[mythtv-users] Mythmusic fail

[Bob Sully]

On Tue, 1 Nov 2022 23:37:36 -0700, you wrote:

>>For the past seven or eight times I have opened mythfrontend, it has asked
>>me to upgrade the music database schema.  Each time I have allowed it to
>>upgrade, but it apparently doesn't "take".

>If you tell it to do the database upgrade, it should automatically do
>a database backup first.  If your database is very large, that can
>take a long time, and in the past, that has fooled people into
>thinking that mythfrontend was not working and they have killed it and
>restarted it, then said no to the upgrade question.  My database now
>takes at least 20 minutes to do a backup (it is around 19 Gbytes).

>To see what is happening, before you say yes to the upgrade question,
>do this:

>cd /var/log/mythtv
>tail -f mythfrontend.log

>You should see messages about the database backup and upgrade process.
>Hopefully, there will be some clues as to why it does not work
Thanks, Steve, much appreciated.

Here are the pertinent lines from the log.  It looks like there is at least
one table missing.  Unfortunately, I don't have database backups going far
enough back (before the problem began) to have an idea as to what to repair.
Any advice appreciated.

Also - why does Mythweb depend on Mythmusic to work?  The browser can't
connect - looks like more of a web-server (Apache2)  issue to me, but I'm
not the Myth expert!

Oct 30 16:04:46 vader mythfrontend.real: mythfrontend[7886]: E CoreContext
dbcheckcommon.cpp:95 (performUpdateSeries) DB Error (Performing MythMusic
database upgrade): #012Query was: ALTER TABLE music_albumart DEFAULT
CHARACTER SET utf8; #012Error was: Driver error was [2/1146]:#012QMYSQL:
Unable to execute query#012Database error was:#012Table
'mythconverg.music_albumart' doesn't exist
Oct 30 16:04:46 vader mythfrontend.real: mythfrontend[7886]: E CoreContext
musicdbcheck.cpp:77 (UpgradeMusicDatabaseSchema) Database schema upgrade
failed.
Oct 30 16:04:46 vader mythfrontend.real: mythfrontend[7886]: E CoreContext
main.cpp:885 (mythplugin_init) Couldn't upgrade music database schema,
exiting.
Oct 30 16:04:46 vader mythfrontend.real: mythfrontend[7886]: E CoreContext
mythplugin.cpp:140 (init_plugin) Unable to initialize plugin 'mythmusic'.
Oct 30 16:19:44 vader mythfrontend.real: mythfrontend[16429]: E CoreContext
dbcheckcommon.cpp:95 (performUpdateSeries) DB Error (Performing MythMusic
database upgrade): #012Query was: ALTER TABLE music_albumart DEFAULT
CHARACTER SET utf8; #012Error was: Driver error was [2/1146]:#012QMYSQL:
Unable to execute query#012Database error was:#012Table
'mythconverg.music_albumart' doesn't exist
Oct 30 16:19:44 vader mythfrontend.real: mythfrontend[16429]: E CoreContext
musicdbcheck.cpp:77 (UpgradeMusicDatabaseSchema) Database schema upgrade
failed.
Oct 30 16:19:44 vader mythfrontend.real: mythfrontend[16429]: E CoreContext
main.cpp:885 (mythplugin_init) Couldn't upgrade music database schema,
exiting.
Oct 30 16:19:44 vader mythfrontend.real: mythfrontend[16429]: E CoreContext
mythplugin.cpp:140 (init_plugin) Unable to initialize plugin 'mythmusic'.
Nov  1 23:22:01 vader mythfrontend.real: mythfrontend[1073105]: E
CoreContext dbcheckcommon.cpp:95 (performUpdateSeries) DB Error (Performing
MythMusic database upgrade): #012Query was: ALTER TABLE music_albumart
DEFAULT CHARACTER SET utf8; #012Error was: Driver error was
[2/1146]:#012QMYSQL: Unable to execute query#012Database error
was:#012Table 'mythconverg.music_albumart' doesn't exist
Nov  1 23:22:01 vader mythfrontend.real: mythfrontend[1073105]: E
CoreContext musicdbcheck.cpp:77 (UpgradeMusicDatabaseSchema) Database
schema upgrade failed.
Nov  1 23:22:01 vader mythfrontend.real: mythfrontend[1073105]: E
CoreContext main.cpp:885 (mythplugin_init) Couldn't upgrade music database
schema, exiting.
Nov  1 23:22:01 vader mythfrontend.real: mythfrontend[1073105]: E
CoreContext mythplugin.cpp:140 (init_plugin) Unable to initialize plugin
'mythmusic'.
Nov  2 20:18:38 vader mythfrontend.real: mythfrontend[1416244]: E
CoreContext main.cpp:885 (mythplugin_init) Couldn't upgrade music database
schema, exiting.
Nov  2 20:18:38 vader mythfrontend.real: mythfrontend[1416244]: E
CoreContext mythplugin.cpp:140 (init_plugin) Unable to initialize plugin
'mythmusic'.
-- 

*__________________________________*
*Bob Sully*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20221102/e5a93c25/attachment.htm>