[Babase] Karl.. SOS on server crashing

Lacey Maryott lacey.maryott at duke.edu
Wed May 9 09:38:53 EDT 2007


oh and ps... i know the sending signal failed thing isn't true... but it 
isn't canceling, so it seems it may be true this time?

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... :-\
>
> Let me know when you would like us to try running the query again 
> while you can be watching things :)
> thanks so much
> Lacey
>

-- 
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