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 15:46] Baron Schwartz
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
           DB: NULL
      COMMAND: Connect
         TIME: 9178
        STATE: Reading event from the relay log
         INFO: NULL
      TIME_MS: 2
    ROWS_SENT: 0
    ROWS_READ: 2

mysql> show full processlist\G
*************************** 2. row ***************************
           Id: 179478
         User: system user
      Command: Connect
         Time: 9217
        State: Sending data
         Info: insert ignore into [redacted]...
[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".