Error MySQL/MariaDB Upgrade (5.6 to 10.0) step 4

MyDreamscape

Member
Apr 27, 2010
6
1
53
Netherlands
The upgrade to MaraiDB went go wrong with following msg shown on the screen:

Code:
Starting process with log file at /var/cpanel/logs/mysql_upgrade.20160929-201036/unattended_upgrade.log
Beginning “MariaDB 10.0” upgrade...
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 “shadow-utils” is available.
The “MariaDB100” repository is available and working.
Installing pre-known MariaDB dependencies.
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.proserve.nl
* epel: ftp.nluug.nl
* extras: mirror.proserve.nl
* updates: mirror.proserve.nl
Excluding Packages in global exclude list
Finished
Setting up Install Process
No package perl-DBI available.
Package 2:shadow-utils-4.0.17-23.el5.x86_64 already installed and latest version
Package coreutils-5.97-34.el5_8.1.x86_64 already installed and latest version
Package grep-2.5.1-55.el5.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
Loading mirror speeds from cached hostfile
* base: mirror.proserve.nl
* epel: ftp.nluug.nl
* extras: mirror.proserve.nl
* updates: mirror.proserve.nl
Excluding Packages in global exclude list
Finished
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.0.27-1 set to be updated
---> Package MariaDB-common.x86_64 0:10.0.27-1 set to be updated
---> Package MariaDB-devel.x86_64 0:10.0.27-1 set to be updated
---> Package MariaDB-server.x86_64 0:10.0.27-1 set to be updated
--> Processing Dependency: perl(DBI) for package: MariaDB-server
---> Package MariaDB-shared.x86_64 0:10.0.27-1 set to be updated
--> Finished Dependency Resolution
MariaDB-server-10.0.27-1.x86_64 from MariaDB100 has depsolving problems
--> Missing Dependency: perl(DBI) is needed by package MariaDB-server-10.0.27-1.x86_64 (MariaDB100)
You could try using --skip-broken to work around the problem
You could try running: package-cleanup --problems
package-cleanup --dupes
rpm -Va --nofiles --nodigest

(XID cqn54b) The system failed to execute yum with the arguments “-y -c /var/tmp/8539.WHOSTMGR_BIN_WHOSTMGR_PL__.GQYUcZDMGTinAnaW.tmp -x MariaDB-compat install MariaDB-server MariaDB-client MariaDB-devel MariaDB-shared MariaDB-common” because of an error: The “/usr/bin/yum” command (process 8589) reported error number 1 when it ended. : Error: Missing Dependency: perl(DBI) is needed by package MariaDB-server-10.0.27-1.x86_64 (MariaDB100)
Restarting mysql service.
Waiting for “mysql” to restart ……waiting for “mysql” to initialize ………finished.

Service Status
mysql (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/xxxxx.xxxxx.net.err --open-files-limit=10000 --pid-file=/var/lib/mysql/xxxxx.xxxxx.net.pid) is running as mysql with PID 8836 (pidfile check method).

Startup Log
Starting MySQL.. SUCCESS!

Log Messages
2016-09-29 20:11:27 8836 [Note] /usr/sbin/mysqld: ready for connections.
160929 20:11:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160929 20:11:24 mysqld_safe mysqld from pid file /var/lib/mysql/xxxxx.xxxxx.net.pid ended
2016-09-29 20:11:24 27025 [Note] /usr/sbin/mysqld: Shutdown complete
2016-09-29 20:11:20 27025 [Warning] /usr/sbin/mysqld: Forcing close of thread 1401942 user: 'eximstats'
2016-09-29 20:11:18 27025 [Note] /usr/sbin/mysqld: Normal shutdown

mysql restarted successfully.

The preinstall check failed. The install may have failed because system perl has been altered. MariaDB cannot be installed. at /usr/local/cpanel/Cpanel/MariaDB/Install.pm line 108.

This is now showing and I have actually no idea what to do next:

MySQL/MariaDB Upgrade

Warning: The last run of the MySQL upgrade wizard failed. If you have corrected the problems that led to this failure it is highly recommended that you resume your previous upgrade rather than beginning a new one.

Current step number: 4
Starting MySQL/MariaDB version: 5.6
Selected MySQL/MariaDB version: 10.0
Upgrade Type: Partially-Interactive Upgrade
It offers two options: Resume Current Upgrade and/or Ignore Current Upgrade.

Would be nice to hear how to solve this issue.
 
Last edited by a moderator:

MyDreamscape

