Received: from localhost (pluto.hub.org [200.46.204.4]) by postgresql.org (Postfix) with ESMTP id 2B06C9FA2E2 for ; Tue, 21 Nov 2006 00:46:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.4]) (amavisd-new, port 10024) with ESMTP id 61150-10 for ; Tue, 21 Nov 2006 00:46:27 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web55207.mail.re4.yahoo.com (web55207.mail.re4.yahoo.com [206.190.58.171]) by postgresql.org (Postfix) with SMTP id A14989FA0C0 for ; Tue, 21 Nov 2006 00:46:27 -0400 (AST) Received: (qmail 63152 invoked by uid 60001); 21 Nov 2006 01:59:46 -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=fZ4v/KUzap4s94I/Muwr5c/Cl4N0yS62MsQtNkJa1LXLNgM2ORxErTzqU327N1O2JUrFfI13xLIoi79xXtwvg4PCoamlkn6Lzy3mvRVdaH9dxDl2MER4nQhH6T/EIT1J64jdJfPZ+zlDK9kLul4wrFvSFeJyTi9iDnvX9kUsfS8= ; Message-ID: <20061121015946.63150.qmail@web55207.mail.re4.yahoo.com> Received: from [67.180.92.241] by web55207.mail.re4.yahoo.com via HTTP; Mon, 20 Nov 2006 17:59:46 PST Date: Mon, 20 Nov 2006 17:59:46 -0800 (PST) From: anil maran Subject: LOG: logger shutting down To: anil maran , allan@saddi.com MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1881414252-1164074386=:62094" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.667 tagged_above=0 required=5 tests=BAYES_40, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_40_50, HTML_MESSAGE X-Spam-Level: *** X-Archive-Number: 200611/188 X-Sequence-Number: 23715 --0-1881414252-1164074386=:62094 Content-Type: text/plain; charset=ascii Content-Transfer-Encoding: quoted-printable my db server has crashed=0Ai m using postgres=0Awhat happened is when reind= exing was happening=0Apostgres got shut down=0Anow i m unable to start can = you give me any pointers=0A=0A=0A=0ACRON running vacuum on a database=0Aand= pg_ctl stop -m fast got called=0A=0ANow I m unalbe ot run the database, th= e following is the error when I run =0Apg_ctl -D /work/database start=0ALOG= : logger shutting down=0A=0Aon running tail -n 30 postgresql-Mon.log=0A=0A= =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 31612) was terminated by signal 6=0A=0ALOG: = aborting startup due to startup process failure=0ALOG: logger shutting dow= n=0ALOG: database system was interrupted while in recovery at 2006-11-20 1= 6:56:18 PST=0AHINT: This probably means that some data is corrupted and yo= u will have to use the last backup for recovery.=0A=0ALOG: checkpoint reco= rd 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: 249= 9839=0ALOG: next MultiXactId: 972; next MultiXactOffset: 2099=0A=0ALOG: d= atabase system was not properly shut down; automatic recovery in progress= =0ALOG: redo starts at 8A/8F00833C=0APANIC: block 1100 unfound=0ALOG: st= artup process (PID 31846) was terminated by signal 6=0ALOG: aborting start= up due to startup process failure=0A=0ALOG: logger shutting down=0ALOG: d= atabase system was interrupted while in recovery 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.=0A=0ALOG: checkpoint record is at 8A= /8F01D6D4=0ALOG: redo record is at 8A/8F00833C; undo record is at 0/0; shu= tdown FALSE=0ALOG: next transaction ID: 32782967; next OID: 2499839=0ALOG:= next MultiXactId: 972; next MultiXactOffset: 2099=0A=0ALOG: database sys= tem 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: aborting startup due to sta= rtup process failure=0A=0ALOG: logger shutting down=0A=0Apg_controldata = =0Apg_control version number: 812=0ACatalog version number: = 200510211=0ADatabase system identifier: 495219679494850= 0735=0A=0ADatabase cluster state: in recovery=0Apg_control la= st modified: Mon 20 Nov 2006 05:14:36 PM PST=0ACurrent log file= ID: 138=0ANext log file segment: 170=0A=0A= Latest checkpoint location: 8A/8F01D6D4=0A=0APrior checkpoint loc= ation: 8A/8C01924C=0ALatest checkpoint's REDO location: 8A/8F= 00833C=0ALatest checkpoint's UNDO location: 0/0=0ALatest checkpoint's Ti= meLineID: 1=0ALatest checkpoint's NextXID: 32782967=0A=0ALat= est checkpoint's NextOID: 2499839=0ALatest checkpoint's NextMultiX= actId: 972=0ALatest checkpoint's NextMultiOffset: 2099=0ATime of latest c= heckpoint: Mon 20 Nov 2006 12:53:56 PM PST=0AMaximum data alignm= ent: 4=0A=0ADatabase block size: 8192=0ABloc= ks per segment of large relation: 131072=0ABytes per WAL segment: = 16777216=0AMaximum length of identifiers: 64=0AMaximum columns= in an index: 32=0A=0ADate/time type storage: floati= ng-point numbers=0AMaximum length of locale name: 128=0ALC_COLLATE: = en_US.UTF-8=0ALC_CTYPE: = en_US.UTF-8=0A=0A=0A=0A=0AI tried running pg_resetxlog everything got lo= st, so restoring the copied database folder=0A=0AI got pointers to looking = at =0A=0Apg_filedump and I could not find out how to specify options to fil= edump=0APlease help me out=0Amy data bases is like 1gigabyte, panicking=0At= hanks =0A=0A=0A=0A=0A =0A__________________________________________________= __________________________________=0ADo you Yahoo!?=0AEveryone is raving ab= out the all-new Yahoo! Mail beta.=0Ahttp://new.mail.yahoo.com --0-1881414252-1164074386=:62094 Content-Type: text/html; charset=ascii Content-Transfer-Encoding: quoted-printable
my db server has cra= shed
i m us= ing postgres
what happened is when reindexing was happening
postgres got shut down
now i m unable to start c= an you give me any pointers

