database disk image is malformed

[marauder 17]

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.

[Luke 37248]

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.

[marauder 17]

Thanks, that fixed it.

[Luke 37248]

Thanks for the feedback.

[Shadowking 3]

It did the trick for me too, thank you.