Getting invalid page header in block while vacuuming PostgreSQL DB.

[lalit jangra <lalit.j.jangra@xxxxxxxxx>]

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.