| Bug #23379 | wrong time value in SHOW PROCESSLIST | ||
|---|---|---|---|
| Submitted: | 17 Oct 2006 18:06 | Modified: | 13 Nov 2006 20:48 |
| Reporter: | Georg Richter | ||
| Status: | Closed | ||
| Category: | Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.26 /4.1/5.1BK | OS: | Linux (Linux) |
| Assigned to: | Andrey Hristov | Target Version: | |
[17 Oct 2006 18:51]
Miguel Solorzano
Thank you for the bug report.
[18 Oct 2006 14: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 17: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 18: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 18: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 18:28]
Chad MILLER
Looks good. Iggy's first, I'm second review
[13 Nov 2006 20:48]
Paul DuBois
Noted in 4.1.23, 5.0.30 (not 5.0.29), 5.1.13 changelogs.
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 | +----+----------------------+-----------------+------+---------+------------+------------- -----+------------------+