PDA

View Full Version : another scanning issue



theStimmer
2007-12-18, 14:08
can anyone help with a sql error that is thrown when scanning...?

I'm currently running 6.5.5....I upgraded to see if it fixed this problem which started in 6.5.4 The scan populates the DB with most of the files...but no artwork...it appears that is has something to do with compiling the "various Artists" info. The tail of the log file is below:

2007-12-18 15:01:10.8496 -- VA postcheck for album 'Live at Budokan' (id: [57])
2007-12-18 15:01:12.9843 --- Album has composite artist '58'
2007-12-18 15:01:12.9856 --- Album has composite artist '58'
2007-12-18 15:01:12.9868 --- Album has composite artist '58'
2007-12-18 15:01:13.9881 --- Album has composite artist '58'
2007-12-18 15:01:13.9893 --- Album has composite artist '58'
2007-12-18 15:01:13.9906 --- Album has composite artist '58'
2007-12-18 15:01:13.9918 --- Album has composite artist '58'
2007-12-18 15:01:13.9930 --- Album has composite artist '58'
2007-12-18 15:01:13.9942 --- Album has composite artist '58'
2007-12-18 15:01:13.9953 --- Album has composite artist '58'
2007-12-18 15:01:13.9960 -- VA postcheck for album 'Chicago Transit Authority' (id: [58])
2007-12-18 15:01:13.0905 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_768_0.MYI' (Errcode: 13) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-12-18 15:01:13.0907 ERROR: Backtrace follows:

2007-12-18 15:01:13.0910 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 1: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 2: DBIx::Class::Storage::DBI::_select (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 3: DBIx::Class::Storage::DBI::Cursor::next (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/ResultSet.pm line 701)
frame 4: DBIx::Class::ResultSet::next (/<C:\Program Files\SlimServer\server\scanner.exe>Slim/Schema.pm line 1212)
frame 5: Slim::Schema::mergeVariousArtistsAlbums (/<C:\Program Files\SlimServer\server\scanner.exe>Slim/Music/Import.pm line 312)
frame 6: Slim::Music::Import::runScanPostProcessing (scanner.pl line 195)
frame 7: main::__ANON__ (/<C:\Program Files\SlimServer\server\scanner.exe>DBIx/Class/Schema.pm line 584)
frame 8: (eval) (/<C:\Program Files\SlimServer\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-12-18 15:01:13.2256 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_768_0.MYI' (Errcode: 13) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-12-18 15:01:13.2260 ERROR: Backtrace follows:

2007-12-18 15:01:13.2262 Backtrace:

frame 0: Slim::Schema::throw_exception (/<C:\Program Files\SlimServer\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-12-18 15:01:13.3173 forceCommit: syncing to the database.

Siduhe
2007-12-18, 14:20
DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_768_0.MYI' (Errcode: 13) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771

This error normally means that your onaccess virus scanner is preventing MySql from writing to a temp file. Can you set it to ignore *.myi and *.myd files? If not (Mcafee Home version for example) can you set your on-access scanner only to scan documents?

Then try a full clear and rescan again.

theStimmer
2007-12-19, 06:51
Thanks Siduhe,

I just got around to trying your suggestion and that did solve the problem.