SQLitePCL.Pretty error - One stinking album!!!!

[Skjellyfetti 0]

Hello all! 

I have a fairly large music collection in Emby (10,000+/- albums and live shows, 150,000+/- files). I'm very particular about my tagging and have my own genres for organizational purposes. 
After scanning everything in, I noticed that any genre that had a comma in it, would be split up into separate ones by Emby, even though they all contained the same files.
I went ahead and renamed the genres, removed the commas and everything worked as expected...with the exception of one stinking album, that retained the old genre metadata, and not what I would like it to show. Each individual song shows the correct data, but it's still showing the old multiple genres for the album itself. 
I have tried everything I can think of to fix this, with no luck. 
I looked up the error, and in the Linux forums for the same thing, it was suggested to rename library.db and do a full rescan. Thing is, my database file is almost 400mb and it took quite a while to scan and import everything I have. Is there any other way around this that anyone knows of? Error string is below.

Thank you in advance! 

2022-08-16 06:46:59.066 Info Server: http/1.1 POST http://localhost:8096/emby/Items/297168/Refresh?Recursive=true&ImageRefreshMode=FullRefresh&MetadataRefreshMode=FullRefresh&ReplaceAllImages=false&ReplaceAllMetadata=true&X-Emby-Client=Emby Web&X-Emby-Device-Name=Google Chrome Windows&X-Emby-Device-Id=a3144bba-6efd-4575-a56e-c5149a1088a2&X-Emby-Client-Version=4.7.6.0. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36
2022-08-16 06:46:59.072 Info Server: http/1.1 Response 204 to ::1. Time: 6ms. http://localhost:8096/emby/Items/297168/Refresh?Recursive=true&ImageRefreshMode=FullRefresh&MetadataRefreshMode=FullRefresh&ReplaceAllImages=false&ReplaceAllMetadata=true&X-Emby-Client=Emby Web&X-Emby-Device-Name=Google Chrome Windows&X-Emby-Device-Id=a3144bba-6efd-4575-a56e-c5149a1088a2&X-Emby-Client-Version=4.7.6.0
2022-08-16 06:46:59.412 Info HttpClient: GET https://musicbrainz.emby.tv/ws/2/release/?query="Further Down the Spiral [US]" AND artist:"Nine Inch Nails"
2022-08-16 06:46:59.691 Error SqliteItemRepository: Error saving items
    *** Error Report ***
    Version: 4.7.6.0
    Command line: D:\embyserver\system\EmbyServer.dll -noautorunwebapp
    Operating system: Microsoft Windows 10.0.19044
    Framework: .NET 6.0.7
    OS/Process: x64/x64
    Runtime: D:/embyserver/system/System.Private.CoreLib.dll
    Processor count: 8
    Data path: D:\embyserver\programdata
    Application path: D:\embyserver\system
    SQLitePCL.pretty.SQLiteException: Corrupt: database disk image is malformed
    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 Emby.Server.Implementations.Data.SqliteItemRepository.SaveItem(IDatabaseConnection db, BaseItem item, Int64 topParentId, Int64 userDataKeyId, IStatement insertItemStatement, IStatement updateItemStatement)
       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, CancellationToken cancellationToken)
    Source: SQLitePCL.pretty
    TargetSite: Void CheckOk(SQLitePCLEx.sqlite3, Int32)
    
2022-08-16 06:46:59.702 Error ProviderManager: Error refreshing item
    *** Error Report ***
    Version: 4.7.6.0
    Command line: D:\embyserver\system\EmbyServer.dll -noautorunwebapp
    Operating system: Microsoft Windows 10.0.19044
    Framework: .NET 6.0.7
    OS/Process: x64/x64
    Runtime: D:/embyserver/system/System.Private.CoreLib.dll
    Processor count: 8
    Data path: D:\embyserver\programdata
    Application path: D:\embyserver\system
    SQLitePCL.pretty.SQLiteException: Corrupt: database disk image is malformed
    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 Emby.Server.Implementations.Data.SqliteItemRepository.SaveItem(IDatabaseConnection db, BaseItem item, Int64 topParentId, Int64 userDataKeyId, IStatement insertItemStatement, IStatement updateItemStatement)
       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, CancellationToken cancellationToken)
       at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, MetadataRefreshOptions metadataRefreshOptions, CancellationToken cancellationToken)
       at Emby.Server.Implementations.Library.LibraryManager.UpdateItems(List`1 items, BaseItem parent, ItemUpdateType updateReason, Boolean setDateLastSaved, Boolean saveMetadata, MetadataRefreshOptions metadataRefreshOptions, CancellationToken cancellationToken)
       at Emby.Server.Implementations.Library.LibraryManager.UpdateItem(BaseItem item, BaseItem parent, ItemUpdateType updateReason, MetadataRefreshOptions metadataRefreshOptions)
       at MediaBrowser.Controller.Entities.BaseItem.UpdateToRepository(ItemUpdateType updateReason, MetadataRefreshOptions metadataRefreshOptions)
       at Emby.Providers.Manager.MetadataService`2.SaveItem(MetadataResult`1 result, Boolean isFirstRefresh, LibraryOptions libraryOptions, ItemUpdateType reason, IDirectoryService directoryService, MetadataRefreshOptions metadataRefreshOptions, CancellationToken cancellationToken)
       at Emby.Providers.Manager.MetadataService`2.RefreshMetadata(BaseItem item, MetadataRefreshOptions refreshOptions, LibraryOptions libraryOptions, CancellationToken cancellationToken)
       at MediaBrowser.Controller.Entities.BaseItem.RefreshMetadata(MetadataRefreshOptions options, LibraryOptions libraryOptions, CancellationToken cancellationToken)
       at Emby.Providers.Manager.ProviderManager.RefreshItem(BaseItem item, MetadataRefreshOptions options, CancellationToken cancellationToken)
       at Emby.Providers.Manager.ProviderManager.StartProcessingRefreshQueue()
    Source: SQLitePCL.pretty
    TargetSite: Void CheckOk(SQLitePCLEx.sqlite3, Int32)

[Abobader 3470]

Hello Skjellyfetti,

** 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

[Skjellyfetti 0]

So I did finally manage to get this to work, and I apologize for the false alarm! 

What I ended up doing was removing the album from my library, shutting down Embry, going into the programdata > metadata > musicgenres folder and deleting the genres I didn't want there. I also made a quick change to the title of the album in the ID tag, started up Embry, moved the album back in there, scanned and VIOLA!!! It finally worked. 

Ahhhhh now I'm not a stressed out OCD mess anymore LOL!!! 

 

[Luke 42085]

Hi, I think you might still have an issue even if you don't see it yet. I would suggest stepping through this to resolve the database error:

https://support.emby.media/support/solutions/articles/44002210894-corrupt-database

[Skjellyfetti 0]

Thank you, I'll definitely take a look into this...much appreciated!

[Luke 42085]

Let us know how you get on. Thanks.