SQL Import hang.

Posted on
Wed Jan 24, 2018 4:46 pm
dking4 offline
Posts: 27
Joined: Jan 24, 2018

SQL Import hang.

I'm seeing the following errors in my log after enabling INDIGOplotD. I am still getting plots of variable values so I'm not really sure if the error is really affecting anything. I saw another thread on this topic from last July (http://forums.indigodomo.com/viewtopic.php?f=165&t=18618) but the fix was enabling SQL Logging which is already running appropriately on my system. I have tried reloading all plugins, reloading INDIGOplotD, reloading SQL Logging as well as disabling plugins, restarting Indigo and then reloading each one I use individually.

Any ideas or should I just ignore?

Thanks!

dk

Jan 24, 2018 at 11:19:37 AM
Reloading plugin "INDIGOplotD 4.16.28"
Stopping plugin "INDIGOplotD 4.16.28" (pid 2007)
INDIGOplotD main loop stopped
Stopped plugin "INDIGOplotD 4.16.28"
Starting plugin "INDIGOplotD 4.16.28" (pid 6833)
Started plugin "INDIGOplotD 4.16.28"
INDIGOplotD initializing ... 4-16-28; debuglevel=
INDIGOplotD indigo version found: 7
INDIGOplotD number of days per bin category are: [8, 38, 390] for [days, hours, minutes] data
INDIGOplotD using '/usr/bin/python2.7' for utily programs
INDIGOplotD SQLMode: ; GNUPLOT/MATPLOT: mat; GNUplotVersion= 5.2; PLOT-Directory= /Users/david/indigo/INDIGOplotD/
INDIGOplotD dataversion 2 dataOffsetInTimeDataNumbers:5
INDIGOplotD read file /Users/david/indigo/INDIGOplotD/data/minute.dat lines: 2304 ok
INDIGOplotD read file /Users/david/indigo/INDIGOplotD/data/hour.dat lines: 912 ok
INDIGOplotD read file /Users/david/indigo/INDIGOplotD/data/day.dat lines: 390 ok
INDIGOplotD checking py-restore files
INDIGOplotD initializing ...2
INDIGOplotD initialized

Jan 24, 2018 at 11:23:17 AM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 11:30:31 AM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 11:37:46 AM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 11:45:04 AM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 11:52:19 AM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 11:59:34 AM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 12:06:49 PM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 12:14:08 PM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 12:21:24 PM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 12:28:39 PM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 12:35:52 PM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 12:43:11 PM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 12:50:27 PM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 12:57:43 PM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 1:04:58 PM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 1:12:17 PM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 1:19:32 PM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Jan 24, 2018 at 1:26:50 PM
INDIGOplotD ------------------------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD ------------------------------------------------------------------------------

Posted on
Wed Jan 24, 2018 5:49 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: SQL Import hang.

could you do a "reload data from sql".
that will reset everything and load the whole sql data. In default mode it only loads 2 days. That should fix it .


[edit] just saw you did reload sql ..[edit]
could you switch on debug sql . restart plugin that will create a lot of output. and post or email me


Karl

Posted on
Mon Jan 29, 2018 6:52 pm
dking4 offline
Posts: 27
Joined: Jan 24, 2018

Re: SQL Import hang.

New log output. Thanks for your quick reply and sorry for my delayed one!

Jan 29, 2018 at 3:43:21 PM
Reloading plugin "INDIGOplotD 4.16.28"
Stopping plugin "INDIGOplotD 4.16.28" (pid 6833)
INDIGOplotD main loop stopped
Stopped plugin "INDIGOplotD 4.16.28"
Starting plugin "INDIGOplotD 4.16.28" (pid 14070)
Started plugin "INDIGOplotD 4.16.28"
INDIGOplotD initializing ... 4-16-28; debuglevel=General,Initialize,SQL,
INDIGOplotD indigo version found: 7
INDIGOplotD number of days per bin category are: [8, 38, 390] for [days, hours, minutes] data
INDIGOplotD sqlDynamic
INDIGOplotD using '/usr/bin/python2.7' for utily programs
INDIGOplotD clearing plot flags
INDIGOplotD SQLMode: ; GNUPLOT/MATPLOT: mat; GNUplotVersion= 5.2; PLOT-Directory= /Users/david/indigo/INDIGOplotD/
INDIGOplotD syncPlotsWithIndigo copying PLOT using Fuel_Oil_Usage id:1153076108
INDIGOplotD syncPlotsWithIndigo found new PLOT ... syncing 2 Fuel_Oil_Usage id1153076108 fname:Fuel_Oil_Usage
INDIGOplotD dataversion 2 dataOffsetInTimeDataNumbers:5
INDIGOplotD read file /Users/david/indigo/INDIGOplotD/data/minute.dat lines: 2304 ok
INDIGOplotD read file /Users/david/indigo/INDIGOplotD/data/hour.dat lines: 912 ok
INDIGOplotD read file /Users/david/indigo/INDIGOplotD/data/day.dat lines: 390 ok
INDIGOplotD redolineDataSource called from : startup
INDIGOplotD redolineDataSource: listOfSelectedDataColumnsAndDevPropName[(0, 'None'), (1, u'Var-TankVolumeGallons-average')] calledfrom :startup
INDIGOplotD redolineDataSource called from : startup
INDIGOplotD redolineDataSource: listOfSelectedDataColumnsAndDevPropName[(0, 'None'), (1, u'Var-TankVolumeGallons-average')] calledfrom :startup
INDIGOplotD redolineDataSource called from : cleanData
INDIGOplotD redolineDataSource: listOfSelectedDataColumnsAndDevPropName[(0, 'None'), (1, u'Var-TankVolumeGallons-average')] calledfrom :cleanData
INDIGOplotD checking py-restore files
INDIGOplotD initializing ...2
INDIGOplotD initialized
Reloading plugin "SQL Logger 2.0.7"
Stopping plugin "SQL Logger 2.0.7" (pid 2011)
SQL Logger closing SQL connection
Stopped plugin "SQL Logger 2.0.7"
Starting plugin "SQL Logger 2.0.7" (pid 14082)
Started plugin "SQL Logger 2.0.7"
SQL Logger connected to /Library/Application Support/Perceptive Automation/Indigo 7/Logs/indigo_history.sqlite
SQL Logger updating all device tables
SQL Logger Debug INSERT INTO device_history_959417598 ("batterylevel", "batterylevel_ui", "lastchangedvia", "onoffstate", "onoffstate_ui") VALUES (?, ?, ?, ?, ?);
SQL Logger Debug (u'95', u'95%', u'manually', u'True', u'locked')
SQL Logger Debug DELETE FROM device_history_959417598 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_629724571 ("alarmstate", "boltstate", "handlestate", "lastuser", "latchstate", "lockstate") VALUES (?, ?, ?, ?, ?, ?);
SQL Logger Debug (u'', u'', u'Open', u'', u'', u'Locked')
SQL Logger Debug DELETE FROM device_history_629724571 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1062376105 ("analoginput1", "analoginput2", "analoginputsall", "binaryinput1", "binaryinput2", "binaryinput3", "binaryinput4", "binaryinput5", "binaryinput6", "binaryinput7", "binaryinputsall", "binaryoutput1", "binaryoutput2", "binaryoutput3", "binaryoutput4", "binaryoutput5", "binaryoutput6", "binaryoutput7", "binaryoutput8", "binaryoutputsall", "sensorinput1", "sensorinputsall") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
SQL Logger Debug (u'60', u'0', u'60, 0', u'False', u'False', u'False', u'False', u'False', u'False', u'False', u'0, 0, 0, 0, 0, 0, 0', u'False', u'False', u'False', u'False', u'False', u'False', u'False', u'False', u'', u'0', u'0')
SQL Logger Debug DELETE FROM device_history_1062376105 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_230067192 ("batterylevel", "batterylevel_ui", "lastchangedvia", "onoffstate", "onoffstate_ui") VALUES (?, ?, ?, ?, ?);
SQL Logger Debug (u'96', u'96%', u'manually', u'True', u'locked')
SQL Logger Debug DELETE FROM device_history_230067192 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1026941194 ("alarmstate", "boltstate", "handlestate", "lastuser", "latchstate", "lockstate") VALUES (?, ?, ?, ?, ?, ?);
SQL Logger Debug (u'', u'', u'Open', u'', u'', u'Locked')
SQL Logger Debug DELETE FROM device_history_1026941194 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1004066117 ("communicationerror", "onoffstate") VALUES (?, ?);
SQL Logger Debug (u'False', u'False')
SQL Logger Debug DELETE FROM device_history_1004066117 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1816956265 ("communicationerror", "onoffstate") VALUES (?, ?);
SQL Logger Debug (u'False', u'False')
SQL Logger Debug DELETE FROM device_history_1816956265 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1354092736 ("communicationerror", "onoffstate") VALUES (?, ?);
SQL Logger Debug (u'False', u'False')
SQL Logger Debug DELETE FROM device_history_1354092736 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_988466127 ("communicationerror", "onoffstate") VALUES (?, ?);
SQL Logger Debug (u'False', u'False')
SQL Logger Debug DELETE FROM device_history_988466127 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_69762379 ("communicationerror", "onoffstate") VALUES (?, ?);
SQL Logger Debug (u'False', u'False')
SQL Logger Debug DELETE FROM device_history_69762379 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1780710906 ("batterylevel", "batterylevel_ui", "lastchangedvia", "onoffstate", "onoffstate_ui") VALUES (?, ?, ?, ?, ?);
SQL Logger Debug (u'95', u'95%', u'manually', u'True', u'locked')
SQL Logger Debug DELETE FROM device_history_1780710906 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1036290413 ("alarmstate", "boltstate", "handlestate", "lastuser", "latchstate", "lockstate") VALUES (?, ?, ?, ?, ?, ?);
SQL Logger Debug (u'', u'', u'', u'', u'', u'Locked')
SQL Logger Debug DELETE FROM device_history_1036290413 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_574574986 ("communicationerror", "onoffstate") VALUES (?, ?);
SQL Logger Debug (u'False', u'True')
SQL Logger Debug DELETE FROM device_history_574574986 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_153312992 ("communicationerror", "onoffstate") VALUES (?, ?);
SQL Logger Debug (u'False', u'True')
SQL Logger Debug DELETE FROM device_history_153312992 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_591421692 ("communicationerror", "onoffstate") VALUES (?, ?);
SQL Logger Debug (u'False', u'False')
SQL Logger Debug DELETE FROM device_history_591421692 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_22882957 ("communicationerror", "onoffstate") VALUES (?, ?);
SQL Logger Debug (u'False', u'False')
SQL Logger Debug DELETE FROM device_history_22882957 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1033254207 ("communicationerror", "onoffstate") VALUES (?, ?);
SQL Logger Debug (u'False', u'False')
SQL Logger Debug DELETE FROM device_history_1033254207 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1682998466 ("communicationerror", "onoffstate") VALUES (?, ?);
SQL Logger Debug (u'False', u'False')
SQL Logger Debug DELETE FROM device_history_1682998466 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_654096562 ("batterylevel", "batterylevel_ui", "lastchangedvia", "onoffstate", "onoffstate_ui") VALUES (?, ?, ?, ?, ?);
SQL Logger Debug (u'96', u'96%', u'unknown', u'True', u'locked')
SQL Logger Debug DELETE FROM device_history_654096562 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1037654267 ("alarmstate", "boltstate", "handlestate", "lastuser", "latchstate", "lockstate") VALUES (?, ?, ?, ?, ?, ?);
SQL Logger Debug (u'', u'', u'Open', u'', u'', u'Locked')
SQL Logger Debug DELETE FROM device_history_1037654267 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1344148446 ("actions", "motion", "recording", "sensitivity", "state", "state_active", "state_disconnected", "state_passive", "state_preparing", "state_unavailable", "type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
SQL Logger Debug (u'False', u'True', u'True', u'50', u'active', u'True', u'False', u'False', u'False', u'False', u'Network Axis')
SQL Logger Debug DELETE FROM device_history_1344148446 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_69506150 ("actions", "motion", "recording", "sensitivity", "state", "state_active", "state_disconnected", "state_passive", "state_preparing", "state_unavailable", "type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
SQL Logger Debug (u'False', u'True', u'True', u'50', u'active', u'True', u'False', u'False', u'False', u'False', u'Network ONVIF')
SQL Logger Debug DELETE FROM device_history_69506150 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1668703309 ("brightnesslevel", "currentpreset", "nextpreset", "nextpresettime", "onoffstate", "overrideactive", "overrideresumepatrol", "overrideuntil", "paused", "statedisplay") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
SQL Logger Debug (u'0', u'0', u'0', u'2018-01-10 15:05:24', u'False', u'False', u'0', u'', u'False', u'')
SQL Logger Debug DELETE FROM device_history_1668703309 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1506370896 ("batterylevel", "batterylevel_ui", "lastchangedvia", "onoffstate", "onoffstate_ui") VALUES (?, ?, ?, ?, ?);
SQL Logger Debug (u'96', u'96%', u'manually', u'True', u'locked')
SQL Logger Debug DELETE FROM device_history_1506370896 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_899811135 ("alarmstate", "boltstate", "handlestate", "lastuser", "latchstate", "lockstate") VALUES (?, ?, ?, ?, ?, ?);
SQL Logger Debug (u'', u'', u'', u'', u'', u'Locked')
SQL Logger Debug DELETE FROM device_history_899811135 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1249779077 ("state", "state_preparing", "state_ready", "state_unavailable", "version") VALUES (?, ?, ?, ?, ?);
SQL Logger Debug (u'ready', u'False', u'True', u'False', u'4.2.3')
SQL Logger Debug DELETE FROM device_history_1249779077 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1410267591 ("badnodeslist", "connectionstatus", "connectionstatus_connected", "connectionstatus_disconnected") VALUES (?, ?, ?, ?);
SQL Logger Debug (u'[]', u'connected', u'True', u'False')
SQL Logger Debug DELETE FROM device_history_1410267591 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_379688913 ("batterylevel", "batterylevel_ui", "lastchangedvia", "onoffstate", "onoffstate_ui") VALUES (?, ?, ?, ?, ?);
SQL Logger Debug (u'96', u'96%', u'manually', u'True', u'locked')
SQL Logger Debug DELETE FROM device_history_379688913 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_125582952 ("alarmstate", "boltstate", "handlestate", "lastuser", "latchstate", "lockstate") VALUES (?, ?, ?, ?, ?, ?);
SQL Logger Debug (u'', u'', u'Open', u'', u'', u'Locked')
SQL Logger Debug DELETE FROM device_history_125582952 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1245294200 ("brightnesslevel", "communicationerror", "onoffstate") VALUES (?, ?, ?);
SQL Logger Debug (u'0', u'False', u'False')
SQL Logger Debug DELETE FROM device_history_1245294200 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1684561783 ("brightnesslevel", "communicationerror", "onoffstate") VALUES (?, ?, ?);
SQL Logger Debug (u'0', u'False', u'False')
SQL Logger Debug DELETE FROM device_history_1684561783 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_154505915 ("analoginput1", "analoginput2", "analoginputsall", "binaryinput1", "binaryinput2", "binaryinput3", "binaryinput4", "binaryinputsall", "binaryoutput1", "binaryoutput2", "binaryoutputsall") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
SQL Logger Debug (u'378', u'0', u'378, 0', u'False', u'False', u'False', u'False', u'0, 0, 0, 0', u'False', u'False', u'0, 0')
SQL Logger Debug DELETE FROM device_history_154505915 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_393764774 ("communicationerror", "onoffstate") VALUES (?, ?);
SQL Logger Debug (u'False', u'False')
SQL Logger Debug DELETE FROM device_history_393764774 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_71030868 ("brightnesslevel", "communicationerror", "onoffstate") VALUES (?, ?, ?);
SQL Logger Debug (u'0', u'False', u'False')
SQL Logger Debug DELETE FROM device_history_71030868 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1950074334 ("brightnesslevel", "communicationerror", "onoffstate") VALUES (?, ?, ?);
SQL Logger Debug (u'0', u'False', u'False')
SQL Logger Debug DELETE FROM device_history_1950074334 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1757430157 ("brightnesslevel", "communicationerror", "onoffstate") VALUES (?, ?, ?);
SQL Logger Debug (u'0', u'False', u'False')
SQL Logger Debug DELETE FROM device_history_1757430157 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger Debug INSERT INTO device_history_1169305596 ("brightnesslevel", "communicationerror", "onoffstate") VALUES (?, ?, ?);
SQL Logger Debug (u'0', u'False', u'False')
SQL Logger Debug DELETE FROM device_history_1169305596 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-12-30',)
SQL Logger updating all variable tables
SQL Logger Debug INSERT INTO variable_history_1578813833 (value) VALUES (?);
SQL Logger Debug (u'',)
SQL Logger Debug DELETE FROM variable_history_1578813833 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger Debug INSERT INTO variable_history_1668999576 (value) VALUES (?);
SQL Logger Debug (u'',)
SQL Logger Debug DELETE FROM variable_history_1668999576 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger Debug INSERT INTO variable_history_250430200 (value) VALUES (?);
SQL Logger Debug (u'',)
SQL Logger Debug DELETE FROM variable_history_250430200 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger Debug INSERT INTO variable_history_1621386650 (value) VALUES (?);
SQL Logger Debug (u'',)
SQL Logger Debug DELETE FROM variable_history_1621386650 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger Debug INSERT INTO variable_history_1918206615 (value) VALUES (?);
SQL Logger Debug (u'',)
SQL Logger Debug DELETE FROM variable_history_1918206615 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger Debug INSERT INTO variable_history_110650228 (value) VALUES (?);
SQL Logger Debug (u'',)
SQL Logger Debug DELETE FROM variable_history_110650228 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger Debug INSERT INTO variable_history_834469463 (value) VALUES (?);
SQL Logger Debug (u'',)
SQL Logger Debug DELETE FROM variable_history_834469463 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger Debug INSERT INTO variable_history_1670918578 (value) VALUES (?);
SQL Logger Debug (u'',)
SQL Logger Debug DELETE FROM variable_history_1670918578 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger Debug INSERT INTO variable_history_47880783 (value) VALUES (?);
SQL Logger Debug (u'',)
SQL Logger Debug DELETE FROM variable_history_47880783 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger Debug INSERT INTO variable_history_601890439 (value) VALUES (?);
SQL Logger Debug (u'',)
SQL Logger Debug DELETE FROM variable_history_601890439 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger Debug INSERT INTO variable_history_1315877179 (value) VALUES (?);
SQL Logger Debug (u'ok',)
SQL Logger Debug DELETE FROM variable_history_1315877179 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger Debug INSERT INTO variable_history_1413032636 (value) VALUES (?);
SQL Logger Debug (u'true',)
SQL Logger Debug DELETE FROM variable_history_1413032636 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger Debug INSERT INTO variable_history_34307312 (value) VALUES (?);
SQL Logger Debug (u'01/10/18',)
SQL Logger Debug DELETE FROM variable_history_34307312 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger Debug INSERT INTO variable_history_28242827 (value) VALUES (?);
SQL Logger Debug (u'278',)
SQL Logger Debug DELETE FROM variable_history_28242827 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger Debug INSERT INTO variable_history_1119762193 (value) VALUES (?);
SQL Logger Debug (u'16',)
SQL Logger Debug DELETE FROM variable_history_1119762193 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger Debug INSERT INTO variable_history_1310964071 (value) VALUES (?);
SQL Logger Debug (u'377',)
SQL Logger Debug DELETE FROM variable_history_1310964071 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger Debug INSERT INTO variable_history_692112189 (value) VALUES (?);
SQL Logger Debug (u'121',)
SQL Logger Debug DELETE FROM variable_history_692112189 WHERE datetime(ts,'localtime') < ?;
SQL Logger Debug ('2017-01-29',)
SQL Logger update complete
INDIGOplotD action:finish; init:file; TTI: 2; TBI: 389
sqlColListStatus:[0, 10]
INDIGOplotD action:finish; init:file; TTI: 1; TBI: 903
sqlColListStatus:[0, 10]
INDIGOplotD action:finish; init:file; TTI: 0; TBI: 2204
sqlColListStatus:[0, 10]

Jan 29, 2018 at 3:44:58 PM
INDIGOplotD action:finish; init:file; TTI: 2; TBI: 389
sqlColListStatus:[0, 10]
INDIGOplotD action:finish; init:file; TTI: 1; TBI: 903
sqlColListStatus:[0, 10]
INDIGOplotD action:finish; init:file; TTI: 0; TBI: 2204
sqlColListStatus:[0, 10]

Jan 29, 2018 at 3:45:58 PM
INDIGOplotD action:init; init:file; TTI: 0; TBI: 2205
sqlColListStatus:[0, 10]
INDIGOplotD action:finish; init:file; TTI: 2; TBI: 389
sqlColListStatus:[0, 10]
INDIGOplotD action:finish; init:file; TTI: 1; TBI: 903
sqlColListStatus:[0, 10]
INDIGOplotD action:finish; init:file; TTI: 0; TBI: 2205
sqlColListStatus:[0, 10]

Posted on
Mon Jan 29, 2018 11:43 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: SQL Import hang.

with debug I did not mean switch on indigo sql debug, but indigoplotd sql import debug in
menu/ indigoplotd / config /...(3) SQL import

Posted on
Tue Jul 03, 2018 2:15 pm
hamw offline
Posts: 1212
Joined: Mar 31, 2008

Re: SQL Import hang.

I have the same problem... get the error with loading but the graphs appear to be working fine. I turned on debugging and set it to SQL import:

Code: Select all
INDIGOplotD                      initgnu  syncPlotsWithIndigo
   INDIGOplotD                      action:init;  init:file; TTI: 0; TBI:  2210 
 sqlColListStatus:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 10, 10, 0, 10, 10, 0, 0, 10, 10, 10, 0, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 10, 10, 10]
   INDIGOplotD                     getIndigoData  Thermostat Fam Room/hvacCoolerIsOn  out of min/max range: 30.0< 0.0< 95.0
   INDIGOplotD                     getIndigoData  Thermostat Fam Room/hvacHeaterIsOn  out of min/max range: 30.0< 0.0< 95.0
   INDIGOplotD                     getIndigoData  Pool/SPATMP  out of min/max range: 30.0< 0.0< 120.0
   INDIGOplotD                      action:finish;  init:file; TTI: 2; TBI:  389 
 sqlColListStatus:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 10, 10, 0, 10, 10, 0, 0, 10, 10, 10, 0, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 10, 10, 10]
   INDIGOplotD                      action:finish;  init:file; TTI: 1; TBI:  904 
 sqlColListStatus:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 10, 10, 0, 10, 10, 0, 0, 10, 10, 10, 0, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 10, 10, 10]
   INDIGOplotD                      action:finish;  init:file; TTI: 0; TBI:  2210 
 sqlColListStatus:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 10, 10, 0, 10, 10, 0, 0, 10, 10, 10, 0, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 10, 10, 10]
   INDIGOplotD                     Plot_Pool_Temp  min-max calcs........................
   INDIGOplotD                     Plot_Pool_Temp  min-max calcs........................
   INDIGOplotD                     Plot_Pool_Temp  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Attic  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Attic  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Attic  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Fam_Rm_Crawl_Space  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Fam_Rm_Crawl_Space  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Fam_Rm_Crawl_Space  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Pantry_Wine  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Pantry_Wine  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Pantry_Wine  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Apt  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Apt  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Apt  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Pool_House  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Pool_House  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Pool_House  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Main_House_Crawl_Space  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Main_House_Crawl_Space  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Main_House_Crawl_Space  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Game_Rm_Crawl_Space  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Game_Rm_Crawl_Space  min-max calcs........................
   INDIGOplotD                     Plot_Temp_Hum_Game_Rm_Crawl_Space  min-max calcs........................


