Re: postgres database crashed

Поиск
Список
Период
Сортировка
От Ashish Goel
Тема Re: postgres database crashed
Дата
Msg-id 20061017064946.63247.qmail@web58113.mail.re3.yahoo.com
обсуждение исходный текст
Ответ на Re: postgres database crashed  (Markus Schaber <schabi@logix-tt.com>)
Ответы Re: postgres database crashed  (Markus Schaber <schabi@logix-tt.com>)
Список pgsql-hackers
Hi all,<br /><br />I am sorry but I forgot to mention that in the database schema we are maintaining referrences to the
maintable xyz(int id, img image, fname varhcar(50))<br /><br />There are around 14 tables referrencing this table . The
referrencesare being made to the column id.<br /><br />The code works well if we don't maintain the referrences but
whenwe include the referrences then the database crashes somewhere between 2500-3000 transactions.<br /><br />So could
thisproblem be due to the multiple referrences being made to the same table ?<br /><br /><b><i>Markus Schaber
<schabi@logix-tt.com></i></b>wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255);
margin-left:5px; padding-left: 5px;"> Hi, Ashish,<br /><br />Ashish Goel wrote:<br />> But the same code worked when
Iinserted around 2500 images in the<br />> database. After that it started crashing.<br /><br />Testing can never
provethat there are no bugs.<br /><br />It's like the proof that all odd numbers above 1 are prime:<br /><br />3 is
prime,5 is prime, 7 is prime, so I conclude that all odd numbers<br />above 1 are prime.<br /><br /><br /> So , I don't
thinkit's<br />> because of error in the code. Can u suggest some other possible reasons<br />> and also why is
itcrashing at call to memcpy().<br /><br />- broken hardware<br />- compiler bugs<br />- bugs in PostgreSQL<br /><br
/>Butwithout having seen your code, I tend to assume that it's something<br />like a wrong length flag in some corner
casein your code.<br />...<br /><br />Markus<br />-- <br />Markus Schaber | Logical Tracking&Tracing International
AG<br/>Dipl. Inf. | Software Development GIS<br /><br />Fight against software patents in Europe! www.ffii.org<br
/>www.nosoftwarepatents.org<br/><br /></blockquote><br /><p><hr size="1" />Get your own <a href="
http://us.rd.yahoo.com/evt=43290/*http://smallbusiness.yahoo.com/domains">webaddress for just $1.99/1st yr</a>. We'll
help.<a href="http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/">Yahoo! Small Business</a>.  

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Andrew Dunstan"
Дата:
Сообщение: Re: [Plperlng-devel] Data Persists Past Scope
Следующее
От: Markus Schaber
Дата:
Сообщение: Re: postgres database crashed