[Wikidata-bugs] [Maniphest] [Commented On] T245818: Audit query pages on Wikidata

Ladsgroup added a comment. @Marostegui Thanks. Is there any other page that is also causing problems (not enough to be killed but still enough to be annoying?) TASK DETAIL https://phabricator.wikimedia.org/T245818 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpr

[Wikidata-bugs] [Maniphest] [Commented On] T245818: Audit query pages on Wikidata

Marostegui added a comment. I have raised T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run to high as it has caused again errors in production. We need that cronjob either fixed or disabled - everytime it runs we have to

[Wikidata-bugs] [Maniphest] [Commented On] T245818: Audit query pages on Wikidata

Marostegui added a comment. This one T238199 is the one I have had to kill the most lately. I also recall MostLinked being pretty heavy as well TASK DETAIL https://phabricator.wikimedia.org/T245818 EMAIL PREFERENCES https://phabricator.wikime

[Wikidata-bugs] [Maniphest] [Commented On] T245818: Audit query pages on Wikidata

Ladsgroup added a comment. @Marostegui Hey, can you give us the list of the ones that are the most problematic in the DB-level? I know we had to disable some already TASK DETAIL https://phabricator.wikimedia.org/T245818 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/e

[Wikidata-bugs] [Maniphest] [Commented On] T245818: Audit query pages on Wikidata

Marostegui added a comment. I had to kill `updateSpecialPages.php wikidatawiki --override --only=Fewestrevisions` as it was causing issues - tracking task: T238199 TASK DETAIL https://phabricator.wikimedia.org/T245818 EMAIL PREFERENCES https:

[Wikidata-bugs] [Maniphest] [Commented On] T245818: Audit query pages on Wikidata

Ladsgroup added a comment. SELECT uri_path, count(*) FROM wmf.webrequest WHERE year = 2020 AND month = 4 AND agent_type = "user" AND uri_host = "www.wikidata.org" AND uri_path like '/wiki/Special:%' and lower(uri_path) in ('/wiki/special:ancientpages', '/wiki/special:brokenredirects', '/wi

[Wikidata-bugs] [Maniphest] [Commented On] T245818: Audit query pages on Wikidata

Ladsgroup added a comment. On the API-side of requests, this is the number I got since first of April (17 days); select params['qppage'], params['gdppage'], count(*) as hitcount from event.mediawiki_api_request where year = 2020 and month = 4 and params['action'] = 'query' and (params

[Wikidata-bugs] [Maniphest] [Commented On] T245818: Audit query pages on Wikidata

matej_suchanek added a comment. > I hope it's fine that I hijack it. Totally fine. TASK DETAIL https://phabricator.wikimedia.org/T245818 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: matej_suchanek Cc: Lea_Lacroix_WMDE, Marostegui, Addshore