Hi Adrin,
Am 11.10.19 um 21:42 schrieb Adrian Klaver:
> On 10/11/19 10:28 AM, wambacher@posteo.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