<!DOCTYPE html><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<p>Hi,</p>
<p>version: pgpool-II-4.4.2-1.rhel8.x86_64</p>
<p>log file attached, there is pid 3996197 that is affected by the
autosave issue, in database are connections reported as idle in
transaction and waiting on client. This testing environment has
just primary database configured.</p>
<p>Our development team has decided to get rid of autosave for
future releases, but I still have the current version, so I can
test your recommendations if you can provide any.</p>
<p>Thanks, <br>
</p>
<p>Karel.</p>
<p><br>
</p>
<p>requested setting:</p>
<p># egrep 'primary_routing_query_pattern_list|log_client_messages'
pgpool.conf</p>
<p>log_client_messages = on<br>
#primary_routing_query_pattern_list = ''<br>
</p>
<p><br>
</p>
<p># grep ^[a-z] pgpool.conf<br>
backend_clustering_mode = 'streaming_replication'<br>
listen_addresses = '*'<br>
port = 9999<br>
unix_socket_directories = '/run/pgpool-II,/var/run/postgresql/'<br>
pc_listen_addresses = 'localhost'<br>
backend_hostname0 = '10.2.20.105'<br>
backend_port0 = 5432<br>
backend_weight0 = 1<br>
backend_data_directory0 = '/var/lib/pgsql/14/data'<br>
backend_flag0 = 'ALWAYS_PRIMARY'<br>
backend_application_name0 = 'primarydb'<br>
allow_clear_text_frontend_auth = on<br>
ssl = on<br>
ssl_key = '/var/lib/pgsql/14/data/server.key'<br>
ssl_cert = '/var/lib/pgsql/14/data/server.crt'<br>
num_init_children = 800<br>
log_destination = 'stderr'<br>
log_connections = on<br>
log_disconnections = off<br>
log_statement = on<br>
log_client_messages = on<br>
syslog_facility = 'LOCAL0'<br>
syslog_ident = 'pgpool'<br>
client_min_messages = log # values in order of
decreasing detail:<br>
log_min_messages = info # values in order of
decreasing detail:<br>
logging_collector = on<br>
log_directory = '/var/log/pgpool_logs'<br>
pid_file_name = '/run/pgpool-II/pgpool.pid'<br>
sr_check_user = 'nobody'<br>
sr_check_password = 'b'<br>
health_check_user = 'nobody'<br>
health_check_password = 'b'<br>
hostname0 = ''<br>
wd_lifecheck_user = 'nobody'<br>
wd_lifecheck_password = 'b'<br>
<br>
</p>
<p></p>
<div class="moz-cite-prefix">On 1/11/24 10:01, Bo Peng wrote:<br>
</div>
<blockquote type="cite" cite="mid:CAHRdu86U86WuwM4fd1S9OVBgzdvmvDEz=ko9Lm1gGt=g67RhNA@mail.gmail.com">
<div dir="ltr">
<div>Hi,</div>
<div><br>
</div>
<div>
<span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">Does the same issue occur if you
set primary_routing_query_pattern_list = ''?</span></span></span>
<br>
</div>
<div><br>
</div>
<div>Could you set log_client_messages = on and share the logs?</div>
<div>Which version are you using?<br>
</div>
<div><br>
</div>
<div>Best regards,</div>
<div><br>
</div>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">2023年12月27日(水) 23:50 Karel
Svec <<a href="mailto:karel.svec@finshape.com" moz-do-not-send="true" class="moz-txt-link-freetext">karel.svec@finshape.com</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">
<div>
<p>Hi,</p>
<p>we are facing problem when we use pgpool as proxy our
application with <b><font color="#000000">autosave=always&cleanupSavepoints=true</font></b>
options in url wont start properly, it hangs immediately
issuing only <b>SAVEPOINT PGJDBC_AUTOSAVE , </b>there
are no errors around, pgpool log is attached.<br>
</p>
<p>When the application is connected directly to postgres
db (bypassing pgpool) it works.</p>
<p>My question is, can we use <b><font color="#000000">autosave
</font></b>connection parameter <a href="https://jdbc.postgresql.org/documentation/use/" target="_blank" moz-do-not-send="true" class="moz-txt-link-freetext">https://jdbc.postgresql.org/documentation/use/</a>
with pgpool ? <br>
</p>
<p>I suppose savepoint makes sense only on primary db so I
tried to route such query to primary but nothing
changed, it hangs as well.<br>
</p>
<p>pgpool settings:<br>
</p>
<p>...<br>
</p>
<p><br>
</p>
<p>connection example: <font color="#000000">url=jdbc:postgresql://<a href="http://vbdb01-czdc-p.lx.finshape.com:9999/jtb_gen_test?currentSchema=udebs&autosave=always&cleanupSavepoints=true" target="_blank" moz-do-not-send="true">vbdb01-czdc-p.lx.finshape.com:9999/jtb_gen_test?currentSchema=udebs&autosave=always&cleanupSavepoints=true</a></font></p>
<p><br>
</p>
<p>I will be grateful for any advice</p>
<p>Karel.<br>
</p>
</div>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank" moz-do-not-send="true" class="moz-txt-link-freetext">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank" moz-do-not-send="true" class="moz-txt-link-freetext">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</blockquote>
</div>
</div>
</blockquote>
</body>
</html>