[Wikidata-bugs] [Maniphest] [Commented On] T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis

2017-11-10 Thread gerritbot
gerritbot added a comment. Change 383107 abandoned by Reedy: Disable inject recent changes on all client wikis https://gerrit.wikimedia.org/r/383107TASK DETAILhttps://phabricator.wikimedia.org/T171027EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Bawolff,

[Wikidata-bugs] [Maniphest] [Commented On] T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis

2017-10-17 Thread Vicpeters
Vicpeters added a comment. Thanks for help! It works now!TASK DETAILhttps://phabricator.wikimedia.org/T171027EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Bawolff, VicpetersCc: JEumerus, Alsee, awight, Matthewrbowker, Noella94, Nirmos, Stryn, Mike_Peel,

[Wikidata-bugs] [Maniphest] [Commented On] T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis

2017-10-13 Thread Jwh
Jwh added a comment. Works fine now. Thank you so much to have solved this problem!TASK DETAILhttps://phabricator.wikimedia.org/T171027EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: JwhCc: JEumerus, Alsee, awight, Matthewrbowker, Noella94, Nirmos, Stryn,

[Wikidata-bugs] [Maniphest] [Commented On] T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis

2017-10-13 Thread jcrespo
jcrespo added a comment. The initial scope- query issues on ruwiki and commonswiki, I think has been successfully patched. These are the statistics I have now: F10184141: Screenshot_20171013_165442.png I would ask users affected to confirm the issues are gone- probably not 100% of them will

[Wikidata-bugs] [Maniphest] [Commented On] T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis

2017-10-12 Thread Johan
Johan added a comment. Will fix.TASK DETAILhttps://phabricator.wikimedia.org/T171027EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: jcrespo, JohanCc: Alsee, awight, Matthewrbowker, Noella94, Nirmos, Stryn, Mike_Peel, Capankajsmilyo, Elitre, Risker, Peachey88,

[Wikidata-bugs] [Maniphest] [Commented On] T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis

2017-10-12 Thread Catrope
Catrope added a comment. In T171027#3680606, @IKhitron wrote: Hi, @Johan. Recent changes or watchlists? Both. But the statement should really make that clearer. It uses RC and WL as if they're interchangeable, and in the code they kind of are because they use the same underlying infrastructure,

[Wikidata-bugs] [Maniphest] [Commented On] T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis

2017-10-12 Thread Johan
Johan added a comment. @jcrespo Is this an accurate description right now? There is a problem with watchlists that show a large number of pages. Until it has been fixed Wikidata edits will not be shown in recent changes on Commons or Russian Wikipedia. If necessary Wikidata edits will be removed

[Wikidata-bugs] [Maniphest] [Commented On] T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis

2017-10-12 Thread Catrope
Catrope added a comment. In T171027#3677449, @Catrope wrote: Thanks, I'll experiment with removing the STRAIGHT_JOIN, as well as with @awight's suggestion at T164796#3560530 of breaking out the change tags rollup. This is tracked over at T176456: ORES on Watchlist causes big slowdown—especially

[Wikidata-bugs] [Maniphest] [Commented On] T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis

2017-10-12 Thread jcrespo
jcrespo added a comment. This is the result on query error rate after ruwiki has been purged: F10158519: Screenshot_20171012_130744.png Please note that these are preliminary results, and that tables have yet to be optimized/analyzed, but I think this confirms we are in the right track. Commons

[Wikidata-bugs] [Maniphest] [Commented On] T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis

2017-10-11 Thread Alsee
Alsee added a comment. In T171027#3673060, @Lydia_Pintscher wrote: This is a hugely political issue. It doesn't matter whether Political Issues come from the community, a project manager, or President of the Planet. They wait in line when a database administrator declares an emergency: we are

[Wikidata-bugs] [Maniphest] [Commented On] T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis

2017-10-11 Thread Bawolff
Bawolff added a comment. Well wikidata is almost certainly a contributing factor, (particularly for russian) I would hesitate to blame it solely for slow ores on watchlist speeds, without more evidence. Especially on english wikipedia with its large recentchanges table and relatively low usage of

[Wikidata-bugs] [Maniphest] [Commented On] T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis

2017-10-11 Thread Bawolff
Bawolff added a comment. In T171027#3676023, @jmatazzoni wrote: In T171027#3673060, @Lydia_Pintscher wrote: This is a hugely political issue. Let's please not do this unless necessary. Right now, ORES is unusable on Watchlist for English, Russian and probably some other big wikis. It causes

[Wikidata-bugs] [Maniphest] [Commented On] T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis

2017-10-11 Thread jmatazzoni
jmatazzoni added a comment. In T171027#3673060, @Lydia_Pintscher wrote: This is a hugely political issue. Let's please not do this unless necessary. Right now, ORES is unusable on Watchlist for English, Russian and probably some other big wikis. It causes delays of 30 seconds to a minute when

[Wikidata-bugs] [Maniphest] [Commented On] T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis

2017-10-10 Thread Risker
Risker added a comment. In T171027#3673060, @Lydia_Pintscher wrote: This is a hugely political issue. Let's please not do this unless necessary. Daniel has provided a patch for T177707 and Marius has been working on various other improvements. I'm not sure how political it is at this point; it

[Wikidata-bugs] [Maniphest] [Commented On] T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis

2017-10-10 Thread Lydia_Pintscher
Lydia_Pintscher added a comment. This is a hugely political issue. Let's please not do this unless necessary. Daniel has provided a patch for T177707 and Marius has been working on various other improvements.TASK DETAILhttps://phabricator.wikimedia.org/T171027EMAIL