ERROR: could not access status of transaction

["Thomas F. O'Connell" <tfo(at)sitening(dot)com>]

I recently saw this in some postgres logs:

ERROR:  could not access status of transaction ...
DETAIL:  could not open file "pg_clog/...": No such file or directory
STATEMENT:  COPY ...

The copy command was issued amongst a number of other queries from an  
application layer at the same time as a pg_dumpall was running.

Based on this:

http://archives.postgresql.org/pgsql-committers/2006-01/msg00287.php

I would not have thought this cluster was vulnerable. It's running  
8.1.3. It makes me a little nervous that the nightly backup was  
interrupted, but it makes me a little more nervous that it seems  
indicative of an abstruse error condition. Any thoughts from the  
hackers?

--
Thomas F. O'Connell
Database Architecture and Programming
Sitening, LLC

http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)