Maniphest T102224

{tick} Schema Audit
Closed, ResolvedPublic
Actions

Description

Objective: Audit EventLogging Schemas
Key Result: All EL schemas are reviewed and properly categorized on the meta wiki, data is sanitized accordingly.

Here is a list of all schemas:
https://meta.wikimedia.org/w/index.php?title=Special%3APrefixIndex&prefix=&namespace=470

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		Milimetric	T102224 {tick} Schema Audit
		Resolved		mforns	T102515 Gather information on all the schemas {tick} [13 pts]
		Resolved		mforns	T102517 Reach out to half the schema owners [8 pts] {tick}
		Resolved		• madhuvishy	T102712 [Spike] Research best methods to track and update EL schema talk pages {tick}
		Resolved		• madhuvishy	T103133 Update Schema Talk pages {tick} [8 pts]
		Duplicate		None	T102518 enforce policy for each Schema [8 pts] {tick}
		Resolved		None	T103202 Event Logging Schema Ownership and Maintenance
		Resolved		• madhuvishy	T103366 Gather information on all the schemas {tick} [13 pts]
		Resolved		• madhuvishy	T103380 Reach out to half the schema owners [8 pts] {tick}
		Resolved		None	T104351 Host a debrief of EventLogging cleanup {tick}
		Duplicate		mforns	T104877 Enforce policy for each schema: Sanitize {tick} [8 pts]
		Resolved		mforns	T108857 Delete obsolete schemas {tick} [5 pts]
		Resolved		• madhuvishy	T110247 Archive obsolete schema pages {tick} [5 pts]
		Resolved		None	T108850 Set up auto-purging after 90 days {tick}
		Resolved		jcrespo	T108856 Set up bucketization of editCount fields {tick}
		Resolved		jcrespo	T104748 db1046 innodb signal 6 abort and restart
		Resolved		mforns	T135190 Respawn the schema/field white-list for EL auto-purging {tick}
		Resolved		• elukey	T156933 Improve purging for analytics-slave data on Eventlogging
		Resolved		• elukey	T168414 Purge all old data from EventLogging master
		Resolved		jcrespo	T183123 Precautionary backup needed for the log database on db1107 before applying regular purging/sanitization
		Declined		mforns	T105065 Delete all data from EventLogging:PersonalBar schema {tick}
		Invalid		mforns	T106558 Make EventLogging code mark new tables for purging as default {tick}

Event Timeline

• kevinator created this task.Jun 12 2015, 7:26 AM

• kevinator raised the priority of this task from to Needs Triage.

• kevinator updated the task description. (Show Details)

• kevinator added a subscriber: • kevinator.

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 12 2015, 7:26 AM

• kevinator triaged this task as Medium priority.Jun 12 2015, 7:26 AM

• kevinator added projects: Analytics-Kanban, Analytics-EventLogging.

• kevinator set Security to None.

• kevinator moved this task from Next Up to Parent Tasks on the Analytics-Kanban board.

• kevinator renamed this task from {tick} EventLogging Schema Audit to {tick} Schema Audit.Jun 12 2015, 7:36 AM

see doc:
https://docs.google.com/spreadsheets/d/1EDy5SwWCE2Tz1STzWoUi478usJaUK1cVmScyCv87pdk/edit#gid=0

• kevinator updated the task description. (Show Details)Jun 12 2015, 9:02 PM

• kevinator added subtasks: T102515: Gather information on all the schemas {tick} [13 pts], T102517: Reach out to half the schema owners [8 pts] {tick}, T102518: enforce policy for each Schema [8 pts] {tick}, T102712: [Spike] Research best methods to track and update EL schema talk pages {tick}, T103133: Update Schema Talk pages {tick} [8 pts], T103366: Gather information on all the schemas {tick} [13 pts], T103380: Reach out to half the schema owners [8 pts] {tick}, T104351: Host a debrief of EventLogging cleanup {tick}, T104877: Enforce policy for each schema: Sanitize {tick} [8 pts], T105065: Delete all data from EventLogging:PersonalBar schema {tick}, T106558: Make EventLogging code mark new tables for purging as default {tick}.Jul 28 2015, 4:33 AM

• kevinator closed subtask T103380: Reach out to half the schema owners [8 pts] {tick} as Resolved.Jul 31 2015, 3:22 PM

• kevinator closed subtask T102517: Reach out to half the schema owners [8 pts] {tick} as Resolved.Aug 14 2015, 3:20 PM

mforns closed subtask T105065: Delete all data from EventLogging:PersonalBar schema {tick} as Declined.Aug 20 2015, 5:13 PM

• kevinator closed subtask T103133: Update Schema Talk pages {tick} [8 pts] as Resolved.Aug 27 2015, 10:53 PM

mforns closed subtask T106558: Make EventLogging code mark new tables for purging as default {tick} as Invalid.Sep 10 2015, 4:49 PM

mforns added a subtask: T108850: Set up auto-purging after 90 days {tick}.Nov 17 2015, 11:23 AM

Nuria closed subtask T104351: Host a debrief of EventLogging cleanup {tick} as Resolved.May 2 2016, 4:44 PM

This project's done

• elukey closed subtask T108850: Set up auto-purging after 90 days {tick} as Resolved.Jan 18 2018, 5:02 PM