Validate notes.noteable_type NOT NULL constraint SYNC
What does this MR do and why?
Validation was already run during the weekend in .com with !153029 (merged). Adding the sync migration with the db/structure.sql changes
DB review
Console output
UP
bin/rails db:migrate
main: == [advisory_lock_connection] object_id: 125740, pg_backend_pid: 345
main: == 20240527204206 ValidateNotesNoteableTypeNotNullConstraint: migrating =======
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0002s
main: -- execute("ALTER TABLE notes VALIDATE CONSTRAINT check_1244cbd7d0;")
main: -> 0.0003s
main: -- execute("RESET statement_timeout")
main: -> 0.0001s
main: == 20240527204206 ValidateNotesNoteableTypeNotNullConstraint: migrated (0.0163s)
main: == [advisory_lock_connection] object_id: 125740, pg_backend_pid: 345
ci: == [advisory_lock_connection] object_id: 125980, pg_backend_pid: 349
ci: == 20240527204206 ValidateNotesNoteableTypeNotNullConstraint: migrating =======
ci: -- execute("SET statement_timeout TO 0")
ci: -> 0.0002s
ci: -- execute("ALTER TABLE notes VALIDATE CONSTRAINT check_1244cbd7d0;")
ci: -> 0.0003s
ci: -- execute("RESET statement_timeout")
ci: -> 0.0001s
ci: == 20240527204206 ValidateNotesNoteableTypeNotNullConstraint: migrated (0.0075s)
ci: == [advisory_lock_connection] object_id: 125980, pg_backend_pid: 349
DOWN
bin/rails db:rollback:main db:rollback:ci
main: == [advisory_lock_connection] object_id: 125320, pg_backend_pid: 99538
main: == 20240527204206 ValidateNotesNoteableTypeNotNullConstraint: reverting =======
main: == 20240527204206 ValidateNotesNoteableTypeNotNullConstraint: reverted (0.0028s)
main: == [advisory_lock_connection] object_id: 125320, pg_backend_pid: 99538
ci: == [advisory_lock_connection] object_id: 125960, pg_backend_pid: 99786
ci: == 20240527204206 ValidateNotesNoteableTypeNotNullConstraint: reverting =======
ci: == 20240527204206 ValidateNotesNoteableTypeNotNullConstraint: reverted (0.0061s)
ci: == [advisory_lock_connection] object_id: 125960, pg_backend_pid: 99786
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.
Related to #443667 (closed)
Edited by Mario Celi