Home of the Squeezebox™ & Transporter® network music players.
Results 1 to 4 of 4
  1. #1
    Senior Member brucegrr's Avatar
    Join Date
    Feb 2006
    Location
    Ney, Ohio
    Posts
    547

    Scan Problem in 7.3.3

    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:BI::_execute (/<D:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 826)
    frame 3: DBIx::Class::Storage:BI::_select (/<D:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI/Cursor.pm line 79)
    frame 4: DBIx::Class::Storage:BI::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??

  2. #2
    Senior Member brucegrr's Avatar
    Join Date
    Feb 2006
    Location
    Ney, Ohio
    Posts
    547
    Fixed the problem.

    Deleting the cache fixed the scanning problem.

  3. #3
    Junior Member
    Join Date
    May 2006
    Posts
    23
    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:BI::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:BI::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:BI::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:BI::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:BI::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!

  4. #4
    Senior Member Mnyb's Avatar
    Join Date
    Feb 2006
    Location
    Vństerňs Sweden
    Posts
    16,419
    Quote Originally Posted by brucegrr View Post
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •