[Babase] Queries that run forever
Tyler Brock
tjb13 at duke.edu
Sat Apr 7 17:10:37 EDT 2007
Lacey,
Thank you so much. We figured the problem out so hopefully there won't be any more issues when running that query. I really appreciate the offer and maybe I can come by this week.
-Tyler
-----Original Message-----
From: Lacey Maryott <lacey.maryott at duke.edu>
Date: Wed, 04 Apr 2007 09:04:25
To:The Baboon Database Project <babase at eeblistserv.princeton.edu>
Subject: Re: [Babase] Queries that run forever
Tyler,
I'm not sure what your schedule is like, but if you did want me to
show you how to Kill stuff in ppa, i have the password and I can run you
through it really quickly. I'm in Susan's lab. I will be here today
until 630, tomorrow 8-6 and friday until noon. Just let me know!
Lacey
Tyler Brock wrote:
> awesome, I'll make the changes you suggested and see what happens, can
> you let me know what your up to and if you change things / when i
> should try again.
>
> -Tyler
>
> On Apr 4, 2007, at 1:03 AM, Karl O. Pinc wrote:
>
>> Ah,
>>
>> I think I see the problem.
>>
>> I may have reloaded/changed the triggers/validation
>> in babase_copy but not changed the structure of the
>> groups table. (We went through a change in the
>> GROUPS.Permanent column a ways back.) The datatype
>> changed. This probably borked the triggers and
>> they run forever.
>>
>> Let me see about fixing this.....
>>
>> (FYI, sometimes the optimiser does not work so well
>> when the datatypes don't match up. That's a reason
>> to _not_ put numbers in quotes (unless they're going
>> into a text column -- which is why I tell people
>> to always put stuff in quotes so they don't have to think
>> about it.))
>>
>> 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
>
>
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
>
--
Lacey Maryott
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu
_______________________________________________
Babase mailing list
Babase at www.eco.princeton.edu
http://www.eco.princeton.edu/mailman/listinfo/babase
More information about the Babase
mailing list