Same to me on 5.5.20 MySQL Community Server (GPL), wsrep_23.4.r3713, wsrep_23.4.r3713
Interestingly it happens only on 2 Galera nodes out of 3 and in an other state:
show processlist; +------+-------------+--------------------+------+---------+------+--------------------+----------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+-------------+--------------------+------+---------+------+--------------------+----------------------------------------------------------+ | 1 | system user | | NULL | Sleep | 5283 | wsrep aborter idle | NULL | | 2 | system user | | NULL | Query | 3 | committing 419838 | COMMIT | | 1166 | root | localhost | NULL | Query | 0 | sleeping | show processlist | | 1167 | app | 192.168.56.1:40884 | test | Query | 0 | query end | INSERT INTO test values (NULL, "Test data insert", NULL) | | 2022 | app | 192.168.56.1:43648 | test | Query | 0 | query end | INSERT INTO test values (NULL, "Test data insert", NULL) | | 6557 | app | 192.168.56.1:47964 | test | Query | 0 | query end | insert into test values (NULL, 'Test data insert', NULL) | +------+-------------+--------------------+------+---------+------+--------------------+----------------------------------------------------------+
+------+-------------+--------------------+------+---------+------+--------------------------+----------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+-------------+--------------------+------+---------+------+--------------------------+----------------------------------------------------------+ | 1 | system user | | NULL | Sleep | -8 | applied write set 420218 | NULL | | 2 | system user | | NULL | Sleep | 5234 | wsrep aborter idle | NULL | | 1373 | root | localhost | NULL | Query | 0 | sleeping | show processlist | | 1374 | app | 192.168.56.1:44662 | test | Query | 0 | query end | INSERT INTO test values (NULL, "Test data insert", NULL) | | 7091 | app | 192.168.56.1:52785 | test | Query | 0 | query end | insert into test values (NULL, 'Test data insert', NULL) | +------+-------------+--------------------+------+---------+------+--------------------------+----------------------------------------------------------+
+------+-------------+--------------------+------+---------+------+--------------------------+----------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+-------------+--------------------+------+---------+------+--------------------------+----------------------------------------------------------+ | 1 | system user | | NULL | Sleep | -3 | applied write set 422340 | NULL | | 2 | system user | | NULL | Sleep | 1053 | wsrep aborter idle | NULL | | 237 | root | localhost | NULL | Query | 0 | sleeping | show processlist | | 238 | app | 192.168.56.1:59235 | test | Query | 0 | query end | INSERT INTO test values (NULL, "Test data insert", NULL) | | 5648 | app | 192.168.56.1:40218 | test | Query | 0 | query end | insert into test values (NULL, 'Test data insert', NULL) | +------+-------------+--------------------+------+---------+------+--------------------------+----------------------------------------------------------+
Same to me on 5.5.20 MySQL Community Server (GPL), wsrep_23.4.r3713, wsrep_23.4.r3713
Interestingly it happens only on 2 Galera nodes out of 3 and in an other state:
show processlist; +------ ------- +------ ------- ------- +------ +------ ---+--- ---+--- ------- ------- ---+--- ------- ------- ------- ------- ------- ------- ------- ------+ +------ ------- +------ ------- ------- +------ +------ ---+--- ---+--- ------- ------- ---+--- ------- ------- ------- ------- ------- ------- ------- ------+ +------ ------- +------ ------- ------- +------ +------ ---+--- ---+--- ------- ------- ---+--- ------- ------- ------- ------- ------- ------- ------- ------+
+------
| Id | User | Host | db | Command | Time | State | Info |
+------
| 1 | system user | | NULL | Sleep | 5283 | wsrep aborter idle | NULL |
| 2 | system user | | NULL | Query | 3 | committing 419838 | COMMIT |
| 1166 | root | localhost | NULL | Query | 0 | sleeping | show processlist |
| 1167 | app | 192.168.56.1:40884 | test | Query | 0 | query end | INSERT INTO test values (NULL, "Test data insert", NULL) |
| 2022 | app | 192.168.56.1:43648 | test | Query | 0 | query end | INSERT INTO test values (NULL, "Test data insert", NULL) |
| 6557 | app | 192.168.56.1:47964 | test | Query | 0 | query end | insert into test values (NULL, 'Test data insert', NULL) |
+------
+------ +------ ------- +------ ------- ------- +------ +------ ---+--- ---+--- ------- ------- ------- --+---- ------- ------- ------- ------- ------- ------- ------- -----+ +------ ------- +------ ------- ------- +------ +------ ---+--- ---+--- ------- ------- ------- --+---- ------- ------- ------- ------- ------- ------- ------- -----+ +------ ------- +------ ------- ------- +------ +------ ---+--- ---+--- ------- ------- ------- --+---- ------- ------- ------- ------- ------- ------- ------- -----+
| Id | User | Host | db | Command | Time | State | Info |
+------
| 1 | system user | | NULL | Sleep | -8 | applied write set 420218 | NULL |
| 2 | system user | | NULL | Sleep | 5234 | wsrep aborter idle | NULL |
| 1373 | root | localhost | NULL | Query | 0 | sleeping | show processlist |
| 1374 | app | 192.168.56.1:44662 | test | Query | 0 | query end | INSERT INTO test values (NULL, "Test data insert", NULL) |
| 7091 | app | 192.168.56.1:52785 | test | Query | 0 | query end | insert into test values (NULL, 'Test data insert', NULL) |
+------
+------ +------ ------- +------ ------- ------- +------ +------ ---+--- ---+--- ------- ------- ------- --+---- ------- ------- ------- ------- ------- ------- ------- -----+ +------ ------- +------ ------- ------- +------ +------ ---+--- ---+--- ------- ------- ------- --+---- ------- ------- ------- ------- ------- ------- ------- -----+ +------ ------- +------ ------- ------- +------ +------ ---+--- ---+--- ------- ------- ------- --+---- ------- ------- ------- ------- ------- ------- ------- -----+
| Id | User | Host | db | Command | Time | State | Info |
+------
| 1 | system user | | NULL | Sleep | -3 | applied write set 422340 | NULL |
| 2 | system user | | NULL | Sleep | 1053 | wsrep aborter idle | NULL |
| 237 | root | localhost | NULL | Query | 0 | sleeping | show processlist |
| 238 | app | 192.168.56.1:59235 | test | Query | 0 | query end | INSERT INTO test values (NULL, "Test data insert", NULL) |
| 5648 | app | 192.168.56.1:40218 | test | Query | 0 | query end | insert into test values (NULL, 'Test data insert', NULL) |
+------