Article ID: 129352, created on Aug 30, 2016, last review on Aug 30, 2016

  • Applies to:
  • Operations Automation 6.0


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:


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

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF