# Logstash InfluxDB bad timestamp error

**URL:** <https://discuss.elastic.co/t/logstash-influxdb-bad-timestamp-error/148516>\
**Category:** Logstash\
**Created:** [September 13, 2018, 9:24pm UTC](https://discuss.elastic.co/t/logstash-influxdb-bad-timestamp-error/148516 "2018-09-13T21:24:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MrSantamaria](https://avatars.discourse-cdn.com/v4/letter/m/2acd7d/32.png) [@MrSantamaria](https://discuss.elastic.co/u/MrSantamaria)\
**Post date:** [September 13, 2018, 9:24pm UTC](https://discuss.elastic.co/t/logstash-influxdb-bad-timestamp-error/148516/1 "2018-09-13T21:24:54Z")

</div>

Hello,

I've almost got the configuration right but I am uncertain what is going on between the conversion of my data. I'm currently trying to turn mysql into influx.  
My input: is a jdbc, select \* from table query outputing to stdout:  
{  
"field1" =\> 2.92,  
"field2" =\> "SomeString",  
"time" =\> 2018-05-09T18:15:25.000Z,  
...  
"field10" =\> "SomeString"  
}

For my influxdb output I have:  
influxdb {  
host =\> "localhost"  
#port =\> 8086  
user =\> "username"  
password =\> "somepassword"  
codec =\> "json"  
db =\> "dbname"  
use\_event\_fields\_for\_data\_points =\> true  
allow\_time\_override =\> true  
exclude\_fields =\> ["@timestamp", "@version", "sequence", "message", "type"]  
data\_points =\> {}  
}

The error I get is:  
jsons'  
Jsons'

[2018-09-13T15:21:28,281][WARN][logstash.outputs.influxdb] Non recoverable exception while writing to InfluxDB {:exception=\>#\<InfluxDB::Error: {"error":"unable to parse 'logstash field1=0.34E0,field2=0.41389E5,field3="somestring",field4="somestring",field5="somestring",field6="somestring",field7=0.3E1 2018-05-09T18:05:28.000Z': bad timestamp"}\>}

I didn't miss write that error. I've noticed that instead of a comma after field7 there is space instead of a comma and field name.  
Any help here would be awesome.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [October 11, 2018, 9:38pm UTC](https://discuss.elastic.co/t/logstash-influxdb-bad-timestamp-error/148516/2 "2018-10-11T21:38:50Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.