Em ter, 28 de ago de 2018 às 13:18, Flavio Henrique Araque Gurgel <fhagur@xxxxxxxxx> escreveu:
Em ter, 28 de ago de 2018 às 13:15, <wambacher@xxxxxxxxx> escreveu:Hi,
there is only one process updating my database. and that is exactly the
job which is getting the error.
all other jobs are read/only and i even stoppend those.
but there has been a crash some hours ago.
Look if you have prepared transactions on the pg_prepared_transactions view.If you make use of JDBC it's possible that you use it without knowing and it survives Postgres restarts.If you have any, drop them.
Flavio Gurgel