pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Panic: Page Add Item: Corrupted page pointers 2+ messages / 2 participants [nested] [flat]
* Panic: Page Add Item: Corrupted page pointers @ 2005-09-11 17:09 The One <i51359@yahoo.com> 2005-09-12 00:01 ` Re: Panic: Page Add Item: Corrupted page pointers Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: The One @ 2005-09-11 17:09 UTC (permalink / raw) To: pgsql-sql Hi, I'm getting this error when try to create a table in Postgresql 7.3, windows2000: Panic: Page Add Item: Corrupted page pointers: lower=24258, upper=39318, special=65421 LOG: statement = create table data(key unique, status text, info text) LOG: pg_recvby : unexpected EOF on client connection LOG: server process <pid 13847> was terminated by signal 6 LOG: all server processes terminated; reinitializing shared memory and semaphores ..... Thank you --------------------------------- Yahoo! for Good Watch the Hurricane Katrina Shelter From The Storm concert ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Panic: Page Add Item: Corrupted page pointers 2005-09-11 17:09 Panic: Page Add Item: Corrupted page pointers The One <i51359@yahoo.com> @ 2005-09-12 00:01 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2005-09-12 00:01 UTC (permalink / raw) To: The One <i51359@yahoo.com>; +Cc: pgsql-sql The One <i51359@yahoo.com> writes: > I'm getting this error when try to create a table in Postgresql 7.3, windows2000: > Panic: Page Add Item: Corrupted page pointers: lower=24258, upper=39318, special=65421 Apparently you've got at least one corrupt page in at least one system table. I'd recommend pg_dump'ing as much as you can and then recreate the database. If pg_dump doesn't work you could try turning on zero_damaged_pages, and praying that most of what you need is on undamaged pages. It's quite possible though that that will hose the DB completely, so don't do it till you've exhausted the possibilities for pg_dump without it. Consider updating to a more recent PG release while you are recovering... regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-09-12 00:01 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-09-11 17:09 Panic: Page Add Item: Corrupted page pointers The One <i51359@yahoo.com> 2005-09-12 00:01 ` Tom Lane <tgl@sss.pgh.pa.us>
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