<div dir="ltr"><div dir="ltr">I revalidated everything and now the connection is established successfully to the DB via pgpool, but falling with the actual error. I have tried using <span style="color:rgb(80,0,80)">remote_apply, still seeing the same error.</span><div><font color="#500050"><br></font><div>Error in Virtual User 1: Error: Connection to database failed<br>connection to server at "10.35.8.30", port 9999 failed: ERROR: unable to read message kind<br>DETAIL: kind does not match between main(53) slot[1] (45)<span style="color:rgb(80,0,80)"></span></div></div><div><br></div><div>here are my parameters</div><div><br></div><div><br></div><div><u><b>pgpool.conf</b></u></div><div>listen_addresses = '*'<br>port = 9999<br>pcp_listen_addresses = '*'<br>backend_hostname0 = '10.35.8.30'<br>backend_port0 = 5432<br>backend_weight0 = 1<br>backend_hostname1 = '10.35.8.31'<br>backend_port1 = 5432<br>backend_weight1 = 1<br>load_balance_mode = 'on'<br>master_slave_mode = 'on'<br>master_slave_sub_mode = 'stream'<br>sr_check_period = 10<br>sr_check_user = 'monitor'<br>sr_check_password = 'Monitor@321'<br>sr_check_database = 'monitor'<br>delay_threshold = 10240<br>allow_clear_text_frontend_auth = 'on'<br>pid_file_name = '/u01/app/admin/Postgresql/pgpool/pgpool.pid' # pgpool pid location<br>logging_collector = on<br>log_directory = '/u01/app/admin/Data//PG_LOGS' #pgpool log location<br>log_filename = 'pgpool.log'<br>num_init_children = 30<br>enable_pool_hba = on<br>pool_passwd = '/usr/local/etc/pool_passwd'<br>health_check_period = 30<br>health_check_timeout = 20<br>health_check_user = 'pgbigboss'<br>health_check_password = ''<br>health_check_database = 'postgres'<br>health_check_max_retries = 3<br>health_check_retry_delay = 1<br>connect_timeout = 10000<br>statement_level_load_balance = on<br>use_watchdog = on<br>delegate_ip = '10.35.8.4'<br>if_up_cmd = '/usr/bin/sudo /sbin/ip addr add $_IP_$/21 dev eth0 label eth0:1'<br>if_down_cmd = '/usr/bin/sudo /sbin/ip addr del $_IP_$/21 dev eth0'</div><div>arping_cmd = '/usr/bin/sudo /usr/sbin/arping -U $_IP_$ -w 1 -I eth0'<br><br><br>hostname0 = '10.35.8.30'<br>wd_port0 = 9000<br>pgpool_port0 = 9999<br><br>hostname1 = '10.35.8.31'<br>wd_port1 = 9000<br>pgpool_port1 = 9999<br><br>heartbeat_hostname0 = '10.35.8.30'<br>heartbeat_port0 = 9694<br>heartbeat_device0 = ''<br><br>heartbeat_hostname1 = '10.35.8.31'<br>heartbeat_port1 = 9694<br>heartbeat_device1 = ''<br><br>wd_heartbeat_keepalive = 2<br>wd_heartbeat_deadtime = 30<br>#trusted_servers = ''<br>trusted_server_command = 'ping -q -c3 3 %h'<br>backend_clustering_mode = 'streaming_replication'<br>enable_consensus_with_half_votes = on<br>failover_require_consensus = on<br>failover_when_quorum_exists = on<br>log_min_messages = DEBUG5<br>log_per_node_statement = on<br>log_hostname = on<br>log_connections = on<br>log_error_verbosity = VERBOSE</div><div><br></div><div><br></div><div><b><u>postgresql.conf</u></b></div><div>listen_addresses = '*'<br>port = 5432<br>superuser_reserved_connections = 3 # (change requires restart)<br>dynamic_shared_memory_type = posix # the default is usually the first option<br>min_dynamic_shared_memory = 500MB # (change requires restart)<br>wal_level = replica <br>synchronous_commit = remote_apply <br>wal_log_hints = on <br>max_replication_slots = 10 <br>wal_keep_size = 2048 # in megabytes; 0 disables<br>hot_standby = on <br>log_destination = 'stderr' # Valid values are combinations of<br>logging_collector = on # Enable capturing of stderr, jsonlog,<br>log_directory = '/u01/app/admin/Data/PG_LOGS/' # directory where log files are written,<br>log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern,<br>log_file_mode = 0600 # creation mode for log files,<br>log_rotation_age = 7d # Automatic rotation of logfiles will<br>log_timezone = 'Etc/UTC'<br>autovacuum = on # Enable autovacuum subprocess? 'on'<br>autovacuum_max_workers = 3 # max number of autovacuum subprocesses<br>idle_in_transaction_session_timeout = 60000 # in milliseconds, 0 is disabled<br>idle_session_timeout = 300000 # in milliseconds, 0 is disabled<br>datestyle = 'iso, mdy'<br>timezone = 'Etc/UTC'<br>lc_messages = 'en_US.UTF-8' # locale for system error message<br>lc_monetary = 'en_US.UTF-8' # locale for monetary formatting<br>lc_numeric = 'en_US.UTF-8' # locale for number formatting<br>lc_time = 'en_US.UTF-8' # locale for time formatting<br>default_text_search_config = 'pg_catalog.english'<br>max_connections = 40 <br>shared_buffers = 2GB<br>effective_cache_size = 6GB<br>maintenance_work_mem = 512MB<br>checkpoint_completion_target = 0.9<br>wal_buffers = 16MB<br>default_statistics_target = 100<br>random_page_cost = 4<br>effective_io_concurrency = 2<br>work_mem = 51MB<br>min_wal_size = 2GB<br>max_wal_size = 8GB<br>max_worker_processes = 2<br>max_parallel_workers_per_gather = 2<br>max_parallel_workers = 2<br>max_parallel_maintenance_workers = 2<br>shared_preload_libraries = 'pg_stat_statements,repmgr'<br>pg_stat_statements.track = all<br>pg_stat_statements.max = 10000<br>track_io_timing = on<b><u></u></b></div><div><br></div><div><br></div><div><br></div><div><u><b>pgpool.log</b></u></div><div>2024-12-25 03:20:40.968: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: DEBUG: processing ReadyForQuery<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: DETAIL: transaction state of node 0 'I'(49)<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:2223<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: DEBUG: pool_write: to frontend: kind:Z po:0<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: LOCATION: pool_stream.c:478<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: DEBUG: pool_write: to frontend: length:4 po:1<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: LOCATION: pool_stream.c:481<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: DEBUG: pool_write: to frontend: kind:I po:5<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: LOCATION: pool_stream.c:478<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: DEBUG: pool_flush_it: flush size: 6<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: LOCATION: pool_stream.c:650<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: DEBUG: session context: unsetting query in progress. DONE<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: LOCATION: pool_session_context.c:267<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: DEBUG: pool_query_context_destroy: query context:0x84e448 query: "CREATE DATABASE "tpcc" OWNER "tpcc""<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: LOCATION: pool_query_context.c:109<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: DEBUG: session context: unsetting query in progress. DONE<br>2024-12-25 03:20:40.968: [unknown] pid 2485248: LOCATION: pool_session_context.c:267<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: processing frontend response<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DETAIL: received kind 'Q'(51) from frontend<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:2732<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: session context: clearing doing extended query messaging. DONE<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_session_context.c:341<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: invoking the standard parser<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: parser.c:101<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: session context: setting query in progress. DONE<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_session_context.c:253<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: Pgversion: local cache returned<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_pg_utils.c:707<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: decide where to send the query<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DETAIL: destination = 3 for query= "commit"<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_query_context.c:1975<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOG: DB node id: 0 backend pid: 2486391 statement: commit<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:3674<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: pool_write: to backend: 0 kind:Q<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_stream.c:467<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: pool_flush_it: flush size: 12<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_stream.c:650<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: waiting for query response<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DETAIL: waiting for backend:0 to complete the query<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_process_query.c:539<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: pool_read: read 18 bytes from backend 0<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_stream.c:199<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.970: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: reading backend data packet kind<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DETAIL: main node id: 0<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_process_query.c:3364<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: reading backend data packet kind<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DETAIL: backend:0 kind:'C'<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_process_query.c:3426<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: reading backend data packet kind<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DETAIL: backend:0 of 2 kind = 'C'<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_process_query.c:3491<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: read_kind_from_backend max_count:1.000000 num_executed_nodes:1<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_process_query.c:3507<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: processing backend response<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DETAIL: received kind 'C'(43) from backend<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:3008<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_write: to frontend: kind:C po:0<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_stream.c:478<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_write: to frontend: length:4 po:1<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_stream.c:481<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_write: to frontend: length:7 po:5<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_stream.c:481<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_flush_it: flush size: 12<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_stream.c:650<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: session context: setting command success. DONE<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_session_context.c:930<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: reading backend data packet kind<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DETAIL: main node id: 0<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_process_query.c:3364<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: reading backend data packet kind<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DETAIL: backend:0 kind:'Z'<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_process_query.c:3426<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: reading backend data packet kind<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DETAIL: backend:0 of 2 kind = 'Z'<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_process_query.c:3491<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: read_kind_from_backend max_count:1.000000 num_executed_nodes:1<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_process_query.c:3507<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: processing backend response<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DETAIL: received kind 'Z'(5a) from backend<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:3008<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: processing backend response<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DETAIL: Ready For Query received<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:3026<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: session context: clearing ignore till sync. DONE<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_session_context.c:374<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: reading message length<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DETAIL: slot: 0 length: 5<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:4486<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: processing ReadyForQuery<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DETAIL: transaction state of node 0 'I'(49)<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:2223<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_write: to frontend: kind:Z po:0<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_stream.c:478<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_write: to frontend: length:4 po:1<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_stream.c:481<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_write: to frontend: kind:I po:5<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_stream.c:478<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_flush_it: flush size: 6<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_stream.c:650<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: session context: clearing writing transaction. DONE<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_session_context.c:736<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: session context: clearing failed transaction. DONE<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_session_context.c:774<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: session context: clearing failed transaction. DONE<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_session_context.c:807<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: session context: unsetting query in progress. DONE<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_session_context.c:267<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: pool_query_context_destroy: query context:0x84e448 query: "commit"<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_query_context.c:109<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: DEBUG: session context: unsetting query in progress. DONE<br>2024-12-25 03:20:40.971: [unknown] pid 2485248: LOCATION: pool_session_context.c:267<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: processing frontend response<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DETAIL: received kind 'X'(58) from frontend<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:2732<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: session context: clearing doing extended query messaging. DONE<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_session_context.c:341<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: Frontend terminated<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DETAIL: received message kind 'X' from frontend<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:2808<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: session context: clearing doing extended query messaging. DONE<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_session_context.c:341<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: session context: unsetting query in progress. DONE<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_session_context.c:267<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: session context: clearing doing extended query messaging. DONE<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_session_context.c:341<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: session context: unsetting query in progress. DONE<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_session_context.c:267<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: session context: unsetting query in progress. DONE<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_session_context.c:267<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: invoking the standard parser<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: parser.c:101<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: session context: setting query in progress. DONE<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_session_context.c:253<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: Pgversion: local cache returned<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_pg_utils.c:707<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: decide where to send the query<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DETAIL: destination = 3 for query= "DISCARD ALL"<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_query_context.c:1975<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOG: DB node id: 0 backend pid: 2486391 statement: DISCARD ALL<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:3674<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: pool_write: to backend: 0 kind:Q<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_stream.c:467<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: pool_flush_it: flush size: 17<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_stream.c:650<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: waiting for query response<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DETAIL: waiting for backend:0 to complete the query<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_process_query.c:539<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: pool_read: read 23 bytes from backend 0<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_stream.c:199<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: extract_message: kind: C<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_process_query.c:4489<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: extract_message: kind: C<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_process_query.c:4489<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: extract_message: kind: C<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_process_query.c:4489<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: extract_message: kind: C<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_process_query.c:4489<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOG: DB node id: 1 backend pid: 2277851 statement: DISCARD ALL<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:3674<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: pool_write: to backend: 1 kind:Q<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_stream.c:467<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: pool_flush_it: flush size: 17<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_stream.c:650<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DEBUG: waiting for query response<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: DETAIL: waiting for backend:1 to complete the query<br>2024-12-25 03:20:40.973: [unknown] pid 2485248: LOCATION: pool_process_query.c:539<br>2024-12-25 03:20:40.974: [unknown] pid 2485248: DEBUG: pool_read: read 23 bytes from backend 1<br>2024-12-25 03:20:40.974: [unknown] pid 2485248: LOCATION: pool_stream.c:199<br>2024-12-25 03:20:40.974: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.974: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.974: [unknown] pid 2485248: DEBUG: reading backend data packet kind<br>2024-12-25 03:20:40.974: [unknown] pid 2485248: DETAIL: main node id: 0<br>2024-12-25 03:20:40.974: [unknown] pid 2485248: LOCATION: pool_process_query.c:3364<br>2024-12-25 03:20:40.974: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: reading backend data packet kind<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DETAIL: backend:0 kind:'C'<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_process_query.c:3426<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: reading backend data packet kind<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DETAIL: backend:0 of 2 kind = 'C'<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_process_query.c:3491<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: reading backend data packet kind<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DETAIL: backend:1 kind:'C'<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_process_query.c:3426<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: reading backend data packet kind<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DETAIL: backend:1 of 2 kind = 'C'<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_process_query.c:3491<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: read_kind_from_backend max_count:2.000000 num_executed_nodes:2<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_process_query.c:3507<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: processing backend response<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DETAIL: received kind 'C'(43) from backend<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:3008<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: pool_flush_it: flush size: 0<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_stream.c:650<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: session context: setting command success. DONE<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_session_context.c:930<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: reading backend data packet kind<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DETAIL: main node id: 0<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_process_query.c:3364<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: reading backend data packet kind<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DETAIL: backend:0 kind:'Z'<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_process_query.c:3426<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: reading backend data packet kind<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DETAIL: backend:0 of 2 kind = 'Z'<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_process_query.c:3491<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: reading backend data packet kind<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DETAIL: backend:1 kind:'Z'<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_process_query.c:3426<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: reading backend data packet kind<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DETAIL: backend:1 of 2 kind = 'Z'<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_process_query.c:3491<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: read_kind_from_backend max_count:2.000000 num_executed_nodes:2<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_process_query.c:3507<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: processing backend response<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DETAIL: received kind 'Z'(5a) from backend<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:3008<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: processing backend response<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DETAIL: Ready For Query received<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:3026<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: session context: clearing ignore till sync. DONE<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_session_context.c:374<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: reading message length<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DETAIL: slot: 0 length: 5<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:4486<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: pool_virtual_main_db_node_id: virtual_main_node_id:0 load_balance_node_id:0 PRIMARY_NODE_ID:0<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_query_context.c:403<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: reading message length<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DETAIL: slot: 1 length: 5<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:4500<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: processing ReadyForQuery<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DETAIL: transaction state of node 0 'I'(49)<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:2223<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: processing ReadyForQuery<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DETAIL: transaction state of node 1 'I'(49)<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_proto_modules.c:2223<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: pool_flush_it: flush size: 0<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_stream.c:650<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: session context: unsetting query in progress. DONE<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_session_context.c:267<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: pool_query_context_destroy: query context:0x84e448 query: "DISCARD ALL"<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_query_context.c:109<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: session context: unsetting query in progress. DONE<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_session_context.c:267<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: DEBUG: session context: clearing doing extended query messaging. DONE<br>2024-12-25 03:20:40.975: [unknown] pid 2485248: LOCATION: pool_session_context.c:341<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: DEBUG: session context: unsetting query in progress. DONE<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: LOCATION: pool_session_context.c:267<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: DEBUG: setting backend connection close timer<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: DETAIL: close time 1735096840<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: LOCATION: pool_connection_pool.c:354<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: DEBUG: session context: unsetting query in progress. DONE<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: LOCATION: pool_session_context.c:267<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: DEBUG: pool_write: to backend: 0 kind:X<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: LOCATION: pool_stream.c:467<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: DEBUG: pool_flush_it: flush size: 5<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: LOCATION: pool_stream.c:650<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: DEBUG: pool_write: to backend: 1 kind:X<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: LOCATION: pool_stream.c:467<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: DEBUG: pool_flush_it: flush size: 5<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: LOCATION: pool_stream.c:650<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: DEBUG: RESET ALL CONFIG VARIABLES<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: LOCATION: pool_config_variables.c:5918<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: DEBUG: connection_count_down: number of connected children: 2<br>2024-12-25 03:20:40.976: [unknown] pid 2485248: LOCATION: child.c:1427<br>2024-12-25 03:20:40.976: child pid 2485255: DEBUG: set_config_option "log_per_node_statement" = "on"<br>2024-12-25 03:20:40.976: child pid 2485255: DEBUG: set_config_option "log_hostname" = "on"<br>2024-12-25 03:20:40.976: child pid 2485255: DEBUG: set_config_option "log_connections" = "on"<br>2024-12-25 03:20:40.976: child pid 2485255: DEBUG: set_config_option "log_error_verbosity" = "VERBOSE"<br>2024-12-25 03:20:40.976: child pid 2485255: DEBUG: read pgpool node id file /usr/local/etc/pgpool_node_id<br>2024-12-25 03:20:40.976: child pid 2485255: DETAIL: pgpool node id: 0<br>2024-12-25 03:20:40.976: child pid 2485255: LOCATION: pool_config_variables.c:5273<br>2024-12-25 03:20:40.976: child pid 2485255: DEBUG: initializing pool configuration<br>2024-12-25 03:20:40.976: child pid 2485255: DETAIL: num_backends: 2 total_weight: 2.000000<br>2024-12-25 03:20:40.976: child pid 2485255: LOCATION: pool_config_variables.c:4879<br>2024-12-25 03:20:40.976: child pid 2485255: DEBUG: initializing pool configuration<br>2024-12-25 03:20:40.976: child pid 2485255: DETAIL: backend 0 weight: 1073741823.500000 flag: 0000<br>2024-12-25 03:20:40.976: child pid 2485255: LOCATION: pool_config_variables.c:4899<br>2024-12-25 03:20:40.976: child pid 2485255: DEBUG: initializing pool configuration<br>2024-12-25 03:20:40.976: child pid 2485255: DETAIL: backend 1 weight: 1073741823.500000 flag: 0000<br>2024-12-25 03:20:40.976: child pid 2485255: LOCATION: pool_config_variables.c:4899<br>2024-12-25 03:20:40.976: child pid 2485255: DEBUG: extracting string tokens from [10.35.8.31] based on ;<br>2024-12-25 03:20:40.976: child pid 2485255: LOCATION: pool_config_variables.c:3076<br>2024-12-25 03:20:40.976: child pid 2485255: DEBUG: initializing pool configuration<br>2024-12-25 03:20:40.976: child pid 2485255: DETAIL: extracting string tokens [token[0]: 10.35.8.31]<br>2024-12-25 03:20:40.976: child pid 2485255: LOCATION: pool_config_variables.c:3082<br>2024-12-25 03:20:40.977: child pid 2485255: DEBUG: I am 2485255 accept fd 7<br>2024-12-25 03:20:40.977: child pid 2485255: LOCATION: child.c:1910<u><b></b></u></div><div><u><b>....</b></u></div><div>2024-12-25 03:20:40.980: child pid 2485255: LOG: new connection received<br>2024-12-25 03:20:40.980: child pid 2485255: DETAIL: connecting host=<a href="http://dev01windowsjum.internal.cloudapp.net">dev01windowsjum.internal.cloudapp.net</a> port=49942<br>2024-12-25 03:20:40.980: child pid 2485255: LOCATION: child.c:1921<br>2024-12-25 03:20:40.980: child pid 2485255: DEBUG: reading startup packet<br>2024-12-25 03:20:40.980: child pid 2485255: DETAIL: Protocol Major: 1234 Minor: 5679 database: user: <br>2024-12-25 03:20:40.980: child pid 2485255: LOCATION: child.c:775<br>2024-12-25 03:20:40.980: child pid 2485255: DEBUG: selecting backend connection<br>2024-12-25 03:20:40.980: child pid 2485255: DETAIL: SSLRequest from client<br>2024-12-25 03:20:40.980: child pid 2485255: LOCATION: child.c:1991<br>2024-12-25 03:20:40.980: child pid 2485255: DEBUG: SSL is requested but SSL support is not available<br>2024-12-25 03:20:40.980: child pid 2485255: LOCATION: pool_ssl.c:1105<br>2024-12-25 03:20:40.980: child pid 2485255: DEBUG: pool_write: to frontend: kind:N po:0<br>2024-12-25 03:20:40.980: child pid 2485255: LOCATION: pool_stream.c:478<br>2024-12-25 03:20:40.980: child pid 2485255: DEBUG: pool_flush_it: flush size: 1<br>2024-12-25 03:20:40.980: child pid 2485255: LOCATION: pool_stream.c:650<br>2024-12-25 03:20:40.982: child pid 2485255: DEBUG: reading startup packet<br>2024-12-25 03:20:40.982: child pid 2485255: DETAIL: Protocol Major: 3 Minor: 0 database: tpcc user: tpcc<br>2024-12-25 03:20:40.982: child pid 2485255: LOCATION: child.c:775<br>2024-12-25 03:20:40.982: child pid 2485255: DEBUG: creating new connection to backend<br>2024-12-25 03:20:40.982: child pid 2485255: DETAIL: connecting 0 backend<br>2024-12-25 03:20:40.982: child pid 2485255: LOCATION: pool_connection_pool.c:884<br>2024-12-25 03:20:40.982: child pid 2485255: DEBUG: creating new connection to backend<br>2024-12-25 03:20:40.982: child pid 2485255: DETAIL: connecting 1 backend<br>2024-12-25 03:20:40.982: child pid 2485255: LOCATION: pool_connection_pool.c:884<br>2024-12-25 03:20:40.983: child pid 2485255: DEBUG: SSL is requested but SSL support is not available<br>2024-12-25 03:20:40.983: child pid 2485255: LOCATION: pool_ssl.c:1115<br>2024-12-25 03:20:40.983: child pid 2485255: DEBUG: pool_flush_it: flush size: 33<br>2024-12-25 03:20:40.983: child pid 2485255: LOCATION: pool_stream.c:650<br>2024-12-25 03:20:40.983: child pid 2485255: DEBUG: SSL is requested but SSL support is not available<br>2024-12-25 03:20:40.983: child pid 2485255: LOCATION: pool_ssl.c:1115<br>2024-12-25 03:20:40.983: child pid 2485255: DEBUG: pool_flush_it: flush size: 33<br>2024-12-25 03:20:40.983: child pid 2485255: LOCATION: pool_stream.c:650<br>2024-12-25 03:20:40.992: child pid 2485255: DEBUG: pool_read: read 381 bytes from backend 0<br>2024-12-25 03:20:40.992: child pid 2485255: LOCATION: pool_stream.c:199<br>2024-12-25 03:20:40.992: child pid 2485255: DEBUG: pool_read: read 99 bytes from backend 1<br>2024-12-25 03:20:40.992: child pid 2485255: LOCATION: pool_stream.c:199<br>2024-12-25 03:20:40.992: child pid 2485255: DEBUG: reading message length<br>2024-12-25 03:20:40.992: child pid 2485255: DETAIL: slot: 0 length: 8<br>2024-12-25 03:20:40.992: child pid 2485255: LOCATION: pool_proto_modules.c:4486<br>2024-12-25 03:20:40.992: child pid 2485255: DEBUG: reading message length<br>2024-12-25 03:20:40.992: child pid 2485255: DETAIL: slot: 1 length: 8<br>2024-12-25 03:20:40.992: child pid 2485255: LOCATION: pool_proto_modules.c:4500<br>2024-12-25 03:20:40.992: child pid 2485255: DEBUG: authentication backend<br>2024-12-25 03:20:40.992: child pid 2485255: DETAIL: auth kind:0<br>2024-12-25 03:20:40.992: child pid 2485255: LOCATION: pool_auth.c:419<br>2024-12-25 03:20:40.992: child pid 2485255: DEBUG: pool_write: to frontend: kind:R po:0<br>2024-12-25 03:20:40.992: child pid 2485255: LOCATION: pool_stream.c:478<br>2024-12-25 03:20:40.992: child pid 2485255: DEBUG: pool_write: to frontend: length:4 po:1<br>2024-12-25 03:20:40.992: child pid 2485255: LOCATION: pool_stream.c:481<br>2024-12-25 03:20:40.992: child pid 2485255: DEBUG: pool_write: to frontend: length:4 po:5<br>2024-12-25 03:20:40.992: child pid 2485255: LOCATION: pool_stream.c:481<br>2024-12-25 03:20:40.992: child pid 2485255: DEBUG: pool_flush_it: flush size: 9<br>2024-12-25 03:20:40.992: child pid 2485255: LOCATION: pool_stream.c:650<br>2024-12-25 03:20:40.992: child pid 2485255: LOG: pool_read_kind: error message from 1 th backend:database "tpcc" does not exist<br>2024-12-25 03:20:40.992: child pid 2485255: LOCATION: pool_proto_modules.c:4653<br>2024-12-25 03:20:40.992: child pid 2485255: ERROR: unable to read message kind<br>2024-12-25 03:20:40.992: child pid 2485255: DETAIL: kind does not match between main(53) slot[1] (45)<br>2024-12-25 03:20:40.992: child pid 2485255: LOCATION: pool_proto_modules.c:4658<br>2024-12-25 03:20:40.992: child pid 2485255: DEBUG: pool_write: to frontend: kind:E po:0<br>2024-12-25 03:20:40.992: child pid 2485255: LOCATION: pool_stream.c:478<br>2024-12-25 03:20:40.992: child pid 2485255: DEBUG: pool_write: to frontend: length:4 po:1<br>2024-12-25 03:20:40.992: child pid 2485255: LOCATION: pool_stream.c:481<u><b></b></u></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div> List of databases<br> Name | Owner | Encoding | Collate | Ctype | ICU Locale | Locale Provider | Access privileges <br>------------+------------------+----------+-------------+-------------+------------+-----------------+----------------------------<br> monitor | pgbigboss | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | libc | <br> postgres | pgbigboss | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | libc | =Tc/pgbigboss +<br> | | | | | | | pgbigboss=CTc/pgbigboss +<br> | | | | | | | readonly_role=c/pgbigboss +<br> | | | | | | | readwrite_role=c/pgbigboss<br> repmgr | repmgr_owner | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | libc | <br> template0 | pgbigboss | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | libc | =c/pgbigboss +<br> | | | | | | | pgbigboss=CTc/pgbigboss<br> template1 | pgbigboss | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | libc | =c/pgbigboss +<br> | | | | | | | pgbigboss=CTc/pgbigboss<br> <b>tpcc | tpcc | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | libc </b> | <br> tst20dec01 | tst20dec01_owner | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | libc | <br>(7 rows)</div><div><br></div><div><br></div><div><br></div><div><b style="background-color:rgb(243,243,243)"><font color="#ff0000">Please help me understand what's happening with the database 'tpcc' that is been created and trying to access the same with new session gives error saying 'tpcc' does not exist.</font></b></div><div><br></div><div>Regards</div><div>Mukesh Tanuku</div></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Wed, Dec 25, 2024 at 5:28 AM Tatsuo Ishii <<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">> Sometimes i see destination = 3, what this meas?<br>
<br>
It means the query is sent to both primary and standby(s).<br>
<br>
> BTW, Yes, I tried setting it to "remote_apply", but from then on I'm<br>
> getting connection timed-out errors from client.<br>
> <br>
> Error in Virtual User 1: Error: Connection to database failed<br>
> connection to server at "10.35.8.4", port 6211 failed: Connection timed out<br>
> (0x0000274C/10060)<br>
> Is the server running on that host and accepting TCP/IP connections?<br>
> <br>
> Nothing is been logged in pgpool.log<br>
<br>
Can you connect to the PostgreSQL (IP=10.35.8.4, port=6211) using psql?<br>
If you cannot, the problem is in PostgreSQL, not pgpool.<br>
<br>
Best reagards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS K.K.<br>
English: <a href="http://www.sraoss.co.jp/index_en/" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en/</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
</blockquote></div></div>