<div dir="ltr"><div><div>Hi all,<br><br></div>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.<br>
<br></div><div>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:<br><br>Failed actions (of cource it is not installed, because of the DRBD....I want to run ALL resources on the same node):<br>
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<br><br>I get the following log message:<br>Jun 12 12:03:50 node1 pgsql(p_psql-server)[6003]: INFO: Don't check /var/lib/pgsql/data during probe<br>
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<br>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<br>
</div><div>Jun 12 12:03:50 node1 crmd[16412]: notice: te_rsc_command: Initiating action 6: probe_complete probe_complete on node1 (local) - no waiting<br>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<br>
Jun 12 12:03:50 node1 pengine[16411]: notice: unpack_config: On loss of CCM Quorum: Ignore<br>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<br>
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)<br>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)<br>
<br></div><div>But it's started:<br> Node node1 (739670273): online<br> fs_postgres (ocf::heartbeat:Filesystem): Started <br> p_tomcat-server (lsb:tomcat-server): Started<br> p_lvm_r0 (ocf::heartbeat:LVM): Started<br>
p_drbd_r0 (ocf::linbit:drbd): Master<br> p_ip (ocf::heartbeat:IPaddr2): Started<br> fs_opt (ocf::heartbeat:Filesystem): Started<br> fs_srv (ocf::heartbeat:Filesystem): Started<br>
p_psql-server (ocf::heartbeat:pgsql): Started<br> Node snode2 (739670274): online<br> p_drbd_r0 (ocf::linbit:drbd): Started<br><br><br></div><div>My Config:<br><br>node $id="739670273" node1 \<br>
attributes standby="off"<br>node $id="739670274" node2 \<br> attributes standby="off"<br>primitive fs_opt ocf:heartbeat:Filesystem \<br> params device="/dev/mapper/vgdata-opt--lv" directory="/opt" fstype="ext4" \<br>
meta target-role="Started"<br>primitive fs_postgres ocf:heartbeat:Filesystem \<br> params device="/dev/mapper/vgdata-postgres--lv" directory="/postgres" fstype="ext4" options="acl,noatime,nodiratime" \<br>
meta target-role="Started"<br>primitive fs_srv ocf:heartbeat:Filesystem \<br> params device="/dev/mapper/vgdata-srv--lv" directory="/srv" fstype="ext4" \<br> meta target-role="Started"<br>
primitive p_drbd_r0 ocf:linbit:drbd \<br> params drbd_resource="r0-lvm-drbd" \<br> op monitor interval="29s" role="Master" \<br> op monitor interval="31s" role="Slave"<br>
primitive p_ip ocf:heartbeat:IPaddr2 \<br> params ip="192.168.10.150" cidr_netmask="24" nic="eth0" \<br> meta target-role="Started"<br>primitive p_lvm_r0 ocf:heartbeat:LVM \<br>
params volgrpname="vgdata" \<br> meta target-role="Started"<br>primitive p_psql-server ocf:heartbeat:pgsql \<br> op monitor interval="30" timeout="30" \<br> meta is-managed="true" target-role="Started"<br>
primitive p_tomcat-server lsb:tomcat-server \<br> op monitor interval="30s" timeout="20s" \<br> meta is-managed="true" target-role="Started"<br>group g_webserver p_psql-server p_tomcat-server \<br>
meta is-managed="true" target-role="Started"<br>ms ms_drbd_r0 p_drbd_r0 \<br> meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1" notify="true" target-role="Started" is-managed="true"<br>
colocation c_lvm_on_drbd inf: p_lvm_r0 p_ip ms_drbd_r0:Master<br>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<br>property $id="cib-bootstrap-options" \<br>
dc-version="1.1.10-42f2063" \<br> cluster-infrastructure="corosync" \<br> stonith-enabled="false" \<br> stonith-action="poweroff" \<br> no-quorum-policy="ignore" \<br>
default-resource-stickiness="100" \<br> last-lrm-refresh="1402567892"<br><br></div></div>