Home > mailing lists

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

From

lalit jangra

Date:

31 August 2014, 16:45:38

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.