Do not kill system user
shunki-fujita opened this issue · 0 comments
shunki-fujita commented
Describe the bug
KillConnections function also terminates system user processes.
Lines 19 to 30 in c545ebb
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.