PDA

View Full Version : Scan Problem in 7.3.3



brucegrr
2009-07-15, 20:11
I haven't had a problem with my Squeezebox in ages.

Suddenly I am having a problem with it completing a full scan. It "says" it is completed but it is not. (see graphic)

I tried scanning three times. Stalls on the same process but at a different place each time

The log shows the following:

[09-07-15 22:44:23.1550] main::main (122) Starting SqueezeCenter scanner (v7.3.3, r27044, Mon Jun 15 15:14:08 PDT 2009)
[09-07-15 23:05:48.4540] 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 'D:\ProgramData\SqueezeCenter\Cache\MySQL\#sql_8f8 _0.MYD' (Errcode: 13) at /<D:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771.
[09-07-15 23:05:48.4547] Slim::Schema::Storage::throw_exception (81) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/<D:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 81)
frame 1: Slim::Schema::Storage::throw_exception (/<D:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 773)
frame 2: DBIx::Class::Storage::DBI::_execute (/<D:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 826)
frame 3: DBIx::Class::Storage::DBI::_select (/<D:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 4: DBIx::Class::Storage::DBI::Cursor::next (/<D:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/ResultSet.pm line 703)
frame 5: DBIx::Class::ResultSet::next (/<D:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1443)
frame 6: Slim::Schema::mergeVariousArtistsAlbums (/<D:\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__ (/<D:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Schema.pm line 584)
frame 9: (eval) (/<D:\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-07-15 23:05:48.6114] 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 'D:\ProgramData\SqueezeCenter\Cache\MySQL\#sql_8f8 _0.MYD' (Errcode: 13) at /<D:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771.
[09-07-15 23:05:48.6119] Slim::Schema::throw_exception (288) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/<D:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 288)
frame 1: Slim::Schema::throw_exception (/<D:\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

Suggestions??

brucegrr
2009-07-15, 22:21
Fixed the problem.

Deleting the cache fixed the scanning problem.

wplate
2009-07-19, 09:33
I'm having scanning problems too, SqueezeCenter isn't finding any files in my library. I trashed the cache folder and restarted but still no joy. SqueezeCenter 7.3.3 on Mac OS X 10.5.7. My snippet of my log excerpt follows...







[09-04-12 11:56:21.2204] Slim::Plugin::iTunes::Importer::Artwork::OSX::expo rtSingleArtwork (107) Error: Error from artwork script: Error getting artwork: iTunes got an error: Parameter error.
[09-04-12 11:56:21.5490] Slim::Plugin::iTunes::Importer::Artwork::OSX::expo rtSingleArtwork (107) Error: Error from artwork script: Error getting artwork: iTunes got an error: Parameter error.
[09-04-12 11:56:21.8855] Slim::Plugin::iTunes::Importer::Artwork::OSX::expo rtSingleArtwork (107) Error: Error from artwork script: Error getting artwork: iTunes got an error: Parameter error.
[09-04-12 11:56:21.8896] Slim::Schema::throw_exception (229) Error: Can't update Slim::Schema::Progress=HASH(0x3865e04): row not found
[09-04-12 11:56:21.8902] Slim::Schema::throw_exception (229) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/Slim/Schema.pm line 229)
frame 1: Slim::Schema::throw_exception (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/Row.pm line 461)
frame 2: DBIx::Class::Row::throw_exception (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/Row.pm line 117)
frame 3: DBIx::Class::Row::update (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/Relationship/CascadeActions.pm line 30)
frame 4: DBIx::Class::Relationship::CascadeActions::update (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/InflateColumn.pm line 222)
frame 5: DBIx::Class::InflateColumn::update (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/Slim/Schema/DBI.pm line 35)
frame 6: Slim::Schema::DBI::update (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/Slim/Utils/Progress.pm line 164)
frame 7: Slim::Utils::Progress::update (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/Slim/Plugin/iTunes/Importer/Artwork.pm line 124)
frame 8: Slim::Plugin::iTunes::Importer::Artwork::startArtw orkScan (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/Slim/Music/Import.pm line 519)
frame 9: Slim::Music::Import::runArtworkImporter (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/Slim/Music/Import.pm line 392)
frame 10: Slim::Music::Import::runScanPostProcessing (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/scanner.pl line 235)
frame 11: main::__ANON__ (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/Schema.pm line 584)
frame 12: (eval) (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/Schema.pm line 572)
frame 13: DBIx::Class::Schema::txn_do (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/scanner.pl line 235)
frame 14: (eval) (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/scanner.pl line 235)
frame 15: main::main (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/scanner.pl line 363)

[09-04-12 11:56:22.2287] Slim::Plugin::iTunes::Importer::Artwork::OSX::expo rtSingleArtwork (107) Error: Error from artwork script: Error getting artwork: iTunes got an error: Parameter error.
[09-04-12 11:56:22.5601] Slim::Plugin::iTunes::Importer::Artwork::OSX::expo rtSingleArtwork (107) Error: Error from artwork script: Error getting artwork: iTunes got an error: Parameter error.
[09-04-12 11:56:22.5638] DBIx::Class::Storage::DBI::Cursor::next (90) Warning: Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at /Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 90.
[09-04-12 11:56:22.5673] Slim::Schema::throw_exception (229) Error: Can't update Slim::Schema::Progress=HASH(0x3865e04): row not found
[09-04-12 11:56:22.5679] Slim::Schema::throw_exception (229) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/Slim/Schema.pm line 229)
frame 1: Slim::Schema::throw_exception (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/Row.pm line 461)
frame 2: DBIx::Class::Row::throw_exception (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/Row.pm line 117)
frame 3: DBIx::Class::Row::update (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/Relationship/CascadeActions.pm line 30)
frame 4: DBIx::Class::Relationship::CascadeActions::update (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/InflateColumn.pm line 222)
frame 5: DBIx::Class::InflateColumn::update (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/Slim/Schema/DBI.pm line 35)
frame 6: Slim::Schema::DBI::update (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/Slim/Utils/Progress.pm line 195)
frame 7: Slim::Utils::Progress::final (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/Slim/Plugin/iTunes/Importer/Artwork.pm line 127)
frame 8: Slim::Plugin::iTunes::Importer::Artwork::startArtw orkScan (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/Slim/Music/Import.pm line 519)
frame 9: Slim::Music::Import::runArtworkImporter (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/Slim/Music/Import.pm line 392)
frame 10: Slim::Music::Import::runScanPostProcessing (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/scanner.pl line 235)
frame 11: main::__ANON__ (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/Schema.pm line 584)
frame 12: (eval) (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/Schema.pm line 572)
frame 13: DBIx::Class::Schema::txn_do (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/scanner.pl line 235)
frame 14: (eval) (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/scanner.pl line 235)
frame 15: main::main (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/scanner.pl line 363)

