Search results always empty

[MacGyver27 20]

Hello,

I just made a clean install of my host system and tried to run restored Emby from the old version. Most things looks good but I have noticed 2 problems:

• favorites list for users got empty
• searching always shows nothing.. even after waiting couple minutes

Any suggestion what it might be? If it recovers eventually? Or do I need to delete e.g. metadata folder?

Thanks a lot

[Luke 42078]

Hi, how did you restore? Let's look at a search example:

How to Report a Problem

Thanks.

[MacGyver27 20]

Just restored docker-compose folder. It contains `/config` of a `lscr.io/linuxserver/emby:latest` image.

docker-compose.yml:

version: "3.7"

services:
  emby:
    container_name: emby.33400
    image: lscr.io/linuxserver/emby:latest
    #image: emby/embyserver:latest
    restart: always
    privileged: true
    runtime: nvidia
    deploy:
      resources:
        reservations:
          devices:
            - driver: nvidia
              count: all
              capabilities: [gpu]
    ports:
      - 33400:33400
    #  - 1900:1900/udp
    #  - 1901:1901/udp
    volumes:
        # Server
      - $PWD/emby/config:/config
      - /dev/shm:/transcode
      - /lvm/raid/private/media/.optimized:/optimized
        # Movies
      - /lvm/raid/private/media/Movies:/srv/media/Movies:rw
    environment:
      - TZ=${TZ}
      - PUID=${PUID} #LINUXSERVER
      - PGID=${PGID} #LINUXSERVER
      - UID=${PUID}
      - GID=${PGID}
      - NVIDIA_VISIBLE_DEVICES=all
      - NVIDIA_DRIVER_CAPABILITIES=all
    labels:
      # AUTOUPDATE
      - com.ouroboros.enable=true

networks:
  default:
    name: emby

 

I know it is not the "cleanest" way, but my old host got corrupted so was only able to extract what was on disk.. Thanks!

EDIT:
Debian 12
Docker version 24.0.6

embyserver.txt embyserver-63829702989.txt

Edited September 7, 2023 by MacGyver27

[Luke 42078]

OK please follow the instructions here to get back up and running again:

Corrupt Database

Please note in your case if you happen to have older database files that are not corrupted, you could use those instead of making a fresh start.

[MacGyver27 20]

Nothing helped. So am I safe to delete just `library.db` and have it configured manually again? Or others DB will be out of sync (I think shouldnt be the problem)..

I was able to open library.db in SQL Browser, so is there a table which contains just library configuration so I can import it? Thanks

 

sqlite3 library.db "PRAGMA integrity_check"
Error: in prepare, database disk image is malformed (11)

sqlite3 library.db ".recover" | sqlite3 library-recovered.db
sql error: SQL logic error (1)

sqlite3 library.db ".dump" | sqlite3 library-recovered.db
Runtime error near line 304349: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 304350: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 304351: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 304352: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313288: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313289: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313290: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313291: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313293: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313294: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313295: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313296: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313298: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313299: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313300: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313301: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313302: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313303: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313304: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313305: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313306: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313307: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313308: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313309: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313310: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313311: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313312: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313313: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313314: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313315: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313316: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313317: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313318: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 313319: UNIQUE constraint failed: MediaStreams2.ItemId, MediaStreams2.StreamIndex (19)
Runtime error near line 1272035: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1272140: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312386: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312387: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312388: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312389: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312390: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312391: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312392: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312393: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312394: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312395: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312396: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312397: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312398: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312399: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312400: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312401: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312402: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312403: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312404: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312405: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312406: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312407: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312408: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312409: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1312410: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1319680: UNIQUE constraint failed: Chapters3.ItemId, Chapters3.ChapterIndex (19)
Runtime error near line 1340541: UNIQUE constraint failed: fts_search7_data.id (19)

 

Edited September 7, 2023 by MacGyver27

[Luke 42078]

Quote

So am I safe to delete just `library.db` and have it configured manually again?

Yea it looks like that's what you're going to have to do. 

[MacGyver27 20]

Thanks! What about `metadata` folder? needs to be deleted as well? since its associated with the `library.db` ?

[MacGyver27 20]

Something strange happened.. I deleted library.db (metadata folder still in place). Server loaded empty, so started adding libraries and suddenly all old libraries appeared and now am able to search?! How could this happen? Thanks!

[Luke 42078]

The most likely answer is you're able to search as the content is getting scanned in again.

[MacGyver27 20]

But this does not answer the question how it restored my all libraries when I deleted the library.db? Thanks

[Luke 42078]

If the library.db file was deleted then it would not restore them. They'd have to be scanned in. Maybe that happened really fast, or maybe you didn't do what you thought you did. 

[MacGyver27 20]

Thanks! I am up and running now.. how long does it take to generate all metadatas? Old folder was 40GB, this new one from the yesterday is about 350MB now.

Since I have your attention here, can you react to the following:

• how can I get rid of imported playlists? if I click delete it wants to delete them from the disk.. I just want them away from the server
• i would find very useful if we could upload subtitles manually.. I have users which are not well English speaking and they always ask me to upload subtitles for them.. searching doesnt always find good match or if any.. so that they dont have to bother me and they can try themself.. and subtitles would be shared with others
• is there a user limit? I have found 25 devices limit, this is per user or in total?

Sorry if it was already discussed somewhere, did just quick google and didnt find exact answer..

Thank you.

[Luke 42078]

Quote

• how can I get rid of imported playlists? if I click delete it wants to delete them from the disk.. I just want them away from the server

Have you explored the library options of your music library?

Quote

i would find very useful if we could upload subtitles manually.. I have users which are not well English speaking and they always ask me to upload subtitles for them.. searching doesnt always find good match or if any.. so that they dont have to bother me and they can try themself.. and subtitles would be shared with others

Great idea. Please create a feature request topic !

https://emby.media/community/index.php?/forum/98-feature-requests/

Quote

is there a user limit? I have found 25 devices limit, this is per user or in total?

No limit.

[GrimReaper 4740]

8 hours ago, MacGyver27 said:

i would find very useful if we could upload subtitles manually.. I have users which are not well English speaking and they always ask me to upload subtitles for them.. searching doesnt always find good match or if any.. so that they dont have to bother me and they can try themself.. and subtitles would be shared with others

 

6 minutes ago, Luke said:

Great idea. Please create a feature request topic !

https://emby.media/community/index.php?/forum/98-feature-requests/

 

There's already an open request for this or something functionally equivalent. Please join in and contribute to the existing discussion at:

 

[MacGyver27 20]

On 08/09/2023 at 22:08, Luke said:

Have you explored the library options of your music library?

When unchecked import playlists they disappeared over a day or so.. Thanks!