ActiveRecord::NotNullViolation: PG::NotNullViolation: ERROR: null value in column "environment_id" violates not-null constraint
https://sentry.gitlab.net/gitlab/gitlabcom/issues/1022111/
PG::NotNullViolation: ERROR: null value in column "environment_id" violates not-null constraint
DETAIL: Failing row contains (35445849, 18178, 4435291, null, feature/revise-wording-add-student, f, 880ae9de83f89dab67e62304032599b4af8e47d1, 1708472, 326079845, CommitStatus, 2019-10-20 23:56:28.230921, 2019-10-20 23:56:28.230921, stop_ci_test, null, 0, null).
active_record/connection_adapters/postgresql_adapter.rb:611:in `async_exec_params'
@connection.exec_params(sql, type_casted_binds)
active_record/connection_adapters/postgresql_adapter.rb:611:in `block (2 levels) in exec_no_cache'
@connection.exec_params(sql, type_casted_binds)
active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
yield
active_support/concurrency/share_lock.rb:187:in `yield_shares'
yield
active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
@lock.yield_shares(compatible: [:load]) do
...
(348 additional frame(s) were not displayed)
ActiveRecord::NotNullViolation: PG::NotNullViolation: ERROR: null value in column "environment_id" violates not-null constraint
DETAIL: Failing row contains (35445849, 18178, 4435291, null, feature/revise-wording-add-student, f, 880ae9de83f89dab67e62304032599b4af8e47d1, 1708472, 326079845, CommitStatus, 2019-10-20 23:56:28.230921, 2019-10-20 23:56:28.230921, stop_ci_test, null, 0, null).
: INSERT INTO "deployments" ("iid", "project_id", "ref", "tag", "sha", "user_id", "deployable_id", "deployable_type", "created_at", "updated_at", "on_stop", "status") VALUES (18178, 4435291, 'feature/revise-wording-add-student', FALSE, '880ae9de83f89dab67e62304032599b4af8e47d1', 1708472, 326079845, 'CommitStatus', '2019-10-20 23:56:28.230921', '2019-10-20 23:56:28.230921', 'stop_ci_test', 0) RETURNING "id"
ActiveRecord::NotNullViolation: PG::NotNullViolation: ERROR: null value in column "environment_id" violates not-null constraint
DETAIL: Failing row contains (35445849, 18178, 4435291, null, feature/revise-wording-add-student, f, 880ae9de83f89dab67e62304032599b4af8e47d1, 1708472, 326079845, CommitStatus, 2019-10-20 23:56:28.230921, 2019-10-20 23:56:28.230921, stop_ci_test, null, 0, null).
: INSERT INTO "deployments" ("iid", "project_id", "ref", "tag", "sha", "user_id", "deployable_id", "deployable_type", "created_at", "updated_at", "on_stop", "status") VALUES (18178, 4435291, 'feature/revise-wording-add-student', FALSE, '880ae9de83f89dab67e62304032599b4af8e47d1', 1708472, 326079845, 'CommitStatus', '2019-10-20 23:56:28.230921', '2019-10-20 23:56:28.230921', 'stop_ci_test', 0) RETURNING "id"
Related Logs
https://sentry.gitlab.net/gitlab/gitlabcom/issues/1022111/
https://log.gitlab.net/app/kibana#/discover?_g=h@8b5b71a&_a=h@f7f92e7
Related Tickets
https://gitlab.zendesk.com/agent/tickets/135900
https://gitlab.zendesk.com/agent/tickets/135879
Edited by Jerome Uy