PDA

View Full Version : Scanner Trouble - Zero Artists



fuzzyT
2007-08-14, 18:28
My scanner process seems to be dying before it can update the artist
info in the slimserver database. The result is that I end up with
Library Stats that read: "4642 albums with 67754 songs by 0 artists",
and no listing under the Artist browse interfaces.

This started maybe a month ago. Everything is fine otherwise. AFAICT
this only occurs under rescans. Full wipe+scan requests have finished
normally so far.

The server is a Core2Duo 2.2GHz box with 2GB of RAM. No big software,
load or config changes recently.

Was running SS 6.5.3, upgraded to a more recent version to see if issue
would resolve, but it didn't.

SlimServer Version: 6.5.4 - 12553 - Windows XP - EN - cp1252
Server IP address: 192.168.0.100
Perl Version: 5.8.8 MSWin32-x86-multi-thread
MySQL Version: 5.0.22-community-nt

Some scanner logs are copied below, but I think the salient entry is:

Can't create/write to file 'C:\WINDOWS\TEMP\#sql_99c_0.MYI'

SlimServer is configured to run under the local SYSTEM account, which
has read/write/delete permissions to that directory. Plenty of room on
the disk.

Any ideas?

Thanks,

--rt

2007-08-14 20:32:08.3399 For files with extensions in:
[(?i-xsm:\.(?:ape|wma|shn|wav|wave|mp3|mp2|flc|flac|fla |m4a|mov|m4b|mp4|mp+|mpc|ogg|aif|aiff|lnk|cue)$)]
2007-08-14 20:34:23.2031 Import: Completed Slim::Music::MusicFolderScan
Scan in 134 seconds.
2007-08-14 20:34:23.2032 Import: Starting
Slim::Music::PlaylistFolderScan scan
2007-08-14 20:34:23.2035 About to look for files in G:\music\playlists
2007-08-14 20:34:23.2043 For files with extensions in:
[(?i-xsm:\.(?:asf|wax|asx|lnk|wpl|m3u|pls|xspf|cue|lnk) $)]
2007-08-14 20:34:34.0625 Import: Starting mergeVariousArtistsAlbums().
.................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. ........................................
.................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .........................................
.................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. .................................................. ............2007-08-14
20:42:58.8540 ERROR: Error executing 'SELECT me.id, me.url,
me.content_type, me.title, me.titlesort, me.titlesearch, me.album,
me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote,
me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover,
me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels,
me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm,
me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed,
me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak,
contributorTracks.role, contributorTracks.contributor,
contributorTracks.track FROM tracks me LEFT JOIN contributor_track
contributorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( (
contributorTracks.role = ? ) AND ( me.album = ? ) ) ) ORDER BY
contributorTracks.track': DBD::mysql::st execute failed: Can't
create/write to file 'C:\WINDOWS\TEMP\#sql_99c_0.MYI' (Errcode: 13) at
D:\server\slim\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-08-14 20:42:58.8541 ERROR: Backtrace follows:

