May 2018
Intermediate to advanced
576 pages
30h 25m
English
First, check the setting of max_prepared_transactions:
SHOW max_prepared_transactions;
If your setting is more than zero, then check whether you have any prepared transactions. As an example, you may find something like the following:
postgres=# SELECT * FROM pg_prepared_xacts;-[ RECORD 1 ]------------------------------transaction | 459812gid | prep1prepared | 2017-04-11 13:21:51.912374+01owner | postgresdatabase | postgres
Here, the gid (global identifier) will usually have been automatically generated.