Postgres Pro
Downloads
Home   >   mailing lists

Re: AW: What do you do with a long running rollback - Mailing list pgsql-admin

From Chris Cawley
Subject Re: AW: What do you do with a long running rollback
Date
Msg-id 560094305.1610677.1638192139164@mail.yahoo.com
Whole thread Raw
In response to AW: What do you do with a long running rollback  ("Dischner, Anton" <Anton.Dischner@med.uni-muenchen.de>)
List pgsql-admin
Tree view
Thanks for the support.  It looks like the transaction cleared off over the weekend.

Chris


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üngliche Nachricht-----
Von: Tom Lane <tgl@sss.pgh.pa.us>
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 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 record.

What are you looking at exactly?

            regards, tom lane


pgsql-admin by date:

Previous
From: Gaurav Anand
Date:
Subject: Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
Next
From: "Edward J. Sabol"
Date:
Subject: Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.