Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 156A72E00A0 for ; Mon, 28 Jan 2008 13:22:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 96557-10 for ; Mon, 28 Jan 2008 13:22:00 -0400 (AST) Received: from mail.autorevenue.com (ip-208.178.167.106.gblx.net [208.178.167.106]) by postgresql.org (Postfix) with ESMTP id F1ADD2E0039 for ; Mon, 28 Jan 2008 13:21:57 -0400 (AST) Received: (qmail 20836 invoked from network); 28 Jan 2008 12:22:04 -0500 Received: from unknown (HELO dei26g028575) (msteben@10.10.1.20) by mail.autorevenue.com with SMTP; 28 Jan 2008 12:22:04 -0500 From: "Mark Steben" To: Subject: production error Date: Mon, 28 Jan 2008 12:21:34 -0500 Message-ID: <006f01c861d2$3b6d62b0$14010a0a@dei26g028575> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0070_01C861A8.52975AB0" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992 Thread-Index: Achh0jsjh3XtrdPLTxStCFe2/wHHOA== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/263 X-Sequence-Number: 28037 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 @autorevenue.com Visit our new website at 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

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
@utoRevenue™
A Dominion = Enterprises Company
480 = Pleasant Street
Suite = B200
Lee, MA 01238
413-243-4800 Home Office 
413-243-4809 Corporate Fax

msteben@autorevenue.com

Visit our = new website at
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--