[Babase] Queries that run forever

Karl O. Pinc kop at meme.com
Wed Apr 4 00:30:01 EDT 2007


On 04/03/2007 11:24:01 PM, Tyler Brock wrote:
> Ok, so I'm still trying to figure out why the following query runs  
> forever:
> 
> delete from rnktypes where rnktype = 'ADFFIX';
> 
> I thought it might be because it is referenced in ranks by some of  
> the sample stuff i created but then i ran a delete on all of those  
> rows to ensure it would not complain if adffix was deleted from  
> rnktypes. However this query still runs forever along with my other  
> update calls to the ranks table in the database which used to work  
> quickly. I have no idea why so I'm going to you guys for help again.

I'll take a look.  I probably have something going on in the delete
trigger.  I may not care that it takes a long time because it's
almost never that something's deleted from RNKTYPES.

> Karl, thank you for the advice last time but I still have no idea  
> what the password for the admin is so I am unable to start these  
> rouge processes that have been created. Sorry.

Lacey can help you out.

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