Mailing List Archive

MythMusic database upgrade failure
I've just upgraded from 0.21-fixes to 0.22-fixes. I guess that over the
last 4 years I've accumulated some cruft because each time I start the
frontend I get the following:

2009-11-13 12:26:50.471 Current MythMusic Schema Version
(MusicDBSchemaVer): 1013
2009-11-13 12:26:50.472 Timed out waiting.
2009-11-13 12:26:50.491 Backing up database with script:
'/usr/local/share/mythtv/mythconverg_backup.pl'
2009-11-13 12:27:08.702 Database Backup complete.
2009-11-13 12:27:08.713 Backed up database to file:
'/mnt/store/mythconverg-1244-20091113122650.sql.gz'
2009-11-13 12:27:22.344 Upgrading to MythMusic schema version 1014
2009-11-13 12:27:22.345 DB Error (Performing database upgrade):
Query was: DROP TABLE musicmetadata;
Error was: Driver error was [2/1051]:
QMYSQL3: Unable to execute statement
Database error was:
Unknown table 'musicmetadata'

new version: 1014

After this, I'm still unable to enter MythMusic

I'm quite happy to drop the music database tables to start from scratch,
if someone could tell me how to do that, as all my files have tags so
re-scanning shouldn't be a problem. I currently have the following tables:

ls music*
music_albumart.MYD music_albums.frm music_directories.MYI
music_playlists.MYD music_radios.frm
music_smartplaylist_items.MYI music_songs.MYD music_stats.frm
music_albumart.MYI music_artists.MYD music_directories.frm
music_playlists.MYI music_smartplaylist_categories.MYD
music_smartplaylist_items.frm music_songs.MYI
music_albumart.frm music_artists.MYI music_genres.MYD
music_playlists.frm music_smartplaylist_categories.MYI
music_smartplaylists.MYD music_songs.frm
music_albums.MYD music_artists.frm music_genres.MYI
music_radios.MYD music_smartplaylist_categories.frm
music_smartplaylists.MYI music_stats.MYD
music_albums.MYI music_directories.MYD music_genres.frm
music_radios.MYI music_smartplaylist_items.MYD
music_smartplaylists.frm music_stats.MYI


--
Robin Gilks



_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: MythMusic database upgrade failure [ In reply to ]
> I've just upgraded from 0.21-fixes to 0.22-fixes. I guess that over the
> last 4 years I've accumulated some cruft because each time I start the
> frontend I get the following:
>
> 2009-11-13 12:26:50.471 Current MythMusic Schema Version
> (MusicDBSchemaVer): 1013
> 2009-11-13 12:26:50.472 Timed out waiting.
> 2009-11-13 12:26:50.491 Backing up database with script:
> '/usr/local/share/mythtv/mythconverg_backup.pl'
> 2009-11-13 12:27:08.702 Database Backup complete.
> 2009-11-13 12:27:08.713 Backed up database to file:
> '/mnt/store/mythconverg-1244-20091113122650.sql.gz'
> 2009-11-13 12:27:22.344 Upgrading to MythMusic schema version 1014
> 2009-11-13 12:27:22.345 DB Error (Performing database upgrade):
> Query was: DROP TABLE musicmetadata;
> Error was: Driver error was [2/1051]:
> QMYSQL3: Unable to execute statement
> Database error was:
> Unknown table 'musicmetadata'
>
> new version: 1014
>
> After this, I'm still unable to enter MythMusic
>
> I'm quite happy to drop the music database tables to start from scratch,
> if someone could tell me how to do that, as all my files have tags so
> re-scanning shouldn't be a problem. I currently have the following tables:
>
> ls music*
> music_albumart.MYD music_albums.frm music_directories.MYI
> music_playlists.MYD music_radios.frm
> music_smartplaylist_items.MYI music_songs.MYD music_stats.frm
> music_albumart.MYI music_artists.MYD music_directories.frm
> music_playlists.MYI music_smartplaylist_categories.MYD
> music_smartplaylist_items.frm music_songs.MYI
> music_albumart.frm music_artists.MYI music_genres.MYD
> music_playlists.frm music_smartplaylist_categories.MYI
> music_smartplaylists.MYD music_songs.frm
> music_albums.MYD music_artists.frm music_genres.MYI
> music_radios.MYD music_smartplaylist_categories.frm
> music_smartplaylists.MYI music_stats.MYD
> music_albums.MYI music_directories.MYD music_genres.frm
> music_radios.MYI music_smartplaylist_items.MYD
> music_smartplaylists.frm music_stats.MYI
>

Found this which seems to have worked...

http://www.gossamer-threads.com/lists/mythtv/users/329920

Not sure what the warning below is all about though!

2009-11-13 14:43:30.207 Music Scanner - Discarding APIC frame with size
less than 100 bytes


--
Robin Gilks


