emby server creates libraries and I can't delete them

[Flest 6]

at first there were 3 of them, now there are 28)))

and the server creates a high CPU load 20-30% (Ryzen 5800X), all time... 

[Flest 6]

any ideas?
need to remove these useless libraries (

maybe using manual editing of config files?

Edited March 31 by Flest

[Happy2Play 8294]

There as several topic on camera upload causing issues and creating multiple libraries.  I have yet to run into not being able to remove each one by one from the UI though.

Only other way if you can't remove them in the UI would be manually digging around in the database and and removing them for all there linked tables.

But the devs are looking into this.

[Flest 6]

24 minutes ago, Happy2Play said:

Only other way if you can't remove them in the UI would be manually digging around in the database and and removing them for all there linked tables.

I tried, the server starts doing something, the processor load increases, and... nothing happens)))

Tell me how to delete them using tables?

I deleted the download folder, the server created 3 new libraries with a new path C:\Users\Flest\AppData\Roaming\Emby-Serv...
and I can delete these new libraries, but the library with the old path "P:\Photos Uploads" is not deleted

 

Edited March 31 by Flest

[Happy2Play 8294]

It doesn't help if you still have camera upload enabled though as the issue still happens when new items are added.  

Testing with only one present did not add additional libraries in my test.  It is a issue starting with none.

But you have to find the ids in the Mediaitems table or the parentid from the url for each library, then remove that id from ancestorids, itemextradata, itemlinks2, useritemshares, then finally mediaitems table.

Ensure you have a backup of your library.db though.

The ones with the custom path I am not sure as it sound like a old and new config exist.  As for files well they have become obsolete as almost all configs have migrated to database only.

 

[Flest 6]

56 minutes ago, Happy2Play said:

 

maybe there are faq or something else? )

 

Edited March 31 by Flest

[Happy2Play 8294]

Just now, Flest said:

maybe there are faq or something else? )

 

That means there is a table with the id still in it so the row can not be deleted

[Flest 6]

11 minutes ago, Happy2Play said:

That means there is a table with the id still in it so the row can not be deleted

and how to solve this problem? )
I deleted this from all the tables except "mediaitems"

[Happy2Play 8294]

This is only an example

Now back to the first image for the library as you have linked items to that location.

So there is no easy answer here ass all your uploaded images will be linked also preventing the removal of the library.  But yes it can be done.

[Flest 6]

10 hours ago, Happy2Play said:

This is only an example

Now back to the first image for the library as you have linked items to that location.

 

So there is no easy answer here ass all your uploaded images will be linked also preventing the removal of the library.  But yes it can be done.

no images, all libraries are empty

ok let's try - librory parentId=435922

finded all records "MediaItems" like 439270, 439271, 439272, 439273...

delete all from "AncestorIds2"

delete all from "ItemExtradata"

delete all from "ItemLinks2"

delete all from "UserItemShares"

back to "MediaItems" and try delete librory, and... i cant )))

save the database and start the server. the libraries are still there, but the folders are gone)

[Happy2Play 8294]

Well since they changed to Mixed Content you should be able to delete/remove them in the UI.  But you are not getting all the linking.

[Flest 6]

5 minutes ago, Happy2Play said:

Well since they changed to Mixed Content you should be able to delete/remove them in the UI. 

I can't remove them from the UI :(

"But you are not getting all the linking."

what could I have missed and where?

[Happy2Play 8294]

Your images are mixing 43522 and 43523 so it is impossible to say.

In the Name column of MediaItems table are you filter cameraupload and then camera upload to see id?

Have you filtered the MediaItems Path column for cameraupload to see id?

Edited April 1 by Happy2Play

[Flest 6]

6 minutes ago, Happy2Play said:

Your images are mixing 43522 and 43523 so it is impossible to say.

In the Name column of MediaItems table are you filter cameraupload and then camera upload to see id?

Have you filtered the MediaItems Path column for cameraupload to see id?

numbers are different because these are the numbers of all the libraries that I found)
I deleted records of all these numbers

Spoiler

435922
435923
435926
439142
439269
439270
439271
439272
439273
439274
439275
439276
439277
439278
439279
439280
439281
439282
439283
439284
439285
439312
439313
439314
439315
439360
439361
439362

 

[Flest 6]

 

13 hours ago, Happy2Play said:

Your images are mixing 43522 and 43523 so it is impossible to say.

In the Name column of MediaItems table are you filter cameraupload and then camera upload to see id?

Have you filtered the MediaItems Path column for cameraupload to see id?

new try  ))

rename all 28 librires - find all 28 IDs

delete all from "AncestorIds2"

delete all from "ItemExtradata"

delete all from "ItemLinks2"

delete all from "UserItemShares"

back to "MediaItems" and still cant delete thems

 

librories still in UI

[Luke 37092]

Hi, apologies from the disruption. You may want to consider starting with a fresh database. We are looking into the root cause of this issue. Thanks.

[Flest 6]

10 minutes ago, Luke said:

Hi, apologies from the disruption. You may want to consider starting with a fresh database. We are looking into the root cause of this issue. Thanks.

hi)

Reinstall and configure everything again? (((((

Is there any way to save server statistics? "Playback Reporting" and "Statistics" plugins

Or is it better not to do this and do a clean installation?

What about the camera upload? Until you find the cause of the problem, is it better not to use it?

 

[Luke 37092]

9 minutes ago, Flest said:

hi)

Reinstall and configure everything again? (((((

Is there any way to save server statistics? "Playback Reporting" and "Statistics" plugins

Or is it better not to do this and do a clean installation?

What about the camera upload? Until you find the cause of the problem, is it better not to use it?

 

The other option is to remove all of the libraries that have been deleted, but that would have to be done one at a time.

I believe if you uncheck the option in server camera upload settings to create a subfolder for each device, then it might not happen again after that.

[Flest 6]

2 minutes ago, Luke said:

The other option is to remove all of the libraries that have been deleted, but that would have to be done one at a time.

how can i do this? from ui? 

 

3 minutes ago, Luke said:

I believe if you uncheck the option in server camera upload settings to create a subfolder for each device, then it might not happen again after that.

if I understood you correctly. then I didn’t use this option, and I only have 1 device - my phone)

[Luke 37092]

21 hours ago, Flest said:

how can i do this? from ui? 

Yes, using the normal remove library from Emby library setup.

[Flest 6]

1 hour ago, Luke said:

Yes, using the normal remove library from Emby library setup.

doesnt work  (
if I try to delete then CPU load becomes 20% and nothing happens

after rebooting the server, the CPU load becomes normal - 0-0.5%

[Luke 37092]

1 minute ago, Flest said:

doesnt work  (
if I try to delete then CPU load becomes 20% and nothing happens

after rebooting the server, the CPU load becomes normal - 0-0.5%

I think you just need to give it time to finish deleting entries from the server database.

[Flest 6]

2 minutes ago, Luke said:

Я думаю, вам просто нужно дать ему время закончить удаление записей из базы данных сервера.

ok Luke

I'll give it until evening
I'll write what happened)

[Flest 6]

6 hours ago, Luke said:

I think you just need to give it time to finish deleting entries from the server database.

after 6 hours the library wasnt deleted

[Luke 37092]

OK that's not normal, but I would give it more time. Thanks.