- Posted on
Mon Jun 19, 2017 9:26 pm
-
hamw
offline
-
- Posts: 1212
- Joined: Mar 31, 2008
Thanks, Karl. Error is fixed but see below... no data.
Anyway, here's the startup:
Enabling plugin "INDIGOplotD 4.16.21"
Starting plugin "INDIGOplotD 4.16.21" (pid 29971)
Started plugin "INDIGOplotD 4.16.21"
INDIGOplotD initializing ... 4-16-21; 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: batch2Days; GNUPLOT/MATPLOT: mat; GNUplotVersion= ; PLOT-Directory= /Users/XX/Documents/INDIGOplotD/
INDIGOplotD dataversion 2 dataOffsetInTimeDataNumbers:5
INDIGOplotD read file /Users/XX/Documents/INDIGOplotD/data/minute.dat lines: 2016 ok
INDIGOplotD read file /Users/XX/Documents/INDIGOplotD/data/hour.dat lines: 888 ok
INDIGOplotD read file /Users/XX/Documents/INDIGOplotD/data/day.dat lines: 389 ok
INDIGOplotD command: reLoad data from SQL for last 2 days started
INDIGOplotD sql logger used 3318.39 secs CPU so far
INDIGOplotD checking py-restore files
INDIGOplotD initializing ...2
********************
I have three plots I have been trying to use. BTW they say they are printing to the default location but I haven't see one come up yet. The IndigoPlotD script message says "OK" but when the script is executed it turns red briefly in the dialog box. When I click "Show" there is no plot. I only updated one of them with lines, etc, so I thought the below line error was not a big deal?
*******************
INDIGOplotD pending indigoCommands: ['PrintPlotData:1666228865']
PLOT:: Game Rm Temp deviceID: 1666228865
...Background >>#FFFFFF<<
...Border >>1+2+4+8<<
...DeviceNamePlot >>Game Rm Temp<<
...ExtraText >><<
...ExtraTextColorRGB >>#000000<<
...ExtraTextFrontBack >>front<<
...ExtraTextRotate >>0.0<<
...ExtraTextSize >>8<<
...ExtraTextXPos >>0.0<<
...ExtraTextYPos >>0.0<<
...Grid >>0<<
...LeftLabel >><<
...LeftLog >>linear<<
...LeftScaleDecPoints >>0<<
...LeftScaleRange >><<
...LeftScaleTics >><<
...MHDDays >>[2, 14, 90]<<
...MHDShift >>[0, 0, 0]<<
...NumberIsUsed >>1<<
...PlotFileLastupdates >>0<<
...PlotFileOrVariName >><<
...PlotType >>dataFromTimeSeries<<
...Raw >><<
...RightLabel >><<
...RightLog >>linear<<
...RightScaleDecPoints >>0<<
...RightScaleRange >><<
...RightScaleTics >><<
...TextColor >>#000000<<
...TextFont >>System-font<<
...TextMATFont >>sans-serif<<
...TextSize >>8<<
...Textscale21 >>1.5<<
...TitleText >>Game Rm Temp<<
...TransparentBackground >>1.0<<
...TransparentBlocks >>1.0<<
...XLabel >>x-axis Text<<
...XLog >>linear<<
...XScaleDecPoints >>0<<
...XScaleFormat >><<
...XScaleRange >><<
...XScaleTics >><<
...XYvPolar >>xy<<
...ampm >>24<<
...compressPNGfile >>False<<
...dataSource >>mini<<
...drawZeroLine >>False<<
...resxy >>[u'850,350', u'']<<
...variableInText >><<
-l# 1/ Color>#000000<; EveryRepeat>1<; FromTo><; Func>None<; LeftRight>Left<; Multiplier>1.0<; NumbersFormat><; NumbersOffset><; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>8<; ToColumnIndexB>0<; Type>LineSolid<; Width>1<
INDIGOplotD
INDIGOplotD pending indigoCommands: ['PrintPlotData:32335221']
PLOT:: Plot Temp Hum Fam Rm Crawl Space deviceID: 32335221
...Background >>#FFFFFF<<
...Border >>1+2+4+8<<
...DeviceNamePlot >>Plot Temp Hum Fam Rm Crawl Space<<
...ExtraText >><<
...ExtraTextColorRGB >>#000000<<
...ExtraTextFrontBack >>front<<
...ExtraTextRotate >>0.0<<
...ExtraTextSize >>20<<
...ExtraTextXPos >>0.0<<
...ExtraTextYPos >>0.0<<
...Grid >>0<<
...LeftLabel >><<
...LeftLog >>linear<<
...LeftScaleDecPoints >>0<<
...LeftScaleRange >><<
...LeftScaleTics >><<
...MHDDays >>[2, 14, 90]<<
...MHDShift >>[0, 0, 0]<<
...NumberIsUsed >>1<<
...PlotFileLastUpdate >>0<<
...PlotFileLastupdates >>0<<
...PlotFileOrVariName >><<
...PlotType >>dataFromTimeSeries<<
...Raw >><<
...RightLabel >><<
...RightLog >>linear<<
...RightScaleDecPoints >>0<<
...RightScaleRange >><<
...RightScaleTics >><<
...TextColor >>#000000<<
...TextFont >>0<<
...TextMATFont >>sans-serif<<
...TextSize >>20<<
...Textscale21 >>1.5<<
...TitleText >>Fam Rm Crawl Space Temp Humidity<<
...TransparentBackground >>1.0<<
...TransparentBlocks >>1.0<<
...XLabel >>x-axis Text<<
...XLog >>linear<<
...XScaleDecPoints >>0<<
...XScaleFormat >><<
...XScaleRange >><<
...XScaleTics >><<
...XYvPolar >>xy<<
...ampm >>24<<
...compressPNGfile >>False<<
...dataSource >>mini<<
...drawZeroLine >>False<<
...resxy >>[u'850,350', u'']<<
...variableInText >>yes<<
...variableinPlot >><<
-l# 1/ Color>#FF0000<; EveryRepeat>1<; FromTo><; Func>None<; LeftRight>Left<; Multiplier>1.0<; NumbersFormat><; NumbersOffset><; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>5<; ToColumnIndexB>0<; Type>LineSolid<; Width>1<
-l# 2/ Color>#A00000<; EveryRepeat>1<; FromTo><; Func>None<; LeftRight>Right<; Multiplier>1.0<; NumbersFormat><; NumbersOffset><; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>3<; ToColumnIndexB>0<; Type>LineSolid<; Width>2<
-l# 3/ Color>#8B00B2<; EveryRepeat>1<; FromTo><; Func>None<; LeftRight>Left<; Multiplier>1.0<; NumbersFormat><; NumbersOffset><; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>5<; ToColumnIndexB>0<; Type>LineSolid<; Width>1<
-l# 4/ Color>#00FF00<; EveryRepeat>1<; FromTo><; Func>None<; LeftRight>Left<; Multiplier>1.0<; NumbersFormat><; NumbersOffset><; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>6<; ToColumnIndexB>0<; Type>LineSolid<; Width>1<
INDIGOplotD
Received INSTEON "Thermostat MBR" temperature changed to 71.0
INDIGOplotD pending indigoCommands: ['PrintPlotData:828854081']
PLOT:: Plot Temp Hum Game Rm Crawl Space deviceID: 828854081
...Background >>#FFFFFF<<
...Border >>1+2+4+8<<
...DeviceNamePlot >>Plot Temp Hum Game Rm Crawl Space<<
...ExtraText >><<
...ExtraTextColorRGB >>#000000<<
...ExtraTextFrontBack >>front<<
...ExtraTextRotate >>0.0<<
...ExtraTextSize >>20<<
...ExtraTextXPos >>0.0<<
...ExtraTextYPos >>0.0<<
...Grid >>0<<
...LeftLabel >><<
...LeftLog >>linear<<
...LeftScaleDecPoints >>0<<
...LeftScaleRange >><<
...LeftScaleTics >><<
...MHDDays >>[2, 14, 90]<<
...MHDShift >>[0, 0, 0]<<
...NumberIsUsed >>1<<
...PlotFileLastUpdate >>0<<
...PlotFileLastupdates >>0<<
...PlotFileOrVariName >><<
...PlotType >>dataFromTimeSeries<<
...Raw >><<
...RightLabel >><<
...RightLog >>linear<<
...RightScaleDecPoints >>0<<
...RightScaleRange >><<
...RightScaleTics >><<
...TextColor >>#000000<<
...TextFont >>0<<
...TextMATFont >>sans-serif<<
...TextSize >>20<<
...Textscale21 >>1.5<<
...TitleText >>Game Rm Crawl Space Temp Humidity<<
...TransparentBackground >>1.0<<
...TransparentBlocks >>1.0<<
...XLabel >>x-axis Text<<
...XLog >>linear<<
...XScaleDecPoints >>0<<
...XScaleFormat >><<
...XScaleRange >><<
...XScaleTics >><<
...XYvPolar >>xy<<
...ampm >>24<<
...compressPNGfile >>False<<
...dataSource >>mini<<
...drawZeroLine >>False<<
...resxy >>[u'850,350', u'']<<
...variableInText >><<
-l# 1/ Color>#0000A0<; EveryRepeat>1<; FromTo><; Func>None<; LeftRight>Left<; Multiplier>1.0<; NumbersFormat><; NumbersOffset><; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>1<; ToColumnIndexB>0<; Type>LineSolid<; Width>1<
-l# 2/ Color>#A00000<; EveryRepeat>1<; FromTo><; Func>None<; LeftRight>Right<; Multiplier>1.0<; NumbersFormat><; NumbersOffset><; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>3<; ToColumnIndexB>0<; Type>LineSolid<; Width>2<
INDIGOplotD
INDIGOplotD --------------------------------------------------------------
INDIGOplotD Line '9798' has error=''key temperature not found in dict''
INDIGOplotD --------------------------------------------------------------
INDIGOplotD
*********************************
INDIGOplotD command: PrintDeviceData
INDIGOplotD pending indigoCommands: ['PrintDeviceData']
DevNo, Name, ID State Measurement offset multipl minValue maxValue ColfilGps resetType --- nickName
1 TH CrawlSp 3 Game Rm Humidity ok: 1
# 1 Dev-ID: 761629564 humidity average 0.0 1.0 -200.0 50000.0 1 1 0 RFXCrawlSp3GameRm-Humidit-average
# 2 temperature average 0.0 1.0 -200.0 50000.0 2 1 0 RFXCrawlSp3GameRm-Temp-average
2 TH CrawlSp 2 Main House Humidity ok: 1
# 1 Dev-ID: 503075230 humidity average 0.0 1.0 -200.0 50000.0 3 1 0 RFXCrawlSp2MainHouse-Humidit-average
# 2 temperature average 0.0 1.0 -200.0 50000.0 4 1 0 RFXCrawlSp2MainHouse-Temp-average
3 TH CrawlSp 1 Fam Rm Humidity ok: 1
# 1 Dev-ID: 1055284047 humidity average 0.0 1.0 -200.0 50000.0 5 1 0 RFXCrawlSp1FamRm-Humidit-average
# 2 temperature average 0.0 1.0 -200.0 50000.0 6 1 0 RFXCrawlSp1FamRm-Temp-average
4 TH CrawlSp 1 Fam Rm Temp ok: 1
# 1 Dev-ID: 878724171 temperature average 0.0 1.0 -200.0 50000.0 7 1 0 THCrawlSp1FamRmTemp-Temp-average
5 Thermostat GameRm ok: 1
# 1 Dev-ID: 429909040 temperatureInput1 average 0.0 1.0 -200.0 50000.0 8 1 0 ThermostatGameRm-Temp-average
INDIGOplotD
INDIGOplotD Index list for dataColumn to Device#/State#
INDIGOplotD Column=Dev#/St# Column=Dev#/St# Column=Dev#/St# Column=Dev#/St# Column=Dev#/St#
INDIGOplotD 1= 1/ 1 2= 1/ 2 3= 2/ 1 4= 2/ 2 5= 3/ 1
INDIGOplotD 6= 3/ 2 7= 4/ 1 8= 5/ 1
INDIGOplotD
INDIGOplotD
INDIGOplotD Consumption Cost data; type gConsumption WeekDay
INDIGOplotD ...not defined
INDIGOplotD Consumption Cost data; type wConsumption WeekDay
INDIGOplotD ...not defined
INDIGOplotD Consumption Cost data; type eConsumption WeekDay
INDIGOplotD ...not defined
INDIGOplotD Consumption Cost data; type oConsumption WeekDay
INDIGOplotD ...not defined
************************
INDIGOplotD command: reset device parameters
INDIGOplotD removeColumnFromData colToRemove 1 from number of columns: 8
INDIGOplotD pending indigoCommands: ['PauseDataCollection']
INDIGOplotD removeColumnFromData colToRemove 1 from number of columns: 7
Error (client) timeout waiting for plugin response from com.karlwachs.INDIGOplotD for request UiAction
AD2USB Alarm Interface Zone: 39 - Zone Driveway Door Motion RF Wireless 39 state changed to: (Faulted)
INDIGOplotD removeColumnFromData colToRemove 3 from number of columns: 6
AD2USB Alarm Interface Zone: 39 - Zone Driveway Door Motion RF Wireless 39 state changed to: (Clear)
INDIGOplotD removeColumnFromData colToRemove 3 from number of columns: 5
INDIGOplotD removeColumnFromData colToRemove 1 from number of columns: 4
INDIGOplotD removeColumnFromData colToRemove 1 from number of columns: 3
INDIGOplotD removeColumnFromData colToRemove 2 from number of columns: 2
Trigger Pool Heater Pool off/enabled/on Set Pool_Heat_Pool_Status for Pool_Heat_Actual_Status
Trigger Pool Heat Pool Status Variable Change sets Pool_Heat_Status for Heat Indicator Light
Script Pool/Spa Heat has turned ON
INDIGOplotD removeColumnFromData colToRemove 1 from number of columns: 1
INDIGOplotD /Users/XX/Documents/INDIGOplotD/gnu/Plot Temp Hum Fam Rm Crawl Space-minute-S1.gnu has no lines defined -- dont forget to click CONFIRM before you save the lines and plots, ignore this warning if just created
INDIGOplotD /Users/XX/Documents/INDIGOplotD/gnu/Plot Temp Hum Fam Rm Crawl Space-hour-S1.gnu has no lines defined -- dont forget to click CONFIRM before you save the lines and plots, ignore this warning if just created
INDIGOplotD /Users/XX/Documents/INDIGOplotD/gnu/Plot Temp Hum Fam Rm Crawl Space-day-S1.gnu has no lines defined -- dont forget to click CONFIRM before you save the lines and plots, ignore this warning if just created
INDIGOplotD /Users/XX/Documents/INDIGOplotD/gnu/Game Rm Temp-minute-S1.gnu has no lines defined -- dont forget to click CONFIRM before you save the lines and plots, ignore this warning if just created
INDIGOplotD /Users/XX/Documents/INDIGOplotD/gnu/Game Rm Temp-hour-S1.gnu has no lines defined -- dont forget to click CONFIRM before you save the lines and plots, ignore this warning if just created
INDIGOplotD /Users/XX/Documents/INDIGOplotD/gnu/Game Rm Temp-day-S1.gnu has no lines defined -- dont forget to click CONFIRM before you save the lines and plots, ignore this warning if just created
INDIGOplotD /Users/XX/Documents/INDIGOplotD/gnu/Plot Temp Hum Game Rm Crawl Space-minute-S1.gnu has no lines defined -- dont forget to click CONFIRM before you save the lines and plots, ignore this warning if just created
INDIGOplotD /Users/XX/Documents/INDIGOplotD/gnu/Plot Temp Hum Game Rm Crawl Space-hour-S1.gnu has no lines defined -- dont forget to click CONFIRM before you save the lines and plots, ignore this warning if just created
INDIGOplotD /Users/XX/Documents/INDIGOplotD/gnu/Plot Temp Hum Game Rm Crawl Space-day-S1.gnu has no lines defined -- dont forget to click CONFIRM before you save the lines and plots, ignore this warning if just created
INDIGOplotD pending indigoCommands: ['ContinueDataCollection']
INDIGOplotD command: init data done
INDIGOplotD command: reset device parameters done
Error (client) received unexpected packet response UiAction (waiting for )
***********************
This seems to have stopped the error. I tried running the plots again and it did not work. I don't have a backup of the DB, so I just "Reload data from the SQL database from the last 2 days"
***********************
Reloading plugin "INDIGOplotD 4.16.21"
Stopping plugin "INDIGOplotD 4.16.21" (pid 29971)
INDIGOplotD --------------------------------------------------------------
INDIGOplotD Line '8956' has error='None'
INDIGOplotD --------------------------------------------------------------
INDIGOplotD main loop stopped
Stopped plugin "INDIGOplotD 4.16.21"
Starting plugin "INDIGOplotD 4.16.21" (pid 30417)
Started plugin "INDIGOplotD 4.16.21"
INDIGOplotD initializing ... 4-16-21; 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: batch2Days; GNUPLOT/MATPLOT: mat; GNUplotVersion= ; PLOT-Directory= /Users/XX/Documents/INDIGOplotD/
INDIGOplotD /Users/XX/Documents/INDIGOplotD/gnu/Plot Temp Hum Fam Rm Crawl Space-minute-S1.gnu has no lines defined -- dont forget to click CONFIRM before you save the lines and plots, ignore this warning if just created
INDIGOplotD /Users/XX/Documents/INDIGOplotD/gnu/Game Rm Temp-minute-S1.gnu has no lines defined -- dont forget to click CONFIRM before you save the lines and plots, ignore this warning if just created
INDIGOplotD dataversion 2 dataOffsetInTimeDataNumbers:5
INDIGOplotD read file /Users/XX/Documents/INDIGOplotD/data/minute.dat lines: 2304 ok
INDIGOplotD read file /Users/XX/Documents/INDIGOplotD/data/hour.dat lines: 912 ok
INDIGOplotD read file /Users/XX/Documents/INDIGOplotD/data/day.dat lines: 390 ok
INDIGOplotD command: reLoad data from SQL for last 2 days started
INDIGOplotD sql logger used 3375.45 secs CPU so far
INDIGOplotD checking py-restore files
INDIGOplotD initializing ...2
Jun 19, 2017, 10:49:19 PM
INDIGOplotD command: Reload last 2 days from SQL
INDIGOplotD pending indigoCommands: ['ReloadSQL2Days']
INDIGOplotD command: reLoad data from SQL for last 2 days started
********************************
But I don't seem to have any data....
********************************
Reloading plugin "SQL Logger 2.0.5"
Stopping plugin "SQL Logger 2.0.5" (pid 31066)
SQL Logger closing SQL connection
Stopped plugin "SQL Logger 2.0.5"
Starting plugin "SQL Logger 2.0.5" (pid 31274)
Started plugin "SQL Logger 2.0.5"
SQL Logger connected to indigo_history as postgres on 127.0.0.1
SQL Logger searching for unused device and variable tables
SQL Logger search complete (none found)
SQL Logger updating all device tables
SQL Logger updating all variable tables
SQL Logger update complete
From the IndigoPlotD Log:
sqlHistListStatus:[0, 10, 10, 10, 10, 10, 10, 10, 10]
17:24:46 SQL -Convert no records found, try later 1
17:24:46 SQL -Convert no records found, try later 2
17:24:46 SQL - theCol:8; updatesALL:False; sqlDynamic:batch2Days-resetTo-batch2Days; sqlHistListStatus:[0, 10, 10, 10, 10, 10, 10, 10, 10]
17:24:46 SQL -Convert no records found, try later 1
17:24:46 SQL -Convert no records found, try later 2
17:24:46 General - redolineDataSource called from : cleanData
17:24:46 General -redolineDataSource: listOfSelectedDataColumnsAndDevPropName[(0, 'None'), (1, u'THCrawlSp3GameRmHumidity-Humidit-average'), (2, u'THCrawlSp3GameRmHumidity-Temp-average'), (3, u'THCrawlSp2MainHouseHumidity-Humidit-average'), (4, u'THCrawlSp2MainHouseHumidity-Temp-average'), (5, u'THCrawlSp1FamRmHumidity-Humidit-average'), (6, u'THCrawlSp1FamRmHumidity-Temp-average'), (7, u'THCrawlSp1FamRmTemp-Temp-average'), (8, u'ThermostatGameRm-Temp-average')] calledfrom :cleanData
17:24:46 SQL - clearSqlData sqlupdates: [0, 0, 0, 0, 0, 0, 0, 0, 0]
17:24:46 SQL -SQL import 2017-06-18 17:24:46.306147 ... sqlColListStatus: [0, 0, 0, 0, 0, 0, 0, 0, 0]
***************************
So the error is fixed but no data. I think it should have started to accumulate data from yesterday. I set up postgres and IndigoPlotd appears to be pointed to it, but Indigo doesn't seem to be populating it. Anu advice on how to get the database operational?
Thanks!!