Server Issues

[bretswinney 22]

My server has been acting strange for a day or so. I need some help with a few things

 

1. Library Scans are not working & it will not allow me to remove a library.

2. Auto Organize will not work but this could be due to the library issue but not sure.

 

Please advise on what I can do to get these issues fixed.

 

Thanks in advance!

[Luke 40145]

Hi there, let's look at an example:

Thanks.

[bretswinney 22]

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, ReadOnlySpan`1 sqlUtf8)
at SQLitePCL.pretty.DatabaseConnection.RollbackTransaction(IDatabaseConnection This)
at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, Action`1 afterSave, CancellationToken cancellationToken)
at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, CancellationToken cancellationToken)
at Emby.Server.Implementations.Library.LibraryManager.CreateItems(List`1 items, BaseItem parent, CancellationToken cancellationToken)
at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal(IProgress`1 progress, CancellationToken cancellationToken, Boolean recursive, Boolean refreshChildMetadata, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService)
at MediaBrowser.Controller.Entities.Folder.ValidateSubFolders(BaseItem[] children, IDirectoryService directoryService, IProgress`1 progress, CancellationToken cancellationToken)
at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal(IProgress`1 progress, CancellationToken cancellationToken, Boolean recursive, Boolean refreshChildMetadata, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService)
at Emby.Server.Implementations.Library.LibraryManager.PerformLibraryValidation(IProgress`1 progress, CancellationToken cancellationToken)
at Emby.Server.Implementations.Library.LibraryManager.ValidateMediaLibraryInternal(IProgress`1 progress, CancellationToken cancellationToken)
at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)

[bretswinney 22]

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, ReadOnlySpan`1 sqlUtf8)
at SQLitePCL.pretty.DatabaseConnection.RollbackTransaction(IDatabaseConnection This)
at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteChannels(Int64[] idsToDelete)
at Emby.LiveTV.LiveTvManager.CleanDeadChannels(Int64[] currentIdList)
at Emby.LiveTV.LiveTvManager.RefreshChannelsInternal(IProgress`1 progress, CancellationToken cancellationToken)
at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)

[bretswinney 22]

embyserver.txt

[Happy2Play 9459]

You will need to follow the steps in the KB, since it throws malformed, you will most likely need to reset the database.

SQLitePCL.pretty.SQLiteException: Error: cannot rollback - no transaction is active

SQLitePCL.pretty.SQLiteException: Corrupt: database disk image is malformed

Corrupt Database : Emby