在使用logstash从mysql数据库同步数据时，发现sql_last_value时间不正确，始终为'1970-01-01 00:00:00'。在后续的同步中，时间逐渐变为'2018-05-08 03:02:04'。问题在于sql查询条件中的时间值。如何解决这个问题并确保sql_last_value能正确反映上次同步的最新时间呢?
The stdin plugin is now waiting for input:
[2018-05-08T11:01:02,589][INFO ][logstash.agent ] Successfully started Logstash API endpoint {:port=>9600}
[2018-05-08T11:02:04,834][INFO ][logstash.inputs.jdbc ] (0.257000s) SELECT version() AS `v` LIMIT 1
[2018-05-08T11:02:04,948][INFO ][logstash.inputs.jdbc ] (0.024000s) select * from std where creattime > '1970-01-01 00:00:00'
2018-05-08T03:02:05.079Z %{host} %{message}
2018-05-08T03:02:05.080Z %{host} %{message}
2018-05-08T03:02:05.088Z %{host} %{message}
2018-05-08T03:02:05.091Z %{host} %{message}
2018-05-08T03:02:05.093Z %{host} %{message}
2018-05-08T03:02:05.021Z %{host} %{message}
2018-05-08T03:02:05.049Z %{host} %{message}
2018-05-08T03:02:05.052Z %{host} %{message}
2018-05-08T03:02:05.055Z %{host} %{message}
2018-05-08T03:02:05.058Z %{host} %{message}
2018-05-08T03:02:05.060Z %{host} %{message}
2018-05-08T03:02:05.062Z %{host} %{message}
2018-05-08T03:02:05.064Z %{host} %{message}
2018-05-08T03:02:05.066Z %{host} %{message}
2018-05-08T03:02:05.069Z %{host} %{message}
[2018-05-08T11:03:00,274][INFO ][logstash.inputs.jdbc ] (0.005000s) select * from std where creattime > '2018-05-08 03:02:04'
[2018-05-08T11:04:00,211][INFO ][logstash.inputs.jdbc ] (0.009000s) select * from std where creattime > '2018-05-08 03:03:00'
'2018-05-08 03:03:00'这个时间不对，请问下这个时间怎么来的啊？select * from std where creattime >:sql_last_value 这是sql语句
扫一扫
195
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
