events scheduler导致MGR节点退出详解及修复
问题复现
执行如下命令:
mysql> SET GLOBAL EVENT_SCHEDULER = OFF;Query OK, 0 rows affected (0.01 sec)mysql> CREATE EVENT e1 ON SCHEDULE EVERY 1 SECOND ENDS NOW() + INTERVAL 1 SECOND DO SELECT 1; Query OK, 0 rows affected (0.01 sec)mysql> SET GLOBAL EVENT_SCHEDULER = ON;Query OK, 0 rows affected (0.04 sec)mysql> show events;Empty set (0.01 sec)