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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1fuePK-0001aR-Qw
	for pgsql-admin@arkaria.postgresql.org; Tue, 28 Aug 2018 13:51:47 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1fuePI-0002Im-7C
	for pgsql-admin@arkaria.postgresql.org; Tue, 28 Aug 2018 13:51:44 +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 <alvherre@2ndquadrant.com>)
	id 1fuePH-0002If-Ra
	for pgsql-admin@lists.postgresql.org; Tue, 28 Aug 2018 13:51:44 +0000
Received: from mail-qk0-x243.google.com ([2607:f8b0:400d:c09::243])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1fuePE-0003SA-6p
	for pgsql-admin@lists.postgresql.org; Tue, 28 Aug 2018 13:51:43 +0000
Received: by mail-qk0-x243.google.com with SMTP id c126-v6so1004349qkd.7
        for <pgsql-admin@lists.postgresql.org>;
 Tue, 28 Aug 2018 06:51:38 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623;
        h=date:from:to:cc:subject:message-id:mime-version:content-disposition
         :content-transfer-encoding:in-reply-to:user-agent;
        bh=YrrHd4fKOTUki7UrK5157SI9If+ZiS5Esj1eZ1eWv+s=;
        b=gZKlk+uH1gDj4LCMZYpAnecR9fBnJ9A8HcnfQs3RZhvvcAIZ1vlS6H79WLssY/T1EC
         4ZOhKSJFCvxgk+WEFI3aLLlVbH3EZzW3nbR5PqCuKuVaYL2OOcc6BDmgOo1O6Nr6xRFP
         5Syt4T0qZkND9Su4tSfoHdfInhsPIWqY3hOpRFk6DwIlZHn9ZE9X0QMR2sg5IeEHsSsM
         BTbSQ3JV4AQhMQSo/u/1u0Ar5YzmEhz5hxJP9MJCMeLFDYR/0m4G4qL6Pa35AH0+RbTd
         f11DByMYPVpHQEpXEtfn7/PbWcNiGUkaPNmz1aWWlcFZIaeYRG0C5/Boc9iXEati0rfu
         qH6A==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version
         :content-disposition:content-transfer-encoding:in-reply-to
         :user-agent;
        bh=YrrHd4fKOTUki7UrK5157SI9If+ZiS5Esj1eZ1eWv+s=;
        b=Pn/x2o/6MZo/OiqYRlNGSJDeJNXtLVEMQpjDfvzXxg+mhfj6U6KmLQN0sprrrauKXR
         4ee2ZANzRpCGK8sDolJ0rTJLPWBdpy9uULXTqwBMv3iJZnBmhlyrCnnHS35pMvXhzWfG
         jckEjMLajrCOlVnSxnFuixKTU77vKtSAmf5ybzGI6e+KYY1ibKJmn9MPCDjWe7f1Azyg
         R+W+5LpNOBjqV8T27OefC3Z8/Vfm+hQY/J0ddct5mJzw/wuCZN+2MLAc4xD7KargO4CJ
         iCfuKS/lsbM7rHzMOrMNyxAOgM2hr5Z7bUyIKSQD2A0pbcH+KAxZBbtLMPwX8uirGwwA
         s43Q==
X-Gm-Message-State: APzg51CVjYAAcDztR9IBqCLayiMOTIiQSDKh6BwxL2Xzp99fijHyWb2z
	+obFJg8n3a7soxjFFFn0ql12y0HKH28cG4HlvBvXF/R8owG9bo7lITA6/AIYiq9KSf/gELWIjbg
	KCmqo5ltDDpsPKGHBqb9W/5s7Owwwmga7znRJB8ESaH2l5YUhHcTYHG0aRtY7uateDwzwIQ8q8C
	8atgc0cyCYGBA=
X-Google-Smtp-Source: 
 ANB0VdZTx3H76YqD4g7uc3W1gNfjBLlOGVe1c4h3xko0N0jw8jItupcBVPqieHrsloRLvQghp+Yhlg==
X-Received: by 2002:a37:1568:: with SMTP id
 f101-v6mr1579155qkh.14.1535464297209;
        Tue, 28 Aug 2018 06:51:37 -0700 (PDT)
Received: from alvin.alvh.no-ip.org ([190.121.29.3])
        by smtp.gmail.com with ESMTPSA id
 j88-v6sm600542qte.49.2018.08.28.06.51.36
        (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256);
        Tue, 28 Aug 2018 06:51:36 -0700 (PDT)
Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000)
	id DC890819; Tue, 28 Aug 2018 10:51:34 -0300 (-03)
Date: Tue, 28 Aug 2018 10:51:34 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: wambacher@posteo.de
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: tuple concurrently updated
Message-ID: <20180828135134.o4ymb6vvitpfcmxc@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <986488f7-ff29-5dff-9425-5fcd6dcbb68a@posteo.de>
User-Agent: NeoMutt/20170306-137-4415bd-dirty (1.8.0)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

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?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services