All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
MariaDB 10.1.15 regression / issues - Downgrade to 10.1.14 asap
Symptoms -
cPanel auto updates to 10.1.15
You start seeing errors like -
2016-07-05 23:54:23 140077783045888 [Warning] InnoDB: Setting thread 17043 nice to 0 failed, current nice 12, errno 13
2016-07-05 23:54:23 140077703358208 [Warning] InnoDB: Setting thread 17049 nice to 0 failed, current nice 12, errno 13
2016-07-05 23:54:23 140077772556032 [Warning] InnoDB: Setting thread 17044 nice to 0 failed, current nice 12, errno 13
or
Thread pointer: 0x0x7faf306bd008
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...
stack_bottom = 0x7faf299fd140 thread_stack 0x48400
/usr/sbin/mysqld(my_print_stacktrace+0x2b)[0x7fafa25b341b]
/usr/sbin/mysqld(handle_fatal_signal+0x475)[0x7fafa210f9f5]
/lib64/libpthread.so.0(+0xf7e0)[0x7fafa17147e0]
/usr/sbin/mysqld(_ZN10SQL_SELECT17test_quick_selectEP3THD6BitmapILj64EEyybbb+0x1fe5)[0x7fafa21fb535]
mysys/stacktrace.c:247(my_print_stacktrace)[0x7fafa1fdfb90]
sql/opt_range.cc:12843(get_sel_arg_for_keypart)[0x7fafa1feee9e]
sql/sql_select.cc:21082(test_if_skip_sort_order)[0x7fafa1feffe0]
sql/sql_select.cc:3437(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x7fafa1ff013d]
sql/sql_select.cc:384(handle_select(THD*, LEX*, select_result*, unsigned long))[0x7fafa1ff3add]
/usr/sbin/mysqld(+0x451d52)[0x7fafa1f95d52]
sql/sql_parse.cc:5895(execute_sqlcom_select)[0x7fafa1fa200f]
sql/sql_parse.cc:7314(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x7fafa1fa554d]
sql/sql_parse.cc:1486(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x7fafa1fa81ab]
sql/sql_parse.cc:1109(do_command(THD*))[0x7fafa1fa875b]
sql/sql_connect.cc:1350(do_handle_one_connection(THD*))[0x7fafa20646ef]
sql/sql_connect.cc:1264(handle_one_connection)[0x7fafa2064847]
/lib64/libpthread.so.0(+0x7aa1)[0x7fafa170caa1]
/lib64/libc.so.6(clone+0x6d)[0x7faf9fbf1aad]
MariaDB bug report -
https://jira.mariadb.org/browse/MDEV-10333
cPanel solution -
This issue actually occurred from an update upgrading MariaDB from version
10.1.14 to 10.1.15. MariaDB currently has an open case regarding this
problem, and for now the workaround is to downgrade back to 10.1.14.
>
I filed a case the other day for our developers as well - case CPANEL-7340.
>
Please also refer to the MariaDB links for further details:
>
>
>
I was able to test out reverting back to 10.1.14 on my test server which
you can follow as well should you choose to downgrade:
>
rpm -e --nodeps --justdb MariaDB-server
rpm -e --nodeps --justdb MariaDB-client
rpm -e --nodeps --justdb MariaDB-shared
rpm -e --nodeps --justdb MariaDB-common
rpm -e --nodeps --justdb MariaDB-devel
>
You'll also need to ensure that the proper MariaDB101.repo is setup in
/etc/yum.repos.d/ as well as the version matching in
/var/cpanel/cpanel.config:
>
root@cpgeoff [/etc/yum.repos.d]# grep -i mysql /var/cpanel/cpanel.config
mysql-host=localhost
mysql-version=10.1
>
Once this is done you can use WHM to run the installer to install MariaDB
10.1 which will reinstall the 10.1.14 version since .15 was pulled.
Comments
cPanel recommends MariaDB 10.0 over 10.1 which I assume is not affected and would assume most people are hopefully using 10.0 for those using cPanel.
And this was the reason with all my 404 errors at
apt-get upgrade
command for mariadb packages at Ubuntu from their official repository. I simply commented out the repository line from mysources.list
file, updated, added and re-updated and the issue was gone for me.However, you're still running Ubuntu.
Haven't had any issues with 10.1 - and while I haven't directly compared 10.0 to 10.1, I can confirm that myself -> mariadb 10.1 is a huge improvement in performance and a large reduction in ram usage.
I'd switch to Debian on the day they brought PPA support. Also I used to run CentOS, was tired of weird structure of it and the need to compile stuff, never got used to it. Also it's been quite stable for me with LEMP stack over years (I only install LTS editions by the way), what's wrong with it if it's running fine?
https://www.lowendtalk.com/discussion/85905/canonical-attempting-to-bill-ovh-for-use-of-the-ubuntu-trademark
I just finished removing Ubuntu from my life last week.
Aha, didn't hear about this at all, thanks for the heads-up!
From what I've heard, the amount of non-Oracle engineering in 10.1 is much greater than in previous Maria releases, so this should be interesting.
Would be interesting to spin up a VM and investigate this further...