Jump to content

Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown


bigeyez

Recommended Posts

Suddenly I started getting these errors and some of my media seems to be missing covers. Where should I look into first?

 

 

error

Chapter image extraction failed.
3 minutes ago
Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
error
Scan media library failed.
an hour ago
Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.

 

 

I am on Debian Testing x64 using Emby-Beta

Link to comment
Share on other sites

I even restored from the back up and getting the same issue.

 

Here is some info from the log

       Processor count: 8                                                                                                                                                           [21/1932]
        Program data path: /media/SYSLINX/var/lib/emby-server                                                                                          
        Application directory: /usr/lib/emby-server/bin                                                                                                                                     
        Corrupt: database disk image is malformed                                                                                                                                                     SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
          at SQLitePCL.pretty.SQLiteException.CheckOk (SQLitePCL.sqlite3 db, System.Int32 rc) [0x0001a] in <926d5dc8f35f4aae9a6008f11f233fd0>:0                                          
          at SQLitePCL.pretty.SQLiteException.CheckOk (SQLitePCL.sqlite3_stmt stmt, System.Int32 rc) [0x00006] in <926d5dc8f35f4aae9a6008f11f233fd0>:0    
          at SQLitePCL.pretty.StatementImpl.MoveNext () [0x00056] in <926d5dc8f35f4aae9a6008f11f233fd0>:0
          at Emby.Server.Implementations.Data.SqliteExtensions+<ExecuteQuery>c__Iterator0.MoveNext () [0x0004b] in <9f419e4dfa6b4379b55068d8fd39f290>:0
          at Emby.Server.Implementations.Data.SqliteItemRepository.GetItemList (MediaBrowser.Controller.Entities.InternalItemsQuery query) [0x002a1] in <9f419e4dfa6b4379b55068d8fd39f290>:0
          at Emby.Server.Implementations.Library.LibraryManager.GetItemList (MediaBrowser.Controller.Entities.InternalItemsQuery query, System.Boolean allowExternalContent) [0x0006d] in <9f4
19e4dfa6b4379b55068d8fd39f290>:0                                                                                                                         
          at Emby.Server.Implementations.Library.LibraryManager.GetItemList (MediaBrowser.Controller.Entities.InternalItemsQuery query) [0x00000] in <9f419e4dfa6b4379b55068d8fd39f290>:0
          at Emby.Server.Implementations.ScheduledTasks.ChapterImagesTask+<Execute>c__async0.MoveNext () [0x00095] in <9f419e4dfa6b4379b55068d8fd39f290>:0          
        --- End of stack trace from previous location where exception was thrown ---
          at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <8f2c484307284b51944a1a13a14c0266>:0
          at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0004e] in <8f2c484307284b51944a1a13a14c0266>:0
          at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x0002e] in <8f2c484307284b51944a1a13a14c0266>:0
          at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x0000b] in <8f2c484307284b51944a1a13a14c0266>:0
          at System.Runtime.CompilerServices.ConfiguredTaskAwaitable+ConfiguredTaskAwaiter.GetResult () [0x00000] in <8f2c484307284b51944a1a13a14c0266>:0                                               at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker+<ExecuteInternal>c__async2.MoveNext () [0x0019c] in <9f419e4dfa6b4379b55068d8fd39f290>:0
        SQLitePCL.pretty.SQLiteException                                                                                                                                     
          at SQLitePCL.pretty.SQLiteException.CheckOk (SQLitePCL.sqlite3 db, System.Int32 rc) [0x0001a] in <926d5dc8f35f4aae9a6008f11f233fd0>:0
          at SQLitePCL.pretty.SQLiteException.CheckOk (SQLitePCL.sqlite3_stmt stmt, System.Int32 rc) [0x00006] in <926d5dc8f35f4aae9a6008f11f233fd0>:0
          at SQLitePCL.pretty.StatementImpl.MoveNext () [0x00056] in <926d5dc8f35f4aae9a6008f11f233fd0>:0
          at Emby.Server.Implementations.Data.SqliteExtensions+<ExecuteQuery>c__Iterator0.MoveNext () [0x0004b] in <9f419e4dfa6b4379b55068d8fd39f290>:0
 at Emby.Server.Implementations.Data.SqliteExtensions+<ExecuteQuery>c__Iterator0.MoveNext () [0x0004b] in <9f419e4dfa6b4379b55068d8fd39f290>:0
          at Emby.Server.Implementations.Data.SqliteItemRepository.GetItemList (MediaBrowser.Controller.Entities.InternalItemsQuery query) [0x002a1] in <9f419e4dfa6b4379b55068d8fd39f290>:0
          at Emby.Server.Implementations.Library.LibraryManager.GetItemList (MediaBrowser.Controller.Entities.InternalItemsQuery query, System.Boolean allowExternalContent) [0x0006d] in <9f4
19e4dfa6b4379b55068d8fd39f290>:0
          at Emby.Server.Implementations.Library.LibraryManager.GetItemList (MediaBrowser.Controller.Entities.InternalItemsQuery query) [0x00000] in <9f419e4dfa6b4379b55068d8fd39f290>:0
          at Emby.Server.Implementations.ScheduledTasks.ChapterImagesTask+<Execute>c__async0.MoveNext () [0x00095] in <9f419e4dfa6b4379b55068d8fd39f290>:0
        --- End of stack trace from previous location where exception was thrown ---
          at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <8f2c484307284b51944a1a13a14c0266>:0
          at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0004e] in <8f2c484307284b51944a1a13a14c0266>:0
          at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x0002e] in <8f2c484307284b51944a1a13a14c0266>:0
          at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x0000b] in <8f2c484307284b51944a1a13a14c0266>:0
          at System.Runtime.CompilerServices.ConfiguredTaskAwaitable+ConfiguredTaskAwaiter.GetResult () [0x00000] in <8f2c484307284b51944a1a13a14c0266>:0
          at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker+<ExecuteInternal>c__async2.MoveNext () [0x0019c] in <9f419e4dfa6b4379b55068d8fd39f290>:0



Edited by bigeyez
Link to comment
Share on other sites

Somehow your database file has become corrupted.  You'll need to rename this file, restart the server and run a library scan:

/media/SYSLINX/var/lib/emby-server/data/library.db

The most typical cause of this is abruptly terminating the server process in an ungraceful manner, e.g. a power loss, forcefully shutting down the machine, etc.

Link to comment
Share on other sites

Thanks, I will try it.

 

It seems like it happened last night, must be a drive issue.

 

Somehow your database file has become corrupted.  You'll need to rename this file, restart the server and run a library scan:

/media/SYSLINX/var/lib/emby-server/data/library.db

The most typical cause of this is abruptly terminating the server process in an ungraceful manner, e.g. a power loss, forcefully shutting down the machine, etc.

Link to comment
Share on other sites

  • 5 months later...

I just got the same error 

Scan media library failed.
6 minutes ago
Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
 
What is the path to the .db and do I change the library.db to something like library.old?
Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...