Percona Server with XtraDB

Wrong time in SHOW PROCESSLIST

Reported by Oleg Tsarev on 2010-08-03
14
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Percona Server
Medium
Oleg Tsarev

Bug Description

Sometimes we can see strange times in SHOW PROCESSLIST, i.e.:
mysql> select * from information_schema.processlist where command!='Sleep';
+----------+-------------+----------------------+--------------------+-------------+----------------+------------------------------------------------------------------+---------------------------------------------------------------------+-----------------------+
| ID | USER | HOST | DB |
COMMAND | TIME |
STATE |
INFO |
TIME_MS |
+----------+-------------+----------------------+--------------------+-------------+----------------+------------------------------------------------------------------+---------------------------------------------------------------------+-----------------------+
| 19236439 | root | localhost | NULL |
Query | 0 |
executing | select *
from information_schema.processlist where command!='Sleep' |
0.478 |
| 19221966 | cardbee | 192.168.100.41:38886 | cardbee_production |
Query | 18446744073709 |
NULL |
NULL |
18446744073709550.000 |
| 18073082 | slave | 192.168.100.22:6389 | NULL |
Binlog Dump | 210340 | Has sent all binlog to slave; waiting for
binlog to be updated |
NULL
| 210340986.341 |
| 18008531 | slave | 192.168.100.23:50055 | NULL |
Binlog Dump | 225897 | Has sent all binlog to slave; waiting for
binlog to be updated |
NULL
| 225897897.500 |
| 17993363 | system user | | NULL |
Connect | 0 | Has read all relay log; waiting for the slave
I/O thread to upda |
NULL
| 11.957 |
| 17993362 | system user | | NULL |
Connect | 229693 | Waiting for master to send
event |
NULL
| 229693423.131 |
+----------+-------------+----------------------+--------------------+-------------+----------------+------------------------------------------------------------------+---------------------------------------------------------------------+-----------------------+
6 rows in set (0.00 sec)

This bug similar to bug 600360

Oleg Tsarev (tsarev) on 2010-08-03
Changed in percona-server:
importance: Undecided → Medium
status: New → In Progress
assignee: nobody → Oleg Tsarev (tsarev)
Oleg Tsarev (tsarev) on 2010-08-03
Changed in percona-server:
status: In Progress → Fix Committed
Changed in percona-server:
milestone: none → 5.1-11.3
Changed in percona-server:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers