PDA

View Full Version : Scanning problems



tim912
2006-10-17, 12:32
Since I upgraded to 6.5 when I scan my library the SlimServer gets to 19,632 songs and stops. I've used the debug info to detect the file that's causing the problem and have checked out the file with Foobar2000. It plays correctly and all the tags seem to be OK.

The problem appears to be something to do with the musicbrainz_id data being too long for the DB column. However this file does not contain any musicbrainz tags (and none of my other files do either). Can anyone help me here?

With --d_scan --d_server --d_info I get the following messages:

2006-10-17 17:48:07.7926 Starting music folder scan in \\musicserver\music
2006-10-17 17:48:07.7935 About to look for files in \\musicserver\music\
2006-10-17 17:48:07.7948 For files with extensions in: [(?i-xsm:\.(?:ape|wma|shn|wav|wave|mp3|mp2|flc|flac|m4a |mov|m4b|mp4|mp+|mpc|ogg|aif|aiff|lnk|cue)$)]

2006-10-17 18:38:29.1697 Found 19632 files in \\musicserver\music\
2006-10-17 18:38:29.2947 mp3 file type for file:////musicserver/music/Milla/The%20Divine%20Comedy/02%20-%20Gentleman%20Who%20Fell.mp3
2006-10-17 18:38:29.2995
2006-10-17 18:38:29.2998 newTrack(): New Track: [file:////musicserver/music/Milla/The%20Divine%20Comedy/02%20-%20Gentleman%20Who%20Fell.mp3]
2006-10-17 18:38:29.2999 newTrack(): readTags is 1
2006-10-17 18:38:29.3189 mp3 file type for \\musicserver\music\Milla\The Divine Comedy\02 - Gentleman Who Fell.mp3
2006-10-17 18:38:29.3193 Trying to load Slim::Formats::MP3
2006-10-17 18:38:29.7765 ERROR: Error executing 'INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, block_alignment, content_type, drm, filesize
, lossless, musicbrainz_id, rating, remote, samplerate, secs, tagversion, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?
, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)': DBD::mysql::st execute failed: Data too long for column 'musicbrainz_id' at row 1 at C:\PROGRA~1\
SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2006-10-17 18:38:29.7770 ERROR: Backtrace follows:

2006-10-17 18:38:29.7774 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 1: DBIx::Class::Storage::DBI::_execute (C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 788)
frame 2: DBIx::Class::Storage::DBI::insert (C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Row.pm line 75)
frame 3: DBIx::Class::Row::insert (C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
frame 4: DBIx::Class::PK::Auto::insert (C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/ResultSet.pm line 1335)
frame 5: DBIx::Class::ResultSet::create (/PerlApp/Slim/Schema.pm line 794)
frame 6: Slim::Schema::newTrack (/PerlApp/Slim/Schema.pm line 955)
frame 7: Slim::Schema::updateOrCreate (/PerlApp/Slim/Utils/Scanner.pm line 322)
frame 8: Slim::Utils::Scanner::scanDirectory (/PerlApp/Slim/Music/MusicFolderScan.pm line 72)
frame 9: Slim::Music::MusicFolderScan::startScan (/PerlApp/Slim/Music/Import.pm line 393)
frame 10: Slim::Music::Import::runImporter (/PerlApp/Slim/Music/Import.pm line 236)
frame 11: Slim::Music::Import::runScan (scanner.pl line 179)
frame 12: (eval) (scanner.pl line 173)
frame 13: main::main (scanner.pl line 330)

2006-10-17 18:38:29.8103 ERROR: Scanner: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'INSERT INTO tracks (audio, audio_offset,
audio_size, bitrate, block_alignment, content_type, drm, filesize, lossless, musicbrainz_id, rating, remote, samplerate, secs, tagversion, timestamp, title
, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)': DBD::mysql::st execute failed: D
ata too long for column 'musicbrainz_id' at row 1 at C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
]

2006-10-17 18:38:29.8110 ERROR: Scanner: Skipping post-process & Not updating lastRescanTime!

2006-10-17 18:38:29.8119 Got to the END.
2006-10-17 18:38:29.8122 Got sigint.
2006-10-17 18:38:29.8123 SlimServer cleaning up.
2006-10-17 18:38:29.8174 forceCommit: syncing to the database.

kyleki
2006-10-17, 14:58
This looks to be the same thing I've been discussing in this thread:
http://forums.slimdevices.com/showthread.php?t=28674

I found that slimserver didn't like any info in the Comments tag (not sure if it was id3v1 or id3v2 since I cleared both versions on my troublesome files). I would look at the tags in \\musicserver\music\Milla\The Divine Comedy\02 - Gentleman Who Fell.mp3 and see if anything looks "fishy" and clean it up. If nothing looks strange, write down the tag information you want to preserve, clear the tag, and re-apply it. Sometimes the tags get corrupted.

The fact that Slimserver is crashing on these files is, as pointed out in the above mentioned thread, a bug. At least changing your tags on these few files that cause a crash is a workaround for now.

It worked for me anyway...

zulu
2006-10-18, 02:28
I had a similar problem where I had a tag called "ID" and that threw the scanner off.