Sebastien FLAESCH Query interruption with MySQL 5.7 using KILL QUERY in signal handler does no more work
Jul 03, 2016; 18:55
Sebastien FLAESCH
Query interruption with MySQL 5.7 using KILL QUERY in signal handler does no more work
Hi all,
I use the following technique to cancel a long running query:
In the SIGINT signal handler, I restart a connection and I perform a
KILL QUERY mysql-process-id-of-running-query
This was working find with MySQL 5.6.
But with 5.7 (5.7.11), we get now a different result:
A) The query is still interrupted, but we no longer get an SQL error -1317.
B) For some reason, the program does not want to exit() - (must investigate)
Any clues?
With mysql it's working fine:
mysql> select sleep(10); ^C^C -- query aborted +-----------+ | sleep(10) | +-----------+ +-----------+ 1 row in set (2.79 sec)
mysql> \q Bye
Thanks! Seb
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Jul 12
Sebastien FLAESCH Re: Query interruption with MySQL 5.7 using KILL QUERY in signal handler does no more work
Jul 12, 2016; 13:01
Sebastien FLAESCH
Re: Query interruption with MySQL 5.7 using KILL QUERY in signal handler does no more work
Jul 12
Sebastien FLAESCH Re: Query interruption with MySQL 5.7 using KILL QUERY in signal handler does no more work
Jul 12, 2016; 16:39
Sebastien FLAESCH
Re: Query interruption with MySQL 5.7 using KILL QUERY in signal handler does no more work
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!