Monitor sets ip first after changing state from ADMIN_OFFLINE to ONLINE
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(
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(
2012/01/03 15:27:26 INFO Orphaned role 'reader(
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(