记一次Logstash踩坑[WARN ][logstash.inputs.jdbc] tracking_column not found in dataset.

最新推荐文章于 2021-09-02 09:54:32 发布

民工来啦

最新推荐文章于 2021-09-02 09:54:32 发布

阅读量3.2k

点赞数

分类专栏： ELK Stack

本文链接：https://blog.csdn.net/hc7736/article/details/87341536

版权

在使用Logstash version 6.5时遇到WARN级别错误，提示[jdbc] tracking_column not found in dataset。问题源于SQL查询语句中未包含用于追踪的字段。解决方法是确保在配置文件的SQL查询中包含指定的追踪列，或者根据实际情况使用重新定义的列名。

摘要由CSDN通过智能技术生成

logstash version 6.5
[2019-01-09T18:04:05,020][WARN ][logstash.inputs.jdbc ] tracking_column not found in dataset. {:tracking_column=>"[ServiceUsage_T].[UsageBegin]"}
{ 2012 rufus-scheduler intercepted an error:
2012 job:
2012 Rufus::Scheduler::CronJob “* * * * *” {}
2012 error:
2012 2012
2012 TypeError
2012 can’t dup NilClass
2012 org/jruby/RubyKernel.java:1882:in dup' 2012 uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/date/format.rb:838:in_parse’
2012 uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/date.rb:1830:in parse' 2012 /usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.13/lib/logstash/plugin_mixins/jdbc/value_tracking.rb:87:inset_value’
2012 /home/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.13/lib/logstash/plugin_mixins/jdbc/jdbc.rb:237:in execute_statement' 2012 /home/logstash/vendor/bundle/jrub