Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r7rN4-00790J-Jg for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Nov 2023 06:14:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r7rN2-002p1g-AW for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Nov 2023 06:14:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r7rN1-002p1Y-Sl for pgsql-hackers@lists.postgresql.org; Tue, 28 Nov 2023 06:14:56 +0000 Received: from mail-wm1-x336.google.com ([2a00:1450:4864:20::336]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r7rMz-007itV-1Y for pgsql-hackers@lists.postgresql.org; Tue, 28 Nov 2023 06:14:54 +0000 Received: by mail-wm1-x336.google.com with SMTP id 5b1f17b1804b1-40b4c2ef5cdso2511865e9.2 for ; Mon, 27 Nov 2023 22:14:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dataegret-com.20230601.gappssmtp.com; s=20230601; t=1701152090; x=1701756890; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=SdXqgTWMabnfKbuWGzMfm09xi4C6w/RUMinQWqouees=; b=1e9TLgzknWGm6dWU8cV1v/v3qkMvuLjfqnsBALCxOtx0a4cxxuYP2wx8jHIedat32m kWhLyjmH644iyAMbH4meKoNxxisqVa+6ogVkOId0Moq7gv2L7Rgadv8h7+EuesbY9JDv Aal8DohJFmAa9tzCwosf4GkY20Q5XyuahJj26N+OtZrARpTe6IVWMv5drjQ6xwnflYq/ /vR7+S1LDm3ptY0l/TkFDZjVtf/uv1ROaRxYIXa9zQQnH/L1uxyYnGX9t5fdngyyuwod ELlUOsjbedd4ucZV5Td3/nfWBPNFVa0jKfRJyudvlaZUrqz295THoMrBpZPzoGnOPgSJ 0AwA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1701152090; x=1701756890; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=SdXqgTWMabnfKbuWGzMfm09xi4C6w/RUMinQWqouees=; b=hG3VhaHlAUSksDeHhS/CkOER5fY+dvFIllwTmkE+y1wowO16FmmUWRUx2dRvhY97X7 wPzha2nI0teIE6brOGpwPiiqmeMyrlJpBy0DuX4BltOZJsFCwmN/fWEfdPTAemwM9D5o M4JumOyKQV5GUzKoH22ts8xYHQfgUTwB29OddCUmiS9QBTTuETj9SplFR05Bm0MYm2Jg vd5Igdrv//XwfQtikHm9zXqRHCrLfUFxZ2a/w5pIHtwDVt7gL3ycmM5vrucf+vaZx449 N4C6bOhGfrkTzjt6bIurlimfw05ZZL/75LRKRsqzPz/4oSRwsKQYCoveGo5cckWz2SFy lxJQ== X-Gm-Message-State: AOJu0YwWCLLmaIWrklFwgvYamloQ9gh1hpTUMFMxBZIH1ke5kQt73eH9 27fSLGp55u2gfFeQsygdbbhxKnweC9m5zROXIEna X-Google-Smtp-Source: AGHT+IGHKthp2PBePsQI3PR/2ogQHQgqC3WCpkgN7bgBXujTTHY5/fsMtZZ4l7PwcBGtpAlBMQbuFg== X-Received: by 2002:a05:6000:11c5:b0:32d:a2c4:18bf with SMTP id i5-20020a05600011c500b0032da2c418bfmr10017056wrx.59.1701152089315; Mon, 27 Nov 2023 22:14:49 -0800 (PST) Received: from smtpclient.apple ([145.224.72.237]) by smtp.gmail.com with ESMTPSA id c9-20020adfef49000000b00331698cb263sm14014990wrp.103.2023.11.27.22.14.48 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 27 Nov 2023 22:14:49 -0800 (PST) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Ilya Kosmodemiansky Mime-Version: 1.0 (1.0) Subject: Re: PostgreSql: Canceled on conflict out to old pivot Date: Tue, 28 Nov 2023 07:14:38 +0100 Message-Id: References: Cc: pgsql-hackers@lists.postgresql.org In-Reply-To: To: "Wirch, Eduard" X-Mailer: iPhone Mail (21B91) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, > On 28. Nov 2023, at 06:41, Wirch, Eduard wrote: >=20 > =EF=BB=BF >=20 > : >=20 > ERROR: could not serialize access due to read/write dependencies among tra= nsactions > Detail: Reason code: Canceled on identification as a pivot, with conflic= t out to old committed transaction 61866959. >=20 > There is a variation of the error: >=20 > PSQLException: ERROR: could not serialize access due to read/write depende= ncies among transactions > Detail: Reason code: Canceled on conflict out to old pivot 61940806. Could you show explain analyze output for those queries which fail with such= errors? >=20 >=20