can't find files in pg_clog and invalid page headers

Поиск
Список
Период
Сортировка
Искать
От
Adam Kavan
Тема
can't find files in pg_clog and invalid page headers
Дата
Msg-id
5.2.1.1.0.20030814131833.009e8de0@pop.central.cox.net
Список
Дерево обсуждения
can't find files in pg_clog and invalid page headers Adam Kavan <akavan@cox.net>
Re: can't find files in pg_clog and invalid page headers Tom Lane <tgl@sss.pgh.pa.us>
Re: can't find files in pg_clog and invalid page Adam Kavan <akavan@cox.net>
Re: can't find files in pg_clog and invalid page headers Tom Lane <tgl@sss.pgh.pa.us>
I am running postgres 7.4Beta1 and have found a problem, I'm not sure if 
its a bug or something I did wrong.  I ran ANALYZE on a large table while 
the database was receiving data, after running it on just my large table I 
decided to run it on my entire database.  When I issued the database wide 
analyze I got an error:

data=# analyze;
ERROR:  could not access status of transaction 739760128
DETAIL:  open of file "/usr/local/pgsql/data/pg_clog/02C1" failed: No such 
file or directory

There is only one file in pg_clog its called 0000.  I ran it again and got:

data=# analyze;
ERROR:  could not access status of transaction 3942652937
DETAIL:  open of file "/usr/local/pgsql/data/pg_clog/0EB0" failed: No such 
file or directory

Then I tried running analyze just on my large table again and got:

data=# ANALYZE "DetailedMeters";
ERROR:  invalid page header in block 10836 of "DetailedMeters"

Now whenever I try to read all of "DetailedMeters" I get that error message 
though the block numbers can change (10832,10834,10836).

Anyone know what I did to cause this?  Or is this some sort of bug or 
hardware failure?

---- Adam Kavan
---- akavan@cox.net

В списке pgsql-general по дате отправления
От: Bruno Wolff III
Дата:
Сообщение: Re: importing db as text files
От: Peter Childs
Дата:
Сообщение: 7.4Beta
FAQ