[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