Problem with Graph+ showing zero - resolved

[llamafilm]

The same thing just happened to me for one output. The values are correct on the Status page but the graph shows zero. Looking back in the graph, this started on February 6, which happens to be the same day that I had this weird behavior. Just before the zeroes start, there was a weird value of -79 Gigawatts. Before that time, there is no data.

Before I try clearing the log, I wanted to see if you want to see any diagnostic to find out what caused this.

http://192.168.20.32/query?select=[Grid_Import,Grid_Export]&begin=2023-02-06&end=2023-02-7&group=h&format=csv&header=yes
Grid_Import, Grid_Export
null, null
null, null
null, null
null, null
null, null
null, null
null, null
null, null
null, null
146.6, 79303931023
0, 0
0, 0
0, 0
0, 0
0, 0
882.7, 0
41.7, 0
355.7, 0
294, 0
1734.5, 0
717.1, 0
702.6, 0
645.4, 0
192.9, 0

[overeasy]

Im not convinced you have a datalog problem. Can I see your outputs setup and any integrator you have setup please? Also, can you show the status display with the datalogs tab expanded?

[llamafilm]

Does the log get erased when you pull the power? I tried that while troubleshooting on Feb 6.

[overeasy]

@llamafilm

Does the log get erased when you pull the power?

No, but the datalogs were (re)created around that time. I’d need to see the message log covering 2/6/2023 at 9:15:25 to offer any guess as to why.

I think the problem with the first query entry has to do with the datalogs being recreated but the integrator was not. If you delete the integrator and recreate, that should go away (but your integrator will start from 24 hours before the time you recreate it).

[llamafilm]

It’s possible I cleared the log on that day while troubleshooting, I don’t remember. Here’s the log, there is nothing newer than this:

** Restart **

SD initialized.
2/06/23 17:11:16z Real Time Clock is running. Unix time 1675703476 
2/06/23 17:11:16z Reset Reason: Power-fail restart.
2/06/23 17:11:16z ESP8266 ID: 14622328, RTC PCF8523 (68)
2/06/23 17:11:16z IoTaWatt 5.0, Firmware version 02_07_05
2/06/23 17:11:16z SPIFFS mounted.
2/06/23 09:11:16 Local time zone: -8:00, using DST/BST when in effect.
2/06/23 09:11:16 device name: IotaWatt
2/06/23 09:11:19 HTTP server started
2/06/23 09:11:19 WiFi connected. SSID=IoT, IP=192.168.20.32, channel=1, RSSI -74db
2/06/23 09:11:19 MDNS responder started for hostname IotaWatt
2/06/23 09:11:19 LLMNR responder started for hostname IotaWatt
2/06/23 09:11:19 timeSync: service started.
2/06/23 09:11:19 statService: started.
2/06/23 09:11:19 Updater: service started. Auto-update class is MINOR
2/06/23 09:11:19 dataLog: service started.
2/06/23 09:11:19 dataLog: Last log entry 02/06/23 09:11:05
2/06/23 09:11:23 Updater: Auto-update is current for class MINOR.
2/06/23 09:11:24 historyLog: service started.
2/06/23 09:11:24 historyLog: Last log entry 02/06/23 09:11:00
2/06/23 09:11:24 Grid: Started
2/06/23 09:11:24 Grid: Last log entry 02/06/23 09:11:05
2/06/23 09:11:29 PVoutput: started
2/06/23 09:11:29 PVoutput: System desert-llama, interval 5, freeload mode  
2/06/23 09:11:29 PVoutput: Start status beginning 02/06/23 09:10:00
2/06/23 09:15:19 deletelog=both command received.

** Restart **

