MySQL slaves don't come back up with slave config

--===============0478774537==
Content-Type: multipart/signed; boundary="Apple-Mail=_2E71930E-3E5E-424C-B54C-EF93E3C931CA"; protocol="application/pgp-signature"; micalg=pgp-sha1


--Apple-Mail=_2E71930E-3E5E-424C-B54C-EF93E3C931CA
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

I=E2=80=99ve configured 6 nodes as mysql master/slave using this config:

primitive p_mysql ocf:heartbeat:mysql \
        params socket=3D"/var/run/mysqld/mysqld.sock" =
replication_user=3D"slave" replication_passwd=3D=E2=80=9CXXXXX" =
test_user=3D"test_user" test_passwd=3D"test_pass" \
        op start interval=3D"0" timeout=3D"120s" \
        op stop interval=3D"0" timeout=3D"120s" \
        op monitor timeout=3D"30s" interval=3D"30s" role=3D"Master" =
OCF_CHECK_LEVEL=3D"10" \
        op monitor timeout=3D"30s" interval=3D"60s" role=3D"Slave" =
OCF_CHECK_LEVEL=3D"10"
primitive p_mysql-ip ocf:heartbeat:IPaddr \
        params ip=3D"10.10.10.191" \
        op monitor interval=3D"1s" timeout=3D"20s" \
        op start interval=3D"0" timeout=3D"20s" \
        op stop interval=3D"0" timeout=3D"20s" \
        meta is-managed=3D"true" resource-stickiness=3D"500"
ms cl_mysql p_mysql
colocation co_ip-on-mysql inf: p_mysql-ip cl_mysql:Master

On the initial setup, everything looks good. The slaves are all =
reporting proper status. However, if I reboot one of the slaves, even =
though it is reported in crm status as a slave, the mysql server shows =
that slave status is not configured or started on that node and log =
shows:

Aug 23 08:44:35 [1204] app5       lrmd:     info: log_execute: 	=
executing - rsc:p_mysql action:start call_id:99
mysql(p_mysql)[1562]:	2015/08/23_08:44:35 INFO: MySQL is not running
mysql(p_mysql)[1562]:	2015/08/23_08:44:35 INFO: Creating PID dir: =
/var/run/mysqld
mysql(p_mysql)[1562]:	2015/08/23_08:44:35 INFO: MySQL is not running
mysql(p_mysql)[1562]:	2015/08/23_08:44:37 INFO: MySQL is not running
mysql(p_mysql)[1562]:	2015/08/23_08:44:41 INFO: No MySQL master =
present - clearing replication state
mysql(p_mysql)[1562]:	2015/08/23_08:44:41 ERROR: check_slave invoked =
on an instance that is not a replication slave.
mysql(p_mysql)[1562]:	2015/08/23_08:44:41 WARNING: Attempted to unset =
the replication master on an instance that is not configured as a =
replication slave
Aug 23 08:44:42 [1205] app5      attrd:   notice: attrd_trigger_update: 	=
Sending flush op to all hosts for: master-p_mysql (1)
Aug 23 08:44:42 [1202] app5        cib:     info: cib_process_request: 	=
Completed cib_query operation for section =
//cib/status//node_state[@id=3D'168430230']//transient_attributes//nvpair[=
@name=3D'master-p_mysql']: No such device or address (rc=3D-6, =
origin=3Dlocal/attrd/26, version=3D0.554.409)
Aug 23 08:44:42 [1205] app5      attrd:   notice: attrd_perform_update: 	=
Sent update 28: master-p_mysql=3D1
mysql(p_mysql)[1562]:	2015/08/23_08:44:42 ERROR: check_slave invoked =
on an instance that is not a replication slave.
mysql(p_mysql)[1562]:	2015/08/23_08:44:42 INFO: MySQL started
Aug 23 08:44:42 [1204] app5       lrmd:   notice: operation_finished: 	=
p_mysql_start_0:1562:stderr [ Error performing operation: No such device =
or address ]
Aug 23 08:44:42 [1204] app5       lrmd:     info: log_finished: 	=
finished - rsc:p_mysql action:start call_id:99 pid:1562 exit-code:0 =
exec-time:6509ms queue-time:0ms
Aug 23 08:44:42 [1207] app5       crmd:   notice: process_lrm_event: 	=
LRM operation p_mysql_start_0 (call=3D99, rc=3D0, cib-update=3D28, =
confirmed=3Dtrue) ok
Aug 23 08:44:42 [1207] app5       crmd:     info: do_lrm_rsc_op: 	=
Performing key=3D64:347:0:429cc780-9827-42f4-b638-7d4ba43a1c6c =
op=3Dp_mysql_monitor_60000
mysql(p_mysql)[2399]:	2015/08/23_08:44:42 ERROR: check_slave invoked =
on an instance that is not a replication slave.
Aug 23 08:44:42 [1207] app5       crmd:   notice: process_lrm_event: 	=
LRM operation p_mysql_monitor_60000 (call=3D106, rc=3D0, cib-update=3D29, =
confirmed=3Dfalse) ok
mysql(p_mysql)[2762]:	2015/08/23_08:45:42 ERROR: check_slave invoked =
on an instance that is not a replication slave.

=46rom here, the last message is reported at every monitor interval. =
I=E2=80=99m unsure why these happens, and could use some help. Thanks.

=E2=80=94
Cyphre    : http://www.cyphre.com/
SwissDisk : http://www.swissdisk.com/
Ubuntu    : http://www.ubuntu.com/
My Blog   : http://ben-collins.blogspot.com/


--Apple-Mail=_2E71930E-3E5E-424C-B54C-EF93E3C931CA
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
	filename=signature.asc
Content-Type: application/pgp-signature;
	name=signature.asc
Content-Description: Message signed with OpenPGP using GPGMail

-----BEGIN PGP SIGNATURE-----
Comment: Stop snooping around.

iEYEARECAAYFAlXaCRgACgkQbVJJsWDoC1v7hACgnT1Z7BveIxseadZ463qS7hUi
SxkAn053rrVDdlQmLRWpKNVkQY6PSPwO
=Li+x
-----END PGP SIGNATURE-----

--Apple-Mail=_2E71930E-3E5E-424C-B54C-EF93E3C931CA--

--===============0478774537==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Linux-HA mailing list is closing down.
Please subscribe to [email protected] instead.
http://clusterlabs.org/mailman/listinfo/users
_______________________________________________
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
--===============0478774537==--