[pgpool-general: 2123] pgpool-HA resource agent monitor not running

Mistina Michal Michal.Mistina at virte.sk
Wed Sep 11 22:42:44 JST 2013


Hi to everybody.

I'm running pgpool on the top of 2-node pacemaker cluster. There are couple
more services running on each server.

After I migrate from one node to another I am experiencing a failure of
monitoring action on the pgpool resource agent. However pgpool service is
running.

It looks like this:

[root at tstcaps01 ~]# crm_mon -1

============

Last updated: Wed Sep 11 13:21:09 2013

Last change: Wed Sep 11 13:16:37 2013 via cibadmin on tstcaps02

Stack: openais

Current DC: tstcaps01 - partition WITHOUT quorum

Version: 1.1.7-6.el6-148fccfd5985c5590cc601123c6c16e966b85d14

2 Nodes configured, 4 expected votes

9 Resources configured.

============

 

Online: [ tstcaps01 tstcaps02 ]

 

Resource Group: PGServer

     pg_lvm     (ocf::heartbeat:LVM):   Started tstcaps01

     pg_fs      (ocf::heartbeat:Filesystem):    Started tstcaps01

     pg_vip     (ocf::heartbeat:IPaddr2):       Started tstcaps01

     pg_lsb     (lsb:postgresql-9.2):   Started tstcaps01

     pg_pool    (ocf::heartbeat:pgpool):        Started tstcaps01

Master/Slave Set: ms_drbd_pg [drbd_pg]

     Masters: [ tstcaps01 ]

     Slaves: [ tstcaps02 ]

Clone Set: pingclone [pg_ping]

     Started: [ tstcaps02 tstcaps01 ]

 

Failed actions:

    pg_pool_monitor_120000 (node=tstcaps01, call=30, rc=7, status=complete):
not running

 

 

Configuration snippet:

[root at tstcaps01 ~]# crm configure show

primitive pg_pool ocf:heartbeat:pgpool \

        params pgpoolconf="/etc/pgpool-II/pgpool.conf"
pcpconf="/etc/pgpool-II/pcp.conf" hbaconf="/etc/pgpool-II/pool_hba.conf"
logfile="/var/log/pgpool/pgpool.log" pgpooluser="postgres" checkmethod="pid"
checkstring="/var/run/pgpool/pgpool.pid" pgpoolcmd="/usr/bin/pgpool"
psqlcmd="/usr/pgsql-9.2/bin/psql" pcpnccmd="/usr/bin/pcp_node_count" \

        op monitor interval="120" timeout="130" \

        op start interval="0" timeout="60" \

        op stop interval="0" timeout="60" \

        meta is-managed="true"

 

There are no errors in the pgpool.log.

 

I'm using pgpool-ha 2.1, pacemaker 1.1.7-6.el6, corosync 1.4.1-7.el6.

 

Thank you.

 

Best regards,

Michal Mistina

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130911/66d4f5d8/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3076 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130911/66d4f5d8/attachment-0001.p7s>


More information about the pgpool-general mailing list