[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