sql logger error - database locked

Posted on
Mon Feb 22, 2016 9:42 am
Asconasny offline
Posts: 161
Joined: Jan 16, 2015

sql logger error - database locked

Hi

Im getting frequent SQL Logger Error database is locked error.
SQL Logger Error exception trying to insert row into table device_history_176485861 ("Hilde Iphone") -- unable to modify table
SQL Logger Error database is locked

Is it any chance to avoid this?

I also see some users is using postgreSQL instead of SQLite. Is there any advantage for using that?

regards
Asconasny

Posted on
Tue Feb 23, 2016 10:21 am
jay (support) offline
Site Admin
User avatar
Posts: 18199
Joined: Mar 19, 2008
Location: Austin, Texas

Re: sql logger error - database locked

Are you seeing it for every change or just that one device?

Jay (Indigo Support)
Twitter | Facebook | LinkedIn

Posted on
Tue Feb 23, 2016 3:12 pm
Asconasny offline
Posts: 161
Joined: Jan 16, 2015

Re: sql logger error - database locked

Hi

Not every change, different devices, different times.

indigo is installed on a mac mini 2.6 i7 with 8gb ram

2016-02-22 15:34:38.434 SQL Logger Error exception trying to insert row into table device_history_1983242777 ("AppleTvPlexstue") -- unable to modify table
2016-02-22 15:34:38.450 SQL Logger Error database is locked
2016-02-22 15:39:40.460 SQL Logger Error exception trying to insert row into table device_history_264711228 ("Ring Doorbell") -- unable to modify table
2016-02-22 15:39:40.523 SQL Logger Error database is locked
2016-02-22 15:40:00.268 SQL Logger Error exception trying to insert row into table variable_history_1375451334 ("ipDevice17")
2016-02-22 15:40:00.291 SQL Logger Error database is locked
2016-02-22 15:44:44.806 SQL Logger Error exception trying to insert row into table device_history_146332736 ("PirStueAlarm") -- unable to modify table
2016-02-22 15:44:44.874 SQL Logger Error database is locked

and so on..

