Comment 3 for bug 1203050

Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

OK, I was able to reproduce this. Last messages from the error log in my case:

...
2013-07-21 11:10:56 1468 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.12-rc60.4' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Percona Server (GPL), Release 60.4
2013-07-22 16:02:56 1468 [ERROR] /usr/sbin/mysqld: Sort aborted: Query execution was interrupted
2013-07-22 16:05:15 1468 [ERROR] /usr/sbin/mysqld: Sort aborted: Query execution was interrupted
2013-07-22 16:05:15 1468 [Warning] Sort aborted, host: localhost, user: root, thread: 45, query: create temporary table tt select t1.user from mysql.user t1, mysql.user t2, mysql.user t3, mysql.user t4, mysql.user t5, mysql.user t6, mysql.user t7, mysql.user t8, mysql.user t9 order by 1 desc
2013-07-22 16:06:31 1468 [ERROR] /usr/sbin/mysqld: Sort aborted: Query execution was interrupted
2013-07-22 16:06:31 1468 [Warning] Sort aborted, host: localhost, user: root, thread: 46, query: create temporary table tt select t1.user from mysql.user t1, mysql.user t2, mysql.user t3, mysql.user t4, mysql.user t5, mysql.user t6, mysql.user t7, mysql.user t8, mysql.user t9 order by 1 desc
2013-07-22 16:07:24 1468 [ERROR] /usr/sbin/mysqld: Sort aborted: Server shutdown in progress
2013-07-22 16:07:24 1468 [Warning] Sort aborted, host: localhost, user: root, thread: 47, query: create temporary table tt select t1.user from mysql.user t1, mysql.user t2, mysql.user t3, mysql.user t4, mysql.user t5, mysql.user t6, mysql.user t7, mysql.user t8, mysql.user t9 order by 1 desc

See last message, it says about shutdown in progress. It happens when I run KILL <session_id> instead of KILL QUERY <session id>.

This is a actually a duplicate of upstream bug I've verified years ago: http://bugs.mysql.com/bug.php?id=18256.