[Pgpool-general] pgfail

[Евгений Фурманюк]

Hello all.

I have pgpool-II-2.2 and periodical have error:

2009-02-20 08:30:34 ERROR: pid 23585: pool_process_query: 1 th kind D does
not match with master or majority connection kind C
2009-02-20 08:30:34 ERROR: pid 23585: kind mismatch among backends. Possible
last query was: " SET SESSION AUTHORIZATION DEFAULT" kind details are: 0[C]
1[D]
2009-02-20 08:30:34 LOG:   pid 23585: notice_backend_error: 1 fail over
request from pid 23585
2009-02-20 08:30:34 LOG:   pid 23584: starting degeneration. shutdown host
192.168.0.3(5432)
2009-02-20 08:30:34 LOG:   pid 23584: failover_handler: set new master node:
0
2009-02-20 08:30:34 LOG:   pid 23584: failover done. shutdown host
192.168.0.3(5432)

Work one two hour, then error and node failover.

What can i do?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20090220/820e6fdd/attachment.html 
-------------- next part --------------
# listen 
listen_addresses = '*'
port = 9999

pcp_port = 9898
pcp_socket_dir = '/tmp'
pcp_timeout = 40

socket_dir = '/tmp'
num_init_children = 300
max_pool = 10
child_life_time = 0
connection_life_time = 0
child_max_connections = 0
client_idle_limit = 0
authentication_timeout = 60

# main settings
replication_mode = true
replication_timeout = 50000
replication_stop_on_mismatch = true
replicate_select = true # false

load_balance_mode = true
parallel_mode = false
enable_query_cache = false

# other

reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
print_timestamp = true
master_slave_mode = false
connection_cache = true
insert_lock = false
ignore_leading_white_space = true

# failover and recovery
#failover_command = '/var/lib/postgresql/data/__failover.sh'
failover_command = ''
#failback_command = '/var/lib/postgresql/data/pgpool-recovery'
failback_command = ''

health_check_timeout = 40
health_check_period = 20
health_check_user = 'nobody'

recovery_user = 'recovery'
recovery_password = ''
recovery_1st_stage_command = 'base-backup.sh'
recovery_2nd_stage_command = 'pgpool-recovery'
recovery_timeout = 90

# log
log_statement = true
log_connections = true
log_hostname = true
logdir = '/var/log/'

# system
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 = ''
enable_pool_hba = false

# backend
backend_socket_dir = '/tmp'

#backend_hostname0 = '192.168.0.1'
#backend_port0 = 5432
#backend_weight0 = 0.5
#backend_data_directory0 = '/var/lib/postgresql/data/'

backend_hostname0 = 'localhost'
backend_port0 = 5432
backend_weight0 = 0.5
backend_data_directory0 = '/var/lib/postgresql/data/'

backend_hostname1 = '192.168.0.3'
backend_port1 = 5432
backend_weight1 = 0.5
backend_data_directory1 = '/var/lib/postgresql/data/'