<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">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"><u></u>
<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">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>backend_clustering_mode = 'streaming_replication'<br>
listen_addresses = '*'<br>
port = 9999<br>
unix_socket_directories = '/var/run/postgresql/'<br>
pcp_listen_addresses = 'localhost'<br>
pcp_port = 9898<br>
pcp_socket_dir = '/var/run/postgresql/'<br>
backend_hostname0 = '10.2.20.234'<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>
backend_hostname1 = '10.2.20.233'<br>
backend_port1 = 5432<br>
backend_weight1 = 1<br>
backend_data_directory1 = '/var/lib/pgsql/14/data'<br>
backend_flag1 = 'ALLOW_TO_FAILOVER'<br>
backend_application_name1 = 'standbydb'<br>
enable_pool_hba = off<br>
pool_passwd = ''<br>
authentication_timeout = 1min<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 = 32<br>
min_spare_children = 5<br>
max_spare_children = 10<br>
child_life_time = 5min<br>
log_destination = 'stderr'<br>
log_connections = on<br>
log_disconnections = on<br>
log_hostname = on<br>
log_per_node_statement = on<br>
syslog_facility = 'LOCAL0'<br>
syslog_ident = 'pgpool'<br>
logging_collector = on<br>
log_directory = '/var/log/pgpool_logs'<br>
pid_file_name = '/run/pgpool-II/pgpool.pid'<br>
logdir = '/var/run/postgresql'<br>
load_balance_mode = on<br>
primary_routing_query_pattern_list = 'SAVEPOINT.*;select
GLOBALSYSTEMPARAMETER.paramname.*;BEGIN.*'<br>
sr_check_period = 10<br>
sr_check_user = 'repmgr'<br>
sr_check_password = '******'<br>
sr_check_database = 'postgres'<br>
delay_threshold = 10000000<br>
health_check_user = 'nobody'<br>
health_check_password = '****'<br>
hostname0 = ''</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">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">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</blockquote></div></div>