Please help with this error message

From: "Chris Smith" <cdsmith(at)twu(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Please help with this error message
Date: 2003-03-26 15:18:06
Message-ID: 021701c2f3aa$e7a6bf90$6700000a@KYA
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I posted about this earlier and got no response, but now it's happening
again. Can someone please help?

We're getting the following error message from PostgreSQL 7.3.2:

ERROR: unexpected chunk number 1 (expected 0) for toast value 77579

This error occurs whenever I attempt to SELECT the contents of a bytea field
from this particular record. It has also occurred in the past, and appears
to happen somewhat randomly among records. It does not appear to be related
to the content of the data inserted into the database, because we've been
able to retrieve the same actual contents successfully in other records.

The INSERT and UPDATE to add the record and set the contents field work
fine.

Does anyone have any ideas on what I can try to solve this problem? I can
put in a number of retries, I suppose, but that seems pretty kludgy.

--
www.designacourse.com
The Easiest Way to Train Anyone... Anywhere.

Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-03-26 15:39:42 Re: transaction blocking inserts in postgresql 7.3
Previous Message Chris Smith 2003-03-26 15:16:24 Please help with this error message