Thread: db errors

db errors

From
"Akash Garg"
Date:

We had a crash of one of our db systems last night.  After doing a fsck of he file system and getting the db backup, we’re getting a lot of these messages in our logs.  The DB will also occasionally crash now.

 

Oct 12 07:40:16 postgres[30770]: [3-1] 2007-10-12 07:40:16 PDTERROR:  could not access status of transaction 2259991368

Oct 12 07:40:16 postgres[30770]: [3-2] 2007-10-12 07:40:16 PDTDETAIL:  Could not read from file "pg_clog/086B" at offset 73728: Success.

 

Any ideas?

 

Thanks,

Akash