[Babase] Queries that run forever

Tyler Brock tjb13 at duke.edu
Wed Apr 4 03:37:11 EDT 2007


Now it fails to work again using babase_test... example:

babase_test=> SELECT * FROM ranks where sname = 'BIN' AND rnkdate =  
'1984-1-01' AND grp = 3.0 AND rnktype = 'ALL';
rnkid | sname | rnkdate | grp | rnktype | rank
-------+-------+---------+-----+---------+------
(0 rows)

babase_test=> INSERT INTO ranks (sname, rnkdate, grp, rnktype, rank)  
VALUES ('BIN', '1984-1-01', 3.0, 'ALL', 1);
Cancel request sent
ERROR:  canceling statement due to user request
babase_test=>

Maybe I'm messing something up?

On Apr 4, 2007, at 1:08 AM, Karl O. Pinc wrote:

> Tyler, Everybody,
>
> On 04/04/2007 12:03:19 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.
>
> Ok.  That's definately the problem.
>
> The right way to fix it is to recreate the babase_copy
> db and restore the data.  It's late right now and
> that takes a while.  So, let's cheat.
>
> For now why don't you use the babase_test
> database instead of the babase_copy database.
> I'll write the list when we next do a conversion
> and fixup both babase_test and babase_copy
> and you can go back to using babase_copy.
>
> I just tried the query in babase_test and
> everything works fine.  So we're good to
> go and you don't have a problem at all.
> (Unless this problem is hiding another.... ;-)
>
> Meanwhile Tabby and I are already messing up the
> babase_test database data so there's no reason
> you can't mess it up too.  We _probably_
> won't interfere with each other.
>
> 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