# PG::NotNullViolation: ERROR: null value in column "verification\_status" violates not-null constraint

**URL:** https://meta.discourse.org/t/pg-error-null-value-in-column-verification-status-violates-not-null-constraint/164303
**Category:** Bug
**Created:** [September 17, 2020, 4:08am UTC](https://meta.discourse.org/t/pg-error-null-value-in-column-verification-status-violates-not-null-constraint/164303 "2020-09-17T04:08:30Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![neounix](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/neounix/32/215617_2.png) [@neounix](https://meta.discourse.org/u/neounix)
#### Post date: [September 17, 2020, 4:08am UTC](https://meta.discourse.org/t/pg-error-null-value-in-column-verification-status-violates-not-null-constraint/164303/1 "2020-09-17T04:08:30Z")

</div>

Hello,

Just did a rebuild (a number of times, to remove some plugins) and it is crashed with this error:

```plaintext
Caused by:
PG::NotNullViolation: ERROR: null value in column "verification_status" violates not-null constraint
DETAIL: Failing row contains (-1, -1, d-logo-sketch.png, 14461, null, null, /images/d-logo-sketch.png, 2020-03-15 04:26:28.409885, 2020-03-15 04:26:28.409885, _aa4aed9d6276bab017d3991051fbb9177783abe, null, null, png, null, null, null, f, null, null, null, null).

```

Any clues how to fix this?

Thanks.

---

<div class="post-metadata">

### Author: ![martin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/martin/32/491371_2.png) [@martin](https://meta.discourse.org/u/martin)
#### Post date: [September 17, 2020, 4:25am UTC](https://meta.discourse.org/t/pg-error-null-value-in-column-verification-status-violates-not-null-constraint/164303/2 "2020-09-17T04:25:46Z")

</div>

I am working on this, just made a fix that I think will fix it:

[https://github.com/discourse/discourse/commit/c2a660ead38d278022ba00386887190ba0739544](https://github.com/discourse/discourse/commit/c2a660ead38d278022ba00386887190ba0739544)

---

<div class="post-metadata">

### Author: ![neounix](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/neounix/32/215617_2.png) [@neounix](https://meta.discourse.org/u/neounix)
#### Post date: [September 17, 2020, 4:28am UTC](https://meta.discourse.org/t/pg-error-null-value-in-column-verification-status-violates-not-null-constraint/164303/3 "2020-09-17T04:28:26Z")

</div>

Thanks @martin

Just tried to rebuild again, same error:

```plaintext
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.3/lib/active_record/tasks/database_tasks.rb:238:in `migrate'
/var/www/discourse/lib/tasks/db.rake:215:in `block in <main>'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rake-13.0.1/exe/rake:27:in `<top (required)>'
/usr/local/bin/bundle:23:in `load'
/usr/local/bin/bundle:23:in `<main>'

Caused by:
PG::NotNullViolation: ERROR: null value in column "verification_status" violates not-null constraint
DETAIL: Failing row contains (-1, -1, d-logo-sketch.png, 14461, null, null, /images/d-logo-sketch.png, 2020-03-15 04:26:28.409885, 2020-03-15 04:26:28.409885, _aa4aed9d6276bab017d3991051fbb9177783abe, null, null, png, null, null, null, f, null, null, null, null).
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-2.1.0/lib/patches/db/pg.rb:110:in `exec'

```

Not sure if it is relevant, but we run both a data and an app container.

No issues at all rebuilding the data container.

The error is only on the app container.

Let me know if you need more info from here.

```plaintext
FAILED
--------------------
Pups::ExecError: cd /var/www/discourse && su discourse -c 'bundle exec rake db:migrate' failed with return #<Process::Status: pid 3058 exit 1>
Location of failure: /pups/lib/pups/exec_command.rb:112:in `spawn'
exec failed with the params {"cd"=>"$home", "hook"=>"db_migrate", "cmd"=>["su discourse -c 'bundle exec rake db:migrate'"]}
54cb19cd99ea4d6e68a5d8c5daaecce6ee0b49593ec3b3625a458c73c67a4a0b
**FAILED TO BOOTSTRAP** please scroll up and look for earlier error messages, there may be more than one.
./discourse-doctor may help diagnose the problem.

```

---

<div class="post-metadata">

### Author: ![martin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/martin/32/491371_2.png) [@martin](https://meta.discourse.org/u/martin)
#### Post date: [September 17, 2020, 4:31am UTC](https://meta.discourse.org/t/pg-error-null-value-in-column-verification-status-violates-not-null-constraint/164303/4 "2020-09-17T04:31:16Z")

</div>

The commit has not yet reached the `tests-passed` branch, so the fix will not be there yet.

---

<div class="post-metadata">

### Author: ![neounix](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/neounix/32/215617_2.png) [@neounix](https://meta.discourse.org/u/neounix)
#### Post date: [September 17, 2020, 4:43am UTC](https://meta.discourse.org/t/pg-error-null-value-in-column-verification-status-violates-not-null-constraint/164303/6 "2020-09-17T04:43:53Z")

</div>

Thank you so much @martin

Fantastic support! Much appreciated.

Rebuild worked like a charm with your patch.

```plaintext
version: c2a660ead38d278022ba00386887190ba0739544

```

---

<div class="post-metadata">

### Author: ![martin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/martin/32/491371_2.png) [@martin](https://meta.discourse.org/u/martin)
#### Post date: [September 17, 2020, 4:46am UTC](https://meta.discourse.org/t/pg-error-null-value-in-column-verification-status-violates-not-null-constraint/164303/7 "2020-09-17T04:46:15Z")

</div>

Awesome! The patch is now in tests-passed so you should switch back when possible 😉

---

<div class="post-metadata">

### Author: ![neounix](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/neounix/32/215617_2.png) [@neounix](https://meta.discourse.org/u/neounix)
#### Post date: [September 17, 2020, 4:48am UTC](https://meta.discourse.org/t/pg-error-null-value-in-column-verification-status-violates-not-null-constraint/164303/8 "2020-09-17T04:48:43Z")

</div>

Incredible @martin

Done!

Back on `test-passed` and life is back to normal here.

## Thank you again for the amazingly fast support.

---

<div class="post-metadata">

### Author: ![martin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/martin/32/491371_2.png) [@martin](https://meta.discourse.org/u/martin)
#### Post date: [September 17, 2020, 7:18am UTC](https://meta.discourse.org/t/pg-error-null-value-in-column-verification-status-violates-not-null-constraint/164303/9 "2020-09-17T07:18:24Z")

</div>