Re: tuple concurrently updated

Поиск
Список
Период
Сортировка
От wambacher@posteo.de
Тема Re: tuple concurrently updated
Дата
Msg-id f8cfb91f-a205-0530-25df-09f806d7ca5c@posteo.de
обсуждение исходный текст
Ответ на Re: tuple concurrently updated  (Flavio Henrique Araque Gurgel <fhagur@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Flavio Henrique Araque Gurgel
Дата:
Сообщение: Re: tuple concurrently updated
Следующее
От: wambacher@posteo.de
Дата:
Сообщение: Re: tuple concurrently updated