[mythtv-users] Mythmusic fail

[Bob Sully]

Hi, Stephen -

Following your instructions in the previous message:[rcs at vader: ~]$
sudo mysql mythconverg -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
...
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2307
Server version: 8.0.31-0ubuntu0.22.04.1 (Ubuntu)
...
mysql> drop table if exists music_albumart;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> source /home/rcs/music_albumart.sql;  <-- this is what I called the
dump from your database
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1813 (HY000): Tablespace '`mythconverg`.`music_albumart`' exists.
Query OK, 0 rows affected (0.00 sec)
ERROR 1146 (42S02): Table 'mythconverg.music_albumart' doesn't exist
ERROR 1146 (42S02): Table 'mythconverg.music_albumart' doesn't exist
ERROR 1146 (42S02): Table 'mythconverg.music_albumart' doesn't exist
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> \q
Bye

This didn't go according to plan.
The frontend did ask the question about upgrading the schema again, which
it had stopped doing for a while.

However, the log shows that the table was not re-created:

Nov  5 22:44:22 vader mythfrontend.real: mythfrontend[2578611]: I
CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version
(DBSchemaVer): 1376
Nov  5 22:44:23 vader mythfrontend.real: mythfrontend[2578611]: N
CoreContext mythmainwindow.cpp:1478 (RegisterMediaPlugin) Registering
Internal as a media playback plugin.
Nov  5 22:44:23 vader mythfrontend.real: mythfrontend[2578611]: A
CoreContext mediamonitor-unix.cpp:209 (CheckMountable)
MMUnix:CheckMountable: DBus interface error: The name
org.freedesktop.UDisks was not provided by any .service files
Nov  5 22:44:23 vader mythfrontend.real: mythfrontend[2578611]: W
CoreContext mediamonitor-unix.cpp:217 (CheckMountable) MMUnix:UDisks2
service found. Media Monitor does not support this yet!
Nov  5 22:44:23 vader mythfrontend.real: mythfrontend[2578611]: I
CoreContext mythtranslation.cpp:62 (load) Loading en_us translation for
module mytharchive
Nov  5 22:44:23 vader mythfrontend.real: mythfrontend[2578611]: N
CoreContext mythmainwindow.cpp:1478 (RegisterMediaPlugin) Registering
WebBrowser as a media playback plugin.
Nov  5 22:44:23 vader mythfrontend.real: mythfrontend[2578611]: I
CoreContext mythtranslation.cpp:62 (load) Loading en_us translation for
module mythbrowser
Nov  5 22:44:23 vader mythfrontend.real: mythfrontend[2578611]: I
CoreContext mythtranslation.cpp:62 (load) Loading en_us translation for
module mythgame
Nov  5 22:44:23 vader mythfrontend.real: mythfrontend[2578611]: I
CoreContext schemawizard.cpp:117 (Compare) Current MythMusic Schema Version
(MusicDBSchemaVer): 1024
Nov  5 22:44:23 vader mythfrontend.real: mythfrontend[2578611]: E
CoreContext dbutil.cpp:599 (DoBackup) Backing up database with script:
'/usr/share/mythtv/mythconverg_backup.pl'
Nov  5 22:44:35 vader mythfrontend.real: mythfrontend[2578611]: C
CoreContext dbutil.cpp:621 (DoBackup) Database Backup complete.
Nov  5 22:44:35 vader mythfrontend.real: mythfrontend[2578611]: C
CoreContext dbutil.cpp:651 (DoBackup) Backed up database to file:
'/misc/dbbackup/mythconverg-1376-20221106054423.sql.gz'
Nov  5 22:44:35 vader mythfrontend.real: mythfrontend[2578611]: I
CoreContext bonjourregister.cpp:117 (BonjourCallback) Bonjour: Service
registration complete: name 'Mythfrontend on vader' type
'_mythfrontend._tcp.' domain: 'local.'
Nov  5 22:45:35 vader mythfrontend.real: mythfrontend[2578611]: C
CoreContext dbcheckcommon.cpp:119 (performActualUpdate) Upgrading to
MythMusic schema version 1025
Nov  5 22:45:35 vader mythfrontend.real: mythfrontend[2578611]: 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  5 22:45:35 vader mythfrontend.real: mythfrontend[2578611]: E
CoreContext musicdbcheck.cpp:77 (UpgradeMusicDatabaseSchema) Database
schema upgrade failed.
Nov  5 22:45:35 vader mythfrontend.real: mythfrontend[2578611]: E
CoreContext main.cpp:885 (mythplugin_init) Couldn't upgrade music database
schema, exiting.
Nov  5 22:45:35 vader mythfrontend.real: mythfrontend[2578611]: E
CoreContext mythplugin.cpp:140 (init_plugin) Unable to initialize plugin
'mythmusic'.

Scratching my head.
What's next?
Thanks!
*__________________________________*
*Bob Sully*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20221106/5389980c/attachment.htm>