Add NOT NULL constraint

What does this MR do and why?

This is a post deploy migration to add multi column NOT NULL to snippet_repositories as described in #550705 (closed)

migration output

   be rake db:migrate
main: == [advisory_lock_connection] object_id: 155740, pg_backend_pid: 84965
main: == 20250926194922 AddMultiColumnNotNullConstraintToSnippetRepositories: migrating
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0004s
main: -- execute("ALTER TABLE snippet_repositories VALIDATE CONSTRAINT check_0d1a38de4c;")
main:    -> 0.0011s
main: -- execute("RESET statement_timeout")
main:    -> 0.0003s
main: == 20250926194922 AddMultiColumnNotNullConstraintToSnippetRepositories: migrated (0.0396s)

main: == [advisory_lock_connection] object_id: 155740, pg_backend_pid: 84965
ci: == [advisory_lock_connection] object_id: 155740, pg_backend_pid: 84967
ci: == 20250926194922 AddMultiColumnNotNullConstraintToSnippetRepositories: migrating
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0003s
ci: -- execute("ALTER TABLE snippet_repositories VALIDATE CONSTRAINT check_0d1a38de4c;")
ci:    -> 0.0016s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0003s
ci: == 20250926194922 AddMultiColumnNotNullConstraintToSnippetRepositories: migrated (0.0162s)

ci: == [advisory_lock_connection] object_id: 155740, pg_backend_pid: 84967

Related to #550705 (closed)

Edited by Hunter Stewart

Merge request reports

Loading