[pgpool-general: 1317] Error on pgpool

Wolf Schwurack wolf at uen.org
Mon Jan 14 02:27:39 JST 2013


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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130113/664510d9/attachment.html>


More information about the pgpool-general mailing list