Null value in column "pqgroup_eusage" violates not-null constraintDETAIL: Failing row contains (6, 4, 0/259, data1, null, 4831838208, root, root, 755, 2017-02-14 17:12:34.201143 00, data1, f, no, 0, 0, 2015/4, null, null)

Support
7

@Flyer and @holmkvist

Whilst looking into the related:

I have manged to reproduce the issue reported in this thread.

Install 3.8.16-1.iso
activate testing channel updates
- not sure if this interim version is relevant but anyway
yum update rockstor-3.8.16-10
(accept GPG key)
reboot
no errors.
yum update rockstor-3.8.16-11
Confirmed via rpm console that the db migration associated with this version was successful
also:
SELECT pqgroup_rusage FROM storageadmin_share;
 pqgroup_rusage 
----------------
              0
              0
(2 rows)
So we have the new db entries

then when attempting to create a share in rockstor_rockstor pool:

IntegrityError: null value in column "pqgroup_eusage" violates not-null constraint
DETAIL:  Failing row contains (12, 1, 0/263, test-share, null, 7025459, root, root, 755, 2017-03-07 16:57:44.890215+00, test-share, f, null, 0, 0, 2015/12, null, null).

But the good news is that after a reboot all subsequent share creations function as expected. Note also that the initial share creation that triggered the error took effect.

So looks like this one was not a missing db entry (via failed db migration) but as a result of stale code following the 3.8.16-11 update.

Popping in this thread so that we know how this might be reproduced.

1 Like