<div dir="ltr">Hello<div>Have you checked your pgpool log files? If your master node became master node, pgpool log files show this situation and show failover_command run.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Aug 10, 2016 at 4:51 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">Le 10/08/2016 à 16:37, Lucas Luengas a écrit :<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hello.<br>
<br>
You can check Postgresql log files. When standby node is converted in<br>
master node, pgpool run shell script indicated in failover_command<br>
(pgpool.conf). This shell script must create a trigger file in standby<br>
server. After trigger file is created, standby node is in write-mode,<br>
and Posgresql log files show this.<br>
</blockquote>
<br>
Hello,<br>
<br>
problem I have is that failover and failback command from pgpool.conf are never executed ! :( (i'm in max debug mode on one server)<br>
<br>
Question I have: pgpool.conf is replication=on load_balance=on use-watchdog=on fail_over_on_backend_error=on and master_slave=off<br>
<br>
>From the documentation I read, especially <a href="http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/" rel="noreferrer" target="_blank">http://www.pgpool.net/pgpool-w<wbr>eb/contrib_docs/simple_sr_sett<wbr>ing2_3.3/</a> and sample from pgpool-source<br>
it should be possible. I now have some doubt.<br>
<br>
Main problem is that when a postgresql DB was done, it reconnect to the pool but there is no recovery from master DB to this new standby.<br>
<br>
Should I better use master/slave ?<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Regards.<br>
<br>
<br>
On Tue, Aug 9, 2016 at 9:39 PM, Daniel Huhardeaux <<a href="mailto:tech@tootai.net" target="_blank">tech@tootai.net</a><br>
<mailto:<a href="mailto:tech@tootai.net" target="_blank">tech@tootai.net</a>>> wrote:<br>
<br>
Sorry, another problem. After having shutted down pgpool on master<br>
(previous post), the standby node became MASTER but unusable. I<br>
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<br>
master/majority nodes packet kind ['C']<br>
FATAL: failed to read kind from backend<br>
DETAIL: kind mismatch among backends. Possible last query was:<br>
"drop table utilisateur;" kind details are: 0[C] 1[E: cannot execute<br>
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<br>
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<br>
recovery from a standby node when it come back to life. What am I<br>
missing ? How can I debug this ?<br>
<br>
Thanks for any hint, sorry to take your time.<br>
<br>
Regards<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> <mailto:<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.<wbr>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>
<<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>
<br>
<br><span class="HOEnZb"><font color="#888888">
</font></span></blockquote><span class="HOEnZb"><font color="#888888">
<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>