Any thoughts? I see the "out of range" for the pool and AC up top.... I am trying to graph when the pool heat turns on and off, and when the AC turns on and off. Maybe that's the error. What are the correct selections to plot an on-then-off event?

BTW fantastic plugin!

Posted on
Tue Jul 03, 2018 2:58 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

SQL Import hang.

Looks like the min; max range is set to 30;95

Set in menu data select to -1; 1000 for that device/ state

[EDIT] it is called: ignore if less the / greater than.
on/off has 0 or 1 as values


Sent from my iPhone using Tapatalk

Posted on
Sat Jul 28, 2018 6:31 am
hamw offline
Posts: 1212
Joined: Mar 31, 2008

Re: SQL Import hang.

I think this is mostly straightened out but I'm still getting a SQL reload error. Any ideas?

Code: Select all
Jul 28, 2018, 8:23:22 AM
   INDIGOplotD                     command: debug ON
   INDIGOplotD                     command: ReloadSQL
   INDIGOplotD                     pending indigoCommands: ['ReloadSQL']
   INDIGOplotD                      clearSqlData sqlupdates: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 10, 10, 0, 10, 10, 0, 0, 10, 10, 10, 10, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 10, 10, 10]
   INDIGOplotD                     command: reLoad SQL started

Jul 28, 2018, 8:23:59 AM
   INDIGOplotD                      initgnu  syncPlotsWithIndigo
   INDIGOplotD                      action:finish;  init:file; TTI: 2; TBI:  389 
 sqlColListStatus:[0, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49]
   INDIGOplotD                      action:finish;  init:file; TTI: 1; TBI:  896 
 sqlColListStatus:[0, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49]
   INDIGOplotD                      action:finish;  init:file; TTI: 0; TBI:  2116 
 sqlColListStatus:[0, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49]
   Received INSTEON                "Thermostat MBR" temperature changed to 70.0

