Beginner's data type confusion

InfluxDB 1
1

I’ve been using InfluxDB for a while as a link between IOBroker and Grafana, but never spent too many thoughts on it. It simply worked.

Now I have an issue where states like true/false are written to InfluxDB, but value mapping in Grafana is not working. Grafana Community wasn’t able to help, so I guess something is messed up with data types in InfluxDB. I started writing values as boolean, but they always appeared as “true”, not reflecting the actual state. After switching type to string, “true/false” state is represented correctly, but value mapping does not apply rules. I wondered if the change in data type messed something up and started writing to a new data point which is “string” from the beginning, but the issue persists.

Is there any chance to take a raw look on the data stored? I’m on InfluxDB 1.6.7 and anyway - I’m confused because I read about more recent versions, but this was the most recent one that was installed when I set up the container.

Thanks in advance!

2

You can test with commands like influx_inspect dumptsm -all and influx_inspect check-schema to get a raw, low-level view of your data and better understand any issues with data types.

Ref: Influx Inspect disk utility | InfluxDB OSS v1 Documentation

3

Thanks suyash!
Unfortunately influx_inspect seems not to be available on my system, or in my PATH. Should it be available as soon as InfluxDB is installed? Do I need to run it from a specific path?