Page MenuHomePhabricator

Killed very long transaction that was blocking the replica on labsdb1001
Closed, ResolvedPublic

Description

labsdb1001 was lagging today because a transaction created from the user s51114 that belongs to the group tools.enwp10 was keeping the replica from being executed because Waiting for table metadata lock.

The killed transaction was open since 22k seconds and was executing many queries on it, there wasn't a single particularly long running query. This is a bad practice and you should avoud

---TRANSACTION 35432803735, ACTIVE 22221 sec starting index read
mysql tables in use 2, locked 0
, holds adaptive hash latch
MySQL thread id 74988385, OS thread handle 0x7efc5dfff700, query id 4364880313 10.68.18.40 s51114 Sending data

Event Timeline

OK, I need to identify the request and probably split it in smaller one.

Marostegui subscribed.

I am going to close this ticket as resolved as no further reports were done and looks like this was a one-time issue.
We can reopen if someone feels it needs to be reopened

Thanks!