<div dir="ltr">Hi,<div><br></div><div>i am trying to run postgresql cluster with streaming replication using pgsql RA and pacemaker ..</div><div>i succeded once, master was as PRI, slave HS:sync, failover worked as it should (slave become master) .. </div>
<div>but after some tests something went wrong and i don't know what and why and how to get it back working ... now when i start crm, master is PRI, but slave gets into HS:ASYNC state .. and when master fails, and slave gets into HS:alone state</div>
<div><br></div><div>can somebody please give me hint what should i do or what should i look for?</div><div><br></div><div>Thanks a lot for any help</div><div>Tomas</div><div><br></div><div>my configuration:</div><div><br>
</div><div><div>node jboss-test \</div><div> attributes pgsql-data-status="LATEST"</div><div>node jboss-test2 \</div><div> attributes pgsql-data-status="STREAMING|ASYNC"</div><div>primitive pgsql ocf:heartbeat:pgsql \</div>
<div> params pgctl="/opt/postgres/9.3/bin/pg_ctl" psql="/opt/postgres/9.3/bin/psql" pgdata="/opt/postgres/9.3/data/" rep_mode="sync" node_list="jboss-test jboss-test2" restore_command="cp /opt/postgres/9.3/data/pg_archive/%f %p" primary_conninfo_opt="keepalives_idle=60 keepalives_interval=5 keepalives_count=5" master_ip="172.16.111.120" stop_escalate="0" \</div>
<div> op start interval="0s" timeout="60s" on-fail="restart" \</div><div> op stop interval="0s" timeout="60s" on-fail="block" \</div><div> op monitor interval="11s" timeout="60s" on-fail="restart" \</div>
<div> op monitor interval="10s" role="Master" timeout="60s" on-fail="restart" \</div><div> op promote interval="0s" timeout="60s" on-fail="restart" \</div>
<div> op demote interval="0s" timeout="60s" on-fail="block" \</div><div> op notify interval="0s" timeout="60s"</div><div>primitive pingCheck ocf:pacemaker:ping \</div>
<div> params name="default_ping_set" host_list="172.16.0.1" multiplier="100" \</div><div> op start interval="0s" timeout="60s" on-fail="restart" \</div>
<div> op monitor interval="2s" timeout="60s" on-fail="restart" \</div><div> op stop interval="0s" timeout="60s" on-fail="ignore"</div><div>primitive vip-master ocf:heartbeat:IPaddr2 \</div>
<div> params ip="172.16.111.110" nic="eth0" cidr_netmask="24" \</div><div> op start interval="0s" timeout="60s" on-fail="restart" \</div><div> op monitor interval="10s" timeout="60s" on-fail="restart" \</div>
<div> op stop interval="0s" timeout="60s" on-fail="block"</div><div>primitive vip-rep ocf:heartbeat:IPaddr2 \</div><div> params ip="172.16.111.120" nic="eth0" cidr_netmask="24" \</div>
<div> meta migration-threshold="0" \</div><div> op start interval="0s" timeout="60s" on-fail="stop" \</div><div> op monitor interval="10s" timeout="60s" on-fail="restart" \</div>
<div> op stop interval="0s" timeout="60s" on-fail="block"</div><div>primitive vip-slave ocf:heartbeat:IPaddr2 \</div><div> params ip="172.16.111.111" nic="eth0" cidr_netmask="24" \</div>
<div> meta resource-stickiness="1" \</div><div> op start interval="0s" timeout="60s" on-fail="restart" \</div><div> op monitor interval="10s" timeout="60s" on-fail="restart" \</div>
<div> op stop interval="0s" timeout="60s" on-fail="block"</div><div>group master-group vip-master vip-rep \</div><div> meta ordered="false"</div><div>ms msPostgresql pgsql \</div>
<div> meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1" notify="true"</div><div>clone clnPingCheck pingCheck</div><div>location rsc_location-1 vip-slave \</div>
<div> rule $id="rsc_location-1-rule" 200: pgsql-status eq HS:sync \</div><div> rule $id="rsc_location-1-rule-0" 190: pgsql-status eq HS:async \</div><div> rule $id="rsc_location-1-rule-1" 100: pgsql-status eq PRI \</div>
<div> rule $id="rsc_location-1-rule-2" -inf: not_defined pgsql-status \</div><div> rule $id="rsc_location-1-rule-3" -inf: pgsql-status ne HS:sync and pgsql-status ne PRI and pgsql-status ne HS:async</div>
<div>location rsc_location-2 msPostgresql \</div><div> rule $id="rsc_location-3-rule" -inf: not_defined default_ping_set or default_ping_set lt 100</div><div>colocation rsc_colocation-1 inf: msPostgresql clnPingCheck</div>
<div>colocation rsc_colocation-2 inf: master-group msPostgresql:Master</div><div>order rsc_order-1 0: clnPingCheck msPostgresql</div><div>order rsc_order-2 0: msPostgresql:promote master-group:start symmetrical=false</div>
<div>order rsc_order-3 0: msPostgresql:demote master-group:stop symmetrical=false</div><div>property $id="cib-bootstrap-options" \</div><div> no-quorum-policy="ignore" \</div><div> stonith-enabled="false" \</div>
<div> crmd-transition-delay="0s" \</div><div> dc-version="1.1.6-9971ebba4494012a93c03b40a2c58ec0eb60f50c" \</div><div> cluster-infrastructure="openais" \</div><div> expected-quorum-votes="2" \</div>
<div> last-lrm-refresh="1389301940"</div></div><div><div>rsc_defaults $id="rsc-options" \</div><div> resource-stickiness="INFINITY" \</div><div> migration-threshold="1"</div>
</div><div><br></div><div>crm_mon -Afr:</div><div><div>============</div><div>Last updated: Fri Jan 10 09:46:29 2014</div><div>Last change: Fri Jan 10 09:46:29 2014 by root via crm_attribute on jboss-test</div><div>Stack: openais</div>
<div>Current DC: jboss-test - partition with quorum</div><div>Version: 1.1.6-9971ebba4494012a93c03b40a2c58ec0eb60f50c</div><div>2 Nodes configured, 2 expected votes</div><div>7 Resources configured.</div><div>============</div>
<div><br></div><div>Online: [ jboss-test jboss-test2 ]</div><div><br></div><div>Full list of resources:</div><div><br></div><div> Clone Set: clnPingCheck [pingCheck]</div><div> Started: [ jboss-test jboss-test2 ]</div>
<div> Master/Slave Set: msPostgresql [pgsql]</div><div> Masters: [ jboss-test ]</div><div> Slaves: [ jboss-test2 ]</div><div>vip-slave (ocf::heartbeat:IPaddr2): Started jboss-test2</div><div> Resource Group: master-group</div>
<div> vip-master (ocf::heartbeat:IPaddr2): Started jboss-test</div><div> vip-rep (ocf::heartbeat:IPaddr2): Started jboss-test</div><div><br></div><div>Node Attributes:</div><div>* Node jboss-test:</div>
<div> + default_ping_set : 100</div><div> + master-pgsql:0 : 1000</div><div> + pgsql-data-status : LATEST</div><div> + pgsql-master-baseline : 0000000039004DF0</div>
<div> + pgsql-status : PRI</div><div>* Node jboss-test2:</div><div> + default_ping_set : 100</div><div> + master-pgsql:1 : -INFINITY</div><div> + pgsql-data-status : STREAMING|ASYNC</div>
<div> + pgsql-status : HS:async</div></div><div><br></div></div>