Jul 28, 2018, 8:24:42 AM
   INDIGOplotD                     --------------------------------------------------------------
   INDIGOplotD                     restarting SQL import,    it seems to hang. If this happens several times reload INDIGOplotD :
   INDIGOplotD                     --------------------------------------------------------------
   INDIGOplotD                     sql-logger not enabled  disabling calls to SQL-Logger

Jul 28, 2018, 8:24:59 AM
   INDIGOplotD                      initgnu  syncPlotsWithIndigo
   INDIGOplotD                      action:finish;  init:file; TTI: 2; TBI:  389 
 sqlColListStatus:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]
   INDIGOplotD                      action:finish;  init:file; TTI: 1; TBI:  896 
 sqlColListStatus:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]
   INDIGOplotD                      action:finish;  init:file; TTI: 0; TBI:  2116 
 sqlColListStatus:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]
   Received INSTEON                "Thermostat MBR" temperature changed to 71.0
   Reloading plugin "INDIGOplotD 4.16.21"
   Stopping plugin "INDIGOplotD 4.16.21" (pid 2403)
   INDIGOplotD                      stop matplot: not active, PID:  x
   INDIGOplotD                      main loop stopped
   Stopped plugin "INDIGOplotD 4.16.21"
   Starting plugin "INDIGOplotD 4.16.21" (pid 28973)
   Started plugin "INDIGOplotD 4.16.21"
   INDIGOplotD                     initializing  ... 4-16-21;  debuglevel=SQL,
   INDIGOplotD                     indigo version found: 7
   INDIGOplotD                      number of days per bin category are: [8, 38, 390] for [days, hours, minutes] data
   INDIGOplotD                     sqlDynamic
   INDIGOplotD                     using '/usr/bin/python2.7' for utily programs
   INDIGOplotD                     SQLMode: ;  GNUPLOT/MATPLOT: gnu;  GNUplotVersion= 5.0;  PLOT-Directory= /Users/hamiltonwilliams/Documents/INDIGOplotD/
   INDIGOplotD                     dataversion 2  dataOffsetInTimeDataNumbers:5
   INDIGOplotD                      read file /Users/hamiltonwilliams/Documents/INDIGOplotD/data/minute.dat lines: 2304  ok
   INDIGOplotD                      read file /Users/hamiltonwilliams/Documents/INDIGOplotD/data/hour.dat lines: 912  ok
   INDIGOplotD                      read file /Users/hamiltonwilliams/Documents/INDIGOplotD/data/day.dat lines: 390  ok
   INDIGOplotD                     checking py-restore files
   INDIGOplotD                     initializing  ...2
   INDIGOplotD                     initialized


