[Babase] Queries that run forever

Lacey Maryott lacey.maryott at duke.edu
Wed Apr 4 09:04:25 EDT 2007


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 



More information about the Babase mailing list