Re: postgres database crashed - Mailing list pgsql-hackers

From Ashish Goel
Subject Re: postgres database crashed
Date
Msg-id 20061014071407.17349.qmail@web58114.mail.re3.yahoo.com
Whole thread Raw
In response to postgres database crashed  (Ashish Goel <postgres_help@yahoo.com>)
Responses Re: postgres database crashed  (Markus Schaber <schabi@logix-tt.com>)
List pgsql-hackers
But the same code worked when I inserted around 2500 images in the database. After that it started crashing. So , I don't think it's because of error in the code. Can u suggest some other possible reasons and also why is it crashing at call to memcpy().





Tom Lane <tgl@sss.pgh.pa.us> wrote:
Ashish Goel writes:
> We have a following table xyz( id int , fname varchar(50), img image)
> where image is a data type we have created similar to lo.
> ...
> Can somebody suggest us what might be the cause of error and what can we do to resolve it ?

Incorrect code in your custom datatype, almost certainly. Check
computations of memory size allocations, for example. Test it in
a backend compiled with --enable-cassert.

regards, tom lane


All-new Yahoo! Mail - Fire up a more powerful email and get things done faster.


Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail.

pgsql-hackers by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Postgresql Caching
Next
From: "Raja Agrawal"
Date:
Subject: Asynchronous I/O Support