| From: | Gordon Shannon <gordo169(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | could not access status of transaction 1118722281 |
| Date: | 2011-04-05 02:28:14 |
| Message-ID: | 1301970494832-4283137.post@n5.nabble.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Running 9.0.2 on Centos.
I just discovered this in my production error log. Starting about 45
minutes ago, I got 70 of these, within 2 seconds:
28652 2011-04-04 21:47:29 EDT [33]WARNING: PD_ALL_VISIBLE flag was
incorrectly set in relation "pg_toast_49338181" page 16820
These warnings were immediately proceeded by this, which has continuously
repeated every 15 seconds since then:
8895 2011-04-04 22:15:28 EDT [1]ERROR: could not access status of
transaction 1118722281
8895 2011-04-04 22:15:28 EDT [2]DETAIL: Could not open file
"pg_clog/042A": No such file or directory.
8895 2011-04-04 22:15:28 EDT [3]CONTEXT: automatic vacuum of table
"mcore.pg_toast.pg_toast_48975830"
I checked and the pg_clog files start at 04BF and run through 0A57 (1,433
files)
Any help would be greatly appreciated.
Gordon
--
View this message in context: http://postgresql.1045698.n5.nabble.com/could-not-access-status-of-transaction-1118722281-tp4283137p4283137.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Curvey | 2011-04-05 03:18:50 | postgres segfaulting on pg_restore |
| Previous Message | C. Bensend | 2011-04-05 01:34:28 | Re: Plpgsql function to compute "every other Friday" |