Home of the Squeezebox™ & Transporter® network music players.
Results 1 to 7 of 7
  1. #1

    Help me figure out why scanning is no longer working. Please?

    Below is from my scanner log. I can't figure it out, nothing has changed yet I'm getting many errors. I reinstalled LMS, but it didn't help. Any ideas of what to do? Thanks, SL

    frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 1006)
    frame 2: DBIx::Class::Storage:BI::__ANON__ (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Utils/SQLHelper.pm line 83)
    frame 3: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Utils/SQLHelper.pm line 83)
    frame 4: Slim::Utils::SQLHelper::executeSQLFile (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 415)
    frame 5: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 414)
    frame 6: Slim::Schema::wipeDB (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 2099)
    frame 7: Slim::Schema::wipeAllData (scanner.pl line 296)
    frame 8: (eval) (scanner.pl line 296)
    frame 9: main::main (scanner.pl line 494)

    [12-07-19 14:15:01.8768] Slim::Utils::SQLHelper::executeSQLFile (85) Error: Couldn't execute SQL statement: [DELETE FROM contributors;] : [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: database disk image is malformed [for Statement "DELETE FROM contributors;"] at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 126
    ]
    [12-07-19 14:15:02.3483] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db do failed: database or disk is full [for Statement "DELETE FROM contributor_track;"]
    [12-07-19 14:15:02.3488] Slim::Schema::Storage::throw_exception (122) Backtrace:

    frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 122)
    frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 1006)
    frame 2: DBIx::Class::Storage:BI::__ANON__ (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Utils/SQLHelper.pm line 83)
    frame 3: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Utils/SQLHelper.pm line 83)
    frame 4: Slim::Utils::SQLHelper::executeSQLFile (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 415)
    frame 5: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 414)
    frame 6: Slim::Schema::wipeDB (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 2099)
    frame 7: Slim::Schema::wipeAllData (scanner.pl line 296)
    frame 8: (eval) (scanner.pl line 296)
    frame 9: main::main (scanner.pl line 494)

    [12-07-19 14:15:02.3493] Slim::Utils::SQLHelper::executeSQLFile (85) Error: Couldn't execute SQL statement: [DELETE FROM contributor_track;] : [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: database or disk is full [for Statement "DELETE FROM contributor_track;"] at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 126
    ]
    [12-07-19 14:15:02.3566] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db do failed: constraint failed
    foreign key constraint failed [for Statement "DELETE FROM genres;"]
    [12-07-19 14:15:02.3571] Slim::Schema::Storage::throw_exception (122) Backtrace:

    frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 122)
    frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 1006)
    frame 2: DBIx::Class::Storage:BI::__ANON__ (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Utils/SQLHelper.pm line 83)
    frame 3: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Utils/SQLHelper.pm line 83)
    frame 4: Slim::Utils::SQLHelper::executeSQLFile (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 415)
    frame 5: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 414)
    frame 6: Slim::Schema::wipeDB (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 2099)
    frame 7: Slim::Schema::wipeAllData (scanner.pl line 296)
    frame 8: (eval) (scanner.pl line 296)
    frame 9: main::main (scanner.pl line 494)

    [12-07-19 14:15:02.3577] Slim::Utils::SQLHelper::executeSQLFile (85) Error: Couldn't execute SQL statement: [DELETE FROM genres;] : [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: constraint failed
    foreign key constraint failed [for Statement "DELETE FROM genres;"] at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 126
    ]
    [12-07-19 14:15:02.4663] Slim::Music::Import::runImporter (485) Starting Slim::Media::MediaFolderScan scan
    [12-07-19 14:15:02.4671] Slim::Utils::Scanner::Local::rescan (171) Discovering audio files in M:\---MUSIC---
    [12-07-19 14:15:02.5781] Slim::Utils::SQLiteHelper::updateProgress (405) Warning: Server aborted scan, shutting down
    Last edited by Sam Lowry; 2012-07-19 at 14:24. Reason: updated log

  2. #2
    Senior Member
    Join Date
    Jun 2008
    Location
    Hildesheim, Germany
    Posts
    2,159
    I See a part telling "database or disk is full", check your disk free space.
    2 * Classic, 2 * Boom, SC 7.7.2 auf GigaByte STA/C mit VIA C7 1GHz, 1GB RAM, 250 GB 2,5" HD, Ubuntu Desktop 8.04 LTS, controlled by Squeeze Commander on Motorola Xoom, CD -> FLAC = dbpoweramp, Mix MusicIP, Router AVM Fritz 3270

    last.fm/user/jo-wie

  3. #3
    Former Squeezebox UI Guy
    Join Date
    Sep 2008
    Posts
    33
    I've been having problems for weeks trying to get LMS to scan my iTunes playlists with no luck. It's so bad that honestly I have a hard time recommending this product to anyone until it gets fixed. It's a shame Logitech doesn't seem to be putting in the resources to respond to these issues...

  4. #4
    For anyone else with a similar problem...

    The solution for me was to open the LMS Control Panel-> Advanced-> Check Clean cache folder, including....->Run Clean Up

    Never noticed that option until yesterday.

  5. #5
    Senior Member
    Join Date
    Dec 2007
    Location
    Boston area (NE USA)
    Posts
    647
    Worth trying whenever there's something odd going on.
    I sometimes delete the entire cache (location varies by OS, it's N:\Documents and Settings\All Users\Application Data\Squeezebox\Cache on win XP/2003, otherwise find server.prefs and find the string beginning with cachedir:
    I just stop SBS, delete everything inside that cache folder, then restart SBS

    Given the error, you could have probably just rebuilt the db file (check the SQLite command line tool here) with SBS off, of course. But delete and rebuild has fixed a lot of odd stuff for me over the years.

  6. #6
    The most widespread and fatal error involves embedded artwork.

    I was unable to proceed to software above v 6 until I removed all embedded artwork with dbpoweramp.

    cheers.

    bfl
    Last edited by banned for life; 2012-08-01 at 16:49.

  7. #7
    Senior Member
    Join Date
    May 2008
    Location
    United States
    Posts
    8,154
    Quote Originally Posted by banned for life View Post
    The most widespread and fatal error involves embedded artwork.

    I was unable to proceed to software above v 6 until I removed all embedded artwork with dbpoweramp.

    cheers.

    bfl
    hmmmm, another data point: I have about 20,000 mp3 files with embedded artwork and they haven't caused any problems in any of the builds (currently using LMS 7.7.2). All the artwork files are jpg, and I don't think any are larger than about 600x600. I use cover.jpg (not embedded) in my FLAC albums.
    Location 1: VortexBox Appliance 6TB (2.2) > LMS 7.7.2 > Transporter, Touch, Boom, Radio w/Battery (all ethernet)
    Location 2: VBA 3TB (2.2) > LMS 7.7.2 > Touch > Benchmark DAC I, Boom, Radio w/Battery (all ethernet except Radio)
    Office: Win7(64) > LMS 7.7.2 > SqueezePlay
    Spares: VBA 4TB, SB3, Touch (3), Radio (3), CONTROLLER
    Controllers: iPhone4S (iPeng), iPad2 (iPengHD & SqueezePad), CONTROLLER, or SqueezePlay 7.7 on Win7(64) laptop
    Ripping (FLAC) - dbpoweramp, Tagging - mp3tag, Spotify

Posting Permissions

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