After several days of running the Concord plug-in with no problems, it appears to crash with these messages in the log:
Dec-02 7:30:12 PM CONCORD Error An unexpected error occurred in the UpdateTrackingTable Err=unable to open database file unable to open database file function/subroutine: [System.Data.SQLite.SQLiteException: unable to open database file unable to open database file at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00000] in :0 at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x00000] in :0 at System.Data.SQLite.SQLiteDataReader.NextResult () [0x00000] in :0 at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, CommandBehavior behave) [0x00000] in :0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader:.ctor (System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavio r) at System.Data.SQLite.SQLiteCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in :0 at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00000] in :0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteCommand:ExecuteNonQuery () at HSPI_CONCORD.dbModule.updateTrackingTable () [0x00000] in :0 ]
Dec-02 7:30:12 PM CONCORD Error Error with SQL statement = Insert into Tracking (HCDC, TriggerDateTime, TimeSequence, ZoneNumber, ZoneName, Partition, Event) values('CONCORD_8', 1449106206, 380, 8, 'FAMILYROOMMOTION', 1, 'Faulted')
Dec-02 7:30:12 PM CONCORD Error An unexpected error occurred in the Timer1_Elapsed function/subroutine: [System.ObjectDisposedException: The object was used after being disposed. at System.Data.SQLite.SQLiteConnection.CheckDisposed () [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.get_State () [0x00000] in :0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteConnection:get_State () at HSPI_CONCORD.dbModule.updateTrackingTable () [0x00000] in :0 at HSPI_CONCORD.devModule.Timer1_Elapsed (System.Object sender, System.Timers.ElapsedEventArgs e) [0x00000] in :0 ]
Dec-02 7:30:18 PM CONCORD WriteLog() - Error Too many open files
Dec-02 7:30:21 PM CONCORD WriteLog() - Error Too many open files
Dec-02 7:30:22 PM CONCORD Error An unexpected error occurred in the UpdateTrackingTable Err=unable to open database file function/subroutine: [System.Data.SQLite.SQLiteException: unable to open database file at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool) [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in :0 ]
Dec-02 7:30:22 PM CONCORD Error Error with SQL statement =
Dec-02 7:30:22 PM CONCORD Error An unexpected error occurred in the Timer1_Elapsed function/subroutine: [System.ObjectDisposedException: The object was used after being disposed. at System.Data.SQLite.SQLiteConnection.CheckDisposed () [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.get_State () [0x00000] in :0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteConnection:get_State () at HSPI_CONCORD.dbModule.updateTrackingTable () [0x00000] in :0 at HSPI_CONCORD.devModule.Timer1_Elapsed (System.Object sender, System.Timers.ElapsedEventArgs e) [0x00000] in :0 ]
Dec-02 7:30:31 PM CONCORD WriteLog() - Error Too many open files
Dec-02 7:30:32 PM CONCORD Error An unexpected error occurred in the UpdateTrackingTable Err=unable to open database file function/subroutine: [System.Data.SQLite.SQLiteException: unable to open database file at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool) [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in :0 ]
Dec-02 7:30:32 PM CONCORD Error Error with SQL statement =
Dec-02 7:30:32 PM CONCORD Error An unexpected error occurred in the Timer1_Elapsed function/subroutine: [System.ObjectDisposedException: The object was used after being disposed. at System.Data.SQLite.SQLiteConnection.CheckDisposed () [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.get_State () [0x00000] in :0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteConnection:get_State () at HSPI_CONCORD.dbModule.updateTrackingTable () [0x00000] in :0 at HSPI_CONCORD.devModule.Timer1_Elapsed (System.Object sender, System.Timers.ElapsedEventArgs e) [0x00000] in :0 ]
Dec-02 7:30:33 PM CONCORD WriteLog() - Error Too many open files
Dec-02 7:30:34 PM CONCORD WriteLog() - Error Too many open files
Dec-02 7:30:37 PM CONCORD WriteLog() - Error Too many open files
Dec-02 7:30:42 PM CONCORD Error An unexpected error occurred in the UpdateTrackingTable Err=unable to open database file function/subroutine: [System.Data.SQLite.SQLiteException: unable to open database file at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool) [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in :0 ]
Dec-02 7:30:42 PM CONCORD Error Error with SQL statement =
Dec-02 7:30:42 PM CONCORD Error An unexpected error occurred in the Timer1_Elapsed function/subroutine: [System.ObjectDisposedException: The object was used after being disposed. at System.Data.SQLite.SQLiteConnection.CheckDisposed () [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.get_State () [0x00000] in :0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteConnection:get_State () at HSPI_CONCORD.dbModule.updateTrackingTable () [0x00000] in :0 at HSPI_CONCORD.devModule.Timer1_Elapsed (System.Object sender, System.Timers.ElapsedEventArgs e) [0x00000] in :0 ]
Dec-02 7:30:52 PM CONCORD Error An unexpected error occurred in the UpdateTrackingTable Err=unable to open database file function/subroutine: [System.Data.SQLite.SQLiteException: unable to open database file at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool) [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in :0 ]
Dec-02 7:30:52 PM CONCORD Error Error with SQL statement =
Dec-02 7:30:52 PM CONCORD Error An unexpected error occurred in the Timer1_Elapsed function/subroutine: [System.ObjectDisposedException: The object was used after being disposed. at System.Data.SQLite.SQLiteConnection.CheckDisposed () [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.get_State () [0x00000] in :0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteConnection:get_State () at HSPI_CONCORD.dbModule.updateTrackingTable () [0x00000] in :0 at HSPI_CONCORD.devModule.Timer1_Elapsed (System.Object sender, System.Timers.ElapsedEventArgs e) [0x00000] in :0 ]
Dec-02 7:31:02 PM CONCORD Error An unexpected error occurred in the UpdateTrackingTable Err=unable to open database file function/subroutine: [System.Data.SQLite.SQLiteException: unable to open database file at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool) [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in :0 ]
Dec-02 7:31:02 PM CONCORD Error Error with SQL statement =
If I shutdown restart it, things seem to work fine for a day or so till the same thing happens
Current Date/Time: 12/2/2015 8:15:07 PM
HomeSeer Version: HS3 ZEE S2 Edition 3.0.0.208
Linux version: Linux HomeTrollerZeeS2 3.18.11-v7+ #781 SMP PREEMPT Tue Apr 21 18:07:59 BST 2015 armv7l GNU/Linux System Uptime: 3 Days 6 Hours 17 Minutes 2 Seconds
IP Address: 192.168.0.161
Number of Devices: 103
Number of Events: 12
Enabled Plug-Ins
3.0.0.4: CM15A
3.1.13.2: CONCORD
3.0.0.68: HSTouch Server
3.0.1.25: Z-Wave
Dec-02 7:30:12 PM CONCORD Error An unexpected error occurred in the UpdateTrackingTable Err=unable to open database file unable to open database file function/subroutine: [System.Data.SQLite.SQLiteException: unable to open database file unable to open database file at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00000] in :0 at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x00000] in :0 at System.Data.SQLite.SQLiteDataReader.NextResult () [0x00000] in :0 at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, CommandBehavior behave) [0x00000] in :0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader:.ctor (System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavio r) at System.Data.SQLite.SQLiteCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in :0 at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00000] in :0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteCommand:ExecuteNonQuery () at HSPI_CONCORD.dbModule.updateTrackingTable () [0x00000] in :0 ]
Dec-02 7:30:12 PM CONCORD Error Error with SQL statement = Insert into Tracking (HCDC, TriggerDateTime, TimeSequence, ZoneNumber, ZoneName, Partition, Event) values('CONCORD_8', 1449106206, 380, 8, 'FAMILYROOMMOTION', 1, 'Faulted')
Dec-02 7:30:12 PM CONCORD Error An unexpected error occurred in the Timer1_Elapsed function/subroutine: [System.ObjectDisposedException: The object was used after being disposed. at System.Data.SQLite.SQLiteConnection.CheckDisposed () [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.get_State () [0x00000] in :0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteConnection:get_State () at HSPI_CONCORD.dbModule.updateTrackingTable () [0x00000] in :0 at HSPI_CONCORD.devModule.Timer1_Elapsed (System.Object sender, System.Timers.ElapsedEventArgs e) [0x00000] in :0 ]
Dec-02 7:30:18 PM CONCORD WriteLog() - Error Too many open files
Dec-02 7:30:21 PM CONCORD WriteLog() - Error Too many open files
Dec-02 7:30:22 PM CONCORD Error An unexpected error occurred in the UpdateTrackingTable Err=unable to open database file function/subroutine: [System.Data.SQLite.SQLiteException: unable to open database file at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool) [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in :0 ]
Dec-02 7:30:22 PM CONCORD Error Error with SQL statement =
Dec-02 7:30:22 PM CONCORD Error An unexpected error occurred in the Timer1_Elapsed function/subroutine: [System.ObjectDisposedException: The object was used after being disposed. at System.Data.SQLite.SQLiteConnection.CheckDisposed () [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.get_State () [0x00000] in :0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteConnection:get_State () at HSPI_CONCORD.dbModule.updateTrackingTable () [0x00000] in :0 at HSPI_CONCORD.devModule.Timer1_Elapsed (System.Object sender, System.Timers.ElapsedEventArgs e) [0x00000] in :0 ]
Dec-02 7:30:31 PM CONCORD WriteLog() - Error Too many open files
Dec-02 7:30:32 PM CONCORD Error An unexpected error occurred in the UpdateTrackingTable Err=unable to open database file function/subroutine: [System.Data.SQLite.SQLiteException: unable to open database file at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool) [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in :0 ]
Dec-02 7:30:32 PM CONCORD Error Error with SQL statement =
Dec-02 7:30:32 PM CONCORD Error An unexpected error occurred in the Timer1_Elapsed function/subroutine: [System.ObjectDisposedException: The object was used after being disposed. at System.Data.SQLite.SQLiteConnection.CheckDisposed () [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.get_State () [0x00000] in :0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteConnection:get_State () at HSPI_CONCORD.dbModule.updateTrackingTable () [0x00000] in :0 at HSPI_CONCORD.devModule.Timer1_Elapsed (System.Object sender, System.Timers.ElapsedEventArgs e) [0x00000] in :0 ]
Dec-02 7:30:33 PM CONCORD WriteLog() - Error Too many open files
Dec-02 7:30:34 PM CONCORD WriteLog() - Error Too many open files
Dec-02 7:30:37 PM CONCORD WriteLog() - Error Too many open files
Dec-02 7:30:42 PM CONCORD Error An unexpected error occurred in the UpdateTrackingTable Err=unable to open database file function/subroutine: [System.Data.SQLite.SQLiteException: unable to open database file at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool) [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in :0 ]
Dec-02 7:30:42 PM CONCORD Error Error with SQL statement =
Dec-02 7:30:42 PM CONCORD Error An unexpected error occurred in the Timer1_Elapsed function/subroutine: [System.ObjectDisposedException: The object was used after being disposed. at System.Data.SQLite.SQLiteConnection.CheckDisposed () [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.get_State () [0x00000] in :0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteConnection:get_State () at HSPI_CONCORD.dbModule.updateTrackingTable () [0x00000] in :0 at HSPI_CONCORD.devModule.Timer1_Elapsed (System.Object sender, System.Timers.ElapsedEventArgs e) [0x00000] in :0 ]
Dec-02 7:30:52 PM CONCORD Error An unexpected error occurred in the UpdateTrackingTable Err=unable to open database file function/subroutine: [System.Data.SQLite.SQLiteException: unable to open database file at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool) [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in :0 ]
Dec-02 7:30:52 PM CONCORD Error Error with SQL statement =
Dec-02 7:30:52 PM CONCORD Error An unexpected error occurred in the Timer1_Elapsed function/subroutine: [System.ObjectDisposedException: The object was used after being disposed. at System.Data.SQLite.SQLiteConnection.CheckDisposed () [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.get_State () [0x00000] in :0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteConnection:get_State () at HSPI_CONCORD.dbModule.updateTrackingTable () [0x00000] in :0 at HSPI_CONCORD.devModule.Timer1_Elapsed (System.Object sender, System.Timers.ElapsedEventArgs e) [0x00000] in :0 ]
Dec-02 7:31:02 PM CONCORD Error An unexpected error occurred in the UpdateTrackingTable Err=unable to open database file function/subroutine: [System.Data.SQLite.SQLiteException: unable to open database file at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool) [0x00000] in :0 at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in :0 ]
Dec-02 7:31:02 PM CONCORD Error Error with SQL statement =
If I shutdown restart it, things seem to work fine for a day or so till the same thing happens
Current Date/Time: 12/2/2015 8:15:07 PM
HomeSeer Version: HS3 ZEE S2 Edition 3.0.0.208
Linux version: Linux HomeTrollerZeeS2 3.18.11-v7+ #781 SMP PREEMPT Tue Apr 21 18:07:59 BST 2015 armv7l GNU/Linux System Uptime: 3 Days 6 Hours 17 Minutes 2 Seconds
IP Address: 192.168.0.161
Number of Devices: 103
Number of Events: 12
Enabled Plug-Ins
3.0.0.4: CM15A
3.1.13.2: CONCORD
3.0.0.68: HSTouch Server
3.0.1.25: Z-Wave
Comment