愚者求师之过,智者从师之长。

加载mysql-connector-java时报错 环境: centos version 4.8.5 mysql 5.6.44 es 和logstash 都是最新版本

Logstash | 作者 EasonJ | 发布于2019年09月05日 | 阅读数:3292

[2019-09-05T18:05:44,881][ERROR][logstash.javapipeline    ] A plugin had an unrecoverable error. Will restart this plugin.

  Pipeline_id:main

  Plugin: <LogStash::Inputs::Jdbc jdbc_user=>"root", jdbc_paging_enabled=>true, jdbc_password=><password>, jdbc_page_size=>10000, statement=>"select * from bookquestion", jdbc_driver_library=>"/usr/local/mysql-connector-java-5.1.48-bin.jar", jdbc_connection_string=>"jdbc:mysql://127.0.0.1:3306/payable?useUnicode=true&characterEncoding=utf8", id=>"c36691ca5be68efa5e03efcfae56d712f7575bfd5f52c8d141a71c240b957d38", jdbc_driver_class=>"com.mysql.jdbc.Driver", enable_metric=>true, codec=><LogStash::Codecs::Plain id=>"plain_117992fe-a1df-4ab6-afd1-96c1733b2b56", enable_metric=>true, charset=>"UTF-8">, jdbc_validate_connection=>false, jdbc_validation_timeout=>3600, jdbc_pool_timeout=>5, sql_log_level=>"info", connection_retry_attempts=>1, connection_retry_attempts_wait_time=>0.5, plugin_timezone=>"utc", parameters=>{"sql_last_value"=>1970-01-01 00:00:00 UTC}, last_run_metadata_path=>"/root/.logstash_jdbc_last_run", use_column_value=>false, tracking_column_type=>"numeric", clean_run=>false, record_last_run=>true, lowercase_column_names=>true>

  Error: com.mysql.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?

  Exception: LogStash::PluginLoadingError

  Stack: /usr/local/logstash/logstash-7.3.1/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.14/lib/logstash/plugin_mixins/jdbc/jdbc.rb:189:in `open_jdbc_connection'

/usr/local/logstash/logstash-7.3.1/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.14/lib/logstash/plugin_mixins/jdbc/jdbc.rb:250:in `execute_statement'

/usr/local/logstash/logstash-7.3.1/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.14/lib/logstash/inputs/jdbc.rb:281:in `execute_query'

/usr/local/logstash/logstash-7.3.1/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.14/lib/logstash/inputs/jdbc.rb:267:in `run'

/usr/local/logstash/logstash-7.3.1/logstash-core/lib/logstash/java_pipeline.rb:309:in `inputworker'

/usr/local/logstash/logstash-7.3.1/logstash-core/lib/logstash/java_pipeline.rb:302:in `block in start_input'

[2019-09-05T18:05:45,251][WARN ][logstash.outputs.elasticsearch] Attempted to resurrect connection to dead ES instance, but got an error. {:url=>"http://127.0.0.1:9200/&quot;, :error_type=>LogStash::Outputs::ElasticSearch::HttpClient::Pool::HostUnreachableError, :error=>"Elasticsearch Unreachable: [http://127.0.0.1:9200/][Manticore::SocketException] Connection refused (Connection refused)"}
已邀请:

NeroCho

赞同来自:

兄弟 我和你遇到一样的问题,我直接放弃官方镜像,使用最新版配合java1.8正常没问题。官方容器里面是Java 11。。。看到这个问题的大佬们是怎么解决的?

要回复问题请先登录注册