[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

jcrespo added a comment. One thing that may be relevant here is that the query may have worked once or twice in the last 6 months due to this underlying issue. Last update that completed successfully was 27 March. In effect, because this bug, this wasn't disabled officially but it was

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

Lea_Lacroix_WMDE added a comment. Can we keep the task open a few more days? I just sent the announcement to the community https://www.wikidata.org/wiki/Wikidata:Project_chat#Special:FewestRevisions_to_be_disabled and I just want to make sure that there's no strong veto. But everything

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

ArielGlenn added a comment. Unless folks want to keep it open to work on speeding it up in the future? TASK DETAIL https://phabricator.wikimedia.org/T238199 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: ArielGlenn Cc: SilentSpike, WMDE-leszek,

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

Marostegui added a comment. The above patch to remove the cronjob has been merged, and the cronjob manually removed from mwmaint1002. I guess this can be resolved @Ladsgroup? TASK DETAIL https://phabricator.wikimedia.org/T238199 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

gerritbot added a comment. Change 596172 **merged** by ArielGlenn: [operations/puppet@production] mediawiki: Disable fewestrevisions for wikidata https://gerrit.wikimedia.org/r/596172 TASK DETAIL https://phabricator.wikimedia.org/T238199 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

Marostegui added a comment. And this just happened again: | 1953784190 | wikiadmin| 10.64.16.77:53846 | wikidatawiki | Query | 44238 | Copying to tmp table on disk | SELECT /* SpecialFewestRevisions::reallyDoQuery */

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2020-05-27T13:18:59Z] Kill /usr/local/bin/mwscriptwikiset updateSpecialPages.php s8.dblist --override --only=Fewestrevisions T238199 TASK DETAIL

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

Ladsgroup added a comment. With the announcement done , this can move forward on our side TASK DETAIL https://phabricator.wikimedia.org/T238199 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

ArielGlenn added a comment. In T238199#6135018 , @Ladsgroup wrote: > ... > Anyway, Lydia said it's fine to do it tomorrow when it gets announced by our communication manager. Does that work for you? Anything's fine as

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

Ladsgroup added a comment. In T238199#6132549 , @ArielGlenn wrote: > Can we do this temporarily while the query is being fixed up? It looks like it had to be killed in Nov, Feb, Apr, May, so I'd rather temp disable than require folks

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

ArielGlenn added a comment. Can we do this temporarily while the query is being fixed up? It looks like it had to be killed in Nov, Feb, Apr, May, so I'd rather temp disable than require folks to shoot it (and anything else hung as a side effect). TASK DETAIL

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

Ladsgroup added a comment. In T238199#6132487 , @ArielGlenn wrote: > Can we just skip the updateSpecialPages.php wikidatawiki --override --only=Fewestrevisions script altogether, instead of shooting it every month? That's a

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

gerritbot added a comment. Change 596172 had a related patch set uploaded (by ArielGlenn; owner: ArielGlenn): [operations/puppet@production] mediawiki: Disable fewestrevisions for wikidata https://gerrit.wikimedia.org/r/596172 TASK DETAIL https://phabricator.wikimedia.org/T238199

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

ArielGlenn added a comment. Can we just skip the updateSpecialPages.php wikidatawiki --override --only=Fewestrevisions script altogether, instead of shooting it every month? TASK DETAIL https://phabricator.wikimedia.org/T238199 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

jcrespo added a comment. Over 50K user errors: https://logstash.wikimedia.org/goto/e78777bdaa039396e05bca8099294c91 TASK DETAIL https://phabricator.wikimedia.org/T238199 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: jcrespo Cc:

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

Marostegui added a comment. This hit us hard again: | 1593977753 | wikiadmin | 10.64.16.77:59698 | wikidatawiki | Query | 22436 | Copying to tmp table on disk | SELECT /* SpecialFewestRevisions::reallyDoQuery */

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2020-04-27T07:15:39Z] Kill updateSpecialPages.php wikidatawiki --override --only=Fewestrevisions as it is causing lag - T238199 TASK DETAIL

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

jcrespo added a comment. I killed SpecialFewestRevisions::reallyDoQuery because it was causing the host (s8, db1101) where it was running to lag for 1-2 seconds, enough for queries waiting for replication to take a dive in performance, and logging hundreds of thousands of db errors. Long

[Wikidata-bugs] [Maniphest] [Commented On] T238199: SpecialFewestRevisions::reallyDoQuery takes more than 9h to run

matmarex added a comment. @Marostegui Did you mean to CC someone else? I know nothing about this :) TASK DETAIL https://phabricator.wikimedia.org/T238199 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: matmarex Cc: Lydia_Pintscher, Aklapper,