Re: tuple concurrently updated

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux