Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mrgc9-0000gI-5x for pgsql-admin@arkaria.postgresql.org; Mon, 29 Nov 2021 13:22:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mrgc6-0004YN-P4 for pgsql-admin@arkaria.postgresql.org; Mon, 29 Nov 2021 13:22:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mrgc6-0004Wq-4t for pgsql-admin@lists.postgresql.org; Mon, 29 Nov 2021 13:22:34 +0000 Received: from sonic315-13.consmr.mail.bf2.yahoo.com ([74.6.134.123]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mrgbz-0003sS-1B for pgsql-admin@lists.postgresql.org; Mon, 29 Nov 2021 13:22:33 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1638192144; bh=a0vYSCWjrHStIPnbS4+bEBXQGYL3TRpxilDbpDeFwYg=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=hEkPiUSXpjUIf/f0W1SCyvsUUls9WkOsB8ZK23ODyH2J0ewSWgBN0qxn8QMYTh7BaDhT4EBkKjwADwCIRHEUnWmCSnyXoaxWex6/Wo47byTXHiUoxXxiKSwacSWAWCjIANxvcDETiFZCUEMLLZnJy7ui4YXaPJZvFs7aBNdEGUuWFHzPS1qfcVSTkUowfHWgX5I+nwmu/EXZwJbrt2/cXsJ+Fvdcc3ahlEf3o2YkB+8SDrsjx7/V+NKe6yKz22i1p7846P1KI7m+c3Zm28WYWtoSGRUnZ7uk9TNpfu3OPEW9fFAC+vecwFk/3o0HbQIMmvt4ubskvg+OSypoouHvVA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1638192144; bh=fTWxoHd0ovPILO6YtT4JpvIVUABfQHg/j2zzVaszMfw=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=CkiPNF5lO7xvZrQqr/IorNThs+4T/mjmWJfpn57hOXNM3xECctz1JHtNZTdf1H9Ub3xaAEFF8Pda1D3i5jNbM9zqecocTAKv+//jVRG9azaaPY+5DC0YqYjKbYCUY4umbT8Iva3B6ULh0AEihuSS8HHo9lABf6Nv0ALwSgzEgqkCM7OJ5KdGH85N/io76RsPbUsLSIaG2O3XuVldk+DtZ0yJIud5YZu3ygkmqFFhsez91Kisg7wr1oUc/hUv6sf95aogRaiWW13scmcoY2y7aRGL9ytWycb72U+YrckJAurmvghuByVcp1g9T7KCwGf1tLFjauYpHLpEAvXEvDs9SQ== X-YMail-OSG: c8QAkdgVM1m_m9cCMc5sjgftYtmH2vRKYaoe93XbFTWzdgPtr4x09XHxKnRwFlw El3omKqbCvIYHD_tYLY5Q2OuBE0MB8jpPel0mIFC89FfDsRbl9KH0dgSxTvaQuMfeisvTPEqyonB wn19N0yawNgFvvfhXUqDZjfn8tDLdxvdEvmdlHS7j7WnQ7CLUtV1jhkeMEcWRMRPGwwBwpmQGLZc 18WUXg.PsQC223gj5ftmRM9A9.vCCBwy6V4kKi2fQ006XrKAz5J1QUUNH9kVBDgS.ThDVQjejLGN 7rvUqp1KEHbUJr53lxRHaotwgGZ9KtoFFPTCH2YtIkj4VbiZoH09SR7tYwI6YH7xwXgVLp7ohexv wjZ2ajvqTu10_pl8px1ieBDt30L2XBZOWeHZmrQ00RR3RDsX19T_N8dqF_5VEQAeAVzkLTzJHOa5 GxLLUH5OH8zeDhytYK7EFeepAy3ehiRuhFB.WGf.gRVNHrUDR3QvRtQrk4Rz3WF1MkT7lSxuqxLJ 97aWPbAGdr3DiqTV86YPU7OLhx.uY37issOLrFyOsUK9BPuM9.8DLHm1hvq7uviM2lruIf6S_yu5 fndk2N5WMfvB.i2aDnmgh7a_fnAy2DJuTQG.UR8LjJUn1C3frMdyOEA7G.aCaTMfZMwyum_q4ybn CMQxSGhkjs3DXISCiWDHPTjGiUkbrU8_nH7u6r_R9exIXXYtrQFfsJ8bU0Hepf_06xxfvPB87AwR ZX6SruDWPhdS6h6kXmJ0X_CafTv9F5DenShM_33__RzojvrVONh1.02XZ6djFtEhPIgKan3q9V86 S_HiA.6euyg8L7eLOlHXgtr8AWR6ab6hfZhXr0sA5xgfoZk4MmKtEHV831cQ0L3YA0mcTj89SMvG ok3Uw2mjRUZExo9DaDn3S7Jp.00bgoVMFGCL.VIHV2Sd0OHrFcXnPHkphTVk9BpZPpQknOPkKH54 ulswkdvJuX55ZgvVtl5TIkgdy51Io89TmXyXHlm.H_dQXni64KT9GvTgdN_P2BmnEvYfkMECL_kE dJMnYZ82jcBwExBewQCiFVsHnmZZwbi3K8W2_8BKNEdewpGhCQnC7JNjqk5povrP_JRUokhxlECu 9zMiDQ6E5ntVP20Z9wvtc4Q_dbl.NxoFIuBxggVmgrSmt3CeNhz8SErz10w6d7VzhWFqCkkoI3PC UxCxC67oPf9BbG8JKHX84rLFo7mXf9134aemCJkw.TKEXt7ENfiEFaoCJA0rKc7iTShYiV5VrLBA jxAG8_bv1_75ABLsQV0CXotMckpqcT.QT86M0kFRJxyEL00vXr_mVlIGS21DFPFerQZ7Hh86tIti tCx9cnC61A.FgdVqD9wHGydOhZkXWGGVeI5hh0QaynU3sUQYZkIWpI0kK65Mjcx_ZUnQCbd8NX2W 31pdeZDSgQJYVgV8ayqnm.9_OsuSJleJupTaJShwnvuz_Alw5xqncGuTfcCjmMXei3lN8PKdy.xa DhokpTgxwSGDsG45ydMlOTymkwjklt2R_EZ3hYt2whExh_BbbdyMlwmsQYEuOEgCep_MeBsgpSNM qaqW2bJFR0rqaj4GqMrl2Cxtr4HeMNu3T2au0ts5YVhi_FDBK8lsSoZSrn8PaH.h05ceN54ZoyRi LkBSbe21M1JnZHnOocseFFw5ExzW3fYCAo.HpSZ_86k7oA_j2fWRmALVlC0TykDGQKSdpHMgiwft AH9yWw5j_WqtnusHtdFfnXG8v1Lku2LkhbIGsuES5CWmPpldBeRg0vnRwpo6wPYwUbygbP9pxBqL mayvB7yVyUB2RfpB8rg7Sl7YZJfCROrTGZJyiqpFcVJiCr.AvsVjC_GEhs67L7OpTybjPv6Z_9OI l2IjVe2xaQSL4UjX7WGJeEiOV51iTrkOb3A_I7a_eUec_ANYDA_ZDi9d5OxAQqz2QJee9hnXf7bt 1PwZkxkR9r.kbi.xkJHU5AbQiiATWlfL6cusl_.gAQOFKO2EQYR6cIi6O4A41DkcjFfkvfeIhLlQ jIbveuVqVHBkQmaBxNUXW31XX2lFXVyAa0UBQem6foZADUwYuHNM48u_xalyHK5U4LOBiiApzGpU Eer4Wk4sqcLKyDAFFHkxNQc7Gk0nQyiUaeuy.9MoKoAcXpfjYrEVL2ASRB4kVvzYIiz7qqMoZRUP A.heJuiqXRX0tHcnrTgPyuG9PVWRoNMWWEAoewuFPc8hSkUYjHTKfLiEBymwjO1nQPRT8KT7pYHR 401ChPauukD_umSKIUsNkYEltd0XLdxkvDdqJugu0ror0gCRPuA-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic315.consmr.mail.bf2.yahoo.com with HTTP; Mon, 29 Nov 2021 13:22:24 +0000 Date: Mon, 29 Nov 2021 13:22:19 +0000 (UTC) From: Chris Cawley To: 'Tom Lane' , "Dischner, Anton" Cc: "pgsql-admin@lists.postgresql.org" Message-ID: <560094305.1610677.1638192139164@mail.yahoo.com> In-Reply-To: References: <1977259621.1023368.1637951601701.ref@mail.yahoo.com> <1977259621.1023368.1637951601701@mail.yahoo.com> <440098.1637952136@sss.pgh.pa.us> Subject: Re: AW: What do you do with a long running rollback MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1610676_43858166.1638192139163" X-Mailer: WebService/1.1.19306 YMailNorrin Content-Length: 4375 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1610676_43858166.1638192139163 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thanks for the support.=C2=A0 It looks like the transaction cleared off ov= er the weekend. Chris On Monday, November 29, 2021, 05:13:28 AM EST, Dischner, Anton wrote: =20 =20 Hi Tom, do you see heavy disk activity? best, A -----Urspr=C3=BCngliche Nachricht----- Von: Tom Lane =20 Gesendet: Freitag, 26. November 2021 19:42 An: Chris Cawley Cc: pgsql-admin@lists.postgresql.org Betreff: Re: What do you do with a long running rollback Chris Cawley writes: > It's been like that for several days already. Really?=C2=A0 Rollback is O(1) in Postgres. I could possibly believe that it's blocked on a lock, but even that would b= e a bug, because transaction abort should never try to take any new locks. A perhaps-more-plausible theory is that you've enabled synchronous commit b= ut your replica is failing to ack the transmission of the abort's WAL recor= d. What are you looking at exactly? =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 regards, tom lane =20 ------=_Part_1610676_43858166.1638192139163 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thanks for the support. = ; It looks like the transaction cleared off over the weekend.

Chris


<= /div> =20
=20
On Monday, November 29, 2021, 05:13:28 AM EST, Dischner= , Anton <anton.dischner@med.uni-muenchen.de> wrote:


Hi Tom,

do you see heavy disk activity?

best,

A

-----Urspr=C3=BCngliche Nachricht-----
Von: Tom Lane= <tgl@sss.pgh.pa.us>
Gesendet: Fre= itag, 26. November 2021 19:42
An: Chris Cawley <cj_cawley@yahoo.com>
Cc: pgsql-admin@lists.postgresql.org
Betreff:= Re: What do you do with a long running rollback

Chris Cawley <cj_cawley@yahoo.com> write= s:
> It's been like that for several days already.

Really?  Rollback is O(1) in Postgre= s.

I could possibly believe that it's = blocked on a lock, but even that would be a bug, because transaction abort = should never try to take any new locks.

A perhaps-more-plausible theory is that you've enabled synchronous commit= but your replica is failing to ack the transmission of the abort's WAL rec= ord.

What are you looking at exactly?<= br clear=3D"none">
        =     regards, tom lane

<= br clear=3D"none">
------=_Part_1610676_43858166.1638192139163--