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@xxxxxxxxx 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? |