Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id 9E0669F9C9E for ; Tue, 21 Nov 2006 21:29:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 67710-02 for ; Tue, 21 Nov 2006 21:29:45 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web55214.mail.re4.yahoo.com (web55214.mail.re4.yahoo.com [206.190.58.178]) by postgresql.org (Postfix) with SMTP id 687E59FA161 for ; Tue, 21 Nov 2006 21:29:43 -0400 (AST) Received: (qmail 44453 invoked by uid 60001); 22 Nov 2006 00:29:42 -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; b=5D/nSs9CopDJqwD5G6j+kTjRQcGTx8xsFGTy1Z7CbBaw0IbCDlOYaycPlBBQh1Xfo46UsMMCMh2kKiX8rR9urNGn9e96SaAuNG0NCBbj6VjIH1RqEwtbT/cX7Ejn6MC+eUZ0sd1bn58VF0w6UVWvUXuG4tpB7LMdZtOCTdFIuDo= ; Message-ID: <20061122002942.44451.qmail@web55214.mail.re4.yahoo.com> Received: from [67.180.92.241] by web55214.mail.re4.yahoo.com via HTTP; Tue, 21 Nov 2006 16:29:42 PST Date: Tue, 21 Nov 2006 16:29:42 -0800 (PST) From: anil maran Subject: Fw: postgres database crash To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1612159056-1164155382=:44204" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.753 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_40_50, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200611/191 X-Sequence-Number: 23718 --0-1612159056-1164155382=:44204 Content-Type: text/plain; charset=ascii Content-Transfer-Encoding: quoted-printable Hi=0ACRON job running vacuum on a database and pg_ctl stop -m fast got call= ed=0A=0ANow I m unable to run the database, the following is the error when= I run pg_ctl -D /work/database start=0ALOG: logger shutting down=0A=0Aon = running =0Atail -n 30 postgresql-Mon.log =0ALOG: database system was not p= roperly shut down; automatic recovery in progress=0ALOG: redo starts at 8A= /8F00833C=0APANIC: block 1100 unfound=0ALOG: startup process (PID 31612) = was terminated by signal 6 =0ALOG: aborting startup due to startup process= failure=0ALOG: logger shutting down=0ALOG: database system was interrupt= ed while in recovery at 2006-11-20 16:56:18 PST=0AHINT: This probably mean= s that some data is corrupted and you will have to use the last backup for = recovery. =0ALOG: checkpoint record is at 8A/8F01D6D4=0ALOG: redo record = is at 8A/8F00833C; undo record is at 0/0; shutdown FALSE=0ALOG: next trans= action ID: 32782967; next OID: 2499839=0ALOG: next MultiXactId: 972; next = MultiXactOffset: 2099 =0ALOG: database system was not properly shut down; = automatic recovery in progress=0ALOG: redo starts at 8A/8F00833C=0APANIC: = block 1100 unfound=0ALOG: startup process (PID 31846) was terminated by s= ignal 6=0ALOG: aborting startup due to startup process failure =0ALOG: lo= gger shutting down=0ALOG: database system was interrupted while in recover= y at 2006-11-20 17:12:21 PST=0AHINT: This probably means that some data is= corrupted and you will have to use the last backup for recovery. =0ALOG: = checkpoint record is at 8A/8F01D6D4=0ALOG: redo record is at 8A/8F00833C; = undo record is at 0/0; shutdown FALSE=0ALOG: next transaction ID: 32782967= ; next OID: 2499839=0ALOG: next MultiXactId: 972; next MultiXactOffset: 20= 99 =0ALOG: database system was not properly shut down; automatic recovery = in progress=0ALOG: redo starts at 8A/8F00833C=0APANIC: block 1100 unfound= =0ALOG: startup process (PID 32000) was terminated by signal 6=0ALOG: abo= rting startup due to startup process failure =0ALOG: logger shutting down= =0A=0Apg_controldata =0Apg_control version number: 812=0ACatalog= version number: 200510211=0ADatabase system identifier: = 4952196794948500735 =0ADatabase cluster state: in recov= ery=0Apg_control last modified: Mon 20 Nov 2006 05:14:36 PM PST= =0ACurrent log file ID: 138=0ANext log file segment: = 170=0ALatest checkpoint location: 8A/8F01D6D4 =0APrior = checkpoint location: 8A/8C01924C=0ALatest checkpoint's REDO loca= tion: 8A/8F00833C=0ALatest checkpoint's UNDO location: 0/0=0ALatest c= heckpoint's TimeLineID: 1=0ALatest checkpoint's NextXID: 327= 82967 =0ALatest checkpoint's NextOID: 2499839=0ALatest checkpoint'= s NextMultiXactId: 972=0ALatest checkpoint's NextMultiOffset: 2099=0ATime= of latest checkpoint: Mon 20 Nov 2006 12:53:56 PM PST=0AMaximum= data alignment: 4 =0ADatabase block size: 8= 192=0ABlocks per segment of large relation: 131072=0ABytes per WAL segment:= 16777216=0AMaximum length of identifiers: 64=0AMaxim= um columns in an index: 32 =0ADate/time type storage: = floating-point numbers=0AMaximum length of locale name: 128=0ALC_C= OLLATE: en_US.UTF-8=0ALC_CTYPE: = en_US.UTF-8=0A=0A=0AI tried running pg_resetxlog everything go= t lost, so restoring the copied database folder=0A=0AI got pointers to look= ing at pg_filedump and I could not find out how to specify options to filed= ump=0APlease help me out=0Amy data bases is like 1gigabyte, panicking=0Atha= nks=0A=0A =0AAnil=0A=0A=0A =0A_____________________________________________= _______________________________________=0ASponsored Link=0A=0AMortgage rate= s near 39yr lows. $510k for $1,698/mo. =0ACalculate new payment! www.LowerM= yBills.com/lre --0-1612159056-1164155382=:44204 Content-Type: text/html; charset=ascii Content-Transfer-Encoding: quoted-printable
Hi
=0A
=0A
=0A
=0A
CRON= job running vacuum on a database and pg_ctl stop -m fast got called

