Home of the Squeezebox™ & Transporter® network music players.
Results 1 to 4 of 4
  1. #1
    Junior Member
    Join Date
    Jul 2009
    Posts
    18

    Media scan terminating unexpectedly after tag updates

    In the morning on Sunday 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.

    Should I try clearing the entire library and starting from scratch?
    Last edited by Stone Free; 2017-08-08 at 12:16.

  2. #2
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    19,779

    Media scan terminating unexpectedly aftertag updates

    > 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 "

    Can you try without PhilsLibraries plugin (or whatever its real name)?


    --

    Michael

  3. #3
    Senior Member Philip Meyer's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    5,596

    Media scan terminating unexpectedly aftertag updates

    Oh, looks like a plugin I created to create some library views that depend on Erland's trackstat plugin to provide track ratings.

    You can install trackstat, should resolve the problem.

  4. #4
    Junior Member
    Join Date
    Jul 2009
    Posts
    18
    Thanks guys thats fixed it!

Posting Permissions

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