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 1fug4f-0006ju-0E for pgsql-admin@arkaria.postgresql.org; Tue, 28 Aug 2018 15:38:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fug4c-0002Op-SC for pgsql-admin@arkaria.postgresql.org; Tue, 28 Aug 2018 15:38:30 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fueVi-0007Jb-O2 for pgsql-admin@lists.postgresql.org; Tue, 28 Aug 2018 13:58:22 +0000 Received: from mout01.posteo.de ([185.67.36.65]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fueVe-00076r-Da for pgsql-admin@lists.postgresql.org; Tue, 28 Aug 2018 13:58:21 +0000 Received: from submission (posteo.de [89.146.220.130]) by mout01.posteo.de (Postfix) with ESMTPS id 43F6F20E36 for ; Tue, 28 Aug 2018 15:58:14 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=posteo.de; s=2017; t=1535464694; bh=S5ONkpfOa3L+kPJYDURdybSB8Gpr9MoidZSNFeLniQY=; h=Subject:To:From:Openpgp:Autocrypt:Date:From; b=Jl8494rhjSs8YAXA32WvCy/Tp0iFVdyaggeEVGOEgYsYXSWBL+5u0K5CVdjx3wB0A LwISWErDNsrJPXzO7CRhMyZrIQoFWjz00NQMb8L52nf7NgnYKnnH8NC2ig3vSdAofK iLhavzbx0uDhNJzM28+/Clj6GrS0UlLxXl06awy6rqVsV4CvQV8mgbSTQ9GSt35LyX co15M89PlybV0Sa+YZtK/pzTJ+sVnFQRBW+TgOWM/6WIAx13eDlKWQTNRe9/zVeQiY upfXEH+EsY6Jk0lEQQPl2R66zke9YFX/dChAyBRV+K66wnRhGtdb3BU7L0XEwd2Rde F7mKyboTeOy5Q== Received: from customer (localhost [127.0.0.1]) by submission (posteo.de) with ESMTPSA id 4209M95bLkz6tm9 for ; Tue, 28 Aug 2018 15:58:13 +0200 (CEST) Subject: Re: tuple concurrently updated To: pgsql-admin@lists.postgresql.org References: <986488f7-ff29-5dff-9425-5fcd6dcbb68a@posteo.de> <1378566276.366027624.1535454005687.JavaMail.root@zimbra82-e14.priv.proxad.net> <99342cd8-c2f6-31bd-f8e4-5c65658b1a2f@posteo.de> <1233975696.366149748.1535454938944.JavaMail.root@zimbra82-e14.priv.proxad.net> <114865725.367018989.1535461805284.JavaMail.root@zimbra82-e14.priv.proxad.net> <2be8ebca-fecc-51f4-39d7-9869941c679a@posteo.de> <1535463942466-0.post@n3.nabble.com> From: Walter Nordmann Openpgp: preference=signencrypt Autocrypt: addr=walter.nordmann@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: <9df8bb7f-50c4-ba3d-1086-d3871ad3f363@posteo.de> Date: Tue, 28 Aug 2018 15:58:13 +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: <1535463942466-0.post@n3.nabble.com> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Content-Language: de-DE List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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:45 schrieb pavan95: > Hi Walter, > > Why can't you go with a postgres service restart in order to get rid of this > error? > >> DELETE FROM planet_osm_line WHERE osm_id = -166570; >> FEHLER: tuple concurrently updated > Concurrent transactions can update or delete one or more of those rows > before DELETE can lock the rows (at least with the default isolation level > READ COMMITTED). This would result in your error message. > > To defend against this race condition, lock the rows in the SELECT with FOR > UPDATE (or other options) > > Regards, > Pavan > > > > -- > Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html >