=0A=0ACRON running vacuum on a database
and pg_ctl stop -m fast got called

Now I m unal= be ot run the database, the following is the error when I run =0Apg_ctl -D /work/database start
LOG:  logger shutting down

on = running tail -n 30 postgresql-Mon.log=0A= =0A
LOG:  database system was not properly shut down; autom= atic recovery in progress
LOG:  redo starts at 8A/8F00833C
PANIC= :  block 1100 unfound
LOG:  startup process (PID 31612) was te= rminated by signal 6=0A
LOG:  aborting startup due to startup proce= ss failure
LOG:  logger shutting down
LOG:  database system= was interrupted while in recovery at 2006-11-20 16:56:18 PST
HINT: = ; This probably means that some data is corrupted and you will have to use = the last backup for recovery.=0A
LOG:  checkpoint record is at 8A/8= F01D6D4
LOG:  redo record is at 8A/8F00833C; undo record is at 0/0;= shutdown FALSE
LOG:  next transaction ID: 32782967; next OID: 2499= 839
LOG:  next MultiXactId: 972; next MultiXactOffset: 2099=0A
L= OG:  database system was not properly shut down; automatic recovery in= progress
LOG:  redo starts at 8A/8F00833C
PANIC:  block 11= 00 unfound
LOG:  startup process (PID 31846) was terminated by sign= al 6
LOG:  aborting startup due to startup process failure=0A
LO= G:  logger shutting down
LOG:  database system was interrupted= while in recovery at 2006-11-20 17:12:21 PST
HINT:  This probably = means that some data is corrupted and you will have to use the last backup = for recovery.=0A
LOG:  checkpoint record is at 8A/8F01D6D4
LOG:&= nbsp; redo record is at 8A/8F00833C; undo record is at 0/0; shutdown FALSE<= br>LOG:  next transaction ID: 32782967; next OID: 2499839
LOG: = ; next MultiXactId: 972; next MultiXactOffset: 2099=0A
LOG:  databa= se system was not properly shut down; automatic recovery in progress
LOG= :  redo starts at 8A/8F00833C
PANIC:  block 1100 unfound
LO= G:  startup process (PID 32000) was terminated by signal 6
LOG:&nbs= p; aborting startup due to startup process failure=0A
LOG:  logger = shutting down

pg_controldata
pg_control version number:       =      812
Catalog version number:   &n= bsp;           200510211<= br>Database system identifier:       &nb= sp;   4952196794948500735=0A
Database cluster state: &nbs= p;             = in recovery
pg_control last modified:      = ;       Mon 20 Nov 2006 05:14:36 PM PST
Cu= rrent log file ID:         &nb= sp;        138
Next log file segment:=             &nb= sp;   170
=0ALatest checkpoint location:   &nbs= p;       8A/8F01D6D4=0A
Prior checkpoint l= ocation:            = 8A/8C01924C
Latest checkpoint's REDO location:    8A/8F00= 833C
Latest checkpoint's UNDO location:    0/0
Latest = checkpoint's TimeLineID:       1
Latest ch= eckpoint's NextXID:          3= 2782967=0A
Latest checkpoint's NextOID:     &nb= sp;    2499839
Latest checkpoint's NextMultiXactId: = 972
Latest checkpoint's NextMultiOffset:  2099
Time of latest c= heckpoint:           = ; Mon 20 Nov 2006 12:53:56 PM PST
Maximum data alignment:  &nb= sp;            4=0A<= br>Database block size:        &nbs= p;         8192
Blocks per segme= nt of large relation: 131072
Bytes per WAL segment:   &nb= sp;            16777= 216
Maximum length of identifiers:      &n= bsp; 64
Maximum columns in an index:      =     32=0A
Date/time type storage:    =            floating-point= numbers
Maximum length of locale name:     &nb= sp;  128
LC_COLLATE:        = ;           &nb= sp;       en_US.UTF-8
LC_CTYPE:  = ;            &n= bsp;           =    en_US.UTF-8

=0A=0A
I tried running pg_resetxlog everything got lost, so restoring the= copied database folder

I = got pointers to looking at =0A=0Apg_file= dump and I could not find out how to specify options to filedump
= Please help me out
my data bases is like 1gigabyte, panicking
thanks<= /span>
 


=0A=0A
Sponsored Link

=0AMortgage rates a= s low as 4.625% - $150,000 loan for $579 a month. Intro-*Terms --0-1881414252-1164074386=:62094--