Maniphest T85867

Remove unused views from labsdb
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	yuvipanda
	Jan 5 2015, 10:02 PM

Tags

Referenced Files

None

Subscribers

Description

Currently:

hashs (T54927 for prod)
povwatch_log (T54924 for prod)
povwatch_subscribers (T54924 for prod)
pif_edits (part of https://www.mediawiki.org/wiki/Personal_image_filter ?? )

These were probably used at some point in teh long lone past, but labsdb should provide a consistent view of active MW tables, not long lost ones (we can make them available in other formats if necessary).

Details

	Subject	Repo	Branch	Lines +/-
	Remove hashs, pif_edits & povwatch* view from whitelist	operations/software/labsdb-auditor	master	+0 -22
	Drop pif_edits, povwatch_*	operations/software/labsdb-auditor	master	+0 -15
	Remove povwatch_* and pif_edits views	operations/software	master	+2 -2
	Remove ambigus, unused 'hashs' view	operations/software	master	+1 -1

Customize query in gerrit

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		• chasemp	T85866 Make labsdb views consistent with currently in-use set of tables / columns in production
		Resolved		• chasemp	T85867 Remove unused views from labsdb

Event Timeline

yuvipanda created this task.Jan 5 2015, 10:02 PM

yuvipanda raised the priority of this task from to Needs Triage.

yuvipanda updated the task description. (Show Details)

yuvipanda added a project: LabsDB-Auditor.

yuvipanda added subscribers: Aklapper, yuvipanda.

Change 183871 had a related patch set uploaded (by Yuvipanda):
Remove ambigus, unused 'hashs' view

https://gerrit.wikimedia.org/r/183871

Patch-For-Review

Change 183871 merged by Yuvipanda:
Remove ambigus, unused 'hashs' view

https://gerrit.wikimedia.org/r/183871

yuvipanda triaged this task as Medium priority.Jan 9 2015, 4:52 PM

Change 183872 had a related patch set uploaded (by Yuvipanda):
Remove hashs view from whitelist

https://gerrit.wikimedia.org/r/183872

Patch-For-Review

yuvipanda renamed this task from Remove hashs view from labsdb to Remove unused views from labsdb.Jan 9 2015, 4:57 PM

yuvipanda updated the task description. (Show Details)

yuvipanda set Security to None.

Change 183874 had a related patch set uploaded (by Yuvipanda):
Drop pif_edits, povwatch_*

https://gerrit.wikimedia.org/r/183874

Patch-For-Review

Change 183875 had a related patch set uploaded (by Yuvipanda):
Remove povwatch_* and pif_edits views

https://gerrit.wikimedia.org/r/183875

Patch-For-Review

Change 183875 merged by Yuvipanda:
Remove povwatch_* and pif_edits views

https://gerrit.wikimedia.org/r/183875

Change 183874 abandoned by Yuvipanda:
Drop pif_edits, povwatch_*

https://gerrit.wikimedia.org/r/183874

valhallasw updated the task description. (Show Details)Jan 10 2015, 5:25 PM

Change 183872 merged by Merlijn van Deen:
Remove hashs, pif_edits & povwatch* view from whitelist

https://gerrit.wikimedia.org/r/183872

yuvipanda mentioned this in rOSLAcce19b746b7b: Remove hashs, pif_edits & povwatch* view from whitelist.Mar 12 2015, 4:03 AM

hitcounter killed in https://gerrit.wikimedia.org/r/#/c/187119/

Restricted Application added a project: Cloud-Services. · View Herald TranscriptAug 15 2015, 1:16 AM

That could probably be dropped from production actually...

Luke081515 moved this task from Triage to Backlog on the Cloud-Services board.Mar 25 2016, 4:16 PM

• Phabricator_maintenance removed a subscriber: yuvipanda.Jun 7 2017, 6:56 PM

• chasemp closed this task as Resolved.Jan 2 2020, 9:01 PM

• chasemp claimed this task.