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

On 10/11/19 1:56 PM, wambacher@posteo.de wrote:
> 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)

By system do you mean just Postgres or the computer as a whole?

>>
>> 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

Have you tried a REINDEX?

> 
> 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
> 
> 
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com