Re: tuple concurrently updated

Поиск
Список
Период
Сортировка
От Flavio Henrique Araque Gurgel
Тема Re: tuple concurrently updated
Дата
Msg-id CAGHTAeMDRiB0wRXby6M3PCsv+9QLbBNxoDENTm=cCg3b1-DsxQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: tuple concurrently updated  (Flavio Henrique Araque Gurgel <fhagur@gmail.com>)
Ответы Re: tuple concurrently updated  (wambacher@posteo.de)
Список pgsql-admin


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 по дате отправления:

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