Bug #58189 SHOW FULL PROCESSLIST shows query duration time of "-1" for it's own process
Submitted: 15 Nov 2010 2:47 Modified: 2 Jan 2016 5:07
Reporter: Roel Van de Paar Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version:5.5.7rc OS:Any
Assigned to: CPU Architecture:Any

[15 Nov 2010 2:47] Roel Van de Paar
Description:
During some heavy-load testing on a server, I saw the following;

| 39 | root | localhost:54479 | test | Query   |   -1 | NULL                            | show full processlist   

How to repeat:
SHOW FULL PROCESSLIST
[15 Nov 2010 2:49] Roel Van de Paar
Full output at time of bug

Attachment: full output bug 58189.txt (text/plain), 3.78 KiB.

[15 Nov 2010 10:08] Peter Laursen
not here (win7/64 bit server)

SELECT VERSION(); -- 5.5.7-rc 

SHOW FULL PROCESSLIST
/*
    Id  User    Host             db      Command    Time  State   Info                 
------  ------  ---------------  ------  -------  ------  ------  ---------------------
     1  root    localhost:54222  (NULL)  Query         0  (NULL)  show full processlist
     2  root    localhost:54223  (NULL)  Sleep         8          (NULL)               
 */

... but there is no 'heavy load' here!
[2 Jan 2016 5:07] MySQL Verification Team
changing this from verified to can't repeat.
there is no testcase, and haven't seen this myself (without setting timestamp) and/or changing clocks.