Page MenuHomePhabricator

On Wikispecies and other wikis, the data in Special:LonelyPages has not been updated since 25 September
Closed, ResolvedPublic

Description

On Wikispecies, the data in species:Special:LonelyPages (Orphaned pages) was last updated on 25 September 2023.

I checked other wikis, and the data in a number of them was also last updated on 25 September 2023, while in the others it was updated recently.

(a) last updated 25 September

(b) updated recently

Is this a bug or a change in the update frequency? According to a post at species:Wikispecies:Village Pump#Orphaned pages update, the data in species:Special:LonelyPages used to be updated twice a week. Thanks.

Event Timeline

Korg renamed this task from On Wikispecies and other wikis, Special:LonelyPages has not been updated since 25 September to On Wikispecies and other wikis, the data in Special:LonelyPages has not been updated since 25 September.Oct 9 2023, 7:53 AM

I'm wondering where this is defined... Cannot find anything obvious in https://gerrit.wikimedia.org/r/plugins/gitiles/operations/puppet/+/refs/heads/production/modules/profile/manifests/mediawiki/maintenance/updatequerypages/ but could imagine that it's monthly instead of twice a month.

Would also be useful to have a system message like querypage-updates-monthly displayed on the Special page to explain how often it's updated.

Looks like it's defined in https://gerrit.wikimedia.org/r/plugins/gitiles/operations/puppet/+/refs/heads/production/modules/profile/manifests/mediawiki/maintenance/update_special_pages.pp, which creates one periodic job per section.

All the wikis mentioned above are on s3 which according to systemd, is still running:

cgoubert@mwmaint2002:~$ systemctl status mediawiki_job_update_special_pages_s*.timer | grep -E '(service|active|Trigger)'
● mediawiki_job_update_special_pages_s1.timer - Periodic execution of mediawiki_job_update_special_pages_s1.service
   Active: active (waiting) since Mon 2023-09-11 08:40:07 UTC; 4 weeks 0 days ago
  Trigger: Tue 2023-10-10 05:00:00 UTC; 19h left
● mediawiki_job_update_special_pages_s3.timer - Periodic execution of mediawiki_job_update_special_pages_s3.service
   Active: active (running) since Mon 2023-09-11 08:40:06 UTC; 4 weeks 0 days ago
  Trigger: n/a
● mediawiki_job_update_special_pages_s5.timer - Periodic execution of mediawiki_job_update_special_pages_s5.service
   Active: active (waiting) since Mon 2023-09-11 08:40:07 UTC; 4 weeks 0 days ago
  Trigger: Tue 2023-10-10 05:00:00 UTC; 19h left
● mediawiki_job_update_special_pages_s6.timer - Periodic execution of mediawiki_job_update_special_pages_s6.service
   Active: active (waiting) since Mon 2023-09-11 08:40:06 UTC; 4 weeks 0 days ago
  Trigger: Tue 2023-10-10 05:00:00 UTC; 19h left
● mediawiki_job_update_special_pages_s7.timer - Periodic execution of mediawiki_job_update_special_pages_s7.service
   Active: active (waiting) since Mon 2023-09-11 08:40:05 UTC; 4 weeks 0 days ago
  Trigger: Tue 2023-10-10 05:00:00 UTC; 19h left
● mediawiki_job_update_special_pages_s8.timer - Periodic execution of mediawiki_job_update_special_pages_s8.service
   Active: active (waiting) since Mon 2023-09-11 08:40:06 UTC; 4 weeks 0 days ago
  Trigger: Tue 2023-10-10 05:00:00 UTC; 19h left
● mediawiki_job_update_special_pages_s11.timer - Periodic execution of mediawiki_job_update_special_pages_s11.service
   Active: active (waiting) since Mon 2023-09-11 08:40:06 UTC; 4 weeks 0 days ago
  Trigger: Tue 2023-10-10 05:00:00 UTC; 19h left
● mediawiki_job_update_special_pages_s2.timer - Periodic execution of mediawiki_job_update_special_pages_s2.service
   Active: active (waiting) since Mon 2023-09-11 08:40:07 UTC; 4 weeks 0 days ago
  Trigger: Tue 2023-10-10 05:00:00 UTC; 19h left
● mediawiki_job_update_special_pages_s4.timer - Periodic execution of mediawiki_job_update_special_pages_s4.service
   Active: active (waiting) since Mon 2023-09-11 08:40:07 UTC; 4 weeks 0 days ago
  Trigger: Tue 2023-10-10 05:00:00 UTC; 19h left

The job was restarted this morning by @taavi after being stuck for a while because it experienced the bug tracked in T348428: updateSpecialPages.php will try to re-connect to a DB indefinitely following a DB maintenance.

Ladsgroup claimed this task.
Ladsgroup subscribed.

We fixed that problem. Next week run will update it. I resolve this please reopen if it's not fixed by then.