← Back to team overview

maria-discuss team mailing list archive

Re: mariadb 10.4.13-lp152.1.1 to 10.5.12-3.9.1 upgrade failure SOLVED!

 

Hi and thanks Karl and everyone who tried to help me, and sorry for the long delay in responding. Trying to use the packages from the mariadb.org repo did not work any better than using the repos from OpenSuSE's repositories. The automatic upgrade process did not work when trying to upgrade from any version past 10.5.11-3.3.1-x86-64.

However, I have managed to find a solution by  using another approach. I reinstalled version 10.5.11-3.3.1-x86-64 and used mysqldump to dump all the databases to an sql file. Then I set the database storage directory aside and created a new directory to hold the database files. I then installed the latest versions of mariadb server, client, tools etc from the OpenSuSE repository (Ver 10.5.12-3.9.1-x86_64), started it with no databases, and imported all my databases from the aforementioned sql file.  Seems to have worked!

Thanks again, just reporting how I managed to workaround this issue.   Marc....

On 11/8/21 4:27 AM, Karl Levik wrote:
Hiya Marc,

That sounds like progress.

I wonder whether the upgrade would work with MariaDB Server packages from the mariadb.org <http://mariadb.org> repo instead of packages from OpenSuSE?

If so, then that would indicate the problem might be related to the packaging done by OpenSuSE.

Cheers,
Karl

