[pgpool-general: 8990] autosave=always jdbc option & it only sends query SAVEPOINT PGJDBC_AUTOSAVE and hangs
Karel Svec
karel.svec at finshape.com
Wed Dec 27 23:50:19 JST 2023
Hi,
we are facing problem when we use pgpool as proxy our application with
*autosave=always&cleanupSavepoints=true* options in url wont start
properly, it hangs immediately issuing only *SAVEPOINT PGJDBC_AUTOSAVE ,
*there are no errors around, pgpool log is attached.
When the application is connected directly to postgres db (bypassing
pgpool) it works.
My question is, can we use *autosave *connection parameter
https://jdbc.postgresql.org/documentation/use/ with pgpool ?
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.
pgpool settings:
backend_clustering_mode = 'streaming_replication'
listen_addresses = '*'
port = 9999
unix_socket_directories = '/var/run/postgresql/'
pcp_listen_addresses = 'localhost'
pcp_port = 9898
pcp_socket_dir = '/var/run/postgresql/'
backend_hostname0 = '10.2.20.234'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/var/lib/pgsql/14/data'
backend_flag0 = 'ALWAYS_PRIMARY'
backend_application_name0 = 'primarydb'
backend_hostname1 = '10.2.20.233'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/var/lib/pgsql/14/data'
backend_flag1 = 'ALLOW_TO_FAILOVER'
backend_application_name1 = 'standbydb'
enable_pool_hba = off
pool_passwd = ''
authentication_timeout = 1min
allow_clear_text_frontend_auth = on
ssl = on
ssl_key = '/var/lib/pgsql/14/data/server.key'
ssl_cert = '/var/lib/pgsql/14/data/server.crt'
num_init_children = 32
min_spare_children = 5
max_spare_children = 10
child_life_time = 5min
log_destination = 'stderr'
log_connections = on
log_disconnections = on
log_hostname = on
log_per_node_statement = on
syslog_facility = 'LOCAL0'
syslog_ident = 'pgpool'
logging_collector = on
log_directory = '/var/log/pgpool_logs'
pid_file_name = '/run/pgpool-II/pgpool.pid'
logdir = '/var/run/postgresql'
load_balance_mode = on
primary_routing_query_pattern_list = 'SAVEPOINT.*;select
GLOBALSYSTEMPARAMETER.paramname.*;BEGIN.*'
sr_check_period = 10
sr_check_user = 'repmgr'
sr_check_password = '******'
sr_check_database = 'postgres'
delay_threshold = 10000000
health_check_user = 'nobody'
health_check_password = '****'
hostname0 = ''
connection example:
url=jdbc:postgresql://vbdb01-czdc-p.lx.finshape.com:9999/jtb_gen_test?currentSchema=udebs&autosave=always&cleanupSavepoints=true
I will be grateful for any advice
Karel.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20231227/40445660/attachment.htm>
-------------- next part --------------
2023-12-27 12:15:15.340: child pid 1386239: LOG: new connection received
2023-12-27 12:15:15.340: child pid 1386239: DETAIL: connecting host=10.2.20.210 port=25241
2023-12-27 12:15:15.818: child pid 1386239: LOG: using clear text authentication with frontend
2023-12-27 12:15:15.818: child pid 1386239: DETAIL: backend will still use SCRAM auth
2023-12-27 12:15:15.818: child pid 1386239: HINT: you can disable this behavior by setting allow_clear_text_frontend_auth to off
2023-12-27 12:15:15.872: [unknown] pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: SELECT version()
2023-12-27 12:15:15.872: [unknown] pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Parse: SET extra_float_digits = 3
2023-12-27 12:15:15.872: [unknown] pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Bind: SET extra_float_digits = 3
2023-12-27 12:15:15.872: [unknown] pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Execute: SET extra_float_digits = 3
2023-12-27 12:15:15.873: [unknown] pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Parse: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:15.873: [unknown] pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Bind: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:15.873: [unknown] pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:15.925: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Parse:
2023-12-27 12:15:15.926: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Bind:
2023-12-27 12:15:15.926: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: D message
2023-12-27 12:15:15.926: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Execute:
2023-12-27 12:15:15.927: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Parse: SHOW TRANSACTION ISOLATION LEVEL
2023-12-27 12:15:15.927: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Bind: SHOW TRANSACTION ISOLATION LEVEL
2023-12-27 12:15:15.927: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: D message
2023-12-27 12:15:15.927: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Execute: SHOW TRANSACTION ISOLATION LEVEL
2023-12-27 12:15:16.040: child pid 1385088: LOG: new connection received
2023-12-27 12:15:16.040: child pid 1385088: DETAIL: connecting host=10.2.20.210 port=34634
2023-12-27 12:15:16.139: child pid 1385088: LOG: using clear text authentication with frontend
2023-12-27 12:15:16.139: child pid 1385088: DETAIL: backend will still use SCRAM auth
2023-12-27 12:15:16.139: child pid 1385088: HINT: you can disable this behavior by setting allow_clear_text_frontend_auth to off
2023-12-27 12:15:16.212: [unknown] pid 1385088: LOG: DB node id: 0 backend pid: 1615488 statement: SELECT version()
2023-12-27 12:15:16.212: [unknown] pid 1385088: LOG: DB node id: 0 backend pid: 1615488 statement: Parse: SET extra_float_digits = 3
2023-12-27 12:15:16.212: [unknown] pid 1385088: LOG: DB node id: 0 backend pid: 1615488 statement: Bind: SET extra_float_digits = 3
2023-12-27 12:15:16.212: [unknown] pid 1385088: LOG: DB node id: 0 backend pid: 1615488 statement: Execute: SET extra_float_digits = 3
2023-12-27 12:15:16.213: [unknown] pid 1385088: LOG: DB node id: 0 backend pid: 1615488 statement: Parse: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.213: [unknown] pid 1385088: LOG: DB node id: 0 backend pid: 1615488 statement: Bind: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.213: [unknown] pid 1385088: LOG: DB node id: 0 backend pid: 1615488 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.217: child pid 1387270: LOG: new connection received
2023-12-27 12:15:16.217: child pid 1387270: DETAIL: connecting host=10.2.20.210 port=64043
2023-12-27 12:15:16.318: child pid 1387270: LOG: using clear text authentication with frontend
2023-12-27 12:15:16.318: child pid 1387270: DETAIL: backend will still use SCRAM auth
2023-12-27 12:15:16.318: child pid 1387270: HINT: you can disable this behavior by setting allow_clear_text_frontend_auth to off
2023-12-27 12:15:16.407: [unknown] pid 1387270: LOG: DB node id: 0 backend pid: 1615489 statement: SELECT version()
2023-12-27 12:15:16.407: [unknown] pid 1387270: LOG: DB node id: 0 backend pid: 1615489 statement: Parse: SET extra_float_digits = 3
2023-12-27 12:15:16.407: [unknown] pid 1387270: LOG: DB node id: 0 backend pid: 1615489 statement: Bind: SET extra_float_digits = 3
2023-12-27 12:15:16.407: [unknown] pid 1387270: LOG: DB node id: 0 backend pid: 1615489 statement: Execute: SET extra_float_digits = 3
2023-12-27 12:15:16.408: [unknown] pid 1387270: LOG: DB node id: 0 backend pid: 1615489 statement: Parse: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.408: [unknown] pid 1387270: LOG: DB node id: 0 backend pid: 1615489 statement: Bind: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.408: [unknown] pid 1387270: LOG: DB node id: 0 backend pid: 1615489 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.411: child pid 1383982: LOG: new connection received
2023-12-27 12:15:16.411: child pid 1383982: DETAIL: connecting host=10.2.20.210 port=64733
2023-12-27 12:15:16.440: child pid 1383982: LOG: using clear text authentication with frontend
2023-12-27 12:15:16.440: child pid 1383982: DETAIL: backend will still use SCRAM auth
2023-12-27 12:15:16.440: child pid 1383982: HINT: you can disable this behavior by setting allow_clear_text_frontend_auth to off
2023-12-27 12:15:16.507: [unknown] pid 1383982: LOG: DB node id: 0 backend pid: 1615490 statement: SELECT version()
2023-12-27 12:15:16.507: [unknown] pid 1383982: LOG: DB node id: 0 backend pid: 1615490 statement: Parse: SET extra_float_digits = 3
2023-12-27 12:15:16.507: [unknown] pid 1383982: LOG: DB node id: 1 backend pid: 574635 statement: Parse: SET extra_float_digits = 3
2023-12-27 12:15:16.507: [unknown] pid 1383982: LOG: DB node id: 0 backend pid: 1615490 statement: Bind: SET extra_float_digits = 3
2023-12-27 12:15:16.507: [unknown] pid 1383982: LOG: DB node id: 1 backend pid: 574635 statement: Bind: SET extra_float_digits = 3
2023-12-27 12:15:16.507: [unknown] pid 1383982: LOG: DB node id: 0 backend pid: 1615490 statement: Execute: SET extra_float_digits = 3
2023-12-27 12:15:16.507: [unknown] pid 1383982: LOG: DB node id: 1 backend pid: 574635 statement: Execute: SET extra_float_digits = 3
2023-12-27 12:15:16.509: [unknown] pid 1383982: LOG: DB node id: 0 backend pid: 1615490 statement: Parse: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.509: [unknown] pid 1383982: LOG: DB node id: 1 backend pid: 574635 statement: Parse: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.509: [unknown] pid 1383982: LOG: DB node id: 0 backend pid: 1615490 statement: Bind: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.509: [unknown] pid 1383982: LOG: DB node id: 1 backend pid: 574635 statement: Bind: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.509: [unknown] pid 1383982: LOG: DB node id: 0 backend pid: 1615490 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.509: [unknown] pid 1383982: LOG: DB node id: 1 backend pid: 574635 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.512: child pid 1386196: LOG: new connection received
2023-12-27 12:15:16.512: child pid 1386196: DETAIL: connecting host=10.2.20.210 port=57651
2023-12-27 12:15:16.535: child pid 1386196: LOG: using clear text authentication with frontend
2023-12-27 12:15:16.535: child pid 1386196: DETAIL: backend will still use SCRAM auth
2023-12-27 12:15:16.535: child pid 1386196: HINT: you can disable this behavior by setting allow_clear_text_frontend_auth to off
2023-12-27 12:15:16.608: [unknown] pid 1386196: LOG: DB node id: 0 backend pid: 1615491 statement: SELECT version()
2023-12-27 12:15:16.608: [unknown] pid 1386196: LOG: DB node id: 0 backend pid: 1615491 statement: Parse: SET extra_float_digits = 3
2023-12-27 12:15:16.608: [unknown] pid 1386196: LOG: DB node id: 1 backend pid: 574636 statement: Parse: SET extra_float_digits = 3
2023-12-27 12:15:16.608: [unknown] pid 1386196: LOG: DB node id: 0 backend pid: 1615491 statement: Bind: SET extra_float_digits = 3
2023-12-27 12:15:16.608: [unknown] pid 1386196: LOG: DB node id: 1 backend pid: 574636 statement: Bind: SET extra_float_digits = 3
2023-12-27 12:15:16.608: [unknown] pid 1386196: LOG: DB node id: 0 backend pid: 1615491 statement: Execute: SET extra_float_digits = 3
2023-12-27 12:15:16.608: [unknown] pid 1386196: LOG: DB node id: 1 backend pid: 574636 statement: Execute: SET extra_float_digits = 3
2023-12-27 12:15:16.609: [unknown] pid 1386196: LOG: DB node id: 0 backend pid: 1615491 statement: Parse: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.609: [unknown] pid 1386196: LOG: DB node id: 1 backend pid: 574636 statement: Parse: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.609: [unknown] pid 1386196: LOG: DB node id: 0 backend pid: 1615491 statement: Bind: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.609: [unknown] pid 1386196: LOG: DB node id: 1 backend pid: 574636 statement: Bind: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.609: [unknown] pid 1386196: LOG: DB node id: 0 backend pid: 1615491 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.609: [unknown] pid 1386196: LOG: DB node id: 1 backend pid: 574636 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.619: child pid 1386174: LOG: new connection received
2023-12-27 12:15:16.619: child pid 1386174: DETAIL: connecting host=10.2.20.210 port=20365
2023-12-27 12:15:16.643: child pid 1386174: LOG: using clear text authentication with frontend
2023-12-27 12:15:16.643: child pid 1386174: DETAIL: backend will still use SCRAM auth
2023-12-27 12:15:16.643: child pid 1386174: HINT: you can disable this behavior by setting allow_clear_text_frontend_auth to off
2023-12-27 12:15:16.708: [unknown] pid 1386174: LOG: DB node id: 0 backend pid: 1615492 statement: SELECT version()
2023-12-27 12:15:16.708: [unknown] pid 1386174: LOG: DB node id: 0 backend pid: 1615492 statement: Parse: SET extra_float_digits = 3
2023-12-27 12:15:16.708: [unknown] pid 1386174: LOG: DB node id: 0 backend pid: 1615492 statement: Bind: SET extra_float_digits = 3
2023-12-27 12:15:16.708: [unknown] pid 1386174: LOG: DB node id: 0 backend pid: 1615492 statement: Execute: SET extra_float_digits = 3
2023-12-27 12:15:16.709: [unknown] pid 1386174: LOG: DB node id: 0 backend pid: 1615492 statement: Parse: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.709: [unknown] pid 1386174: LOG: DB node id: 0 backend pid: 1615492 statement: Bind: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.709: [unknown] pid 1386174: LOG: DB node id: 0 backend pid: 1615492 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.712: child pid 1384099: LOG: new connection received
2023-12-27 12:15:16.712: child pid 1384099: DETAIL: connecting host=10.2.20.210 port=9674
2023-12-27 12:15:16.737: child pid 1384099: LOG: using clear text authentication with frontend
2023-12-27 12:15:16.737: child pid 1384099: DETAIL: backend will still use SCRAM auth
2023-12-27 12:15:16.737: child pid 1384099: HINT: you can disable this behavior by setting allow_clear_text_frontend_auth to off
2023-12-27 12:15:16.808: [unknown] pid 1384099: LOG: DB node id: 0 backend pid: 1615493 statement: SELECT version()
2023-12-27 12:15:16.808: [unknown] pid 1384099: LOG: DB node id: 0 backend pid: 1615493 statement: Parse: SET extra_float_digits = 3
2023-12-27 12:15:16.808: [unknown] pid 1384099: LOG: DB node id: 0 backend pid: 1615493 statement: Bind: SET extra_float_digits = 3
2023-12-27 12:15:16.808: [unknown] pid 1384099: LOG: DB node id: 0 backend pid: 1615493 statement: Execute: SET extra_float_digits = 3
2023-12-27 12:15:16.809: [unknown] pid 1384099: LOG: DB node id: 0 backend pid: 1615493 statement: Parse: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.809: [unknown] pid 1384099: LOG: DB node id: 0 backend pid: 1615493 statement: Bind: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.809: [unknown] pid 1384099: LOG: DB node id: 0 backend pid: 1615493 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.812: child pid 1388305: LOG: new connection received
2023-12-27 12:15:16.812: child pid 1388305: DETAIL: connecting host=10.2.20.210 port=30289
2023-12-27 12:15:16.834: child pid 1388305: LOG: using clear text authentication with frontend
2023-12-27 12:15:16.834: child pid 1388305: DETAIL: backend will still use SCRAM auth
2023-12-27 12:15:16.834: child pid 1388305: HINT: you can disable this behavior by setting allow_clear_text_frontend_auth to off
2023-12-27 12:15:16.908: [unknown] pid 1388305: LOG: DB node id: 0 backend pid: 1615494 statement: SELECT version()
2023-12-27 12:15:16.908: [unknown] pid 1388305: LOG: DB node id: 0 backend pid: 1615494 statement: Parse: SET extra_float_digits = 3
2023-12-27 12:15:16.908: [unknown] pid 1388305: LOG: DB node id: 1 backend pid: 574639 statement: Parse: SET extra_float_digits = 3
2023-12-27 12:15:16.908: [unknown] pid 1388305: LOG: DB node id: 0 backend pid: 1615494 statement: Bind: SET extra_float_digits = 3
2023-12-27 12:15:16.908: [unknown] pid 1388305: LOG: DB node id: 1 backend pid: 574639 statement: Bind: SET extra_float_digits = 3
2023-12-27 12:15:16.908: [unknown] pid 1388305: LOG: DB node id: 0 backend pid: 1615494 statement: Execute: SET extra_float_digits = 3
2023-12-27 12:15:16.908: [unknown] pid 1388305: LOG: DB node id: 1 backend pid: 574639 statement: Execute: SET extra_float_digits = 3
2023-12-27 12:15:16.910: [unknown] pid 1388305: LOG: DB node id: 0 backend pid: 1615494 statement: Parse: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.910: [unknown] pid 1388305: LOG: DB node id: 1 backend pid: 574639 statement: Parse: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.910: [unknown] pid 1388305: LOG: DB node id: 0 backend pid: 1615494 statement: Bind: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.910: [unknown] pid 1388305: LOG: DB node id: 1 backend pid: 574639 statement: Bind: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.910: [unknown] pid 1388305: LOG: DB node id: 0 backend pid: 1615494 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.910: [unknown] pid 1388305: LOG: DB node id: 1 backend pid: 574639 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:16.913: child pid 1385056: LOG: new connection received
2023-12-27 12:15:16.913: child pid 1385056: DETAIL: connecting host=10.2.20.210 port=30388
2023-12-27 12:15:17.017: child pid 1385056: LOG: using clear text authentication with frontend
2023-12-27 12:15:17.017: child pid 1385056: DETAIL: backend will still use SCRAM auth
2023-12-27 12:15:17.017: child pid 1385056: HINT: you can disable this behavior by setting allow_clear_text_frontend_auth to off
2023-12-27 12:15:17.034: [unknown] pid 1385056: LOG: DB node id: 0 backend pid: 1615495 statement: SELECT version()
2023-12-27 12:15:17.034: [unknown] pid 1385056: LOG: DB node id: 0 backend pid: 1615495 statement: Parse: SET extra_float_digits = 3
2023-12-27 12:15:17.034: [unknown] pid 1385056: LOG: DB node id: 0 backend pid: 1615495 statement: Bind: SET extra_float_digits = 3
2023-12-27 12:15:17.034: [unknown] pid 1385056: LOG: DB node id: 0 backend pid: 1615495 statement: Execute: SET extra_float_digits = 3
2023-12-27 12:15:17.035: [unknown] pid 1385056: LOG: DB node id: 0 backend pid: 1615495 statement: Parse: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:17.035: [unknown] pid 1385056: LOG: DB node id: 0 backend pid: 1615495 statement: Bind: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:17.035: [unknown] pid 1385056: LOG: DB node id: 0 backend pid: 1615495 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:17.039: child pid 1385174: LOG: new connection received
2023-12-27 12:15:17.039: child pid 1385174: DETAIL: connecting host=10.2.20.210 port=23032
2023-12-27 12:15:17.131: child pid 1385174: LOG: using clear text authentication with frontend
2023-12-27 12:15:17.131: child pid 1385174: DETAIL: backend will still use SCRAM auth
2023-12-27 12:15:17.131: child pid 1385174: HINT: you can disable this behavior by setting allow_clear_text_frontend_auth to off
2023-12-27 12:15:17.208: [unknown] pid 1385174: LOG: DB node id: 0 backend pid: 1615496 statement: SELECT version()
2023-12-27 12:15:17.208: [unknown] pid 1385174: LOG: DB node id: 0 backend pid: 1615496 statement: Parse: SET extra_float_digits = 3
2023-12-27 12:15:17.208: [unknown] pid 1385174: LOG: DB node id: 0 backend pid: 1615496 statement: Bind: SET extra_float_digits = 3
2023-12-27 12:15:17.208: [unknown] pid 1385174: LOG: DB node id: 0 backend pid: 1615496 statement: Execute: SET extra_float_digits = 3
2023-12-27 12:15:17.209: [unknown] pid 1385174: LOG: DB node id: 0 backend pid: 1615496 statement: Parse: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:17.209: [unknown] pid 1385174: LOG: DB node id: 0 backend pid: 1615496 statement: Bind: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:17.209: [unknown] pid 1385174: LOG: DB node id: 0 backend pid: 1615496 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
2023-12-27 12:15:17.726: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Parse:
2023-12-27 12:15:17.726: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Bind:
2023-12-27 12:15:17.726: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: D message
2023-12-27 12:15:17.726: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Execute:
2023-12-27 12:15:27.420: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Parse:
2023-12-27 12:15:27.421: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Bind:
2023-12-27 12:15:27.421: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: D message
2023-12-27 12:15:27.421: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Execute:
2023-12-27 12:15:27.640: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Parse: BEGIN READ ONLY
2023-12-27 12:15:27.640: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Bind: BEGIN READ ONLY
2023-12-27 12:15:27.640: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: Execute: BEGIN READ ONLY
2023-12-27 12:15:27.640: PostgreSQL JDBC Driver pid 1386239: LOG: DB node id: 0 backend pid: 1615487 statement: SAVEPOINT PGJDBC_AUTOSAVE
More information about the pgpool-general
mailing list