Home of the Squeezebox™ & Transporter® network music players.
Page 1 of 4 123 ... LastLast
Results 1 to 10 of 39
  1. #1
    Senior Member
    Join Date
    Jan 2012
    Posts
    647

    Constantly crashing server (database image malformed)

    For several years now, my LMS stops out of the blue and I have to delete all the .db files and rebuild from scratch. I've tried all sorts of things like try pinkdot's LMSupdate package, Synology's beta package (I'm currently running 7.9.1-166 on a Synology DS1511+) but the end result is always the same. I'll be playing a song and it will just stop and give me the following errors and the only option is to rebuild. This happens at least once a week and I'm basically at the end of my rope. Is there anything anyone can suggest that might fix this? I'm just so tired of having to rebuild constantly, which takes longer and longer as my library grows.

    Code:
    Insert into Database Playing Track:
    file:///volume1/Media/Music/Love%20And%20Death%20-%20Between%20Here%20&%20Lost/09%20-%20Paralyzed.flac
    [17-12-31 15:14:46.5323] Plugins::SugarCube::Plugin::kickoff (263) 
    #### Track Changed or Timer Fired ####
    [17-12-31 15:14:46.5339] Plugins::SugarCube::Breakout::TrackTracker (328) 
    Insert into Database Playing Track:
    file:///volume1/Media/Music/Love%20And%20Death%20-%20Between%20Here%20&%20Lost/10%20-%20Chemicals.flac
    [17-12-31 15:17:18.4237] Plugins::SugarCube::Plugin::kickoff (263) 
    #### Track Changed or Timer Fired ####
    [17-12-31 15:17:18.4259] Plugins::SugarCube::Breakout::TrackTracker (328) 
    Insert into Database Playing Track:
    file:///volume1/Media/Music/Love%20And%20Death%20-%20Between%20Here%20&%20Lost/11%20-%20Bruises.flac
    [17-12-31 15:21:41.3863] Plugins::SugarCube::Plugin::kickoff (263) 
    #### Track Changed or Timer Fired ####
    [17-12-31 15:21:41.3879] Plugins::SugarCube::Breakout::TrackTracker (328) 
    Insert into Database Playing Track:
    file:///volume1/Media/Music/Love%20And%20Death%20-%20Between%20Here%20&%20Lost/12%20-%20Empty.flac
    [17-12-31 15:25:49.4823] Plugins::SugarCube::Plugin::kickoff (263) 
    #### Track Changed or Timer Fired ####
    [17-12-31 15:25:49.4839] Plugins::SugarCube::Breakout::TrackTracker (328) 
    Insert into Database Playing Track:
    file:///volume1/Media/Music/Love%20And%20Death%20-%20Between%20Here%20&%20Lost/13%20-%20The%20Abandoning%20(Rauch%20Remix).flac
    [17-12-31 15:30:08.0063] Plugins::SugarCube::Plugin::kickoff (263) 
    #### Track Changed or Timer Fired ####
    [17-12-31 15:30:08.0080] Plugins::SugarCube::Breakout::TrackTracker (328) 
    Insert into Database Playing Track:
    file:///volume1/Media/Music/Love%20And%20Death%20-%20Between%20Here%20&%20Lost/14%20-%20Meltdown%20(Rauch%20Remix).flac
    [17-12-31 15:30:08.1121] Plugins::SugarCube::Plugin::ArrayLoop (667) 
    #### Built URL Request for MusicIP:
     http://localhost:10002/api/mix?&sizetype=tracks&size=13&song%3d%2Fvolume1%2FMedia%2FMusic%2FLove%20And%20Death%20-%20Between%20Here%20%26%20Lost%2F14%20-%20Meltdown%20(Rauch%20Remix).flac&style=0&variety=0
    ####
    [17-12-31 15:30:08.1819] Plugins::SugarCube::Plugin::ScalarLoop (357) 
    #### MusicIP Responded with ####
    /volume1/Media/Music/Love And Death - Between Here & Lost/14 - Meltdown (Rauch Remix).flac
    /volume1/Media/Music/Star Wars Trilogy (The Original Soundtrack Anthology)/CD 3/11 - Into The Trap.flac
    /volume1/Media/Music/The Perks Of Being A Wallflower (Original Motion Picture Soundtrack)/06 - Asleep.flac
    /volume1/Media/Music/Liberace - Liberace's Greatest Hits/02 - Warsaw Concerto.flac
    /volume1/Media/Music/Carole King - Natural Woman The Very Best Of Carole King/14 - It's Going To Take Some Time.flac
    /volume1/Media/Music/John Denver - Back Home Again/11 - Sweet Surrender.flac
    /volume1/Media/Music/Linda Ronstadt - Heart Like A Wheel/05 - Heart Like A Wheel.flac
    /volume1/Media/Music/R.E.M. - Automatic For The People (DVD-A)/04 - Everybody Hurts.flac
    /volume1/Media/Music/Carole King - Natural Woman The Very Best Of Carole King/06 - Up On The Roof (Live).flac
    /volume1/Media/Music/Caravans - Original Moton Picture Score/11 - Becky's Waltz.flac
    /volume1/Media/Music/Secret Garden - White Stones/14 - Illumination.flac
    /volume1/Media/Music/Secret Garden - Songs From A Secret Garden/03 - Song from A Secret Garden.flac
    /volume1/Media/Music/Star Wars Trilogy (The Original Soundtrack Anthology)/CD 3/05 - The Return Of The Jedi.flac
    
    [17-12-31 15:30:08.5027] Slim::Schema::Storage::throw_exception (100) Error: DBI Exception: DBD::SQLite::st execute failed: database disk image is malformed [for Statement "SELECT tracks.url, tracks.title, albums.title, genres.name, contributors.name, tracks.coverid, tracks.album, tracks.id FROM contributors, tracks INNER JOIN genre_track ON (genre_track.track = tracks.id) INNER JOIN genres ON (genre_track.genre = genres.id) INNER JOIN albums ON (tracks.album = albums.id) INNER JOIN contributor_track ON tracks.id = contributor_track.track AND contributor_track.contributor = contributors.id AND contributor_track.role in (1,6) WHERE tracks.url = 'file:///volume1/Media/Music/Love%20And%20Death%20-%20Between%20Here%20&%20Lost/14%20-%20Meltdown%20(Rauch%20Remix).flac' OR tracks.url = 'file:///volume1/Media/Music/Star%20Wars%20Trilogy%20(The%20Original%20Soundtrack%20Anthology)/CD%203/11%20-%20Into%20The%20Trap.flac' OR tracks.url = 'file:///volume1/Media/Music/The%20Perks%20Of%20Being%20A%20Wallflower%20(Original%20Motion%20Picture%20Soundtrack)/06%20-%20Asleep.flac' OR tracks.url = 'file:///volume1/Media/Music/Liberace%20-%20Liberace%27s%20Greatest%20Hits/02%20-%20Warsaw%20Concerto.flac' OR tracks.url = 'file:///volume1/Media/Music/Carole%20King%20-%20Natural%20Woman%20The%20Very%20Best%20Of%20Carole%20King/14%20-%20It%27s%20Going%20To%20Take%20Some%20Time.flac' OR tracks.url = 'file:///volume1/Media/Music/John%20Denver%20-%20Back%20Home%20Again/11%20-%20Sweet%20Surrender.flac' OR tracks.url = 'file:///volume1/Media/Music/Linda%20Ronstadt%20-%20Heart%20Like%20A%20Wheel/05%20-%20Heart%20Like%20A%20Wheel.flac' OR tracks.url = 'file:///volume1/Media/Music/R.E.M.%20-%20Automatic%20For%20The%20People%20(DVD-A)/04%20-%20Everybody%20Hurts.flac' OR tracks.url = 'file:///volume1/Media/Music/Carole%20King%20-%20Natural%20Woman%20The%20Very%20Best%20Of%20Carole%20King/06%20-%20Up%20On%20The%20Roof%20(Live).flac' OR tracks.url = 'file:///volume1/Media/Music/Caravans%20-%20Original%20Moton%20Picture%20Score/11%20-%20Becky%27s%20Waltz.flac' OR tracks.url = 'file:///volume1/Media/Music/Secret%20Garden%20-%20White%20Stones/14%20-%20Illumination.flac' OR tracks.url = 'file:///volume1/Media/Music/Secret%20Garden%20-%20Songs%20From%20A%20Secret%20Garden/03%20-%20Song%20from%20A%20Secret%20Garden.flac' OR tracks.url = 'file:///volume1/Media/Music/Star%20Wars%20Trilogy%20(The%20Original%20Soundtrack%20Anthology)/CD%203/05%20-%20The%20Return%20Of%20The%20Jedi.flac' group by tracks.url"]
    Trying to rebuild /volume1/@appstore/SqueezeCenter/Cache/library.db from scratch.
    [17-12-31 15:30:09.1960] Slim::Networking::IO::Select::__ANON__ (131) Error: Select task failed calling Slim::Networking::Async::HTTP::_http_read_body: DBIx::Class::Storage::DBI::__ANON__(): DBI Exception: DBD::SQLite::st fetchrow_array failed: attempt to fetch on inactive database handle [for Statement "SELECT tracks.url, tracks.title, albums.title, genres.name, contributors.name, tracks.coverid, tracks.album, tracks.id FROM contributors, tracks INNER JOIN genre_track ON (genre_track.track = tracks.id) INNER JOIN genres ON (genre_track.genre = genres.id) INNER JOIN albums ON (tracks.album = albums.id) INNER JOIN contributor_track ON tracks.id = contributor_track.track AND contributor_track.contributor = contributors.id AND contributor_track.role in (1,6) WHERE tracks.url = 'file:///volume1/Media/Music/Love%20And%20Death%20-%20Between%20Here%20&%20Lost/14%20-%20Meltdown%20(Rauch%20Remix).flac' OR tracks.url = 'file:///volume1/Media/Music/Star%20Wars%20Trilogy%20(The%20Original%20Soundtrack%20Anthology)/CD%203/11%20-%20Into%20The%20Trap.flac' OR tracks.url = 'file:///volume1/Media/Music/The%20Perks%20Of%20Being%20A%20Wallflower%20(Original%20Motion%20Picture%20Soundtrack)/06%20-%20Asleep.flac' OR tracks.url = 'file:///volume1/Media/Music/Liberace%20-%20Liberace%27s%20Greatest%20Hits/02%20-%20Warsaw%20Concerto.flac' OR tracks.url = 'file:///volume1/Media/Music/Carole%20King%20-%20Natural%20Woman%20The%20Very%20Best%20Of%20Carole%20King/14%20-%20It%27s%20Going%20To%20Take%20Some%20Time.flac' OR tracks.url = 'file:///volume1/Media/Music/John%20Denver%20-%20Back%20Home%20Again/11%20-%20Sweet%20Surrender.flac' OR tracks.url = 'file:///volume1/Media/Music/Linda%20Ronstadt%20-%20Heart%20Like%20A%20Wheel/05%20-%20Heart%20Like%20A%20Wheel.flac' OR tracks.url = 'file:///volume1/Media/Music/R.E.M.%20-%20Automatic%20For%20The%20People%20(DVD-A)/04%20-%20Everybody%20Hurts.flac' OR tracks.url = 'file:///volume1/Media/Music/Carole%20King%20-%20Natural%20Woman%20The%20Very%20Best%20Of%20Carole%20King/06%20-%20Up%20On%20The%20Roof%20(Live).flac' OR tracks.url = 'file:///volume1/Media/Music/Caravans%20-%20Original%20Moton%20Picture%20Score/11%20-%20Becky%27s%20Waltz.flac' OR tracks.url = 'file:///volume1/Media/Music/Secret%20Garden%20-%20White%20Stones/14%20-%20Illumination.flac' OR tracks.url = 'file:///volume1/Media/Music/Secret%20Garden%20-%20Songs%20From%20A%20Secret%20Garden/03%20-%20Song%20from%20A%20Secret%20Garden.flac' OR tracks.url = 'file:///volume1/Media/Music/Star%20Wars%20Trilogy%20(The%20Original%20Soundtrack%20Anthology)/CD%203/05%20-%20The%20Return%20Of%20The%20Jedi.flac' group by tracks.url"] at /volume1/@appstore/SqueezeCenter/Cache/InstalledPlugins/Plugins/SugarCube/Plugin.pm line 426
    ; fh=Slim::Networking::Async::Socket::HTTP=GLOB(0xf4da168)
    [17-12-31 15:30:09.8388] Slim::Control::Request::execute (1888) Error: While trying to run function coderef [Slim::Control::Queries::statusQuery]: [DBIx::Class::Storage::DBI::__ANON__(): DBI Exception: DBD::SQLite::st execute failed: attempt to execute on inactive database handle [for Statement "SELECT value FROM metainformation WHERE name = 'isScanning'"] at /volume1/@appstore/SqueezeCenter/Slim/Music/Import.pm line 682

  2. #2
    You have problems with sugarcube plugin, remove it or at lest report your problem to the developer
    1 x Touch
    1 x Radio
    Logitech Media Server Version: 7.9.0 - 1439462741 @ Tue Aug 18 04:19:24 UTC 2015
    Squeeze Commander
    Squeeze Player
    Phone: Sony Experia Z3

  3. #3
    Senior Member
    Join Date
    Jan 2012
    Posts
    647
    Quote Originally Posted by T-bird View Post
    You have problems with sugarcube plugin, remove it or at lest report your problem to the developer
    Hmm, what makes you think it's Sugarcube?

  4. #4
    I'm guessing, since every line in your log mention it

    Edit: Or some of Erlands plugins what integrates with Sugarcube like trackstat
    Last edited by T-bird; 2018-01-01 at 02:28.
    1 x Touch
    1 x Radio
    Logitech Media Server Version: 7.9.0 - 1439462741 @ Tue Aug 18 04:19:24 UTC 2015
    Squeeze Commander
    Squeeze Player
    Phone: Sony Experia Z3

  5. #5
    Senior Member pinkdot's Avatar
    Join Date
    Nov 2009
    Location
    The Netherlands
    Posts
    900
    Seems still the same problem and IMO has to do with his (Morbeas) special use case:
    http://forums.slimdevices.com/showth...l=1#post880534

    And a Happy New Year to all :-)

    Verstuurd vanaf mijn Redmi 3S met Tapatalk
    -LMS on Raspian Stretch -> 2x Radio
    -RPI 3 (Mopidy), Aune S6 - Exposure 3010S2 - PMC FB1i

  6. #6
    Senior Member cparker's Avatar
    Join Date
    Oct 2005
    Location
    Hampshire, United Kingdom
    Posts
    589
    Quote Originally Posted by T-bird View Post
    I'm guessing, since every line in your log mention it

    Edit: Or some of Erlands plugins what integrates with Sugarcube like trackstat
    Hi

    I dont believe this to be a Sugarcube issue, it just happens that it's writing to the log at the same time as the system is writing to the log.

    If you look at lines;
    "database disk image is malformed"
    "Trying to rebuild /volume1/@appstore/SqueezeCenter/Cache/library.db from scratch."
    "execute failed: attempt to execute on inactive database handle [for Statement "SELECT value FROM metainformation WHERE name = 'isScanning'"] at /volume1/@appstore/SqueezeCenter/Slim/Music/Import.pm line 682"

    These indicate that the LMS database is screwed and therefore when Sugarcube is trying to read the database it cant because the database is mangled

    (SugarCube doesn't write to the LMS database it just reads from it.)

    I would try;
    Stopping the LMS service
    Renaming the .db files (On a Wintel system these are under ProgramData\Squeezebox\Cache not sure for a Synology)
    Restarting LMS service
    This should start a complete rebuild of the LMS databases, rather than just a rescan. If the database structure is damaged a rescan wont fix the problem.

    Ensure the scan completes fully and then try again. Also check your Synology SMART status and check you don't have lots of disk errors,as googling "database disk image is malformed" is also an indicator of potential hardware failure.

    Hope that helps
    www.spicefly.com - ** Spicefly SugarCube ** - A hassle free acoustic journey through your music library using MusicIP. Plus the finest MusicIP installation guides, enhanced MIP Interface and SpyGlass MIP the Windows Automated MusicIP Headless Installer.

  7. #7
    Senior Member DJanGo's Avatar
    Join Date
    Sep 2005
    Location
    Germany
    Posts
    2,483
    Quote Originally Posted by cparker View Post
    "database disk image is malformed"
    "Trying to rebuild /volume1/@appstore/SqueezeCenter/Cache/library.db from scratch."
    "execute failed: attempt to execute on inactive database handle [for Statement "SELECT value FROM metainformation WHERE name = 'isScanning'"] at /volume1/@appstore/SqueezeCenter/Slim/Music/Import.pm line 682"

    Hi
    a malformed database on a NAS let me always think about disk is full....
    df -h /volume1/@appstore/SqueezeCenter

  8. #8
    Senior Member
    Join Date
    Jan 2012
    Posts
    647
    Quote Originally Posted by DJanGo View Post
    Hi
    a malformed database on a NAS let me always think about disk is full....
    I am running out of space but still have 280+ GB available. You really think that's the problem?
    Attached Images Attached Images  
    Last edited by Morbeas; 2018-01-01 at 08:38.

  9. #9
    Senior Member
    Join Date
    Jan 2012
    Posts
    647
    Quote Originally Posted by cparker View Post
    I would try;
    Stopping the LMS service
    Renaming the .db files (On a Wintel system these are under ProgramData\Squeezebox\Cache not sure for a Synology)
    Restarting LMS service
    This should start a complete rebuild of the LMS databases, rather than just a rescan. If the database structure is damaged a rescan wont fix the problem.

    Ensure the scan completes fully and then try again. Also check your Synology SMART status and check you don't have lots of disk errors,as googling "database disk image is malformed" is also an indicator of potential hardware failure.

    Hope that helps
    Like I said, when this happens, which is usually about once a week, I delete all those .db files and rebuild from scratch but the issue always comes back.

    Edit: I just checked and there are 0 errors on any of my 5 disks.

  10. #10
    Senior Member
    Join Date
    Jan 2012
    Posts
    647
    Also, there is one other thing on my installation that is different and that is I create a symlink to the Cache folder on a share I created.

    This is what I do:
    Code:
    mv /volume1/@appstore/SqueezeCenter/Cache /volume1/SqueezeShare/
    ln -s /volume1/SqueezeShare/Cache /volume1/@appstore/SqueezeCenter/
    This is so that a program I use, Muso, can have access to the Cache folder.

    Just an FYI.

Posting Permissions

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