Empty play lists -- scan issues?

[eschurr]

I'm using SqueezeCenter 7.3.3 on XP with iTunes. I have my rescan set to run once/day at night. In the mornings when i try to play a playlist, SC often tells me the playlist is empty (but clearly it is not empty in iTunes). If i manually force a rescan, everything is ok. the odd thing is that the problem doesn't happen all the time, and i can't find any pattern to why it happens when it does.

i've searched the forums for related issues and can't find much. i did find something awhile ago about Macafee, and i changed my registry settings as instructed, which fixed another problem but this problem still occurs sporadically.

Any ideas?

[eschurr]

no one has answered this, but perhaps this may give someone enough info to answer.

the info from my scan log file for my last scan says (and this occurs for all of my scans). It seems that i commonly have this error:

Can't create/write to file 'C:\Documents and Settings\All Users\Application Data\SqueezeCenter\Cache\MySQL\#sql_928_0.MYD'

Here's the log file:
**************************************************

[09-11-16 11:00:07.5312] main::main (122) Starting SqueezeCenter scanner (v7.3.3, r27044, Mon Jun 15 15:14:08 PDT 2009)
[09-11-16 11:03:33.0004] Slim::Schema::Storage::throw_exception (81) 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.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.lossless, me.lyrics, me.replay_gain, me.replay_peak, me.extid, 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:\Documents and Settings\All Users\Application Data\SqueezeCenter\Cache\MySQL\#sql_928_0.MYD' (Errcode: 13) at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771.
[09-11-16 11:03:33.0012] Slim::Schema::Storage::throw_exception (81) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 81)
frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 773)
frame 2: DBIx::Class::Storage:BI::_execute (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 826)
frame 3: DBIx::Class::Storage:BI::_select (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 4: DBIx::Class::Storage:BI::Cursor::next (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/ResultSet.pm line 703)
frame 5: DBIx::Class::ResultSet::next (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1443)
frame 6: Slim::Schema::mergeVariousArtistsAlbums (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 375)
frame 7: Slim::Music::Import::runScanPostProcessing (scanner.pl line 243)
frame 8: main::__ANON__ (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Schema.pm line 584)
frame 9: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Schema.pm line 572)
frame 10: DBIx::Class::Schema::txn_do (scanner.pl line 243)
frame 11: (eval) (scanner.pl line 243)
frame 12: main::main (scanner.pl line 371)

[09-11-16 11:03:33.0034] Slim::Schema::throw_exception (288) 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.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.lossless, me.lyrics, me.replay_gain, me.replay_peak, me.extid, 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:\Documents and Settings\All Users\Application Data\SqueezeCenter\Cache\MySQL\#sql_928_0.MYD' (Errcode: 13) at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771.
[09-11-16 11:03:33.0045] Slim::Schema::throw_exception (288) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 288)
frame 1: Slim::Schema::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Schema.pm line 606)
frame 2: DBIx::Class::Schema::txn_do (scanner.pl line 243)
frame 3: (eval) (scanner.pl line 243)
frame 4: main::main (scanner.pl line 371)

[eschurr]

i'll add more to this thread (although i'm the only one on it): what baffles me is that sometime the playlists are empty and sometimes they aren't. My scan runs every morning at 5 am -- sometimes the playlists are properly populated, but other times they are empty. Usually if i do a manual rescan of playlists, they populate properly.

why sometimes and not others? Huh?

[Mnyb]

no one has answered this, but perhaps this may give someone enough info to answer.

the info from my scan log file for my last scan says (and this occurs for all of my scans). It seems that i commonly have this error:

Can't create/write to file 'C:\Documents and Settings\All Users\Application Data\SqueezeCenter\Cache\MySQL\#sql_928_0.MYD'

Your antivirus is messing it up for you.
MySQL (the database ) can not always create files or tempfiles. then it crashes

Make exceptions for *.MYD and *.MYI files

Have you upgraded to MSE lately ?
what antivirus do you have ?

[eschurr]

thanks. I'm using MSE on Win7 64bit.

i just set it to ignore files of type .MYD and .MYI files (should i be ignoring any processes, too?)

let's see if that helps.

[Mnyb]

thanks. I'm using MSE on Win7 64bit.

i just set it to ignore files of type .MYD and .MYI files (should i be ignoring any processes, too?)

let's see if that helps.

No it won't help use the search function hence my jibe at MSE.
MSE bug's are well covered in other treads, it has been discussed at length in this forum for at least 3-4 months.
MSE has a bug where it will not honor these settings.

You have to turn of real-time protection, but that lowers the security level quite a bit (and may not work anyway)

So you may as well look at other alternatives for antivirus.

Again search this forum re experiences with other antivirus software.
There is useful workarounds for many of them on this site.

What is happening is that almost all antivirus software thinks that MySQL is a virus, almost every "scanner does not..." tread for the last 2 years is about this.