SQL Logger Error after update to Indigo 6.1.8

Posted on
Mon Apr 25, 2016 10:23 am
lindehoff offline
Posts: 80
Joined: Aug 08, 2015

SQL Logger Error after update to Indigo 6.1.8

After I upgraded to Indigo 6.1.8 I started to get a lot of SQL Logger Error, here i an example:
Code: Select all
  SQL Logger Error                exception trying to insert row into table device_history_564722319 ("Sonos Play 1 - Kitchen") -- unable to modify table
  SQL Logger Error                ERROR:  column "alive" of relation "device_history_564722319" does not exist at character 558

The error are in the same nature but different tables and columns.
It is not specific to a device type it occurs for all devices types and variables.

Posted on
Mon Apr 25, 2016 11:05 am
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: SQL Logger Error after update to Indigo 6.1.8

Looks Like your db is corrupted



Sent from my iPhone using Tapatalk

Posted on
Mon Apr 25, 2016 11:31 am
lindehoff offline
Posts: 80
Joined: Aug 08, 2015

Re: SQL Logger Error after update to Indigo 6.1.8

kw123 wrote:
Looks Like your db is corrupted

I really hope not, I can access the database with pgAdmin.

Posted on
Mon Apr 25, 2016 11:36 am
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: SQL Logger Error after update to Indigo 6.1.8

You could do
-Stop Indigo server
-Sqlite3 sqlitehistory .dump > dumpfile
Then
-SQLite3 newdb < dumpfile
Then
-mv newdb to sqlitehistory

All in the logs directory in indigo
Or
Try indigoutilities and select menu restore or something like this

That does step 2 and 3. And some more things.

As alway I suggest to do an hourly db copy of your sql-db then let timemachine do its thing



Sent from my iPhone using Tapatalk

Posted on
Mon Apr 25, 2016 11:55 am
lindehoff offline
Posts: 80
Joined: Aug 08, 2015

Re: SQL Logger Error after update to Indigo 6.1.8

kw123 wrote:
You could do
-Stop Indigo server
-Sqlite3 sqlitehistory .dump > dumpfile
Then
-SQLite3 newdb < dumpfile
Then
-mv newdb to sqlitehistory

All in the logs directory in indigo
Or
Try indigoutilities and select menu restore or something like this

That does step 2 and 3. And some more things.

As alway I suggest to do an hourly db copy of your sql-db then let timemachine do its thing



Sent from my iPhone using Tapatalk


I'm not using Sqlite, I use PostgreSQL.

Posted on
Mon Apr 25, 2016 2:37 pm
jay (support) offline
Site Admin
User avatar
Posts: 18200
Joined: Mar 19, 2008
Location: Austin, Texas

Re: SQL Logger Error after update to Indigo 6.1.8

We didn't change anything in the plugin (haven't for a long time). I don't know much about PostgreSQL, but is there some function to validate/repair databases? I'd recommend checking to make sure there's not something wrong with the db or db server.

Finally, you can attempt Karl's suggestion (without the details), which is to dump your database, then recreate the db - though I'd have no idea how to do it on PostgreSQL...

Jay (Indigo Support)
Twitter | Facebook | LinkedIn

Posted on
Mon Apr 25, 2016 8:47 pm
RogueProeliator offline
User avatar
Posts: 2501
Joined: Nov 13, 2012
Location: Baton Rouge, LA

Re: SQL Logger Error after update to Indigo 6.1.8

I really hope not, I can access the database with pgAdmin.

Try manually inserting a value into one of those tables via pgAdmin - perhaps will get a better error message if it is related to a server configuration (e.g. out of space or corrupt indices or something along those lines). I don't think there is enough to go on with that error in the Indigo Log.

Adam

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 3 guests