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!

SOLVED Can't upgrade from MySQL 5.6 to MariaDB 10.1

Discussion in 'Database Discussion' started by aolbrechts, Jan 10, 2018.

  1. aolbrechts

    aolbrechts Active Member

    Joined:
    Feb 24, 2016
    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Belgium
    cPanel Access Level:
    Root Administrator
    Hello,

    I'm trying to upgrade to MariaDB on my server and it won't go through :(
    Not sure what to do to fix this ?


    Thanks for your help?
    Antoine


    Error installing MariaDB dependencies: (XID hkba5a) The system failed to execute yum with the arguments “--assumeyes --config /etc/yum.conf --exclude MariaDB-compat install perl-DBI shadow-utils grep coreutils” because of an error: The “/usr/bin/yum” command (process 10753) reported error number 1 when it ended. :

    Transaction check error:
    package grep-2.20-3.el7.x86_64 is already installed

    Error Summary
    -------------
    Obtained version information from system.
    Proceeding with MySQL/MariaDB upgrade despite the following: Normal: The selected MariaDB version (10.1) is more than one generation newer than the currently installed version. The upgrade process will iterate over each intervening version to ensure tables are upgraded appropriately.
     

    Attached Files:

  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    It looks like you might have a YUM exclusion added for MariaDB, which isn't a default entry on the exclude= line. Please post the output from the following command:

    Code:
    grep exclude= /etc/yum.conf
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. aolbrechts

    aolbrechts Active Member

    Joined:
    Feb 24, 2016
    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Belgium
    cPanel Access Level:
    Root Administrator
    Here is what I get :

    exclude=bind-chroot courier* dovecot* exim* filesystem httpd* mod_ssl* mydns* mysql* nsd* p0f perl* php* proftpd* pure-ftpd* spamassassin* squirrelmail*
     
  4. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,834
    Likes Received:
    85
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hi,

    The mysql* term is mentioned in the exclude list, so it will fail until it exists there.. You can just remove this entry from the exclude list once and then execute the upgrade. Are you upgrading it manually or via WHM. If you are upgrading it via WHM, then WHM should automatically adjust this and upgrade properly. How exactly you are upgrading?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. aolbrechts

    aolbrechts Active Member

    Joined:
    Feb 24, 2016
    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Belgium
    cPanel Access Level:
    Root Administrator
    I'm trying to do this in WHM (see screenshot) but it won't work.
     

    Attached Files:

  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Please remove "mysql*" from the "exclude=" line in the /etc/yum.conf file and try again.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. aolbrechts

    aolbrechts Active Member

    Joined:
    Feb 24, 2016
    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Belgium
    cPanel Access Level:
    Root Administrator
    Hello,

    Just tried that, and this is the error I get :



    Error installing MariaDB dependencies: (XID juf6qz) The system failed to execute yum with the arguments “--assumeyes --config /etc/yum.conf --exclude MariaDB-compat install shadow-utils coreutils perl-DBI grep” because of an error: The “/usr/bin/yum” command (process 21449) reported error number 1 when it ended. :

    Transaction check error:
    package grep-2.20-3.el7.x86_64 is already installed

    Error Summary
    -------------
    Obtained version information from system.
    Proceeding with MySQL/MariaDB upgrade despite the following: Normal: The selected MariaDB version (10.1) is more than one generation newer than the currently installed version. The upgrade process will iterate over each intervening version to ensure tables are upgraded appropriately.
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    I've seen this happen when the system has duplicate RPMs installed. Try running the following command to see if multiple instances of the "grep" RPM are installed:

    Code:
    rpm -qa | grep grep
    If so, run a command like this for each particular RPM name:

    Code:
    yum info -v grep-2.20-2.el7.x86_64 | grep -i 'from repo'
    Replace "grep-2.20-2.el7.x86_64" from the above example with the actual RPM names found in the prior command. This should tell you which YUM repo (if any) the duplicate RPMs are associated with. You can then run the following command to see which YUM repos are active on your system:

    Code:
    grep -iR 'enabled=1' /etc/yum.repos.d/
    If one of the duplicate "grep" RPMs is not associated with an enabled YUM repo, then you can uninstall it with a command such as:

    Code:
    rpm -e --nodeps grep-2.20-2.el7.x86_64
    You'd replace "grep-2.20-2.el7.x86_64" with the RPM name that's not associated with an enabled YUM repo. Once you do this, you should be able to proceed with the MariaDB upgrade.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. aolbrechts

    aolbrechts Active Member

    Joined:
    Feb 24, 2016
    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Belgium
    cPanel Access Level:
    Root Administrator
    I indeed have two installed :

    root@cloud [~]# rpm -qa | grep grep
    grep-2.20-3.el7.x86_64
    grep-2.20-2.el7.x86_64

    But when I do
    yum info -v grep-2.20-2.el7.x86_64 | grep -i 'from repo'
    and
    yum info -v grep-2.20-3.el7.x86_64 | grep -i 'from repo'

    Nothing happens.

    And then after if I do
    grep -iR 'enabled=1' /etc/yum.repos.d/

    I get this :
    /etc/yum.repos.d/cpanel-plugins.repo:enabled=1
    /etc/yum.repos.d/cPAddons.repo:enabled=1
    /etc/yum.repos.d/EA4.repo:enabled=1
     
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    You'd generally see one of the RPMs show up as coming from the "base" YUM repo. Could you open a support ticket using the link in my signature so we can take a closer look at your system?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  11. aolbrechts

    aolbrechts Active Member

    Joined:
    Feb 24, 2016
    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Belgium
    cPanel Access Level:
    Root Administrator
    Yes OK, because nothing else appears when I do both commands ...
     
  12. aolbrechts

    aolbrechts Active Member

    Joined:
    Feb 24, 2016
    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Belgium
    cPanel Access Level:
    Root Administrator
    Done.

    Your Support Request ID is: 9211563
     
  13. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    To update, the duplicate RPMS were removed with the following command:

    Code:
    package-cleanup --cleandupes
    This allowed the MySQL/MariaDB upgrade to complete successfully.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  14. aolbrechts

    aolbrechts Active Member

    Joined:
    Feb 24, 2016
    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Belgium
    cPanel Access Level:
    Root Administrator
    Thanks, I've one that with a ticket to the support and it finally upgraded !
     
    cPanelMichael likes this.
  15. aolbrechts

    aolbrechts Active Member

    Joined:
    Feb 24, 2016
    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Belgium
    cPanel Access Level:
    Root Administrator
    Hello,
    Yesterday night everything was OK and this morning I’m flooded by client phone calls saying their web sites are down.
    It seems Wordpress is looking for MySQL everywhere.
    What I don’t understand is that is was working yesterday night AFTER the MariaDB update.
    Here is an exemple of the messages received when visiting a web site :
    Your PHP installation doesn’t contain MySQL. This extension is required for Wordpress.
    Thanks for your urgent help,
    Antoine
     
  16. rpvw

    rpvw Well-Known Member

    Joined:
    Jul 18, 2013
    Messages:
    729
    Likes Received:
    248
    Trophy Points:
    93
    Location:
    Spain
    cPanel Access Level:
    Root Administrator
    Maybe an overnight upcp broke something.

    Check your upcp logs to see if there is anything that looks strange.

    You may have to update your Easy Apache 4 using yum update, or maybe you need to restart the Apache/PHP-FPM/SQL Server daemons or maybe the SQL components in your PHP need refreshing by un-installing them and re-installing using the WHM >> Software >> Easy Apache 4 interface.

    EasyApache 4 Home - EasyApache 4 - cPanel Documentation
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  17. aolbrechts

    aolbrechts Active Member

    Joined:
    Feb 24, 2016
    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Belgium
    cPanel Access Level:
    Root Administrator
    Indeed something has happened during the night because there was no MySQL extension installed in EA4 anymore !
    Just re-installed and it seems OK, but I have to check if it won't happen every night ...
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice