MapperParsingException failed to parse date format

Elastic Stack Elasticsearch
1

I have exception for pushing mysql data to elasticxsearch. I stored mysql date value to "Current_time_stamp" its look like "2016-06-20 12:25:58"

This is Table Data:

           id  name   mail                ip                timedate                    socketid    reson           active            deactive
           1   Bilal   ABD@gmail.com  192.168.1.5   2016-06-20 12:25:58   /#j9h5AC  cancel  2016-06-20 12:25:58   2016-06-20 12:27:12

Mysql Show only this format "2016-06-20 12:25:58", If elasticsearch get "2016-06-21 12:56:42 +0530"

So i Put Date fomat to:

            "format": "yyyy-MM-dd HH:mm:ss|| yyyy-MM-dd HH:mm +SSSS||yyyy-MM-dd||epoch_millis"

Index Mapping:

        {
    "properties": {
      "active": {
        "type":   "date",
        "format": "yyyy-MM-dd HH:mm:ss|| yyyy-MM-dd HH:mm +SSSS||yyyy-MM-dd||epoch_millis"
        
      },
      "deactive": {
        "type":   "date",
        "format": "yyyy-MM-dd HH:mm:ss|| yyyy-MM-dd HH:mm +SSSS||yyyy-MM-dd||epoch_millis"
       
      },
      "id": {
        "type": "long"
      },
      "ip": {
        "type": "string",
        "index": "not_analyzed"
      },
      "mail": {
        "type": "string",
        "index": "not_analyzed"
      },
      "name": {
        "type": "string",
        "index": "not_analyzed"
      },
      "reason": {
        "type": "string",
        "index": "not_analyzed"
      },
      "socketid": {
        "type": "string",
        "index": "not_analyzed"
      },
      "timedate": {
       "type":   "date",
       "format": "yyyy-MM-dd HH:mm:ss|| yyyy-MM-dd HH:mm +SSSS ||yyyy-MM-dd||epoch_millis"
      }
    }
  }

But Elasticsearch Throw Error:

    [2016-06-21 12:45:54,846][DEBUG][action.bulk              ] [Supremor] [chatmaster][1] failed to execute bulk item (index) index {[chatmaster][chatmastertype][21], source[{"id":21,"name":"Bilal","mail":"bilalusean@gmail.com","ip":"127.0.0.1","timedate":"2016-06-21 12:09:52 +0530","socketid":"/#hjV00hZrEvFUlXeWAAAG","reason":"others","active":"2016-06-21 12:09:52 +0530","deactive":"2016-06-21 12:11:52 +0530"}]}
    MapperParsingException[failed to parse [timedate]]; nested: IllegalArgumentException[Invalid format: "2016-06-21 12:09:52 +0530" is malformed at " +0530"];
      at org.elasticsearch.index.mapper.FieldMapper.parse(FieldMapper.java:329)

Suggest me Which Format use to Push This Mysql Data to Elkasticsearch .

2

IIRC +SSSS does not mean TimeZone.

None of the formats you provided matches the string you are sending.

3

I have solve this problem, while I using this format "yyyy-MM-dd HH:mm:ss Z" refer this link http://www.fileformat.info/tip/java/simpledateformat.htm to check our date pattern.