<div dir="ltr">Hello.<div><br></div><div>You can check Postgresql log files. When standby node is converted in master node, pgpool run shell script indicated in failover_command (pgpool.conf). This shell script must create a trigger file in standby server. After trigger file is created, standby node is in write-mode, and Posgresql log files show this.</div><div><br></div><div>Regards.</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Aug 9, 2016 at 9:39 PM, Daniel Huhardeaux <span dir="ltr"><<a href="mailto:tech@tootai.net" target="_blank">tech@tootai.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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<br>
<br>
verification_cluster=# drop table utilisateur;<br>
WARNING: packet kind of backend 1 ['E'] does not match with master/majority nodes packet kind ['C']<br>
FATAL: failed to read kind from backend<br>
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]<br>
HINT: check data consistency among db nodes<br>
server closed the connection unexpectedly<br>
This probably means the server terminated abnormally<br>
before or while processing the request.<br>
The connection to the server was lost. Attempting reset: Succeeded.<br>
<br>
Previous master being down, I tried various solutions including pg_ctl reload or server reboot. It stay in this state.<br>
<br>
>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 ?<br>
<br>
Thanks for any hint, sorry to take your time.<br>
<br>
Regards<span class="HOEnZb"><font color="#888888"><br>
<br>
Daniel<br>
<br>
-- <br>
TOOTAi Networks<br>
______________________________<wbr>_________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-general</a><br>
</font></span></blockquote></div><br></div>