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@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