[09-04-12 11:57:31.9814] DBIx::Class::Storage::DBI::txn_commit (706) Warning: commit ineffective with AutoCommit enabled at /Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 706.
[09-04-12 11:57:31.9817] DBIx::Class::Storage::DBI::txn_commit (706) Warning: Commmit ineffective while AutoCommit is on at /Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 706.
[09-04-12 11:57:31.9822] Slim::Schema::throw_exception (229) Error: DBD::mysql::db commit failed: Commmit ineffective while AutoCommit is on at /Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 706.
[09-04-12 11:57:31.9824] Slim::Schema::throw_exception (229) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/Slim/Schema.pm line 229)
frame 1: Slim::Schema::throw_exception (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Class/Schema.pm line 606)
frame 2: DBIx::Class::Schema::txn_do (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/scanner.pl line 235)
frame 3: (eval) (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/scanner.pl line 235)
frame 4: main::main (/Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/scanner.pl line 363)

[09-07-18 20:39:11.3757] main::main (122) Starting SqueezeCenter scanner (v7.3.3, r27044, Mon Jun 15 14:51:57 PDT 2009)
[09-07-18 20:40:06.2175] main::main (237) Error: Failed when running main scan: [spec is not a valid file specification at /Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/Slim/Utils/OS/OSX.pm line 300.
]
[09-07-18 20:40:06.2177] main::main (238) Error: Skipping post-process & Not updating lastRescanTime!
[09-07-18 20:58:49.7922] main::main (122) Starting SqueezeCenter scanner (v7.3.3, r27044, Mon Jun 15 14:51:57 PDT 2009)
[09-07-18 20:59:05.5240] main::main (237) Error: Failed when running main scan: [spec is not a valid file specification at /Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/Slim/Utils/OS/OSX.pm line 300.
]
[09-07-18 20:59:05.5242] main::main (238) Error: Skipping post-process & Not updating lastRescanTime!
[09-07-19 09:19:20.3797] main::main (122) Starting SqueezeCenter scanner (v7.3.3, r27044, Mon Jun 15 14:51:57 PDT 2009)
[09-07-19 09:19:46.8466] main::main (237) Error: Failed when running main scan: [spec is not a valid file specification at /Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/Slim/Utils/OS/OSX.pm line 300.
]
[09-07-19 09:19:46.8468] main::main (238) Error: Skipping post-process & Not updating lastRescanTime!

Mnyb
2009-07-21, 21:57
Fixed the problem.

Deleting the cache fixed the scanning problem.

Very god that it did usually this kind of error message:

"DBD::mysql::st execute failed: Can't create/write to file 'D:\ProgramData\SqueezeCenter\Cache\MySQL\#sql_8f8 _0.MYD' (Errcode: 13) at /<D:\PROGRA~1\SQUEEZ~1\server\scanner.exe"

Implicates that your Antivirus software is messing with MySQL and scanner.
So if you don't already have done it, set your AV software to ignore *.MYD and *.MYI files