Deleting an Album results in an SQLite 'FOREIGN KEY constraint failed' error.

[DBee25 1]

I am running into an issue deleting albums from Emby. Each time SQLite throws an ''SQLitePCL.pretty.SQLiteException: Constraint: FOREIGN KEY constraint failed' error.
The problem is reproduceable. I installed Emby on a (fresh installation of) Debian 12.

Steps to reproduce:

- Create a new library of content type 'Music'
  Use a local folder (i.e. /emby/music)
  chown emby:emby /emby/music.
  All other options default

- Upload an album (and fix permissions), wait for it to be added to the library

- In a browser, select the library and select 'Albums'

- Select the album, select 'Delete' in the popup menu

- A popup window containing the SQLite error appears, resulting in the album not being deleted.

 

The problem only occurs when you try to delete an album. Dleting items from other menu items works as expected.
The album is removed automatically though when you remove the entire folder.

From the looks of it seems to be a database problem and I hope this can be looked into.

 

 

 

 

 

embyserver.txt

[Abobader 3326]

Hello DBee25,

** This is an auto reply **

Please wait for someone from staff support or our members to reply to you.

It's recommended to provide more info, as it explain in this thread:

Thank you.

Emby Team

[Luke 39870]

Hi, can you please attach the complete Emby server log file? Thanks.

[DBee25 1]

According to 'How to report a problem'  the log file containing the issue should be uploaded and that is what I did. The literal text is  ''Please attach the server log from the time frame the activity occurred'. There i not much more information to add. It was new install of Emby on  new installed OS. This system was only set up to reproduce the problem and has already been removed. From what I remember the rest of the log contained no error.  What information on Emby startup parameters could be of any influence on Album information not being removed due to a database problem?

[Happy2Play 9405]

But a full log will show your libraries and the added contented assuming the steps above were in that same log.  

Can say I cannot reproduce an issue with the steps you provided.

 

Edited April 29 by Happy2Play

[DBee25 1]

Here it is...

embyserver.txt

[DBee25 1]

Wrong log file, this is the correct one

embyserver.txt

[Luke 39870]

If you perform the deletion from folder view instead so that you're just deleting the raw folder or files, how does that compare?

[DBee25 1]

Deleting from all other views works. When you delete the album from the folder view the album is also removed from the album view.

From what I have seen  the only thing that does not work is deleting an album from the album view.

 

[Luke 39870]

OK we'll take a look at it. Thanks.