mherger wrote:
> > btw, do you know if there are any limitations to how big the .db
> files
> > can be ? the artwork.db is 720MB and the library.db is 390MB. the
> files
> > were smaller than the ones I deleted so it seems that a complete
> rescan
> > every now and then is a good thing to do.
>
> I've heard of users with 600k+ tracks in their library. No idea how bit
>
> the .db files were in those cases, but you're certainly far from any
> known limitation wrt. file size.
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
------------------------------------------------------------------------
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
