Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated

Hi Adrin,

Am 11.10.19 um 21:42 schrieb Adrian Klaver:
> On 10/11/19 10:28 AM, wambacher(at)posteo(dot)de wrote:
>> Hi, after a crash i get this errpor: DELETE FROM planet_osm_line
>> WHERE osm_id = -390840 failed: FEHLER:  tuple concurrently updated
>>
>> any idea what i can do?
>
> More information would be helpful:
>
> 1) Postgres version?
10.1
>
> 2) What is logged just before the crash?
will have to check this later.
>
> 3) By crash do you mean the Postgres server shuts down?
no, system hang and i had to do a power reset (nothing else helped)
>
> 4) Does this happen every time you delete -390840?
yes
>
> 5) Is -390840 really the value?
yes
> If so what is the definition for the osm_id column?

bigint,

index "planet_osm_line_pkey" btree (osm_id), Tablespace »planet3_is1

and there is no trigger on this table.

i wrote a pg/plsql function reading the table line by line using an
exception condition and writing all records to a new table. program is
running and some records have been ignored. it is quite easy to re-add
the missing records - hope so.

regards

walter