From: "Dischner, Anton" <Anton.Dischner@med.uni-muenchen.de>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>, Chris Cawley <cj_cawley@yahoo.com>
CC: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: AW: What do you do with a long running rollback
Thread-Topic: What do you do with a long running rollback
Thread-Index: AQHX4vQhX7qG6UzIYU6aLaplq0a04qwWE/8AgAQ4pVA=
Date: Mon, 29 Nov 2021 10:10:57 +0000
Message-ID: 
 <ed80d5c2840c432099df8a6f56b40d8a@MITMB5.helios.med.uni-muenchen.de>
References: <1977259621.1023368.1637951601701.ref@mail.yahoo.com>
 <1977259621.1023368.1637951601701@mail.yahoo.com>
 <440098.1637952136@sss.pgh.pa.us>
In-Reply-To: <440098.1637952136@sss.pgh.pa.us>
Accept-Language: de-DE, en-US
Content-Language: de-DE
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/ed80d5c2840c432099df8a6f56b40d8a%40MITMB5.helios.med.uni-muenchen.de>
Precedence: bulk

Hi Tom,

do you see heavy disk activity?

best,

A

-----Urspr=FCngliche Nachricht-----
Von: Tom Lane <tgl@sss.pgh.pa.us>=20
Gesendet: Freitag, 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> writes:
> It's been like that for several days already.

Really?  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?

			regards, tom lane