[pgpool-general: 1479] pgPool watchdog service is down after Primary failover

ning chan ninchan8328 at gmail.com
Mon Mar 11 02:50:19 JST 2013


hi,
I am evaluating the pgPool-II 3.2.3 with the same test case I tested with
3.2.2, I see the behavior is different and would like to know if this is an
expected behavior, new bug, or known issue?

server0 is Primary database with pgpool0
server1 is Standby database with pgpool1

Here is the steps to reproduce problem:
1) Checked and confirmed that all backend status are 2 and virtual ip
assigned to Primary0
2) Induce kernel panic on server0, " echo 'c' > /proc/sysrq-trigger"
3) pgpool1 should detect the backend0 is down and promote server1 to become
new Primary. From database point of view, the backend1 does promoted to
become new primary, however, pgpool1 watchdog and health check services
reported error.

Log and config file are attached.

Thanks~
Ning
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130310/1bf79c14/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: failback.py
Type: application/octet-stream
Size: 10531 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130310/1bf79c14/attachment-0006.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: failover.py
Type: application/octet-stream
Size: 6234 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130310/1bf79c14/attachment-0007.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool-server1.conf
Type: application/octet-stream
Size: 25586 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130310/1bf79c14/attachment-0008.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: db-server1.log
Type: application/octet-stream
Size: 51648 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130310/1bf79c14/attachment-0009.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool-server0.conf
Type: application/octet-stream
Size: 25375 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130310/1bf79c14/attachment-0010.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: db-server0.log
Type: application/octet-stream
Size: 18226 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130310/1bf79c14/attachment-0011.obj>


More information about the pgpool-general mailing list