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

From: lalit jangra <lalit(dot)j(dot)jangra(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Fwd: Getting invalid page header in block while vacuuming PostgreSQL DB.
Date: 2014-08-31 16:45:33
Message-ID: CANWCqG6ej_YLP=Pc=U7PWvvMixQ6Dw4ocwuOMveP_xRSF1C7LA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message liuyuanyuan 2014-09-01 02:04:24 答复: [JDBC] invalid byte sequence for encoding "UTF8": 0x00
Previous Message Andreas Joseph Krogh 2014-08-30 17:21:41 Re: invalid byte sequence for encoding "UTF8": 0x00

Browse pgsql-general by date

  From Date Subject
Next Message Shida Sato 2014-08-31 21:05:09 About limit on cube dimensions
Previous Message pasman.p@gmail.com 2014-08-31 14:22:32 Small fix in PG 9.4b2 - pg_env.sh