[mythtv-users] Mariadb upgrade issues

[Larry Kennedy]

On Sat, Jun 24, 2023 at 1:14 PM Larry Kennedy <lunchtimelarry at gmail.com>
wrote:

>
>
> On Sat, Jun 24, 2023 at 1:02 PM Stephen Worthington <
> stephen_agent at jsw.gen.nz> wrote:
>
>> On Sat, 24 Jun 2023 11:50:10 -0400, you wrote:
>>
>> >All,
>> >
>> >I'm trying to patch my Ubuntu 20.04.5 backend and suddenly I'm going in
>> >circles on this well-documented mariadb upgrade issue.  No matter what I
>> >try to remove/purge, I get this:
>> >
>> >The following packages have unmet dependencies:
>> > mariadb-plugin-rocksdb : Depends: mariadb-server-10.3 (=
>> >1:10.3.38-0ubuntu0.20.04.1) but 1:10.3.34-0ubuntu0.20.04.1 is to be
>> >installed
>> > mariadb-plugin-tokudb : Depends: mariadb-server-10.3 (=
>> >1:10.3.38-0ubuntu0.20.04.1) but 1:10.3.34-0ubuntu0.20.04.1 is to be
>> >installed
>> > mariadb-test : Depends: mariadb-server-10.3 (=
>> 1:10.3.38-0ubuntu0.20.04.1)
>> >but 1:10.3.34-0ubuntu0.20.04.1 is to be installed
>> >                Depends: mariadb-test-data (= 1:10.3.38-0ubuntu0.20.04.1)
>> >but 1:10.3.37-0ubuntu0.20.04.1 is to be installed
>> >
>> >Is there anything that works to get rid of these packages so I can
>> continue
>> >accepting upgrades?  I've tried removing all of these one by one, as well
>> >as the reported dependencies such as mythtv.  Nothing is working.
>>
>> It looks like mariadb-plugin-tokudb is deprecated - there may not be a
>> version of that package any more - it is certainly gone in 22.04. That
>> sort of thing always causes problems.  What happens when you manually
>> remove it?
>>
>> apt remove mariadb-plugin-tokudb
>>
>
> Thanks for weighing in.  I get the same result on this one as the others:
>
> sudo apt remove mariadb-plugin-tokudb
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> You might want to run 'apt --fix-broken install' to correct these.
> The following packages have unmet dependencies:
>  mariadb-plugin-rocksdb : Depends: mariadb-server-10.3 (=
> 1:10.3.38-0ubuntu0.20.04.1) but 1:10.3.34-0ubuntu0.20.04.1 is to be
> installed
>  mariadb-test : Depends: mariadb-server-10.3 (=
> 1:10.3.38-0ubuntu0.20.04.1) but 1:10.3.34-0ubuntu0.20.04.1 is to be
> installed
>                 Depends: mariadb-test-data (= 1:10.3.38-0ubuntu0.20.04.1)
> but 1:10.3.37-0ubuntu0.20.04.1 is to be installed
> E: Unmet dependencies. Try 'apt --fix-broken install' with no packages (or
> specify a solution).
>
>

Solved!

I just noticed that when I ran apt --fix-broken install, it was complaining
that the mariadb.cnf was missing.  I simply touch-ed that file and the fix
seems to have worked.


>> In the dim distant past, I can remember having to remove all the
>> mariadb packages and everything that depended on them (including all
>> the mythtv packages), and then reinstalling everything (MariaDB
>> first).  That was when I was converting from using MySQL to MariaDB
>> but there was not a matching version between them (the base versions
>> were compatible, but the point releases were not).  Then I had to
>> restore the database from the backup as MariaDB could not work with
>> the existing MySQL version of the database due to the incompatible
>> versions.  You should not need to do a restore, but make sure you have
>> a full backup just in case.
>>
>
> For sure I made a backup before I started messing about with this.
>
>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://lists.mythtv.org/mailman/listinfo/mythtv-users
>> http://wiki.mythtv.org/Mailing_List_etiquette
>> MythTV Forums: https://forum.mythtv.org
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20230624/5cabaf18/attachment.htm>