Percona Server moved to https://jira.percona.com/projects/PS

  1. Bug #1040735
  2. Comment #27

Comment 27 for bug 1040735

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

Based on metadata lock in the attached processlist and

" Sessions could end up deadlocked when executing a combination of SELECT, DROP TABLE, KILL, and SHOW ENGINE INNODB STATUS. (Bug #60682, Bug #12636001)"

as per http://dev.mysql.com/doc/refman/5.5/en/news-5-5-27.html

I tested with http://bugs.mysql.com/file.php?id=17153 attached here http://bugs.mysql.com/bug.php?id=60682 and normal queries to sbtest table.

I am getting a similar trace.

The server also hard locks, so after killing both, the server doesn't shutdown normally and SIGKILL is required.

I also noticed like

""
120829 2:05:24 [ERROR] /usr/sbin/mysqld: Sort aborted: Server shutdown in progress
120829 2:05:25 [ERROR] /usr/sbin/mysqld: Sort aborted: Server shutdown in progress
120829 2:05:25 [ERROR] /usr/sbin/mysqld: Sort aborted: Server shutdown in progress

"""
in the error log.