[Babase] Queries that run forever

Karl O. Pinc kop at meme.com
Wed Apr 4 11:37:53 EDT 2007


On 04/04/2007 02:37:11 AM, Tyler Brock wrote:
> Now it fails to work again using babase_test... example:

> 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?

No, you found a bug in my code.  I fixed it.

If you tried to rank an individual in a group before that
group has a supergroup (before the group's Permanent date
when the group has no From_group) then there'd be an
infinite loop in the supergroup() function.
In other words, you were ranking an individual in a group
before the group actually existed as an indepedent
entity and the database had no information regarding
what group the group split from.  So in some sense the
group didn't actually exist because the system had
no way to check which groups the individual needed
to be censued in in order to be a member of the group.

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