PDA

View Full Version : Error: Can



rambeaux
2007-12-29, 19:15
In troubleshooting my lack of iTunes playlist transfer (I can now see them, but they don't seem to update with changes made in iTunes....) I see the following error in the debub mode of scanner.exe:

Can't create/write to file 'C:\WINDOWS\TEMP\#sql_6ac_0.MYD' (Errcode: 13) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

Most of the tips I saw involved antivirus programs, but I see no popup from McAfee showing the activity, which is what I would expect. There aren't any special permissions on the temp folder, so I'm wondering what's going on...

any clues?




C:\Documents and Settings\griffinb>"C:\Program Files\SlimServer\server\scanner.e
xe" --d_itunes --rescan
2007-12-29 17:54:21.4721 About to look for files in M:\iTunes
2007-12-29 17:54:21.5188 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-12-29 17:54:34.5000 Found 3 files in M:\iTunes
2007-12-29 17:54:36.0188 About to look for files in M:\iTunes
2007-12-29 17:54:36.0457 For files with extensions in: [(?i-xsm:\.(?:asf|wax|asx
|lnk|wpl|m3u|pls|xspf|cue|lnk)$)]
2007-12-29 17:54:52.4843 ERROR: Error executing 'SELECT me.id, me.url, me.conten
t_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timest
amp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audi
o_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, m
e.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, contributorTr
acks.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_6ac_0.MYD' (Errcode: 13) at C:\Program Files\SlimServ
er\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-12-29 17:54:52.8281 ERROR: Backtrace follows:

2007-12-29 17:54:52.8769 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\ser
ver\CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 2: DBIx::Class::Storage::DBI::_select (C:\Program Files\SlimServer\serv
er\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\s
canner.exe>Slim/Schema.pm line 1212)
frame 5: Slim::Schema::mergeVariousArtistsAlbums (/<C:\Program Files\SlimServ
er\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>DBI
x/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-29 17:54:53.4843 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.b
itrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian
, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.pl
aycount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.re
play_peak, contributorTracks.role, contributorTracks.contributor, contributorTra
cks.track FROM tracks me LEFT JOIN contributor_track contributorTracks ON ( cont
ributorTracks.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_6ac_0.MYD' (Errcode: 13) at C
:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-12-29 17:54:53.8232 ERROR: Backtrace follows:

2007-12-29 17:54:53.8719 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)

snarlydwarf
2007-12-29, 21:35
You wouldnt see a popup...

What happens is that an AV program will see you trying to access the file and will sneak itself in, "uhoh they are opening this, let me check it!" The AV program won't see a problem.... it won't detect something wrong with the MYD file... but mysql will.. it will be VERY annoyed that it cant open the file it asked to open, and it will abort.

So, yes, your problem still sounds like an AV scanner fiddling with files.

rambeaux
2007-12-30, 02:05
foo...

I didn't think this post went through here... looks like it did.

I can't see a way to filter files from the AV interference. My wife actually works on the McAfee product, and says it would pop up a warning.

??

I may see if I can kill this thread, since I managed to repost above...