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

by

This is what postgres does when a query produces an error and you try to run another query without first rolling back the transaction. (You might think of it as a safety feature, to keep you from corrupting your data.)

To fix this, you’ll want to figure out where in the code that bad query is being executed. It might be helpful to use the log_statement and log_min_error_statement options in your postgresql server.

More Related Contents:

  1. How to set up a PostgreSQL database in Django
  2. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  3. psycopg2: insert multiple rows with one query
  4. Parameterized queries with psycopg2 / Python DB-API and PostgreSQL
  5. Passing table name as a parameter in psycopg2
  6. error installing psycopg2, library not found for -lssl
  7. Use Django ORM as standalone [duplicate]
  8. GeoDjango on Windows: “Could not find the GDAL library” / “OSError: [WinError 126] The specified module could not be found”
  9. Django connection to postgres by docker-compose
  10. Composite primary key in django
  11. psycopg2.OperationalError: FATAL: unsupported frontend protocol 1234.5679: server supports 2.0 to 3.0
  12. Psycopg2 image not found
  13. Can’t install psycopg2 with pip in virtualenv on Mac OS X 10.7
  14. How do you join two tables on a foreign key field using django ORM?
  15. Error Installing Psycopg2 on MacOS 10.9.5
  16. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  17. Create a Postgres database using python
  18. Case insensitive unique model fields in Django?
  19. Django JSONField filtering
  20. Django ConnectionAbortedError: [WinError 10053] An established connection was aborted by the software in your host machine
  21. Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
  22. Python/postgres/psycopg2: getting ID of row just inserted
  23. How to set connection timeout in SQLAlchemy
  24. Deploying Django to Heroku (Psycopg2 Error)
  25. Mac + virtualenv + pip + postgresql = Error: pg_config executable not found
  26. How to perform filtering with a Django JSONField?
  27. Psycopg2, Postgresql, Python: Fastest way to bulk-insert
  28. Insert Python Dictionary using Psycopg2
  29. Use binary COPY table FROM with psycopg2
  30. How Postgresql COPY TO STDIN With CSV do on conflic do update?

Leave a Comment