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:	None
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

Description:
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

Probably related to (or a duplicate of) bug #38551. Please, check. (No fix for 5.1.x, sorry)

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".

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.