[Pgpool-general] pool_read_int: data does not match ...

Henry henry at zen.co.za
Sat Jun 6 18:50:20 UTC 2009


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 5
2009-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 startup
2009-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 backend
2009-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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: PGP Digital Signature
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090606/050481ea/attachment.bin>


More information about the Pgpool-general mailing list