Skip to content

Drop unused columns in sent_notifications

What does this MR do and why?

Drop unused columns in sent_notifications

These columns have already been ignored in the previous release

Migration output

main: == [advisory_lock_connection] object_id: 223660, pg_backend_pid: 45826
main: == 20230626070723 DropUnusedSentNotificationColumns: migrating ================
main: -- remove_column(:sent_notifications, :line_code)
main:    -> 0.0045s
main: -- remove_column(:sent_notifications, :note_type)
main:    -> 0.0005s
main: -- remove_column(:sent_notifications, :position)
main:    -> 0.0006s
main: == 20230626070723 DropUnusedSentNotificationColumns: migrated (0.0098s) =======
main: == [advisory_lock_connection] object_id: 223660, pg_backend_pid: 45826
ci: == [advisory_lock_connection] object_id: 223900, pg_backend_pid: 45828
ci: == 20230626070723 DropUnusedSentNotificationColumns: migrating ================
ci: -- remove_column(:sent_notifications, :line_code)
ci:    -> 0.0025s
ci: -- remove_column(:sent_notifications, :note_type)
ci:    -> 0.0003s
ci: -- remove_column(:sent_notifications, :position)
ci:    -> 0.0006s
ci: == 20230626070723 DropUnusedSentNotificationColumns: migrated (0.0127s) =======
ci: == [advisory_lock_connection] object_id: 223900, pg_backend_pid: 45828
main: == [advisory_lock_connection] object_id: 223220, pg_backend_pid: 46278
main: == 20230626070723 DropUnusedSentNotificationColumns: reverting ================
main: -- add_column(:sent_notifications, :line_code, :string)
main:    -> 0.0027s
main: -- add_column(:sent_notifications, :note_type, :string)
main:    -> 0.0008s
main: -- add_column(:sent_notifications, :position, :text)
main:    -> 0.0006s
main: == 20230626070723 DropUnusedSentNotificationColumns: reverted (0.0083s) =======
ci: == [advisory_lock_connection] object_id: 223160, pg_backend_pid: 46705
ci: == 20230626070723 DropUnusedSentNotificationColumns: reverting ================
ci: -- add_column(:sent_notifications, :line_code, :string)
ci:    -> 0.0017s
ci: -- add_column(:sent_notifications, :note_type, :string)
ci:    -> 0.0005s
ci: -- add_column(:sent_notifications, :position, :text)
ci:    -> 0.0004s
ci: == 20230626070723 DropUnusedSentNotificationColumns: reverted (0.0110s) =======
ci: == [advisory_lock_connection] object_id: 223160, pg_backend_pid: 46705

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #416155 (closed)

Edited by Heinrich Lee Yu

Merge request reports