HSBuddy DB Maintenace error - New

[langenet]

Antonio,

I've had HSbuddy installed just over a month and due to a lack of time, only configured a few devices in the dashboard.
Starting about 3:00AM this morning, about every 15 minutes I get the following in the log - perhaps history db maintenance errors.

Aug-11 9:34:45 AM

Info

Plugin HSBuddy has connected. IP:127.0.0.1:49301

Aug-11 9:34:34 AM

HSBuddy

Failed to cleanup the devices table: SQLite.SQLiteException: IOError at SQLite.SQLiteCommand.ExecuteNonQuery() at SQLite.TableQuery`1.Delete(Expression`1 predExpr) at HSPI_HSBuddy.History.DeviceHistory.CleanupCallback(Object context)

My server has been up for 30 days and is running HS3 Pro Edition 3.0.0.548 (Windows) and 3.18.721.0 of HSBuddy.

I guess somehow something is up with the DB as I can browse the ClientInfo table but all others are empty using DB Browser for SQLite. Mind you, I don't see a History table.
While selecting Erase All in the config menu, I get the following:

Aug-11 9:44:49 AM

HSBuddy

Unhandled exception during PostBackProc for HSBuddyConfiguration: SQLite.SQLiteException: IOError at SQLite.SQLiteCommand.ExecuteNonQuery() at SQLite.SQLiteConnection.Execute(String query, Object[] args) at SQLite.SQLiteConnection.DropTable(TableMapping map) at SQLite.SQLiteConnection.DropTable[T]() at HSPI_HSBuddy.History.DeviceHistory.EraseAll() at HSPI_HSBuddy.WebPages.ConfigurationPage.PostBackProc(NameVal ueCollection query) at HSPI_HSBuddy.WebPages.WebPageBase.PostBackProc(String data, String user, Int32 userRights)

Just to confirm, I suppose just delete the db and restart the plugin? I only have one client configured.

Thanks,

Robert

[langenet]

I deleted the hsbuddy.db3 file, then started HSBuddy which recreated it just fine. For reasons I don't know, it looks like the DeviceChange got dropped somehow...

Anyway, all good now.

[rge]

I have the same error, and don't really want to lose dashboards and such.

Is deleting the db file the way to go, or is there another option?

Thanks.