Monitor sets ip first after changing state from ADMIN_OFFLINE to ONLINE

Bug #911277 reported by MartinDo
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
mysql-mmm
New
Undecided
Unassigned

Bug Description

When i changed slave from ADMIN_OFFLINE to ONLINE, monitor assigned ip first and after few seconds he had taken it back and changing state to REPLICATION_DELAY.
Monitor should findout state of the slavefirst and after that he should assign proper state.

MMM_monitor did the similar thing with master few weeks ago, and then i had inconsistency in databases like duplicate id's. The only thing i could do, was to build new master from slave and i lost some records.

Here is a part of log:

2012/01/03 15:27:13 FATAL Admin changed state of 'db-mamina-02' from ADMIN_OFFLINE to ONLINE
2012/01/03 15:27:13 INFO Moving role 'reader(10.0.40.28)' from host 'db-mamina-01' to host 'db-mamina-02'
2012/01/03 15:27:15 INFO Check 'rep_threads' on 'db-mamina-02' is ok!
2012/01/03 15:27:25 ERROR Check 'rep_backlog' on 'db-mamina-02' has failed for 10 seconds! Message: ERROR: Backlog is too big
2012/01/03 15:27:26 FATAL State of host 'db-mamina-02' changed from ONLINE to REPLICATION_DELAY
2012/01/03 15:27:26 INFO Removing all roles from host 'db-mamina-02':
2012/01/03 15:27:26 INFO Removed role 'reader(10.0.40.28)' from host 'db-mamina-02'
2012/01/03 15:27:26 INFO Orphaned role 'reader(10.0.40.28)' has been assigned to 'db-mamina-01'
2012/01/03 15:30:20 INFO Check 'rep_backlog' on 'db-mamina-02' is ok!
2012/01/03 15:30:22 FATAL State of host 'db-mamina-02' changed from REPLICATION_DELAY to ONLINE
2012/01/03 15:30:22 INFO Moving role 'reader(10.0.40.28)' from host 'db-mamina-01' to host 'db-mamina-02'

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.