Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


MariaDB 10.1.15 regression / issues - Downgrade to 10.1.14 asap
New on LowEndTalk? Please Register and read our Community Rules.

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

leapswitchleapswitch Patron Provider, Veteran

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

  • ktkt Member, Host Rep
    edited July 2016

    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.

  • ardaarda Member

    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 my sources.list file, updated, added and re-updated and the issue was gone for me.

  • raindog308raindog308 Administrator, Veteran

    arda said: and the issue was gone for me

    However, you're still running Ubuntu.

    image

    Thanked by 1netomx
  • shovenoseshovenose Member, Host Rep

    @kt said:
    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.

    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.

  • ardaarda Member
    edited July 2016

    @raindog308 said:

    arda said: and the issue was gone for me

    However, you're still running Ubuntu.

    http://i.giphy.com/u5kEMRnol8SMU.gif

    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?

  • raindog308raindog308 Administrator, Veteran

    arda said: 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.

    Thanked by 1arda
  • ardaarda Member

    @raindog308 said:

    arda said: 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!

  • raindog308raindog308 Administrator, Veteran

    shovenose said: mariadb 10.1 is a huge improvement in performance and a large reduction in ram usage.

    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.

  • MikePTMikePT Moderator, Patron Provider, Veteran

    Would be interesting to spin up a VM and investigate this further...

Sign In or Register to comment.