Skip to content

Drop merge_requests_closing_issues.closes_work_item column

Mario Celi requested to merge 465389-drop-column into master

What does this MR do and why?

The column was never used and now can be safely removed as described in #465389 (closed)

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

DB review

Console output

UP

bin/rails db:migrate
main: == [advisory_lock_connection] object_id: 127920, pg_backend_pid: 69673
main: == 20240618174204 RemoveMergeRequestsClosingIssuesClosesWorkItemColumn: migrating
main: -- remove_column(:merge_requests_closing_issues, :closes_work_item)
main:    -> 0.0028s
main: == 20240618174204 RemoveMergeRequestsClosingIssuesClosesWorkItemColumn: migrated (0.0060s)

main: == [advisory_lock_connection] object_id: 127920, pg_backend_pid: 69673
ci: == [advisory_lock_connection] object_id: 128300, pg_backend_pid: 69675
ci: == 20240618174204 RemoveMergeRequestsClosingIssuesClosesWorkItemColumn: migrating
ci: -- remove_column(:merge_requests_closing_issues, :closes_work_item)
ci:    -> 0.0040s
ci: == 20240618174204 RemoveMergeRequestsClosingIssuesClosesWorkItemColumn: migrated (0.0096s)

ci: == [advisory_lock_connection] object_id: 128300, pg_backend_pid: 69675

DOWN

bin/rails db:rollback:main db:rollback:ci
main: == [advisory_lock_connection] object_id: 127580, pg_backend_pid: 71922
main: == 20240618174204 RemoveMergeRequestsClosingIssuesClosesWorkItemColumn: reverting
main: -- add_column(:merge_requests_closing_issues, :closes_work_item, :boolean, {:default=>true, :null=>false})
main:    -> 0.0037s
main: == 20240618174204 RemoveMergeRequestsClosingIssuesClosesWorkItemColumn: reverted (0.0065s)

main: == [advisory_lock_connection] object_id: 127580, pg_backend_pid: 71922
ci: == [advisory_lock_connection] object_id: 128780, pg_backend_pid: 72170
ci: == 20240618174204 RemoveMergeRequestsClosingIssuesClosesWorkItemColumn: reverting
ci: -- add_column(:merge_requests_closing_issues, :closes_work_item, :boolean, {:default=>true, :null=>false})
ci:    -> 0.0034s
ci: == 20240618174204 RemoveMergeRequestsClosingIssuesClosesWorkItemColumn: reverted (0.0113s)

ci: == [advisory_lock_connection] object_id: 128780, pg_backend_pid: 72170

Related to #465389 (closed)

Edited by Mario Celi

Merge request reports