I'm attempting to restore a postgres DB backup on to my local dev environment but I encounter an error when trying to login as the admin user (the salient parts being):
SQLSTATE: Not null violation: 7 ERROR: null value in column "id" violates not-null constraint
The SQL being executed was: INSERT INTO "sessions"
So it seems as though it correctly authenticates my username and password and then tries to create a new entry in the sessions table but fails to do so because the session service is returning a null value.
Is this interpretation correct?
I'm using redis for my session storage, so I tried clearing the keys from there but it doesn't fix the issue.
I'm really blocked on this one and would appreciate any thoughts!