Skip to main content

MariaDB Upgrade Issue

Comments

10 comments

  • cPRex Jurassic Moderator

    Hey there!  Can you try running the classic combination of Yum fixing commands to see if that changes the behavior, or gives you an error message related to Yum itself?

    yum clean all
    yum makecache
    yum update

    Let me know how that goes!

    0
  • Dan Fox

    Thank you for replying cPRex. 

    I have actioned these and all went well till I ran yum update. It identified the MariaDB needed updating. I got the below.

    Downloading Packages:
    MariaDB-server-11.0.6-1.el8.x86_64.rpm                                                                   15 MB/s |  27 MB     00:01
    ----------------------------------------------------------------------------------------------------------------------------------------
    Total                                                                                                    15 MB/s |  27 MB     00:01
    Running transaction check
    Transaction check succeeded.
    Running transaction test
    Transaction test succeeded.
    Running transaction
      Preparing        :                                                                                                                1/1
      Running scriptlet: MariaDB-server-11.0.6-1.el8.x86_64                                                                             1/1
      Running scriptlet: MariaDB-server-11.0.6-1.el8.x86_64                                                                             1/2

    ******************************************************************
    A MySQL or MariaDB server package (MariaDB-server-10.6.14-1.el8.x86_64) is installed.

    Upgrading directly from MySQL 10.6 to MariaDB 11.0 may not
    be safe in all cases.  A manual dump and restore using mysqldump is
    recommended.  It is important to review the MariaDB manual's Upgrading
    section for version-specific incompatibilities.

    A manual upgrade is required.

    - Ensure that you have a complete, working backup of your data and my.cnf
      files
    - Shut down the MySQL server cleanly
    - Remove the existing MySQL packages.  Usually this command will
      list the packages you should remove:
      rpm -qa | grep -i '^mysql-'

      You may choose to use 'rpm --nodeps -ev <package-name>' to remove
      the package which contains the mysqlclient shared library.  The
      library will be reinstalled by the MariaDB-shared package.
    - Install the new MariaDB packages supplied by MariaDB Foundation
    - Ensure that the MariaDB server is started
    - Run the 'mysql_upgrade' program

    This is a brief description of the upgrade process.  Important details
    can be found in the MariaDB manual, in the Upgrading section.
    ******************************************************************
    error: %prein(MariaDB-server-11.0.6-1.el8.x86_64) scriptlet failed, exit status 1

    Error in PREIN scriptlet in rpm package MariaDB-server
      Verifying        : MariaDB-server-11.0.6-1.el8.x86_64                                                                             1/2
      Verifying        : MariaDB-server-10.6.14-1.el8.x86_64                                                                            2/2
    /etc/dnf/universal-hooks/pkgs/MariaDB-server/transaction/100-build_mysql_conf: running in the background.

    Failed:
      MariaDB-server-10.6.14-1.el8.x86_64                                 MariaDB-server-11.0.6-1.el8.x86_64

    Error: Transaction failed

     

    0
  • cPRex Jurassic Moderator

    Now that you've performed that work with Yum, can you try the upgrade through the WHM interface and see if the same issue happens there?

    0
  • Dan Fox

    Same error I'm afraid

    0
  • cPRex Jurassic Moderator

    Can you run the recommend command and send me the output?

    rpm -qa | grep -i '^mysql-'
    0
  • cPRex Jurassic Moderator

    I deleted that last post as we didn't need to see every package on the server :D

    At this point it would be best to create a ticket - I'd hate to recommend something that could damage the database structure on the server.

    0
  • Dan Fox

    Hello cPRex. Thank you. 

    I have a slight issue that becuase I have got the license through the data centre with the server, CPanel are not letting me do a support ticket.

    I have also had an issue reinstalling NGinx which was down to the IP's in the Resolver timing out. I have used as a temporary solution, Google's IPs and this has enabled me to install NGinx once again. 

    I have once again run tried running the commands you have suggested and this has not helped fix the MariaDB upgrade. 

    A possible clue, I am running a range of WooCommerce websites on the server, and whenever I do a search in the product list for a certain keyword, I am getting 404 page errors, other words I am searching are fine and this is not limited to 1 site and always the same keyword. I am also getting the same 404 (try clearing your cache which works)  whilst doing other Wordpress Admin tasks but not all. I have tested plugins, themes etc and no closer. Whilst I know this is not a Wordpress or WooCommerce forum, I am putting this up as a possible clue as to what is going on. When I clear my browser cache, the admins work all again and there are no errors in log files I can see. It is odd. 

    0
  • Dan Fox

    Me again, I am also getting server software update failures if this is related?

     

    Thank you

    0
  • cPRex Jurassic Moderator

    Your hosting provider would be the first point of contact for the issue, and then they would escalate the problem to us if they are not able to resolve it.

    0
  • Dan Fox

    I am trying... thank you cPRex for your assitance so far. 

    1

Please sign in to leave a comment.