From: | wambacher(at)posteo(dot)de |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: tuple concurrently updated |
Date: | 2018-08-28 14:00:39 |
Message-ID: | f67fa1c1-5b91-0b11-8693-f3fd511c82e5@posteo.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
updates are done using a program, that is without my control: osm2pgsql.
this program does everthing which is necessary including locking. and
it't running for years on many, many openstreetmap servers.
because there was a crash before, it must be a data corruption problem,
not programming error.
regards
walter
Am 28.08.2018 um 15:51 schrieb Alvaro Herrera:
> On 2018-Aug-28, wambacher(at)posteo(dot)de wrote:
>
>> getting this error:
>>
>> DELETE FROM planet_osm_line WHERE osm_id = -166570;
>> FEHLER: tuple concurrently updated
>>
>> postgresql 10.1
>>
>> any idea what i can do? of course i did a restart first.
> What is the definition of the table? It sounds like there's some GIS
> datatype -- Right? Are there any triggers or some other fun fact about
> this delete? What is the isolation level in effect when the delete
> runs?
>
--
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>
From | Date | Subject | |
---|---|---|---|
Next Message | Mario Asboth | 2018-08-28 14:00:42 | Please remove me from the list |
Previous Message | wambacher | 2018-08-28 13:59:55 | Re: tuple concurrently updated |