Bug 1393191 - Database Integrity task_library task_bugzilla
Summary: Database Integrity task_library task_bugzilla
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Beaker
Classification: Retired
Component: general
Version: develop
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: 25.0
Assignee: Dan Callaghan
QA Contact: tools-bugs
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-11-09 04:37 UTC by Tyrone Abdy
Modified: 2018-03-19 04:18 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-03-19 04:18:16 UTC
Embargoed:


Attachments (Terms of Use)

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


Note You need to log in before you can comment on or make changes to this bug.