Hi all, I'm trying to configure my PSQL primitive. I have a 2 node cluster running with pacemaker 1.1.10, corosync 1.3.3 on Ubuntu Server 14.04 LTS. It is an active/passive cluster, so PostgreSQL (and all other resources) just have to run on the left or the right node.
It's strange...PSQL is running fine on node1, but Pacemaker want to migrate it to the second node and I don't no why. Everytime I clear the failed Actions: Failed actions (of cource it is not installed, because of the DRBD....I want to run ALL resources on the same node): p_psql-server_start_0 (node=node2, call=265, rc=5, status=complete, last-rc-change=Thu Jun 12 10:55:03 2014, queued=34ms, exec=0ms ): not installed I get the following log message: Jun 12 12:03:50 node1 pgsql(p_psql-server)[6003]: INFO: Don't check /var/lib/pgsql/data during probe Jun 12 12:03:50 node1 crmd[16412]: notice: process_lrm_event: LRM operation p_psql-server_monitor_0 (call=443, rc=0, cib-update=295, confirmed=true) ok Jun 12 12:03:50 node1 crmd[16412]: warning: status_from_rc: Action 7 (p_psql-server_monitor_0) on node1 failed (target: 7 vs. rc: 0): Error Jun 12 12:03:50 node1 crmd[16412]: notice: te_rsc_command: Initiating action 6: probe_complete probe_complete on node1 (local) - no waiting Jun 12 12:03:50 node1 crmd[16412]: notice: run_graph: Transition 65 (Complete=3, Pending=0, Fired=0, Skipped=10, Incomplete=0, Source=/var/lib/pacemaker/pengine/pe-input-292.bz2): Stopped Jun 12 12:03:50 node1 pengine[16411]: notice: unpack_config: On loss of CCM Quorum: Ignore Jun 12 12:03:50 node1 pengine[16411]: notice: unpack_rsc_op: Operation monitor found resource p_drbd_r0:0 active in master mode on node1 Jun 12 12:03:50 node1 pengine[16411]: notice: unpack_rsc_op: Preventing p_psql-server from re-starting on node2: operation start failed 'not installed' (rc=5) Jun 12 12:03:50 node1 pengine[16411]: warning: unpack_rsc_op: Processing failed op start for p_psql-server on node2: not installed (5) But it's started: Node node1 (739670273): online fs_postgres (ocf::heartbeat:Filesystem): Started p_tomcat-server (lsb:tomcat-server): Started p_lvm_r0 (ocf::heartbeat:LVM): Started p_drbd_r0 (ocf::linbit:drbd): Master p_ip (ocf::heartbeat:IPaddr2): Started fs_opt (ocf::heartbeat:Filesystem): Started fs_srv (ocf::heartbeat:Filesystem): Started p_psql-server (ocf::heartbeat:pgsql): Started Node snode2 (739670274): online p_drbd_r0 (ocf::linbit:drbd): Started My Config: node $id="739670273" node1 \ attributes standby="off" node $id="739670274" node2 \ attributes standby="off" primitive fs_opt ocf:heartbeat:Filesystem \ params device="/dev/mapper/vgdata-opt--lv" directory="/opt" fstype="ext4" \ meta target-role="Started" primitive fs_postgres ocf:heartbeat:Filesystem \ params device="/dev/mapper/vgdata-postgres--lv" directory="/postgres" fstype="ext4" options="acl,noatime,nodiratime" \ meta target-role="Started" primitive fs_srv ocf:heartbeat:Filesystem \ params device="/dev/mapper/vgdata-srv--lv" directory="/srv" fstype="ext4" \ meta target-role="Started" primitive p_drbd_r0 ocf:linbit:drbd \ params drbd_resource="r0-lvm-drbd" \ op monitor interval="29s" role="Master" \ op monitor interval="31s" role="Slave" primitive p_ip ocf:heartbeat:IPaddr2 \ params ip="192.168.10.150" cidr_netmask="24" nic="eth0" \ meta target-role="Started" primitive p_lvm_r0 ocf:heartbeat:LVM \ params volgrpname="vgdata" \ meta target-role="Started" primitive p_psql-server ocf:heartbeat:pgsql \ op monitor interval="30" timeout="30" \ meta is-managed="true" target-role="Started" primitive p_tomcat-server lsb:tomcat-server \ op monitor interval="30s" timeout="20s" \ meta is-managed="true" target-role="Started" group g_webserver p_psql-server p_tomcat-server \ meta is-managed="true" target-role="Started" ms ms_drbd_r0 p_drbd_r0 \ meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1" notify="true" target-role="Started" is-managed="true" colocation c_lvm_on_drbd inf: p_lvm_r0 p_ip ms_drbd_r0:Master order o_drbd_before_lvm inf: ms_drbd_r0:promote p_lvm_r0:start fs_srv:start fs_postgres:start fs_opt:start p_ip:start g_webserver property $id="cib-bootstrap-options" \ dc-version="1.1.10-42f2063" \ cluster-infrastructure="corosync" \ stonith-enabled="false" \ stonith-action="poweroff" \ no-quorum-policy="ignore" \ default-resource-stickiness="100" \ last-lrm-refresh="1402567892"
_______________________________________________ Pacemaker mailing list: Pacemaker@oss.clusterlabs.org http://oss.clusterlabs.org/mailman/listinfo/pacemaker Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org