Postgresql Class path contains multiple SLF4J bindings.

[jaswinder97]

Getting an error while trying to connect postgresql docker host to logstash container
logstash | 04:33:18.805 [[main]-pipeline-manager] INFO logstash.outputs.jdbc - JDBC - Starting up logstash | SLF4J: Class path contains multiple SLF4J bindings. logstash | SLF4J: Found binding in [jar:file:/usr/share/logstash/vendor/bundle/jruby/1.9/gems/logstash-output-jdbc-5.4.0/lib/org/apache/logging/log4j/log4j-slf4j-impl/2.6.2/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class] logstash | SLF4J: Found binding in [jar:file:/usr/share/logstash/vendor/bundle/jruby/1.9/gems/logstash-output-jdbc-5.4.0/vendor/jar-dependencies/runtime-jars/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class] logstash | SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. logstash | SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] logstash | 04:33:18.861 [[main]-pipeline-manager] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting... logstash | 04:33:19.015 [[main]-pipeline-manager] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed. logstash | 04:33:19.039 [[main]-pipeline-manager] INFO logstash.pipeline - Starting pipeline {"id"=>"main", "pipeline.workers"=>4, "pipeline.batch.size"=>125, "pipeline.batch.delay"=>5, "pipeline.max_inflight"=>500} logstash | 04:33:19.075 [[main]-pipeline-manager] INFO logstash.pipeline - Pipeline main started logstash | 04:33:19.175 [Api Webserver] INFO logstash.agent - Successfully started Logstash API endpoint {:port=>9600} logstash | 04:33:19.227 [[main]-pipeline-manager] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Shutdown initiated... logstash | 04:33:19.273 [[main]-pipeline-manager] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Shutdown completed. logstash | 04:33:22.105 [LogStash::Runner] WARN logstash.agent - stopping pipeline {:id=>"main"}

Environment

• Version of plugin used: logstash-output-jdbc 5.4.0
• Version of Logstash used: logstash:5-alpine
• Database engine & version you're connecting to: postgres docker image
• config with loaded jar version-

`input {
stdin { }
}

filter {
}

output {
jdbc {

    driver_jar_path => '/usr/share/logstash/vendor/jar/jdbc/postgresql-42.2.5.jre7.jar'

	connection_string => 'jdbc:postgresql://db:5432/postgres?user=postgres&password=postgres'
    
    statement => [ "INSERT INTO log (host, timestamp, message) VALUES(?, CAST (? AS timestamp), ?)", "host", "@timestamp", "message" ]
}

}`

[theangryangel]

The double binding isn’t ideal but it shouldn’t shut down the app from my understanding. Put logstash into debug mode to see if you any better errors.

…

Sent from my iPhone

On 13 Mar 2019, at 04:41, Jaswinder Singh ***@***.***> wrote: Getting an error while trying to connect postgresql docker host to logstash container logstash | 04:33:18.805 [[main]-pipeline-manager] INFO logstash.outputs.jdbc - JDBC - Starting up logstash | SLF4J: Class path contains multiple SLF4J bindings. logstash | SLF4J: Found binding in [jar:file:/usr/share/logstash/vendor/bundle/jruby/1.9/gems/logstash-output-jdbc-5.4.0/lib/org/apache/logging/log4j/log4j-slf4j-impl/2.6.2/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class] logstash | SLF4J: Found binding in [jar:file:/usr/share/logstash/vendor/bundle/jruby/1.9/gems/logstash-output-jdbc-5.4.0/vendor/jar-dependencies/runtime-jars/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class] logstash | SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. logstash | SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] logstash | 04:33:18.861 [[main]-pipeline-manager] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting... logstash | 04:33:19.015 [[main]-pipeline-manager] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed. logstash | 04:33:19.039 [[main]-pipeline-manager] INFO logstash.pipeline - Starting pipeline {"id"=>"main", "pipeline.workers"=>4, "pipeline.batch.size"=>125, "pipeline.batch.delay"=>5, "pipeline.max_inflight"=>500} logstash | 04:33:19.075 [[main]-pipeline-manager] INFO logstash.pipeline - Pipeline main started logstash | 04:33:19.175 [Api Webserver] INFO logstash.agent - Successfully started Logstash API endpoint {:port=>9600} logstash | 04:33:19.227 [[main]-pipeline-manager] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Shutdown initiated... logstash | 04:33:19.273 [[main]-pipeline-manager] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Shutdown completed. logstash | 04:33:22.105 [LogStash::Runner] WARN logstash.agent - stopping pipeline {:id=>"main"} Environment Version of plugin used: logstash-output-jdbc 5.4.0 Version of Logstash used: logstash:5-alpine Database engine & version you're connecting to: postgres docker image config with loaded jar version- `input { stdin { } } filter { } output { jdbc { driver_jar_path => '/usr/share/logstash/vendor/jar/jdbc/postgresql-42.2.5.jre7.jar' connection_string => 'jdbc:postgresql://db:5432/postgres?user=postgres&password=postgres' statement => [ "INSERT INTO log (host, timestamp, message) VALUES(?, CAST (? AS timestamp), ?)", "host", ***@***.***", "message" ] } }` — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.