[mythtv-users] Mythmusic fail

[Stephen Worthington]

On Sun, 6 Nov 2022 20:58:15 -0800, you wrote:

>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.

That is definitely not what I expected.  Especially errors saying
first that music_albumart exists, and then that it does not exist!

Do you do daily the database check and repair?  (Do you have the
/etc/cron.daily/optimize_mythdb file?)  Try manually running that file
as root and check the results, to make sure the database is not
corrupt:

sudo /etc/cron.daily/optimize_mythdb

If you do not have it in /etc/cron.daily, then do this to install it:

sudo cp -av
/usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl
/etc/cron.daily/optimize_mythdb