Re: tuple concurrently updated

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: wambacher(at)posteo(dot)de
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: tuple concurrently updated
Date: 2018-08-28 13:51:34
Message-ID: 20180828135134.o4ymb6vvitpfcmxc@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 2018-Aug-28, wambacher(at)posteo(dot)de wrote:

> getting this error:
>
> DELETE FROM planet_osm_line WHERE osm_id = -166570;
> FEHLER:  tuple concurrently updated
>
> postgresql 10.1
>
> any idea what i can do? of course i did a restart first.

What is the definition of the table? It sounds like there's some GIS
datatype -- Right? Are there any triggers or some other fun fact about
this delete? What is the isolation level in effect when the delete
runs?

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Walter Nordmann 2018-08-28 13:58:13 Re: tuple concurrently updated
Previous Message 066ce286 2018-08-28 13:46:02 Re: tuple concurrently updated