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.

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

Discussion in 'Database Discussions' started by MyDreamscape, Sep 29, 2016.

Tags:
  1. MyDreamscape

    MyDreamscape Member

    Joined:
    Apr 27, 2010
    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    1
    Location:
    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:

    It offers two options: Resume Current Upgrade and/or Ignore Current Upgrade.

    Would be nice to hear how to solve this issue.
     
    #1 MyDreamscape, Sep 29, 2016
    Last edited by a moderator: Oct 2, 2016
  2. MyDreamscape

    MyDreamscape Member

    Joined:
    Apr 27, 2010
    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    1
    Location:
    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)...@194.8.197.22......receiving......request 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
     
    #2 MyDreamscape, Oct 1, 2016
    Last edited by a moderator: Oct 2, 2016
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    672
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  4. MyDreamscape

    MyDreamscape Member

    Joined:
    Apr 27, 2010
    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    1
    Location:
    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!
     
    cPanelMichael likes this.
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    672
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page