[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