applier time value can be negative
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL patches by Codership |
Invalid
|
Low
|
Unassigned | |||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC | Status tracked in 5.6 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Invalid
|
Undecided
|
Unassigned |
Bug Description
Following has been observed in processlists:
mysql> show processlist;
+------
| Id | User | Host | db | Command | Time | State | Info |
+------
| 13 | system user | | NULL | Sleep | -204 | post SQL applying (0) | NULL |
| 14 | system user | | NULL | Sleep | 240432 | wsrep aborter idle | NULL |
| 15 | system user | | NULL | Sleep | -204 | post SQL applying (0) | NULL |
| 16 | system user | | NULL | Sleep | -204 | post SQL applying (0) | NULL |
| 17 | system user | | NULL | Sleep | -204 | post SQL applying (0) | NULL |
Changed in codership-mysql: | |
milestone: | 5.5.33-24.8 → none |
no longer affects: | codership-mysql/5.5 |
Changed in codership-mysql: | |
status: | New → Invalid |
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) |
+------
+------ +------ ------- +------ ------- ------- +------ +------ ---+--- ---+--- ------- ------- ------- --+---- ------- ------- ------- ------- ------- ------- ------. ..