great thank you.
I ended up setting the ISO time in UTC timezone (as I can’t guarantee the TZ one the machine performing the query is the same as the iotawatt).
Something you may want to look into, I’ve managed to make my iota completely unresponsive and requiring a reboot performing some queries.
http://192.168.10.3/query?select=[time.iso,Total_Solar.d5,Total_Solar.wh.d9]&begin=2021-08-29T10:07:00Z&end=2021-08-29T10:07:30Z&group=all
So I was playing with that url, and I changed the various precision value on both end between 3 and 9 and from time to time, in my haste I would cause the URL to be incorrect, typically because I incorrectly deleted the ,
before Total_Solar
like so:
http://192.168.10.3/query?select=[time.iso,Total_Solar.d5Total_Solar.wh.d9]&begin=2021-08-29T10:07:00Z&end=2021-08-29T10:07:30Z&group=all
I continued writing rubbish URL by specifying .d without a number behind etc.
When I pressed enter I didn’t get an error, the iotawatt no longer responded.
I managed to reproduce it twice in under 5 minutes. A 3rd time it stopped responding to ping but came back only about 1 minute later.
Now it is possible that it just happened that the wifi went down twice exactly at those time, but seeing it’s been rock solid all day it would be a weird coincidence.
This is the log after the first occurence:
** Restart **
SD initialized.
8/26/21 23:34:17z Real Time Clock is running. Unix time 1630020857
8/26/21 23:34:17z Power failure detected.
8/26/21 23:34:17z Reset reason: Power on
8/26/21 23:34:17z ESP8266 ChipID: 6308362
8/26/21 23:34:17z IoTaWatt 5.0, Firmware version 02_05_11
8/26/21 23:34:17z SPIFFS mounted.
8/27/21 09:34:17 Local time zone: +10:00
8/27/21 09:34:17 Using Daylight Saving Time (BST) when in effect.
8/27/21 09:34:17 device name: IotaWatt
8/27/21 09:34:20 Connecting with WiFiManager.
8/27/21 09:37:20 Did not connect after power-fail. Restarting to reset WiFi.
** Restart **
SD initialized.
8/26/21 23:37:22z Real Time Clock is running. Unix time 1630021042
8/26/21 23:37:22z Reset reason: Software/System restart
8/26/21 23:37:22z Trace: 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, 11:0, 11:4, 11:5, 11:5, 11:6, 11:7, 11:8, 11:9, 16:0, 11:10, 11:11, 11:12, 11:12
8/26/21 23:37:22z ESP8266 ChipID: 6308362
8/26/21 23:37:22z IoTaWatt 5.0, Firmware version 02_05_11
8/26/21 23:37:22z SPIFFS mounted.
8/27/21 09:37:22 Local time zone: +10:00
8/27/21 09:37:22 Using Daylight Saving Time (BST) when in effect.
8/27/21 09:37:22 device name: IotaWatt
8/27/21 09:37:22 HTTP server started
8/27/21 09:37:22 timeSync: service started.
8/27/21 09:37:22 statService: started.
8/27/21 09:37:23 dataLog: service started.
8/27/21 09:37:26 dataLog: Last log entry 08/27/21 09:34:00
8/27/21 09:37:34 WiFi connected. SSID=HOME-WLAN, IP=192.168.10.3, channel=11, RSSI -59db
8/27/21 09:37:34 MDNS responder started for hostname IotaWatt
8/27/21 09:37:34 LLMNR responder started for hostname IotaWatt
8/27/21 09:37:34 Updater: service started. Auto-update class is NONE
8/27/21 09:38:22 historyLog: service started.
8/27/21 09:38:23 historyLog: Last log entry 08/27/21 09:34:00
8/28/21 16:11:53 Updater: Auto-update class changed to MINOR
8/28/21 16:11:58 Updater: Update from 02_05_11 to 02_06_05
8/28/21 16:11:58 Updater: download 02_06_05
8/28/21 16:12:04 Updater: Download failed HTTPcode -11
8/28/21 16:23:03 Restart command received.
** Restart **
SD initialized.
8/28/21 06:23:05z Real Time Clock is running. Unix time 1630131785
8/28/21 06:23:05z Reset reason: Software/System restart
8/28/21 06:23:05z Trace: 1:4, 1:1[10], 1:2[11], 9:0[11], 9:0, 9:1, 8:4, 8:6, 8:8, 8:9, 9:3, 9:5, 9:9, 1:2, 1:3, 1:4, 1:1[11], 1:2[12], 9:0[12], 9:0, 9:1, 8:4, 8:6, 8:8, 8:9, 9:3, 9:5, 9:9, 1:2, 1:3, 10:2, 10:3
8/28/21 06:23:05z ESP8266 ChipID: 6308362
8/28/21 06:23:05z IoTaWatt 5.0, Firmware version 02_05_11
8/28/21 06:23:05z SPIFFS mounted.
8/28/21 16:23:05 Local time zone: +10:00
8/28/21 16:23:05 Using Daylight Saving Time (BST) when in effect.
8/28/21 16:23:05 device name: IotaWatt
8/28/21 16:23:05 HTTP server started
8/28/21 16:23:05 timeSync: service started.
8/28/21 16:23:05 statService: started.
8/28/21 16:23:06 dataLog: service started.
8/28/21 16:23:10 dataLog: Last log entry 08/28/21 16:23:00
8/28/21 16:24:06 historyLog: service started.
8/28/21 16:24:07 historyLog: Last log entry 08/28/21 16:23:00
8/28/21 16:27:40 WiFi connected. SSID=HOME-WLAN, IP=192.168.10.3, channel=8, RSSI -55db
8/28/21 16:27:40 MDNS responder started for hostname IotaWatt
8/28/21 16:27:40 LLMNR responder started for hostname IotaWatt
8/28/21 16:27:40 Updater: service started. Auto-update class is MINOR
8/28/21 16:27:41 Updater: Update from 02_05_11 to 02_06_05
8/28/21 16:27:41 Updater: download 02_06_05
8/28/21 16:27:46 Updater: Release downloaded 5616ms, size 834296
8/28/21 16:27:54 Updater: signature verified
8/28/21 16:28:03 Updater: firmware upgraded to version 02_06_05
8/28/21 16:28:03 Updater: Firmware updated, restarting.
** Restart **
SD initialized.
8/28/21 06:28:12z Real Time Clock is running. Unix time 1630132092
8/28/21 06:28:12z Reset reason: Software/System restart
8/28/21 06:28:12z Trace: 9:0, 9:1, 8:4, 8:6, 8:8, 8:9, 9:3, 9:5, 9:9, 1:2, 1:3, 1:4, 1:5[19], 1:6, 1:1[12], 1:2[13], 9:0[13], 9:0, 9:1, 8:4, 8:6, 8:8, 8:9, 9:3, 9:5, 9:9, 1:2, 1:3, 1:4, 1:5[5], 5:0, 5:7
8/28/21 06:28:12z ESP8266 ChipID: 6308362
8/28/21 06:28:12z IoTaWatt 5.0, Firmware version 02_06_05
8/28/21 06:28:12z Updater: Installing update files for version 02_06_05
8/28/21 06:28:12z Updater: Installing GRAPH.HTM
8/28/21 06:28:12z Updater: Installing GRAPH.JS
8/28/21 06:28:12z Updater: Installing GRAPH2.HTM
8/28/21 06:28:12z Updater: Installing GRAPH2.JS
8/28/21 06:28:13z Updater: Installing INDEX.HTM
8/28/21 06:28:13z Updater: Installing TABLES.TXT
8/28/21 06:28:13z Updater: Installing CNFSTYLE.CSS
8/28/21 06:28:13z Updater: Installing EDIT.HTM
8/28/21 06:28:13z Updater: Installation complete.
8/28/21 06:28:13z SPIFFS mounted.
8/28/21 16:28:14 Local time zone: +10:00
8/28/21 16:28:14 Using Daylight Saving Time (BST) when in effect.
8/28/21 16:28:14 device name: IotaWatt
8/28/21 16:28:14 HTTP server started
8/28/21 16:28:14 timeSync: service started.
8/28/21 16:28:14 statService: started.
8/28/21 16:28:14 dataLog: service started.
8/28/21 16:28:16 dataLog: Last log entry 08/28/21 16:27:45
8/28/21 16:28:19 historyLog: service started.
8/28/21 16:28:19 historyLog: Last log entry 08/28/21 16:27:00
8/28/21 16:28:19 WiFi connected. SSID=HOME-WLAN, IP=192.168.10.3, channel=8, RSSI -53db
8/28/21 16:28:19 MDNS responder started for hostname IotaWatt
8/28/21 16:28:19 LLMNR responder started for hostname IotaWatt
8/28/21 16:28:19 Updater: service started. Auto-update class is MINOR
8/28/21 16:28:20 Updater: Auto-update is current for class MINOR.
8/28/21 22:29:12 Updater: Invalid response from server. HTTPcode: -11
8/29/21 03:29:51 Updater: Invalid response from server. HTTPcode: -4
** Restart **
SD initialized.
8/29/21 02:45:01z Real Time Clock is running. Unix time 1630205101
8/29/21 02:45:01z Power failure detected.
8/29/21 02:45:01z Reset reason: Power On
8/29/21 02:45:01z ESP8266 ChipID: 6308362
8/29/21 02:45:01z IoTaWatt 5.0, Firmware version 02_06_05
8/29/21 02:45:01z SPIFFS mounted.
8/29/21 12:45:01 Local time zone: +10:00
8/29/21 12:45:01 Using Daylight Saving Time (BST) when in effect.
8/29/21 12:45:01 device name: IotaWatt
8/29/21 12:45:04 Connecting with WiFiManager.
8/29/21 12:48:04 Did not connect after power-fail. Restarting to reset WiFi.
** Restart **
SD initialized.
8/29/21 02:48:05z Real Time Clock is running. Unix time 1630205285
8/29/21 02:48:05z Reset reason: Software/System restart
8/29/21 02:48:05z Trace: 0:0, 0:0, 11:0, 11:4, 11:5, 11:5, 11:10, 11:15, 11:20, 11:20[1], 11:20[2], 11:20[3], 11:21, 11:22, 11:21, 11:22, 11:21, 11:22, 11:21, 11:22, 11:20[4], 11:20[5], 11:20[6], 11:20[7], 11:25, 11:30, 11:31, 11:30, 11:35, 11:40, 11:45, 11:70
8/29/21 02:48:05z ESP8266 ChipID: 6308362
8/29/21 02:48:05z IoTaWatt 5.0, Firmware version 02_06_05
8/29/21 02:48:05z SPIFFS mounted.
8/29/21 12:48:05 Local time zone: +10:00
8/29/21 12:48:05 Using Daylight Saving Time (BST) when in effect.
8/29/21 12:48:05 device name: IotaWatt
8/29/21 12:48:05 HTTP server started
8/29/21 12:48:05 timeSync: service started.
8/29/21 12:48:05 statService: started.
8/29/21 12:48:05 dataLog: service started.
8/29/21 12:48:07 dataLog: Last log entry 08/29/21 12:44:40
8/29/21 12:48:10 historyLog: service started.
8/29/21 12:48:10 historyLog: Last log entry 08/29/21 12:44:00
8/29/21 12:52:16 WiFi connected. SSID=HOME-WLAN, IP=169.254.11.66, channel=8, RSSI -48db
8/29/21 12:52:16 MDNS responder started for hostname IotaWatt
8/29/21 12:52:16 LLMNR responder started for hostname IotaWatt
8/29/21 12:52:16 Updater: service started. Auto-update class is MINOR
8/29/21 12:58:00 WiFi disconnected.
8/29/21 12:58:38 WiFi connected. SSID=HOME-WLAN, IP=192.168.10.3, channel=7, RSSI -51db
8/29/21 12:58:39 Updater: Auto-update is current for class MINOR.
8/29/21 13:58:56 Updater: Invalid response from server. HTTPcode: -11
** Restart **
SD initialized.
8/29/21 09:44:47z Real Time Clock is running. Unix time 1630230287
8/29/21 09:44:47z Power failure detected.
8/29/21 09:44:47z Reset reason: Power On
8/29/21 09:44:47z ESP8266 ChipID: 6308362
8/29/21 09:44:47z IoTaWatt 5.0, Firmware version 02_06_05
8/29/21 09:44:47z SPIFFS mounted.
8/29/21 19:44:47 Local time zone: +10:00
8/29/21 19:44:47 Using Daylight Saving Time (BST) when in effect.
8/29/21 19:44:47 device name: IotaWatt
8/29/21 19:44:50 Connecting with WiFiManager.
8/29/21 19:47:50 Did not connect after power-fail. Restarting to reset WiFi.
** Restart **
SD initialized.
8/29/21 09:47:51z Real Time Clock is running. Unix time 1630230471
8/29/21 09:47:51z Reset reason: Software/System restart
8/29/21 09:47:51z Trace: 0:0, 0:0, 11:0, 11:4, 11:5, 11:5, 11:10, 11:15, 11:20, 11:20[1], 11:20[2], 11:20[3], 11:21, 11:22, 11:21, 11:22, 11:21, 11:22, 11:21, 11:22, 11:20[4], 11:20[5], 11:20[6], 11:20[7], 11:25, 11:30, 11:31, 11:30, 11:35, 11:40, 11:45, 11:70
8/29/21 09:47:51z ESP8266 ChipID: 6308362
8/29/21 09:47:51z IoTaWatt 5.0, Firmware version 02_06_05
8/29/21 09:47:51z SPIFFS mounted.
8/29/21 19:47:51 Local time zone: +10:00
8/29/21 19:47:51 Using Daylight Saving Time (BST) when in effect.
8/29/21 19:47:51 device name: IotaWatt
8/29/21 19:47:51 HTTP server started
8/29/21 19:47:51 timeSync: service started.
8/29/21 19:47:51 statService: started.
8/29/21 19:47:51 dataLog: service started.
8/29/21 19:47:53 dataLog: Last log entry 08/29/21 19:44:30
8/29/21 19:47:56 historyLog: service started.
8/29/21 19:47:56 historyLog: Last log entry 08/29/21 19:44:00
8/29/21 19:47:56 WiFi connected. SSID=HOME-WLAN, IP=192.168.10.3, channel=10, RSSI -48db
8/29/21 19:47:56 MDNS responder started for hostname IotaWatt
8/29/21 19:47:56 LLMNR responder started for hostname IotaWatt
8/29/21 19:47:56 Updater: service started. Auto-update class is MINOR
8/29/21 19:47:58 Updater: Auto-update is current for class MINOR.