pgpool HA not working

From: Sanjay Rao <srao(at)noida(dot)interrasystems(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pgpool HA not working
Date: 2011-07-24 13:25:09
Message-ID: 4E2C1D35.5070604@noida.interrasystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I am working on pgpool /postgresql/linux first time. All these three are
new to me.

I am running pgpool-HA using pacemaker-corosync.
I am having following error in my setup. Does any body have any idea
about the warning highlighted in logs ? Any type of help would be
appreciated a lot...

Jul 24 18:40:41 squarepant attrd: [3772]: info: attrd_perform_update:
Sent update 1010: probe_complete=true
Jul 24 18:40:41 squarepant cib: [3770]: WARN: cib_process_request:
Operation complete: op cib_modify for section status
(origin=local/attrd/1010, version=0.52.352): The object/attribute does
not exist (rc=-22)
Jul 24 18:40:41 squarepant attrd: [3772]: WARN: attrd_cib_callback:
Update 1010 for probe_complete=true failed: The object/attribute does
not exist
Jul 24 18:40:41 squarepant pgpool[7635]: INFO: pgpoolRA: request stop,
but not running.
Jul 24 18:40:41 squarepant crmd: [3896]: info: process_lrm_event: LRM
operation pgpool_stop_0 (call=339, rc=0, cib-update=472, confirmed=true) ok
Jul 24 18:40:41 squarepant crmd: [3896]: info: match_graph_event: Action
pgpool_stop_0 (2) confirmed on squarepant (rc=0)
Jul 24 18:40:41 squarepant crmd: [3896]: info: te_rsc_command:
Initiating action 12: start pgpool_start_0 on squarepant (local)
Jul 24 18:40:41 squarepant crmd: [3896]: info: do_lrm_rsc_op: Performing
key=12:112:0:6d68acf3-ab99-409f-b686-8533e4b24ca0 op=pgpool_start_0 )
Jul 24 18:40:41 squarepant lrmd: [3771]: info: rsc:pgpool:340: start
Jul 24 18:40:41 squarepant crmd: [3896]: info: te_pseudo_action: Pseudo
action 5 fired and confirmed

ouput of crm_mon command is

============
Last updated: Sun Jul 24 18:15:59 2011
Stack: Heartbeat
Current DC: squarepant (85f4f3d6-650e-4620-8cbb-edb1bc9d389c) -
partition with quorum
Version: 1.1.5-1.fc14-01e86afaaa6d4a8c4836f68df80ababd6ca3902f
1 Nodes configured, unknown expected votes
3 Resources configured.
============

Online: [ squarepant ]

DBIP (ocf::heartbeat:IPaddr2): Started squarepant
postgresql (ocf::heartbeat:pgsql): Started squarepant
pgpool (ocf::heartbeat:pgpool): Started squarepant FAILED

Failed actions:
pgpool_monitor_30000 (node=squarepant, call=1874, rc=7,
status=complete): not running

Thanks & Regards
Sanjay

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pablo Romero Abiti 2011-07-24 13:55:36 Re : Re : Update columns in same table from update trigger?
Previous Message Yan Chunlu 2011-07-24 12:46:26 Re: streaming replication does not work across datacenter with 20ms latency?