--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
<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:arial, helvetica, sans-serif;font-size:8=
pt"><DIV><FONT size=3D1>Hi</FONT></DIV>=0A<DIV style=3D"FONT-SIZE: 8pt; FON=
T-FAMILY: arial, helvetica, sans-serif">=0A<DIV style=3D"FONT-SIZE: 12pt; F=
ONT-FAMILY: times new roman, new york, times, serif">=0A<DIV style=3D"FONT-=
SIZE: 14pt; FONT-FAMILY: arial, helvetica, sans-serif">=0A<DIV><STRONG>CRON=
</STRONG>job running vacuum on a database and <SPAN style=3D"FONT-WEIGHT: =
bold">pg_ctl stop -m fast</SPAN> got called<BR><BR>Now I m unable to run th=
e database, the following is the error when I run <SPAN style=3D"FONT-WEIGH=
T: bold">pg_ctl -D /work/database start</SPAN><BR><SPAN style=3D"FONT-WEIGH=
T: bold">LOG: logger shutting down</SPAN><BR><BR>on running </DIV>=0A=
<DIV><SPAN style=3D"FONT-WEIGHT: bold">tail -n 30 postgresql-Mon.log </SPAN=
><BR>LOG: database system was not properly shut down; automatic recov=
ery in progress<BR>LOG: redo starts at 8A/8F00833C<BR>PANIC: bl=
ock 1100 unfound<BR>LOG: startup process (PID 31612) was terminated b=
y signal 6 <BR>LOG: aborting startup due to startup process failure<B=
R>LOG: logger shutting down<BR>LOG: database system was interru=
pted while in recovery at 2006-11-20 16:56:18 PST<BR>HINT: This proba=
bly means that some data is corrupted and you will have to use the last bac=
kup for recovery. <BR>LOG: checkpoint record is at 8A/8F01D6D4<BR>LOG=
: redo record is at 8A/8F00833C; undo record is at 0/0; shutdown FALS=
E<BR>LOG: next transaction ID: 32782967; next OID: 2499839<BR>LOG:&nb=
sp; next MultiXactId: 972; next MultiXactOffset: 2099 <BR>LOG: databa=
se system was not properly shut down; automatic recovery in progress<BR>LOG=
: redo
starts at 8A/8F00833C<BR>PANIC: block 1100 unfound<BR>LOG: sta=
rtup process (PID 31846) was terminated by signal 6<BR>LOG: aborting =
startup due to startup process failure <BR>LOG: logger shutting down<=
BR>LOG: database system was interrupted while in recovery at 2006-11-=
20 17:12:21 PST<BR>HINT: This probably means that some data is corrup=
ted and you will have to use the last backup for recovery. <BR>LOG: c=
heckpoint record is at 8A/8F01D6D4<BR>LOG: redo record is at 8A/8F008=
33C; undo record is at 0/0; shutdown FALSE<BR>LOG: next transaction I=
D: 32782967; next OID: 2499839<BR>LOG: next MultiXactId: 972; next Mu=
ltiXactOffset: 2099 <BR>LOG: database system was not properly shut do=
wn; automatic recovery in progress<BR>LOG: redo starts at 8A/8F00833C=
<BR>PANIC: block 1100 unfound<BR>LOG: startup process (PID 3200=
0) was terminated by signal 6<BR>LOG: aborting startup due to startup=
process
failure <BR>LOG: logger shutting down<BR><BR><SPAN style=3D"FONT-WEI=
GHT: bold">pg_controldata </SPAN><BR>pg_control version number: =
812<BR>Catalog versi=
on number: =
; 200510211<BR>Database system identifier: &nb=
sp; 4952196794948500735 <BR>Datab=
ase cluster state: &nb=
sp; in recovery<BR>pg_control last modified: &=
nbsp; Mon 20 No=
v 2006 05:14:36 PM PST<BR>Current log file ID: =
; 1=
38<BR>Next log file segment: =
; 170<BR>Latest checkpoint
location: 8A/8=
F01D6D4 <BR>Prior checkpoint location: &=
nbsp; 8A/8C01924C<BR>Latest checkpoint's REDO locat=
ion: 8A/8F00833C<BR>Latest checkpoint's UNDO location:&nb=
sp; 0/0<BR>Latest checkpoint's TimeLineID: &nb=
sp; 1<BR>Latest checkpoint's NextXID: &n=
bsp; 32782967 <BR>Latest checkpoint's NextOID: =
; 2499839<BR>Latest checkpo=
int's NextMultiXactId: 972<BR>Latest checkpoint's NextMultiOffset:&nb=
sp; 2099<BR>Time of latest checkpoint: &=
nbsp; Mon 20 Nov 2006 12:53:56 PM PST<BR>Maximum da=
ta alignment: &n=
bsp; 4 <BR>Database block
size: &nb=
sp; 8192<BR>Blocks per segment of large relat=
ion: 131072<BR>Bytes per WAL segment: &n=
bsp; 16777216<BR>Maximum le=
ngth of identifiers: 64<BR>Maximu=
m columns in an index: =
; 32 <BR>Date/time type storage: &=
nbsp; floating-point numbers<BR>Maximum=
length of locale name: 128<BR>LC=
_COLLATE: =
&n=
bsp;
en_US.UTF-8<BR>LC_CTYPE: &n=
bsp; =
; en_US.UTF-8<BR><BR><BR>I tried=
running <SPAN style=3D"FONT-WEIGHT: bold">pg_resetxlog</SPAN> everything g=
ot lost, so restoring the copied <SPAN style=3D"FONT-WEIGHT: bold">database=
</SPAN> folder<BR><BR>I got pointers to looking at <SPAN style=3D"FONT-WEIG=
HT: bold">pg_filedump</SPAN> and I could not find out how to specify option=
s to filedump<BR>Please help me out<BR>my data bases is like 1gigabyte, pan=
icking<BR>thanks<BR></DIV>=0A<DIV> </DIV>Anil</DIV></DIV></DIV></div><=
br>=0A=0A<font color=3D"666666"><font size=3D"2"><hr size=3D1>Sponsored Lin=
k</font></font><br><br>=0A<a href=3D"http://forms.nextag.com/goto.jsp?url=
=3D/serv/main/buyer/education.jsp?doSearch=3Dn&tm=3Dy&search =3Db_deg_emp_pe=
ople&s=3D4016&p=3D5036">Degrees for employed people - in as fast as 1 year.=
A.S. / Bachelors / Masters</a></body></html>
--0-1612159056-1164155382=:44204--
