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 CAGHTAeMDw7Qd6zkwkxYb36BHGaoCPXk6Q-a8MCNkyT8FOrkbKg@mail.gmail.com
Whole thread Raw
In response to Re: tuple concurrently updated  (wambacher@posteo.de)
Responses Re: tuple concurrently updated  (Flavio Henrique Araque Gurgel <fhagur@gmail.com>)
Re: tuple concurrently updated  (wambacher@posteo.de)
List pgsql-admin
Tree view


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: 066ce286@free.fr
Date:
Subject: Re: tuple concurrently updated
Next
From: Flavio Henrique Araque Gurgel
Date:
Subject: Re: tuple concurrently updated