Immediately check the PostgreSQL log files for detailed error messages surrounding the transaction rollback. You can use the following command to view the latest entries:
SELECT * FROM pg_catalog.pg_logs ORDER BY modification_time DESC LIMIT 5;
If pg_logs is not accessible or the command above does not work due to your PostgreSQL setup, locate the log files manually in the PostgreSQL data directory (pg_log folder) and use a command line tool to view the latest entries, for example:
tail -n 100 /var/log/postgresql/postgresql-<version>-main.log
Replace <version> with your PostgreSQL version. Examine the entries for any ERROR or WARNING lines that occurred around the time of the rollback. This should provide clues about why the transaction was rolled back.
Let Dr. Droid create custom investigation plans for your infrastructure.
Start Free POC (15-min setup) →