2007-08-14 20:42:58.8544 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception
(D:\server\slim\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 1: DBIx::Class::Storage::DBI::_execute
(D:\server\slim\server\CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 2: DBIx::Class::Storage::DBI::_select
(D:\server\slim\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 3: DBIx::Class::Storage::DBI::Cursor::next
(D:\server\slim\server\CPAN/DBIx/Class/ResultSet.pm line 701)
frame 4: DBIx::Class::ResultSet::next
(/<D:\server\slim\server\scanner.exe>Slim/Schema.pm line 1212)
frame 5: Slim::Schema::mergeVariousArtistsAlbums
(/<D:\server\slim\server\scanner.exe>Slim/Music/Import.pm line 312)
frame 6: Slim::Music::Import::runScanPostProcessing (scanner.pl line
195)
frame 7: main::__ANON__
(/<D:\server\slim\server\scanner.exe>DBIx/Class/Schema.pm line 584)
frame 8: (eval)
(/<D:\server\slim\server\scanner.exe>DBIx/Class/Schema.pm line 572)
frame 9: DBIx::Class::Schema::txn_do (scanner.pl line 195)
frame 10: (eval) (scanner.pl line 195)
frame 11: main::main (scanner.pl line 314)

2007-08-14 20:42:58.8556 ERROR: Carp::Clan::__ANON__(): Error executing
'SELECT me.id, me.url, me.content_type, me.title, me.titlesort,
me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize,
me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset,
me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate,
me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm,
me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id,
me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating,
me.replay_gain, me.replay_peak, contributorTracks.role,
contributorTracks.contributor, contributorTracks.track FROM tracks me
LEFT JOIN contributor_track contributorTracks ON (
contributorTracks.track = me.id ) WHERE ( ( ( contributorTracks.role = ?
) AND ( me.album = ? ) ) ) ORDER BY contributorTracks.track':
DBD::mysql::st execute failed: Can't create/write to file
'C:\WINDOWS\TEMP\#sql_99c_0.MYI' (Errcode: 13) at
D:\server\slim\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-08-14 20:42:58.8557 ERROR: Backtrace follows:

2007-08-14 20:42:58.8558 Backtrace:

frame 0: Slim::Schema::throw_exception
(/<D:\server\slim\server\scanner.exe>DBIx/Class/Schema.pm line 606)
frame 1: DBIx::Class::Schema::txn_do (scanner.pl line 195)
frame 2: (eval) (scanner.pl line 195)
frame 3: main::main (scanner.pl line 314)

2007-08-14 20:42:59.1701 Got to the END.
2007-08-14 20:42:59.1702 Got sigint.
2007-08-14 20:42:59.1702 SlimServer scanner cleaning up.

JJZolx
2007-08-14, 18:38
Sounds like the scanner is choking on some piece of data, most likely something within a tag in one of the files that you added about a month ago. It must be happening during one of the final scanner passes that consolidates various artists or album artists or somesuch.

Try running the scan with d_import and d_scan, maybe also d_sql debugging flags enabled and you may be able to tell which file or bit of data is causing the crash.

Ron Stewart
2007-08-14, 19:01
This sounds like the same problem a few of us were discussing over in the Beginner's forum (http://forums.slimdevices.com/showthread.php?t=37579). You might want to try temporarily disabling your virus scanner (or adding exclusions as mentioned in the thread) to see if that helps.

Ron

fuzzyT
2007-08-14, 20:02
OK, I've added exclusions to the McAfee virus scanner for files with .myi and .myd extensions. Rescanning now with --d_import --d_server --d_scan flags.

Well, new error, some progress anyway. I think this could be caused by the state of the contributor data left over from the previous failure. Will do a complete wipe/rescan, then see what my scheduled incremental rescan does in the morning.

2007-08-14 22:54:15.2500 Couldn't execute SQL statement: [INSERT INTO contributor_album (role,contributor,album) SELECT DISTINCT role,contributor,album FROM contributor_track,tracks where tracks.id=contributor_track.track;] : [DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/contributor_album`, CONSTRAINT `contributor_album_ibfk_1` FOREIGN KEY (`album`) REFERENCES `albums` (`id`) ON DELETE CASCADE) at /<D:\server\slim\server\scanner.exe>Slim/Utils/SQLHelper.pm line 83, <$fh> line 36.
]

schatzy
2007-08-15, 13:17
fuzzyT,

Have you disable the MusicMagic plugin. I found that that caused all kinds of problems if there was a problem character in a filename or tag somewhere.

I went as far as to remove the plugin files to get it to work properly.

I proved this by reinstalling the plugin and doing a wipe and scan , again problems every time i ran a scan with the plugin there was a problem every time i had the plugin removed it worked fine.

slimpy
2007-08-16, 02:07
I had the same problem after I updated from 6.5.1 to 6.5.3.
Clear & rescan seemed to show a correct tracks, album and artist count. But it failed to recognize any various artist albums.
Look for new & updated left me with 0 artists.
I ran a full rescan from the command line with a couple of debugging switches.
It all came down to an mp3 that had "-" set as the artist. Somehow Slimserver choked and failed. Incidently this was on the second to last album in the scan process hence the seemingly correct stats after the scan.
I just changed the tag on the offending file, rescanned and all was well again.

-s.

fuzzyT
2007-08-16, 09:04
The MusicMagic plug-in has been and is disabled. I don't use it.

It's interesting that a string value in a tag field could crash the scanner. Did you file a bug on that? It would be good to do that and get a copy of the offending file to the engineering team.

I need to do some more logged runs of the incremental scan, but for now, it looks like the virus scanner was the issue. Not sure why writing to a temp directory tripped it, but adding the exclusion seemed to work.

I'll post again once I have more data.