[ANSWERED]SQL Logger Error

Posted on
Thu Feb 13, 2014 7:08 am
mlooss offline
Posts: 181
Joined: Sep 05, 2013

[ANSWERED]SQL Logger Error

Today my log is full with these messages? It looks like my DB became corrupted/damage, but how and and how can I fix it?

SQL Logger Error exception trying to insert row into table device_history_1568303338 ("SJU Wind Speed MPH")
SQL Logger Error database disk image is malformed

Posted on
Thu Feb 13, 2014 3:28 pm
jay (support) offline
Site Admin
User avatar
Posts: 14860
Joined: Mar 19, 2008
Location: Austin, Texas

Re: SQL Logger Error

To clear the error, just delete the database file (the path to the file is listed in the plugin's config dialog). If you want to try and save the data in the file you can just roll back to an earlier (uncorrupted) backup. If you don't have a backup, you can attempt to do the recovery yourself but it's a fairly technical procedure.

Note - if you don't actually want the data but you enabled the plugin for use with the Error in Event Log trigger, just uncheck all the checkboxes in the config dialog.

Jay (Indigo Support)
Twitter | Facebook | LinkedIn

Posted on
Fri Oct 03, 2014 10:01 am
waveuk offline
Posts: 22
Joined: Sep 24, 2014

Re: [ANSWERED]SQL Logger Error

I had this issue twice in 2 weeks. Is this something normal with this plugin? What could be the cause of this corruption?

Posted on
Fri Oct 03, 2014 5:31 pm
jay (support) offline
Site Admin
User avatar
Posts: 14860
Joined: Mar 19, 2008
Location: Austin, Texas

Re: [ANSWERED]SQL Logger Error

Crashes are usually the culprit - or a power outage.

In the worst case, you may be having issues with your hard drive - repairing it using Disk Utility is a good plan if it continues to happen.

Jay (Indigo Support)
Twitter | Facebook | LinkedIn

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 1 guest