Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

w2ksp4.exe, WwwxxXdbf, procmail "FROM_MAILER" patch, Use of assignment to $[ is deprecated at /usr/local/sbin/apxs line 86. , wwwxxx vim, mysql closing table and opening table, 800c5000, setgid operation not permitted, pciehp: acpi_pciehprm on IBM, WWWXXX.DBF

Links

XODOX
Impressum

#1: production error

Posted on 2008-01-28 18:21:34 by Mark Steben

This is a multi-part message in MIME format.

------=_NextPart_000_0070_01C861A8.52975AB0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi folks, getting this error in production:



unexpected chunk number 0 (expected 1) for toast value 34761



Any ideas on how to approach this?



Two of the tables in the query have toast tables, one does not.



Thanks,



Mark Steben

Senior Database Administrator
@utoRevenueT
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee, MA 01238
413-243-4800 Home Office
413-243-4809 Corporate Fax

msteben <blocked::mailto:name@autorevenue.com> @autorevenue.com

Visit our new website at
<blocked::http://www.autorevenue.com/> www.autorevenue.com



IMPORTANT: The information contained in this e-mail message is confidential
and is intended only for the named addressee(s). If the reader of this
e-mail message is not the intended recipient (or the individual responsible
for the delivery of this e-mail message to the intended recipient), please
be advised that any re-use, dissemination, distribution or copying of this
e-mail message is prohibited. If you have received this e-mail message in
error, please reply to the sender that you have received this e-mail message
in error and then delete it. Thank you.

Come Visit Us at NADA! Booth #5735N
February 9th - February 12th
Moscone Center in San Francisco, CA




------=_NextPart_000_0070_01C861A8.52975AB0
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=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PostalCode"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"State"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"City"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"Street"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"address"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Times New Roman";
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>Hi folks, getting this error in =
production:<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>unexpected chunk number 0 (expected 1) for toast value =
34761<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>Any ideas on how to approach this?<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>Two of the tables in the query have toast tables, one does =
not.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>Thanks,<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p class=3DMsoNormal><font size=3D4 face=3D"Times New Roman"><span =
style=3D'font-size:
13.5pt'>Mark Steben</span></font><o:p></o:p></p>

<p class=3DMsoNormal><font size=3D4 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:13.5pt;color:black'>Senior Database Administrator<br>
</span></font><font size=3D5 color=3Dmaroon><span =
style=3D'font-size:18.0pt;
color:maroon'>@utoRevenue&#8482;</span></font><font size=3D4 =
color=3Dmaroon><span
style=3D'font-size:15.0pt;color:maroon'> <br>
</span></font><font size=3D1><span style=3D'font-size:9.0pt'>A Dominion =
Enterprises
Company<br>
</span></font><font size=3D4><span style=3D'font-size:13.5pt'>480 =
Pleasant Street<br>
<st1:address w:st=3D"on"><st1:Street w:st=3D"on">Suite</st1:Street> =
B200</st1:address><br>
<st1:place w:st=3D"on"><st1:City w:st=3D"on">Lee</st1:City>, <st1:State =
w:st=3D"on">MA</st1:State>
<st1:PostalCode w:st=3D"on">01238</st1:PostalCode></st1:place><br>
413-243-4800&nbsp;Home&nbsp;Office&nbsp;<br>
413-243-4809 Corporate Fax</span></font><o:p></o:p></p>

<div>

<p class=3DMsoNormal><font size=3D4 face=3D"Times New Roman"><span =
style=3D'font-size:
13.5pt'>msteben</span></font><font size=3D2><span =
style=3D'font-size:10.5pt'><a
href=3D"blocked::mailto:name@autorevenue.com"
title=3D"blocked::mailto:name@autorevenue.com"><font size=3D4 =
color=3Dblack
title=3D"blocked::mailto:name@autorevenue.com"><span =
style=3D'font-size:13.5pt;
color:black'><span =
title=3D"blocked::mailto:name@autorevenue.com">@autorevenue. com</span></f=
ont></a></span><br>
<br>
</span></font><font size=3D4><span style=3D'font-size:13.5pt'>Visit our =
new website
at <br>
</span></font><font size=3D2><span style=3D'font-size:10.5pt'><a
href=3D"blocked::http://www.autorevenue.com/"
title=3D"blocked::http://www.autorevenue.com/"><font size=3D4 =
color=3Dmaroon
title=3D"blocked::http://www.autorevenue.com/"><span =
style=3D'font-size:13.5pt;
color:maroon'>www.autorevenue.com</span></font></a></span></font><o:p></o=
:p></p>

</div>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D2 color=3Dmaroon face=3D"Times New =
Roman"><span
style=3D'font-size:10.0pt;color:maroon'>IMPORTANT: The information =
contained in
this e-mail message is confidential and is intended only for the named
addressee(s). If the reader of this e-mail message is not the intended
recipient (or the individual responsible for the delivery of this e-mail
message to the intended recipient), please be advised that any re-use,
dissemination, distribution or copying of this e-mail message is =
prohibited.
&nbsp;If you have received this e-mail message in error, please reply to =
the
sender that you have received this e-mail message in error and then =
delete it.
&nbsp;Thank you.<o:p></o:p></span></font></p>

<div>

<p class=3DMsoNormal><font size=3D5 color=3Dmaroon face=3D"Times New =
Roman"><span
style=3D'font-size:18.0pt;color:maroon'>Come Visit Us at NADA! =
&nbsp;Booth #5735N
<br>
February 9th - February 12th <br>
Moscone Center in <st1:place w:st=3D"on"><st1:City w:st=3D"on">San =
Francisco</st1:City>,
<st1:State w:st=3D"on">CA</st1:State></st1:place> </span></font><font =
size=3D2
color=3Dmaroon><span =
style=3D'font-size:10.0pt;color:maroon'><o:p></o:p></span></font></p>

</div>

</div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

</div>

</body>

</html>

------=_NextPart_000_0070_01C861A8.52975AB0--

Report this message

#2: Re: production error

Posted on 2008-01-28 21:43:36 by Tom Lane

"Mark Steben" <msteben@autorevenue.com> writes:
> Hi folks, getting this error in production:
> unexpected chunk number 0 (expected 1) for toast value 34761

What PG version is that?

It looks like it might be an index-corruption issue, in which case
reindexing the toast table might help.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Report this message