Invalid format: "2019-05-16" is too short

[zxyyxzzxy001 (ashin)]

I use logstash transfer data from mysql to elasticsearch.When logstash output data to elasticsearch,it throw an exception : Invalid format: "2019-05-16" is too short.

the column start_date in mysql data type is date.I have another column named complete_time and it's mysql data type is datetime.I've tried set the date format in template/logstash.json but the problem still happens.

[spinscale (Alexander Reelsen)]

you can add another format like yyyy-MM-dd to the list of formats. You could also just go with strict_date_optional_time||epoch_millis or date_optional_time||epoch_millis in your mapping.

--Alex