Could not open file "pg_clog/049C": No such file or directory.

Modified on: Thu, 23 Jan, 2020 at 1:30 PM

Business Automation Operations Automation

Symptoms

Execution of some script, with postgresql query is terminated with error:

OperationalError: could not access status of transaction 1238193445 DETAIL: Could not open file "pg_clog/049C": No such file or directory.

postgresql transaction log file is missing in the folder:

/var/lib/pgsql/9.0/data/pg_clog/

It may be result of improper server shutdown or other technical reason.

Recreate the missing file manually:

su - postgres dd if=/dev/zero of=/var/lib/pgsql/data/pg_clog/0726 bs=256k count=1

Did you find it helpful? Yes No