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 1s4Ito-002cUV-Lf for pgsql-bugs@arkaria.postgresql.org; Tue, 07 May 2024 11:22:20 +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 1s4Itl-002NZ8-In for pgsql-bugs@arkaria.postgresql.org; Tue, 07 May 2024 11:22:18 +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 1s4Itl-002NZ0-6d for pgsql-bugs@lists.postgresql.org; Tue, 07 May 2024 11:22:18 +0000 Received: from mail-ej1-x634.google.com ([2a00:1450:4864:20::634]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s4Itj-001reW-Hm for pgsql-bugs@lists.postgresql.org; Tue, 07 May 2024 11:22:16 +0000 Received: by mail-ej1-x634.google.com with SMTP id a640c23a62f3a-a59a5f81af4so773191666b.3 for ; Tue, 07 May 2024 04:22:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1715080934; x=1715685734; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to; bh=GD9RFm0/9FwhEYDdS6DtlMXhsaFvh+2e3TFgK8Ag8DA=; b=AZ2YCt1lVIYgIz48Abk1djuvgYGGpKMOgtRTfH10g2QDO7RKGBAr1X//pckZl311VX Rq5PWkNoyuwiZqlT8mlmT2L5WNEPOca27SnxWDAd90KpQkVR3mUXk4JABu2aRkln4wfr R3tgp8d7kxc2TKn/Nerb8t5W33HYX6F04lmkbfm+bSmu7t1yuoCjYcqg/1iMvs7PveUg 83Aryedli9hIwXNx+CyTI95+E0Dk8tK4ojOpaovi8v+vBV748sB1Ct3eHVw/hI4zTfpn uBn6zfMwdDo/b5mRkEKPdH3d1X7HxgBUDtVjgUNpzI0p/uhgUpa627YOOKGmuVHY1XBE HE7g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1715080934; x=1715685734; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=GD9RFm0/9FwhEYDdS6DtlMXhsaFvh+2e3TFgK8Ag8DA=; b=bj2tFHnecCLbP0/qVNMQ9jwCnoZ640xQ6xj/xjdTaiyWnoP08So8LShdHg/zAfwg85 eIzbVWCx859xwxJYdfZb09DOvoS9wOashR/rgDYNfl0dnQwowsEjJcZ/HbMFxLIsfkFO k4rCrSzbeceMe2Mi94DRO5K4Sx85yAfcGseAypJIv0K2uaYigtVQJyF1eeoJPnpWoFG2 dVwIA34Y/Wj1KXyNuiPdd4uFEWm1QiWCX1g9KJ/iDYxIZ5DYe1MKeXHstxWKnSiiQFQN j4P5z1VQnhqjexBWIo9SbtNZxtruVvfwQMdbAKaY0JBbcUfrh2aPzLQRIhTwPGLaF2OQ uexw== X-Forwarded-Encrypted: i=1; AJvYcCWdAEHFmryJYR/BmtgIIC93YwrgrgDhsMo+sHvqH6G5hSkzqjUz6DuxcHuSsRuXY//i1Nm88HvQZ03IPRlkFGKCDgiOKH3QMgYWfusqR3zD X-Gm-Message-State: AOJu0YxvIX2iU3khD/dF3m1QxWB5/L57BQryxn+EltkHz6NCDjCgDctL 43xyvmQAridvJw3YwEWcntKDQkhtt2FaqAeBPqL/KiCIVah1zJutNDuLPpcUbXU= X-Google-Smtp-Source: AGHT+IHECKHn3pkYyZOxnwKH0AUsm6JKD37jHrLC9pvs2BPOE4J03qoJTozuTrCktdQzjR8xKR2Z2A== X-Received: by 2002:a17:906:bcef:b0:a59:a3cb:8c8b with SMTP id op15-20020a170906bcef00b00a59a3cb8c8bmr5976556ejb.11.1715080934008; Tue, 07 May 2024 04:22:14 -0700 (PDT) Received: from localhost.localdomain ([88.116.133.170]) by smtp.gmail.com with ESMTPSA id wn3-20020a170907068300b00a59a5af8001sm4251780ejb.208.2024.05.07.04.22.13 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 07 May 2024 04:22:13 -0700 (PDT) Message-ID: <7aafc728c6928b1b3a6e6ddeae8ae59dd3f65261.camel@cybertec.at> Subject: Re: BUG #18457: Possible data loss needs to be evaluated From: Laurenz Albe To: julius.ernesti@kpi4me.de, pgsql-bugs@lists.postgresql.org Date: Tue, 07 May 2024 13:22:13 +0200 In-Reply-To: <18457-dc62fafe74c67bdd@postgresql.org> References: <18457-dc62fafe74c67bdd@postgresql.org> Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.50.4 (3.50.4-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2024-05-07 at 08:35 +0000, PG Bug reporting form wrote: > ERROR:=C2=A0 current transaction is aborted, commands ignored until end o= f transaction block >=20 > We are still trying to find out how this could have happened. This is not a bug, it is expected behavior. If a statement in a transaction causes an error, all subsequent statements in that transaction will receive that message until you end the transaction with ROLLBACK or COMMIT (which will also roll back). Yours, Laurenz Albe