BUG #17528: ERROR: could not access status of transaction 1997627701

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #17528: ERROR: could not access status of transaction 1997627701
Дата
Msg-id 17528-1df379cdbc43ea7b@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #17528: ERROR: could not access status of transaction 1997627701  (Andrey Borodin <x4mmm@yandex-team.ru>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      17528
Logged by:          Evgeniy Yanchuk
Email address:      ev.yanchuk.s@gmail.com
PostgreSQL version: 10.19
Operating system:   CentOS Linux release 7.7.1908 (Core)
Description:

Hello.
I've found on our server (PostgreSQL 10.19 on x86_64-pc-linux-gnu, compiled
by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit)

2022-06-21 09:08:08.291 MSK [34331:44/99061] [u178-01] [local]
10.201.14.125:10081 : Check.Finish ERROR:  could not access status of
transaction 1997627701
2022-06-21 09:08:08.291 MSK [34331:44/99061] [u178-01] [local]
10.201.14.125:10081 : Check.Finish DETAIL:  Could not open file
"pg_xact/0771": No such file or directory.
2022-06-21 09:08:08.291 MSK [34331:44/99061] [u178-01] [local]
10.201.14.125:10081 : Check.Finish STATEMENT:

I created the file "pg_xact/0771" using the command "dd if=/dev/zero
of=/var/lib/pgsql/10/data/pg_xact/0771 bs=256k count=1", but the error
reappeared after a while.

Restarting postgresql.service didn't help either.

Thanks, Evgeniy

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

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: Extension pg_trgm, permissions and pg_dump order
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #17526: PG_DUMP is not outputting "CREATE SCHEMA" statements when an extension is assigned to a schema