Bug #59899 Wrong status in processlist when using ROW level replication
Submitted: 2 Feb 2011 17:37 Modified: 24 Jun 2011 16:15
Reporter: Peter Zaitsev (Basic Quality Contributor) Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: Row Based Replication ( RBR ) Severity:S3 (Non-critical)
Version:5.1.36, 5.1.54 OS:Any
Assigned to: CPU Architecture:Any
Tags: qc

[2 Feb 2011 17:37] Peter Zaitsev
The status shown for the query in replication thread is wrong when using row level replication see:

---TRANSACTION 24027116B, ACTIVE 0 sec, process no 15777, OS thread id 1106032960 starting index read
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s)
MySQL thread id 9286, query id 567085 invalidating query cache entries (table)

This shows there is innodb activity doing index read but status shown as "invalidating query cache"

The status should be added which states applying replication row event or something similar

How to repeat:
check processlist while running loaded row level replication
[24 May 2011 16:15] Valeriy Kravchuk
Probably related to (or a duplicate of) bug #38551. Please, check. (No fix for 5.1.x, sorry)
[24 Jun 2011 23: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".