Re: BUG #18099: ERROR: could not access status of transaction 4007513275

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: BUG #18099: ERROR: could not access status of transaction 4007513275
Дата
Msg-id 82730b0204b4daaa924d031479af86c11bd7801f.camel@cybertec.at
обсуждение исходный текст
Ответ на BUG #18099: ERROR: could not access status of transaction 4007513275  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
On Fri, 2023-09-08 at 06:36 +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference:      18099
> Logged by:          Dogukan Yuzen
> Email address:      dyuzenn98@gmail.com
> PostgreSQL version: 14.8
> Operating system:   Red Hat Enterprise Linux Server release 7.9 (Maipo
> Description:       
>
> A few days ago , we had  some problems in our production database.
> We can't read the table.
>
> We can't solve this problem.
> ERROR:  could not access status of transaction 4007513275
> DETAIL:  Could not open file "pg_xact/0EED": No such file or directory.

That's data corruption.  Restore your backup.

What is your proof that this was caused by a PostgreSQL software bug?
More frequent causes are hardware problems or pilot error (pg_resetwal
or other manipulations that break your database).

Yours,
Laurenz Albe



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #18097: Immutable expression not allowed in generated at
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: About #13489, array dimensions and CREATE TABLE ... LIKE