Wrong timestamp

Telegraf
1

Hello all, this is my first post.
I’m having trouble writing old timestamps, and i’m kinda lost about what is wrong.
I have a file “salida.txt” with
“airTempL,host=SanRoque value=12.92 1529240400000
airTempL,host=SanRoque value=13.92 1529241600000
airTempL,host=SanRoque value=14.36 1529242800000
airTempL,host=SanRoque value=14.27 1529244060000”

and using python to store the data
os.system(“curl -i -XPOST ‘http://localhost:8086/write?db=ldsDB’ --data-binary ‘@salida.txt’”)

but stored data shows wrong timestamp
[
“1970-01-01T00:25:29.2404Z”,
“SanRoque”,
12.92
],
[
“1970-01-01T00:25:29.2416Z”,
“SanRoque”,
13.92
],
[
“1970-01-01T00:25:29.2428Z”,
“SanRoque”,
14.36
],
[
“1970-01-01T00:25:29.24406Z”,
“SanRoque”,
14.27
]

Any thoughts??
thank you

2

By default InfluxDB treats timestamps as nanoseconds since epoc as per documentation - InfluxDB HTTP API reference | InfluxDB OSS 1.5 Documentation

Nanoseconds will be a 20 digit number, that you are passing is milliseconds since epoc so that appears to be very small number when treated as a nanoseconds. You have two options to fix it:

Option 1: Pass nanoseconds since epoc instead of milliseconds
Option 2: Set precision as milliseconds as per documentation

Cheers!