| From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
| Cc: | Chester Kustarz <chester(at)arbor(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Corrupted Data? |
| Date: | 2004-09-15 00:01:13 |
| Message-ID: | 41478649.3080808@zeut.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alvaro Herrera wrote:
> On Tue, Sep 14, 2004 at 08:13:24AM -0400, Matthew T. O'Connor wrote:
> You can create a pg_clog file (the one it's complaining about) filled
> with zeros, using
> dd if=/dev/zero bs=1k count=8 of=/path/to/data/pg_clog/0E3D
Ok, I tried this, and it changed the error but hasn't fixed the problem
now I get this:
[dbmail2(at)dezeut dbmail2]$ psql
Welcome to psql 7.4.2, the PostgreSQL interactive terminal.
dbmail2=# delete from messageblks where messageblk_idnr = 7718;
ERROR: could not access status of transaction 3822646358
DETAIL: could not read from file "/var/lib/pgsql/data/pg_clog/0E3D" at
offset 139264: Success
And in the log file I get this:
ERROR: XX000: could not access status of transaction 3822646358
DETAIL: could not read from file "/var/lib/pgsql/data/pg_clog/0E3D" at
offset 139264: Success
LOCATION: SlruReportIOError, slru.c:634
Any more thoughts?
Thanks again,
Matthew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2004-09-15 01:38:41 | Re: Corrupted Data? |
| Previous Message | Martijn van Oosterhout | 2004-09-14 23:35:07 | Re: Spacing in output |