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