Re: Unable to start any node of pgsql Master/Slave Cluster
Oliver Weichhold <[email protected]>
| Newsgroups | gmane.linux.highavailability.user |
|---|---|
| Message-ID | <[email protected]> |
CIB Dump:
<cib admin_epoch="50" epoch="73" num_updates="7"
validate-with="pacemaker-1.2" cib-last-written="Thu Sep 18 11:50:17 2014"
update-origin="node1" update-client="crmd" crm_feature_set="3.0.7"
have-quorum="0" dc-uuid="1">
<configuration>
<crm_config>
<cluster_property_set id="cib-bootstrap-options">
<nvpair id="cib-bootstrap-options-no-quorum-policy"
name="no-quorum-policy" value="ignore"/>
<nvpair id="cib-bootstrap-options-stonith-enabled"
name="stonith-enabled" value="false"/>
<nvpair id="cib-bootstrap-options-dc-version" name="dc-version"
value="1.1.10-32.el7_0-368c726"/>
<nvpair id="cib-bootstrap-options-cluster-infrastructure"
name="cluster-infrastructure" value="corosync"/>
<nvpair id="cib-bootstrap-options-last-lrm-refresh"
name="last-lrm-refresh" value="1411055417"/>
</cluster_property_set>
</crm_config>
<nodes>
<node id="1" uname="node1"/>
<node id="2" uname="node2"/>
</nodes>
<resources>
<master id="pgsql_master_slave">
<primitive class="ocf" id="pgsql" provider="heartbeat" type="pgsql">
<instance_attributes id="pgsql-instance_attributes">
<nvpair id="pgsql-instance_attributes-pgctl" name="pgctl"
value="/usr/pgsql-9.3/bin/pg_ctl"/>
<nvpair id="pgsql-instance_attributes-psql" name="psql"
value="/usr/pgsql-9.3/bin/psql"/>
<nvpair id="pgsql-instance_attributes-pgdata" name="pgdata"
value="/var/lib/pgsql/9.3/data/"/>
<nvpair id="pgsql-instance_attributes-rep_mode" name="rep_mode"
value="async"/>
<nvpair id="pgsql-instance_attributes-node_list"
name="node_list" value="node1 node2"/>
<nvpair id="pgsql-instance_attributes-tmpdir" name="tmpdir"
value="/var/lib/pgsql/9.3/data/ra_tmp"/>
<nvpair id="pgsql-instance_attributes-restore_command"
name="restore_command" value="cp /var/lib/pgsql/9.3/data/pg_archive/%f %p"/>
<nvpair id="pgsql-instance_attributes-primary_conninfo_opt"
name="primary_conninfo_opt" value="keepalives_idle=60 keepalives_interval=5
keepalives_count=5"/>
<nvpair id="pgsql-instance_attributes-master_ip"
name="master_ip" value="10.1.1.7"/>
<nvpair id="pgsql-instance_attributes-restart_on_promote"
name="restart_on_promote" value="true"/>
</instance_attributes>
<operations>
<op id="pgsql-start-interval-0s" interval="0s" name="start"
on-fail="restart" timeout="60s"/>
<op id="pgsql-monitor-interval-4s" interval="4s" name="monitor"
on-fail="restart" timeout="60s"/>
<op id="pgsql-monitor-interval-3s" interval="3s" name="monitor"
on-fail="restart" role="Master" timeout="60s"/>
<op id="pgsql-promote-interval-0s" interval="0s" name="promote"
on-fail="restart" timeout="60s"/>
<op id="pgsql-demote-interval-0s" interval="0s" name="demote"
on-fail="stop" timeout="60s"/>
<op id="pgsql-stop-interval-0s" interval="0s" name="stop"
on-fail="block" timeout="60s"/>
</operations>
</primitive>
<meta_attributes id="pgsql_master_slave-meta_attributes">
<nvpair id="pgsql_master_slave-meta_attributes-master-max"
name="master-max" value="1"/>
<nvpair id="pgsql_master_slave-meta_attributes-master-node-max"
name="master-node-max" value="1"/>
<nvpair id="pgsql_master_slave-meta_attributes-clone-max"
name="clone-max" value="2"/>
<nvpair id="pgsql_master_slave-meta_attributes-clone-node-max"
name="clone-node-max" value="1"/>
<nvpair id="pgsql_master_slave-meta_attributes-notify"
name="notify" value="true"/>
</meta_attributes>
</master>
<group id="master-group">
<primitive class="ocf" id="pgsql_vip_rep" provider="heartbeat"
type="IPaddr2">
<instance_attributes id="pgsql_vip_rep-instance_attributes">
<nvpair id="pgsql_vip_rep-instance_attributes-ip" name="ip"
value="10.1.1.7"/>
<nvpair id="pgsql_vip_rep-instance_attributes-nic" name="nic"
value="tun0"/>
<nvpair id="pgsql_vip_rep-instance_attributes-cidr_netmask"
name="cidr_netmask" value="24"/>
</instance_attributes>
<operations>
<op id="pgsql_vip_rep-start-interval-0s" interval="0s"
name="start" on-fail="stop" timeout="60s"/>
<op id="pgsql_vip_rep-monitor-interval-10s" interval="10s"
name="monitor" on-fail="restart" timeout="60s"/>
<op id="pgsql_vip_rep-stop-interval-0s" interval="0s"
name="stop" on-fail="ignore" timeout="60s"/>
</operations>
<meta_attributes id="pgsql_vip_rep-meta_attributes">
<nvpair id="pgsql_vip_rep-meta_attributes-migration-threshold"
name="migration-threshold" value="0"/>
</meta_attributes>
</primitive>
<primitive class="ocf" id="pgsql_forward_listen_port"
provider="heartbeat" type="portforward">
<instance_attributes
id="pgsql_forward_listen_port-instance_attributes">
<nvpair
id="pgsql_forward_listen_port-instance_attributes-srcport" name="srcport"
value="5433"/>
<nvpair
id="pgsql_forward_listen_port-instance_attributes-dstport" name="dstport"
value="5432"/>
<nvpair
id="pgsql_forward_listen_port-instance_attributes-protocol" name="protocol"
value="tcp"/>
</instance_attributes>
<operations>
<op id="pgsql_forward_listen_port-start-timeout-20"
interval="0s" name="start" timeout="20"/>
<op id="pgsql_forward_listen_port-stop-timeout-20" interval="0s"
name="stop" timeout="20"/>
<op id="pgsql_forward_listen_port-monitor-interval-5s"
interval="5s" name="monitor"/>
</operations>
</primitive>
</group>
</resources>
<constraints>
<rsc_colocation
id="colocation-master-group-pgsql_master_slave-INFINITY" rsc="master-group"
rsc-role="Started" score="INFINITY" with-rsc="pgsql_master_slave"
with-rsc-role="Master"/>
<rsc_order first="pgsql_master_slave" first-action="promote"
id="order-pgsql_master_slave-master-group-INFINITY" score="INFINITY"
symmetrical="false" then="master-group" then-action="start"/>
<rsc_order first="pgsql_master_slave" first-action="demote"
id="order-pgsql_master_slave-master-group-0" score="0" symmetrical="false"
then="master-group" then-action="stop"/>
</constraints>
<rsc_defaults>
<meta_attributes id="rsc_defaults-options">
<nvpair id="rsc_defaults-options-resource-stickiness"
name="resource-stickiness" value="INFINITY"/>
<nvpair id="rsc_defaults-options-migration-threshold"
name="migration-threshold" value="1"/>
</meta_attributes>
</rsc_defaults>
</configuration>
<status>
<node_state id="1" uname="node1" in_ccm="true" crmd="online"
crm-debug-origin="do_update_resource" join="member" expected="member">
<lrm id="1">
<lrm_resources>
<lrm_resource id="pgsql_forward_listen_port" type="portforward"
class="ocf" provider="heartbeat">
<lrm_rsc_op id="pgsql_forward_listen_port_last_0"
operation_key="pgsql_forward_listen_port_monitor_0" operation="monitor"
crm-debug-origin="do_update_resource" crm_feature_set="3.0.7"
transition-key="6:13:7:2b32876f-fe95-470b-b770-9c34a79944e9"
transition-magic="0:7;6:13:7:2b32876f-fe95-470b-b770-9c34a79944e9"
call-id="78" rc-code="7" op-status="0" interval="0" last-run="1411055417"
last-rc-change="1411055417" exec-time="137" queue-time="0"
op-digest="8efe4e9ed1afd487e598578eef7352df"/>
</lrm_resource>
<lrm_resource id="pgsql_vip_rep" type="IPaddr2" class="ocf"
provider="heartbeat">
<lrm_rsc_op id="pgsql_vip_rep_last_0"
operation_key="pgsql_vip_rep_monitor_0" operation="monitor"
crm-debug-origin="do_update_resource" crm_feature_set="3.0.7"
transition-key="5:13:7:2b32876f-fe95-470b-b770-9c34a79944e9"
transition-magic="0:7;5:13:7:2b32876f-fe95-470b-b770-9c34a79944e9"
call-id="74" rc-code="7" op-status="0" interval="0" last-run="1411055417"
last-rc-change="1411055417" exec-time="326" queue-time="0"
op-digest="9d672e70b2c9726a4cb571becf2b04b4"/>
</lrm_resource>
<lrm_resource id="pgsql" type="pgsql" class="ocf"
provider="heartbeat">
<lrm_rsc_op id="pgsql_last_failure_0"
operation_key="pgsql_monitor_0" operation="monitor"
crm-debug-origin="do_update_resource" crm_feature_set="3.0.7"
transition-key="4:13:7:2b32876f-fe95-470b-b770-9c34a79944e9"
transition-magic="0:1;4:13:7:2b32876f-fe95-470b-b770-9c34a79944e9"
call-id="70" rc-code="1" op-status="0" interval="0" last-run="1411055417"
last-rc-change="1411055417" exec-time="526" queue-time="0"
op-digest="489ca265de0844a902bea5974ac07875"/>
<lrm_rsc_op id="pgsql_last_0" operation_key="pgsql_stop_0"
operation="stop" crm-debug-origin="do_update_resource"
crm_feature_set="3.0.7"
transition-key="1:14:0:2b32876f-fe95-470b-b770-9c34a79944e9"
transition-magic="0:0;1:14:0:2b32876f-fe95-470b-b770-9c34a79944e9"
call-id="80" rc-code="0" op-status="0" interval="0" last-run="1411055418"
last-rc-change="1411055418" exec-time="3580" queue-time="0"
op-digest="489ca265de0844a902bea5974ac07875"/>
</lrm_resource>
</lrm_resources>
</lrm>
<transient_attributes id="1">
<instance_attributes id="status-1">
<nvpair id="status-1-probe_complete" name="probe_complete"
value="true"/>
<nvpair id="status-1-pgsql-status" name="pgsql-status"
value="STOP"/>
<nvpair id="status-1-master-pgsql" name="master-pgsql"
value="-INFINITY"/>
<nvpair id="status-1-last-failure-pgsql" name="last-failure-pgsql"
value="1411055416"/>
<nvpair id="status-1-pgsql-data-status" name="pgsql-data-status"
value="LATEST"/>
<nvpair id="status-1-fail-count-pgsql" name="fail-count-pgsql"
value="INFINITY"/>
</instance_attributes>
</transient_attributes>
</node_state>
</status>
</cib>
--
View this message in context: http://linux-ha.996297.n3.nabble.com/Unable-to-start-any-node-of-pgsql-Master-Slave-Cluster-tp15816p15817.html
Sent from the Linux-HA mailing list archive at Nabble.com.
_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems