[pgpool-general: 1319] Re: Error on pgpool

[Wolf Schwurack]

After doing some checking I found that pgool failed over to the replicate database. I have restart master and replicate, then both pgpool. But the pgpool keeps pointing to the replicate database.

How do I get pgpool to point back to the master?

Wolf

From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Wolf Schwurack
Sent: Sunday, January 13, 2013 10:28 AM
To: 'pgpool-general at pgpool.net'
Subject: [pgpool-general: 1317] Error on pgpool

Not sure why we got this error or if there is a problem can anyone help? I check the connections which all seem to still be working

I have 2 pgpool with master and slave postgres
pgpool-II version 3.2.1
psql (9.2.1)

2013-01-11 15:11:15 LOG:   pid 7004: ProcessFrontendResponse: failed to read kin
d from frontend. frontend abnormally exited
2013-01-13 09:44:47 LOG:   pid 1272: degenerate_backend_set: 0 fail over request
from pid 1272
2013-01-13 09:44:47 LOG:   pid 1267: starting degeneration. shutdown host pgprod
-db(5432)
2013-01-13 09:44:47 LOG:   pid 1267: Restart all children
2013-01-13 09:44:47 LOG:   pid 1267: find_primary_node_repeatedly: waiting for f
inding a primary node
2013-01-13 09:45:27 LOG:   pid 1272: wd_escalation: escalated to master pgpool
2013-01-13 09:45:27 LOG:   pid 1272: wd_escalation:  escaleted to delegate_IP ho
lder
2013-01-13 09:45:50 LOG:   pid 1273: wd_lifecheck: lifecheck failed 3 times. pgpool seems not to be working
2013-01-13 09:45:50 LOG:   pid 1273: wd_IP_down: ifconfig down succeeded
2013-01-13 09:45:50 LOG:   pid 1273: wd_lifecheck: lifecheck failed 3 times. pgpool seems not to be working
2013-01-13 09:46:12 LOG:   pid 1273: wd_lifecheck: lifecheck failed 3 times. pgpool seems not to be working
2013-01-13 09:46:12 LOG:   pid 1273: wd_lifecheck: lifecheck failed 3 times. Pgpool seems not to be working
2013-01-13 09:46:18 LOG:   pid 1267: failover: set new primary node: -1
2013-01-13 09:46:18 LOG:   pid 1267: failover: set new master node: 1
2013-01-13 09:46:18 LOG:   pid 1307: worker process received restart request
2013-01-13 09:46:18 LOG:   pid 1267: failover done. shutdown host pgprod-db(5432)
2013-01-13 09:46:19 LOG:   pid 1306: pcp child process received restart request
2013-01-13 09:46:19 LOG:   pid 1267: PCP child 1306 exits with status 256
2013-01-13 09:46:19 LOG:   pid 1267: fork a new PCP child pid 13994
2013-01-13 09:46:19 LOG:   pid 1267: worker child 1307 exits with status 256
2013-01-13 09:46:19 LOG:   pid 1267: fork a new worker child pid 13995
2013-01-13 09:46:22 LOG:   pid 1273: wd_escalation: escalated to master pgpool
2013-01-13 09:46:22 LOG:   pid 1273: wd_escalation:  escaleted to delegate_IP holder
2013-01-13 09:47:18 LOG:   pid 13965: authentication is timeout


      0___      Wolfgang Schwurack
     c/  /'_    DBA/SA
    (*)  \(*)   University of Utah/UEN
                Tel: (801) 587-9444
                email: wolf at uen.org<mailto:wolf at uen.org>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130114/6be68505/attachment-0001.html>