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

The upgrade to MaraiDB went go wrong with following msg shown on the screen: [SPOILER="Screen output">


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.

MyDreamscape

October 01, 2016 12:13

In WHM I tried to install the missing perl-DBI module, went to 'Install a Perl Module' and msg shows:
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: [SPOILER="Result DBI module install">


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 www.planet-example.de 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)...@194.8.197.22......receiving......request success......Done
Mirror Check passed for mirror.example.de (/index.html)
Searching on cpanmetadb ...
Searching DBI on cpanmetadb (

cPanelMichael

October 06, 2016 19:38

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:
/scripts/checkyum --no-perl
Then, install the required perl-DBI package via the following command:
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:

October 07, 2016 01:58

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: [LIST]

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!

October 07, 2016 03:41

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

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

Comments

Didn't find what you were looking for?