Data isn't posting

#1

I’ve been posting data to Influx for several weeks. This was working fine, but for the past couple of days certain measurements don’t seem to be posting (particularly boolean ones).

For instance, this post is successful and gets the No Content response from the API:
Treat_1.Device.Chamber_1.DOOR_CLOSED_1-11-2 value=0 1496936357309
(date is June 8th at 3:39PM UTC)

But then if I run this query:
SELECT * FROM "Treat_1.Device.Chamber_1.DOOR_CLOSED_1-11-2" ORDER BY time DESC LIMIT 100

The last data point I get is:
2017-06-07T13:58:23.111Z value=1

I’m not sure what’s going on - ? Why do these suddenly stop posting? What’s the best way to debug this? We have V0.9.

#2

@louloizides The 0.9 line is deprecated. There are a number of bugs that have been fixed between then and now that fix potential issues you might be running into. I would highly advise that you upgrade to the 1.2 release.

#3

This documentation on Schema Design will also help you as well. You are writing essentially a Graphite schema that doesn’t allow you to take advantage of tagging in Influx.

#4

You are writing essentially a Graphite schema that doesn’t allow you to take advantage of tagging in Influx

Exactly! Take InfluxDB measurement names like SQL table names. Would a table called Treat_1.Device.Chamber_1.DOOR_CLOSED_1-11-2 make sense?

#5

All-

Thanks for the tips… unfortunately the Influx I’m accessing is integrated into another product and they haven’t yet upgraded, so I need to wait until that happens.

In the case above “Treat_1.Device.Chamber_1.DOOR_CLOSED_1-11-2” is the sensor I’m recording data from. So would it make more sense to have one table called “Sensors” and then have the above as a sensor name tag?

Thanks,

Lou

#6

@louloizides Looks lke there are a couple of pieces of data there. Splitting it up into as many tags as possible would be the right way to do it. I would say something like:

Graphite: Treat_1.Device.Chamber_1.DOOR_CLOSED_1-11-2 true TS
Influx: sensors,site=Treat_1,room=Chamber_1,foo=DOOR_CLOSED,bar=1-11-2 value=true TS