2016-02-22 18:10:42.463 SQL Logger Error exception trying to insert row into table device_history_1983242777 ("AppleTvPlexstue") -- unable to modify table
2016-02-22 18:10:42.517 SQL Logger Error database is locked
2016-02-22 18:10:42.518 SQL Logger Error INSERT INTO device_history_1983242777 ("clientconnectionstatus", "clientconnectionstatus_connected", "clientconnectionstatus_disconnected", "clientconnectionstatus_paused", "clientconnectionstatus_playing", "currentuser", "currentlplayingtitleyear", "currentlyplayingarturl", "currentlyplayingcontentlengthms", "currentlyplayingcontentlengthoffset", "currentlyplayingcontentpercentcomplete", "currentlyplayingcontentrating", "currentlyplayingcontentresolution", "currentlyplayinggrandparentarturl", "currentlyplayinggrandparentthumbnailurl", "currentlyplayingmediatype", "currentlyplayingmediatype_album", "currentlyplayingmediatype_artist", "currentlyplayingmediatype_clip", "currentlyplayingmediatype_comic", "currentlyplayingmediatype_episode", "currentlyplayingmediatype_movie", "currentlyplayingmediatype_person", "currentlyplayingmediatype_photo", "currentlyplayingmediatype_photoalbum", "currentlyplayingmediatype_picture", "currentlyplayingmediatype_playlistitem", "currentlyplayingmediatype_season", "currentlyplayingmediatype_show", "currentlyplayingmediatype_track", "currentlyplayingmediatype_trailer", "currentlyplayingmediatype_unknown", "currentlyplayingparentthumbnailurl", "currentlyplayingstarrating", "currentlyplayingsummary", "currentlyplayingthumbnailurl", "currentlyplayingtitle", "playerdevicetitle") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);
2016-02-22 18:10:45.045 Z-Wave received "PirGangAlarm" status update is on
2016-02-22 18:10:47.469 SQL Logger Error exception trying to insert row into table device_history_1983242777 ("AppleTvPlexstue") -- unable to modify table
2016-02-22 18:10:47.470 SQL Logger Error database is locked
2016-02-22 18:10:47.471 SQL Logger Error INSERT INTO device_history_1983242777 ("clientconnectionstatus", "clientconnectionstatus_connected", "clientconnectionstatus_disconnected", "clientconnectionstatus_paused", "clientconnectionstatus_playing", "currentuser", "currentlplayingtitleyear", "currentlyplayingarturl", "currentlyplayingcontentlengthms", "currentlyplayingcontentlengthoffset", "currentlyplayingcontentpercentcomplete", "currentlyplayingcontentrating", "currentlyplayingcontentresolution", "currentlyplayinggrandparentarturl", "currentlyplayinggrandparentthumbnailurl", "currentlyplayingmediatype", "currentlyplayingmediatype_album", "currentlyplayingmediatype_artist", "currentlyplayingmediatype_clip", "currentlyplayingmediatype_comic", "currentlyplayingmediatype_episode", "currentlyplayingmediatype_movie", "currentlyplayingmediatype_person", "currentlyplayingmediatype_photo", "currentlyplayingmediatype_photoalbum", "currentlyplayingmediatype_picture", "currentlyplayingmediatype_playlistitem", "currentlyplayingmediatype_season", "currentlyplayingmediatype_show", "currentlyplayingmediatype_track", "currentlyplayingmediatype_trailer", "currentlyplayingmediatype_unknown", "currentlyplayingparentthumbnailurl", "currentlyplayingstarrating", "currentlyplayingsummary", "currentlyplayingthumbnailurl", "currentlyplayingtitle", "playerdevicetitle") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);
2016-02-22 18:10:47.611 Z-Wave received "PirStueAlarm" status update is on
2016-02-22 18:10:47.612 Trigger PirLastMovementStue
2016-02-22 18:10:52.566 SQL Logger Error exception trying to insert row into table device_history_146332736 ("PirStueAlarm") -- unable to modify table
2016-02-22 18:10:52.665 SQL Logger Error database is locked
2016-02-22 18:10:52.666 SQL Logger Error INSERT INTO device_history_146332736 ("onoffstate") VALUES (%s);
2016-02-22 18:10:57.508 SQL Logger Error exception trying to insert row into table variable_history_872497627 ("StuePir")
2016-02-22 18:10:57.510 SQL Logger Error database is locked
2016-02-22 18:10:57.510 SQL Logger Error INSERT INTO variable_history_872497627 (value) VALUES (%s);
2016-02-22 18:11:01.100 Z-Wave received "PirStueAlarm" status update is on
2016-02-22 18:11:01.345 INDIGOplotD in mkCopy DB pid=-1= flag= original
2016-02-22 18:11:02.459 SQL Logger Error exception trying to insert row into table device_history_1243742243 ("AlarmSoneStue") -- unable to modify table
2016-02-22 18:11:02.460 SQL Logger Error database is locked
2016-02-22 18:11:02.460 SQL Logger Error INSERT INTO device_history_1243742243 ("onoffstate") VALUES (%s);
2016-02-22 18:11:07.401 SQL Logger Error exception trying to insert row into table device_history_1983242777 ("AppleTvPlexstue") -- unable to modify table
2016-02-22 18:11:07.499 SQL Logger Error database is locked
2016-02-22 18:11:07.499 SQL Logger Error INSERT INTO device_history_1983242777 ("clientconnectionstatus", "clientconnectionstatus_connected", "clientconnectionstatus_disconnected", "clientconnectionstatus_paused", "clientconnectionstatus_playing", "currentuser", "currentlplayingtitleyear", "currentlyplayingarturl", "currentlyplayingcontentlengthms", "currentlyplayingcontentlengthoffset", "currentlyplayingcontentpercentcomplete", "currentlyplayingcontentrating", "currentlyplayingcontentresolution", "currentlyplayinggrandparentarturl", "currentlyplayinggrandparentthumbnailurl", "currentlyplayingmediatype", "currentlyplayingmediatype_album", "currentlyplayingmediatype_artist", "currentlyplayingmediatype_clip", "currentlyplayingmediatype_comic", "currentlyplayingmediatype_episode", "currentlyplayingmediatype_movie", "currentlyplayingmediatype_person", "currentlyplayingmediatype_photo", "currentlyplayingmediatype_photoalbum", "currentlyplayingmediatype_picture", "currentlyplayingmediatype_playlistitem", "currentlyplayingmediatype_season", "currentlyplayingmediatype_show", "currentlyplayingmediatype_track", "currentlyplayingmediatype_trailer", "currentlyplayingmediatype_unknown", "currentlyplayingparentthumbnailurl", "currentlyplayingstarrating", "currentlyplayingsummary", "currentlyplayingthumbnailurl", "currentlyplayingtitle", "playerdevicetitle") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);


