[Babase] Karl.. SOS on server crashing

Karl O. Pinc kop at meme.com
Wed May 9 10:06:17 EDT 2007


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



More information about the Babase mailing list