Postgres Pro
Downloads
Home   >   mailing lists

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

From Adrian Klaver
Subject Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840failed: FEHLER: tuple concurrently updated
Date
Msg-id 3e664979-a015-bf0c-0569-82b2a797f6a7@aklaver.com
Whole thread Raw
In response to got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed:FEHLER: tuple concurrently updated  (wambacher@posteo.de)
Responses Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840failed: FEHLER: tuple concurrently updated
List pgsql-general
Tree view 
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?

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.klaver@aklaver.com

pgsql-general by date:

Previous
From: wambacher@posteo.de
Date:
Subject: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed:FEHLER: tuple concurrently updated
Next
From: Adrian Klaver
Date:
Subject: Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840failed: FEHLER: tuple concurrently updated