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%2
0Being%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/C
aravans%20-%20Original%20Moton%20Picture%20Score/11%20-%20Be!
cky%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%20Origi
nal%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%2!
0The%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
--------------------
------------------------------------------------------------------------
Morbeas's Profile: http://forums.slimdevices.com/member.php?userid=53547
View this thread: http://forums.slimdevices.com/showthread.php?t=108492
_______________________________________________
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
