Bug 1393185

Summary:	Database Integrity Scheduler recipe_task_bugzilla
Product:	[Retired] Beaker	Reporter:	Tyrone Abdy <tabdy>
Component:	general	Assignee:	Dan Callaghan <dcallagh>
Status:	CLOSED CURRENTRELEASE	QA Contact:	tools-bugs <tools-bugs>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	develop	CC:	dcallagh, mjia, rjoost
Target Milestone:	25.0	Keywords:	Patch
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2018-03-19 04:19:10 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Tyrone Abdy 2016-11-09 04:09:56 UTC

Description of problem:
On table recipe_task_bugzilla coulmn recipe_task_id is nullable which can lead to orphans. This should be nullable=False.
As part of the migration script deletion of orphans should be done as there could be due to the nature of the constraint.

Comment 1 Dan Callaghan 2017-12-20 06:21:28 UTC

The recipe_task_bugzilla table has never actually been used, we should just drop it.

Comment 2 Dan Callaghan 2017-12-20 06:50:59 UTC

https://gerrit.beaker-project.org/5962

Comment 4 Dan Callaghan 2018-01-10 03:28:30 UTC

There is no expected change in behaviour here, so verification should just be that the database migration succeeds (it did) and that nothing else breaks.

Comment 6 Roman Joost 2018-03-19 04:19:10 UTC

Beaker 25.0 has been released.

Release notes are available upstream: https://beaker-project.org/docs/whats-new/release-25.html