Postgres Pro
Downloads
Home   >   mailing lists

Re: tuple concurrently updated - Mailing list pgsql-admin

From Flavio Henrique Araque Gurgel
Subject Re: tuple concurrently updated
Date
Msg-id CAGHTAeMDRiB0wRXby6M3PCsv+9QLbBNxoDENTm=cCg3b1-DsxQ@mail.gmail.com
Whole thread Raw
In response to Re: tuple concurrently updated  (Flavio Henrique Araque Gurgel <fhagur@gmail.com>)
Responses Re: tuple concurrently updated  (wambacher@posteo.de)
List pgsql-admin
Tree view


Em ter, 28 de ago de 2018 às 13:18, Flavio Henrique Araque Gurgel <fhagur@gmail.com> escreveu:
Em ter, 28 de ago de 2018 às 13:15, <wambacher@posteo.de> 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.


My mistake, it's pg_prepared_xacts the correct name.
Flavio Gurgel

pgsql-admin by date:

Previous
From: Flavio Henrique Araque Gurgel
Date:
Subject: Re: tuple concurrently updated
Next
From: wambacher@posteo.de
Date:
Subject: Re: tuple concurrently updated