Because of this.....
Jul 28, 2018, 8:24:42 AM
INDIGOplotD --------------------------------------------------------------
INDIGOplotD restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD --------------------------------------------------------------
INDIGOplotD sql-logger not enabled disabling calls to SQL-Logger


I re-enabled SQLLogger, and am getting this....

Jul 28, 2018, 8:27:55 AM
Enabling plugin "SQL Logger 2.0.7"
Starting plugin "SQL Logger 2.0.7" (pid 29022)
Started plugin "SQL Logger 2.0.7"
SQL Logger Error PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
SQL Logger Error reconnect attempt scheduled in 5 seconds
SQL Logger Error PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
SQL Logger Error reconnect attempt scheduled in 5 seconds
INDIGOplotD started sql job for EVENT data: COL,devID,State: 24/543073059/POOLHT;10/1722006044/onOffState;13/1215045977/hvacHeaterIsOn;12/1215045977/hvacCoolerIsOn;20/543073059/POOLHT;21/543073059/SPAHT;22/543073059/SPAHT;23/543073059/PUMP;19/543073059/POOLHT;16/1215045977/hvacHeaterIsOn;37/872181985/hvacHeaterIsOn;36/872181985/hvacCoolerIsOn;35/872181985/hvacCoolerIsOn;38/872181985/hvacHeaterIsOn;15/1215045977/hvacCoolerIsOn;
SQL Logger Error PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
SQL Logger Error reconnect attempt scheduled in 5 seconds
SQL Logger Error PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
SQL Logger Error reconnect attempt scheduled in 5 seconds
SQL Logger Error PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
SQL Logger Error reconnect attempt scheduled in 5 seconds
SQL Logger Error PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
SQL Logger Error reconnect attempt scheduled in 5 seconds


