Re: [HACKERS] postgres database crashed

2006-10-17 Thread Tom Lane
Markus Schaber <[EMAIL PROTECTED]> writes: > Ashish Goel wrote: >> The code works well if we don't maintain the referrences but when we >> include the referrences then the database crashes somewhere between >> 2500-3000 transactions. >> >> So could this problem be due to the multiple referrences be

Re: [HACKERS] postgres database crashed

2006-10-17 Thread Markus Schaber
Hi, Ashish, Ashish Goel wrote: > I am sorry but I forgot to mention that in the database schema we are > maintaining referrences to the main table xyz(int id, img image, fname > varhcar(50)) > > There are around 14 tables referrencing this table . The referrences are > being made to the column i

Re: [HACKERS] postgres database crashed

2006-10-16 Thread Ashish Goel
Hi all,I am sorry but I forgot to mention that in the database schema we are maintaining referrences to the main table xyz(int id, img image, fname varhcar(50))There are around 14 tables referrencing this table . The referrences are being made to the column id.The code works well if we don't mainta

Re: [HACKERS] postgres database crashed

2006-10-16 Thread Markus Schaber
Hi, Ashish, Ashish Goel wrote: > But the same code worked when I inserted around 2500 images in the > database. After that it started crashing. Testing can never prove that there are no bugs. It's like the proof that all odd numbers above 1 are prime: 3 is prime, 5 is prime, 7 is prime, so I co

Re: [HACKERS] postgres database crashed

2006-10-15 Thread Ashish Goel
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 <[EMAIL PROTECTED]> wrote: Ashish Goe

Re: [HACKERS] postgres database crashed

2006-10-15 Thread Andrew Dunstan
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.

Re: [HACKERS] postgres database crashed

2006-10-15 Thread Ashish Goel
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 ,

Re: [HACKERS] postgres database crashed

2006-10-11 Thread Tom Lane
Ashish Goel <[EMAIL PROTECTED]> 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