Fwd: Getting invalid page header in block while vacuuming PostgreSQL DB.

Поиск
Список
Период
Сортировка
От lalit jangra
Тема Fwd: Getting invalid page header in block while vacuuming PostgreSQL DB.
Дата
Msg-id CANWCqG6ej_YLP=Pc=U7PWvvMixQ6Dw4ocwuOMveP_xRSF1C7LA@mail.gmail.com
обсуждение исходный текст
Список pgsql-general

Hi,

I am using PostgreSQL 9.2 and while trying to vacuum db named mcfdb3, i am getting below error.

DETAIL:  0 index row versions were removed.

110 index pages have been deleted, 110 are currently reusable.

CPU 0.02s/0.00u sec elapsed 0.03 sec.

INFO:  index "i1409226645953" now contains 374682 row versions in 3267 pages

DETAIL:  0 index row versions were removed.

1436 index pages have been deleted, 1436 are currently reusable.

CPU 0.01s/0.00u sec elapsed 0.01 sec.

vacuumdb: vacuuming of database "mcfdb3" failed: ERROR:  invalid page header in block 15871 of relation base/17148/30976

DETAIL:  0 index row versions were removed.

110 index pages have been deleted, 110 are currently reusable.

CPU 0.02s/0.00u sec elapsed 0.03 sec.

INFO:  index "i1409226645953" now contains 374682 row versions in 3267 pages

DETAIL:  0 index row versions were removed.

1436 index pages have been deleted, 1436 are currently reusable.

CPU 0.01s/0.00u sec elapsed 0.01 sec.

vacuumdb: vacuuming of database "mcfdb3" failed: ERROR:  invalid page header in block 15871 of relation base/17148/30976

Please help.
 
Regards,
Lalit.

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

Предыдущее
От: "pasman.p@gmail.com"
Дата:
Сообщение: Small fix in PG 9.4b2 - pg_env.sh
Следующее
От: Shida Sato
Дата:
Сообщение: About limit on cube dimensions