| Bug #66401 | SHOW PROCESSLIST and I_S.PROCESSLIST differ for slave thread | ||
|---|---|---|---|
| Submitted: | 15 Aug 2012 15:46 | Modified: | 15 Sep 2012 18:06 |
| Reporter: | Baron Schwartz (Basic Quality Contributor) | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server: Information schema | Severity: | S3 (Non-critical) |
| Version: | 5.5.15 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[15 Aug 2012 18:06]
Sveta Smirnova
Thank you for report. I can not repeat described behavior. Please try with current version and inform us if problem still exists.
[16 Sep 2012 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: SHOW PROCESSLIST shows the SQL that the slave is running. But INFORMATION_SCHEMA.PROCESSLIST shows different state for that thread, and no SQL. How to repeat: mysql> select * from information_schema.processlist where id=179478\G *************************** 1. row *************************** ID: 179478 USER: system user HOST: DB: NULL COMMAND: Connect TIME: 9178 STATE: Reading event from the relay log INFO: NULL TIME_MS: 2 ROWS_SENT: 0 ROWS_EXAMINED: 1 ROWS_READ: 2 mysql> show full processlist\G *************************** 2. row *************************** Id: 179478 User: system user Host: db: Command: Connect Time: 9217 State: Sending data Info: insert ignore into [redacted]...