Re: Corrupted Data?

Поиск
Список
Период
Сортировка
От Matthew T. O'Connor
Тема Re: Corrupted Data?
Дата
Msg-id 41478649.3080808@zeut.net
обсуждение исходный текст
Ответ на Re: Corrupted Data?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Ответы Re: Corrupted Data?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список 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@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



В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Spacing in output
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Corrupted Data?