Earlier today I copied some new audio files to my QNAP 219P under the
Squeezebox shares and successfully ran 'rescan' to update LMS.
I then noticed that my tags where not quite right for the newly copied
album as it had 'Various Artists' in the 'Album Artist' field which I
absolutely hate so I put in the actual album artist using the latest
version of MP3TAG 2.83, the original tags were written with 2.77 of the
same program.
However whenever I try re-scan the library for changes it stops with
''Create library views (1 of 2) Complete 00:00:14
Media scan terminated unexpectedly (Scanning Progress)
Total Time: 00:08:10 (Sunday, August 6, 2017 / 2:03 PM)"
I took this as an opportunity to upgrade to the latest nightly of 7.9
from the '14900335303' version to ''1501791870'. I hoped this might
kill two birds with one stone but it hasn't made a difference it is
still failing at the same point.
Here is an extract from the scanner log:
Code:
--------------------
0444: [17-08-06 14:02:52.2124] main::main (342) Error: Not updating
lastRescanTime!
0443: ]
0442: "] at
/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Schema/Storage.pm
line 126
0441: WHERE ts.rating IS NULL
0440: JOIN track_statistics ts ON ts.url = tracks.url
0439: FROM tracks
0438: SELECT '5443755c', tracks.id
0437: INSERT OR IGNORE INTO library_track (library, track)
0436: [17-08-06 14:02:52.2095] main::main (341) Error: Failed when running
scan post-process: [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do
failed: no such table: track_statistics [for Statement "
0435:
0434: frame 8: main::main
(/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/scanner.pl
line 495)
0433: frame 7: (eval)
(/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/scanner.pl
line 337)
0432: frame 6: Slim::Music::Import::runScanPostProcessing
(/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/scanner.pl
line 337)
0431: frame 5: Slim::Music::Import::runImporter
(/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Music/Import.pm
line 411)
0430: frame 4: Slim::Music::VirtualLibraries::startScan
(/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Music/Import.pm
line 513)
0429: frame 3: Slim::Music::VirtualLibraries::rebuild
(/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Music/VirtualLibraries.pm
line 270)
0428: frame 2: DBIx::Class::Storage::DBI::__ANON__
(/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Music/VirtualLibraries.pm
line 323)
0427: frame 1: Slim::Schema::Storage::throw_exception
(/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/CPAN/DBIx/Class/Storage/DBI.pm
line 1006)
0426: frame 0: Slim::Utils::Log::logBacktrace
(/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Schema/Storage.pm
line 122)
0425:
0424: [17-08-06 14:02:52.1788] Slim::Schema::Storage::throw_exception (122)
Backtrace:
0423: "]
0422: WHERE ts.rating IS NULL
0421: JOIN track_statistics ts ON ts.url = tracks.url
0420: FROM tracks
0419: SELECT '5443755c', tracks.id
0418: INSERT OR IGNORE INTO library_track (library, track)
0417: [17-08-06 14:02:52.1742] Slim::Schema::Storage::throw_exception (122)
Error: DBI Exception: DBD::SQLite::db do failed: no such table:
track_statistics [for Statement "
0416: [17-08-06 14:02:51.8096] Slim::Music::Import::runImporter (511)
Starting Slim::Music::VirtualLibraries scan
0415: [17-08-06 14:02:51.7825] Slim::Music::Import::endImporter (643)
Completed Slim::Plugin::FullTextSearch::Plugin Scan in 133 seconds.
0414: [17-08-06 14:02:51.7794]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (485) Fulltext index build
done!
0413: [17-08-06 14:02:47.6338]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (470) Optimize fulltext
index
0412: [17-08-06 14:02:12.2446]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (435) Create fulltext index
for playlists
0411: [17-08-06 14:02:11.3172]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (425) Create fulltext index
for contributors
0410: [17-08-06 14:01:40.8853]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (416) Create fulltext index
for albums
0409: [17-08-06 14:00:40.8712]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (406) Create fulltext index
for tracks
0408: [17-08-06 14:00:38.3831]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (400) Initialize fulltext
table
0407: [17-08-06 14:00:38.3803]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (396) Starting fulltext
index build
0406: [17-08-06 14:00:38.3742] Slim::Music::Import::runImporter (511)
Starting Slim::Plugin::FullTextSearch::Plugin scan
--------------------
My SBS details are as follows:
Logitech Media Server Status
Logitech Media Server Version: 7.9.1 - 1501791870 @ Fri Aug 4 04:11:59
UTC 2017
Hostname: PetersNAS
Server IP Address: 192.168.1.6
Server HTTP Port Number: 9001
Operating system: Linux - EN - utf8
Platform Architecture: armv5tel-linux
Perl Version: 5.10.0 - armv5tel-linux-thread-multi
Audio::Scan: 0.93
Database Version: DBD::SQLite 1.34_01 (sqlite 3.7.7.1)
Total Players Recognized: 1
I've dug earlier in the day for before the upgrade and the same error is
showing:
Code:
--------------------
0029: [17-08-06 13:54:34.5645] Slim::Utils::Scanner::Local::rescan (181)
Discovering audio files in /share/Qmultimedia/Music
0028: [17-08-06 13:54:34.5607] Slim::Music::Import::runImporter (511)
Starting Slim::Media::MediaFolderScan scan
0027: "] at
/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Schema/Storage.pm
line 126
0026: WHERE ts.rating IS NULL
0025: JOIN track_statistics ts ON ts.url = tracks.url
0024: FROM tracks
0023: SELECT '5443755c', tracks.id
0022: INSERT OR IGNORE INTO library_track (library, track)
0021: [17-08-06 13:54:33.9270] Slim::Utils::PluginManager::load (393)
Warning: Couldn't call Plugins::PhilsLibraries::Plugin->initPlugin:
Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: no such
table: track_statistics [for Statement "
0020:
0019: frame 7: main::main
(/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/scanner.pl
line 495)
0018: frame 6: Slim::Utils::PluginManager::load
(/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/scanner.pl
line 273)
0017: frame 5: (eval)
(/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Utils/PluginManager.pm
line 391)
0016: frame 4: Plugins::PhilsLibraries::Plugin::initPlugin
(/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Utils/PluginManager.pm
line 391)
0015: frame 3: Slim::Music::VirtualLibraries::rebuild
(/opt/ssods4/var/home/SqueezeboxServer/Cache/InstalledPlugins/Plugins/PhilsLibraries/Plugin.pm
line 35)
0014: frame 2: DBIx::Class::Storage::DBI::__ANON__
(/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Music/VirtualLibraries.pm
line 323)
0013: frame 1: Slim::Schema::Storage::throw_exception
(/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/CPAN/DBIx/Class/Storage/DBI.pm
line 1006)
0012: frame 0: Slim::Utils::Log::logBacktrace
(/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Schema/Storage.pm
line 122)
0011:
0010: [17-08-06 13:54:33.9236] Slim::Schema::Storage::throw_exception (122)
Backtrace:
0009: "]
0008: WHERE ts.rating IS NULL
0007: JOIN track_statistics ts ON ts.url = tracks.url
0006: FROM tracks
0005: SELECT '5443755c', tracks.id
0004: INSERT OR IGNORE INTO library_track (library, track)
0003: [17-08-06 13:54:33.9199] Slim::Schema::Storage::throw_exception (122)
Error: DBI Exception: DBD::SQLite::db do failed: no such table:
track_statistics [for Statement "
0002: [17-08-06 13:54:26.0723] Slim::Schema::forceCommit (2149) Warning:
Trying to commit transactions before DB is initialized!
0001: [17-08-06 13:54:21.5066] main::main (205) Starting Logitech Media
Server scanner (v7.9.1, 1501791870, Fri Aug 4 04:11:59 UTC 2017) perl 5.010000
--------------------
Does anyone know what is wrong, and what I can do to fix it?
For the moment I just updated the offending album by using 'Music
Folder' and playing the album and it now appears as the first entry
under 'New Music'
I doubt the following info will be useful but I will include it just in
case. I am on the QNAP firmware 4.3.3.0262 Build 20170727
------------------------------------------------------------------------
Stone Free's Profile: http://forums.slimdevices.com/member.php?userid=31773
View this thread: http://forums.slimdevices.com/showthread.php?t=107809
_______________________________________________
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
