From i51359@yahoo.com Sun Sep 11 17:09:29 2005 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EB0EFD714A for ; Sun, 11 Sep 2005 14:09:29 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03938-10 for ; Sun, 11 Sep 2005 17:09:27 +0000 (GMT) Received: from web33912.mail.mud.yahoo.com (web33912.mail.mud.yahoo.com [66.163.178.76]) by svr1.postgresql.org (Postfix) with SMTP id A8D1DD6E0B for ; Sun, 11 Sep 2005 14:09:27 -0300 (ADT) Received: (qmail 21042 invoked by uid 60001); 11 Sep 2005 17:09:27 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=REvKoyeCVCCLGBWCkwj5TFVuO55MagbDSz/mdWwL00vJaZriL7ti7BZ44n/PzPYGjOJJu2Cvq8sQ5GdkdY2L/Z0jqbtQLVL+BBOs27yc5Hb9Ors4rbLR5bxZRAFUxrC9B8J5SeRXWyU55A3RJeW2MzASdNW/rXSXWTnnEKxiiTM= ; Message-ID: <20050911170927.21040.qmail@web33912.mail.mud.yahoo.com> Received: from [68.209.250.7] by web33912.mail.mud.yahoo.com via HTTP; Sun, 11 Sep 2005 10:09:27 PDT Date: Sun, 11 Sep 2005 10:09:27 -0700 (PDT) From: The One Subject: Panic: Page Add Item: Corrupted page pointers To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1581917050-1126458567=:20063" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.963 required=5 tests=[AWL=0.016, DNS_FROM_RFC_ABUSE=0.374, FROM_ENDS_IN_NUMS=0.516, HTML_30_40=0.056, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200509/118 X-Sequence-Number: 22665 --0-1581917050-1126458567=:20063 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 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 --0-1581917050-1126458567=:20063 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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 --0-1581917050-1126458567=:20063-- From tgl@sss.pgh.pa.us Mon Sep 12 00:01:50 2005 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 923BCD8655 for ; Sun, 11 Sep 2005 21:01:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99131-01 for ; Mon, 12 Sep 2005 00:01:45 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id F249FD85CA for ; Sun, 11 Sep 2005 21:01:46 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j8C01nkM010807; Sun, 11 Sep 2005 20:01:50 -0400 (EDT) To: The One Cc: pgsql-sql@postgresql.org Subject: Re: Panic: Page Add Item: Corrupted page pointers In-reply-to: <20050911170927.21040.qmail@web33912.mail.mud.yahoo.com> References: <20050911170927.21040.qmail@web33912.mail.mud.yahoo.com> Comments: In-reply-to The One message dated "Sun, 11 Sep 2005 10:09:27 -0700" Date: Sun, 11 Sep 2005 20:01:49 -0400 Message-ID: <10806.1126483309@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200509/124 X-Sequence-Number: 22671 The One 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