I have hit a problem with 7.9.0 - 1399470368 @ Wed May 7 14:26:02 UTC
2014. I decide to try testing a regular automated scan (not something
I've done before), with server power control waking the PC up 10 minutes
before the scan is due. The PC duly woke up at 8:35, with a scan
scheduled for 8:45. I've now tried this twice, and both times it has
looped doing nothing except chewing up CPU. The server log (there is
nothing on the scanner log) is as below. I eventually aborted the
scan.
If I kick off a scan manually it seems to be OK.
Code:
--------------------
2014-05-10 08:14:56 squeezeboxserver_safe stopped.
2014-05-10 08:35:32 squeezeboxserver_safe started.
[14-05-10 08:35:36.4170] main::init (368) Starting Logitech Media Server
(v7.9.0, 1399470368, Wed May 7 14:26:02 UTC 2014) perl 5.018002
[14-05-10 08:35:43.9159] Slim::Utils::Misc::msg (1311) Warning:
[08:35:43.9151] defined(@array) is deprecated at
/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/SrvrPowerCtrl/Util.pm
line 69.
[14-05-10 08:35:43.9167] Slim::Utils::Misc::msg (1311) Warning:
[08:35:43.9162] (Maybe you should just omit the defined()?)
[14-05-10 08:35:44.8631] Plugins::CustomScan::Scanner::initDatabase (96)
CustomScan: Creating database tables
[14-05-10 08:35:44.8645] Plugins::CustomScan::Scanner::executeSQLFile (498)
Executing SQL file
/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbcreate.sql
[14-05-10 08:35:44.8843] Plugins::CustomScan::Scanner::initDatabase (439)
Creating indexes
[14-05-10 08:35:44.8858] Plugins::CustomScan::Scanner::executeSQLFile (498)
Executing SQL file
/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbindex.sql
[14-05-10 08:35:44.8917] Plugins::CustomScan::Plugin::installHook (132)
Installing Custom Scan hooks
[14-05-10 08:35:50.4549] Plugins::SrvrPowerCtrl::Settings::new (209) Server
Power Control, version 20120427.163654, is running on sbs version 7.9.0 on
unix:Debian, mac
[14-05-10 08:35:50.5990] Plugins::TrackStat::Storage::refreshTracks (1237)
TrackStat: Synchronizing TrackStat data, please wait...
[14-05-10 08:35:54.4575] Plugins::TrackStat::Storage::refreshTracks (1886)
TrackStat: Synchronizing TrackStat data finished
[14-05-10 08:45:00.3608] Slim::Utils::Scanner::Local::rescan (174)
Discovering audio files in /storage/music/flac
[14-05-10 09:16:29.0547] Slim::Utils::Scanner::Local::__ANON__ (267) Removing
deleted audio files (0)
[14-05-10 09:16:29.0555] Slim::Utils::Scanner::Local::__ANON__ (345) Scanning
new audio files (0)
[14-05-10 09:16:29.0563] Slim::Utils::Scanner::Local::__ANON__ (425)
Rescanning changed audio files (0)
[14-05-10 09:16:29.0618] Slim::Utils::Scanner::Local::rescan (174)
Discovering audio files in /storage/music/playlist
[14-05-10 09:16:29.1242] Plugins::SrvrPowerCtrl::Watchdog::OnWakeupWatchdog
(647) Wakeup Call!!
[14-05-10 09:16:29.3061] Slim::Schema::Storage::throw_exception (122) Error:
DBI Exception: DBD::SQLite::db do failed: table diskonly already exists [for
Statement "
CREATE TEMPORARY TABLE diskonly AS
SELECT DISTINCT(url) as url
FROM scanned_files
WHERE url NOT IN (
SELECT url FROM tracks
WHERE id <= 380181
)
AND url LIKE
'file:///storage/music/playlist%'
AND filesize != 0
"]
[14-05-10 09:16:29.3074] Slim::Schema::Storage::throw_exception (122)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/usr/share/perl5/Slim/Schema/Storage.pm line 122)
frame 1: Slim::Schema::Storage::throw_exception
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1006)
frame 2: DBIx::Class::Storage::DBI::__ANON__
(/usr/share/perl5/Slim/Utils/Scanner/Local.pm line 218)
frame 3: Slim::Utils::Scanner::Local::__ANON__
(/usr/share/perl5/Slim/Networking/IO/Select.pm line 168)
frame 4: (eval) (/usr/share/perl5/Slim/Networking/IO/Select.pm line 168)
frame 5: (eval) (/usr/share/perl5/Slim/Networking/IO/Select.pm line 168)
frame 6: Slim::Networking::IO::Select::loop (/usr/sbin/squeezeboxserver line
724)
frame 7: main::idleStreams (/usr/share/perl5/Slim/Web/Template/Context.pm
line 32)
frame 8: Slim::Web::Template::Context::process
(/usr/share/squeezeboxserver/CPAN/Template/Service.pm line 85)
frame 9: (eval) (/usr/share/squeezeboxserver/CPAN/Template/Service.pm line 82)
frame 10: Template::Service::process
(/usr/share/squeezeboxserver/CPAN/Template.pm line 65)
frame 11: Template::process
(/usr/share/perl5/Slim/Web/Template/SkinManager.pm line 322)
frame 12: Slim::Web::Template::SkinManager::_fillTemplate
(/usr/share/perl5/Slim/Web/Template/NoWeb.pm line 68)
frame 13: Slim::Web::Template::NoWeb::_generateContentFromFile
(/usr/share/perl5/Slim/Web/HTTP.pm line 2548)
frame 14: Slim::Web::HTTP::filltemplatefile
(/usr/share/perl5/Slim/Web/Pages/Progress.pm line 132)
frame 15: Slim::Web::Pages::Progress::progressBar
(/usr/share/perl5/Slim/Web/Pages/Common.pm line 69)
frame 16: Slim::Web::Pages::Common::addLibraryStats
(/usr/share/perl5/Slim/Web/Pages/Home.pm line 149)
frame 17: Slim::Web::Pages::Home::home (/usr/share/perl5/Slim/Web/HTTP.pm
line 1096)
frame 18: Slim::Web::HTTP::generateHTTPResponse
(/usr/share/perl5/Slim/Web/HTTP.pm line 919)
frame 19: Slim::Web::HTTP::processURL (/usr/share/perl5/Slim/Web/HTTP.pm line
723)
frame 20: Slim::Web::HTTP::processHTTP
(/usr/share/perl5/Slim/Networking/IO/Select.pm line 123)
frame 21: (eval) (/usr/share/perl5/Slim/Networking/IO/Select.pm line 119)
frame 22: Slim::Networking::IO::Select::__ANON__
(/usr/share/perl5/Slim/Networking/IO/Select.pm line 168)
frame 23: (eval) (/usr/share/perl5/Slim/Networking/IO/Select.pm line 168)
frame 24: Slim::Networking::IO::Select::loop (/usr/sbin/squeezeboxserver line
705)
frame 25: main::idle (/usr/sbin/squeezeboxserver line 661)
frame 26: main::main (/usr/sbin/squeezeboxserver line 1195)
[14-05-10 09:16:29.3087] Slim::Utils::Misc::msg (1311) Warning:
[09:16:29.3081] EV: error in callback (ignoring): Carp::Clan::__ANON__(): DBI
Exception: DBD::SQLite::db do failed: table diskonly already exists [for
Statement "
CREATE TEMPORARY TABLE diskonly AS
SELECT DISTINCT(url) as url
FROM scanned_files
WHERE url NOT IN (
SELECT url FROM tracks
WHERE id <= 380181
)
AND url LIKE
'file:///storage/music/playlist%'
AND filesize != 0
"] at /usr/share/perl5/Slim/Schema/Storage.pm line 126
--------------------
LMS 7.9 on VortexBox Midi running Xubuntu 14.04, FLACs 16->24 bit,
44.1->192kbps. Wired Touch + EDO, coax to Musical Fidelity M1 CLiC.
Wireless Xubuntu 14.04 laptop controls LMS via Chromium. Meridian
Explorer USB DAC to listen via Squeezelite on Vortexbox & other PCs as
required. Spare Touch in loft.
------------------------------------------------------------------------
PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642
View this thread: http://forums.slimdevices.com/showthread.php?t=101469
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
