# LogStash Wrong Last Run Data Set

**URL:** <https://discuss.elastic.co/t/logstash-wrong-last-run-data-set/162395>\
**Category:** Logstash\
**Created:** [December 29, 2018, 6:10am UTC](https://discuss.elastic.co/t/logstash-wrong-last-run-data-set/162395 "2018-12-29T06:10:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ahmed\_Gamal1](https://avatars.discourse-cdn.com/v4/letter/a/45deac/32.png) [@Ahmed\_Gamal1](https://discuss.elastic.co/u/Ahmed_Gamal1)\
**Post date:** [December 29, 2018, 6:10am UTC](https://discuss.elastic.co/t/logstash-wrong-last-run-data-set/162395/1 "2018-12-29T06:10:33Z")

</div>

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

---

<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:** [January 26, 2019, 6:10am UTC](https://discuss.elastic.co/t/logstash-wrong-last-run-data-set/162395/2 "2019-01-26T06:10:33Z")

</div>

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