and then a whole lot of this....

Code: Select all
Jul 28, 2018, 8:23:22 AM
   INDIGOplotD                     command: debug ON
   INDIGOplotD                     command: ReloadSQL
   INDIGOplotD                     pending indigoCommands: ['ReloadSQL']
   INDIGOplotD                      clearSqlData sqlupdates: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 10, 10, 0, 10, 10, 0, 0, 10, 10, 10, 10, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 10, 10, 10]
   INDIGOplotD                     command: reLoad SQL started

Jul 28, 2018, 8:23:59 AM
   INDIGOplotD                      initgnu  syncPlotsWithIndigo
   INDIGOplotD                      action:finish;  init:file; TTI: 2; TBI:  389 
 sqlColListStatus:[0, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49]
   INDIGOplotD                      action:finish;  init:file; TTI: 1; TBI:  896 
 sqlColListStatus:[0, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49]
   INDIGOplotD                      action:finish;  init:file; TTI: 0; TBI:  2116 
 sqlColListStatus:[0, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49, 49]
   Received INSTEON                "Thermostat MBR" temperature changed to 70.0

Jul 28, 2018, 8:24:42 AM
   INDIGOplotD                     --------------------------------------------------------------
   INDIGOplotD                     restarting SQL import,    it seems to hang. If this happens several times reload INDIGOplotD :
   INDIGOplotD                     --------------------------------------------------------------
   INDIGOplotD                     sql-logger not enabled  disabling calls to SQL-Logger

