fjodolf wrote:
> My indexing problem has returned. :-(
>
>
> I have attempted all of the above to no avail.
>
> Information screen shows the following :
>
> Discovering files/directories: /media/knut/Music10TB/0_Audio
> (172609 of 172609) Complete 00:01:29
>
> Scanning new music files: /media/knut/Music10TB/0_Audio (59327 of
> 159873) Complete 00:10:54
>
> Media scan terminated unexpectedly (Scanning Progress)
> Total Time: 00:12:23 (Wednesday, February 24, 2021 / 5:48 PM)
>
> It no longer fails on indexing artwork, now it is the music files
> themselves that make it crash. I have done a cleanup in the audio files
> removing all files mentioned in previous log files. (some .cue files and
> incomplete .flac files etc)
>
> Media server status :
>
> Logitech Media Server Version: 8.1.1 - 1610364019 @ Thu Jan 14 06:22:21
> CET 2021
> Hostname: knut-Media
> Server IP Address: 127.0.0.1
> Server HTTP Port Number: 9000
> Operating system: Debian - EN - utf8
> Platform Architecture: x86_64-linux
> Perl Version: 5.30.0 - x86_64-linux-gnu-thread-multi
> Audio::Scan: 1.02
> IO::Socket::SSL: 2.067
> Database Version: DBD::SQLite 1.58 (sqlite 3.22.0)
> Total Players Recognized: 2
>
> Scanner log files :
>
> [21-02-24 17:36:14.0473] main::main (206) Starting Logitech Media Server
> scanner (v8.1.1, 1610364019, Thu Jan 14 06:22:21 CET 2021) perl
> 5.030000
> [21-02-24 17:36:14.0994] Carp::Clan::__ANON__ (216) Warning:
> DBIx::Class::ResultSet::update_or_create(): Query returned more than one
> row. SQL that returns multiple rows is DEPRECATED for ->find and
> ->single at /usr/share/perl5/Slim/Schema.pm line 1899
> [21-02-24 17:36:14.0996] Slim::Schema::forceCommit (2171) Warning:
> Trying to commit transactions before DB is initialized!
> [21-02-24 17:36:15.7552] Slim::Music::Import::runImporter (577) Starting
> Slim::Media::MediaFolderScan scan
> [21-02-24 17:36:15.7554] Slim::Utils::Scanner::Local::rescan (179)
> Discovering audio files in /media/knut/Music10TB/0_Audio
> [21-02-24 17:37:44.7550] Slim::Utils::Scanner::Local::__ANON__ (191)
> Start processing found tracks
> [21-02-24 17:37:44.7552] Slim::Utils::Scanner::Local::__ANON__ (199)
> Connect do DB
> [21-02-24 17:37:44.7552] Slim::Utils::Scanner::Local::__ANON__ (202) Get
> latest ID
> [21-02-24 17:37:44.7554] Slim::Utils::Scanner::Local::__ANON__ (224)
> Delete temporary table if exists
> [21-02-24 17:37:44.7554] Slim::Utils::Scanner::Local::__ANON__ (227)
> Re-build temporary table
> [21-02-24 17:37:44.8919] Slim::Utils::Scanner::Local::__ANON__ (276) Get
> deleted tracks count
> [21-02-24 17:37:44.8920] Slim::Utils::Scanner::Local::__ANON__ (283) Get
> new tracks count
> [21-02-24 17:37:44.8926] Slim::Utils::Scanner::Local::__ANON__ (288) Get
> changed tracks count
> [21-02-24 17:37:44.8926] Slim::Utils::Scanner::Local::deleteTracks (519)
> Removing deleted audio files (0)
> [21-02-24 17:37:44.8927] Slim::Utils::Scanner::Local::__ANON__ (301)
> Scanning new audio files (159873)
> [21-02-24 17:39:37.6765] Audio::Scan::scan (64) Warning: Error: Unable
> to read at least 4 bytes from file.
> [21-02-24 17:46:35.0283] Audio::Scan::scan (64) Warning: Error: Unable
> to read at least 10 bytes from file.
> [21-02-24 17:46:35.0517] Audio::Scan::scan (64) Warning: Error: Unable
> to read at least 10 bytes from file.
>
> Server log file :
>
> 2021-02-24 17:34:50 squeezeboxserver_safe stopped.
> 2021-02-24 17:35:29 squeezeboxserver_safe started.
> [21-02-24 17:35:30.5203] main::init (388) Starting Logitech Media Server
> (v8.1.1, 1610364019, Thu Jan 14 06:22:21 CET 2021) perl 5.030000 -
> x86_64-linux-gnu-thread-multi
> [21-02-24 17:35:30.6192] Slim::Utils::IPDetect::_init (138) Warning:
> Couldn't call connect() - falling back to 127.0.0.1
> [21-02-24 17:35:30.6390] Slim::Utils::SQLiteHelper::postConnect (377)
> Optimizing DB because of missing or empty sqlite_stat1 table
> [21-02-24 17:35:32.3635] Slim::Schema::forceCommit (2171) Warning:
> Trying to commit transactions before DB is initialized!
> [21-02-24 17:35:33.5543] Slim::Utils::Misc::msg (1266) Warning:
> [17:35:33.5542] DBIx::Class::ResultSet::update_or_create(): Query
> returned more than one row. SQL that returns multiple rows is
> DEPRECATED for ->find and ->single at /usr/share/perl5/Slim/Schema.pm
> line 1899
> [21-02-24 17:35:33.6902]
> Slim::Plugin::FullTextSearch::Plugin::_initPopularTerms (556) Fulltext
> index missing or outdated - re-building
> [21-02-24 17:35:33.6903]
> Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (453) Starting
> fulltext index build
> [21-02-24 17:35:33.6904]
> Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (457) Initialize
> fulltext table
> [21-02-24 17:35:33.6907]
> Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (470) Create
> fulltext index for tracks
> [21-02-24 17:35:36.3237]
> Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (480) Create
> fulltext index for albums
> [21-02-24 17:35:37.1229]
> Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (489) Create
> fulltext index for contributors
> [21-02-24 17:35:37.1514]
> Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (499) Create
> fulltext index for playlists
> [21-02-24 17:35:37.1572]
> Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (514) Optimize
> fulltext index
> [21-02-24 17:35:37.2745]
> Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (529) Fulltext index
> build done!
> [21-02-24 17:48:38.6621] Slim::Utils::Misc::msg (1266) Warning:
> [17:48:38.6620] DBIx::Class::ResultSet::update_or_create(): Query
> returned more than one row. SQL that returns multiple rows is
> DEPRECATED for ->find and ->single at /usr/share/perl5/Slim/Schema.pm
> line 1899
> [21-02-24 17:48:38.6663]
> Slim::Plugin::FullTextSearch::Plugin::_initPopularTerms (556) Fulltext
> index missing or outdated - re-building
> [21-02-24 17:48:38.6666] Slim::Schema::Storage::throw_exception (121)
> Error: DBI Exception: DBD::SQLite::db selectcol_arrayref failed: no such
> table: fulltext_terms [for Statement "
> SELECT term, d FROM (
> SELECT term, SUM(documents) d
> FROM fulltext_terms
> WHERE NOT col IN ('*', 1, 0) AND LENGTH(term) > 1
> GROUP BY term
> ORDER BY d DESC
> )
> WHERE d > 500
> "]
> [21-02-24 17:48:38.6666] Slim::Schema::Storage::throw_exception (121)
> Backtrace:
>
> frame 0: Slim::Utils::Log::logBacktrace
> (/usr/share/perl5/Slim/Schema/Storage.pm line 121)
> frame 1: Slim::Schema::Storage::throw_exception
> (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1007)
> frame 2: DBIx::Class::Storage::DBI::__ANON__
> (/usr/share/perl5/Slim/Plugin/FullTextSearch/Plugin.pm line 563)
> frame 3: Slim::Plugin::FullTextSearch::Plugin::_initPopularTerms
> (/usr/share/perl5/Slim/Plugin/FullTextSearch/Plugin.pm line 137)
> frame 4: Slim::Plugin::FullTextSearch::Plugin::__ANON__
> (/usr/share/perl5/Slim/Control/Request.pm line 2058)
> frame 5: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 2058)
> frame 6: Slim::Control::Request::notify
> (/usr/share/perl5/Slim/Control/Request.pm line 859)
> frame 7: Slim::Control::Request::checkNotifications
> (/usr/sbin/squeezeboxserver line 709)
> frame 8: main::idle (/usr/sbin/squeezeboxserver line 678)
> frame 9: main::main (/usr/sbin/squeezeboxserver line 1211)
>
> [21-02-24 17:48:38.6667] Slim::Control::Request::notify (2060) Error:
> Failed notify: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db
> selectcol_arrayref failed: no such table: fulltext_terms [for Statement
> "
> SELECT term, d FROM (
> SELECT term, SUM(documents) d
> FROM fulltext_terms
> WHERE NOT col IN ('*', 1, 0) AND LENGTH(term) > 1
> GROUP BY term
> ORDER BY d DESC
> )
> WHERE d > 500
> "] at /usr/share/perl5/Slim/Schema/Storage.pm line 125
Did just discover that version 8.2.0 was available. Installed this. Same
result.
Now running on
Logitech Media Server Version: 8.2.0 - 1614180387 @ Wed Feb 24 16:43:09
CET 2021
Hostname: knut-Media
Server IP Address: 192.168.1.11
Server HTTP Port Number: 9000
Operating system: Debian - EN - utf8
Platform Architecture: x86_64-linux
Perl Version: 5.30.0 - x86_64-linux-gnu-thread-multi
Audio::Scan: 1.02
IO::Socket::SSL: 2.067
Database Version: DBD::SQLite 1.58 (sqlite 3.22.0)
Total Players Recognized: 2
------------------------------------------------------------------------
fjodolf's Profile: http://forums.slimdevices.com/member.php?userid=63640
View this thread: http://forums.slimdevices.com/showthread.php?t=113925
_______________________________________________
Squeezecenter mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