Member
Apr 27, 2010
6
1
53
Netherlands
In WHM I tried to install the missing perl-DBI module, went to 'Install a Perl Module' and msg shows:
Code:
The perl magic loader is deprecated as of 11.36.
Should not be a real problem or?
I add the name of the missing module - DBI - in the input box and clicked Install Now button. Result output:

Code:
Checking C compiler....C compiler (/usr/bin/cc) OK (cached Sat Oct  1 12:22:30 2016)
Tuned C compiler not available because it is not enabled....Done
CPAN fallback is disabled since /var/cpanel/conserve_memory exists, and cpanm is available.
Method: Using Perl Expect, Installer: cpanm
--perl is deprecated since it's known to be fragile in figuring out dependencies. Run `/scripts/cpan_sandbox/x86_64/perl -S cpanm` instead.
cpanm (App::cpanminus) 1.7039 on perl 5.008008 built for x86_64-linux
Work directory is /home/.cpanm/work/1475323109.14127
You have make /usr/bin/make
Falling back to HTTP::Tiny 0.056
You have /bin/tar: tar (GNU tar) 1.15.1
You have /usr/bin/unzip
Testing connection speed...(using fast method)...Done
Ping:0.00533008575439453 (ticks) Testing connection speed to mirror.example.de using pureperl...(cached .. 102622.09 bytes/s)...Done
Ping:0.00743603706359863 (ticks) Testing connection speed to cpan.etla.org using pureperl...(cached .. 77196.62 bytes/s)...Done
Ping:0.00729584693908691 (ticks) Testing connection speed to cpan.mirrors.uk2.net using pureperl...(cached .. 73232.23 bytes/s)...Done
Ping:0.0113880634307861 (ticks) Testing connection speed to [URL='http://www.planet-elektronik.de']www.planet-example.de[/URL] using pureperl...(cached .. 44970.92 bytes/s)...Done
Ping:0.013962984085083 (ticks) Testing connection speed to mirror.bytemark.co.uk using pureperl...(cached .. 37382.63 bytes/s)...Done
Five usable mirrors located
Ping:1000 (ticks) Testing connection speed to 69.73.140.17 using pureperl...(using cached speed)...Done
Ping:0.130738019943237 (ticks) Testing connection speed to 208.109.109.239 using pureperl...(using cached speed)...Done
Ping:0.143280029296875 (ticks) Testing connection speed to 69.50.192.73 using pureperl...(using cached speed)...Done
Three usable fallback mirrors located
Fetching http://mirror.example.de/cpan/index.html (connected:0).......(request attempt 1/12)...Resolving mirror.example.de...(resolve attempt 1/65)[email protected] success......Done
Mirror Check passed for mirror.example.de (/index.html)
Searching on cpanmetadb ...
Searching DBI on cpanmetadb ([URL]http://cpanmetadb.cpanel.net/v1.0/package/DBI[/URL]) ...
Source: fastest CPAN mirror ... DBI is up to date. (1.636)

DBI is up to date. (1.636) so, should do the job?
Through ssh wanted to check the version and if it is installed at all, result:

Code:
-bash-3.2# rpm -q perl-DBI
package perl-DBI is not installed
-bash-3.2#
Means, there is no way to upgrade to MariaDB at all because the missing perl-DBI module is not installed.
So again, how to solve this, what am I missing, is there really not another way to solve this?

I would at least expect an answer/solution from the support here, we pay for the product so is that too much ask for?

Note: in the Backend (WHM) it also says the Module is installed:
DBI 1.636 Update Reinstall Uninstall Show Docs
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
Hello,

Could you verify if "Perl*" if added to the "Exclude=" line in your /etc/yum.conf file? If so, run the following command to remove that entry:

Code:
/scripts/checkyum --no-perl
Then, install the required perl-DBI package via the following command:

Code:
yum install perl-DBI
This should allow the MariaDB upgrade to proceed. Information about the various Perl environments on a cPanel server is available at:

Guide to Perl in cPanel - Perl Environments - Software Development Kit - cPanel Documentation

Thank you.
 

MyDreamscape

Member
Apr 27, 2010
6
1
53
Netherlands
Hello Michael,

Thank you for this solution, all went well this time!
We had to rebuild apache and php also afterwards and that went also flawless.

We have to migrate in the near future to CentOS 7 but for now it looks like:
  • CENTOS: 5.11 x86_64 xenpv
  • cPanel Version: 56.0 (build 35)
  • Apache Version: 2.4.23
  • PHP Version: 5.6.26
  • MySQL Version: 10.0.27-MariaDB
  • Perl Version: 5.8.8

Please mark the issue as solved, thank you!
 
  • Like
Reactions: cPanelMichael

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
Hello,

I'm happy to see the issue is now resolved. Thank you for updating us with the outcome.