Michael Clark <codingninja@xxxxxxxxx> writes: > On Fri, Jul 31, 2009 at 5:24 PM, Greg Stark <gsstark@xxxxxxx> wrote: >>> Now I am getting: >>> ERROR: could not access status of transaction 3839923882 >> How long has this database been in use? That's a very high transaction >> number that would only be reached on a heavily used database after a >> reasonably long period of use. If that's not likely than a likely >> possibility is that your table has been overwritten with garbage. >> Possibly by a filesystem bug or hardware failure. > Not really that long. The database was created in early June, and if that > is supposed to be a transaction count (3839923882), then yeah that seems way > out there. It seems certain that you're looking at corrupt data. Trashed data frequently manifests this way, because the transaction ID is the first field of tuple headers that the database can cross-check with any amount of rigor. At this point we know that at least two unrelated disk blocks have been clobbered by something (first that index page, and now this). There's no very good reason to think there are only two :-(. I'd bet at least a cheese sandwich on hardware problems. Test and fix/replace your hardware, then go back to your last backup (I hope you've got one). regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
