[pgpool-general: 9466] Re: Clarification on query results cache visibility

[Tatsuo Ishii]

> On 5/4/25 05:55, Achilleas Mantzios wrote:
> 
>> On 4/5/25 06:42, Tatsuo Ishii wrote:
>>
>>> Achilleas,
>>>
>>> Please disregard the patch. I think I have an oeversight with the
>>> patch.
>>
>> Good Day Tatsuo. Thank you for all your work!
>>
>> I will wait !
> 
> Dear Tatsuo ,
> 
> I happy to say to you that I finally came up with a valid test that
> reproduces the 2nd bug (with the INSERT and the BIND), so I have this
> java program, which will fail exactly after "preparedThreshold"
> iterations!
> 
> This is supposed to be run against the 4.6.0 version with the
> query_cache-v2.patch applied.
> 
> the table looks like :
> 
> CREATE TABLE testarr(id bigserial primary key, parents int[], descr
> text);
> postgres@[local]/dynacom=# \d testarr
>                              Table "public.testarr"
> Column  |   Type    | Collation | Nullable |               Default
> ---------+-----------+-----------+----------+-------------------------------------
> 
> id      | bigint    |           | not null |
> nextval('testarr_id_seq'::regclass)
> parents | integer[] |           |          |
> descr   | text      |           |          |
> Indexes:
>    "testarr_pkey" PRIMARY KEY, btree (id)
> 
> postgres@[local]/dynacom=#
> 
> As with with the first program pls put the class inside a dir called
> "test", then from the parent :
> 
> achill at smadevnu:~/workspace/pgpoolbugII/bin % ls
> test
> achill at smadevnu:~/workspace/pgpoolbugII/bin % ls test/
> PgPoolTestII.class
> achill at smadevnu:~/workspace/pgpoolbugII/bin %
> 
> run
> 
> java -cp ":/home/achill/SQL/postgresql-42.7.5.jar" test.PgPoolTestII
> localhost 9999 dynacom username passwd

Great! I will give it a try.

Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp