[Babase] Karl.. SOS on server crashing

Lacey Maryott lacey.maryott at duke.edu
Wed May 9 10:10:29 EDT 2007


Hey Karl,
   Marie is running a query, and patrick o is logged in as well as am i, 
running a simple query, so I guess we'll see what happens.  Marie's 
query has been "waiting" for about 3 min now.

Lacey

Karl O. Pinc wrote:
>
> On 05/09/2007 08:37:02 AM, Lacey Maryott wrote:
>> Hey Karl,
>>   So Marie just so happens to be the one crashing the server. Haha... 
>> we just tried running another query, and the whole server stopped... 
>> and i tried logging in on my system as babase_admin, to kill her 
>> process, and it is saying signal sending failed.  Let me know when 
>> you are awake and get this... so we can try to hunt down the problem.
>> Just fyi the query we are running is:
>>
>> select cycles.sname, cycles.cid, cycpoints.date,
>> cycpoints.code from cycles, cycpoints
>> where cycles.cid=cycpoints.cid;
>>
>> and the one she ran yesterday that crashed it was
>>
>> select biograph.sname, biograph.sex, biograph.birth,
>> biograph.bstatus, biograph.matgrp, census.status,
>> census.date, census.grp, maturedates.matured from
>> biograph, maturedates, census where
>> biograph.sname=census.sname and
>> biograph.sname=maturedates.sname;
>>
>> hope these help to bring some light, but overall they don't seem like 
>> incredibly complex queries... :-\
>
> There's 2 possibilities.  It's not really Marie at all, she
> just happens to be running something while somebody else is
> running something that crashes.  (There are defineately more
> than one query running when the crash happens, or at least
> more than one person using the system.)
>
> Or, it could be that the way I've got the memory configured
> causes a crash when "too many" people use the computer at
> once.
>
> Karl <kop at meme.com>
> Free Software:  "You don't pay back, you pay forward."
>                  -- Robert A. Heinlein
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
>

-- 
Lacey Maryott
Alberts Lab
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu 



More information about the Babase mailing list