Greetings,
I'm encountering the error:pool_read_int: data does not match between between master(0) slot[1] (50331648)
as shown from the debug lines below.The only online discussion I found with something similar alluded to enable_pool_hba being true, but as you can see below, enable_pool_hba = false.
I'm missing something obvious here. Anyone have any idea what I'm doing wrong?
Thanks ---------------------- Config: listen_addresses = '*' port = 5432 pcp_port = 9898 socket_dir = '/tmp' pcp_socket_dir = '/tmp' backend_socket_dir = '/tmp' pcp_timeout = 10 num_init_children = 256 max_pool = 4 child_life_time = 3600 connection_life_time = 600 child_max_connections = 0 client_idle_limit = 3600 authentication_timeout = 0 logdir = '/tmp' pid_file_name = '/var/run/pgpool/pgpool.pid' replication_mode = false load_balance_mode = true replication_stop_on_mismatch = false replicate_select = true reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT' print_timestamp = true master_slave_mode = true connection_cache = true health_check_timeout = 0 health_check_period = 0 health_check_user = 'nobody' failover_command = '' failback_command = '' insert_lock = true ignore_leading_white_space = true log_statement = false log_connections = false log_hostname = false parallel_mode = false enable_query_cache = false pgpool2_hostname = '' backend_hostname0 = 'naster0' backend_port0 = 5432 backend_weight0 = 0 backend_hostname1 = 'slave1' backend_port1 = 5431 backend_weight1 = 1 enable_pool_hba = false recovery_user = 'nobody' recovery_password = '' recovery_1st_stage_command = '' recovery_2nd_stage_command = '' recovery_timeout = 90 client_idle_limit_in_recovery = 0 Debug: 2009-06-06 20:19:42 LOG: pid 4254: pgpool successfully started 2009-06-06 20:19:42 DEBUG: pid 4511: I am PCP 4511 2009-06-06 20:19:49 DEBUG: pid 4510: I am 4510 accept fd 52009-06-06 20:19:49 DEBUG: pid 4510: Protocol Major: 1234 Minor: 5679 database: user:
2009-06-06 20:19:49 DEBUG: pid 4510: SSLRequest: sent N; retry startup2009-06-06 20:19:49 DEBUG: pid 4510: Protocol Major: 3 Minor: 0 database: db user: xxx
2009-06-06 20:19:49 DEBUG: pid 4510: new_connection: connecting 0 backend 2009-06-06 20:19:49 DEBUG: pid 4510: new_connection: connecting 1 backend2009-06-06 20:19:49 DEBUG: pid 4510: pool_read_message_length: slot: 0 length: 8 2009-06-06 20:19:49 DEBUG: pid 4510: pool_read_message_length: slot: 1 length: 8 2009-06-06 20:19:49 ERROR: pid 4510: pool_read_int: data does not match between between master(0) slot[1] (50331648)
2009-06-06 20:19:49 ERROR: pid 4510: pool_do_auth: read auth kind failed
pgp7kYQkh35Kw.pgp
Description: PGP Digital Signature
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
