Re: tuple concurrently updated - Mailing list pgsql-admin

From wambacher@posteo.de
Subject Re: tuple concurrently updated
Date
Msg-id f8cfb91f-a205-0530-25df-09f806d7ca5c@posteo.de
Whole thread Raw
In response to Re: tuple concurrently updated  (Flavio Henrique Araque Gurgel <fhagur@gmail.com>)
List pgsql-admin

 pg_prepared_transactions does not exist, or i don't know how to list that

Am 28.08.2018 um 13:18 schrieb Flavio Henrique Araque Gurgel:


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.

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