Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MariaDB upgrade fails

Discussion in 'Database Discussions' started by jndawson, Aug 17, 2017.

Tags:
  1. jndawson

    jndawson Well-Known Member

    Joined:
    Aug 27, 2014
    Messages:
    167
    Likes Received:
    18
    Trophy Points:
    18
    Location:
    Western US
    cPanel Access Level:
    DataCenter Provider
    We have a weird situation.

    Customer's whm/cpanel server crashes due to hardware failure. Can't recover boot partition, so we spin up another vm and restore accounts/system files from latest backup. Turns out the old server was running MariaDB, but we only installed MySQL. After three days of the customer trying to get all their websites working - the newer ones failed, older ones running just fine - they point out that they think we need to install MariaDB.

    We also were able to recover the old server's hard drive and mount it on /mnt so we have all the original files, so we have a full backup standing by.

    Ran whm > software > mysql/mariadb upgrade and it failed. Output:

    Code:
    Starting process with log file at /var/cpanel/logs/mysql_upgrade.20170817-084333/unattended_upgrade.log
    Obtained version information from system.
    Beginning “MariaDB 10.0” upgrade...
    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.web-ster.com
    * extras: ftp.osuosl.org
    * updates: ftp.osuosl.org
    Package 2:shadow-utils-4.1.5.1-24.el7.x86_64 already installed and latest version
    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
    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.web-ster.com
    * extras: ftp.osuosl.org
    * updates: ftp.osuosl.org
    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.web-ster.com
    * extras: ftp.osuosl.org
    * updates: ftp.osuosl.org
    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 11115 (systemd+/proc check method).
    mysql (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=cp5.ipns.com.err --open-files-limit=10000 --pid-file=cp5.ipns.com.pid) is running as mysql with PID 11242 (systemd+/proc check method).
    
    Startup Log
    Aug 17 08:44:37 cp5.ipns.com systemd[1]: Started MySQL Server.
    Aug 17 08:44:37 cp5.ipns.com systemd[1]: Starting MySQL Server...
    Aug 17 08:44:38 cp5.ipns.com mysqld_safe[11115]: 170817 08:44:38 mysqld_safe Logging to '/var/lib/mysql/cp5.ipns.com.err'.
    Aug 17 08:44:38 cp5.ipns.com mysqld_safe[11115]: 170817 08:44:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    
    Log Messages
    170817 08:44:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    170817 08:44:38 mysqld_safe Logging to '/var/lib/mysql/cp5.ipns.com.err'.
    170817 08:44:37 mysqld_safe mysqld from pid file /var/lib/mysql/cp5.ipns.com.pid ended
    2017-08-17 08:44:37 9166 [Note] /usr/sbin/mysqld: Shutdown complete
    2017-08-17 08:44:34 9166 [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 11115 (systemd+/proc check method).
    mysql (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=cp5.ipns.com.err --open-files-limit=10000 --pid-file=cp5.ipns.com.pid) is running as mysql with PID 11242 (systemd+/proc check method).
    The 'mysql' service passed the check: mysql (/bin/sh /usr/bin/mysqld_safe) is running as mysql with PID 11115 (systemd+/proc check method).
    mysql (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=cp5.ipns.com.err --open-files-limit=10000 --pid-file=cp5.ipns.com.pid) is running as mysql with PID 11242 (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 11865 (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 11992 (systemd+/proc check method).
    
    Startup Log
    Aug 17 08:46:49 cp5.ipns.com systemd[1]: Started MySQL Server.
    Aug 17 08:46:49 cp5.ipns.com systemd[1]: Starting MySQL Server...
    Aug 17 08:46:49 cp5.ipns.com mysqld_safe[11865]: 170817 08:46:49 mysqld_safe Logging to '/var/lib/mysql/server.tld.err'.
    Aug 17 08:46:50 cp5.ipns.com mysqld_safe[11865]: 170817 08:46:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    
    Log Messages
    170817 08:46:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    170817 08:46:49 mysqld_safe Logging to '/var/lib/mysql/server.tld.err'.
    170817 08:46:48 mysqld_safe mysqld from pid file /var/lib/mysql/cp5.ipns.com.pid ended
    2017-08-17 08:46:48 11242 [Note] /usr/sbin/mysqld: Shutdown complete
    2017-08-17 08:46:46 11242 [Note] /usr/sbin/mysqld: Normal shutdown
    
    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.
    
    The upgrade process failed!
    
    You should correct any errors listed in the output window and retry the upgrade process beginning at the failed step.
    We then tried running mysql_upgrade --force at cli. Also didn't work.

    The hypothesis is that we have a combination of MySQl & MariaDB files causing the issue. We have a couple of thoughts on how to proceed. Would it make sense to

    1. delete the active mysql directory, attempt the upgrade, then restore from the backup directory? or

    2. delete the active directory, restore from the backup directory, and attempt the upgrade? or

    3. something else?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,127
    Likes Received:
    1,366
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you run the following commands and let us know the output?

    Code:
    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.
     
  3. jndawson

    jndawson Well-Known Member

    Joined:
    Aug 27, 2014
    Messages:
    167
    Likes Received:
    18
    Trophy Points:
    18
    Location:
    Western US
    cPanel Access Level:
    DataCenter Provider
    Oops - should have included all that.

    Code:
    [ 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
    
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,127
    Likes Received:
    1,366
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    You can remove the RPM target settings for MySQL 5.1 with the following command:

    Code:
    /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:

    Code:
    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:

    Code:
    /usr/local/cpanel/scripts/check_cpanel_rpms
    Let us know if this helps.

    Thank you.
     
  5. jndawson

    jndawson Well-Known Member

    Joined:
    Aug 27, 2014
    Messages:
    167
    Likes Received:
    18
    Trophy Points:
    18
    Location:
    Western US
    cPanel Access Level:
    DataCenter Provider
    Tried your steps, then reran update to MariaDB 10.0 via whm. Failed again:

    Code:
    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.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,127
    Likes Received:
    1,366
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you open a support ticket using the link in my signature so we can take a closer look?

    Thank you.
     
  7. jndawson

    jndawson Well-Known Member

    Joined:
    Aug 27, 2014
    Messages:
    167
    Likes Received:
    18
    Trophy Points:
    18
    Location:
    Western US
    cPanel Access Level:
    DataCenter Provider
    Tkt:
    8794447
     
  8. jndawson

    jndawson Well-Known Member

    Joined:
    Aug 27, 2014
    Messages:
    167
    Likes Received:
    18
    Trophy Points:
    18
    Location:
    Western US
    cPanel Access Level:
    DataCenter Provider
    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:

    Code:
    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.
     
    cPanelMichael likes this.
Loading...

Share This Page