Getting invalid page header in block while vacuuming PostgreSQL DB.

Поиск
Список
Период
Сортировка
От lalit jangra
Тема Getting invalid page header in block while vacuuming PostgreSQL DB.
Дата
Msg-id CANWCqG5BggxqVVEhFuLRYcKGD1Q5LdbRjGPk7h5zoHH1An+MBA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Getting invalid page header in block while vacuuming PostgreSQL DB.  (Jerry Sievers <gsievers19@comcast.net>)
Список pgsql-admin
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-admin по дате отправления:

Предыдущее
От: "Saravanan.S"
Дата:
Сообщение: Re: Table Partition
Следующее
От: "liuyuanyuan"
Дата:
Сообщение: 答复: [JDBC] invalid byte sequence for encoding "UTF8": 0x00