Every morning at approximately one minute past midnight I am getting SQL Logger timed out errors for about a minute or two, then everything resumes as normal. The INDIGOplotD plots do not seem to be affected because this is a short term problem. The error always occurs immediately after the following INDIGOplotD command:
INDIGOplotD command: shift day done
I am using PostgreSQL, and it appears that any device attempting to log data for a minute or two following this INDIGOplotD command times out with an error. An example is the following:
2018-06-23 00:01:51.795 SQL Logger Error exception trying to insert row into table device_history_336233721 ("Ecobee Thermostat")
2018-06-23 00:01:51.978 SQL Logger Error timed out
2018-06-23 00:01:51.979 SQL Logger Error INSERT INTO device_history_336233721 ("authenticated", "autoaway", "autohome", "climate", "humidityinput1", "humidityinputsall", "hvaccoolerison", "hvacdehumidifierison", "hvacfanison", "hvacfanmode", "hvacfanmode_ui", "hvacfanmodeisalwayson", "hvacfanmodeisauto", "hvacheaterison", "hvachumidifierison", "hvacoperationmode", "hvacoperationmode_ui", "hvacoperationmodeisauto", "hvacoperationmodeiscool", "hvacoperationmodeisheat", "hvacoperationmodeisoff", "hvacoperationmodeisprogramauto", "hvacoperationmodeisprogramcool", "hvacoperationmodeisprogramheat", "occupied", "setpointcool", "setpointcool_ui", "setpointheat", "setpointheat_ui", "temperatureinput1", "temperatureinput1_ui", "temperatureinput2", "temperatureinput2_ui", "temperatureinputsall") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);