On Mon, 8 Nov 2021 at 06:08, Marc Chamberlin <marc@xxxxxxxxxxxxxxxxxx <mailto:marc@xxxxxxxxxxxxxxxxxx>> wrote:

    Hi Karl, and thanks for your thoughts, and I think you got me a
    bit further but in the end still no joy getting the upgrade to the
    latest version of Mariadb, that is supported in OpenSuSE 15.3,
    (10.5.12-3.9.1), to work. I took your idea of doing incremental
    upgrades to see how far I could get and this is what I found using
    various versions found in the OpenSuSE 15.3 repositories -

    Version 10.4.13-lp152.1.1-x86_64 (supplied as part of OpenSuSE
    15.2)  upgraded to version 10.5.8-1.5-x86-64, works!
    Version 10.5.8-1.5-x86-64 (supplied as part of OpenSuSE 15.3)
    upgraded to version 10.5.11-3.3.1-x86-64, works!
    Version 10.5.11-3.3.1-x86-64 (supplied as part of OpenSuSE 15.3)
    upgraded to version 10.5.12-3.6.1-x86-64, worked first time I
    tried, but all subsequent attempts to upgrade to this version
    (from version 10.5.8-1.5-x86-64) have failed.
    Version 10.5.12-3.6.1-x86-64 (supplied as part of OpenSuSE 15.3)
    upgraded to version 10.5.12-3.9.1-x86-64, always fails.

    So at the moment I can use version 10.5.11-3.3.1-x86-64. By failed
    I mean I cannot get that version of the MySQL/MariaDB server to
    start. Instead I get the error about corrupt tables that I
    reported earlier. It appears that something broke in version
    10.5.12-3.6.1-x86-64 even though I did get it to work one time.

    Your other suggestion, to "Retry with innodb_force_recovery=5"
    hasn't seemed to make a difference in my assorted attempts to
    upgrade to the latest versions that OpenSuSE 15.3 has in it's
    repositories.

       HTHs,  Marc...


    On 11/5/21 2:30 AM, Karl Levik wrote:
    (Re-sent because I forgot to include the list, sorry.)

    Hi Marc,

    That sounds frustrating. 10.4.13 is not the most recent in the
    10.4 series, so perhaps it would help to upgrade to 10.4.21
    first, and then upgrade from there to 10.5.12?

    Your error log also suggests a solution: "Retry with
    innodb_force_recovery=5" - it might be worth trying that as well.

    Cheers,
    Karl

    On Thu, 4 Nov 2021 at 16:45, Marc Chamberlin
    <marc@xxxxxxxxxxxxxxxxxx <mailto:marc@xxxxxxxxxxxxxxxxxx>> wrote:


        Hello - I have ran into a problem that maybe someone else has
        hit and knows a solution for it.  I recently upgraded my
        OpenSuSE 15.2 x64 version to OpenSuSE 15.3 x64 and installed
        all additional updates and patches that were suggested for
        15.3.  Most of the upgrade succeeded, all except Mariadb.
        Google has not been helpful either. My understanding of
        Mariadb is that after a new install of a new version it is
        suppose to automagically update and fix the databases from
        the older version, when the server is restarted, but I think
        this is failing. I found the  upgrade log file for Mariadb
        and it appears to be reporting some kind of corruption has
        occurred. This is preventing the mariadb (mysql) server from
        even starting, so it is not possible to use queries to find
        and repair the database. -

        bigbang:/var/tmp/mysql-protected.lBP2YQ # more
        log_upgrade_run.err
        2021-10-31 12:11:36 0 [Note] InnoDB: !!!
        innodb_force_recovery is set to 1 !!!
        2021-10-31 12:11:36 0 [Note] InnoDB: Uses event mutexes
        2021-10-31 12:11:36 0 [Note] InnoDB: Compressed tables use
        zlib 1.2.11
        2021-10-31 12:11:36 0 [Note] InnoDB: Number of pools: 1
        2021-10-31 12:11:36 0 [Note] InnoDB: Using crc32 + pclmulqdq
        instructions
        2021-10-31 12:11:36 0 [Note] mysqld: O_TMPFILE is not
        supported on /tmp (disabling future attempts)
        2021-10-31 12:11:36 0 [Note] InnoDB: Using Linux native AIO
        2021-10-31 12:11:36 0 [Note] InnoDB: Initializing buffer
        pool, total size = 134217728, chunk size = 134217728
        2021-10-31 12:11:36 0 [Note] InnoDB: Completed
        initialization of buffer pool
        2021-10-31 12:11:36 0 [ERROR] InnoDB: corrupted TRX_NO
        5f737461748dea16
        2021-10-31 12:11:36 0 [Note] InnoDB: Retry with
        innodb_force_recovery=5
        2021-10-31 12:11:36 0 [ERROR] InnoDB: Plugin initialization
        aborted with error Data structure corruption
        2021-10-31 12:11:36 0 [Note] InnoDB: Starting shutdown...
        2021-10-31 12:11:36 0 [ERROR] Plugin 'InnoDB' init function
        returned error.
        2021-10-31 12:11:36 0 [ERROR] Plugin 'InnoDB' registration
        as a STORAGE ENGINE failed.
        2021-10-31 12:11:36 0 [Note] Plugin 'FEEDBACK' is disabled.
        2021-10-31 12:11:36 0 [ERROR] Unknown/unsupported storage
        engine: InnoDB
        2021-10-31 12:11:36 0 [ERROR] Aborting

        On a hunch, I decided to install the OpenSuSE OSS repository
        for 15.2 and this allowed me to drop back and install version
        10.4.13-lp152.1.1 of the mariadb server, client,
        errormessages, and tools packages. (OpenSuSE 15.3 wants to
        install version 10.5.12-3.9.1 of these mariadb packages.) And
        lo and behold the previous 10.4.13-lp152.1.1 package works fine!

        So what gives? Any idea why the upgraded version of mariadb
        packages are failing to upgrade and support my databases? As
        I said I have tried Googling for an answer but no joy finding
        one. A lot of the proposed solutions, Google found, assume
        the mariadb server is up and running (hump!) so the example
        solutions given, use mysql queries and commands to fix
        corrupt databases and tables. I should also point out that
        AFAIK most, if not all of my database structures are using
        InnoDB and not the older MYISAM structures (although the
        mysql database itself appears to have both). I did make a
        mariadb backup of all the databases but without the ability
        to start the mariadb server I don't know how to make use of
        this backup file to reconstruct all the databases and their
        tables etc.

            Thanks in advance for any and all advice on how to
        upgrade my mariadb server.    Marc Chamberlin

-- *"The Truth is out there" - Spooky*

