[Pgpool-general] Fwd: ERROR: pid 29857: pool_read_int: data does not match between between master (0) slot[1] (50331648)
Oleg Laktionov
olaktionov at gmail.com
Tue Oct 30 11:47:08 UTC 2007
Hi,
My problem is resolved.
Thanks everybody!!!
---------- Forwarded message ----------
From: Oleg Laktionov <olaktionov at gmail.com>
Date: 29.10.2007 15:35
Subject: Re: [Pgpool-general] ERROR: pid 29857: pool_read_int: data does not
match between between master (0) slot[1] (50331648)
To: Yoshiyuki Asaba <y-asaba at sraoss.co.jp>
Hi,
Thank you.
I have changed pool-hba.conf, pg_hba.conf and now it works fine.
I realize that the cause was a misconfiguration of this files.
Below is right configuration...
pool-hba.conf:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 192.168.157.120/32 trust
host all all 192.168.157.121/32 trust
pg_hba.conf:
# "local" is for Unix domain socket connections only
local all all password
# IPv4 local connections:
host all all 127.0.0.1/32 password
host all all 192.168.157.120/32 password
host all all 192.168.157.121/32 password
Great. Thank you again.
2007/10/29, Yoshiyuki Asaba <y-asaba at sraoss.co.jp>:
>
> Hi,
>
> Sorry for the delay.
>
> From: "Oleg Laktionov" <olaktionov at gmail.com>
> Subject: [Pgpool-general] ERROR: pid 29857: pool_read_int: data does not
> match between between master (0) slot[1] (50331648)
> Date: Thu, 25 Oct 2007 17:23:55 +0400
>
> > 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.
>
> Are you setting md5 authentication?
>
> --
> Yoshiyuki Asaba
> y-asaba at sraoss.co.jp
>
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20071030/a8f6519b/attachment.html
More information about the Pgpool-general
mailing list