Page MenuHomePhabricator

Query in Toolforge couldn't complete (timeout)
Closed, DuplicatePublic

Description

Hello, since Mar 9 2019 "Update for the actor table change" the server took too long for any quarry, for example this quarry takes 312.47 second in quarry.wmflabs, but in Toolforge it couldn't even complete, I get "2013 Lost connection to MySQL server during query" or timeout.

Change 482110 merged by jenkins-bot:
[mediawiki/extensions/UserMerge@REL1_31] Update for the actor table change
https://gerrit.wikimedia.org/r/482110

Event Timeline

Jar created this task.Jul 1 2019, 4:27 AM
Restricted Application added subscribers: alanajjar, Aklapper. · View Herald TranscriptJul 1 2019, 4:27 AM

Using optimizer:

  • You appear to be querying the revision table and filtering by user. It may be more efficient to use the revision_userindex table.
Jar added a comment.Jul 1 2019, 11:36 AM

@matej_suchanek same problem when I use the revision_userindex table.

zhuyifei1999 edited projects, added Data-Services; removed Quarry.Jul 1 2019, 5:56 PM
zhuyifei1999 added a subscriber: zhuyifei1999.