[pgpool-general: 8576] Re: received degenerate backend request for node_id: 0 from pid [$pid]

[Giuseppe Sacco]

Hello,
I forgot to reply to your second question. Please find below the
pgpool.conf configuration file content.

Il giorno gio, 26/01/2023 alle 16.34 +0100, Giuseppe Sacco ha scritto:
pgpool[134337]: 2023-01-26 15:30:16.735: [unknown] pid 134337: DEBUG: 
pool_read: read -1 bytes from backend 0
pgpool[134337]: 2023-01-26 15:30:16.735: [unknown] pid 134337: LOCATION: 
pool_stream.c:199
pgpool[134337]: 2023-01-26 15:30:16.735: [unknown] pid 134337: LOG: 
received degenerate backend request for node_id: 0 from pid [134337]
pgpool[134337]: 2023-01-26 15:30:16.735: [unknown] pid 134337: LOCATION: 
pool_internal_comms.c:145

backend_clustering_mode = 'streaming_replication'
listen_addresses = 'PGPOOL_IP'
port = 5995
socket_dir = '/var/lib/postgresql/pgpool'
backend_hostname0 = 'SERVER1_IP'
backend_port0 = 5995
backend_weight0 = 0
backend_data_directory0 = '/var/lib/postgresql/14/main'
backend_flag0 = 'ALWAYS_PRIMARY'
backend_application_name0 = 'pgpool0'
backend_hostname1 = 'SERVER2_IP'
backend_port1 = 5995
backend_weight1 = 1
backend_data_directory1 = '/dati/ripristino_barman'
backend_flag1 = 'ALLOW_TO_FAILOVER'
backend_application_name1 = 'pgpool1'
allow_clear_text_frontend_auth = on
num_init_children = 8
log_connections = on
log_statement = off
log_per_node_statement = off
log_standby_delay = 'if_over_threshold'
log_error_verbosity = verbose
log_min_messages = debug5
replicate_select = off
load_balance_mode = on
sr_check_period = 10
sr_check_user = 'SR_USER'
sr_check_password = 'TEXT....'
delay_threshold = 60
health_check_period = 120
health_check_user = 'HL_USER'
health_check_password = 'TEXT....'
health_check_max_retries = 1000
health_check_retry_delay = 1000
hostname0 = ''

Thank you,
Giuseppe