[Pgpool-general] Error "kind does not match between backends"
Vladimir A. Petrov
vap at infopac.ru
Thu Feb 2 09:25:39 GMT 2006
Hello!
I just tried to setup pgpool-2.6.3 for two servers in master/slave mode.
Connection via pgpool fails:
root at sql:~#psql -U vap -p 9999 -h sql3 infopac
Password:
psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Pgpool.log contains the following diagnostics:
2006-02-02 13:01:24 DEBUG: pid 77219: name: session_authorization value: vap
2006-02-02 13:01:24 DEBUG: pid 77219: secondary name: server_encoding
value: UNICODE
2006-02-02 13:01:24 ERROR: pid 77219: read_kind: kind does not match
between backends master(75) secondary(83)
2006-02-02 13:01:24 ERROR: pid 77219: pool_do_auth: failed to read kind
while processing ParamterStatus
Master server has version 7.4.11, slave has version 8.0.6. Slave
contains the replication of the only one schema from master. Replication
implemented via slony1-1.1.2. Both servers has equal authentification
settings:
Master:
host all all 217.77.96.0 255.255.255.0 password
Slave:
host all all 217.77.96.0/24 password
Configuration of pgpool:
listen_addresses = '*'
port = 9999
socket_dir = '/tmp'
backend_host_name = 'sql.infopac.ru'
backend_port = 5432
secondary_backend_host_name = 'sql3.infopac.ru'
secondary_backend_port = 5432
num_init_children = 32
max_pool = 4
child_life_time = 300
connection_life_time = 0
logdir = '/var/log'
replication_mode = false
replication_strict = true
replication_timeout = 5000
load_balance_mode = true
weight_master = 1
weight_secondary = 10
replication_stop_on_mismatch = false
reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
print_timestamp = true
master_slave_mode = true
connection_cache = true
health_check_timeout = 20
health_check_period = 0
health_check_user = 'nobody'
insert_lock = false
How can I to resolve this problem?
Any help will be appreciated.
--
Vladimir A. Petrov (aka vap) phone: (+7 8482) 420069
Infopac JSC. Head of the exploitation department. http://infopac.ru
_______________________________________________________________________
^[:wq ...sed libera nos a malo.
More information about the Pgpool-general
mailing list