Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen

Поиск
Список
Период
Сортировка
От Daulat
Тема Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen
Дата
Msg-id CALfOM6KRUw-6Qo-mSBvyBBtACZPPcQtUsPYjbANiZ_Rv-CR+Hw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen
Список pgsql-general
Дерево обсуждения
We are unable to take the backup of our database. While taking backup we are getting the same error. 

psql: error: connection to server at "localhost" (::1), port 5014 failed: FATAL:  pg_attribute catalog is missing 1 attribute(s) for relation OID 2662

Thanks.

On Fri, Mar 22, 2024 at 12:35 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Fri, 2024-03-22 at 10:56 +0530, Daulat wrote:
> We recently started seeing an error “ERROR:  uncommitted xmin 3100586
> from before xid cutoff 10339367 needs to be frozen” on our user tables.
> I’m unable to do ‘vacuum’, ‘vacuum freeze’ or ‘vacuum full’ on Postgres 14.4 running on a windows environment.
>
> Error:
>
> first come this---- ERROR:  uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen
> CONTEXT:  while scanning block 1403 offset 8 of relation "pg_catalog.pg_attribute"

Update to 14.latest; perhaps that data corruption was caused by a bug that
is already fixed.

Upgrading won't get rid of the error though (I think).
The seasy way is to dump the database and restore it to a new database.

Yours,
Laurenz Albe

В списке pgsql-general по дате отправления:

Предыдущее
От: arun chirappurath
Дата:
Сообщение: pg_locks-exclusivelock for select queries
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen