Announcement

Collapse
No announcement yet.

Concord database pruning throws this error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Concord database pruning throws this error

    Haven't seen a log error on the Concord plugin in quite a while but the midnight pruning routine threw the following error.

    Apr-26 00:00:17 * CONCORD Error An unexpected error occurred in the compactDB() function/subroutine: [System.Data.SQLite.SQLiteException (0x80004005): library routine called out of sequence null connection or database handle at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00083] in <11a72aa9b7eb459d9770aa264de2a0ab>:0 at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0003c] in <11a72aa9b7eb459d9770aa264de2a0ab>:0 at System.Data.SQLite.SQLiteDataReader.NextResult () [0x0013c] in <11a72aa9b7eb459d9770aa264de2a0ab>:0 at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) [0x0005d] in <11a72aa9b7eb459d9770aa264de2a0ab>:0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader..ctor(System.Data.SQLite .SQLiteCommand,System.Data.CommandBehavior) at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <11a72aa9b7eb459d9770aa264de2a0ab>:0 at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00006] in <11a72aa9b7eb459d9770aa264de2a0ab>:0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() at HSPI_CONCORD.dbModule.compactDB () [0x0003f] in <43b49f4db3f247a79804a6e085515007>:0 ]

    Not really sure what has caused this.

  • #2
    Originally posted by concordseer View Post
    Haven't seen a log error on the Concord plugin in quite a while but the midnight pruning routine threw the following error.

    Apr-26 00:00:17 * CONCORD Error An unexpected error occurred in the compactDB() function/subroutine: [System.Data.SQLite.SQLiteException (0x80004005): library routine called out of sequence null connection or database handle at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00083] in <11a72aa9b7eb459d9770aa264de2a0ab>:0 at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0003c] in <11a72aa9b7eb459d9770aa264de2a0ab>:0 at System.Data.SQLite.SQLiteDataReader.NextResult () [0x0013c] in <11a72aa9b7eb459d9770aa264de2a0ab>:0 at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) [0x0005d] in <11a72aa9b7eb459d9770aa264de2a0ab>:0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader..ctor(System.Data.SQLite .SQLiteCommand,System.Data.CommandBehavior) at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <11a72aa9b7eb459d9770aa264de2a0ab>:0 at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00006] in <11a72aa9b7eb459d9770aa264de2a0ab>:0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() at HSPI_CONCORD.dbModule.compactDB () [0x0003f] in <43b49f4db3f247a79804a6e085515007>:0 ]

    Not really sure what has caused this.
    I've seen the same thing, but never was able to narrow it done as it occurs so infrequently. I'm pretty sure it's a timing issue where HS3 is being slowed down just enough to cause an open/close of the db to fail.

    LMK if it becomes more common place where we might be able to track it down.

    Z

    Comment


    • #3
      Originally posted by vasrc View Post
      I've seen the same thing, but never was able to narrow it done as it occurs so infrequently. I'm pretty sure it's a timing issue where HS3 is being slowed down just enough to cause an open/close of the db to fail.

      LMK if it becomes more common place where we might be able to track it down.

      Z
      I was thinking the same. I'll wait till the next pruning operation and let you know if it occurs again. Thanks!

      Comment

      Working...
      X