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?
# 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/'
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
