Channel Guide SQL Lite corruption error

[glandpuck 0]

My channel guide does not work using zap2xml or schedules direct.  I get a SQL error message.

 

This is from my log file:

 

2018-01-02 09:51:11.865 Error HttpServer: Error processing request
*** Error Report ***
Version: 3.2.60.0
Command line: C:\Users\xxxxx\AppData\Roaming\Emby-Server\system\EmbyServer.dll
Operating system: Microsoft Windows NT 6.2.9200.0
64-Bit OS: True
64-Bit Process: True
User Interactive: True
Processor count: 8
Program data path: C:\Users\xxxxx\AppData\Roaming\Emby-Server
Application directory: C:\Users\xxxxx\AppData\Roaming\Emby-Server\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>d__36.MoveNext()
   at Emby.Server.Implementations.Data.SqliteItemRepository.<>c__DisplayClass64_0.<GetItems>b__0(IDatabaseConnection db)
   at SQLitePCL.pretty.DatabaseConnection.RunInTransaction[T](IDatabaseConnection This, Func`2 f, TransactionMode mode)
   at Emby.Server.Implementations.Data.SqliteItemRepository.GetItems(InternalItemsQuery query)
   at Emby.Server.Implementations.Library.LibraryManager.GetItemsResult(InternalItemsQuery query)
   at Emby.Server.Implementations.LiveTv.LiveTvManager.GetInternalChannels(LiveTvChannelQuery query, DtoOptions dtoOptions, CancellationToken cancellationToken)
   at MediaBrowser.Api.LiveTv.LiveTvService.Get(GetChannels request)
   at Emby.Server.Implementations.Services.ServiceExecGeneral.<Execute>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Emby.Server.Implementations.Services.ServiceHandler.<ProcessRequestAsync>d__15.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Emby.Server.Implementations.HttpServer.HttpListenerHost.<RequestHandler>d__72.MoveNext()
SQLitePCL.pretty.SQLiteException
   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
   at SQLitePCL.pretty.StatementImpl.MoveNext()
   at Emby.Server.Implementations.Data.SqliteExtensions.<ExecuteQuery>d__36.MoveNext()
   at Emby.Server.Implementations.Data.SqliteItemRepository.<>c__DisplayClass64_0.<GetItems>b__0(IDatabaseConnection db)
   at SQLitePCL.pretty.DatabaseConnection.RunInTransaction[T](IDatabaseConnection This, Func`2 f, TransactionMode mode)
   at Emby.Server.Implementations.Data.SqliteItemRepository.GetItems(InternalItemsQuery query)
   at Emby.Server.Implementations.Library.LibraryManager.GetItemsResult(InternalItemsQuery query)
   at Emby.Server.Implementations.LiveTv.LiveTvManager.GetInternalChannels(LiveTvChannelQuery query, DtoOptions dtoOptions, CancellationToken cancellationToken)
   at MediaBrowser.Api.LiveTv.LiveTvService.Get(GetChannels request)
   at Emby.Server.Implementations.Services.ServiceExecGeneral.<Execute>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Emby.Server.Implementations.Services.ServiceHandler.<ProcessRequestAsync>d__15.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Emby.Server.Implementations.HttpServer.HttpListenerHost.<RequestHandler>d__72.MoveNext()
 
I haven't figured out how to fix it.

Help would be appreciated.

[Luke 42077]

Hi, please shutdown emby server, then rename this file:

C:\Users\xxxxx\AppData\Roaming\Emby-Server\data\library.db

Then start emby server and you'll need to run a library scan and refresh your guide.

 

Typical causes of this are sudden terminations of the emby server process - for example, a power loss, abruptly killing the server process, abruptly shutting down your machine, etc. 

 

Please let us know if this helps.

[glandpuck 0]

That solved the problem and all is now working.  I did have a power outage a while back.  The computer is now on a UPS.

Thanks.

[Luke 42077]

Thanks for the feedback

[Jim-Bob Billy-io 0]

Forgive me for being ignorant; but, rename the file to what?

[Luke 42077]

Forgive me for being ignorant; but, rename the file to what?

 

To anything different, and the server will generate a new one the next time you start it. I said rename rather than to delete just in case you may want to try and extract something from it at some point.