InternalError: current transaction is aborted, commands ignored until end of transaction block | Take Two

Hm... Starting to get the feeling this is the catch-all exception for Django, considering the wide range of scenarios in which people slam themselves against this error. (Although it's more frequent when using psycopg2, I hear.)

InternalError: current transaction is aborted, commands ignored until end of transaction block

This time, I was trying to restore a postgresql backup and that's all Django would give me locally. Turns out the users don't match between the servers, so no permissions were granted to anyone on the newly created database (\c <database>, \dp). GRANT ALL on every table, and my restore worked handsomely. (Edit: This command helps. A lot.)

(For another take on this error, see this previous post.)


Want to receive a weekly digest of new articles?

links

social