Open vintur opened 1 year ago
My workaround for now is to install an older version: bin/logstash-plugin install --version '5.2.4' logstash-integration-jdbc
Getting similar errors but the pipeline does not crash:
[2023-05-05T15:11:31,051][WARN ][logstash.inputs.jdbc ][pipelinename [6faf299d28a81ec8695e11ca859aaf26d751639446c01b99ea916ea01c0c5cc5] Exception when executing JDBC query {:exception=>Sequel::DatabaseConnectionError, :message=>"Java::JavaSql::SQLRecoverableException: IO Error: The Network Adapter could not establish the connection", :cause=>"#<Java::JavaSql::SQLRecoverableException: IO Error: The Network Adapter could not establish the connection>"}
Logstash information:
Please include the following information:
JVM (e.g.
java -version
): openjdk 17.0.6 2023-01-17 OpenJDK Runtime Environment Temurin-17.0.6+10 (build 17.0.6+10) OpenJDK 64-Bit Server VM Temurin-17.0.6+10 (build 17.0.6+10, mixed mode, sharing)OS version (
uname -a
if on a Unix-like system): Linux Servername 3.10.0-1160.88.1.el7.x86_64 #1 SMP Sat Feb 18 13:27:00 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux Red Hat Enterprise Linux Server release 7.9 (Maipo)Description of the problem including expected versus actual behavior: The pipeline with configured jdbc inputs crashes at startup when the configured database server is unreachable for some reason, for example not reachable via DNS or if the datebase is not listening on the configured port.
Expected behavior would be to just ignore the non reachable database and try it again next scheduled run.
Steps to reproduce: Input configuration:
Provide logs (if relevant):
Something similar to this: https://github.com/logstash-plugins/logstash-input-jdbc/issues/144
My thread in discussion: https://discuss.elastic.co/t/logstash-jdbc-input-v5-4-1-crash-pipeline-when-configured-server-is-unreachable-or-if-the-server-is-not-listening-on-db-port/330530