marauder 17 Posted October 23, 2018 Share Posted October 23, 2018 I am unable to view any of my files an my library doesn't reload or show any folders. When i try to refresh it fails and I get this alert. 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.SqliteExtensions.ExecuteQuery(IStatement This)+MoveNext() at Emby.Server.Implementations.Data.SqliteItemRepository.RetrieveItem(Guid id) at Emby.Server.Implementations.Library.LibraryManager.GetItemById(Guid id) at Emby.Server.Implementations.Library.LibraryManager.CreateRootFolder() at Emby.Server.Implementations.Library.LibraryManager.get_RootFolder() at Emby.Server.Implementations.IO.LibraryMonitor.Start() at Emby.Server.Implementations.Library.LibraryManager.ValidateMediaLibraryInternal(IProgress`1 progress, CancellationToken cancellationToken) at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options) when checking the logs I see these blocks: 2018-10-23 00:25:02.213 Error HttpServer: Error processing request *** Error Report *** Version: 3.5.3.0 Command line: /system/EmbyServer.dll -programdata /config -ffmpeg /bin/ffmpeg -ffprobe /bin/ffprobe -restartexitcode 3 Operating system: Unix 4.18.15.0 64-Bit OS: True 64-Bit Process: True User Interactive: True Processor count: 8 Program data path: /config Application directory: /system 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.SqliteExtensions.ExecuteQuery(IStatement This)+MoveNext() at Emby.Server.Implementations.Data.SqliteItemRepository.RetrieveItem(Guid id) at Emby.Server.Implementations.Library.LibraryManager.GetItemById(Guid id) at Emby.Server.Implementations.Library.LibraryManager.GetUserRootFolder() at Emby.Server.Implementations.Dto.DtoService.GetBaseItemDtos(IEnumerable`1 items, Int32 itemCount, DtoOptions options, User user, BaseItem owner) at Emby.Server.Implementations.LiveTv.LiveTvManager.GetRecordings(RecordingQuery query, DtoOptions options) at MediaBrowser.Api.LiveTv.LiveTvService.Get(GetRecordings request) at Emby.Server.Implementations.Services.ServiceExecGeneral.Execute(Type serviceType, IRequest request, Object instance, Object requestDto, String requestName) at Emby.Server.Implementations.Services.ServiceController.Execute(HttpListenerHost appHost, Object requestDto, IRequest req) at Emby.Server.Implementations.Services.ServiceHandler.ProcessRequestAsync(HttpListenerHost appHost, IRequest httpReq, IResponse httpRes, ILogger logger, String operationName, CancellationToken cancellationToken) at Emby.Server.Implementations.HttpServer.HttpListenerHost.RequestHandler(IHttpRequest httpReq, String urlString, String host, String localPath, CancellationToken cancellationToken) SQLitePCL.pretty.SQLiteException at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc) at SQLitePCL.pretty.StatementImpl.MoveNext() at Emby.Server.Implementations.Data.SqliteExtensions.ExecuteQuery(IStatement This)+MoveNext() at Emby.Server.Implementations.Data.SqliteItemRepository.RetrieveItem(Guid id) at Emby.Server.Implementations.Library.LibraryManager.GetItemById(Guid id) at Emby.Server.Implementations.Library.LibraryManager.GetUserRootFolder() at Emby.Server.Implementations.Dto.DtoService.GetBaseItemDtos(IEnumerable`1 items, Int32 itemCount, DtoOptions options, User user, BaseItem owner) at Emby.Server.Implementations.LiveTv.LiveTvManager.GetRecordings(RecordingQuery query, DtoOptions options) at MediaBrowser.Api.LiveTv.LiveTvService.Get(GetRecordings request) at Emby.Server.Implementations.Services.ServiceExecGeneral.Execute(Type serviceType, IRequest request, Object instance, Object requestDto, String requestName) at Emby.Server.Implementations.Services.ServiceController.Execute(HttpListenerHost appHost, Object requestDto, IRequest req) at Emby.Server.Implementations.Services.ServiceHandler.ProcessRequestAsync(HttpListenerHost appHost, IRequest httpReq, IResponse httpRes, ILogger logger, String operationName, CancellationToken cancellationToken) at Emby.Server.Implementations.HttpServer.HttpListenerHost.RequestHandler(IHttpRequest httpReq, String urlString, String host, String localPath, CancellationToken cancellationToken) 2018-10-23 00:24:56.601 Error TaskManager: Error *** Error Report *** Version: 3.5.3.0 Command line: /system/EmbyServer.dll -programdata /config -ffmpeg /bin/ffmpeg -ffprobe /bin/ffprobe -restartexitcode 3 Operating system: Unix 4.18.15.0 64-Bit OS: True 64-Bit Process: True User Interactive: True Processor count: 8 Program data path: /config Application directory: /system 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.SqliteExtensions.ExecuteQuery(IStatement This)+MoveNext() at Emby.Server.Implementations.Data.SqliteItemRepository.RetrieveItem(Guid id) at Emby.Server.Implementations.Library.LibraryManager.GetItemById(Guid id) at Emby.Server.Implementations.Library.LibraryManager.CreateRootFolder() at Emby.Server.Implementations.Library.LibraryManager.get_RootFolder() at Emby.Server.Implementations.IO.LibraryMonitor.Start() at Emby.Server.Implementations.Library.LibraryManager.ValidateMediaLibraryInternal(IProgress`1 progress, CancellationToken cancellationToken) at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options) SQLitePCL.pretty.SQLiteException at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc) at SQLitePCL.pretty.StatementImpl.MoveNext() at Emby.Server.Implementations.Data.SqliteExtensions.ExecuteQuery(IStatement This)+MoveNext() at Emby.Server.Implementations.Data.SqliteItemRepository.RetrieveItem(Guid id) at Emby.Server.Implementations.Library.LibraryManager.GetItemById(Guid id) at Emby.Server.Implementations.Library.LibraryManager.CreateRootFolder() at Emby.Server.Implementations.Library.LibraryManager.get_RootFolder() at Emby.Server.Implementations.IO.LibraryMonitor.Start() at Emby.Server.Implementations.Library.LibraryManager.ValidateMediaLibraryInternal(IProgress`1 progress, CancellationToken cancellationToken) at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options) I'm assuming one of my DBs got corrupted. Is it possible to repair or do I need to delete it and rebuild that DB? I'm thinking both my Library and TaskManger are having issues. So would I delete these files? /mnt/user/appdata/EmbyServer/data# ls ScheduledTasks/ library.db-shm library.db-wal library.db I just don't wan to delete more than I need to. Ideally if i can repair it'd rather do that. Thanks. Link to comment Share on other sites More sharing options...
Solution Luke 37289 Posted October 23, 2018 Solution Share Posted October 23, 2018 Hi, you'll need to shut down the server and rename this file: /config/data/library.db Then start back up and run a full library scan. Typical causes of this are sudden and abrupt terminations of the emby server process, such as a power loss, operating system crash, force killing the server process, etc. 2 1 Link to comment Share on other sites More sharing options...
marauder 17 Posted October 23, 2018 Author Share Posted October 23, 2018 Thanks, that fixed it. Link to comment Share on other sites More sharing options...
Luke 37289 Posted October 23, 2018 Share Posted October 23, 2018 Thanks for the feedback. 1 Link to comment Share on other sites More sharing options...
Shadowking 3 Posted July 8, 2020 Share Posted July 8, 2020 It did the trick for me too, thank you. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now