Error in logfile

Posted on
Thu Sep 24, 2015 1:55 am
MortenB offline
Posts: 44
Joined: Jan 24, 2015
Location: Fredrikstad - Norway

Error in logfile

Hi

I suddenly started getting this error in my log-files:
INDIGOplotD readSQLdataBatch calledfrom ...runConcurrentThread histUpdateList[0, 50, 50, 50]
INDIGOplotD readSQLdataBatch calledfrom ...runConcurrentThread sqlUpdateList [0, 0, 0, 0]
INDIGOplotD sql files .done not found.. still waiting
INDIGOplotD readSQLdataBatch calledfrom ...runConcurrentThread histUpdateList[0, 50, 50, 50]
INDIGOplotD readSQLdataBatch calledfrom ...runConcurrentThread sqlUpdateList [0, 0, 0, 0]
INDIGOplotD sql files .done not found.. still waiting
INDIGOplotD readSQLdataBatch calledfrom ...runConcurrentThread histUpdateList[0, 50, 50, 50]
INDIGOplotD readSQLdataBatch calledfrom ...runConcurrentThread sqlUpdateList [0, 0, 0, 0]
INDIGOplotD sql files .done not found.. still waiting
INDIGOplotD sqlUpdateList [0, 10, 10, 10]
INDIGOplotD sql commands launched sqlID anythingToUpdate 0 0
INDIGOplotD Error ------------------------------------
INDIGOplotD Error restarting SQL import, it seems to hang. If this happens several times reload INDIGOplotD :
INDIGOplotD Error ------------------------------------
INDIGOplotD readSQLdataBatch calledfrom ...runConcurrentThread histUpdateList[0, 50, 50, 50]
INDIGOplotD readSQLdataBatch calledfrom ...runConcurrentThread sqlUpdateList [0, 0, 0, 0]
INDIGOplotD sql files .done not found.. still waiting


You can see that I also turned on debugging so you can see what happens. I have tried restarting both INDIGOplotD and SQL Logger plugin.
I also turned on the debug for the SQL Logger and it seems like it is working fine:
SQL Logger updating all variable tables
SQL Logger Debug INSERT INTO variable_history_1786393696 (value) VALUES (?);
SQL Logger Debug (u'false',)
SQL Logger Debug INSERT INTO variable_history_1650276997 (value) VALUES (?);
SQL Logger Debug (u'true',)
SQL Logger Debug INSERT INTO variable_history_125519307 (value) VALUES (?);
SQL Logger Debug (u'false',)
SQL Logger Debug INSERT INTO variable_history_1258268178 (value) VALUES (?);
SQL Logger Debug (u'true',)
SQL Logger Debug INSERT INTO variable_history_340471563 (value) VALUES (?);
SQL Logger Debug (u'',)
SQL Logger Debug INSERT INTO variable_history_1030469029 (value) VALUES (?);
SQL Logger Debug (u'09:52',)
SQL Logger Debug INSERT INTO variable_history_411440144 (value) VALUES (?);
SQL Logger Debug (u'true',)
SQL Logger Debug INSERT INTO variable_history_1859473411 (value) VALUES (?);
SQL Logger Debug (u'true',)


Any ideas as to what can be wrong?
II run 3.11.8 of your plugin.

//Morten

Mac Mini with Indigo 6 - Testing Indigo 7
18 Qubino dimmers
6 Fibaro dimmers (v2)
13 Fibaro Smoke Sensors
13 HeatIt floor thermostats
Also running Node Red and OpenHab2

Posted on
Thu Sep 24, 2015 9:19 am
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Error in logfile

I had this error but do not recall how I fixed it I am out of town and not able to look into it. You could disable the sql logger import in indigoplotd config If you have all the data right now everything should work.

You could though
- delete all data at the bottom of the menu
- restart indigoplotd
- Select restore from 2 days again in indigoplotd menu

First do a save configuration in the menu

That should clear things up


Sent from my iPhone using Tapatalk

Posted on
Thu Sep 24, 2015 9:22 am
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Error in logfile

Or you "import all sql data "


Sent from my iPhone using Tapatalk

Posted on
Sun Jun 18, 2017 8:45 pm
hamw offline
Posts: 1212
Joined: Mar 31, 2008

Re: Error in logfile

I have this recurring in my log:

INDIGOplotD --------------------------------------------------------------
INDIGOplotD Line '9798' has error=''key temperature not found in dict''
INDIGOplotD --------------------------------------------------------------


I have discarded the existing SQL db, iniitated PostGres, pointed IndigoplotD to the Postgres DB, discarded the preference file and reinitiated the plugin. Any ideas? I am thinking I have a corrupt datafield but don't know how to get it fixed. Have not rebooted but will also try that.

Posted on
Sun Jun 18, 2017 11:19 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Error in logfile

Will check tomorrow.


Sent from my iPhone using Tapatalk

Posted on
Sun Jun 18, 2017 11:25 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Error in logfile

which version # are you using?

and please print to log file and post:

print /log plot parameters
print/log device / variable source parameters

it looks as if some of the devices disappeared and now indigoplot is not ins sync with indigo..
brute force:
1. delete all device defs (last option in the menu) (takes ~ 1 minute)
2. "select config to restore" and select one from 2 days ago. (takes ~ 1-2 minutes)

that should restore all defs properly from 2 days ago incl plots etc.

Karl

Posted on
Mon Jun 19, 2017 9:26 pm
hamw offline
Posts: 1212
Joined: Mar 31, 2008

Re: Error in logfile

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!!

Posted on
Mon Jun 19, 2017 11:33 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Error in logfile

can you run utilities and do print device data to check if anything is there.. does indigo complain?

pqsl debugging thats not easy through posts..

I have installed the psql app:
then added it to autostart
then enable postgres in indigo
then added the proper path to indigo plot

but thats very high level.

we could do an online session if you like ..

Posted on
Thu Jun 22, 2017 7:11 pm
hamw offline
Posts: 1212
Joined: Mar 31, 2008

Re: Error in logfile

Karl,

Many many thanks for your assistance. This is a terrific plugin!

Ham

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 3 guests

cron