Wrong time in SHOW PROCESSLIST

Bug #612954 reported by Oleg Tsarev
14
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
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)
Changed in percona-server:
importance: Undecided → Medium
status: New → In Progress
assignee: nobody → Oleg Tsarev (tsarev)
Oleg Tsarev (tsarev)
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
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1153

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.