{"id":3055,"date":"2024-07-01T02:29:23","date_gmt":"2024-06-30T20:59:23","guid":{"rendered":"https:\/\/www.nettigritty.com\/kb\/?p=3055"},"modified":"2024-07-01T10:11:58","modified_gmt":"2024-07-01T04:41:58","slug":"mysql-crashing-on-some-servers-after-upgrade-to-8-0-38","status":"publish","type":"post","link":"https:\/\/www.nettigritty.com\/kb\/cpanel\/mysql-crashing-on-some-servers-after-upgrade-to-8-0-38\/","title":{"rendered":"MySQL Crashing (on some servers) After Upgrade to 8.0.38"},"content":{"rendered":"<p>We have identified that MySQL crashed on some servers following the recent upgrade to version 8.0.38. Errors seen in logs:<\/p>\n<p><code>mysqld.service: Main process exited, code=killed, status=11\/SEGV<\/code><br \/>\n<code>Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.<\/code><\/p>\n<p>To mitigate this issue, please follow the steps below:<\/p>\n<ol>\n<li><strong>Rollback the Upgrade:<\/strong>\n<ul>\n<li>You can downgrade MySQL using the command<br \/>\n<code>yum downgrade mysql-community*<\/code><\/li>\n<\/ul>\n<p>&nbsp;<\/li>\n<li><strong>Version Lock MySQL 8.0.37:<\/strong>\n<ul>\n<li>Lock MySQL to version 8.0.37 until further updates in this regard from MySQL or cPanel.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>Here is the procedure to version lock:<\/p>\n<ol>\n<li>Install version lock:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"flex items-center relative text-token-text-secondary bg-token-main-surface-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md\"><code>dnf install python3-dnf-plugin-versionlock<\/code><\/div>\n<\/div>\n<\/li>\n<li>Lock the MySQL version:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"flex items-center relative text-token-text-secondary bg-token-main-surface-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md\"><code>yum versionlock mysql*<\/code><\/div>\n<\/div>\n<\/li>\n<\/ol>\n<p>For detailed instructions, please refer to the official guide: <a href=\"https:\/\/support.cpanel.net\/hc\/en-us\/articles\/1500013004522-How-to-version-lock-RPM-packages\" target=\"_new\" rel=\"noreferrer noopener\">How to version lock RPM packages<\/a>.<\/p>\n<p>cPanel has now published an official update on this issue<br \/>\n<a href=\"https:\/\/support.cpanel.net\/hc\/en-us\/articles\/24546938662039-Upstream-issue-MySQL-8-0-38-does-not-start-Segmentation-Fault\">https:\/\/support.cpanel.net\/hc\/en-us\/articles\/24546938662039-Upstream-issue-MySQL-8-0-38-does-not-start-Segmentation-Fault<\/a><\/p>\n<p><strong>Additional Notes:<\/strong><\/p>\n<ul>\n<li>To check mysql version on the server: <code>mysql -V<\/code><\/li>\n<li>In case sites have an issue even after the downgrade, you may need to rebuild Apache.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>We have identified that MySQL crashed on some servers following the recent upgrade to version 8.0.38. Errors seen in logs: mysqld.service: Main process exited, code=killed, status=11\/SEGV Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. To mitigate this issue, please follow the steps below: Rollback the Upgrade: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3055","post","type-post","status-publish","format-standard","hentry","category-cpanel"],"_links":{"self":[{"href":"https:\/\/www.nettigritty.com\/kb\/wp-json\/wp\/v2\/posts\/3055","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nettigritty.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nettigritty.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nettigritty.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nettigritty.com\/kb\/wp-json\/wp\/v2\/comments?post=3055"}],"version-history":[{"count":11,"href":"https:\/\/www.nettigritty.com\/kb\/wp-json\/wp\/v2\/posts\/3055\/revisions"}],"predecessor-version":[{"id":3067,"href":"https:\/\/www.nettigritty.com\/kb\/wp-json\/wp\/v2\/posts\/3055\/revisions\/3067"}],"wp:attachment":[{"href":"https:\/\/www.nettigritty.com\/kb\/wp-json\/wp\/v2\/media?parent=3055"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nettigritty.com\/kb\/wp-json\/wp\/v2\/categories?post=3055"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nettigritty.com\/kb\/wp-json\/wp\/v2\/tags?post=3055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}