Mailing List Archive: Recently MythTV says it needs to upgrade databases on every restart?

Recently MythTV says it needs to upgrade databases on every restart?

Mar 26, 2024, 4:53 PM

Post #1 of 4 (70 views)

G'day,

Re: mythbackend version: fixes/33 [v33.0+fixes.20230210.026e506-0ubuntu0]
www.mythtv.org

Just in the last few weeks, every time Mythfrontend restarts, it takes ages,
then says it wants to upgrade the mythconverg database from 1001 to 1025. I
always allow it to, and it mentions the backup, then proceeds normally.

On the next restart, it does the same.

Is the upgrade not working?

Hmm, my MythTV version is looking a bit old.

thanks,
-kt

_______________________________________________
mythtv-dev mailing list
mythtv-dev@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-dev
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org

Re: Recently MythTV says it needs to upgrade databases on every restart? [ In reply to ]

oliver.greg at gmail

Mar 27, 2024, 6:47 AM

Post #2 of 4 (70 views)

Permalink

On Tue, Mar 26, 2024 at 6:55?PM Kingsley Turner <krt@krt.com.au> wrote:

> G'day,
>
> Re: mythbackend version: fixes/33 [v33.0+fixes.20230210.026e506-0ubuntu0]
> www.mythtv.org
>
> Just in the last few weeks, every time Mythfrontend restarts, it takes
> ages,
> then says it wants to upgrade the mythconverg database from 1001 to 1025.
> I
> always allow it to, and it mentions the backup, then proceeds normally.
>
> On the next restart, it does the same.
>
> Is the upgrade not working?
>
> Hmm, my MythTV version is looking a bit old.
>
> thanks,
> -kt
>

Sounds like you probably have a corrupt MySQL table somewhere. Look into
the `mysqlcheck' program.

Re: Recently MythTV says it needs to upgrade databases on every restart? [ In reply to ]

krt at krt

Mar 27, 2024, 12:35 PM

Post #3 of 4 (70 views)

Permalink

On 28/3/24 00:47, Greg Oliver wrote:
> On Tue, Mar 26, 2024 at 6:55?PM Kingsley Turner <krt@krt.com.au> wrote:
>
> G'day,
>
> Re: mythbackend version: fixes/33 [v33.0+fixes.20230210.026e506-0ubuntu0]
> www.mythtv.org <http://www.mythtv.org>
>
> Just in the last few weeks, every time Mythfrontend restarts, it takes
> ages,
> then says it wants to upgrade the mythconverg database from 1001 to
> 1025. I
> always allow it to, and it mentions the backup, then proceeds normally.
>
> On the next restart, it does the same.
>
>
> Sounds like you probably have a corrupt MySQL table somewhere. Look into
> the `mysqlcheck' program.
>

G'day,

Thanks for the suggestion.

I ran:
# mysqlcheck --password=xxxxxxxx --user=mythtv mythconverg

And it reported:
mythconverg.archiveitems                           OK
mythconverg.bdbookmark                             OK
mythconverg.capturecard                            OK
...
mythconverg.websites                               OK

With every item marked "OK".

It doesn't look like it did anything other than report, but I'll restart it
to see.

thanks,
-kt

Re: Recently MythTV says it needs to upgrade databases on every restart? [ In reply to ]

keemllib at gmail

Mar 27, 2024, 1:26 PM

Post #4 of 4 (70 views)

Permalink

On Tuesday 26 March 2024 06:53:46 PM (-05:00), Kingsley Turner wrote:

> G'day,
>
> Re: mythbackend version: fixes/33
[v33.0+fixes.20230210.026e506-0ubuntu0]
> www.mythtv.org
>
> Just in the last few weeks, every time Mythfrontend restarts, it takes
ages,
> then says it wants to upgrade the mythconverg database from 1001 to
1025. I
> always allow it to, and it mentions the backup, then proceeds normally.
>
> On the next restart, it does the same.
>
> Is the upgrade not working?
>
> Hmm, my MythTV version is looking a bit old.
>
> thanks,
> -kt

Sounds like a very old issue with MusicDBSchemaVer. I recall that there was
a table missing so the DB update failed.

See if there's more information in the frontend log. Especially a line
containing:

ALTER TABLE music_SOMETHINGHERE

Maybe someone will remember the solution.
--
Bill
_______________________________________________
mythtv-dev mailing list
mythtv-dev@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-dev
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org