Re: postgres database crashed

From: Ashish Goel <postgres_help(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: postgres database crashed
Date: 2006-10-14 07:14:07
Message-ID: 20061014071407.17349.qmail@web58114.mail.re3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Kellerer 2006-10-14 07:31:36 Re: more anti-postgresql FUD
Previous Message NikhilS 2006-10-14 06:02:10 Re: Additional stats for Relations