Home of the Squeezebox™ & Transporter® network music players.
Page 7 of 8 FirstFirst ... 5678 LastLast
Results 61 to 70 of 79
  1. #61
    Junior Member
    Join Date
    Nov 2019
    Posts
    17
    Quote Originally Posted by mherger View Post
    > [20-09-25 18:29:07.5107] Slim::Plugin::FullTextSearch::Plugin::_rebuildInde x (479) Create fulltext index for playlists
    > [20-09-25 18:29:10.5696] Slim::Schema::Storage::throw_exception (121) Error: DBI Exception: DBD::SQLite::db do failed: malformed MATCH expression: [file:///Volumes/Ade_iTunes/iTunes/iTunes Media/Music/Metz/Metz/11 --))--.m4a] [for Statement "


    What LMS build is this?

    --

    Michael
    Code:
    [20-09-25 17:56:17.1967] main::main (206) Starting Logitech Media Server scanner (v8.0.0, 1600976618, Thu Sep 24 22:15:54 CEST 2020) perl 5.018004
    [20-09-25 17:56:17.3779] Slim::Schema::forceCommit (2157) Warning: Trying to commit transactions before DB is initialized!

  2. #62
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,472

    Scan taking hours instead ofminutes on recent nightlies

    > --------------------
    > [20-09-25 17:56:17.1967] main::main (206) Starting Logitech Media Server scanner (v8.0.0, 1600976618, Thu Sep 24 22:15:54 CEST 2020) perl 5.018004
    > [20-09-25 17:56:17.3779] Slim::Schema::forceCommit (2157) Warning: Trying to commit transactions before DB is initialized!


    Thanks. Would you mind sharing your library.db with me?

    https://www.dropbox.com/request/T3RctyzGgNg0oFDubq6a



    --

    Michael

  3. #63
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,472

    Scan taking hours instead ofminutes on recent nightlies

    I think I finally nailed the issue with the help of kidstypike's
    library.db. Please give the next build another try...
    --

    Michael

  4. #64
    Senior Member kidstypike's Avatar
    Join Date
    Feb 2007
    Location
    Brindle
    Posts
    4,010
    Quote Originally Posted by mherger View Post
    I think I finally nailed the issue with the help of kidstypike's
    library.db. Please give the next build another try...
    Success!

    Name:  scansuccess.jpg
Views: 132
Size:  179.0 KB
    Attached Files Attached Files
    Server - LMS 8.0.1 Pi4B 4GB/Flirc case/pCP v7.0.0b6 - 74K library, playlists & LMS cache on SSD (ntfs)
    Study - Pi3B/pCP 7.0.0b6/pi screen/Allo Boss DAC Ruark MR1 Mk2
    Lounge - Pi2/pCP 6.0.0 > HiFiBerry DIGI+ > AudioEngine DAC1 > AVI DM5
    Garage - Squeezebox Boom + Fostex sub
    Dining Room - Squeezebox Radio

    Spares - 2xTouch, 1xSB3, 7xRPi

  5. #65
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,472

    Scan taking hours instead ofminutes on recent nightlies

    > Success!

    Ok, 15s for the playlist FTS index look much more reasonable :-). Does
    it work? Can you search for tracks in a playlist?


    --

    Michael

  6. #66
    Senior Member kidstypike's Avatar
    Join Date
    Feb 2007
    Location
    Brindle
    Posts
    4,010
    Quote Originally Posted by mherger View Post
    > Success!

    Ok, 15s for the playlist FTS index look much more reasonable :-). Does
    it work? Can you search for tracks in a playlist?l
    Searching from the top search box doesn't bring up anything in playlists. (top pic below)

    Searching by clicking on the spyglass brings up playlists that contain the search criteria, I'm not sure I see the value in that. But then it wasn't me who asked for "search within playlists".

    Name:  Bringer3.jpg
Views: 110
Size:  21.5 KB

    Name:  Bringer2.jpg
Views: 114
Size:  44.8 KB
    Server - LMS 8.0.1 Pi4B 4GB/Flirc case/pCP v7.0.0b6 - 74K library, playlists & LMS cache on SSD (ntfs)
    Study - Pi3B/pCP 7.0.0b6/pi screen/Allo Boss DAC Ruark MR1 Mk2
    Lounge - Pi2/pCP 6.0.0 > HiFiBerry DIGI+ > AudioEngine DAC1 > AVI DM5
    Garage - Squeezebox Boom + Fostex sub
    Dining Room - Squeezebox Radio

    Spares - 2xTouch, 1xSB3, 7xRPi

  7. #67
    Junior Member
    Join Date
    Nov 2019
    Posts
    17
    Still taking a long time for me:

    Code:
    [20-09-26 08:09:47.0649] main::main (206) Starting Logitech Media Server scanner (v8.0.0, 1601033329, Fri Sep 25 13:53:32 CEST 2020) perl 5.018004
    [20-09-26 08:27:31.4928] Slim::Music::Import::runImporter (577) Starting Slim::Plugin::FullTextSearch::Plugin scan
    [20-09-26 08:27:31.4933] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (445) Starting fulltext index build
    [20-09-26 08:27:31.4934] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (449) Initialize fulltext table
    [20-09-26 08:27:31.5326] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (462) Create fulltext index for tracks
    [20-09-26 08:27:36.0543] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (472) Create fulltext index for albums
    [20-09-26 08:27:37.9209] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (481) Create fulltext index for contributors
    [20-09-26 08:27:38.0669] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (491) Create fulltext index for playlists
    [20-09-26 10:41:00.4914] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (506) Optimize fulltext index
    [20-09-26 10:41:00.9810] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (521) Fulltext index build done!
    [20-09-26 10:41:00.9812] Slim::Music::Import::endImporter (709) Completed Slim::Plugin::FullTextSearch::Plugin Scan in 8009 seconds.

  8. #68
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,472

    Scan taking hours instead ofminutes on recent nightlies

    > Still taking a long time for me:

    The please answer my questions about library size, number of playlists,
    number of tracks in those playlists, and share library.db and full
    scanner.log.zip with me.

    https://www.dropbox.com/request/T3RctyzGgNg0oFDubq6a

    It's hard to give advice when I lack any information...

    --

    Michael

  9. #69
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,472

    Scan taking hours instead ofminutes on recent nightlies

    > Still taking a long time for me:

    Thanks for your file! So... you have 10 playlists with 10k+ tracks? One
    with close to 30k tracks. Do you really use those? They seem to be
    imported from iTunes. Unless you're serious about using them I suggest
    you add them to the ignore list in the iTunes plugin settings. This
    should speed up the import considerably.

    --

    Michael

  10. #70
    Junior Member
    Join Date
    Nov 2019
    Posts
    17
    Quote Originally Posted by mherger View Post
    > Still taking a long time for me:

    Thanks for your file! So... you have 10 playlists with 10k+ tracks? One
    with close to 30k tracks. Do you really use those? They seem to be
    imported from iTunes. Unless you're serious about using them I suggest
    you add them to the ignore list in the iTunes plugin settings. This
    should speed up the import considerably.

    --

    Michael
    Thanks, looks like I need a tidy up!

Tags for this Thread

Posting Permissions

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