Multiple errors after 2022.2 upgrade

Restarting after 2022.2 upgrade, my log is filled with stuff like this:

Code: Select all

   SQL Logger Error                Error in plugin execution ServerReplacedElem:

  File "plugin.py", line 298, in deviceUpdated
  File "plugin.py", line 505, in _update_device_history
  File "plugin.py", line 645, in _cache_table_schema
  File "/Library/Application Support/Perceptive Automation/Indigo 2022.2/Plugins/SQL Logger.indigoPlugin/Contents/Server Plugin/indigologger/indigodb.py", line 107, in metadata_schema
  File "/Library/Application Support/Perceptive Automation/Indigo 2022.2/Plugins/SQL Logger.indigoPlugin/Contents/Server Plugin/indigologger/indigodb.py", line 105, in metadata_schema
  File "/Library/Application Support/Perceptive Automation/Indigo 2022.2/Plugins/SQL Logger.indigoPlugin/Contents/Server Plugin/indigologger/sqlfactory_sqlite.py", line 150, in execute_query
type: database disk image is malformed

   SQL Logger Error                Failed to create table to store event log history: database disk image is malformed
   SQL Logger Error                Error in plugin execution ServerReplacedElem:

  File "plugin.py", line 298, in deviceUpdated
  File "plugin.py", line 505, in _update_device_history
  File "plugin.py", line 645, in _cache_table_schema
  File "/Library/Application Support/Perceptive Automation/Indigo 2022.2/Plugins/SQL Logger.indigoPlugin/Contents/Server Plugin/indigologger/indigodb.py", line 107, in metadata_schema
  File "/Library/Application Support/Perceptive Automation/Indigo 2022.2/Plugins/SQL Logger.indigoPlugin/Contents/Server Plugin/indigologger/indigodb.py", line 105, in metadata_schema
  File "/Library/Application Support/Perceptive Automation/Indigo 2022.2/Plugins/SQL Logger.indigoPlugin/Contents/Server Plugin/indigologger/sqlfactory_sqlite.py", line 150, in execute_query
type: database disk image is malformed

   SQL Logger Error                One or more failures updating device history; see the debug log for details
   SQL Logger Error                One or more failures updating device history; see the debug log for details
   SQL Logger Error                One or more failures updating device history; see the debug log for details
   SQL Logger Error                One or more failures updating device history; see the debug log for details
   SQL Logger Error                One or more failures updating device history; see the debug log for details
   SQL Logger Error                One or more failures updating device history; see the debug log for details
   SQL Logger Error                One or more failures updating device history; see the debug log for details
   SQL Logger Error                One or more failures updating device history; see the debug log for details


I wasn't really using it anyway, so I have disabled the plugin. But what might be going on?

[jay (support)]

It looks like the mysql database file has become corrupt. It's located here:

Code: Select all

/Library/Application Support/Perceptive Automation/Indigo 2022.2/Logs/indigo_history.sqlite

While the plugin is disabled, delete that file. then enable the plugin and it should create a new db file.

And maybe consider switching to Postgres rather than sql lite if you are starting again.

I'm seeing similar errors after the 2022.2 upgrade, but I'm already using Postgres (ok, in the interest of full disclosure, it's timescaledb, but there hasn't been any issues until the 2022.2 upgrade). I'm seeing errors like this in my indigo log:

Code: Select all

   NOAA Weather                    '### Weather' changed at 2023-03-08 03:53:00'.
   SQL Logger Error                One or more failures updating device history; see the debug log for details


I'm assuming the debug log is located at:
/Library/Application Support/Perceptive Automation/Indigo 2022.2/Logs/indigoplugin.sql-logger/plugin.log

The corresponding entry in that log is simply :

Code: Select all

2023-03-08 04:11:52.386 ERROR   Plugin._log_error_unobtrusive:  One or more failures updating device history; see the debug log for details


I grepped for all the errors of this type since the upgrade in the log directory. As far as I can tell, only happen after the NOAA plugin tries to do an update. Anyway, I turned on debug logging on the sql logger just now. I'll try to catch it next time to see if that exposes more info, but if anyone else has already had this issue just wanted to throw it out there in case there's already an easy fix.

And maybe consider switching to Postgres rather than sql lite if you are starting again.

Not that I want to switch or am having problems with the db, but how DOES one switch?