I’m very new to InfluxDB, and programming in general, but I have come across my first problem that has been a little stumped.
I will try and explain what I am doing.
I have an InfluxDB that I use for collecting the “blinks” from my electricity meter, this uses a Pi 1B and a bit of Python - nothing too clever but represented a significant learning step for me.
This script occasionally stops working, bound to be my buggy code so I wrote a little bit of Python that checks to see if the last update was more than 5 mins ago.
This works 99% of the time, it crashes occasionally with a date error when I try to convert the date string from the result set into a DateTime type so I can do comparisons against it.
As far as I can tell 99.9% of the time the date returned is in this format;
VERY occasionally, I get it in this format
Originally my scripts weren’t coded to handle that and crashed, I have since addressed this and these changes will not cause issues. But…
Is there any potential explanation for why this happens
Is anyone able to share any thoughts to help me understand it, or shall I just ignore it
The query I am using is SELECT last(“blink”) FROM “leccy”.“autogen”.“house”
As I said above this is a new journey for me, I have some history in RDMS and tend to try and use InfluxDB with that mindset which I know can be wrong.
Thanks in advance.