Jul 28, 2018, 8:24:59 AM
   INDIGOplotD                      initgnu  syncPlotsWithIndigo
   INDIGOplotD                      action:finish;  init:file; TTI: 2; TBI:  389 
 sqlColListStatus:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]
   INDIGOplotD                      action:finish;  init:file; TTI: 1; TBI:  896 
 sqlColListStatus:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]
   INDIGOplotD                      action:finish;  init:file; TTI: 0; TBI:  2116 
 sqlColListStatus:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]
   Received INSTEON                "Thermostat MBR" temperature changed to 71.0
   Reloading plugin "INDIGOplotD 4.16.21"
   Stopping plugin "INDIGOplotD 4.16.21" (pid 2403)
   INDIGOplotD                      stop matplot: not active, PID:  x
   INDIGOplotD                      main loop stopped
   Stopped plugin "INDIGOplotD 4.16.21"
   Starting plugin "INDIGOplotD 4.16.21" (pid 28973)
   Started plugin "INDIGOplotD 4.16.21"
   INDIGOplotD                     initializing  ... 4-16-21;  debuglevel=SQL,
   INDIGOplotD                     indigo version found: 7
   INDIGOplotD                      number of days per bin category are: [8, 38, 390] for [days, hours, minutes] data
   INDIGOplotD                     sqlDynamic
   INDIGOplotD                     using '/usr/bin/python2.7' for utily programs
   INDIGOplotD                     SQLMode: ;  GNUPLOT/MATPLOT: gnu;  GNUplotVersion= 5.0;  PLOT-Directory= /Users/hamiltonwilliams/Documents/INDIGOplotD/
   INDIGOplotD                     dataversion 2  dataOffsetInTimeDataNumbers:5
   INDIGOplotD                      read file /Users/hamiltonwilliams/Documents/INDIGOplotD/data/minute.dat lines: 2304  ok
   INDIGOplotD                      read file /Users/hamiltonwilliams/Documents/INDIGOplotD/data/hour.dat lines: 912  ok
   INDIGOplotD                      read file /Users/hamiltonwilliams/Documents/INDIGOplotD/data/day.dat lines: 390  ok
   INDIGOplotD                     checking py-restore files
   INDIGOplotD                     initializing  ...2
   INDIGOplotD                     initialized

