Unable to delete some shows

[jluna001 0]

Recently I removed a good amount of shows to clear up some space on my server. However in Emby some shows are still showing up. when I try deleting them again within Emby I get this error:

I tried following the "Corrupt Database" steps and using DB Browser for SQLite I got this:

 

Made a copy of the library.db file. Ran the SQLite command:

 sqlite3 library.db ".recover" | sqlite3 library-recovered.db

Then: 

 sqlite3 library-recovered.db "PRAGMA integrity_check"

Shut down Emby and put the library.db file in my data folder, but could no longer connect to the server. If I remove it and put the original library.db file I can connect to server with no problem again.

 

Not sure what I am doing wrong here. Also what could have caused this to begin with. I usually delete files through Sonarr or Radarr, then do a library scan.

 

embyserver.txt

[Luke 42080]

Hi, please see here and let us know if this helps get you squared away:

Corrupt Database

[jluna001 0]

Tried that not sure if I am doing it correctly. I did get a library-recovered.db.

renamed it to library.db placed it in my data folder but server would not launch.

[Luke 42080]

Is any emby server log file generated?

Emby Server Data Folder

[jluna001 0]

yes I attached the server log in my original post

[Luke 42080]

2 minutes ago, jluna001 said:

yes I attached the server log in my original post

Right but I need the server log from after you tried to follow the instructions in the link I gave you. Thanks.

[jluna001 0]

Oh apologies. No logs as server does not load. All I get is a message saying "Emby Server is loading. Please try again shortly."

Edited December 19, 2023 by jluna001

[Luke 42080]

If you got that far then there is a log file. Are you sure you shutdown the server? What files did you change?

[jluna001 0]

after I shutdown the server I rename library.db to library.old and I rename library-recovered.db to library.db

[Luke 42080]

Was there also a library.db-wal file? or library.db-shm? Those should be moved as well.

[jluna001 0]

no I do not see those once the server is off. I do see them when it is running.

[Luke 42080]

When the server is shutdown and you try to access the web interface, what do you get in the browser?