Maniphest T143962

Add uniqueness constraints to ores_classification
Closed, ResolvedPublic
Actions

Description

For each revision+model+class, there should only be one score, and for each revision+model only one class should be the predicted one.

Details

	Subject	Repo	Branch	Lines +/-
	Add UNIQUE indexes to ores_classification	mediawiki/extensions/ORES	master	+13 -2

Customize query in gerrit

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Open		None	T143963 The Great Echo Database Cleanup of 2016 (and 2019)
		Resolved		Halfak	T143962 Add uniqueness constraints to ores_classification
		Invalid		jcrespo	T145317 Do the schema changes for uniqueness constraints.

Event Timeline

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

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptAug 26 2016, 12:44 AM

Change 306854 had a related patch set uploaded (by Catrope):
Add UNIQUE indexes to ores_classification

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

gerritbot added a project: Patch-For-Review.Aug 26 2016, 12:45 AM

Catrope mentioned this in T143963: The Great Echo Database Cleanup of 2016 (and 2019).Aug 26 2016, 12:53 AM

Catrope added a parent task: T143963: The Great Echo Database Cleanup of 2016 (and 2019).Aug 26 2016, 1:32 AM

Ladsgroup added a project: Schema-change.Aug 26 2016, 8:42 AM

Ladsgroup added a project: Machine-Learning-Team (Active Tasks).Aug 26 2016, 8:59 AM

@Catrope, do you want to assign this task to yourself since you started work?

Change 306854 merged by jenkins-bot:
Add UNIQUE indexes to ores_classification

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

Ladsgroup moved this task from Review to Completed on the Machine-Learning-Team (Active Tasks) board.Sep 11 2016, 5:21 AM

Ladsgroup created subtask T145317: Do the schema changes for uniqueness constraints. .Sep 11 2016, 5:24 AM

ReleaseTaggerBot added a project: MW-1.28-release (WMF-deploy-2016-09-13_(1.28.0-wmf.19)).Sep 11 2016, 6:00 AM

Ladsgroup moved this task from Completed to Parked on the Machine-Learning-Team (Active Tasks) board.Sep 11 2016, 9:41 AM

Okay. It was only bad data in the beta cluster. We are okay to deploy this change

jcrespo closed subtask T145317: Do the schema changes for uniqueness constraints. as Invalid.Sep 11 2016, 3:14 PM

• MZMcBride subscribed.Sep 12 2016, 5:05 AM

Halfak closed this task as Resolved.Sep 14 2016, 12:57 AM

Halfak claimed this task.