I’m using influxdb-python API to write to my database. The write fails with a 400 bad request error and the following message:
unable to parse ‘order,book_rank=9,exchange=bitfinex,pair=ETHUSD,type=ask amount=1.04883,id=7981537221i,price=602.88 1517892164461054208’: time outside range -9223372036854775806 - 9223372036854775806"
Clearly this time value (1517892164461054208) falls within range. What else could be the problem?
Thanks in advance,
Wes
I too have the same issue. I’m trying to add influxdb support to an older perl program (Smokeping) and this is the error I get when I try to make the insert:
Nov 06 15:03:40 frost smokeping[24339]: DBG: Error executing write: unable to parse 'FPing,host=172.22.22.51,loss=0,path=/RM/hc2,title=172.22.22.51 median=6.6200000000e-03,ping1=5.8300000000e-03,ping10=6.5900000000e-03,ping11=6.6200000000e-03,ping12=6.7100000000e-03,ping13=6.7100000000e-03,ping14=6.7300000000e-03,ping15=6.7600000000e-03,ping16=7.0400000000e-03,ping17=7.1300000000e-03,ping18=7.1400000000e-03,ping19=7.4300000000e-03,ping2=6.0200000000e-03,ping20=1.6370000000e-02,ping3=6.0600000000e-03,ping4=6.1100000000e-03,ping5=6.1900000000e-03,ping6=6.2200000000e-03,ping7=6.2600000000e-03,ping8=6.3300000000e-03,ping9=6.5900000000e-03,uptime="U" 1573045420072372000': time outside range -9223372036854775806 - 9223372036854775806
I’m using precision ms and my time 1573045420072372000 is between the limits. So - where am I making a mistake?
What should I be looking for?
Ok, found the issue and I’m leaving here a note for posterity.
I had a problem with the perl API I was using (InfluxDB::LineProtocol). I tried to import the module with the precision as a variable (e.g. use InfluxDB::LineProtocol qw(data2line precision=$precision);) and it would default to ns. I hardcoded it to ‘ms’ in the import and in the insert and now it works.
