{"id":9276,"date":"2024-06-30T01:15:00","date_gmt":"2024-06-30T08:15:00","guid":{"rendered":"http:\/\/blog.networkpresence.co\/?p=9276"},"modified":"2024-07-08T03:21:28","modified_gmt":"2024-07-08T10:21:28","slug":"may-jun-2024-cpanel-mysql-upgraded-version-crash-bug","status":"publish","type":"post","link":"http:\/\/blog.networkpresence.co\/?p=9276","title":{"rendered":"May-Jun 2024 cPanel MySQL upgraded version crash bug"},"content":{"rendered":"\n

We’ve seen some customers with this issue, where after a reboot on a current version of cPanel, the MySQL server won’t start fully and keeps crashing with logs like:

<\/p>\n\n\n\n

2024-07-08T00:03:13Z UTC – mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=539914406f129270c6bd39a48640d0f1eeecc1af
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong\u2026
stack_bottom = 0 thread_stack 0x100000
\/usr\/sbin\/mysqld(my_print_stacktrace(unsigned char const, unsigned long)+0x41) [0x213f031] \/usr\/sbin\/mysqld(print_fatal_signal(int)+0x397) [0xffa557] \/usr\/sbin\/mysqld(handle_fatal_signal+0xa5) [0xffa615] \/lib64\/libpthread.so.0(+0x12d20) [0x7fee37433d20] \/usr\/sbin\/mysqld(Validate_files::check(__gnu_cxx::__normal_iterator > > const&, __gnu_cxx::__normal_iterator > > const&, unsigned long)+0x909) [0x218ddb9] \/usr\/sbin\/mysqld(std::thread::_State_impl > > const&, __gnu_cxx::__normal_iterator > > const&, unsigned long)>, __gnu_cxx::__normal_iterator const, std::vector, \/lib64\/libstdc++.so.6(+0xc2b23) [0x7fee361b4b23]
\/lib64\/libpthread.so.0(+0x81ca) [0x7fee374291ca]
\/lib64\/libc.so.6(clone+0x43) [0x7fee357bb8d3]
The manual page at http:\/\/dev.mysql.com\/doc\/mysql\/en\/crashing.html contains
information that should help you find out what is causing the crash.<\/em><\/p>\n\n\n\n

We’ve been in-touch with cPanel about this and here’s the solution\/fix:<\/p>\n\n\n\n

On a terminal session as root to your cPanel VPS, run:

yum downgrade mysql-community-*<\/p>\n\n\n\n

Then your MySQL server should restart and run ok.<\/p>\n\n\n\n

This is a known bug in this version of MySQL and cPanel recommend you lock your MySQL server version at this release for a while with commands like:<\/p>\n\n\n\n

dnf install python3-dnf-plugin-versionlock
yum versionlock mysql-community-*<\/p>\n\n\n\n

FYI,
Richard.<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

We’ve seen some customers with this issue, where after a reboot on a current version of cPanel, the MySQL server won’t start fully and keeps crashing with logs like: 2024-07-08T00:03:13Z UTC – mysqld got signal 11 ;Most likely, you have … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70],"tags":[],"class_list":["post-9276","post","type-post","status-publish","format-standard","hentry","category-sales"],"_links":{"self":[{"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=\/wp\/v2\/posts\/9276","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9276"}],"version-history":[{"count":1,"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=\/wp\/v2\/posts\/9276\/revisions"}],"predecessor-version":[{"id":9277,"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=\/wp\/v2\/posts\/9276\/revisions\/9277"}],"wp:attachment":[{"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9276"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}