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.
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
