Failing migration in 9.5.0-pre 2b950014 : AddBroadcastMessageNotNullConstraints
Observed on 9.5.0-pre 2b950014 .
Running running migration on dev.gitlab.org is failing:
[execute] == 20170809134534 AddBroadcastMessageNotNullConstraints: migrating ============
-- change_column_null(:broadcast_messages, :starts_at, false)
-> 0.0005s
-- change_column_null(:broadcast_messages, :ends_at, false)
-> 0.0002s
-- change_column_null(:broadcast_messages, :created_at, false)
-> 0.0001s
-- change_column_null(:broadcast_messages, :updated_at, false)
-> 0.0001s
-- change_column_null(:broadcast_messages, :message_html, false)
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:
PG::NotNullViolation: ERROR: column "message_html" contains null values
: ALTER TABLE "broadcast_messages" ALTER "message_html" SET NOT NULL
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20170809134534_add_broadcast_message_not_null_constraints.rb:14:in `block in change'
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20170809134534_add_broadcast_message_not_null_constraints.rb:13:in `each'
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20170809134534_add_broadcast_message_not_null_constraints.rb:13:in `change'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:50:in `block (3 levels) in <top (required)>'
/opt/gitlab/embedded/bin/bundle:22:in `load'
/opt/gitlab/embedded/bin/bundle:22:in `<main>'
ActiveRecord::StatementInvalid: PG::NotNullViolation: ERROR: column "message_html" contains null values
: ALTER TABLE "broadcast_messages" ALTER "message_html" SET NOT NULL
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20170809134534_add_broadcast_message_not_null_constraints.rb:14:in `block in change'
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20170809134534_add_broadcast_message_not_null_constraints.rb:13:in `each'
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20170809134534_add_broadcast_message_not_null_constraints.rb:13:in `change'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:50:in `block (3 levels) in <top (required)>'
/opt/gitlab/embedded/bin/bundle:22:in `load'
/opt/gitlab/embedded/bin/bundle:22:in `<main>'
PG::NotNullViolation: ERROR: column "message_html" contains null values
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20170809134534_add_broadcast_message_not_null_constraints.rb:14:in `block in change'
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20170809134534_add_broadcast_message_not_null_constraints.rb:13:in `each'
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20170809134534_add_broadcast_message_not_null_constraints.rb:13:in `change'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:50:in `block (3 levels) in <top (required)>'
/opt/gitlab/embedded/bin/bundle:22:in `load'
/opt/gitlab/embedded/bin/bundle:22:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
@yorickpeterse Seems that you've introduced this change with https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/13429 .
Is there any action taken on this?
Edited by Marin Jankovski