Jul 28, 2018, 8:27:16 AM
   Received INSTEON                "Thermostat MBR" temperature changed to 70.0
   Schedule                        _delayed_action_607

Jul 28, 2018, 8:27:55 AM
   Enabling plugin "SQL Logger 2.0.7"
   Starting plugin "SQL Logger 2.0.7" (pid 29022)
   Started plugin "SQL Logger 2.0.7"
   SQL Logger Error                PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
   SQL Logger Error                reconnect attempt scheduled in 5 seconds
   SQL Logger Error                PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
   SQL Logger Error                reconnect attempt scheduled in 5 seconds
   INDIGOplotD                     started sql job for EVENT data: COL,devID,State: 24/543073059/POOLHT;10/1722006044/onOffState;13/1215045977/hvacHeaterIsOn;12/1215045977/hvacCoolerIsOn;20/543073059/POOLHT;21/543073059/SPAHT;22/543073059/SPAHT;23/543073059/PUMP;19/543073059/POOLHT;16/1215045977/hvacHeaterIsOn;37/872181985/hvacHeaterIsOn;36/872181985/hvacCoolerIsOn;35/872181985/hvacCoolerIsOn;38/872181985/hvacHeaterIsOn;15/1215045977/hvacCoolerIsOn;
   SQL Logger Error                PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
   SQL Logger Error                reconnect attempt scheduled in 5 seconds
   SQL Logger Error                PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
   SQL Logger Error                reconnect attempt scheduled in 5 seconds
   SQL Logger Error                PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
   SQL Logger Error                reconnect attempt scheduled in 5 seconds
   SQL Logger Error                PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
   SQL Logger Error                reconnect attempt scheduled in 5 seconds
   Received INSTEON                "Thermostat MBR" temperature changed to 71.0
   SQL Logger Error                PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
   SQL Logger Error                reconnect attempt scheduled in 5 seconds
   SQL Logger Error                PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
   SQL Logger Error                reconnect attempt scheduled in 5 seconds
   SQL Logger Error                PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
   SQL Logger Error                reconnect attempt scheduled in 5 seconds
   SQL Logger Error                PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
   SQL Logger Error                reconnect attempt scheduled in 5 seconds
   SQL Logger Error                PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
   SQL Logger Error                reconnect attempt scheduled in 5 seconds
   SQL Logger Error                PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
   SQL Logger Error                reconnect attempt scheduled in 5 seconds
   SQL Logger Error                PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
   SQL Logger Error                reconnect attempt scheduled in 5 seconds
   INDIGOplotD                     --------------------------------------------------------------
   INDIGOplotD                     restarting SQL import,    it seems to hang. If this happens several times reload INDIGOplotD :
   INDIGOplotD                     --------------------------------------------------------------
   INDIGOplotD                     setupSQLDataBatch 2 updateslist:[0, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10]
   INDIGOplotD                     sql importfile file not created yet, resetting import parameters: /Users/hamiltonwilliams/Documents/INDIGOplotD/sql/761629564-humidity
   INDIGOplotD                     sqlID ==0, delete  col:1 sql/761629564-humidity
   INDIGOplotD                     /Applications/Postgres.app/Contents/Versions/9.6/bin/psql  indigo_history postgres  -t -A -F ';' -c " SELECT id,  to_char(ts,'YYYYmmddHH24MIss'),  humidity from device_history_761629564 WHERE  ID > 0 order by id  LIMIT 10000000;"  2>/Users/hamiltonwilliams/Documents/INDIGOplotD/sql/761629564-humidity.error | awk -F';' 'NF>2 && !/data unavailable/ {print}'  > /Users/hamiltonwilliams/Documents/INDIGOplotD/sql/761629564-humidity.sqlOut

/usr/bin/python2.7 '/Library/Application Support/Perceptive Automation/Indigo 7/Plugins/INDIGOplotD.indigoPlugin/Contents/Server Plugin/fixSQLoutput.py'  /Users/hamiltonwilliams/Documents/INDIGOplotD/sql/ 761629564-humidity.sqlout 761629564-humidity sqlFix 0


   INDIGOplotD                     sql command for col:1  name-state:TH CrawlSp 3 Game Rm Humidity-humidity             starting at record:       0 added; last existing record is:  no SQL file generated yet
   INDIGOplotD                     sql importfile file not created yet, resetting import parameters: /Users/hamiltonwilliams/Documents/INDIGOplotD/sql/1055284047-humidity
   INDIGOplotD                     sqlID ==0, delete  col:2 sql/1055284047-humidity
   INDIGOplotD                     /Applications/Postgres.app/Contents/Versions/9.6/bin/psql  indigo_history postgres  -t -A -F ';' -c " SELECT id,  to_char(ts,'YYYYmmddHH24MIss'),  humidity from device_history_1055284047 WHERE  ID > 0 order by id  LIMIT 10000000;"  2>/Users/hamiltonwilliams/Documents/INDIGOplotD/sql/1055284047-humidity.error | awk -F';' 'NF>2 && !/data unavailable/ {print}'  > /Users/hamiltonwilliams/Documents/INDIGOplotD/sql/1055284047-humidity.sqlOut

