| From: | lalit jangra <lalit(dot)j(dot)jangra(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Getting invalid page header in block while vacuuming PostgreSQL DB. |
| Date: | 2014-08-30 17:12:31 |
| Message-ID: | CANWCqG5BggxqVVEhFuLRYcKGD1Q5LdbRjGPk7h5zoHH1An+MBA@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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Joseph Krogh | 2014-08-30 17:21:41 | Re: invalid byte sequence for encoding "UTF8": 0x00 |
| Previous Message | Jeffrey Shaw | 2014-08-29 13:54:27 | psql on Linux vs Windows, major GSS differences |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pasman.p@gmail.com | 2014-08-31 14:22:32 | Small fix in PG 9.4b2 - pg_env.sh |
| Previous Message | Adrian Klaver | 2014-08-30 14:22:56 | Re: alter column to varchar without view drop/re-creation |