Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fueY6-00025z-1v for pgsql-admin@arkaria.postgresql.org; Tue, 28 Aug 2018 14:00:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fueY4-00019N-Gn for pgsql-admin@arkaria.postgresql.org; Tue, 28 Aug 2018 14:00:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fueY4-00019G-9Q for pgsql-admin@lists.postgresql.org; Tue, 28 Aug 2018 14:00:48 +0000 Received: from mout01.posteo.de ([185.67.36.65]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fueXz-0003iC-S6 for pgsql-admin@lists.postgresql.org; Tue, 28 Aug 2018 14:00:47 +0000 Received: from submission (posteo.de [89.146.220.130]) by mout01.posteo.de (Postfix) with ESMTPS id 8B96E20EDC for ; Tue, 28 Aug 2018 16:00:40 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=posteo.de; s=2017; t=1535464840; bh=t5g8gxn6MHX9JefBNMZFCdpnC2BEG4ZgDuFv2LWPLJw=; h=Subject:To:From:Openpgp:Autocrypt:Date:From; b=S9kCU1Iv+AM+kwtZKW6XWOhdDWQhundALFLfsyzGHTmA8Y4s/4XtG593pTLNxR2pF OXbTchkdfbMZlT5HEYrPB1xX5Bb4iW9Dwb43oSNH58S0QsDKCE2NxBnpojYCut0ETt qfABvAoAosBJuZlfvZiOMdJ0zh46RI/j4HiVfDZH5ZqGEreiKyKZLer/mR6svPE8Mx W2kah55UuRa68iyZZAq2PfnFG2BHO2+21T1zl4dNPaTlk9Fo8DKYkp9bkb3XCq2WFY a2hZ5olJMl7vEJUEcuoyhBZ+0Tt8avlSpKtktdoVcQYaSlfj/HDVR+XvzTZLGt6X+c mvxFZ9DCBrmKQ== Received: from customer (localhost [127.0.0.1]) by submission (posteo.de) with ESMTPSA id 4209Q00nWDz6tmK for ; Tue, 28 Aug 2018 16:00:40 +0200 (CEST) Subject: Re: tuple concurrently updated References: <20180828135134.o4ymb6vvitpfcmxc@alvherre.pgsql> To: pgsql-admin@lists.postgresql.org From: wambacher@posteo.de Openpgp: preference=signencrypt Autocrypt: addr=wambacher@posteo.de; keydata= xsFNBFsF9hIBEAC4W3M068RHHa+QJ3GjfG8n+sSUenUmRP0YCBL0X9FZfMRk328cXXs2qFP4 yqoegbbRmxC4jUHCrMaPdnRGugW8ZRnyoiKYZrmffx/SzB6kZzdS7RCIhYY3pHLUEd5TIFPG Z2Plr6s1TpwVZc4Gkk9Uj4vGcwzDlUB7feurBpMdKaOfYz53vNXnh0C/e/fg7jx8rw70zM7z UDKcttHshsUUscL4tnYqH4mt2svJ8jmCwpesehjxgywTjxF8vPqr3G2KQ8cW2HbISp1q8gZQ vbXycBZ8Ej5GKsKkYLUP4bN6wfPE1sWlmD3Y5xilYNsDJkREFTQOqpJCoeMROcLZSdpv058Y nKRVVPKaD969nRl8lnMgPEkDOSv5V+IhSebQEFX7vnSkZp/4kETy4NsAa89I6ATBt4H5McQL 3Py46INBbn7cH3k4Vljf8R1qvWYltM9aLZp3HbmKyRl0c5DSRSzKm7jCspmaYQ6pxZfLAx9M HRp2m3tIZPF+o8r8LukVS4Ji/8pXu2Tubd1rpkWwa8P6DxE0ZZGXYEnn7iYQuBn1sOYU2PBG xo/EA2lYx/EfeMDvjFV0ZB8DafROff4pb1mvuTA8m8gyUwa2leCNFg17PqYI/k4zCsGO21Vg qKc2K2rzm9azfX6nPvfcQHZtK55ek9m/0cP0pCsi/3v75vypewARAQABzStXYWx0ZXIgTm9y ZG1hbm4gPHdhbHRlci5ub3JkbWFubkBwb3N0ZW8uZGU+wsF9BBMBCAAnBQJbBfYSAhsjBQkJ ZgGABQsJCAcCBhUICQoLAgQWAgMBAh4BAheAAAoJENd8FQK2Z0Eya2oQAKp/5yxEPPyflX2o dLoPMdPPvZoTDG/PMGbLYqJ8jRPnIcopFCCu07LZDwS9rDjQEnMaDagdvxSHgVprdiJ8BUum 9UK5WDNj++a1tY20DwjVDNOBpZisF3W4GZ+89JIU9710HxcGr0JC2UV99I4IbPbanm5PLAgT csyeDWT5e8EXEPS/BF5adQQH86SsTwKEjQtxtzoI9bNWfEbWvS5ZE0ATGQYtjAilQl/QuFN8 LjdDkAUVTbQbR02I1r9jjpYWv0qCa043FifP0CSosKqOyPbTibvV+FYlMj2c9dj955MJ/BJB QvgEXmNRTN4vsZJEm9u+onJ0NAR2sNPvezIwuOX4mQcUsiDYQAit+MicjS9dJLeMnvcWFuBy boPdNopV2PjtkCzaLOD0jQ01drIBKLIkTGElPSl+EwhwX5PH+XzXY/f8KHIyGsJ9Fi9JZJDS qbFuYNLmIwWqdtvMECF5Cwp1g6UZeFX70ALo82sc/EYfnpfDnLUfTeayWkNDp9xsZMOuLk5M O+s+8tH1tJcIc3YEtVg8M+QZYnweTDoOZOgxsJuePvtMnQl1T5gXHA1W5YT6lrpiLaN2BZfO vjLyb9I+6hMYNtsqnGVP7gADLWIxqG5D8PZ1WYqsDTCzwKHZuasUnc+agOYbUKMo6DSo8g/I zMbF/dkpxD/6UPwRfMltzsFNBFsF9hIBEAD038KpaE8OkPi9/dMaEewlz95rbDvSaUSxCm3w vNnrDRTqiophHoxXYjrrpeS9YPlkjscVYWRSw2Qqf2QYcFexv+8bGjZO1tYTDgLkdfPXrnO+ 2i9xy4dGLHEZRIcyZsS7J46fg9e1Ir6U8nFdAjXW7d/QBWh09QujZ0WXnajuQBeWfDNfKD6V 4+xV+xLndgvQ5elddSqjz6pV4/TcEtjgNg7dB/2cA93sUbikPyHG6jUSncYsa9I4zU94+CNh jUl0WUdcZl9+hRkzzkbxqWD9lxtsWjweN2bcKKpZ3tEVs3mALJauQc2FZMlKCF9fNuJwN9wx Ub1+uI/jBpi1OuuCNfHm/ChpLiiDVRPp/e/t8rNHcagN3hjrP/vBtzqFD6DFWxwZnIQEtoc/ P4K/RythMp07Xdfz2qjSXS2VGVmxgzGStjg6BlGXM3QDqgQt0heZqMWEj5+F7NVipN8ZFxmg rNoViVzqf24k5qwK3EQAUdXKj6UxIocAgJsZ6iE+QDKfd1OvXpRehpnq6/PSji5OZJ0S/QHB +NOs2BU7glMBcePgfagqxAWeD4ZZtt2iONyrt15ukAO/kmNZDdMBmz/6Fq75tqXRROl4CYuA y3ImcQ4r1rFuZTNmydVUM3uV8hOS2j5o3HjsHa91wyeCw4Ms2VkZlxfi4izFP/Yx9gWmFQAR AQABwsFlBBgBCAAPBQJbBfYSAhsMBQkJZgGAAAoJENd8FQK2Z0Ey3egP/jsLqXgKDTGOetw6 zOx+Y2o1XaL1/ov2yx5oSK9d5OagcSpby31eZbd17BkTz2ZV2S7RUoBN7F0JWfs41YkHkvF9 2+ANexNMXnTNrFBemxP2GB7C2MGFVwOhbYj8OhygLIukEtYbSktNBe+CPD76UynvPh2O8aGn f7IibXMntgOc/qm3olXNknZfcXc1hEfCDK2Kce404f7J6verPUm5/LyTVEPGbH4VQBiuwwxq vbvSJdv1pfzHihcjVVjNN/KVU0Um6+GqUj5JrI3JpW7waRERctwmOVc/hYGzGpbN8iUE0Oik Adanx2OanoyxcMBjg5LVgltnRVqVB6AEXRLYUDl7dvRl+68BmvQB08cnmg/UY5tFfxmSTlN/ /gqhThYXF4/3WH8rOtWZ2Gq75YdrMTJO3npJLoDhVCZZkxekcTIveQsv37b2nLZrvqrjWRl4 NAJD2K4kFICPEuErjLEsPIL4YBH2WNFlYpLgAjCBoShRV0IBd3dwF6BJnesR12Xh5H47qS9m +6h28JtTek9FvHCgmNiYcum8yBwBRwfSqLC4LJ9QU4JWb+rx6JLHkVu3sz274bv80B79gibD cjwz8joa6ISPfAaO2sJNhrKl23F8qor37FcXqauPnJwzS5cKNXcEpkBL9+OyPHBU0rMN4k+7 Xs1SWQ51ouO7nAA/IFGj Message-ID: Date: Tue, 28 Aug 2018 16:00:39 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <20180828135134.o4ymb6vvitpfcmxc@alvherre.pgsql> Content-Type: multipart/alternative; boundary="------------CC2927EF292CD7E74FBB323D" Content-Language: de-DE List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------CC2927EF292CD7E74FBB323D Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit 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 Missing Boundaries Emergency Map Postal Code Map (Germany only) Fools (QA for zipcodes in Germany) Postcode Boundaries of Germany --------------CC2927EF292CD7E74FBB323D Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
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?


--------------CC2927EF292CD7E74FBB323D--