Comment 1 for bug 882711

Revision history for this message
shinguz (oli-sennhauser) wrote :

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) |
+------+-------------+--------------------+------+---------+------+--------------------------+----------------------------------------------------------+