Hi
I try to configure simple two nodes(Master/Slave) MYSQL/DRBD/PACEMAKER
with MYSQL replication but it does not work. Everytime I start
mysql(M/S) RA,it won't start with these error below. PLease help if you
see if I am doing anything wrong ( attached crm configure show). thank
you.
( Failed actions:
p_mysql:0_monitor_0 (node=mysqldrbd02, call=501, rc=5,
status=complete): not installed
p_mysql:1_monitor_0 (node=mysqldrbd01, call=251, rc=5,
status=complete): not installed
Reconnecting...[root@mysqldrbd01 etc]# tail -f /var/log/messages
Nov 7 14:33:13 mysqldrbd01 crmd: [8610]: info: run_graph:
====================================================
Nov 7 14:33:13 mysqldrbd01 crmd: [8610]: notice: run_graph: Transition
795 (Complete=6, Pending=0, Fired=0, Skipped=0, Incomplete=0,
Source=/var/lib/pengine/pe-input-895.bz2): Complete
Nov 7 14:33:13 mysqldrbd01 crmd: [8610]: info: te_graph_trigger:
Transition 795 is now complete
Nov 7 14:33:13 mysqldrbd01 crmd: [8610]: info: notify_crmd: Transition
795 status: done - <null>
Nov 7 14:33:13 mysqldrbd01 crmd: [8610]: info: do_state_transition:
State transition S_TRANSITION_ENGINE -> S_IDLE [ input=I_TE_SUCCESS
cause=C_FSA_INTERNAL origin=notify_crmd ]
Nov 7 14:33:13 mysqldrbd01 crmd: [8610]: info: do_state_transition:
Starting PEngine Recheck Timer
Nov 7 14:33:13 mysqldrbd01 cibadmin: [28166]: info: Invoked:
/usr/sbin/cibadmin -Ql
Nov 7 14:33:13 mysqldrbd01 cibadmin: [28171]: info: Invoked:
/usr/sbin/cibadmin -Ql
Nov 7 14:33:17 mysqldrbd01 lrmd: [8607]: info: RA output:
(FAILOVER-ADDR:start:stderr) ARPING 192.168.1.160 from 192.168.1.160
eth1 Sent 5 probes (5 broadcast(s)) Received 0 response(s)
Nov 7 14:33:33 mysqldrbd01 cibadmin: [28513]: info: Invoked: cibadmin -Ql
Nov 7 14:34:08 mysqldrbd01 cibadmin: [28974]: info: Invoked:
/usr/sbin/cibadmin -Ql
Nov 7 14:34:08 mysqldrbd01 crm_resource: [28975]: info: Invoked:
/usr/sbin/crm_resource --meta -t primitive -r p_mysql -p target-role -v
started
Nov 7 14:34:08 mysqldrbd01 crm_resource: [28986]: info: Invoked:
/usr/sbin/crm_resource --meta -t primitive -r p_mysql -p target-role -v
started
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <cib admin_epoch="0" epoch="244" num_updates="24" >
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <configuration >
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <resources >
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <master id="ms_mysql" >
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <primitive id="p_mysql" >
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <meta_attributes id="p_mysql-meta_attributes" >
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <nvpair value="stopped"
id="p_mysql-meta_attributes-target-role" />
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </meta_attributes>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </primitive>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </master>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </resources>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </configuration>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: abort_transition_graph:
need_abort:59 - Triggered transition abort (complete=1) : Non-status change
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </cib>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: need_abort: Aborting on
change to admin_epoch
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <cib admin_epoch="0" epoch="245" num_updates="1" >
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_state_transition:
State transition S_IDLE -> S_POLICY_ENGINE [ input=I_PE_CALC
cause=C_FSA_INTERNAL origin=abort_transition_graph ]
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <configuration >
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_state_transition: All
2 cluster nodes are eligible to run resources.
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <resources >
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_pe_invoke: Query
1487: Requesting the current CIB: S_POLICY_ENGINE
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <master id="ms_mysql" >
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <primitive id="p_mysql" >
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <meta_attributes id="p_mysql-meta_attributes" >
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <nvpair value="started"
id="p_mysql-meta_attributes-target-role" />
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </meta_attributes>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </primitive>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </master>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </resources>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </configuration>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </cib>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: cib_process_request:
Operation complete: op cib_modify for section resources
(origin=local/crm_resource/4, version=0.245.1): ok (rc=0)
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_pe_invoke_callback:
Invoking the PE: query=1487, ref=pe_calc-dc-1320698048-1740, seq=1368,
quorate=1
Nov 7 14:34:08 mysqldrbd01 cib: [28988]: info: write_cib_contents:
Archived previous version as /var/lib/heartbeat/crm/cib-29.raw
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: unpack_config: On
loss of CCM Quorum: Ignore
Nov 7 14:34:08 mysqldrbd01 cib: [28988]: info: write_cib_contents:
Wrote version 0.245.0 of the CIB to disk (digest:
031a742e444fdb356e1d0657a8a1f516)
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: unpack_config: Node
scores: 'red' = -INFINITY, 'yellow' = 0, 'green' = 0
Nov 7 14:34:08 mysqldrbd01 cib: [28988]: info: retrieveCib: Reading
cluster configuration from: /var/lib/heartbeat/crm/cib.mHBHHN (digest:
/var/lib/heartbeat/crm/cib.66XEVP)
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info:
determine_online_status: Node mysqldrbd02 is online
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info:
determine_online_status: Node mysqldrbd01 is online
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op:
Operation DRBD:0_monitor_0 found resource DRBD:0 active on mysqldrbd02
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op: Hard
error - p_mysql:0_monitor_0 failed with rc=5: Preventing ms_mysql from
re-starting on mysqldrbd02
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: find_clone:
Internally renamed DRBD:0 on mysqldrbd01 to DRBD:1
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op:
Operation DRBD:0_monitor_0 found resource DRBD:1 active in master mode
on mysqldrbd01
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op: Hard
error - p_mysql:1_monitor_0 failed with rc=5: Preventing ms_mysql from
re-starting on mysqldrbd01
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: group_print:
Resource Group: AP-CLUST
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: native_print:
SRV-MOUNT (ocf::heartbeat:Filesystem): Started mysqldrbd01
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: native_print:
FAILOVER-ADDR (ocf::heartbeat:IPaddr2): Started mysqldrbd01
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: clone_print:
Master/Slave Set: DRBD-DATA
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: short_print:
Masters: [ mysqldrbd01 ]
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: short_print:
Slaves: [ mysqldrbd02 ]
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: clone_print: Clone
Set: PING-NET-CLONE
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: short_print:
Started: [ mysqldrbd02 mysqldrbd01 ]
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: clone_print:
Master/Slave Set: ms_mysql
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: short_print:
Stopped: [ p_mysql:0 p_mysql:1 ]
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: master_color:
Promoting DRBD:1 (Master mysqldrbd01)
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: master_color:
DRBD-DATA: Promoted 1 instances of a possible 1 to master
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: master_color:
Promoting DRBD:1 (Master mysqldrbd01)
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: master_color:
DRBD-DATA: Promoted 1 instances of a possible 1 to master
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: native_color:
Resource p_mysql:0 cannot run anywhere
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: native_color:
Resource p_mysql:1 cannot run anywhere
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: master_color:
ms_mysql: Promoted 0 instances of a possible 1 to master
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave
resource SRV-MOUNT (Started mysqldrbd01)
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave
resource FAILOVER-ADDR (Started mysqldrbd01)
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave
resource DRBD:0 (Slave mysqldrbd02)
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave
resource DRBD:1 (Master mysqldrbd01)
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave
resource PING-NET:0 (Started mysqldrbd02)
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave
resource PING-NET:1 (Started mysqldrbd01)
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave
resource p_mysql:0 (Stopped)
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave
resource p_mysql:1 (Stopped)
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_state_transition:
State transition S_POLICY_ENGINE -> S_TRANSITION_ENGINE [
input=I_PE_SUCCESS cause=C_IPC_MESSAGE origin=handle_response ]
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: unpack_graph: Unpacked
transition 796: 0 actions in 0 synapses
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_te_invoke: Processing
graph 796 (ref=pe_calc-dc-1320698048-1740) derived from
/var/lib/pengine/pe-input-896.bz2
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: run_graph:
====================================================
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: notice: run_graph: Transition
796 (Complete=0, Pending=0, Fired=0, Skipped=0, Incomplete=0,
Source=/var/lib/pengine/pe-input-896.bz2): Complete
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: te_graph_trigger:
Transition 796 is now complete
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: notify_crmd: Transition
796 status: done - <null>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_state_transition:
State transition S_TRANSITION_ENGINE -> S_IDLE [ input=I_TE_SUCCESS
cause=C_FSA_INTERNAL origin=notify_crmd ]
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_state_transition:
Starting PEngine Recheck Timer
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: process_pe_message:
Transition 796: PEngine Input stored in: /var/lib/pengine/pe-input-896.bz2
Nov 7 14:34:08 mysqldrbd01 cibadmin: [28990]: info: Invoked:
/usr/sbin/cibadmin -Ql
Nov 7 14:34:21 mysqldrbd01 cibadmin: [29177]: info: Invoked:
/usr/sbin/cibadmin -Ql
Nov 7 14:34:21 mysqldrbd01 crm_resource: [29178]: info: Invoked:
/usr/sbin/crm_resource --meta -t primitive -r p_mysql -p target-role -v
stopped
Nov 7 14:34:23 mysqldrbd01 crm_resource: [29190]: info: Invoked:
/usr/sbin/crm_resource --meta -t primitive -r p_mysql -p target-role -v
stopped
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <cib admin_epoch="0" epoch="245" num_updates="1" >
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <configuration >
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <resources >
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <master id="ms_mysql" >
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <primitive id="p_mysql" >
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <meta_attributes id="p_mysql-meta_attributes" >
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <nvpair value="started"
id="p_mysql-meta_attributes-target-role" />
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </meta_attributes>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </primitive>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </master>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </resources>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </configuration>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: abort_transition_graph:
need_abort:59 - Triggered transition abort (complete=1) : Non-status change
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </cib>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: need_abort: Aborting on
change to admin_epoch
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <cib admin_epoch="0" epoch="246" num_updates="1" >
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_state_transition:
State transition S_IDLE -> S_POLICY_ENGINE [ input=I_PE_CALC
cause=C_FSA_INTERNAL origin=abort_transition_graph ]
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <configuration >
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_state_transition: All
2 cluster nodes are eligible to run resources.
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <resources >
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_pe_invoke: Query
1488: Requesting the current CIB: S_POLICY_ENGINE
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <master id="ms_mysql" >
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <primitive id="p_mysql" >
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <meta_attributes id="p_mysql-meta_attributes" >
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <nvpair value="stopped"
id="p_mysql-meta_attributes-target-role" />
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </meta_attributes>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </primitive>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </master>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </resources>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </configuration>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </cib>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: cib_process_request:
Operation complete: op cib_modify for section resources
(origin=local/crm_resource/4, version=0.246.1): ok (rc=0)
Nov 7 14:34:23 mysqldrbd01 cib: [29192]: info: write_cib_contents:
Archived previous version as /var/lib/heartbeat/crm/cib-30.raw
Nov 7 14:34:23 mysqldrbd01 cib: [29192]: info: write_cib_contents:
Wrote version 0.246.0 of the CIB to disk (digest:
b2c10b5780b5ffd9825112ab624861b5)
Nov 7 14:34:23 mysqldrbd01 cib: [29192]: info: retrieveCib: Reading
cluster configuration from: /var/lib/heartbeat/crm/cib.blvW7w (digest:
/var/lib/heartbeat/crm/cib.zrI8Li)
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_pe_invoke_callback:
Invoking the PE: query=1488, ref=pe_calc-dc-1320698063-1741, seq=1368,
quorate=1
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: unpack_config: On
loss of CCM Quorum: Ignore
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: unpack_config: Node
scores: 'red' = -INFINITY, 'yellow' = 0, 'green' = 0
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info:
determine_online_status: Node mysqldrbd02 is online
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info:
determine_online_status: Node mysqldrbd01 is online
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op:
Operation DRBD:0_monitor_0 found resource DRBD:0 active on mysqldrbd02
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op: Hard
error - p_mysql:0_monitor_0 failed with rc=5: Preventing ms_mysql from
re-starting on mysqldrbd02
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: find_clone:
Internally renamed DRBD:0 on mysqldrbd01 to DRBD:1
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op:
Operation DRBD:0_monitor_0 found resource DRBD:1 active in master mode
on mysqldrbd01
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op: Hard
error - p_mysql:1_monitor_0 failed with rc=5: Preventing ms_mysql from
re-starting on mysqldrbd01
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: group_print:
Resource Group: AP-CLUST
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: native_print:
SRV-MOUNT (ocf::heartbeat:Filesystem): Started mysqldrbd01
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: native_print:
FAILOVER-ADDR (ocf::heartbeat:IPaddr2): Started mysqldrbd01
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: clone_print:
Master/Slave Set: DRBD-DATA
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: short_print:
Masters: [ mysqldrbd01 ]
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: short_print:
Slaves: [ mysqldrbd02 ]
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: clone_print: Clone
Set: PING-NET-CLONE
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: short_print:
Started: [ mysqldrbd02 mysqldrbd01 ]
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: clone_print:
Master/Slave Set: ms_mysql
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: short_print:
Stopped: [ p_mysql:0 p_mysql:1 ]
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: master_color:
Promoting DRBD:1 (Master mysqldrbd01)
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: master_color:
DRBD-DATA: Promoted 1 instances of a possible 1 to master
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: master_color:
Promoting DRBD:1 (Master mysqldrbd01)
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: master_color:
DRBD-DATA: Promoted 1 instances of a possible 1 to master
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: native_color:
Resource p_mysql:0 cannot run anywhere
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: native_color:
Resource p_mysql:1 cannot run anywhere
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: master_color:
ms_mysql: Promoted 0 instances of a possible 1 to master
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave
resource SRV-MOUNT (Started mysqldrbd01)
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave
resource FAILOVER-ADDR (Started mysqldrbd01)
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave
resource DRBD:0 (Slave mysqldrbd02)
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave
resource DRBD:1 (Master mysqldrbd01)
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave
resource PING-NET:0 (Started mysqldrbd02)
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave
resource PING-NET:1 (Started mysqldrbd01)
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave
resource p_mysql:0 (Stopped)
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave
resource p_mysql:1 (Stopped)
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_state_transition:
State transition S_POLICY_ENGINE -> S_TRANSITION_ENGINE [
input=I_PE_SUCCESS cause=C_IPC_MESSAGE origin=handle_response ]
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: process_pe_message:
Transition 797: PEngine Input stored in: /var/lib/pengine/pe-input-897.bz2
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: unpack_graph: Unpacked
transition 797: 0 actions in 0 synapses
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_te_invoke: Processing
graph 797 (ref=pe_calc-dc-1320698063-1741) derived from
/var/lib/pengine/pe-input-897.bz2
Nov 7 14:34:23 mysqldrbd01 cibadmin: [29194]: info: Invoked:
/usr/sbin/cibadmin -Ql
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: run_graph:
====================================================
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: notice: run_graph: Transition
797 (Complete=0, Pending=0, Fired=0, Skipped=0, Incomplete=0,
Source=/var/lib/pengine/pe-input-897.bz2): Complete
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: te_graph_trigger:
Transition 797 is now complete
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: notify_crmd: Transition
797 status: done - <null>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_state_transition:
State transition S_TRANSITION_ENGINE -> S_IDLE [ input=I_TE_SUCCESS
cause=C_FSA_INTERNAL origin=notify_crmd ]
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_state_transition:
Starting PEngine Recheck Timer
++++++++++++++++++++++++++++++++++++++
crm configure show:
----------------------
[root@mysqldrbd01 etc]# crm configure show
node mysqldrbd01 \
attributes standby="off"
node mysqldrbd02 \
attributes standby="off"
primitive DRBD ocf:linbit:drbd \
params drbd_resource="repdata" \
operations $id="DRBD-operations" \
op start interval="0" timeout="240" \
op stop interval="0" timeout="100" \
op monitor interval="120" \
meta target-role="started"
primitive FAILOVER-ADDR ocf:heartbeat:IPaddr2 \
params ip="192.168.1.160" nic="eth1" \
operations $id="FAILOVER-ADDR-operations" \
op monitor start-delay="0" interval="10" \
meta target-role="started"
primitive PING-NET ocf:pacemaker:ping \
params dampen="5s" multiplier="100" host_list="192.168.209.4" \
op monitor interval="60s" timeout="60" \
op start interval="0" timeout="60s" \
op stop interval="0" timeout="60s" \
meta target-role="started"
primitive SRV-MOUNT ocf:heartbeat:Filesystem \
params device="/dev/drbd0" directory="/data/" fstype="ext3" \
operations $id="SRV-MOUNT-operations" \
op start interval="0" timeout="60" \
op stop interval="0" timeout="60" \
meta target-role="started"
*primitive p_mysql ocf:heartbeat:mysql \
params binary="/usr/bin/mysqld_safe" \
operations $id="p_mysql-operations" \
op start interval="0" timeout="120" \
op promote interval="0" timeout="120" \
op demote interval="0" timeout="120" \
op stop interval="0" timeout="120" \
op monitor interval="10" timeout="30" start-delay="0" \
meta target-role="stopped"*
group AP-CLUST SRV-MOUNT FAILOVER-ADDR
*ms DRBD-DATA DRBD \
meta clone-max="2" notify="true" target-role="started"
ms ms_mysql p_mysql \
meta clone-max="2"*
clone PING-NET-CLONE PING-NET
location connected_node DRBD-DATA \
rule $id="connected_node-rule" -inf: not_defined pingd or pingd
lte 0
location master-prefer-node-1 FAILOVER-ADDR 25: mysqldrbd01
colocation AP-CLUST_on_DRBD inf: AP-CLUST DRBD-DATA:Master
order AP-CLUST_after_DRBD-DATA inf: DRBD-DATA:promote AP-CLUST:start
property $id="cib-bootstrap-options" \
expected-quorum-votes="2" \
stonith-enabled="false" \
dc-version="1.0.11-1554a83db0d3c3e546cfd3aaff6af1184f79ee87" \
no-quorum-policy="ignore" \
cluster-infrastructure="openais" \
last-lrm-refresh="1320686593"
rsc_defaults $id="rsc-options" \
resource-stickiness="100"
_______________________________________________
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://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker
