moco
moco copied to clipboard
Do not kill system user
Describe the bug KillConnections function also terminates system user processes. https://github.com/cybozu-go/moco/blob/c545ebbbab9e92aaf9b07c42263464d9faec50f9/pkg/dbop/kill.go#L19-L30
mysql> SELECT * FROM information_schema.PROCESSLIST WHERE USER="system user";
+----+-------------+-----------------+------+---------+------+----------------------------------------------------------+------+
| ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO |
+----+-------------+-----------------+------+---------+------+----------------------------------------------------------+------+
| 16 | system user | connecting host | NULL | Connect | 3747 | Waiting for source to send event | NULL |
| 17 | system user | | NULL | Query | 1 | Replica has read all relay log; waiting for more updates | NULL |
| 18 | system user | | NULL | Query | 1 | Waiting for an event from Coordinator | NULL |
| 19 | system user | | NULL | Query | 347 | Waiting for an event from Coordinator | NULL |
| 20 | system user | | NULL | Connect | 3747 | Waiting for an event from Coordinator | NULL |
| 21 | system user | | NULL | Connect | 3747 | Waiting for an event from Coordinator | NULL |
+----+-------------+-----------------+------+---------+------+----------------------------------------------------------+------+
6 rows in set (0.00 sec)
mysql>
These processes should not kill. If killed, data inconsistencies could occur.