This is a multi-part message in MIME format.
------=_NextPart_000_0019_01CA4E50.F2CB7250
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi,
We are running with postgres sql 7.3.2. We were trying to create an
index on a big table. The create index command ran for nearly 5 hours at
which point we decided to interrupt it. Since this was interrupted, any
operations attempted on the table on which the index was being created
gives following error in pgsql log:
LOG: all server processes terminated; reinitializing shared memory and
semaphor
es
LOG: database system was interrupted at 2009-10-16 10:44:54 BST
LOG: checkpoint record is at 150/71A0C0CC
LOG: redo record is at 150/71A0C0CC; undo record is at 0/0; shutdown
TRUE
LOG: next transaction id: 1757299460; next oid: 43508941
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: ReadRecord: record with zero length at 150/71A0C10C
LOG: redo is not required
LOG: database system is ready
Any idea what this means and what we need to do to resolve access to
this table again? We can see the next oid number increases over time.
Access to all other tables in the database is fine. Any help would be
greatly appreciated.
Many Thanks
Neha.
------=_NextPart_000_0019_01CA4E50.F2CB7250
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:filelist.xml [at] 01CA4E50.EECA3560">
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"time"/>
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
span.EmailStyle17
{mso-style-type:personal-compose;
mso-style-noshow:yes;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:black;
font-weight:normal;
font-style:normal;
text-decoration:none;
text-underline:none;
text-decoration:none;
text-line-through:none;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
[at] page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;
mso-header-margin:35.4pt;
mso-footer-margin:35.4pt;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple =
style=3D'tab-interval:36.0pt'>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'>Hi,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>=
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'>We are running with postgres sql =
7.3.2. We
were trying to create an index on a big table. The create index command =
ran for
nearly 5 hours at which point we decided to interrupt it. Since this was =
interrupted,
any <span class=3DGramE>operations</span> attempted on the table on =
which the index
was being created gives following error in pgsql =
log:<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>=
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'>LOG:<span =
style=3D'mso-spacerun:yes'>
</span>all server processes terminated; reinitializing shared memory and
semaphor<o:p></o:p></span></font></p>
<p class=3DMsoNormal><span class=3DGramE><font size=3D2 color=3Dblack =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:black'>es</span></font>=
</span><font
size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:black'><span
style=3D'mso-spacerun:yes'> &nbs=
p; =
; =
&=
nbsp; &n=
bsp; &nb=
sp;
</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'>LOG:<span =
style=3D'mso-spacerun:yes'>
</span>database system was interrupted at 2009-10-16 =
</span></font><st1:time
Hour=3D"10" Minute=3D"44"><font size=3D2 color=3Dblack =
face=3DArial><span
=
style=3D'font-size:10.0pt;font-family:Arial;color:black'>10: 44:54</span><=
/font></st1:time><font
size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:black'> BST<span
style=3D'mso-spacerun:yes'> &nbs=
p;
</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'>LOG:<span =
style=3D'mso-spacerun:yes'>
</span>checkpoint record is at 150/71A0C0CC<span
style=3D'mso-spacerun:yes'> &nbs=
p; =
; =
</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'>LOG:<span =
style=3D'mso-spacerun:yes'>
</span>redo record is at 150/71A0C0CC; undo record is at 0/0; shutdown
TRUE<span style=3D'mso-spacerun:yes'> =
</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'>LOG:<span =
style=3D'mso-spacerun:yes'>
</span>next transaction id: 1757299460; next oid: 43508941<span
style=3D'mso-spacerun:yes'> &nbs=
p; =
;
</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'>LOG:<span =
style=3D'mso-spacerun:yes'>
</span>database system was not properly shut down; automatic recovery in
progress<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'>LOG:<span =
style=3D'mso-spacerun:yes'>
</span>ReadRecord: record with zero length at 150/71A0C10C<span
style=3D'mso-spacerun:yes'> &nbs=
p; =
;
</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'>LOG:<span =
style=3D'mso-spacerun:yes'>
</span>redo is not required<span
style=3D'mso-spacerun:yes'> &nbs=
p; =
; =
&=
nbsp;
</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'>LOG:<span =
style=3D'mso-spacerun:yes'>
</span>database system is ready<span
style=3D'mso-spacerun:yes'> =
</span><span
style=3D'mso-spacerun:yes'> &nbs=
p; =
; =
</span><o:p><=
/o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>=
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'>Any idea what this means and what =
we need
to do to resolve access to this table again? We can see the next oid =
number increases
over time. Access to all other tables in the database is fine. Any help =
would
be greatly appreciated. <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>=
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'>Many =
Thanks<o:p></o:p></span></font></p>
<p class=3DMsoNormal><strong><b =
style=3D'mso-ansi-font-weight:normal'><font size=3D3
color=3Dblack face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:black;
font-weight:normal;mso-bidi-font-weight:bold;mso-no-proof:ye s'>Neha.</spa=
n></font></b></strong><o:p></o:p></p>
</div>
</body>
</html>
------=_NextPart_000_0019_01CA4E50.F2CB7250--
