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.

SOLVED MariaDB Upgrade - The system was not able to ensure the availability of the “MariaDB-client” package

Discussion in 'Database Discussions' started by Andrew Davis, Sep 11, 2017.

Tags:
  1. Andrew Davis

    Andrew Davis Member

    Joined:
    May 23, 2017
    Messages:
    7
    Likes Received:
    3
    Trophy Points:
    3
    Location:
    Trinidad/USA
    cPanel Access Level:
    Website Owner
    Hello,
    I am unable to upgrade from MySQL to MariaDB while using the WHM interface.

    Software » MySQL/MariaDB Upgrade

    I follow the steps correctly, choosing the recommended MariaDB 10.1 version.

    I cannot get past this stage:

    Code:
    2017-09-12 01:27:59 21523 [Note] /usr/sbin/mysqld: Normal shutdown
    2017-09-12 01:19:48 21523 [Note] /usr/sbin/mysqld: ready for connections.
    
    mysql restarted successfully.
    
    The system was not able to ensure the availability of the “MariaDB-client” package: (XID sq48jb) “/usr/bin/yum” reported error code “1” when it ended: Error: No matching Packages to list
    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.

    The process quits at this point.
    I contacted my hosting company and they were unable to resolve the issue for me.


    This particular portion is the problem area, with an Error icon:
    The system was not able to ensure the availability of the “MariaDB-client” package: (XID sq48jb) “/usr/bin/yum” reported error code “1” when it ended: Error: No matching Packages to list


    XID "sq48jb" is random/changing each time I try.


    What can be done to fix this?
    Thanks.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

    Can you verify which operating system is installed on this system? EX:

    Code:
    cat /etc/redhat-release
    Also, are you using any custom YUM repos in the /etc/yum.repos.d/ directory, or do you have mariadb added to the "Exclude=" line in the /etc/yum.conf file?

    Thank you.
     
  3. Andrew Davis

    Andrew Davis Member

    Joined:
    May 23, 2017
    Messages:
    7
    Likes Received:
    3
    Trophy Points:
    3
    Location:
    Trinidad/USA
    cPanel Access Level:
    Website Owner
    Hello, thanks for the response.

    Yes: CentOS release 6.9 (Final)


    Not as far as I am aware.
    I am not manually installing MariaDB via SSH.
    I'm using the WHM interface at "Software » MySQL/MariaDB Upgrade",
    so I haven't manually installed/changed anything, nor edited any files.


    I just checked via SSH, and I actually see this line in the /etc/yum.conf file:
    Code:
    exclude=ansible1.9,mysql,mariadb,mariadb-*,Percona-XtraDB-*,Percona-*-55,Percon$
    So I made a backup copy of this .conf file.
    Then removed this portion "mariadb,mariadb-*," and saved yum.conf.

    Now I went back to WHM » Software » MySQL/MariaDB Upgrade and attempted the upgrade process again.

    ...

    MySQL/MariaDB Upgrade Completed.

    Currently installed: 10.1.26-MariaDB




    So this solved my problem:

    Removing the "mariadb,mariadb-*," portion from the "exclude=" line in "/etc/yum.conf.".
    (Save - Run Update process again)


    Thanks for the assistance!
    -Andrew
     
    cPanelMichael likes this.
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

    I'm glad to see the issue is now solved. Thank you for updating us with the outcome.
     
  5. Andrew Davis

    Andrew Davis Member

    Joined:
    May 23, 2017
    Messages:
    7
    Likes Received:
    3
    Trophy Points:
    3
    Location:
    Trinidad/USA
    cPanel Access Level:
    Website Owner
    You're very welcome. Thanks again.
    Kind regards.
     
    cPanelMichael likes this.
Loading...

Share This Page