RE: BUG #16961: Could not access status of transaction

From: Stepan Yankevych <stepya@ukr.net>
Sent: Wednesday, April 14, 2021 7:12 PM
To: sergii.zhuravlev@smartnet.ua; pgsql-bugs@lists.postgresql.org
Cc: sergii.zhuravlev@smartnet.ua
Subject: Re: BUG #16961: Could not access status of transaction

The issue happening each morning when application starts on the production DataBase during about a month. 

Always the same transaction id is mentioned in the error (1954017648)

We tried to do UNLISTEN - no changes. the same issue.

LISTEN works good for any other channels.

Can it be related to some hanged transaction? 1954017648? (for example while some network interruption)

Is it possible to kill/clean it somehow without DB restart?

Can it be related to some non-vacuumed system table or so?

Any other ideas?

Thanks!

The following bug has been logged on the website:

Bug reference:      16961

Logged by:          Sergey Zhuravlev

Email address:      sergii.zhuravlev@smartnet.ua

PostgreSQL version: 13.2

Operating system:   CentOS Linux release 7.9.2009 (Core)

Description:        

Hello

Command  - LISTEN missed_trades_empty_instrument  

"

ERROR:  could not access status of transaction 1954017648

DETAIL:  Could not open file "pg_xact/0747": No such file or directory.

STATEMENT:  LISTEN missed_trades_empty_instrument

"

Current transaction

# select txid_current();

 txid_current

--------------

   6985716158

Parameter -  autovacuum_freeze_max_age = 200000000