MIME-Version: 1.0
References: <1ac45482-cf26-4d6c-b551-ce9c9a5cbeec@quadratum-braccas.com>
In-Reply-To: <1ac45482-cf26-4d6c-b551-ce9c9a5cbeec@quadratum-braccas.com>
From: Fabrice Chapuis <fabrice636861@gmail.com>
Date: Thu, 13 Nov 2025 12:06:54 +0100
Message-ID: 
 <CAA5-nLDTdwJ-mSqU3qYX8gG7tdZTcuHhXtsKBmBT2oSYfAhfLQ@mail.gmail.com>
Subject: Re: vacuumdb produces ERROR: cannot freeze committed xmax
To: Sbob <sbob@quadratum-braccas.com>
Cc: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000ae116f064377e139"
Archived-At: 
 <https://www.postgresql.org/message-id/CAA5-nLDTdwJ-mSqU3qYX8gG7tdZTcuHhXtsKBmBT2oSYfAhfLQ%40mail.gmail.com>
Precedence: bulk

--000000000000ae116f064377e139
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,
This thread could perhaps help
PostgreSQL: ERROR: cannot freeze committed xmax
<https://www.postgresql.org/message-id/flat/8C414E45-6DD8-48E0-84B2-2D53545=
000D0%40gmail.com>

Regards,

Fabrice

On Wed, Nov 12, 2025 at 8:10=E2=80=AFPM Sbob <sbob@quadratum-braccas.com> w=
rote:

>
> All;
>
> running a vacuumdb is throwing this error on a PostgreSQL v15 db:
>
>
> vacuumdb: error: processing of database "prod1" failed: ERROR: cannot
> freeze committed xmax 1406773176
>
>
> Thanks in advance for any guidance
>
>
>
>

--000000000000ae116f064377e139
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi,</div><div dir=3D"ltr">This thread could perhaps h=
elp<div><a href=3D"https://www.postgresql.org/message-id/flat/8C414E45-6DD8=
-48E0-84B2-2D53545000D0%40gmail.com">PostgreSQL: ERROR: cannot freeze commi=
tted xmax</a></div><div><br></div><div>Regards,</div><div><br></div><div>Fa=
brice</div></div></div><br><div class=3D"gmail_quote gmail_quote_container"=
><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Nov 12, 2025 at 8:10=E2=80=
=AFPM Sbob &lt;<a href=3D"mailto:sbob@quadratum-braccas.com">sbob@quadratum=
-braccas.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddin=
g-left:1ex"><br>
All;<br>
<br>
running a vacuumdb is throwing this error on a PostgreSQL v15 db:<br>
<br>
<br>
vacuumdb: error: processing of database &quot;prod1&quot; failed: ERROR: ca=
nnot <br>
freeze committed xmax 1406773176<br>
<br>
<br>
Thanks in advance for any guidance<br>
<br>
<br>
<br>
</blockquote></div>

--000000000000ae116f064377e139--