Maniphest T143963

The Great Echo Database Cleanup of 2016 (and 2019)
Open, Needs TriagePublic
Actions

Assigned To

None

Authored By

	Catrope
	Aug 26 2016, 12:53 AM

Tags

Referenced Files

None

Subscribers

Tokens

"Party Time" token, awarded by Jdforrester-WMF.

Description

Ready

Blocked / status unknown

T143964: Paginate notifications by event ID, not timestamp (needs patch so that we can then fix T72363: Echo notification table indexes don't support the new feature changes)
Merge Matthias's patch for T124687: Preferentially purge read notifications before unread, then rerun purge script

Done

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Open		None	T143963 The Great Echo Database Cleanup of 2016 (and 2019)
		Resolved		Marostegui	T136428 Add primary key to echo_notification table
		Resolved		Marostegui	T136427 Remove event_page_namespace and event_page_title
		Resolved		Marostegui	T143763 Remove unused bundling DB fields
		Resolved		Marostegui	T143961 Add index on event_page_id on echo_event table
		Open		None	T143964 Paginate notifications by event ID, not timestamp
		Resolved		Halfak	T143962 Add uniqueness constraints to ores_classification
		Invalid		jcrespo	T145317 Do the schema changes for uniqueness constraints.
		Resolved		Marostegui	T217453 Remove etp_user from echo_target_page in production
		Resolved		SBisson	T143959 Remove etp_user from echo_target_page
		Resolved		Ladsgroup	T337310 Remove notification_seen column from echo_notifications database table

Event Timeline

Catrope created this task.Aug 26 2016, 12:53 AM

Restricted Application added a project: Collaboration-Team-Triage. · View Herald TranscriptAug 26 2016, 12:53 AM

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

Catrope updated the task description. (Show Details)Aug 26 2016, 1:31 AM

Catrope added subtasks: T136428: Add primary key to echo_notification table, T136427: Remove event_page_namespace and event_page_title, T143763: Remove unused bundling DB fields, T143959: Remove etp_user from echo_target_page, T143961: Add index on event_page_id on echo_event table, T143964: Paginate notifications by event ID, not timestamp, T143962: Add uniqueness constraints to ores_classification.

Catrope updated the task description. (Show Details)Aug 26 2016, 1:36 AM

Jay8g subscribed.Aug 26 2016, 5:17 AM

• jmatazzoni moved this task from Untriaged to Tracking tickets on the Collaboration-Team-Triage board.Aug 29 2016, 10:35 PM

Catrope mentioned this in T143961: Add index on event_page_id on echo_event table.Aug 30 2016, 1:10 AM

Paladox subscribed.Sep 4 2016, 1:28 PM

Halfak closed subtask T143962: Add uniqueness constraints to ores_classification as Resolved.Sep 14 2016, 12:57 AM

• jmatazzoni closed subtask T143959: Remove etp_user from echo_target_page as Resolved.Oct 11 2016, 12:31 AM

Marostegui closed subtask T136428: Add primary key to echo_notification table as Resolved.Feb 15 2017, 8:30 AM

Catrope added a subtask: T217453: Remove etp_user from echo_target_page in production.Mar 2 2019, 1:00 AM

Catrope removed a subtask: T143959: Remove etp_user from echo_target_page.

Catrope updated the task description. (Show Details)

Restricted Application added a project: Growth-Team. · View Herald TranscriptMar 2 2019, 1:00 AM

Catrope updated the task description. (Show Details)Mar 2 2019, 1:01 AM

Catrope renamed this task from The Great Echo Database Cleanup of 2016 to The Great Echo Database Cleanup of 2016 (and 2019).Mar 4 2019, 9:09 PM

Catrope updated the task description. (Show Details)

JTannerWMF moved this task from Inbox to Q1 2019-20 on the Growth-Team board.Mar 5 2019, 7:52 PM

Catrope updated the task description. (Show Details)Mar 7 2019, 6:24 PM

Marostegui changed the status of subtask T217453: Remove etp_user from echo_target_page in production from Open to Stalled.Mar 8 2019, 2:34 PM

Jdforrester-WMF awarded a token.Mar 14 2019, 5:07 PM

Catrope updated the task description. (Show Details)Mar 14 2019, 8:44 PM

Marostegui closed subtask T143961: Add index on event_page_id on echo_event table as Resolved.Apr 2 2019, 6:50 AM

Marostegui closed subtask T143763: Remove unused bundling DB fields as Resolved.Apr 8 2019, 7:02 AM

Marostegui changed the status of subtask T217453: Remove etp_user from echo_target_page in production from Stalled to Open.Apr 8 2019, 7:05 AM

Marostegui closed subtask T217453: Remove etp_user from echo_target_page in production as Resolved.Apr 10 2019, 10:15 AM

Marostegui updated the task description. (Show Details)Apr 10 2019, 10:19 AM

Marostegui updated the task description. (Show Details)

SBisson mentioned this in W2269 Echo Tasks.Apr 17 2019, 3:10 PM

Marostegui closed subtask T136427: Remove event_page_namespace and event_page_title as Resolved.Apr 23 2019, 6:20 AM

Marostegui updated the task description. (Show Details)

MBinder_WMF added a project: Growth-Team-Filtering.Apr 15 2021, 6:59 PM

Aklapper removed a project: Collaboration-Team-Triage.May 25 2021, 9:09 PM

Ladsgroup closed subtask T337310: Remove notification_seen column from echo_notifications database table as Resolved.Sep 12 2023, 10:00 AM

Ladsgroup updated the task description. (Show Details)

Ladsgroup updated the task description. (Show Details)