Bug #59342 | innodb status prints "purge trx" next to any thread with id 0 | ||
---|---|---|---|
Submitted: | 7 Jan 2011 4:35 | Modified: | 13 Feb 2012 1:27 |
Reporter: | Shane Bester (Platinum Quality Contributor) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
Version: | mysql-trunk | OS: | Any |
Assigned to: | Inaam Rana | CPU Architecture: | Any |
[7 Jan 2011 4:35]
Shane Bester
[7 Jan 2011 9:20]
Valeriy Kravchuk
Thank you for the bug report. Indeed, this is what we see: ------------ TRANSACTIONS ------------ Trx id counter B00 Purge done for trx's n:o < 705 undo n:o < 0 History list length 4 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started, OS thread id 2961182720 purge trx MySQL thread id 1, query id 12 localhost root show engine innodb status