[Pgpool-general] pgpool-II-2.2.1 dropping secondary back-end

[Sridhar Reddapani]

Hi,

I am using Pgpool for a while and we are happy to use it for few of our
production servers.
Suddenly I had this issue..

We are using pgpool for replication with Online Recovery, Its working fine
for 1-2 Hours and then its dropping secondary back-end host[Even postgres on
it running] from pool, some times I can recover it using recovery scripts,
but some times I need to restart[ kill -9] pgpool to recover it. I couldnt
find any useful information in both pgpool and postgres logs.

As per my knowledge, pgpool drops nodes only if it fails in health-check. Am
I correct? or does pgpool take anything else

My pgpool.conf file has these values

listen_addresses = '*'
port = 5432
pcp_port = 9898
socket_dir = '/tmp'
pcp_socket_dir = '/tmp'
backend_socket_dir = '/tmp'
pcp_timeout = 10
num_init_children = 250
max_pool = 1
child_life_time = 120
connection_life_time = 300
child_max_connections = 0
client_idle_limit = 0
authentication_timeout = 60
logdir = '/data/pgsql/pgpool/logs'
pid_file_name = '/data/pgsql/pgpool/logs/pgpool.pid'
replication_mode = true
load_balance_mode = false
replication_stop_on_mismatch = false
replicate_select = false
reset_query_list = 'ABORT; DISCARD ALL'
print_timestamp = true
master_slave_mode = false
connection_cache = true
health_check_timeout = 90
health_check_period = 30
health_check_user = 'postgres'
insert_lock = false
ignore_leading_white_space = true
log_statement = false
log_connections = false
log_hostname = false
parallel_mode = false
enable_query_cache = false
pgpool2_hostname = ''
system_db_hostname = 'localhost'
system_db_port = 5432
system_db_dbname = 'pgpool'
system_db_schema = 'pgpool_catalog'
system_db_user = 'pgpool'
system_db_password = ''
backend_hostname0 = 'x.x.x.x'
backend_port0 = 5433
backend_weight0 = 1
backend_data_directory0 = '/data/pgsql/pgsql3'
backend_hostname1 = 'x.x.x.x'
backend_port1 = 5433
backend_weight1 = 0
backend_data_directory1 = '/data/pgsql/pgsql3'
enable_pool_hba = false
recovery_user = 'postgres'
recovery_password = 'xxxxx'
recovery_1st_stage_command = 'copy_base_backup'
recovery_2nd_stage_command = 'pgpool_recovery_pitr'
recovery_timeout = 150
client_idle_limit_in_recovery = 120

Any Help / Suggestions please?



Thanks & Regards,
Sridhar Reddapani,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090710/d614e417/attachment.html>