It looks like full text search is choking because of the name of a
playlist. I have nearly 900 playlists so I would help to know what I
should be looking for. Any suggestions?
Thanks in advance.
>>
[22-01-16 03:58:08.3316]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (458) Starting
fulltext index build
[22-01-16 03:58:08.3323]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (462) Initialize
fulltext table
[22-01-16 03:58:20.8305]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (475) Create
fulltext index for tracks
[22-01-16 04:01:11.3224]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (485) Create
fulltext index for albums
[22-01-16 04:03:16.8128]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (494) Create
fulltext index for contributors
[22-01-16 04:03:21.0851]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (504) Create
fulltext index for playlists
[22-01-16 06:49:47.7155] Slim::Schema::Storage::throw_exception (121)
Error: DBI Exception: DBD::SQLite::db do failed: out of memory [for
Statement "
INSERT INTO fulltext (id, type, w10, w5, w3, w1)
-- w10: title, w3: url, w1: track metadata
SELECT playlist_track.playlist, 'playlist', ?, '', ?,
UNIQUE_TOKENS(GROUP_CONCAT(w10 || ' ' || w5 || ' ' || w3 || ' ' || w1))
FROM playlist_track
LEFT JOIN tracks ON tracks.url = playlist_track.track
LEFT JOIN fulltext ON fulltext MATCH 'type:track ' ||
IGNORE_PUNCTUATION(REPLACE(REPLACE(playlist_track.track, '%20', ' '),
'file://', ''))
WHERE playlist_track.playlist = ?
"]
[22-01-16 06:49:47.7209] Slim::Schema::Storage::throw_exception (121)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace (/Slim/Schema/Storage.pm line
121)
frame 1: Slim::Schema::Storage::throw_exception
(/DBIx/Class/Storage/DBI.pm line 1006)
frame 2: DBIx::Class::Storage::DBI::__ANON__
(C:/PROGRA~2/SQUEEZ~1/server/Slim/Plugin/FullTextSearch/Plugin.pm line
545)
frame 3: Slim::Plugin::FullTextSearch::Plugin::_createPlaylistItem
(C:/PROGRA~2/SQUEEZ~1/server/Slim/Plugin/FullTextSearch/Plugin.pm line
513)
frame 4: Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex
(C:/PROGRA~2/SQUEEZ~1/server/Slim/Plugin/FullTextSearch/Plugin.pm line
171)
frame 5: Slim::Plugin::FullTextSearch::Plugin::startScan
(/Slim/Music/Import.pm line 580)
frame 6: Slim::Music::Import::runImporter (/Slim/Music/Import.pm line
455)
frame 7: Slim::Music::Import::runScanPostProcessing (scanner.pl line
344)
frame 8: (eval) (scanner.pl line 344)
frame 9: main::main (scanner.pl line 499)
[22-01-16 06:49:47.7558] main::main (348) Error: Failed when running
scan post-process: [Carp::Clan::__ANON__(): DBI Exception:
DBD::SQLite::db do failed: out of memory [for Statement "
INSERT INTO fulltext (id, type, w10, w5, w3, w1)
-- w10: title, w3: url, w1: track metadata
SELECT playlist_track.playlist, 'playlist', ?, '', ?,
UNIQUE_TOKENS(GROUP_CONCAT(w10 || ' ' || w5 || ' ' || w3 || ' ' || w1))
FROM playlist_track
LEFT JOIN tracks ON tracks.url = playlist_track.track
LEFT JOIN fulltext ON fulltext MATCH 'type:track ' ||
IGNORE_PUNCTUATION(REPLACE(REPLACE(playlist_track.track, '%20', ' '),
'file://', ''))
WHERE playlist_track.playlist = ?
"] at /Slim/Schema/Storage.pm line 125
]
[22-01-16 06:49:47.7573] main::main (349) Error: Not updating
lastRescanTime!
PS
>>
Version: 8.2.1 - 1639114554 @ Fri Dec 10 07:58:57 WEST 2021
Hostname: Home-Office-PC
Server IP Address: 192.168.214.179
Operating system: Windows 10 - EN - cp1252
Platform Architecture: 8664
Perl Version: 5.14.1 - MSWin32-x86-multi-thread
Audio::Scan: 1.02
IO::Socket::SSL: 2.068
Database Version: DBD::SQLite 1.58 (sqlite 3.22.0)
------------------------------------------------------------------------
prob's Profile: http://forums.slimdevices.com/member.php?userid=30998
View this thread: http://forums.slimdevices.com/showthread.php?t=102347
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
