Missing my entire database

[knight2024 2]

After creating a couple new libraries with nothing in them yet. All my other database files are gone in 35 folders. Completely vanished, all are empty saying no files.

All my data is still on the qnap so nothing got deleted, thank god !!

All the folders I created are still on the home page just nothing inside them, I have never had this happen in all my years of running emby.

I tried to scan the library files but it will not do anything to scan, or it is so brief that it looks like its doing nothing.

Any info would be appreciated. Thank you 

Very strange !!

[Luke 38528]

Hi there, please attach the emby server log from after you ran the library scan:

How to Report a Problem

Thanks.

[knight2024 2]

Hi Luke

So, i don't know much about the log info but i did see a bunch of lines saying deleting path, that can't be good. 

All I was doing was creating 3 new library folders with nothing in them at that moment.

 

 

embyserver-63868484946.txt

[knight2024 2]

Sorry Luke

This is the log when i try to do a library scan.

 

 

 

embyserver.txt

Edited November 29 by knight2024

[Luke 38528]

How many Emby libraries have you created, and what folder paths are added to each one?

[GrimReaper 3746]

20 minutes ago, knight2024 said:

ll I was doing was creating 3 new library folders with nothing in them at that moment.

You have likely broken your database:

Quote

SQLitePCL.pretty.SQLiteException: Constraint: FOREIGN KEY constraint failed
    SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.

by adding/removing overlapping/nested folder library paths:

Quote

2024-11-29 13:41:53.259 Info LibraryMonitor: /share/CACHEDEV1_DATA/Multimedia/M.A.S.H is already being watched by watcher for /share/CACHEDEV1_DATA/Multimedia

2024-11-29 13:41:56.227 Info LibraryMonitor: /share/CACHEDEV1_DATA/Multimedia/Magnum P.I is already being watched by watcher for /share/CACHEDEV1_DATA/Multimedia

2024-11-29 13:42:53.807 Info LibraryMonitor: /share/CACHEDEV1_DATA/Multimedia/Three's Company is already being watched by watcher for /share/CACHEDEV1_DATA/Multimedia

2024-11-29 13:41:11.573 Info LibraryMonitor: Changing existing watcher from /share/CACHEDEV1_DATA/Multimedia/Wonder Woman to /share/CACHEDEV1_DATA/Multimedia

I'd assume you have added (and potentially removed?) top level folder /share/CACHEDEV1_DATA/Multimedia/ as library path at some point which broke all the other libraries that had it's children as paths:

Quote

2024-11-29 12:08:37.000 Info LibraryMonitor: Stopping directory watching for path /share/CACHEDEV1_DATA/Multimedia/Movies

2024-11-29 12:08:38.356 Info LibraryMonitor: Stopping directory watching for path /share/CACHEDEV1_DATA/Multimedia/Newest Movies

2024-11-29 12:08:38.743 Info LibraryMonitor: Stopping directory watching for path /share/CACHEDEV1_DATA/Multimedia/Airwolf

2024-11-29 12:08:38.843 Info LibraryMonitor: Stopping directory watching for path /share/CACHEDEV1_DATA/Multimedia/Bionic Reunion Movies

2024-11-29 12:08:39.283 Info LibraryMonitor: Stopping directory watching for path /share/CACHEDEV1_DATA/Multimedia/Buck Rogers in the 25th Century

...

...

...

2024-11-29 13:48:35.933 Info LibraryMonitor: Stopping directory watching for path /share/CACHEDEV1_DATA/Multimedia

You can try to recover database with steps listed in the above linked KB article though it is highly doubtful you'll have any success and it is much more likely you'll have to completely rebuild your library/database (or restore from backup if you have any).

[knight2024 2]

I have created 37 libraries over time.

34 of them have Season 1, Season 2, Season 3 etc.., in each one of those 

[knight2024 2]

So restoring from backup worked.

All I know is that when I created one of the new libraries, instead of pointing the folder to it completely, it looks like I accidentally pointed it too /share/CACHEDEV1_DATA/Multimedia/, then I seen that it was wrong and deleted that library, at that time all the libraries disappeared.

 

Thanks @Lukeand @GrimReaper

Appreciate your time !!!!

Edited November 30 by knight2024