Bug #23379 wrong time value in SHOW PROCESSLIST
Submitted: 17 Oct 2006 16:06 Modified: 13 Nov 2006 19:48
Reporter: Georg Richter Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.26 /4.1/5.1BK OS:Linux (Linux)
Assigned to: Andrey Hristov CPU Architecture:Any

[17 Oct 2006 16:06] Georg Richter
Description:
For comnand "connect" SHOW PROCESSLIST shows wrong time value

How to repeat:
From commandline start

telnet localhost 3306

Then execute show processlist command:

mysql> show processlist;
+----+----------------------+-----------------+------+---------+------------+------------------+------------------+
| Id | User                 | Host            | db   | Command | Time       | State            | Info             |
+----+----------------------+-----------------+------+---------+------------+------------------+------------------+
|  3 | root                 | localhost       | test | Query   |          0 | NULL             | show processlist |
|  5 | unauthenticated user | localhost:40923 | NULL | Connect | 2676971253 | Reading from net | NULL             |
+----+----------------------+-----------------+------+---------+------------+------------------+------------------+
[17 Oct 2006 16:51] Miguel Solorzano
Thank you for the bug report.
[18 Oct 2006 12:41] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/13863

ChangeSet@1.2542, 2006-10-18 14:39:47+02:00, andrey@example.com +1 -0
  Fix for bug#23379 "wrong time value in SHOW PROCESSLIST"
  
  The value taken to be shown in SHOW PROCESSLIST is not
  initialized when THD is created and will be random for
  unauthenticated connections.
  
  To the documentor: Random value, instead of NULL, was shown,
  in SHOW PROCESSLIST for still non-authenticated connections.
[18 Oct 2006 15:20] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/13884

ChangeSet@1.2542, 2006-10-18 17:19:17+02:00, andrey@example.com +1 -0
  Fix for bug#23379 "wrong time value in SHOW PROCESSLIST"
  
  The value taken to be shown in SHOW PROCESSLIST is not
  initialized when THD is created and will be random for
  unauthenticated connections.
  
  To the documentor: Random value, instead of NULL, was shown,
  in SHOW PROCESSLIST for still non-authenticated connections.
[18 Oct 2006 16:00] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/13889

ChangeSet@1.2542, 2006-10-18 17:58:38+02:00, andrey@example.com +1 -0
  Fix for bug#23379 "wrong time value in SHOW PROCESSLIST"
  
  The value taken to be shown in SHOW PROCESSLIST is not
  initialized when THD is created and will be random for
  unauthenticated connections.
  
  To the documentor: Random value, instead of NULL, was shown,
  in SHOW PROCESSLIST for still non-authenticated connections.
[18 Oct 2006 16:19] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/13891

ChangeSet@1.2542, 2006-10-18 18:17:41+02:00, andrey@example.com +1 -0
  Fix for bug#23379 "wrong time value in SHOW PROCESSLIST"
  
  The value taken to be shown in SHOW PROCESSLIST is not
  initialized when THD is created and will be random for
  unauthenticated connections.
  
  To the documentor: Random value, instead of NULL, was shown,
  in SHOW PROCESSLIST for still non-authenticated connections.
[18 Oct 2006 16:28] Chad MILLER
Looks good.  Iggy's first, I'm second review
[13 Nov 2006 19:48] Paul Dubois
Noted in 4.1.23, 5.0.30 (not 5.0.29), 5.1.13 changelogs.