/usr/bin/python2.7 '/Library/Application Support/Perceptive Automation/Indigo 7/Plugins/INDIGOplotD.indigoPlugin/Contents/Server Plugin/fixSQLoutput.py'  /Users/hamiltonwilliams/Documents/INDIGOplotD/sql/ 1055284047-humidity.sqlout 1055284047-humidity sqlFix 0


   INDIGOplotD                     sql command for col:2  name-state:TH CrawlSp 1 Fam Rm Humidity-humidity              starting at record:       0 added; last existing record is:  no SQL file generated yet
   INDIGOplotD                     sql importfile file not created yet, resetting import parameters: /Users/hamiltonwilliams/Documents/INDIGOplotD/sql/1877267478-temperature
   INDIGOplotD                     sqlID ==0, delete  col:3 sql/1877267478-temperature
   INDIGOplotD                     /Applications/Postgres.app/Contents/Versions/9.6/bin/psql  indigo_history postgres  -t -A -F ';' -c " SELECT id,  to_char(ts,'YYYYmmddHH24MIss'),  temperature from device_history_1877267478 WHERE  ID > 0 order by id  LIMIT 10000000;"  2>/Users/hamiltonwilliams/Documents/INDIGOplotD/sql/1877267478-temperature.error | awk -F';' 'NF>2 && !/data unavailable/ {print}'  > /Users/hamiltonwilliams/Documents/INDIGOplotD/sql/1877267478-temperature.sqlOut

/usr/bin/python2.7 '/Library/Application Support/Perceptive Automation/Indigo 7/Plugins/INDIGOplotD.indigoPlugin/Contents/Server Plugin/fixSQLoutput.py'  /Users/hamiltonwilliams/Documents/INDIGOplotD/sql/ 1877267478-temperature.sqlout 1877267478-temperature sqlFix 0


   INDIGOplotD                     sql command for col:3  name-state:TH CrawlSp 3 Game Rm Temp-temperature              starting at record:       0 added; last existing record is:  no SQL file generated yet
   INDIGOplotD                     sql importfile file not created yet, resetting import parameters: /Users/hamiltonwilliams/Documents/INDIGOplotD/sql/503075230-humidity
   INDIGOplotD                     sqlID ==0, delete  col:4 sql/503075230-humidity
   INDIGOplotD                     /Applications/Postgres.app/Contents/Versions/9.6/bin/psql  indigo_history postgres  -t -A -F ';' -c " SELECT id,  to_char(ts,'YYYYmmddHH24MIss'),  humidity from device_history_503075230 WHERE  ID > 0 order by id  LIMIT 10000000;"  2>/Users/hamiltonwilliams/Documents/INDIGOplotD/sql/503075230-humidity.error | awk -F';' 'NF>2 && !/data unavailable/ {print}'  > /Users/hamiltonwilliams/Documents/INDIGOplotD/sql/503075230-humidity.sqlOut

/usr/bin/python2.7 '/Library/Application Support/Perceptive Automation/Indigo 7/Plugins/INDIGOplotD.indigoPlugin/Contents/Server Plugin/fixSQLoutput.py'  /Users/hamiltonwilliams/Documents/INDIGOplotD/sql/ 503075230-humidity.sqlout 503075230-humidity sqlFix 0


   INDIGOplotD                     sql command for col:4  name-state:TH CrawlSp 2 Main House Humidity-humidity          starting at record:       0 added; last existing record is:  no SQL file generated yet
   INDIGOplotD                     sql importfile file not created yet, resetting import parameters: /Users/hamiltonwilliams/Documents/INDIGOplotD/sql/794510541-currentDayTotal
   INDIGOplotD                     sqlID ==0, delete  col:5 sql/794510541-currentDayTotal
   INDIGOplotD                     /Applications/Postgres.app/Contents/Versions/9.6/bin/psql  indigo_history postgres  -t -A -F ';' -c " SELECT id,  to_char(ts,'YYYYmmddHH24MIss'),  currentDayTotal from device_history_794510541 WHERE  ID > 0 order by id  LIMIT 10000000;"  2>/Users/hamiltonwilliams/Documents/INDIGOplotD/sql/794510541-currentDayTotal.error | awk -F';' 'NF>2 && !/data unavailable/ {print}'  > /Users/hamiltonwilliams/Documents/INDIGOplotD/sql/794510541-currentDayTotal.sqlOut

/usr/bin/python2.7 '/Library/Application Support/Perceptive Automation/Indigo 7/Plugins/INDIGOplotD.indigoPlugin/Contents/Server Plugin/fixSQLoutput.py'  /Users/hamiltonwilliams/Documents/INDIGOplotD/sql/ 794510541-currentDayTotal.sqlout 794510541-currentDayTotal sqlFix 0




Has SQL somehow gone away?

Posted on
Sat Jul 28, 2018 7:04 am
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: SQL Import hang.

What is you sql string. It is set in config. Could you post?


Sent from my iPhone using Tapatalk

Posted on
Sun Aug 05, 2018 6:54 am
hamw offline
Posts: 1212
Joined: Mar 31, 2008

Re: SQL Import hang.

Sorry for the delay... out of town. I updated to Postgres 9.6, and this is the location.

************
"/Applications/Postgres.app/Contents/Versions/9.6/bin/psql" -p5432 -d "indigo_history"
Last login: Wed Jul 4 13:10:49 on ttys001
Mac-mini:~ hamiltonwilliams$ "/Applications/Postgres.app/Contents/Versions/9.6/bin/psql" -p5432 -d "indigo_history"
psql (9.6.9)
Type "help" for help.

indigo_history=#
**************


In the config menu in IndigoPlot, this the location: /Applications/Postgres.app/Contents/Versions/9.6/bin/psql indigo_history postgres


NOTE: Since updating PostGres and reimporting the database, while I have lost all my data the errors have stopped. Maybe it is working.

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 2 guests