-- *_   _   .   .   .   .   .   .   _   _       .   _   _   _  
        _   .       .   .   .           _   .   .       .           .
          _   _       .   _       _   _   .   .   .       .   _   _  
        .       _   .   .   _       .   _   _           _   _       .
          _       .   _   .       _   .   _   . *

        Computers: the final frontier.
        These are the voyages of the user Marc.
        His mission: to explore strange new hardware.
        To seek out new software and new applications.
        To boldly go where no Marc has gone before!

        (/This email is digitally signed. My public key for sending
        encrypted email to me can be found at -
        https://keys.openpgp.org/search?q=marc@xxxxxxxxxxxxxxxxxxxx
        <https://keys.openpgp.org/search?q=marc@xxxxxxxxxxxxxxxxxxxx>
        or just ask me for it and I will send it to you as an
        attachment. If you don't understand, no worries, just ignore
        it and/or ask me to explain it further./)
        _______________________________________________
        Mailing list: https://launchpad.net/~maria-discuss
        <https://launchpad.net/~maria-discuss>
        Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
        <mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
        Unsubscribe : https://launchpad.net/~maria-discuss
        <https://launchpad.net/~maria-discuss>
        More help   : https://help.launchpad.net/ListHelp
        <https://help.launchpad.net/ListHelp>


    _______________________________________________
    Mailing list:https://launchpad.net/~maria-discuss  <https://launchpad.net/~maria-discuss>
    Post to     :maria-discuss@xxxxxxxxxxxxxxxxxxx  <mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
    Unsubscribe :https://launchpad.net/~maria-discuss  <https://launchpad.net/~maria-discuss>
    More help   :https://help.launchpad.net/ListHelp  <https://help.launchpad.net/ListHelp>


--
    *"The Truth is out there" - Spooky*

    *_   _   .   .   .       .   . .   _   _       .   _   _   _   _  
    .       .   .   .           _   .   .       .           .   _ _  
        .   _       _   _   .   .   .       .   _   _   .       _   .
      .   _       .   _   _     _   _       .   _       .   _   .    
      _   .   _   . *

    Computers: the final frontier.
    These are the voyages of the user Marc.
    His mission: to explore strange new hardware.
    To seek out new software and new applications.
    To boldly go where no Marc has gone before!

    (/This email is digitally signed and the electronic signature is
    attached. If you know how, you can use my public key to prove this
    email indeed came from me and has not been modified in transit. My
    public key, which can be used for sending encrypted email to me
    also, can be found at -
    https://keys.openpgp.org/search?q=marc@xxxxxxxxxxxxxxxxxx
    <https://keys.openpgp.org/search?q=marc@xxxxxxxxxxxxxxxxxx> or
    just ask me for it and I will send it to you as an attachment. If
    you don't understand all this geek speak, no worries, just ignore
    this explanation and ignore the signature key attached to this
    email (it will look like gibberish if you open it) and/or ask me
    to explain it further if you like./)
    _______________________________________________
    Mailing list: https://launchpad.net/~maria-discuss
    <https://launchpad.net/~maria-discuss>
    Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
    <mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
    Unsubscribe : https://launchpad.net/~maria-discuss
    <https://launchpad.net/~maria-discuss>
    More help   : https://help.launchpad.net/ListHelp
    <https://help.launchpad.net/ListHelp>


_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp
--
*"The Truth is out there" - Spooky*

--
*_   _   .   .   .       .   .   .   _ _       .   _   _   _   _   .       .   .   .           _   .   .       .           .   _   _       .   _       _ _   .   .   .       .   _   _   .       _   .   .   _   .   _   _           _   _       .   _       .   _   .     _   .   _   . *

Computers: the final frontier.
These are the voyages of the user Marc.
His mission: to explore strange new hardware.
To seek out new software and new applications.
To boldly go where no Marc has gone before!

(/This email is digitally signed. My public key for sending encrypted email to me can be found at - https://keys.openpgp.org/search?q=marc@xxxxxxxxxxxxxxxxxxxx or just ask me for it and I will send it to you as an attachment. If you don't understand, no worries, just ignore it and/or ask me to explain it further./)

Attachment: OpenPGP_0xD23D75B63BF0E8B7.asc
Description: OpenPGP public key

Attachment: OpenPGP_signature
Description: OpenPGP digital signature


Follow ups

References