search

andialbrecht / crunchyfrog

Head over to RunSQLRun, the successor of CrunchyFrog
http://runsqlrun.org
GNU General Public License v3.0
4 stars 2 forks source link

Slow MySQL queries cannot be stopped #6

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Create a never-ending loop:

CREATE FUNCTION doforever ()
RETURNS Boolean
BEGIN
    foreverloop: LOOP
        IF 1 THEN ITERATE foreverloop; END IF;
    END LOOP foreverloop;
RETURN true;
END;

2. Run the loop:

select doforever();

3. Try and stop the query

What is the expected output? What do you see instead?

The query should be killed.  What I saw was an unresponsive program

What version of the product are you using? On what operating system? Python
version?

I'm using version 0.2 on python 2.5.1

Original issue reported on code.google.com by awagne...@gmail.com on 17 Apr 2008 at 12:57

GoogleCodeExporter commented 9 years ago

Original comment by albrecht.andi on 17 Apr 2008 at 2:28

GoogleCodeExporter commented 9 years ago

Original comment by albrecht.andi on 17 Apr 2008 at 2:28

GoogleCodeExporter commented 9 years ago 
This issue needs some rewrite of the query code base to somehow "kill" blocking
queries which can't be done with join() here because it is a single function 
call
that blocks the threads activity.

Original comment by albrecht.andi on 29 Apr 2008 at 4:12

GoogleCodeExporter commented 9 years ago

Original comment by albrecht.andi on 9 Oct 2008 at 5:43

GoogleCodeExporter commented 9 years ago

Original comment by albrecht.andi on 16 Mar 2009 at 5:25