Not the answer you need?
Register and ask your own question!

MySQL failed to handshake due to LOCK_thread_cache not released

windy.jianwindy.jian ContributorInactive User Role Contributor
I'm not sure whether it's ok or not, if I post my help wanted here. It seems that i encounter a bug-like issue. Percona-server 5.7.24-27

https://dba.stackexchange.com/questions/234769/mysql-failed-to-handshake-due-to-lock-thread-cache-not-released

Comments

  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    Just looking at this and will feedback on the best course of action...
  • windy.jianwindy.jian Contributor Inactive User Role Contributor
    Most people only focus on " too many connections", and lose attentions to other important things. I really don't know how to emphasize the key things which make them believe it's abnormal issue other than "too many connections".
  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    This is most likely to be to do with known issues, good news is that it is likely to have been fixed in 5.7.25-28 which has been released.

    Here is a release document: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-25.html

    The two related bugs are https://bugs.mysql.com/bug.php?id=91941 and https://bugs.mysql.com/bug.php?id=92108

    If you are able to provide sample output from running this https://www.percona.com/doc/percona-toolkit/LATEST/pt-pmp.html I can maybe get someone in the team to confirm this
  • windy.jianwindy.jian Contributor Inactive User Role Contributor
    It's wonderful, thanks for your answer. I don't know describe the issue, so i failed to search the bug in the release notes.
    pt-pmp is a wonderfull tool. Many thanks.
  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    You're very welcome... totally understand that's it's not always easy to get the right search terms BUT we are always here to help.
    Feel free to use the Forum anytime... finding you on Stack Overflow can be a bit hit and miss though in fact I did see your question there and will go and answer it now :)
    Thanks for the feedback :)
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.