Bug 1393191

Summary:	Database Integrity task_library 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:18:16 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:37:44 UTC

Description of problem:
Table task_bugzilla task_id is nullable which can lead to orphaned data. This should be nullable=False as to prevent this from happening.
As part of the migration script delete any orphans that could have occurred

Comment 1 Dan Callaghan 2017-12-20 06:43:12 UTC

On a recent production snapshot:

MySQL [beaker_dcallagh]> select count(*) from task_bugzilla where task_id is null;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.01 sec)

Comment 2 Dan Callaghan 2017-12-20 06:51:24 UTC

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

Comment 4 Dan Callaghan 2018-01-10 03:28:37 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:18:16 UTC

Beaker 25.0 has been released.

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