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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: wambacher(at)posteo(dot)de, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated
Date: 2019-10-11 19:42:14
Message-ID: 3e664979-a015-bf0c-0569-82b2a797f6a7@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

2) What is logged just before the crash?

3) By crash do you mean the Postgres server shuts down?

4) Does this happen every time you delete -390840?

5) Is -390840 really the value?
If so what is the definition for the osm_id column?

>
> regards
>
> walter
>
> --
> My projects:
>
> Admin Boundaries of the World <https://wambachers-osm.website/boundaries>
> Missing Boundaries
> <https://wambachers-osm.website/index.php/projekte/internationale-administrative-grenzen/missing-boundaries>
> Emergency Map <https://wambachers-osm.website/emergency>
> Postal Code Map (Germany only) <https://wambachers-osm.website/plz>
> Fools (QA for zipcodes in Germany) <https://wambachers-osm.website/fools>
> Postcode Boundaries of Germany <https://wambachers-osm.website/pcoundaries>
> OSM Software Watchlist
> <https://wambachers-osm.website/index.php/osm-software-watchlist>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-10-11 19:47:36 Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated
Previous Message wambacher 2019-10-11 17:28:09 got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated