Maniphest T325642

Implement data expiry
Closed, ResolvedPublic5 Estimated Story Points
Actions

Assigned To

Authored By

	STran
	Dec 20 2022, 2:12 PM

Tags

Referenced Files

None

Subscribers

Description

Please write a script that:

Is expected to run at a set interval (set by systemd)
Checks the db for all rows older (based on the expiry column) than a set time (1-2 days, configurable?)
Deletes those rows

This ticket depends on T325637: Add expiry to db schema and how it defines expiry (whether or not it refers to the day it was inserted or the day it should be expired)

Details

	Title	Reference	Author	Source Branch	Dest Branch
	Implement data expiry	repos/mediawiki/services/ipoid!6	stran	add-data-expiration	main

Customize query in GitLab

Related Objects

Mentioned In: T305724: Investigate database data invalidation questions and chunked/timed API to MySQL/MariaDB ETL
Mentioned Here: T325637: Add expiry to db schema

Event Timeline

STran created this task.Dec 20 2022, 2:12 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 20 2022, 2:12 PM

Niharika set the point value for this task to 5.Dec 20 2022, 5:42 PM

STran edited projects, added Anti-Harassment (AHaT Sprint 29: The Ikseongwan); removed Anti-Harassment.Apr 17 2023, 5:28 PM

Tchanders moved this task from AHaT Sprint 29: The Ikseongwan to AHaT Sprint 30: Avanton Gold Cone on the Anti-Harassment board.Apr 25 2023, 1:03 PM

Tchanders edited projects, added Anti-Harassment (AHaT Sprint 30: Avanton Gold Cone); removed Anti-Harassment (AHaT Sprint 29: The Ikseongwan).

Tchanders assigned this task to STran.May 8 2023, 6:36 PM

STran moved this task from Ready 🎬 (ONLY IF YOU HAVE NO MORE CODE TO REVIEW) to In Progress 💪 on the Anti-Harassment (AHaT Sprint 30: Avanton Gold Cone) board.Jun 1 2023, 7:45 AM

ARamirez_WMF edited projects, added Anti-Harassment (AHaT Sprint 31 - The Fez); removed Anti-Harassment (AHaT Sprint 30: Avanton Gold Cone).Jun 6 2023, 5:14 PM

ARamirez_WMF moved this task from Ready 🎬 (ONLY IF YOU HAVE NO MORE CODE TO REVIEW) to In Progress 💪 on the Anti-Harassment (AHaT Sprint 31 - The Fez) board.

stran opened https://gitlab.wikimedia.org/repos/mediawiki/services/ipoid/-/merge_requests/6

Implement data expiry

CodeReviewBot added a project: Patch-For-Review.Jun 7 2023, 7:46 AM

STran moved this task from In Progress 💪 to Code Review 🔍 on the Anti-Harassment (AHaT Sprint 31 - The Fez) board.Jun 7 2023, 7:47 AM

STran moved this task from Backlog to In Progress on the iPoid-Service board.

kostajh mentioned this in T305724: Investigate database data invalidation questions and chunked/timed API to MySQL/MariaDB ETL.Jun 7 2023, 11:14 AM

kharlan updated https://gitlab.wikimedia.org/repos/mediawiki/services/ipoid/-/merge_requests/6

Implement data expiry

Maintenance_bot removed a project: Patch-For-Review.Jun 9 2023, 12:10 PM

tchanders merged https://gitlab.wikimedia.org/repos/mediawiki/services/ipoid/-/merge_requests/6

Implement data expiry

Tchanders moved this task from Code Review 🔍 to Done Q2 2022-2023 on the Anti-Harassment (AHaT Sprint 31 - The Fez) board.Jun 14 2023, 2:39 PM

STran moved this task from In Progress to Done on the iPoid-Service board.Jun 16 2023, 8:23 AM

Tchanders closed this task as Resolved.Aug 14 2023, 10:13 AM