[Pgpool-general] ERROR: pid 29857: pool_read_int: data does not match between between master (0) slot[1] (50331648)

[Tatsuo Ishii]

What versions are your PostgreSQL servers? Maybe 8.3?

Do your PostgreSQL servers use GSSAPI authentication? I'm afraid
pgpool-II does not support it (yet).
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> Greetings all!
> 
> I have a problem with pgpool-ii-1.3.  Debug information is below...
> .....
> 2007-10-25 16:28:20 DEBUG: pid 29850: loading "/usr/local/etc/pool_hba.conf"
> for client authentication configuration file
> 2007-10-25 16:28:20 DEBUG: pid 29851: I am 29851
> 2007-10-25 16:28:20 DEBUG: pid 29852: I am 29852
> 2007-10-25 16:28:20 DEBUG: pid 29853: I am 29853
> 2007-10-25 16:28:20 DEBUG: pid 29854: I am 29854
> 2007-10-25 16:28:20 DEBUG: pid 29855: I am 29855
> 2007-10-25 16:28:20 DEBUG: pid 29856: I am 29856
> 2007-10-25 16:28:20 DEBUG: pid 29858: I am 29858
> 2007-10-25 16:28:20 DEBUG: pid 29859: I am 29859
> 2007-10-25 16:28:20 DEBUG: pid 29860: I am 29860
> 2007-10-25 16:28:20 DEBUG: pid 29861: I am 29861
> 2007-10-25 16:28:20 DEBUG: pid 29857: I am 29857
> 2007-10-25 16:28:20 DEBUG: pid 29862: I am 29862
> 2007-10-25 16:28:20 LOG:   pid 29850: pgpool successfully started
> 2007-10-25 16:28:20 DEBUG: pid 29863: I am PCP 29863
> 2007-10-25 16:28:55 DEBUG: pid 29857: I am 29857 accept fd 0
> 2007-10-25 16:28:55 LOG:   pid 29857: connection received: host=
> replica.test.box.ru port=50558
> 2007-10-25 16:28:55 DEBUG: pid 29857: Protocol Major: 3 Minor: 0 database:
> testdb user: tester
> 2007-10-25 16:28:55 DEBUG: pid 29857: new_connection: connecting 0 backend
> 2007-10-25 16:28:55 DEBUG: pid 29857: new_connection: connecting 1 backend
> 2007-10-25 16:28:55 DEBUG: pid 29857: pool_read_message_length: slot: 0
> length: 8
> 2007-10-25 16:28:55 DEBUG: pid 29857: pool_read_message_length: slot: 1
> length: 8
> 2007-10-25 16:28:55 ERROR: pid 29857: pool_read_int: data does not match
> between between master(0) slot[1] (50331648)
> 2007-10-25 16:28:55 ERROR: pid 29857: pool_do_auth: read pid failed
> 2007-10-25 16:29:41 DEBUG: pid 29857: I am 29857 accept fd 0
> 2007-10-25 16:29:41 LOG:   pid 29857: connection received: host=
> replica.test.box.ru port=45897
> 2007-10-25 16:29:41 DEBUG: pid 29857: Protocol Major: 3 Minor: 0 database:
> testdb user: tester
> 2007-10-25 16:29:41 DEBUG: pid 29857: new_connection: connecting 0 backend
> 2007-10-25 16:29:41 DEBUG: pid 29857: new_connection: connecting 1 backend
> 2007-10-25 16:29:41 DEBUG: pid 29857: pool_read_message_length: slot: 0
> length: 8
> 2007-10-25 16:29:41 DEBUG: pid 29857: pool_read_message_length: slot: 1
> length: 8
> 2007-10-25 16:29:41 ERROR: pid 29857: pool_read_int: data does not match
> between between master(0) slot[1] (50331648)
> 2007-10-25 16:29:41 ERROR: pid 29857: pool_do_auth: read pid failed
> 
> I wish to deploy master-slave configuration with two backends (replication
> with Slony-I). Pgpool-ii works on the backend0 ( master ).
> Here is my configuration file:
> 
> listen_addresses = '*'
> port = 9999
> pcp_port = 9898
> socket_dir = '/tmp'
> pcp_socket_dir = '/tmp'
> backend_socket_dir = '/tmp'
> pcp_timeout = 10
> num_init_children = 12
> max_pool = 1
> child_life_time = 300
> connection_life_time = 0
> child_max_connections = 0
> authentication_timeout = 60
> 
> # logging
> logdir = '/var/log'
> print_timestamp = true
> log_statement = true
> log_connections = true
> log_hostname = true
> # End of logging
> 
> # Work mode
> parallel_mode = false
> replication_mode = false
> load_balance_mode = true
> master_slave_mode = true
> # End of the work mode
> 
> reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
> connection_cache = true
> health_check_timeout = 20
> health_check_period = 0
> health_check_user = 'nobody'
> insert_lock = false
> ignore_leading_white_space = false
> enable_query_cache = false
> pgpool2_hostname = 'replica.test.box.ru'
> backend_hostname0 = 'replica.test.box.ru'
> backend_port0 = 5432
> backend_weight0 = 1
> backend_hostname1 = 'replica1.test.box.ru'
> backend_port1 = 5432
> backend_weight1 = 1
> enable_pool_hba = true
> 
> 
> postgres at replica:~/bin$ ./psql -U tester -d testdb -W -p 9999 -h
> 192.168.157.120
> Password for user tester:
> psql: server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> 
> In the debug information I got ERROR: pid 29857: pool_read_int: data does
> not match between between master(0) slot[1] (50331648).
> Any ideas?
> Thank you in advance.
> 
> 
> -- 
> best regards,
> Oleg Laktionov