[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