pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Getting invalid page header in block while vacuuming PostgreSQL DB. 3+ messages / 2 participants [nested] [flat]
* Getting invalid page header in block while vacuuming PostgreSQL DB. @ 2014-08-30 17:12 lalit jangra <lalit.j.jangra@gmail.com> 2014-08-31 16:45 ` Fwd: Getting invalid page header in block while vacuuming PostgreSQL DB. lalit jangra <lalit.j.jangra@gmail.com> 2014-09-01 17:57 ` Re: Getting invalid page header in block while vacuuming PostgreSQL DB. Jerry Sievers <gsievers19@comcast.net> 0 siblings, 2 replies; 3+ messages in thread From: lalit jangra @ 2014-08-30 17:12 UTC (permalink / raw) To: 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Fwd: Getting invalid page header in block while vacuuming PostgreSQL DB. 2014-08-30 17:12 Getting invalid page header in block while vacuuming PostgreSQL DB. lalit jangra <lalit.j.jangra@gmail.com> @ 2014-08-31 16:45 ` lalit jangra <lalit.j.jangra@gmail.com> 1 sibling, 0 replies; 3+ messages in thread From: lalit jangra @ 2014-08-31 16:45 UTC (permalink / raw) To: pgsql-general@postgresql.org 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Getting invalid page header in block while vacuuming PostgreSQL DB. 2014-08-30 17:12 Getting invalid page header in block while vacuuming PostgreSQL DB. lalit jangra <lalit.j.jangra@gmail.com> @ 2014-09-01 17:57 ` Jerry Sievers <gsievers19@comcast.net> 1 sibling, 0 replies; 3+ messages in thread From: Jerry Sievers @ 2014-09-01 17:57 UTC (permalink / raw) To: lalit jangra <lalit.j.jangra@gmail.com>; +Cc: pgsql-admin lalit jangra <lalit.j.jangra@gmail.com> writes: > 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 Start by looking up that relfilenode in pg_class of the involved DB to see if it's a table or index relation that's corrupt. If per chance this is an index than rebuilding same may be all that's needed. > > 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. > -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@comcast.net p: 312.241.7800 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2014-09-01 17:57 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-08-30 17:12 Getting invalid page header in block while vacuuming PostgreSQL DB. lalit jangra <lalit.j.jangra@gmail.com> 2014-08-31 16:45 ` lalit jangra <lalit.j.jangra@gmail.com> 2014-09-01 17:57 ` Jerry Sievers <gsievers19@comcast.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox