<div dir="ltr">Hi,<div><br></div><div>Thanks a lot!</div><div><br></div><div>With best regards, Vitaly.</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">вт, 2 июл. 2019 г. в 04:00, Bo Peng <<a href="mailto:pengbo@sraoss.co.jp">pengbo@sraoss.co.jp</a>>:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hello,<br>
<br>
On Fri, 28 Jun 2019 09:44:56 +0300<br>
Vitaly Voronov <<a href="mailto:wizard1024@gmail.com" target="_blank">wizard1024@gmail.com</a>> wrote:<br>
<br>
> Hi, all.<br>
> <br>
> We uses PostgreSQL JDBC Driver 42.2.6 via pgpool-II version 4.0.5<br>
> (torokiboshi) on CentOS 7 (from pgpool repo -<br>
> pgpool-II-pg11.4.0.5-1pgdg.rhel7) for connecting to PostgreSQL 11 (from<br>
> <a href="http://postgresql.org" rel="noreferrer" target="_blank">postgresql.org</a> repo - postgresql11-server.x86_64.11.3-1PGDG.rhel7).<br>
> <br>
> We see a lot of messages in log file:<br>
> Jun 28 15:31:07 app1 pgpool[12527]: 2019-06-28 15:31:07: pid 15087: LOG:<br>
> checking zapping sent message: 0x1ef8958 query_context: 0x1efc598<br>
> Jun 28 15:31:07 app1 pgpool[12527]: 2019-06-28 15:31:07: pid 15087: LOG:<br>
> checking zapping sent message: 0x1ef8960 query_context: 0x1efe0a8<br>
> Jun 28 15:31:07 app1 pgpool[12527]: 2019-06-28 15:31:07: pid 15087: LOG:<br>
> checking zapping sent message: 0x1ef8968 query_context: 0x1efb588<br>
> Jun 28 15:31:07 app1 pgpool[12527]: 2019-06-28 15:31:07: pid 15087: LOG:<br>
> checking zapping sent message: 0x1ef8970 query_context: 0x1efb588<br>
> Jun 28 15:31:15 app1 pgpool[12527]: 2019-06-28 15:31:15: pid 14888: LOG:<br>
> checking zapping sent message: 0x1ef8958 query_context: 0x1efb588<br>
> Jun 28 15:31:15 app1 pgpool[12527]: 2019-06-28 15:31:15: pid 14888: LOG:<br>
> checking zapping sent message: 0x1ef8960 query_context: 0x1efad78<br>
> Jun 28 15:31:15 app1 pgpool[12527]: 2019-06-28 15:31:15: pid 14888: LOG:<br>
> checking zapping sent message: 0x1ef8968 query_context: 0x1eff668<br>
> Jun 28 15:31:15 app1 pgpool[12527]: 2019-06-28 15:31:15: pid 14888: LOG:<br>
> checking zapping sent message: 0x1ef8970 query_context: 0x1eff668<br>
> Jun 28 15:31:28 app1 pgpool[12527]: 2019-06-28 15:31:28: pid 15090: LOG:<br>
> checking zapping sent message: 0x1ef8958 query_context: 0x1efd898<br>
> Jun 28 15:31:28 app1 pgpool[12527]: 2019-06-28 15:31:28: pid 15090: LOG:<br>
> checking zapping sent message: 0x1ef8960 query_context: 0x1efd898<br>
> <br>
> I've enabled all logging on pgpool, but we couldn't find any dependency<br>
> between executed query and messages in logs.<br>
> <br>
> Can you explain situation, which can cause such messages?<br>
<br>
"checking zapping sent message" is a normal message.<br>
<br>
When Pgpool-II receive CommandComplete message from backend,<br>
the query which is not referenced by others and is unnamed statement/portal,<br>
will be removed from query context.<br>
<br>
Because it is a normal message, we downgraded it from "LOG" to "DEBUG5".<br>
<a href="https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=d86c71d163c7f495e08db9055fa6bdd39e57a1ac" rel="noreferrer" target="_blank">https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=d86c71d163c7f495e08db9055fa6bdd39e57a1ac</a><br>
<br>
> With best regard, Vitaly.<br>
<br>
<br>
-- <br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
SRA OSS, Inc. Japan<br>
<br>
</blockquote></div>