[ClusterLabs] MySQL resource causes error "0_monitor_20000".

[Andrei Borzenkov]

On Tue, Aug 18, 2015 at 11:57 AM, Kiwamu Okabe <kiwamu at debian.or.jp> wrote:
> Hi,
>
> On Tue, Aug 18, 2015 at 5:07 PM, Kiwamu Okabe <kiwamu at debian.or.jp> wrote:
>> ```
>> 2015-08-18 16:50:38 7081 [ERROR] Slave I/O: Fatal error: The slave I/O
>> thread stops because master and slave have equal MySQL server ids;
>> these ids must be different for replication to work (or the
>> --replicate-same-server-id option must be used on slave but this does
>> not always make sense; please check the manual before using it).
>> Error_code: 1593
>> ```
>
> I fixed it, and get following settings;
>
> ```
> centillion.db01# mysql> show slave status\G
> ...
>              Slave_IO_Running: Yes
>             Slave_SQL_Running: Yes
> ...
> centillion.db01# mysql> stop slave;
> centillion.db02# mysql> start slave;
> centillion.db02# mysql> show slave status\G
> ...
>              Slave_IO_Running: Yes
>             Slave_SQL_Running: Yes
> ...
> ```
>
> But the error message of crm is not changed...
>

You should attach full logs from both nodes starting with pacemaker start.

> ```
> ============
> Last updated: Tue Aug 18 17:41:48 2015
> Stack: Heartbeat
> Current DC: centillion.db02 (0302e3d0-df06-4847-b0f9-9ebddfb6aec7) -
> partition with quorum
> Version: 1.0.13-a83fae5
> 2 Nodes configured, unknown expected votes
> 2 Resources configured.
> ============
>
> Online: [ centillion.db01 centillion.db02 ]
>
> vip_192.168.10.200      (ocf::heartbeat:IPaddr2):       Started centillion.db01
>  Master/Slave Set: mysql-clone
>      mysql:1    (ocf::heartbeat:mysql): Master centillion.db02 FAILED
>      Masters: [ centillion.db01 ]
>
> Failed actions:
>     mysql:1_monitor_20000 (node=centillion.db02, call=26, rc=8,
> status=complete): master
>     mysql:1_monitor_30000 (node=centillion.db02, call=27, rc=8,
> status=complete): master
> ```
>
> Thank's,
> --
> Kiwamu Okabe at METASEPI DESIGN
>
> _______________________________________________
> Users mailing list: Users at clusterlabs.org
> http://clusterlabs.org/mailman/listinfo/users
>
> Project Home: http://www.clusterlabs.org
> Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> Bugs: http://bugs.clusterlabs.org