SD initialized.
2/06/23 17:15:21z Real Time Clock is running. Unix time 1675703721 
2/06/23 17:15:21z Reset reason: Software/System restart
2/06/23 17:15:21z Trace:  1:2, 1:3, 1:3, 1:3, 1:3, 1:3, 1:3, 1:3, 1:3, 1:3, 1:3, 1:3, 1:3, 1:3, 1:3, 1:1[5], 1:2[6], 9:0[6], 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:21, 10:23
2/06/23 17:15:21z ESP8266 ID: 14622328, RTC PCF8523 (68)
2/06/23 17:15:21z IoTaWatt 5.0, Firmware version 02_07_05
2/06/23 17:15:21z SPIFFS mounted.
2/06/23 09:15:21 Local time zone: -8:00, using DST/BST when in effect.
2/06/23 09:15:21 device name: IotaWatt
2/06/23 09:15:21 HTTP server started
2/06/23 09:15:21 timeSync: service started.
2/06/23 09:15:21 statService: started.
2/06/23 09:15:21 dataLog: service started.
2/06/23 09:15:21 dataLog: New current log created.
2/06/23 09:15:26 Grid: Started
2/06/23 09:15:26 Grid: Last log entry 02/06/23 09:15:15
2/06/23 09:15:31 PVoutput: started
2/06/23 09:15:31 WiFi connected. SSID=IoT, IP=192.168.20.32, channel=1, RSSI -75db
2/06/23 09:15:31 MDNS responder started for hostname IotaWatt
2/06/23 09:15:31 LLMNR responder started for hostname IotaWatt
2/06/23 09:15:31 Updater: service started. Auto-update class is MINOR
2/06/23 09:15:32 PVoutput: System desert-llama, interval 5, freeload mode  
2/06/23 09:15:34 Updater: Auto-update is current for class MINOR.
2/06/23 09:15:34 PVoutput: Start status beginning 02/05/06 22:35:00
2/06/23 09:16:28 historyLog: service started.
2/06/23 09:16:28 historyLog: first entry 02/06/23 09:16:00

** Restart **

SD initialized.
2/06/23 20:34:05z Real Time Clock is running. Unix time 1675715645 
2/06/23 20:34:05z Reset Reason: Power-fail restart.
2/06/23 20:34:05z ESP8266 ID: 14622328, RTC PCF8523 (68)
2/06/23 20:34:05z IoTaWatt 5.0, Firmware version 02_07_05
2/06/23 20:34:05z SPIFFS mounted.
2/06/23 12:34:05 Local time zone: -8:00, using DST/BST when in effect.
2/06/23 12:34:05 device name: IotaWatt
2/06/23 12:34:08 HTTP server started
2/06/23 12:34:08 WiFi connected. SSID=IoT, IP=192.168.20.32, channel=1, RSSI -75db
2/06/23 12:34:08 MDNS responder started for hostname IotaWatt
2/06/23 12:34:08 LLMNR responder started for hostname IotaWatt
2/06/23 12:34:08 timeSync: service started.
2/06/23 12:34:08 statService: started.
2/06/23 12:34:08 Updater: service started. Auto-update class is MINOR
2/06/23 12:34:08 dataLog: service started.
2/06/23 12:34:08 dataLog: Last log entry 02/06/23 12:33:50
2/06/23 12:34:10 Updater: Auto-update is current for class MINOR.
2/06/23 12:34:13 historyLog: service started.
2/06/23 12:34:13 historyLog: Last log entry 02/06/23 12:33:00
2/06/23 12:34:13 Grid: Started
2/06/23 12:34:13 Grid: Last log entry 02/06/23 12:33:45
2/06/23 12:34:18 PVoutput: started
2/06/23 12:34:18 PVoutput: System desert-llama, interval 5, freeload mode  
2/06/23 12:34:18 PVoutput: Start status beginning 02/06/23 09:25:00

I just recreated the integrator and now it’s showing zero for both import and export, even on the status page.

[overeasy]

It was still integrating. When the end date/time of Grid Log matches the end date/time of Current Log, it will be available.

[llamafilm]

Ah ok, yes it’s working now. So it sounds like this problem happened because I cleared the Datalog but did not recreate the integrator?

[overeasy]

That’s right. The datalog delete pre-existed integrators and TBH there needs to be some work done to also delete the integrator logs.