[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