Re: A thousand pg_commit_ts truncate attempts per second, two restarting autovacuum processes, and a explosive replication lag. Oh my.

From: Ian Axelrod <ian(dot)axelrod(at)sentilink(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: A thousand pg_commit_ts truncate attempts per second, two restarting autovacuum processes, and a explosive replication lag. Oh my.
Date: 2025-05-06 18:10:57
Message-ID: CA+B3G4TFzHmRt2odVjmGT7=3jeUzbcQLT8LcpZ6A5fAucSgPfg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thank you Laurenz,

I figured there was a high chance this is an Aurora-specific issue. I
do wonder if the replica lag itself is an Aurora-specific issue,
though the replica-reconnect feature is definitely Aurora-specific. I
will be in communication with AWS.

On Tue, May 6, 2025 at 6:28 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
>
> On Mon, 2025-05-05 at 23:52 -0500, Ian Axelrod wrote:
> > This issue occurred on an AWS RDS Aurora PostgreSQL installation.
>
> Aurora is different from PostgreSQL. In particular, the query cancellation
> error you are showing does not occur in the PostgreSQL code base. So unless
> somebody who knows Aurora internals happens to read your question, you won't
> get a good answer.
>
> You could check if your I/O quota are exceeded...
>
> Yours,
> Laurenz Albe

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Sami Imseih 2025-05-06 18:32:48 Re: queryId constant squashing does not support prepared statements
Previous Message Jacob Champion 2025-05-06 17:49:31 Re: [PoC] Federated Authn/z with OAUTHBEARER