[Babase] Queries that run forever

Tyler Brock tjb13 at duke.edu
Wed Apr 4 00:31:42 EDT 2007


Ok awesome! Also, this is the update query I was trying to run:

INSERT INTO ranks VALUES (nextval('ranks_rnkid_seq'::regclass),  
'PLA', '2003-1-01', '10.0', 'ALM', '1');

any idea why something like this would take forever, it should work...

-Tyler

On Apr 4, 2007, at 12:30 AM, Karl O. Pinc wrote:

>
> 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
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase


-Tyler

Tyler J. Brock
Duke University
6202 McQueen Dr.
Durham, NC 27705
(516)857-5208
tjb13 at duke.edu





More information about the Babase mailing list