Re: postgres database crashed - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: postgres database crashed
Date
Msg-id 1448.24.211.165.134.1160929811.squirrel@www.dunslane.net
Whole thread Raw
In response to Re: postgres database crashed  (Ashish Goel <postgres_help@yahoo.com>)
List pgsql-hackers

Did you follow Tom's suggestion of trying with a postgres configured with
--enable-cassert ?

cheers

andrew

Ashish Goel wrote:
> 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(). I have also checked the memory
> allocations , and i don't find problem there.
>
>
>
> 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.
>




pgsql-hackers by date:

Previous
From: Ashish Goel
Date:
Subject: Re: postgres database crashed
Next
From: mark@mark.mielke.cc
Date:
Subject: Re: Postgresql Caching