I keep getting a problem - just recently where I get this message:
influxDB1: Running, Last update 3/24/2022 11:22:40 PM
Post failed 500
I have confirmed the database exists, my home assistant service is posting to influx without incident.
I have stopped the data uploader and started it and it still shows the same wrong data? I have rebooted the iotawatt 2 x already.
Any other suggestions?
Thanks,
Neil
500 is internal server error. The only instance I can see of that in the influx 1 docs is retention policy doesn’t exist.
SHOW RETENTION POLICIES
name duration shardGroupDuration replicaN default
autogen 0s 168h0m0s 1 true
It looks like the time at the end is sloooowly updating but it shouldn’t take that long I wouldn’t imagine?
I only get this when I restart the upload. Not sure if I can enable verbose logging. But in 8 minutes it had only uploaded 3 minutes worth of data?
3/28/22 08:53:30 influxDB_v1: Start posting at 03/24/22 23:20:55
3/28/22 09:01:32 influxDB_v1: Start posting at 03/24/22 23:23:40
Uploaders are slow. They run as low priority services where the processor is sampling power 67% of the time. The data has to be read from the SDcard and the WiFi is memory constrained to small transactions. Welcome to IOT.
That said, over time it should not be taking one step forward and two back. You should make headway. That’s a small sample.
Factors that slow it down are:
Poor WiFi connection
very short upload interval like 5 seconds
Many measurements
Excessively long names for the measurements.
A lot of tags.
other uploaders running.
Using a https proxy.
Assuming it eventually catches up, there should be no problem keeping current during normal operation.
Right well im not terribly well versed in influx querying - so I don’t know for a fact that anything is actually going in but I didn’t want to wait a bunch of days and find out it isnt…
If you watch the uploader status tab, you should be able to see any progress. The protocol is synchronous, so IoTaWatt checks for a valid completion from influx after each packet.
If I go to setup->data uploader at the bottom those three boxes are empty. If I select influxv1 it remains blank. How often should it update?
There should be an uploader tab in your status display. Click on it to expand.
Thats where I am getting the 500 message - over and over. I can see the tables and all
SHOW MEASUREMENTS
name: measurements
name
attic_ac
downstairs_panel
everything
main_level
pool
show queries
qid query database duration status
94 SHOW QUERIES iotawatt 108µs running
show series from attic_ac
key
attic_ac,ct=attic_ac,device=IotaWatt,units=Watts
Can you post your influx uploader setup screen please, and also your status screen?
Not sure why I doubted you. Retention policy issue. I don’t know why. I added a new one and made it the default so it appears to be uploading now. Thanks!