Hi Hassen, The patches had to be retrieved to patch mysql < 5.7.29, but since the upstream version containing the fix got packaged in Ubuntu there is no need to do so anymore.
Coming to your comment, you claim that the upstream patch didn't work for your. This could mean two things: 1. The upstream patch doesn't (completely) fix the problem. In this case we need to follow-up to the upstream bug and provide a case which shows that the problem didn't go away in version 5.7.30. 2. You are hitting a different problem with similar symptoms. In this case you should file a separate bug which then will worked at. What I'd like to ask you is to: 1. Paste the output of `dpkg -l | grep mysql`, so more eyes will check that all the package versions are right. 2. Carefully go through the scenario described in the upstream bug and make sure that's exactly the problem you are facing, and share your finding here. We'll then try to figure out what the best next steps are. I'm setting the status of this report to Incomplete for the moment. Please change it back to New after commenting back and we'll look at it again. Thanks! Thanks! ** Changed in: mysql-5.7 (Ubuntu) Status: Fix Released => Incomplete -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1831773 Title: High CPU usage, MySQL process got stuck on "SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' " To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/1831773/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs