SQL Logger Error INSERT INTO variable_history_942138985 (value) VALUES (%s);
SQL Logger Error exception trying to insert row into table variable_history_120520254 ("CPU_usage_TP-Link-Device")
SQL Logger Error database disk image is malformed
I tried to fix it using the utility plugin:
utilities starting SQLite job /usr/bin/python2.7 '/Library/Application Support/Perceptive Automation/Indigo 7/Plugins/utilities.indigoPlugin/Contents/Server Plugin/mkbackup.py' fix variable_history_1824208005
utilities ... started at 2019-02-25 14:41:50.590383
utilities FIX SQL job submitted, check ~/indigo/Utilities/backup.log/ for detailed info, this might take a long time (~ 1 hour for 8GByte on Mac-Mini 2014)
utilities FIX of SQLite failed, check logfile: /Users/jburgess/indigo/utilities/backup.log .. /Library/Application Support/Perceptive Automation/Indigo 7/logs/indigo_history-fixed.sqlite file not created
and when I look in that log, the only non-0 error I see is (just a few lines, not the whole log):
stepTest started :2019-01-13 13:35:02.896604
stepTest cmd: /usr/bin/sqlite3 '/Library/Application Support/Perceptive Automation/Indigo 7/logs/c-fixed.sqlite' "Select * from variable_history_1824208005;"
stepTest seconds used :0; error= Error: no such table: variable_history_1824208005
finished indigo sqlite job :2019-01-13 13:35:02.906757
total seconds used :0
I'm a novice at sqlite. Any help appreciated. Can I / Should I just delete the database?
/Library/Application\ Support/Perceptive\ Automation/Indigo\ 7/indigo_history.sqlite