[Babase] Queries that run forever

Karl O. Pinc kop at meme.com
Wed Apr 4 01:08:42 EDT 2007


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



More information about the Babase mailing list