_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: MythMusic database upgrade failure [ In reply to ]
On 11/12/2009 06:37 PM, Robin Gilks wrote:
> I've just upgraded from 0.21-fixes to 0.22-fixes. I guess that over the
> last 4 years I've accumulated some cruft because each time I start the
> frontend I get the following:
>
...
> 2009-11-13 12:27:22.345 DB Error (Performing database upgrade):
> Query was: DROP TABLE musicmetadata;
> Error was: Driver error was [2/1051]:
> QMYSQL3: Unable to execute statement
> Database error was:
> Unknown table 'musicmetadata'
>
> new version: 1014
>
> After this, I'm still unable to enter MythMusic
>
> I'm quite happy to drop the music database tables to start from scratch,
> if someone could tell me how to do that, as all my files have tags so
> re-scanning shouldn't be a problem. I currently have the following tables:
>

cat << "EOF" | mysql -umythtv -p mythconverg
DROP TABLE IF EXISTS musicmetadata;
DROP TABLE IF EXISTS musicplaylist;
DROP TABLE IF EXISTS smartplaylistcategory;
DROP TABLE IF EXISTS smartplaylist;
DROP TABLE IF EXISTS smartplaylistitem;
DROP TABLE IF EXISTS music_albums;
DROP TABLE IF EXISTS music_artists;
DROP TABLE IF EXISTS music_genres;
DROP TABLE IF EXISTS music_playlists;
DROP TABLE IF EXISTS music_songs;
DROP TABLE IF EXISTS music_stats;
DROP TABLE IF EXISTS music_smartplaylists;
DROP TABLE IF EXISTS music_smartplaylist_items;
DROP TABLE IF EXISTS music_smartplaylist_categories;
DROP TABLE IF EXISTS music_directories;
DROP TABLE IF EXISTS music_albumart;
DELETE FROM settings WHERE value = 'MusicDBSchemaVer';
EOF

then restart mythfrontend.

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: MythMusic database upgrade failure [ In reply to ]
> On 11/12/2009 06:37 PM, Robin Gilks wrote:
>> I've just upgraded from 0.21-fixes to 0.22-fixes. I guess that over the
>> last 4 years I've accumulated some cruft because each time I start the
>> frontend I get the following:
>>
> ...
>> 2009-11-13 12:27:22.345 DB Error (Performing database upgrade):
>> Query was: DROP TABLE musicmetadata;
>> Error was: Driver error was [2/1051]:
>> QMYSQL3: Unable to execute statement
>> Database error was:
>> Unknown table 'musicmetadata'
>>
>> new version: 1014
>>
>> After this, I'm still unable to enter MythMusic
>>
>> I'm quite happy to drop the music database tables to start from scratch,
>> if someone could tell me how to do that, as all my files have tags so
>> re-scanning shouldn't be a problem. I currently have the following
>> tables:
>>
>
> cat << "EOF" | mysql -umythtv -p mythconverg
> DROP TABLE IF EXISTS musicmetadata;
> DROP TABLE IF EXISTS musicplaylist;
> DROP TABLE IF EXISTS smartplaylistcategory;
> DROP TABLE IF EXISTS smartplaylist;
> DROP TABLE IF EXISTS smartplaylistitem;
> DROP TABLE IF EXISTS music_albums;
> DROP TABLE IF EXISTS music_artists;
> DROP TABLE IF EXISTS music_genres;
> DROP TABLE IF EXISTS music_playlists;
> DROP TABLE IF EXISTS music_songs;
> DROP TABLE IF EXISTS music_stats;
> DROP TABLE IF EXISTS music_smartplaylists;
> DROP TABLE IF EXISTS music_smartplaylist_items;
> DROP TABLE IF EXISTS music_smartplaylist_categories;
> DROP TABLE IF EXISTS music_directories;
> DROP TABLE IF EXISTS music_albumart;
> DELETE FROM settings WHERE value = 'MusicDBSchemaVer';
> EOF
>
> then restart mythfrontend.

That certainly got things running but does the new version 0.22 only look
for new version tags? Some of my stuff that I ripped 7-8 years ago isn't
being entered into the database correctly (it all ends up in unknown) but
recently ripped stuff is OK. Is there some way I can read the old
music_songs table into the database without getting into a mess with the
other tables?


--
Robin Gilks


_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: MythMusic database upgrade failure [ In reply to ]
On 11/12/2009 10:02 PM, Robin Gilks wrote:
> That certainly got things running but does the new version 0.22 only look
> for new version tags? Some of my stuff that I ripped 7-8 years ago isn't
> being entered into the database correctly (it all ends up in unknown) but
> recently ripped stuff is OK. Is there some way I can read the old
> music_songs table into the database without getting into a mess with the
> other tables?
>

Might be better off looking for some kind of tag editor/updater. If all
the data is in the tags, but the wrong format, it seems it would be
possible to script a fix for it (given the right tool--which someone who
knows a thing or 2 about music tags will have to help you find, as I
don't know anything).

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users