Internal Server Error at xtools.wmflab.org/articleinfo
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	GereonK
	Nov 15 2017, 7:11 AM

Description

/var/www/app/Resources/views/articleInfo/result.html.twig: 72 - An exception has been thrown during the rendering of a template ("An exception occurred while executing 'SELECT COUNT(*) AS count                FROM wikidatawiki_p.wb_items_per_site                WHERE ips_item_id = :wikidataId' with params ["1718983"]:SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query").

URL: http://xtools.wmflabs.org/articleinfo/de.wikipedia.org/KSK_Rochade_Eupen-Kelmis

XTools version: 3.1.17-51eec6e

Related Objects

Mentioned In: T180564: Execution of maintain-view can create pileups due to metadata locking (was: Queries to wikidatawiki_p.wb_items_per_site on *.web.db.svc.eqiad.wmflabs are timing out)
Mentioned Here: T180564: Execution of maintain-view can create pileups due to metadata locking (was: Queries to wikidatawiki_p.wb_items_per_site on *.web.db.svc.eqiad.wmflabs are timing out)

Event Timeline

GereonK created this task.Nov 15 2017, 7:11 AM

Samwilson updated the task description. (Show Details)Nov 15 2017, 7:19 AM

Alright, I've narrow it down to an issue with enwiki.web.db.svc.eqiad.wmflabs and the wikidatawiki_p.wb_items_per_site table, specifially. Every thing seems fine over on *.analytics, so switching to it now...

MusikAnimal mentioned this in T180564: Execution of maintain-view can create pileups due to metadata locking (was: Queries to wikidatawiki_p.wb_items_per_site on *.web.db.svc.eqiad.wmflabs are timing out).Nov 15 2017, 7:41 AM

I've switched XTools to use the Analytics server and it seems we're back to normal. If something is still being really slow, please comment here.

I've filed a bug about the slow table at T180564

As a recommendation, please go back to the web server, by chance it happened there, but actually it should be more likely to happen on the analytics one. We will try to make sure it doesn't happen again on T180564 anyway.

Matthewrbowker moved this task from Backlog to Complete on the XTools board.Nov 15 2017, 5:14 PM

Internal Server Error at xtools.wmflab.org/articleinfoClosed, ResolvedPublicActions

Description

Related Objects

Event Timeline

Internal Server Error at xtools.wmflab.org/articleinfo
Closed, ResolvedPublic
Actions