Marostegui added a comment.
In T234948#5562953 <https://phabricator.wikimedia.org/T234948#5562953>, @jcrespo wrote: > We found a possible cause even if partial: maintenance queries for Special page update like `SpecialMostLinked::reallyDoQuery` causing lag and general slowdown on other servers, probably you can check what those do and if they break or make the wikidata migration or make it more difficult. For now manuel killed the ongoing queries. > Updating special pages would match the 0:00 start of issues with no ongoing deployments. Some more details: This exact query has been running for 12h: | 739806079 | wikiadmin | 10.64.16.77:54904 | wikidatawiki | Query | 45858 | Copying to tmp table on disk | SELECT /* SpecialMostLinked::reallyDoQuery www-data@mwmain... */ pl_namespace AS `namespace`,pl_title AS `title`,COUNT(*) AS `value`,page_namespace FROM `pagelinks` LEFT JOIN `page` ON ((page_namespace = pl_namespace) AND (page_title = pl_title)) GROUP BY pl_namespace,pl_title,page_namespace HAVING COUNT(*) > 1 ORDER BY value DESC LIMIT 5000 I killed that one and then some more came in again, so I had to go to mwmaint and kill this to get the server fully back: php /srv/mediawiki-staging/multiversion/MWScript.php updateSpecialPages.php wikidatawiki --override --only=Mostlinked TASK DETAIL https://phabricator.wikimedia.org/T234948 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: alaa_wmde, Marostegui Cc: alaa_wmde, Jdforrester-WMF, WMDE-leszek, Marostegui, Ladsgroup, Aklapper, jcrespo, Iflorez, darthmon_wmde, DannyS712, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs