← 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!

 

Failure of in-place upgrade between 10.5.11 and 10.5.12 sounds like a
_major_ bug.


On Thu, 25 Nov 2021, 21:59 Marc Chamberlin, <marc@xxxxxxxxxxxxxxxxxx> wrote:

> 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 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>
> 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>
>> 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
>>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~maria-discuss
>>> More help   : 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 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
>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : 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
> <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
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>

References