Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hBN2P-0006Kd-GM for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Apr 2019 17:17:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hBN2O-0004iq-8w for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Apr 2019 17:17:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hBN2N-0004e9-SV for pgsql-bugs@lists.postgresql.org; Tue, 02 Apr 2019 17:17:28 +0000 Received: from mail-qt1-x844.google.com ([2607:f8b0:4864:20::844]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hBN2K-00085n-VY for pgsql-bugs@lists.postgresql.org; Tue, 02 Apr 2019 17:17:26 +0000 Received: by mail-qt1-x844.google.com with SMTP id w5so15864769qtb.11 for ; Tue, 02 Apr 2019 10:17:24 -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=OBWjmUkTx4YghYd/BmQyiGiazaLuVA7qMKEpIYU7ooI=; b=HuMMRDDtVGdUWaWD/4ePYIp7C0UScSvbpmMkvrDFvlt+cfbkJxpb3NAtnA7VAGepO/ 8CcSrVR06J++Mll5w89B6TEduqlNbnVRpiLjFPQyBUknG8zMhJSqPFCnwzieWl872Hw9 zwSilKnQrvCMg9MxwsYkcVA15nXLaapEjvlF+kFo3vHN9cTbuv6fGB9XJalY0XKEVqur 7v6z47qJZqG+9+1pjo2pw1L+O6/2dqwvomy7FKPzgchu1CUSCtEMfdO0L4UFmrVD6ALv rBPJI8xbkjrEy59ryeEvRvtxw5fBQ1OWJRiVgzMR73AlitgxksnQTsl0Geu436xyT2mo N9Rg== 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=OBWjmUkTx4YghYd/BmQyiGiazaLuVA7qMKEpIYU7ooI=; b=e87iSp2SSzQK83Zo4QnKR0UZMkLNKx2APZUzXfVzCCD7YUPYea4wT7ACj0RLDrK5rM 7bEsZHT2ydSf9uhYmD2NplCrw2IBSuPPgAfRitLrQORP/rLyIsgepbH7JTMoeTfTU0Pv R3e0ByYp6IVfT3oTVQzBQdkd7j+GQoWzy9aia3K8pzZmL7ECQxQnvo+X1AUbJCRRZIzy e25ZoiwdA8yioAcJZSyphw8+JWz+x5T4FFu+gaG5EkMXQYgF2DYe9AfZJlGsbV0XdlIo B6649Bde5Qs4pooBXqJySlib7Hc8uLQ1HJM4ZOhHvUyTbNjX38FYi0yU2aUAp/bMBwKG eifQ== X-Gm-Message-State: APjAAAX/tr37Kl8TOFQsPf5wWPAxj3/G4vKsCluOKhTOwNcmtM/KXfld AtAD5YpUyfj2XL1a+yLjfaxh7g== X-Google-Smtp-Source: APXvYqzG26H2lANBP0XZMubdufmgrVLjA58mE4J4dKqWJhQ4T35FkhUrgfMMO+lYnn0PvQPMOSsdFA== X-Received: by 2002:aed:3f49:: with SMTP id q9mr61282370qtf.279.1554225444194; Tue, 02 Apr 2019 10:17:24 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([190.121.29.3]) by smtp.gmail.com with ESMTPSA id 133sm2700310qkn.68.2019.04.02.10.17.23 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Tue, 02 Apr 2019 10:17:23 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id A5115120361; Tue, 2 Apr 2019 14:17:21 -0300 (-03) Date: Tue, 2 Apr 2019 14:17:21 -0300 From: Alvaro Herrera To: Tom Lane Cc: r.zharkov@postgrespro.ru, Andres Freund , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed Message-ID: <20190402171721.GA23559@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <1492.1554225238@sss.pgh.pa.us> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2019-Apr-02, Tom Lane wrote: > FWIW, I see six potential candidates, not two: > > pgsql/src/backend/commands/trigger.c: 3380: elog(ERROR, "unexpected table_lock_tuple status: %u", test); > pgsql/src/backend/executor/nodeLockRows.c: 232: elog(ERROR, "unexpected table_lock_tuple status: %u", > pgsql/src/backend/executor/nodeModifyTable.c: 881: elog(ERROR, "unexpected table_lock_tuple status: %u", > pgsql/src/backend/executor/nodeModifyTable.c: 1384: elog(ERROR, "unexpected table_lock_tuple status: %u", > pgsql/src/backend/executor/execReplication.c: 211: elog(ERROR, "unexpected table_lock_tuple status: %u", res); > pgsql/src/backend/executor/execReplication.c: 375: elog(ERROR, "unexpected table_lock_tuple status: %u", res); The other four handle the TM_Invisible case with a different error message. Anyway, the six of them are unexpected so changing them all to PANIC ought to be good enough. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services