Skip to main content

MariaDB upgrade fails

Comments

7 comments

  • cPanelMichael
    We expected to upgrade to 10.0; however, the system is currently on version 5.6. at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 839.

    Hello, Could you run the following commands and let us know the output?
    rpm -qa | grep -i mysql rpm -qa | grep -i mariadb grep mysql-version /var/cpanel/cpanel.config mysql --version cat /etc/redhat-release cat /var/cpanel/rpm.versions.d/local.versions
    Thank you.
    0
  • jndawson
    Hello, Could you run the following commands and let us know the output?
    rpm -qa | grep -i mysql rpm -qa | grep -i mariadb grep mysql-version /var/cpanel/cpanel.config mysql --version cat /etc/redhat-release cat /var/cpanel/rpm.versions.d/local.versions
    Thank you.

    Oops - should have included all that.
    [ root@cp5 ~># rpm -qa | grep -i mysql cpanel-perl-524-DBD-mysql-4.042-1.cp1162.x86_64 ea-php56-php-mysqlnd-5.6.31-2.2.2.cpanel.x86_64 ea-php70-php-mysqlnd-7.0.22-1.1.1.cpanel.x86_64 ea-php55-php-mysqlnd-5.5.38-23.23.2.cpanel.x86_64 cpanel-mysql-5.1.73-1.cp1156.x86_64 cpanel-perl-524-MySQL-Diff-0.50-1.cp1162.x86_64 cpanel-mysql-libs-5.1.73-1.cp1156.x86_64 compat-MySQL51-shared-5.1.73-1.cp1150.x86_64 ea-php71-php-mysqlnd-7.1.8-1.1.2.cpanel.x86_64 compat-MySQL50-shared-5.0.96-4.cp1136.x86_64 [ Thu Aug 17 10:12:18 ] [ root@cp5 ~># rpm -qa | grep -i mariadb MariaDB-devel-10.0.32-1.el7.centos.x86_64 cpanel-mariadb-native-client-1.0.1-6.cp1154.x86_64 cpanel-mariadb-native-client-devel-1.0.1-6.cp1154.x86_64 MariaDB-common-10.0.32-1.el7.centos.x86_64 MariaDB-server-10.0.32-1.el7.centos.x86_64 MariaDB-shared-10.0.32-1.el7.centos.x86_64 MariaDB-client-10.0.32-1.el7.centos.x86_64 [ Thu Aug 17 10:12:32 ] [ root@cp5 ~># grep mysql-version /var/cpanel/cpanel.config mysql-version=5.6 [ Thu Aug 17 10:12:41 ] [ root@cp5 ~># mysql --version mysql Ver 14.14 Distrib 5.6.37, for Linux (x86_64) using EditLine wrapper [ Thu Aug 17 10:12:49 ] [ root@cp5 ~># cat /etc/redhat-release CentOS Linux release 7.3.1611 (Core) [ Thu Aug 17 10:12:59 ] [ root@cp5 ~># cat /var/cpanel/rpm.versions.d/local.versions --- file_format: version: 2 target_settings: clamav: installed munin: installed perl522: uninstalled
    0
  • cPanelMichael
    Hello, You can remove the RPM target settings for MySQL 5.1 with the following command:
    /usr/local/cpanel/scripts/update_local_rpm_versions --del target_settings.MySQL51
    Then, manually update /var/cpanel/cpanel.config so that the mysql-version entry looks like this:
    mysql-version=10.0
    Once you do this, run the following command to have the check_cpanel_rpms script remove the MySQL 5.1 RPMs:
    /usr/local/cpanel/scripts/check_cpanel_rpms
    Let us know if this helps. Thank you.
    0
  • jndawson
    Tried your steps, then reran update to MariaDB 10.0 via whm. Failed again:
    Starting process with log file at /var/cpanel/logs/mysql_upgrade.20170817-104106/upgrade_mysql_with_status.log Obtained version information from system. Obtained version information from system. Ensuring the "MariaDB100" repository is available and working. checkyum version 22.3 Ensuring that the package "MariaDB-client" with version matching "10.0" is available. Ensuring that the package "MariaDB-common" with version matching "10.0" is available. Ensuring that the package "MariaDB-devel" with version matching "10.0" is available. Ensuring that the package "MariaDB-server" with version matching "10.0" is available. Ensuring that the package "MariaDB-shared" with version matching "10.0" is available. Ensuring that the package "coreutils" is available. Ensuring that the package "grep" is available. Ensuring that the package "perl-DBI" is available. Ensuring that the package "shadow-utils" is available. The "MariaDB100" repository is available and working. Installing pre-known MariaDB dependencies. Loaded plugins: fastestmirror, universal-hooks Loading mirror speeds from cached hostfile * EA4: 208.43.129.162 * cpanel-addons-production-feed: 208.43.129.162 * base: mirror.linuxfix.com * extras: mirrors.kernel.org * updates: mirror.sjc02.svwh.net Package coreutils-8.22-18.el7.x86_64 already installed and latest version Package perl-DBI-1.627-4.el7.x86_64 already installed and latest version Package grep-2.20-2.el7.x86_64 already installed and latest version Package 2:shadow-utils-4.1.5.1-24.el7.x86_64 already installed and latest version Nothing to do Installed pre-known MariaDB dependencies. Ensuring MariaDB RPMs for version "10.0". Verifying that the MariaDB packages can be installed by doing a test install. checkyum version 22.3 Loaded plugins: fastestmirror, universal-hooks Loading mirror speeds from cached hostfile * EA4: 208.43.129.162 * cpanel-addons-production-feed: 208.43.129.162 * base: mirror.linuxfix.com * extras: mirrors.kernel.org * updates: mirror.sjc02.svwh.net Package MariaDB-server-10.0.32-1.el7.centos.x86_64 already installed and latest version Package MariaDB-client-10.0.32-1.el7.centos.x86_64 already installed and latest version Package MariaDB-devel-10.0.32-1.el7.centos.x86_64 already installed and latest version Package MariaDB-shared-10.0.32-1.el7.centos.x86_64 already installed and latest version Package MariaDB-common-10.0.32-1.el7.centos.x86_64 already installed and latest version Nothing to do Preinstall check passed. Running: /usr/local/cpanel/scripts/check_cpanel_rpms --targets=MySQL41,MySQL50,MySQL51,MySQL55,MySQL56,MariaDB100,MariaDB101,MariaDB102 --fix Installing MariaDB from official repository. Hooks system enabled. Checking for and running RPM::Versions 'pre' hooks for any RPMs about to be installed All required 'pre' hooks have been run Removing incompatible packages. Loaded plugins: fastestmirror, universal-hooks Loading mirror speeds from cached hostfile * EA4: 208.43.129.162 * cpanel-addons-production-feed: 208.43.129.162 * base: mirror.linuxfix.com * extras: mirrors.kernel.org * updates: mirror.sjc02.svwh.net Package MariaDB-server-10.0.32-1.el7.centos.x86_64 already installed and latest version Package MariaDB-client-10.0.32-1.el7.centos.x86_64 already installed and latest version Package MariaDB-devel-10.0.32-1.el7.centos.x86_64 already installed and latest version Package MariaDB-shared-10.0.32-1.el7.centos.x86_64 already installed and latest version Package MariaDB-common-10.0.32-1.el7.centos.x86_64 already installed and latest version Nothing to do MariaDB installed from official repository. Building configuration. Running: /usr/local/cpanel/bin/build_mysql_conf Waiting for "mysql" to restart ""waiting for "mysql" to initialize "finished. Service Status mysql (/bin/sh /usr/bin/mysqld_safe) is running as mysql with PID 4457 (systemd+/proc check method). mysql (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=server.tld.err --open-files-limit=10000 --pid-file=cserver.tld.pid) is running as mysql with PID 4584 (systemd+/proc check method). Startup Log Aug 17 10:42:27 cp5.ipns.com systemd[1]: Started MySQL Server. Aug 17 10:42:27 cp5.ipns.com systemd[1]: Starting MySQL Server... Aug 17 10:42:27 cp5.ipns.com mysqld_safe[4457]: 170817 10:42:27 mysqld_safe Logging to '/var/lib/mysql/server.tld.err'. Aug 17 10:42:27 cp5.ipns.com mysqld_safe[4457]: 170817 10:42:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Log Messages 170817 10:42:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 170817 10:42:27 mysqld_safe Logging to '/var/lib/mysql/server.tld.err'. 170817 10:42:26 mysqld_safe mysqld from pid file /var/lib/mysql/server.tld.pid ended 2017-08-17 10:42:26 16509 [Note] /usr/sbin/mysqld: Shutdown complete 2017-08-17 10:42:25 16509 [Note] /usr/sbin/mysqld: Normal shutdown mysql restarted successfully. Looking for 'mysql' as: /usr/bin/mysql Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck This installation of MySQL is already upgraded to 5.6.37, use --force if you still need to run mysql_upgrade The 'mysql' service passed the check: mysql (/bin/sh /usr/bin/mysqld_safe) is running as mysql with PID 4457 (systemd+/proc check method). mysql (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=server.tld.err --open-files-limit=10000 --pid-file=server.tld.pid) is running as mysql with PID 4584 (systemd+/proc check method). The 'mysql' service passed the check: mysql (/bin/sh /usr/bin/mysqld_safe) is running as mysql with PID 4457 (systemd+/proc check method). mysql (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=server.tld.err --open-files-limit=10000 --pid-file=server.tld.pid) is running as mysql with PID 4584 (systemd+/proc check method). Done building configuration. Hooks system enabled. Checking for and running RPM::Versions 'post' hooks for any RPMs about to be installed All required 'post' hooks have been run Running: /usr/local/cpanel/scripts/check_cpanel_rpms --targets=MySQL41,MySQL50,MySQL51,MySQL55,MySQL56,MariaDB100,MariaDB101,MariaDB102 --fix Restarting mysql service. Waiting for "mysql" to restart ""waiting for "mysql" to initialize "finished. Service Status mysql (/bin/sh /usr/bin/mysqld_safe) is running as mysql with PID 4906 (systemd+/proc check method). mysql (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=server.tld.err --open-files-limit=10000 --pid-file=cp5.ipns.com.pid) is running as mysql with PID 5032 (systemd+/proc check method). Startup Log Aug 17 10:43:51 cp5.ipns.com systemd[1]: Started MySQL Server. Aug 17 10:43:51 cp5.ipns.com systemd[1]: Starting MySQL Server... Aug 17 10:43:52 cp5.ipns.com mysqld_safe[4906]: 170817 10:43:52 mysqld_safe Logging to '/var/lib/mysql/server.tld.err'. Aug 17 10:43:52 cp5.ipns.com mysqld_safe[4906]: 170817 10:43:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Log Messages 170817 10:43:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 170817 10:43:52 mysqld_safe Logging to '/var/lib/mysql/server.tld.err'. 170817 10:43:51 mysqld_safe mysqld from pid file /var/lib/mysql/server.tld.pid ended 2017-08-17 10:43:50 4584 [Note] /usr/sbin/mysqld: Shutdown complete 2017-08-17 10:43:49 4584 [Note] /usr/sbin/mysqld: Normal shutdown 2017-08-17 10:42:28 4584 [Note] /usr/sbin/mysqld: ready for connections. 170817 10:42:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 170817 10:42:27 mysqld_safe Logging to '/var/lib/mysql/server.tld.err'. 170817 10:42:26 mysqld_safe mysqld from pid file /var/lib/mysql/server.tld.pid ended 2017-08-17 10:42:26 16509 [Note] /usr/sbin/mysqld: Shutdown complete mysql restarted successfully. We expected to upgrade to 10.0; however, the system is currently on version 5.6. at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 839. Obtained version information from system. Upgrade was unsuccessful. Please review and correct any error messages displayed above.
    0
  • cPanelMichael
    Hello, Could you open a support ticket using the link in my signature so we can take a closer look? Thank you.
    0
  • jndawson
    Hello, Could you open a support ticket using the link in my signature so we can take a closer look? Thank you.

    Tkt: 8794447
    0
  • jndawson
    Issue corrected. The first tech confirmed we had a problem with the upgrade and suggested we should fix it. So then we got a real cPanel tech and he discovered the MariaDB package was somehow incomplete:
    The issue was with the MariaDB-server package: ======================== [15:14:30] [8794447] [~]$ rpmverify MariaDB-server-10.0.32-1.el7.centos.x86_64 missing c /etc/init.d/mysql S.5....T. c /etc/logrotate.d/mysql missing c /etc/my.cnf.d/server.cnf missing c /etc/my.cnf.d/tokudb.cnf missing /usr/bin/aria_chk missing /usr/bin/aria_dump_log missing /usr/bin/aria_ftdump missing /usr/bin/aria_pack missing /usr/bin/aria_read_log S.5....T. /usr/bin/innochecksum S.5....T. /usr/bin/my_print_defaults S.5....T. /usr/bin/myisam_ftdump S.5....T. /usr/bin/myisamchk S.5....T. /usr/bin/myisamlog S.5....T. /usr/bin/myisampack S.5....T. /usr/bin/mysql_convert_table_format S.5....T. /usr/bin/mysql_fix_extensions S.5....T. /usr/bin/mysql_install_db S.5....T. /usr/bin/mysql_secure_installation S.5....T. /usr/bin/mysql_setpermission S.5....T. /usr/bin/mysql_tzinfo_to_sql S.5....T. /usr/bin/mysql_upgrade S.5....T. /usr/bin/mysql_zap S.5....T. /usr/bin/mysqlbug S.5....T. /usr/bin/mysqld_multi S.5....T. /usr/bin/mysqld_safe missing /usr/bin/mysqld_safe_helper S.5....T. /usr/bin/mysqldumpslow S.5....T. /usr/bin/mysqlhotcopy S.5....T. /usr/bin/perror S.5....T. /usr/bin/replace S.5....T. /usr/bin/resolve_stack_dump S.5....T. /usr/bin/resolveip missing /usr/bin/tokuft_logprint missing /usr/bin/tokuftdump missing /usr/lib64/libmysqld.so missing /usr/lib64/libmysqld.so.18 missing /usr/lib64/mysql/plugin/auth_pam.so S.5....T. /usr/lib64/mysql/plugin/auth_socket.so missing /usr/lib64/mysql/plugin/ha_innodb.so missing /usr/lib64/mysql/plugin/ha_mroonga.so missing /usr/lib64/mysql/plugin/ha_sequence.so missing /usr/lib64/mysql/plugin/ha_sphinx.so missing /usr/lib64/mysql/plugin/ha_spider.so missing /usr/lib64/mysql/plugin/ha_tokudb.so missing /usr/lib64/mysql/plugin/handlersocket.so missing /usr/lib64/mysql/plugin/locales.so missing /usr/lib64/mysql/plugin/metadata_lock_info.so missing /usr/lib64/mysql/plugin/query_cache_info.so missing /usr/lib64/mysql/plugin/query_response_time.so S.5....T. /usr/lib64/mysql/plugin/semisync_master.so S.5....T. /usr/lib64/mysql/plugin/semisync_slave.so missing /usr/lib64/mysql/plugin/server_audit.so missing /usr/lib64/mysql/plugin/sql_errlog.so S.5....T. /usr/sbin/mysqld missing /usr/sbin/rcmysql missing /usr/share/doc/MariaDB-server-10.0.32 missing d /usr/share/doc/MariaDB-server-10.0.32/COPYING missing d /usr/share/doc/MariaDB-server-10.0.32/COPYING.AGPLv3 missing d /usr/share/doc/MariaDB-server-10.0.32/COPYING.GPLv2 missing d /usr/share/doc/MariaDB-server-10.0.32/CREDITS missing d /usr/share/doc/MariaDB-server-10.0.32/EXCEPTIONS-CLIENT missing d /usr/share/doc/MariaDB-server-10.0.32/INSTALL-BINARY missing d /usr/share/doc/MariaDB-server-10.0.32/PATENTS missing d /usr/share/doc/MariaDB-server-10.0.32/README missing d /usr/share/doc/MariaDB-server-10.0.32/README.md missing d /usr/share/man/man1/aria_chk.1.gz missing d /usr/share/man/man1/aria_dump_log.1.gz missing d /usr/share/man/man1/aria_ftdump.1.gz missing d /usr/share/man/man1/aria_pack.1.gz missing d /usr/share/man/man1/aria_read_log.1.gz S.5...GT. d /usr/share/man/man1/innochecksum.1.gz S.5...GT. d /usr/share/man/man1/my_print_defaults.1.gz S.5...GT. d /usr/share/man/man1/myisam_ftdump.1.gz S.5...GT. d /usr/share/man/man1/myisamchk.1.gz S.5...GT. d /usr/share/man/man1/myisamlog.1.gz S.5...GT. d /usr/share/man/man1/myisampack.1.gz S.5...GT. d /usr/share/man/man1/mysql.server.1.gz S.5...GT. d /usr/share/man/man1/mysql_convert_table_format.1.gz S.5...GT. d /usr/share/man/man1/mysql_fix_extensions.1.gz S.5...GT. d /usr/share/man/man1/mysql_install_db.1.gz S.5...GT. d /usr/share/man/man1/mysql_secure_installation.1.gz S.5...GT. d /usr/share/man/man1/mysql_setpermission.1.gz S.5...GT. d /usr/share/man/man1/mysql_tzinfo_to_sql.1.gz S.5...GT. d /usr/share/man/man1/mysql_upgrade.1.gz S.5...GT. d /usr/share/man/man1/mysql_zap.1.gz S.5...GT. d /usr/share/man/man1/mysqlbug.1.gz S.5...GT. d /usr/share/man/man1/mysqld_multi.1.gz S.5...GT. d /usr/share/man/man1/mysqld_safe.1.gz S.5...GT. d /usr/share/man/man1/mysqldumpslow.1.gz S.5...GT. d /usr/share/man/man1/mysqlhotcopy.1.gz S.5...GT. d /usr/share/man/man1/mysqltest.1.gz S.5...GT. d /usr/share/man/man1/perror.1.gz S.5...GT. d /usr/share/man/man1/replace.1.gz S.5...GT. d /usr/share/man/man1/resolve_stack_dump.1.gz S.5...GT. d /usr/share/man/man1/resolveip.1.gz S.5...GT. d /usr/share/man/man8/mysqld.8.gz missing /usr/share/mysql/SELinux/mariadb.pp missing /usr/share/mysql/SELinux/mariadb.te missing /usr/share/mysql/SELinux/rhel4-mysql.fc missing /usr/share/mysql/SELinux/rhel4-mysql.te .......T. /usr/share/mysql/binary-configure SM5....T. /usr/share/mysql/czech/errmsg.sys SM5....T. /usr/share/mysql/danish/errmsg.sys SM5....T. /usr/share/mysql/dutch/errmsg.sys SM5....T. /usr/share/mysql/english/errmsg.sys SM5....T. /usr/share/mysql/errmsg-utf8.txt SM5....T. /usr/share/mysql/estonian/errmsg.sys SM5....T. /usr/share/mysql/fill_help_tables.sql SM5....T. /usr/share/mysql/french/errmsg.sys SM5....T. /usr/share/mysql/german/errmsg.sys SM5....T. /usr/share/mysql/greek/errmsg.sys SM5....T. /usr/share/mysql/hungarian/errmsg.sys missing /usr/share/mysql/install_spider.sql SM5....T. /usr/share/mysql/italian/errmsg.sys SM5....T. /usr/share/mysql/japanese/errmsg.sys SM5....T. /usr/share/mysql/korean/errmsg.sys SM5....T. /usr/share/mysql/magic missing /usr/share/mysql/my-huge.cnf missing /usr/share/mysql/my-innodb-heavy-4G.cnf missing /usr/share/mysql/my-large.cnf missing /usr/share/mysql/my-medium.cnf missing /usr/share/mysql/my-small.cnf S.5....T. /usr/share/mysql/mysql-log-rotate S.5....T. /usr/share/mysql/mysql.server missing /usr/share/mysql/mysql_performance_tables.sql SM5....T. /usr/share/mysql/mysql_system_tables.sql SM5....T. /usr/share/mysql/mysql_system_tables_data.sql SM5....T. /usr/share/mysql/mysql_test_data_timezone.sql .......T. /usr/share/mysql/mysqld_multi.server SM5....T. /usr/share/mysql/norwegian-ny/errmsg.sys SM5....T. /usr/share/mysql/norwegian/errmsg.sys SM5....T. /usr/share/mysql/polish/errmsg.sys SM5....T. /usr/share/mysql/portuguese/errmsg.sys SM5....T. /usr/share/mysql/romanian/errmsg.sys SM5....T. /usr/share/mysql/russian/errmsg.sys SM5....T. /usr/share/mysql/serbian/errmsg.sys SM5....T. /usr/share/mysql/slovak/errmsg.sys SM5....T. /usr/share/mysql/spanish/errmsg.sys SM5....T. /usr/share/mysql/swedish/errmsg.sys SM5....T. /usr/share/mysql/ukrainian/errmsg.sys
    At any rate, the customer is checking things out and we should know by tomorrow if they're happy since they're in another hemisphere.
    0

Please sign in to leave a comment.