From: wambacher@posteo.de
To: pgsql-admin@lists.postgresql.org
Subject: Re: tuple concurrently updated
Date: Tue, 28 Aug 2018 16:00:39 +0200
Message-ID: <f67fa1c1-5b91-0b11-8693-f3fd511c82e5@posteo.de> (raw)
In-Reply-To: <20180828135134.o4ymb6vvitpfcmxc@alvherre.pgsql>
References: <20180828135134.o4ymb6vvitpfcmxc@alvherre.pgsql>
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@posteo.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-boun...;
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;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: wambacher@posteo.de, pgsql-admin@lists.postgresql.org
Subject: Re: tuple concurrently updated
In-Reply-To: <f67fa1c1-5b91-0b11-8693-f3fd511c82e5@posteo.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox