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

Assigned To

None

Authored By

	• Jar
	Jul 1 2019, 4:27 AM

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.

In T167246#5012834, @gerritbot wrote:

Change 482110 merged by jenkins-bot:
[mediawiki/extensions/UserMerge@REL1_31] Update for the actor table change

https://gerrit.wikimedia.org/r/482110

Related Objects

Mentioned Here: T167246: Refactor "user" & "user_text" fields into "actor" reference table

Event Timeline

• Jar created this task.Jul 1 2019, 4:27 AM

Restricted Application added subscribers: alaa, Aklapper. · View Herald TranscriptJul 1 2019, 4:27 AM

Removing MediaWiki-libs-Rdbms as your link goes to MediaWiki-extensions-UserMerge instead.

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.

@matej_suchanek same problem when I use the revision_userindex table.

matej_suchanek edited projects, added Regression; removed MediaWiki-extensions-UserMerge.Jul 1 2019, 11:42 AM

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

zhuyifei1999 subscribed.

bd808 closed this task as a duplicate of T226050: Wiki Replicas are very slow and timing out.Jul 1 2019, 7:41 PM

matej_suchanek unsubscribed.Jul 2 2019, 6:59 AM

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

Description

Related Objects

Event Timeline

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