<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>On 4/30/25 10:49, Achilleas Mantzios - cloud wrote:</p>
<blockquote type="cite"
cite="mid:dde9f89b-651a-42d5-a5f8-183e7a09265f@cloud.gatewaynet.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<p><br>
</p>
<div class="moz-cite-prefix">On 4/30/25 09:40, Achilleas Mantzios
- cloud wrote:<br>
</div>
<blockquote type="cite"
cite="mid:cca37a60-c11f-46ed-9e1f-2f783a042017@cloud.gatewaynet.com">
<meta http-equiv="Content-Type"
content="text/html; charset=UTF-8">
<p><br>
</p>
<div class="moz-cite-prefix">On 4/30/25 08:12, Achilleas
Mantzios - cloud wrote:<br>
</div>
<blockquote type="cite"
cite="mid:18b14455-23ff-4de8-82d6-8d0c94e56fe1@cloud.gatewaynet.com">On
4/30/25 07:48, Tatsuo Ishii wrote: <br>
<br>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">Thank you a lot for such a quick
response ! I applied, and re-run the <br>
test, it works correctly. <br>
<br>
We will keep testing as in live conditions, with
wildfly , etc. <br>
</blockquote>
</blockquote>
</blockquote>
I have updated the patch. In the previous patch, information
on <br>
whether the query is "cache safe", which means it is safe to
cache the <br>
result of the query, is checked on the global state.
Attached patch <br>
instead checks it directly on the information contained in
the bind <br>
message data, which is an argument of the function
responsible for <br>
processing execute messages. In most cases the global state
is synced <br>
with the bind state, but obtaining information from the bind
message <br>
is safer. <br>
</blockquote>
<br>
Ok, I applied and restarted, thank you! <br>
<br>
Now the cache seems very robust, and fast. <br>
</blockquote>
<p>Unfortunately the 2nd patch (<span
style="font-family:monospace"><span
style="color:#000000;background-color:#ffffff;">query_cache-v2.patch</span></span>)
broke something. Cannot figure yet.</p>
<p>Reverting to the previous patch (yesterday) : <span
style="font-family:monospace"><span
style="color:#000000;background-color:#ffffff;">query_cache.patch</span>
</span>Rev, seems to work correctly.</p>
<p>The scenario involved arrays (pgsql int[] ). (and intarray
extension). I dont know if I am able to do anything (debug)
today, due to immense work load.<br>
</p>
</blockquote>
update the bug is in there no matter the patch's version, will
keep testing.<br>
</blockquote>
<p>update : the bug (this new bug) is not present prior to the first
patch. So the bug (the new one) is not present in plain vanilla :
<span style="font-family:monospace"><span
style="color:#000000;background-color:#ffffff;">pgpool-II-4.6.0</span>
</span>. Reverting both patches solves the issue with the new bug
which has most probably to do with an array function called
"first" : <br>
</p>
<p><span style="font-family:monospace"><span
style="color:#000000;background-color:#ffffff;">select defid,
description from machdefs where first(parents)=214766150 order
by description;</span><br>
</span></p>
<p>I haven't been able to reproduce with SQL (from psql).</p>
<p>Also reverting both patches, i.e. going back to plain vanilla <span
style="font-family:monospace"><span
style="color:#000000;background-color:#ffffff;">pgpool-II-4.6.0</span></span>
solves this new bug, but re-introduces the previous ( with seeing
stale and data and not invalidate data on table <span
style="font-family:monospace"><span
style="color:#000000;background-color:#ffffff;">testpgpool</span></span>)</p>
<blockquote type="cite"
cite="mid:dde9f89b-651a-42d5-a5f8-183e7a09265f@cloud.gatewaynet.com">
<blockquote type="cite"
cite="mid:cca37a60-c11f-46ed-9e1f-2f783a042017@cloud.gatewaynet.com">
<p> </p>
<blockquote type="cite"
cite="mid:18b14455-23ff-4de8-82d6-8d0c94e56fe1@cloud.gatewaynet.com"><br>
<blockquote type="cite"> <br>
Best regards, <br>
-- <br>
Tatsuo Ishii <br>
SRA OSS K.K. <br>
English: <a class="moz-txt-link-freetext"
href="http://www.sraoss.co.jp/index_en/"
moz-do-not-send="true">http://www.sraoss.co.jp/index_en/</a>
<br>
Japanese:<a class="moz-txt-link-freetext"
href="http://www.sraoss.co.jp" moz-do-not-send="true">http://www.sraoss.co.jp</a>
<br>
</blockquote>
_______________________________________________ <br>
pgpool-general mailing list <br>
<a class="moz-txt-link-abbreviated moz-txt-link-freetext"
href="mailto:pgpool-general@pgpool.net"
moz-do-not-send="true">pgpool-general@pgpool.net</a> <br>
<a class="moz-txt-link-freetext"
href="http://www.pgpool.net/mailman/listinfo/pgpool-general"
moz-do-not-send="true">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
<br>
</blockquote>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre wrap="" class="moz-quote-pre">_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated moz-txt-link-freetext"
href="mailto:pgpool-general@pgpool.net" moz-do-not-send="true">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext"
href="http://www.pgpool.net/mailman/listinfo/pgpool-general"
moz-do-not-send="true">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</blockquote>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre wrap="" class="moz-quote-pre">_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</blockquote>
</body>
</html>