I am using Postgres and never had an issue.
It takes 10 minutes to setup:
Download app. click on installer. Start.
Sent from my iPhone using Tapatalk
GRWilde wrote:I see another error that occurs every few days in some of my plots. A very few of my plots show no change in data for over a day then begin updating at around midnight. I traced this to the daily "2 days" refresh of SQL logger data at 16 minutes past midnight every morning. Some SQL logger data is not fully imported, as shown in the following log where the Downstairs Hall Temperature had only a single input, whereas the other entries had a complete set of imports. The data was actually in the SQL logger data because doing a manual "2 days" import restored all of the data for the plots:
INDIGOplotD command: create Python code for PLOTs in /Users/grwilde/indigo/INDIGOplotD/py/RestoreConfigAndPlots-20180321-001603.py DONE
INDIGOplotD Converted 0:00:00.386290 TED 5000-PowerNow_MTU1-average 95121/ 8123/ 494008/ 2632125-rejec: 0/ 0/ 0/ 86998/ 0/ 1
INDIGOplotD Converted 0:00:00.067676 003 - Downstairs Hall Temperature-sensorValue-average 1101/ 1/ 1101/ 26418-rejec: 0/ 0/ 0/ 1100/ 0/ 11
INDIGOplotD Converted 0:00:00.074461 006 - Inside Garage Temperature-sensorValue-average 1152/ 99/ 1152/ 27693-rejec: 0/ 0/ 0/ 1053/ 0/ 4
INDIGOplotD Converted 0:00:00.081248 004 - Entry Hall Temperature-sensorValue-average 1283/ 103/ 1283/ 30968-rejec: 0/ 0/ 0/ 1180/ 0/ 3
INDIGOplotD Converted 0:00:00.088101 005 - Upstairs Hall Temperature-sensorValue-average 1297/ 108/ 1297/ 31318-rejec: 0/ 0/ 0/ 1189/ 0/ 5
INDIGOplotD Converted 0:00:00.378657 Ecobee Thermostat-hvacFanIsOn-average 14709/ 1312/ 29684/ 362162-rejec: 0/ 0/ 0/ 13397/ 0/ 9
INDIGOplotD Converted 0:00:00.500678 Ecobee Thermostat-hvacCoolerIsOn-average 14711/ 1312/ 29684/ 362212-rejec: 0/ 0/ 0/ 13399/ 0/ 8
INDIGOplotD Converted 0:00:00.554645 Ecobee Thermostat-hvacHeaterIsOn-average 14711/ 1312/ 29684/ 362213-rejec: 0/ 0/ 0/ 13399/ 0/ 7
INDIGOplotD Converted 0:00:00.607739 Ecobee Thermostat-temperatureInput1-average 14710/ 1312/ 29684/ 376898-rejec: 0/ 0/ 0/ 13398/ 0/ 6
INDIGOplotD Converted 0:00:00.904237 Ecobee Thermostat-humidityInput1-average 14710/ 1312/ 29684/ 376899-rejec: 0/ 0/ 0/ 13398/ 0/ 10
INDIGOplotD Converted 0:00:01.321059 TED 5000-VoltageNow_MTU1-average 95114/ 8122/ 494010/ 2642497-rejec: 0/ 0/ 0/ 86992/ 0/ 2
INDIGOplotD Converted 0:00:00.144808 costPerHour-value-average- 1722/ 1722/ 1723/ 46567-rejec: 0/ 0/ 0/ 0/ 0/ 18
INDIGOplotD Converted 0:00:00.264067 WeatherSnoop-windSpeed_mph-average 25351/ 1966/ 25351/ 622671-rejec: 0/ 0/ 0/ 23385/ 0/ 16
INDIGOplotD Converted 0:00:00.383734 WeatherSnoop-rainRate_in-average 25351/ 1966/ 25351/ 623542-rejec: 0/ 0/ 0/ 23385/ 0/ 17
INDIGOplotD Converted 0:00:00.472166 WeatherSnoop-outdoorTemperature_F-average 25351/ 1966/ 25351/ 648020-rejec: 0/ 0/ 0/ 23385/ 0/ 12
INDIGOplotD Converted 0:00:00.556743 WeatherSnoop-outdoorHumidity-average 25351/ 1966/ 25351/ 648020-rejec: 0/ 0/ 0/ 23385/ 0/ 13
INDIGOplotD Converted 0:00:00.646001 WeatherSnoop-indoorTemperature_F-average 25351/ 1966/ 25351/ 648020-rejec: 0/ 0/ 0/ 23385/ 0/ 14
INDIGOplotD Converted 0:00:00.784320 WeatherSnoop-relativeBarometricPressure_inHg-average 25351/ 1966/ 25351/ 670394-rejec: 0/ 0/ 0/ 23385/ 0/ 15
INDIGOplotD SQL import 2018-03-21 00:16:13.699113 ... finished, total number of records imported: 36634
I am using Postgres and never had an issue.
It takes 10 minutes to setup:
Download app. click on installer. Start.
/Applications/Postgres.app/Contents/Versions/9.6/bin/psql indigo_history -U postgres
/Library/PostgreSQL/bin/psql indigo_history postgres
I can’t look it up right now. But it is mentioned in one of the threads also the help text should give you a hint. You need to adapt to your version number.
If you have indigo utilities working it uses the same string.
The problem is that the daily 2 day batch refresh at 16 minutes past midnight erases all of the plot information for the past two days and replaces it with empty data. The plots then begin refreshing from that time forward. Plots older than two days remain. The following is the event log associated with the daily refresh. I am at a loss regarding how to solve this problem.
Users browsing this forum: No registered users and 7 guests