Hi Dears,
logstash showed me a strange behaviour as it suddenly changed its sql_last_value to a previous date, have anyone faced such issue or can give a hint. Below part of logstash log
[2018-12-29T04:48:14,906][INFO ][logstash.inputs.jdbc ] (15.397551s) SELECT PROMO_NAME , EVENT_TIMESTAMP , REQUEST_ID , E , REQUETS_NAME , REQ_TIME , REQUEST_STATUS , DURATION ,
REQUEST_CHANNEL , REQUEST_IN , REQUEST_OUT , LAST_MODIFICATION_TIMESTAMP
FROM CDL_MAIN.SMARTPRC_REQS_VALTRIG_VIEW
WHERE LAST_MODIFICATION_TIMESTAMP > TIMESTAMP '2018-12-28 21:54:34.123000 +02:00'
ORDER BY LAST_MODIFICATION_TIMESTAMP
[2018-12-29T04:48:35,237][INFO ][logstash.inputs.jdbc ] (14.046895s) SELECT PROMO_NAME , EVENT_TIMESTAMP , REQUEST_ID , E , REQUETS_NAME , REQ_TIME , REQUEST_STATUS , DURATION ,
REQUEST_CHANNEL , REQUEST_IN , REQUEST_OUT , LAST_MODIFICATION_TIMESTAMP
FROM CDL_MAIN.SMARTPRC_REQS_VALTRIG_VIEW
WHERE LAST_MODIFICATION_TIMESTAMP > TIMESTAMP '2018-12-28 21:54:34.123000 +02:00'
ORDER BY LAST_MODIFICATION_TIMESTAMP
[2018-12-29T04:49:13,869][INFO ][logstash.inputs.jdbc ] (31.461167s) SELECT PROMO_NAME , EVENT_TIMESTAMP , REQUEST_ID , E , REQUETS_NAME , REQ_TIME , REQUEST_STATUS , DURATION ,
REQUEST_CHANNEL , REQUEST_IN , REQUEST_OUT , LAST_MODIFICATION_TIMESTAMP
FROM CDL_MAIN.SMARTPRC_REQS_VALTRIG_VIEW
WHERE LAST_MODIFICATION_TIMESTAMP > TIMESTAMP '2018-12-28 19:05:29.383000 +02:00'
ORDER BY LAST_MODIFICATION_TIMESTAMP
[2018-12-29T04:53:59,572][INFO ][logstash.inputs.jdbc ] (31.272844s) SELECT PROMO_NAME , EVENT_TIMESTAMP , REQUEST_ID , E , REQUETS_NAME , REQ_TIME , REQUEST_STATUS , DURATION ,
REQUEST_CHANNEL , REQUEST_IN , REQUEST_OUT , LAST_MODIFICATION_TIMESTAMP
FROM CDL_MAIN.SMARTPRC_REQS_VALTRIG_VIEW
WHERE LAST_MODIFICATION_TIMESTAMP > TIMESTAMP '2018-12-28 19:05:29.383000 +02:00'
ORDER BY LAST_MODIFICATION_TIMESTAMP
[2018-12-29T04:58:29,942][INFO ][logstash.inputs.jdbc ] (34.851446s) SELECT PROMO_NAME , EVENT_TIMESTAMP , REQUEST_ID , E , REQUETS_NAME , REQ_TIME , REQUEST_STATUS , DURATION ,
REQUEST_CHANNEL , REQUEST_IN , REQUEST_OUT , LAST_MODIFICATION_TIMESTAMP
FROM CDL_MAIN.SMARTPRC_REQS_VALTRIG_VIEW
WHERE LAST_MODIFICATION_TIMESTAMP > TIMESTAMP '2018-12-28 19:05:29.383000 +02:00'
ORDER BY LAST_MODIFICATION_TIMESTAMP