'SQLitePCL.pretty.SQLiteException' was thrown during folder removal

[podonnell 47]

Received the error 

Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.

when I was attempting to delete a folder within a library. I had moved the library down one child folder path.

Here is my server log for when the error appeared.

My library looks fine now, and only monitors the single folder I want it to. However, are there any lingering issues I should be aware of? Trying not to have a corrupt database or such.

Thanks.

errors.txt

[Happy2Play 9780]

You may have broke the db adding child library and parent libraries.

 

2024-08-08 22:25:16.917 Info LibraryMonitor: S:\CIPHER\Other\LG 4k is already being watched by watcher for S:\CIPHER\Other. Adding item 6332

 

2024-08-08 22:25:16.926 Info App: Sqlite: 787 - abort at 36 in [insert or ignore into ItemLinks2 (ItemId, Type, LinkedId, LinkOrder) values (6330,8,6332,0)]: FOREIGN KEY constraint failed

2024-08-08 22:25:16.964 Error SqliteItemRepository: Error saving items
	*** Error Report ***
	Version: 4.8.8.0
	Command line: Desktop\emby\system\EmbyServer.dll -noautorunwebapp
	Operating system: Microsoft Windows 10.0.19045
	Framework: .NET 6.0.30
	OS/Process: x64/x64
	Runtime: C:/Users/Pat/Desktop/emby/system/System.Private.CoreLib.dll
	Processor count: 8
	Data path: Desktop\emby\programdata
	Application path: Desktop\emby\system
	SQLitePCL.pretty.SQLiteException: Constraint: FOREIGN KEY constraint failed
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
	   at SQLitePCL.pretty.StatementImpl.MoveNext()
	   at SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItemsInTranscation(IDatabaseConnection db, List`1 tuples, MetadataRefreshOptions metadataRefreshOptions)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, MetadataRefreshOptions metadataRefreshOptions, Action`1 afterSave, Boolean disableForeignKeys, CancellationToken cancellationToken)
	Source: SQLitePCL.pretty
	TargetSite: Void CheckOk(SQLitePCLEx.sqlite3, Int32)

 

But the same a other topics sometime removing libraries works and other have to create a new db.

Dev needs to make this not possible or a Big warning that you many break your install.

[podonnell 47]

11 hours ago, Happy2Play said:

You may have broke the db adding child library and parent libraries.

 

2024-08-08 22:25:16.917 Info LibraryMonitor: S:\CIPHER\Other\LG 4k is already being watched by watcher for S:\CIPHER\Other. Adding item 6332

 

2024-08-08 22:25:16.926 Info App: Sqlite: 787 - abort at 36 in [insert or ignore into ItemLinks2 (ItemId, Type, LinkedId, LinkOrder) values (6330,8,6332,0)]: FOREIGN KEY constraint failed

2024-08-08 22:25:16.964 Error SqliteItemRepository: Error saving items
	*** Error Report ***
	Version: 4.8.8.0
	Command line: Desktop\emby\system\EmbyServer.dll -noautorunwebapp
	Operating system: Microsoft Windows 10.0.19045
	Framework: .NET 6.0.30
	OS/Process: x64/x64
	Runtime: C:/Users/Pat/Desktop/emby/system/System.Private.CoreLib.dll
	Processor count: 8
	Data path: Desktop\emby\programdata
	Application path: Desktop\emby\system
	SQLitePCL.pretty.SQLiteException: Constraint: FOREIGN KEY constraint failed
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
	   at SQLitePCL.pretty.StatementImpl.MoveNext()
	   at SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItemsInTranscation(IDatabaseConnection db, List`1 tuples, MetadataRefreshOptions metadataRefreshOptions)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, MetadataRefreshOptions metadataRefreshOptions, Action`1 afterSave, Boolean disableForeignKeys, CancellationToken cancellationToken)
	Source: SQLitePCL.pretty
	TargetSite: Void CheckOk(SQLitePCLEx.sqlite3, Int32)

 

But the same a other topics sometime removing libraries works and other have to create a new db.

Dev needs to make this not possible or a Big warning that you many break your install.

What can I do to troubleshoot further? Emby is working perfectly well today.

[Luke 42077]

Hi, please see this topic for more info: 

Thanks.