regards
Asconasny

Posted on
Tue Feb 23, 2016 3:26 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: sql logger error - database locked

Do you have other sql things running? Have you restarted indigo server? If the db is corrupt you will see it then.


Sent from my iPhone using Tapatalk

Posted on
Tue Feb 23, 2016 4:42 pm
Asconasny offline
Posts: 161
Joined: Jan 16, 2015

Re: sql logger error - database locked

Just restarted the mac.
other sql things?

I dont get any message that its corrupted.
I get some errors, then it can run 5 min. or 3 hours no errors.

when i start up i get this error,

SQL Logger Error exception trying to insert row into table device_history_1577602183 ("22 - Clamp 3") -- unable to modify table
SQL Logger Error database is locked
SQL Logger Error INSERT INTO device_history_1577602183 ("accumenergytimedelta", "accumenergytimedelta_ui", "accumenergytotal", "accumenergytotal_ui", "curenergylevel", "curenergylevel_ui") VALUES (%s, %s, %s, %s, %s, %s);
SQL Logger Error exception trying to insert row into table device_history_1984559739 ("22 - Meter Total") -- unable to modify table
SQL Logger Error database is locked
SQL Logger Error INSERT INTO device_history_1984559739 ("accumenergytimedelta", "accumenergytimedelta_ui", "accumenergytotal", "accumenergytotal_ui", "curenergylevel", "curenergylevel_ui") VALUES (%s, %s, %s, %s, %s, %s);
SQL Logger Error exception trying to insert row into table device_history_1913809136 ("Airport Extreme") -- unable to modify table
SQL Logger Error database is locked
SQL Logger Error INSERT INTO device_history_1913809136 ("macnumber", "wifi", "wifisignal", "deviceinfo", "hardwarevendor", "ipnumber", "nickname", "noofchanges", "status", "statusdisplay", "suppresschangemsg", "timeoflastchange", "useping") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);
Z-Wave received "Yttergang Gulv varme" heat setpoint is 26.0 °C
SQL Logger Error exception trying to insert row into table device_history_384597169 ("Alarm") -- unable to modify table
SQL Logger Error database is locked
SQL Logger Error INSERT INTO device_history_384597169 ("longstatusstring", "timeleftdays", "timelefthours", "timeleftminutes", "timeleftseconds", "timerstartvalueseconds", "timerstatus", "timerstatus_active", "timerstatus_inactive", "timerstatus_paused") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s);
SQL Logger Error exception trying to insert row into table device_history_1728985545 ("AlarmSoneGang") -- unable to modify table
SQL Logger Error database is locked
SQL Logger Error INSERT INTO device_history_1728985545 ("onoffstate") VALUES (%s);
Z-Wave received "Vaskerom Gulv varme" temperature update to 26.1 °C
SQL Logger Error exception trying to insert row into table device_history_1883631186 ("AlarmSoneJohannesSoverom") -- unable to modify table
SQL Logger Error database is locked
SQL Logger Error INSERT INTO device_history_1883631186 ("onoffstate") VALUES (%s);
SQL Logger Error exception trying to insert row into table device_history_1243742243 ("AlarmSoneStue") -- unable to modify table
SQL Logger Error database is locked
SQL Logger Error INSERT INTO device_history_1243742243 ("onoffstate") VALUES (%s);
SQL Logger Error exception trying to insert row into table device_history_654243141 ("AlarmSoneVaskerom") -- unable to modify table
SQL Logger Error database is locked
SQL Logger Error INSERT INTO device_history_654243141 ("onoffstate") VALUES (%s);
SQL Logger Error exception trying to insert row into table device_history_1987827 ("Altibox Fiber") -- unable to modify table
SQL Logger Error database is locked
SQL Logger Error INSERT INTO device_history_1987827 ("accumenergytimedelta", "accumenergytimedelta_ui", "accumenergytotal", "accumenergytotal_ui", "curenergylevel", "curenergylevel_ui", "onoffstate") VALUES (%s, %s, %s, %s, %s, %s, %s);
SQL Logger Error exception trying to insert row into table device_history_1130471838 ("Altibox Sentral") -- unable to modify table
SQL Logger Error database is locked
SQL Logger Error INSERT INTO device_history_1130471838 ("accumenergytimedelta", "accumenergytimedelta_ui", "accumenergytotal", "accumenergytotal_ui", "curenergylevel", "curenergylevel_ui", "onoffstate") VALUES (%s, %s, %s, %s, %s, %s, %s);
SQL Logger Error exception trying to insert row into table device_history_608120196 ("Apple TV Stue") -- unable to modify table
SQL Logger Error database is locked
SQL Logger Error INSERT INTO device_history_608120196 ("macnumber", "wifi", "wifisignal", "deviceinfo", "hardwarevendor", "ipnumber", "nickname", "noofchanges", "status", "statusdisplay", "suppresschangemsg", "timeoflastchange", "useping") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);
SQL Logger Error exception trying to insert row into table device_history_1983242777 ("AppleTvPlexstue") -- unable to modify table
SQL Logger Error database is locked
SQL Logger Error INSERT INTO device_history_1983242777 ("clientconnectionstatus", "clientconnectionstatus_connected", "clientconnectionstatus_disconnected", "clientconnectionstatus_paused", "clientconnectionstatus_playing", "currentuser", "currentlplayingtitleyear", "currentlyplayingarturl", "currentlyplayingcontentlengthms", "currentlyplayingcontentlengthoffset", "currentlyplayingcontentpercentcomplete", "currentlyplayingcontentrating", "currentlyplayingcontentresolution", "currentlyplayinggrandparentarturl", "currentlyplayinggrandparentthumbnailurl", "currentlyplayingmediatype", "currentlyplayingmediatype_album", "currentlyplayingmediatype_artist", "currentlyplayingmediatype_clip", "currentlyplayingmediatype_comic", "currentlyplayingmediatype_episode", "currentlyplayingmediatype_movie", "currentlyplayingmediatype_person", "currentlyplayingmediatype_photo", "currentlyplayingmediatype_photoalbum", "currentlyplayingmediatype_picture", "currentlyplayingmediatype_playlistitem", "currentlyplayingmediatype_season", "currentlyplayingmediatype_show", "currentlyplayingmediatype_track", "currentlyplayingmediatype_trailer", "currentlyplayingmediatype_unknown", "currentlyplayingparentthumbnailurl", "currentlyplayingstarrating", "currentlyplayingsummary", "currentlyplayingthumbnailurl", "currentlyplayingtitle", "playerdevicetitle") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);
SQL Logger Error exception trying to insert row into table device_history_1702065589 ("Barometer Trend") -- unable to modify table
SQL Logger Error database is locked
SQL Logger Error INSERT INTO device_history_1702065589 ("agent", "agent_ui", "barometrictrend", "barometrictrend_ui", "dayrain_cm", "dayrain_cm_ui", "dayrain_in", "dayrain_in_ui", "dayrain_km", "dayrain_km_ui", "dayrain_mi", "dayrain_mi_ui", "dayrain_mm", "dayrain_mm_ui", "dewpoint_c", "dewpoint_c_ui", "dewpoint_f", "dewpoint_f_ui", "elevation", "elevation_ui", "heatindex_c", "heatindex_c_ui", "heatindex_f", "heatindex_f_ui", "humidity", "humidity_ui", "latitude", "latitude_ui", "location", "location_ui", "longitude", "longitude_ui", "name", "name_ui", "rainonehour_cm", "rainonehour_cm_ui", "rainonehour_in", "rainonehour_in_ui", "rainonehour_km", "rainonehour_km_ui", "rainonehour_mi", "rainonehour_mi_ui", "rainonehour_mm", "rainonehour_mm_ui", "relativebarometricpressure_cb", "relativebarometricpressure_cb_ui", "relativebarometricpressure_inhg", "relativebarometricpressure_inhg_ui", "relativebarometricpressure_mb", "relativebarometricpressure_mb_ui", "solarradiation", "solarradiation_ui", "temperature_c", "temperature_c_ui", "temperature_f", "temperature_f_ui", "uri", "uri_ui", "uvindex", "uvindex_ui", "version", "version_ui", "visibility_cm", "visibility_cm_ui", "visibility_in", "visibility_in_ui", "visibility_km", "visibility_km_ui", "visibility_mi", "visibility_mi_ui", "visibility_mm", "visibility_mm_ui", "weather", "weather_ui", "windchill_c", "windchill_c_ui", "windchill_f", "windchill_f_ui", "winddirection", "winddirection_ui", "windgust_kn", "windgust_kn_ui", "windgust_kph", "windgust_kph_ui", "windgust_mph", "windgust_mph_ui", "windgust_mps", "windgust_mps_ui", "windspeed_kn", "windspeed_kn_ui", "windspeed_kph", "windspeed_kph_ui", "windspeed_mph", "windspeed_mph_ui", "windspeed_mps", "windspeed_mps_ui") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);
SQL Logger Error exception trying to insert row into table device_history_258060673 ("Barometer trykk") -- unable to modify table
SQL Logger Error database is locked
SQL Logger Error INSERT INTO device_history_258060673 ("agent", "agent_ui", "barometrictrend", "barometrictrend_ui", "dayrain_cm", "dayrain_cm_ui", "dayrain_in", "dayrain_in_ui", "dayrain_km", "dayrain_km_ui", "dayrain_mi", "dayrain_mi_ui", "dayrain_mm", "dayrain_mm_ui", "dewpoint_c", "dewpoint_c_ui", "dewpoint_f", "dewpoint_f_ui", "elevation", "elevation_ui", "heatindex_c", "heatindex_c_ui", "heatindex_f", "heatindex_f_ui", "humidity", "humidity_ui", "latitude", "latitude_ui", "location", "location_ui", "longitude", "longitude_ui", "name", "name_ui", "rainonehour_cm", "rainonehour_cm_ui", "rainonehour_in", "rainonehour_in_ui", "rainonehour_km", "rainonehour_km_ui", "rainonehour_mi", "rainonehour_mi_ui", "rainonehour_mm", "rainonehour_mm_ui", "relativebarometricpressure_cb", "relativebarometricpressure_cb_ui", "relativebarometricpressure_inhg", "relativebarometricpressure_inhg_ui", "relativebarometricpressure_mb", "relativebarometricpressure_mb_ui", "solarradiation", "solarradiation_ui", "temperature_c", "temperature_c_ui", "temperature_f", "temperature_f_ui", "uri", "uri_ui", "uvindex", "uvindex_ui", "version", "version_ui", "visibility_cm", "visibility_cm_ui", "visibility_in", "visibility_in_ui", "visibility_km", "visibility_km_ui", "visibility_mi", "visibility_mi_ui", "visibility_mm", "visibility_mm_ui", "weather", "weather_ui", "windchill_c", "windchill_c_ui", "windchill_f", "windchill_f_ui", "winddirection", "winddirection_ui", "windgust_kn", "windgust_kn_ui", "windgust_kph", "windgust_kph_ui", "windgust_mph", "windgust_mph_ui", "windgust_mps", "windgust_mps_ui", "windspeed_kn", "windspeed_kn_ui", "windspeed_kph", "windspeed_kph_ui", "windspeed_mph", "windspeed_mph_ui", "windspeed_mps", "windspeed_mps_ui") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s

Posted on
Wed Feb 24, 2016 12:44 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: sql logger error - database locked

this looks like a corrupt database.

you can try to use indigo utilities to fix it, but no guarantee.

run indigo utility menu: fix sql and follow log file.
it worked twice out of 3 times.

And may i suggest to use indigo utilities to make backups of your sqldb. Time Machine does not do consistent backups as it takes too long to copy while indigo is still using it (= no backup for many days in a row)
indigo utilities can be set to make a simple copy every xx hours (takes some seconds) and THEN Time Machine can copy THAT file to the Time Machine disk (takes > 10 minutes). That seems to work.


Karl

Posted on
Fri Feb 26, 2016 8:11 am
Asconasny offline
Posts: 161
Joined: Jan 16, 2015

Re: sql logger error - database locked

haven't seen any errors like this since i started this post.. strange.
I had these errors for about a week before i posted

my guess its working and happy with that :)

asconasny

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 2 guests