<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Good Day Tatsuo<br>
</p>
<div class="moz-cite-prefix">On 6/5/25 02:17, Tatsuo Ishii wrote:<br>
</div>
<blockquote type="cite"
cite="mid:20250506.081757.205934300721431836.ishii@postgresql.org">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="" class="moz-quote-pre">On 5/4/25 05:55, Achilleas Mantzios wrote:
</pre>
<blockquote type="cite">
<pre wrap="" class="moz-quote-pre">On 4/5/25 06:42, Tatsuo Ishii wrote:
</pre>
<blockquote type="cite">
<pre wrap="" class="moz-quote-pre">Achilleas,
Please disregard the patch. I think I have an oeversight with the
patch.
</pre>
</blockquote>
<pre wrap="" class="moz-quote-pre">
Good Day Tatsuo. Thank you for all your work!
I will wait !
</pre>
</blockquote>
<pre wrap="" class="moz-quote-pre">
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@<a class="moz-txt-link-freetext" href="smadevnu:~/workspace/pgpoolbugII/bin">smadevnu:~/workspace/pgpoolbugII/bin</a> % ls
test
achill@<a class="moz-txt-link-freetext" href="smadevnu:~/workspace/pgpoolbugII/bin">smadevnu:~/workspace/pgpoolbugII/bin</a> % ls test/
PgPoolTestII.class
achill@<a class="moz-txt-link-freetext" href="smadevnu:~/workspace/pgpoolbugII/bin">smadevnu:~/workspace/pgpoolbugII/bin</a> %
run
java -cp ":/home/achill/SQL/postgresql-42.7.5.jar" test.PgPoolTestII
localhost 9999 dynacom username passwd
</pre>
</blockquote>
<pre wrap="" class="moz-quote-pre">
Great! I will give it a try.
</pre>
</blockquote>
<pre wrap="" class="moz-quote-pre">
Unfortunately the java program needs functions I don't have.
PreparedStatement stidxINS = con.prepareStatement("insert into testarr(parents,descr) VALUES((SELECT intarray_push_array(itoar(?),coalesce((select parents from testarr where id=?),'{}'::integer[]))),?)");
It seems it requires itoar() and intarray_push_array(), which I don't have.</pre>
</blockquote>
itoar is our own, sorry, <span style="white-space: pre-wrap">intarray_push_array</span>
comes from the intarray contrib, I just wanted to make it look like
the original as much as I could, here is a version that doesn't use
any of those. So please try that.<br>
<blockquote type="cite"
cite="mid:20250506.081757.205934300721431836.ishii@postgresql.org">
<pre wrap="" class="moz-quote-pre">
Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: <a class="moz-txt-link-freetext" href="http://www.sraoss.co.jp/index_en/">http://www.sraoss.co.jp/index_en/</a>
<a class="moz-txt-link-freetext" href="Japanese:http://www.sraoss.co.jp">Japanese:http://www.sraoss.co.jp</a>
</pre>
</blockquote>
</body>
</html>