Now I m unable to run th= e database, the following is the error when I run pg_ctl -D /work/database start
LOG:  logger shutting down

on running
=0A=
tail -n 30 postgresql-Mon.log
LOG:  database system was not properly shut down; automatic recov= ery in progress
LOG:  redo starts at 8A/8F00833C
PANIC:  bl= ock 1100 unfound
LOG:  startup process (PID 31612) was terminated b= y signal 6
LOG:  aborting startup due to startup process failureLOG:  logger shutting down
LOG:  database system was interru= pted while in recovery at 2006-11-20 16:56:18 PST
HINT:  This proba= bly means that some data is corrupted and you will have to use the last bac= kup for recovery.
LOG:  checkpoint record is at 8A/8F01D6D4
LOG= :  redo record is at 8A/8F00833C; undo record is at 0/0; shutdown FALS= E
LOG:  next transaction ID: 32782967; next OID: 2499839
LOG:&nb= sp; next MultiXactId: 972; next MultiXactOffset: 2099
LOG:  databa= se system was not properly shut down; automatic recovery in progress
LOG= :  redo starts at 8A/8F00833C
PANIC:  block 1100 unfound
LOG:  sta= rtup process (PID 31846) was terminated by signal 6
LOG:  aborting = startup due to startup process failure
LOG:  logger shutting down<= BR>LOG:  database system was interrupted while in recovery at 2006-11-= 20 17:12:21 PST
HINT:  This probably means that some data is corrup= ted and you will have to use the last backup for recovery.
LOG:  c= heckpoint record is at 8A/8F01D6D4
LOG:  redo record is at 8A/8F008= 33C; undo record is at 0/0; shutdown FALSE
LOG:  next transaction I= D: 32782967; next OID: 2499839
LOG:  next MultiXactId: 972; next Mu= ltiXactOffset: 2099
LOG:  database system was not properly shut do= wn; automatic recovery in progress
LOG:  redo starts at 8A/8F00833C=
PANIC:  block 1100 unfound
LOG:  startup process (PID 3200= 0) was terminated by signal 6
LOG:  aborting startup due to startup= process failure
LOG:  logger shutting down

pg_controldata
pg_control version number:  =           812
Catalog versi= on number:           = ;    200510211
Database system identifier:  &nb= sp;        4952196794948500735
Datab= ase cluster state:         &nb= sp;     in recovery
pg_control last modified: &= nbsp;           Mon 20 No= v 2006 05:14:36 PM PST
Current log file ID:     = ;             1= 38
Next log file segment:        = ;        170
Latest checkpoint location:           8A/8= F01D6D4
Prior checkpoint location:      &= nbsp;     8A/8C01924C
Latest checkpoint's REDO locat= ion:    8A/8F00833C
Latest checkpoint's UNDO location:&nb= sp;   0/0
Latest checkpoint's TimeLineID:   &nb= sp;   1
Latest checkpoint's NextXID:    &n= bsp;     32782967
Latest checkpoint's NextOID: = ;         2499839
Latest checkpo= int's NextMultiXactId:  972
Latest checkpoint's NextMultiOffset:&nb= sp; 2099
Time of latest checkpoint:      &= nbsp;     Mon 20 Nov 2006 12:53:56 PM PST
Maximum da= ta alignment:          &n= bsp;    4
Database block size:           &nb= sp;      8192
Blocks per segment of large relat= ion: 131072
Bytes per WAL segment:      &n= bsp;         16777216
Maximum le= ngth of identifiers:        64
Maximu= m columns in an index:         = ; 32
Date/time type storage:       &= nbsp;       floating-point numbers
Maximum= length of locale name:        128
LC= _COLLATE:           =              &n= bsp;   en_US.UTF-8
LC_CTYPE:        &n= bsp;            = ;         en_US.UTF-8


I tried= running pg_resetxlog everything g= ot lost, so restoring the copied database= folder

I got pointers to looking at pg_filedump and I could not find out how to specify option= s to filedump
Please help me out
my data bases is like 1gigabyte, pan= icking
thanks
=0A
 
Anil
<= br>=0A=0A
Sponsored Lin= k


=0ADegrees for employed people - in as fast as 1 year.= A.S. / Bachelors / Masters --0-1612159056-1164155382=:44204--