Fix page project aggregates cron job
Closed, ResolvedPublic5 Estimated Story Points
Actions

Assigned To

Authored By

	Kgraessle
	Feb 13 2025, 7:47 PM

Description

aggregates.pageproject_aggregates_cron

has not ran since July 24, 2024, 1:40 p.m.

Acceptance Criteria:

aggregates.pageproject_aggregates_cron successfully runs.

Related Objects

Mentioned In: T366978: [Wikilink] Aggregates maintenance commands errors

Event Timeline

Kgraessle created this task.Feb 13 2025, 7:47 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 13 2025, 7:47 PM

Samwalton9-WMF added a project: Wikilink-Tool.Feb 17 2025, 9:33 PM

Samwalton9-WMF moved this task from Inbox to Maintenance priorities on the Moderator-Tools-Team board.

Samwalton9-WMF mentioned this in T366978: [Wikilink] Aggregates maintenance commands errors.Feb 17 2025, 9:37 PM

Scardenasmolinar moved this task from Maintenance priorities to To be estimated on the Moderator-Tools-Team board.Feb 18 2025, 5:15 PM

Kgraessle moved this task from To be estimated to Estimated on the Moderator-Tools-Team board.Feb 18 2025, 5:15 PM

Kgraessle moved this task from Estimated to To be estimated on the Moderator-Tools-Team board.

DMburugu triaged this task as High priority.Feb 18 2025, 5:15 PM

DMburugu set the point value for this task to 5.

DMburugu moved this task from To be estimated to Kanban on the Moderator-Tools-Team board.

DMburugu edited projects, added Moderator-Tools-Team (Kanban); removed Moderator-Tools-Team.

Scardenasmolinar moved this task from Ready to Ready (Maintenance) on the Moderator-Tools-Team (Kanban) board.Feb 18 2025, 5:16 PM

Amdrel claimed this task.Feb 18 2025, 6:11 PM

Amdrel moved this task from Ready (Maintenance) to In Progress on the Moderator-Tools-Team (Kanban) board.Feb 18 2025, 9:11 PM

Amdrel changed the task status from Open to In Progress.Feb 20 2025, 1:02 AM

Scardenasmolinar moved this task from In Progress to Eng review on the Moderator-Tools-Team (Kanban) board.Feb 21 2025, 12:11 AM

Kgraessle moved this task from Eng review to Reviewed (waiting for changes) on the Moderator-Tools-Team (Kanban) board.Feb 21 2025, 4:54 PM

Scardenasmolinar moved this task from Reviewed (waiting for changes) to QA on the Moderator-Tools-Team (Kanban) board.Feb 21 2025, 6:25 PM

GitHub PR: https://github.com/WikipediaLibrary/externallinks/pull/416

The index has been added to the production database. Once we see a completed pageproject_aggregate run, I'll move it on to Done and resolve.

It might be worth checking the cron job lock if we don't see it complete during its next scheduled run. While debugging the job I noticed if the lock is set when restarting the containers while a job is running that they can get stuck.

It looks like the migration finished

and the total links cron looks stuck, we should unlock it in admin

2025-02-24T14:50:19.355353250Z production_crons.1.xcpmy5x9ag24@prod    | [ ] organisations.user_lists_cron
2025-02-24T14:50:19.355362616Z production_crons.1.xcpmy5x9ag24@prod    | [ ] aggregates.link_aggregates_cron
2025-02-24T14:50:19.355371528Z production_crons.1.xcpmy5x9ag24@prod    | [ ] aggregates.user_aggregates_cron
2025-02-24T14:50:19.355411899Z production_crons.1.xcpmy5x9ag24@prod    | [ ] aggregates.pageproject_aggregates_cron
2025-02-24T14:50:19.355421357Z production_crons.1.xcpmy5x9ag24@prod    | [ ] common.backup
2025-02-24T14:50:19.355430204Z production_crons.1.xcpmy5x9ag24@prod    | extlinks.links.cron.TotalLinksCron: lock found. Will try later.

I unlocked total links cron

Kgraessle closed this task as Resolved.Feb 25 2025, 3:35 PM

	F58477533: image.png
	Feb 24 2025, 2:55 PM

Fix page project aggregates cron jobClosed, ResolvedPublic5 Estimated Story PointsActions

Description

Related Objects

Event Timeline

Fix page project aggregates cron job
Closed, ResolvedPublic5 Estimated Story Points
Actions