[pgpool-general: 4891] Database in read only transaction
Daniel Huhardeaux
tech at tootai.net
Wed Aug 10 04:39:33 JST 2016
Sorry, another problem. After having shutted down pgpool on master
(previous post), the standby node became MASTER but unusable. I connect
to it and want to delete a table. I receive
verification_cluster=# drop table utilisateur;
WARNING: packet kind of backend 1 ['E'] does not match with
master/majority nodes packet kind ['C']
FATAL: failed to read kind from backend
DETAIL: kind mismatch among backends. Possible last query was: "drop
table utilisateur;" kind details are: 0[C] 1[E: cannot execute DROP
TABLE in a read-only transaction]
HINT: check data consistency among db nodes
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
Previous master being down, I tried various solutions including pg_ctl
reload or server reboot. It stay in this state.
From the test I made, everything is working as it should except the
recovery from a standby node when it come back to life. What am I
missing ? How can I debug this ?
Thanks for any hint, sorry to take your time.
Regards
Daniel
--
TOOTAi Networks
More information about the pgpool-general
mailing list