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

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

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(dot)klaver(at)aklaver(dot)com