[Wikidata-bugs] [Maniphest] T323929: Database error when trying to fetch new pages by bot on Wikidata with high number of edits

2022-11-29 Thread RPI2026F1
RPI2026F1 added a comment. Your link is still giving me a timeout error. TASK DETAIL https://phabricator.wikimedia.org/T323929 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RPI2026F1 Cc: Umherirrender, Lucas_Werkmeister_WMDE, Aklapper, RPI2026F1

[Wikidata-bugs] [Maniphest] T323929: Database error when trying to fetch new pages by bot on Wikidata with high number of edits

2022-11-29 Thread Umherirrender
Umherirrender added a comment. In T323929#8426341 , @RPI2026F1 wrote: > Ah, so there's a table of recent changes and then if there's nothing in that table it scans all revisions? That would explain a lot. The special page is using a

[Wikidata-bugs] [Maniphest] T323929: Database error when trying to fetch new pages by bot on Wikidata with high number of edits

2022-11-29 Thread Umherirrender
Umherirrender edited projects, added Wikimedia-Slow-DB-Query, MediaWiki-Special-pages; removed Wikimedia-database-issue. TASK DETAIL https://phabricator.wikimedia.org/T323929 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Umherirrender Cc: Lucas_Wer

[Wikidata-bugs] [Maniphest] T323929: Database error when trying to fetch new pages by bot on Wikidata with high number of edits

2022-11-28 Thread RPI2026F1
RPI2026F1 added a comment. Ah, so there's a table of recent changes and then if there's nothing in that table it scans all revisions? That would explain a lot. TASK DETAIL https://phabricator.wikimedia.org/T323929 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpr

[Wikidata-bugs] [Maniphest] T323929: Database error when trying to fetch new pages by bot on Wikidata with high number of edits

2022-11-28 Thread Lucas_Werkmeister_WMDE
Lucas_Werkmeister_WMDE added a comment. I guess Dexbot rarely if ever creates new items – at least it hasn’t created any in the past 30 days: MariaDB [wikidatawiki]> SELECT rc_id FROM recentchanges WHERE rc_actor = (SELECT actor_id FROM actor WHERE actor_name = 'Dexbot') AND rc_new = 1

[Wikidata-bugs] [Maniphest] T323929: Database error when trying to fetch new pages by bot on Wikidata with high number of edits

2022-11-28 Thread RPI2026F1
RPI2026F1 created this task. RPI2026F1 added projects: Wikimedia-database-issue, Wikidata. Restricted Application added a subscriber: Aklapper. TASK DESCRIPTION **Steps to replicate the issue** (include links if applicable): Try to visit https://www.wikidata.org/w/index.php?title=Special%3ACont