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

  1. Bug #1319904
  2. Comment #13

Comment 13 for bug 1319904

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote : Re: mysqld daemon with installed handlersocket plugin did not stop

The 5.5 and 5.6 issues are different.

For 5.5, the shutdown hang is caused by mysqld signal handler never having its initialisation completed if HS is installed. That happens because both HS and signal_hand wait for COND_server_started, which is signalled using mysql_cond_signal, meaning that only one waiter is woken up, which happens to be the HS one. The signal handler waiter does not have a time out.

This is a regression introduced in the upstream fix for http://bugs.mysql.com/bug.php?id=62311, backported to our 5.5 as bug 1249193. The upstream 5.6 later fixed the regression as

$ bzr log -r 4754.1.1
------------------------------------------------------------
revno: 4754.1.1
committer: <email address hidden>
branch nick: 5.6-bug16315379
timestamp: Tue 2013-02-12 11:17:24 +0100
message:
  Bug#16315379 COND_SERVER_STARTED MAY HAVE MULTIPLE WAITERS
   - Always use pthread_cond_broadcast when signalling COND_server_started since there
     may be more than one thread waiting for the condition.