Closed limrik closed 3 months ago
The provided host name is unknown:
java.net.UnknownHostException: your_postgres_host
Apologies for my oversight, have replaced it with localhost. I have also checked that my port 5432 is listening, so not sure why I am still getting the following logs:
logstash-1 | /usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/concurrent-ruby-1.1.9/lib/concurrent-ruby/concurrent/executor/java_thread_pool_executor.rb:13: warning: method redefined; discarding old to_int
logstash-1 | /usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/concurrent-ruby-1.1.9/lib/concurrent-ruby/concurrent/executor/java_thread_pool_executor.rb:13: warning: method redefined; discarding old to_f
logstash-1 | Sending Logstash logs to /usr/share/logstash/logs which is now configured via log4j2.properties
logstash-1 | [2024-05-31T06:52:06,803][INFO ][logstash.runner ] Log4j configuration path used is: /usr/share/logstash/config/log4j2.properties
logstash-1 | [2024-05-31T06:52:06,809][INFO ][logstash.runner ] Starting Logstash {"logstash.version"=>"8.13.4", "jruby.version"=>"jruby 9.4.5.0 (3.1.4) 2023-11-02 1abae2700f OpenJDK 64-Bit Server VM 17.0.11+9 on 17.0.11+9 +indy +jit [x86_64-linux]"}
logstash-1 | [2024-05-31T06:52:06,812][INFO ][logstash.runner ] JVM bootstrap flags: [-Xms1g, -Xmx1g, -Djava.awt.headless=true, -Dfile.encoding=UTF-8, -Djruby.compile.invokedynamic=true, -XX:+HeapDumpOnOutOfMemoryError, -Djava.security.egd=file:/dev/urandom, -Dlog4j2.isThreadContextMapInheritable=true, -Dlogstash.jackson.stream-read-constraints.max-string-length=200000000, -Dlogstash.jackson.stream-read-constraints.max-number-length=10000, -Dls.cgroup.cpuacct.path.override=/, -Dls.cgroup.cpu.path.override=/, -Xms256m, -Xmx256m, -Djruby.regexp.interruptible=true, -Djdk.io.File.enableADS=true, --add-exports=jdk.compiler/com.sun.tools.javac.api=ALL-UNNAMED, --add-exports=jdk.compiler/com.sun.tools.javac.file=ALL-UNNAMED, --add-exports=jdk.compiler/com.sun.tools.javac.parser=ALL-UNNAMED, --add-exports=jdk.compiler/com.sun.tools.javac.tree=ALL-UNNAMED, --add-exports=jdk.compiler/com.sun.tools.javac.util=ALL-UNNAMED, --add-opens=java.base/java.security=ALL-UNNAMED, --add-opens=java.base/java.io=ALL-UNNAMED, --add-opens=java.base/java.nio.channels=ALL-UNNAMED, --add-opens=java.base/sun.nio.ch=ALL-UNNAMED, --add-opens=java.management/sun.management=ALL-UNNAMED, -Dio.netty.allocator.maxOrder=11]
logstash-1 | [2024-05-31T06:52:06,814][INFO ][logstash.runner ] Jackson default value override `logstash.jackson.stream-read-constraints.max-string-length` configured to `200000000`
logstash-1 | [2024-05-31T06:52:06,815][INFO ][logstash.runner ] Jackson default value override `logstash.jackson.stream-read-constraints.max-number-length` configured to `10000`
logstash-1 | [2024-05-31T06:52:07,606][INFO ][logstash.agent ] Successfully started Logstash API endpoint {:port=>9600, :ssl_enabled=>false}
logstash-1 | [2024-05-31T06:52:08,115][INFO ][org.reflections.Reflections] Reflections took 115 ms to scan 1 urls, producing 132 keys and 468 values
logstash-1 | [2024-05-31T06:52:10,501][INFO ][logstash.codecs.jsonlines] ECS compatibility is enabled but `target` option was not specified. This may cause fields to be set at the top-level of the event where they are likely to clash with the Elastic Common Schema. It is recommended to set the `target` option to avoid potential schema conflicts (if your data is ECS compliant or non-conflicting, feel free to ignore this message)
logstash-1 | [2024-05-31T06:52:10,522][INFO ][logstash.javapipeline ] Pipeline `main` is configured with `pipeline.ecs_compatibility: v8` setting. All plugins in this pipeline will default to `ecs_compatibility => v8` unless explicitly configured otherwise.
logstash-1 | [2024-05-31T06:52:10,544][INFO ][logstash.outputs.elasticsearch][main] New Elasticsearch output {:class=>"LogStash::Outputs::ElasticSearch", :hosts=>["http://elasticsearch:9200"]}
logstash-1 | [2024-05-31T06:52:10,680][INFO ][logstash.outputs.elasticsearch][main] Elasticsearch pool URLs updated {:changes=>{:removed=>[], :added=>[http://elastic:xxxxxx@elasticsearch:9200/]}}
logstash-1 | [2024-05-31T06:52:10,776][WARN ][logstash.outputs.elasticsearch][main] Restored connection to ES instance {:url=>"http://elastic:xxxxxx@elasticsearch:9200/"}
logstash-1 | [2024-05-31T06:52:10,777][INFO ][logstash.outputs.elasticsearch][main] Elasticsearch version determined (8.13.4) {:es_version=>8}
logstash-1 | [2024-05-31T06:52:10,778][WARN ][logstash.outputs.elasticsearch][main] Detected a 6.x and above cluster: the `type` event field won't be used to determine the document _type {:es_version=>8}
logstash-1 | [2024-05-31T06:52:10,787][INFO ][logstash.outputs.elasticsearch][main] Not eligible for data streams because config contains one or more settings that are not compatible with data streams: {"index"=>"contacts"}
logstash-1 | [2024-05-31T06:52:10,787][INFO ][logstash.outputs.elasticsearch][main] Data streams auto configuration (`data_stream => auto` or unset) resolved to `false`
logstash-1 | [2024-05-31T06:52:10,801][INFO ][logstash.outputs.elasticsearch][main] Using a default mapping template {:es_version=>8, :ecs_compatibility=>:v8}
logstash-1 | [2024-05-31T06:52:10,802][INFO ][logstash.javapipeline ][main] Starting pipeline {:pipeline_id=>"main", "pipeline.workers"=>12, "pipeline.batch.size"=>125, "pipeline.batch.delay"=>50, "pipeline.max_inflight"=>1500, "pipeline.sources"=>["/usr/share/logstash/pipeline/logstash.conf"], :thread=>"#<Thread:0x6857fcf0 /usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:134 run>"}
logstash-1 | [2024-05-31T06:52:11,534][INFO ][logstash.javapipeline ][main] Pipeline Java execution initialization time {"seconds"=>0.73}
logstash-1 | [2024-05-31T06:52:12,022][ERROR][logstash.inputs.jdbc ][main]
logstash-1 | org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
logstash-1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(org/postgresql/core/v3/ConnectionFactoryImpl.java:346) ~[postgresql-42.7.3.jar:42.7.3]
logstash-1 | at org.postgresql.core.ConnectionFactory.openConnection(org/postgresql/core/ConnectionFactory.java:54) ~[postgresql-42.7.3.jar:42.7.3]
logstash-1 | at org.postgresql.jdbc.PgConnection.<init>(org/postgresql/jdbc/PgConnection.java:273) ~[postgresql-42.7.3.jar:42.7.3]
logstash-1 | at org.postgresql.Driver.makeConnection(org/postgresql/Driver.java:446) ~[postgresql-42.7.3.jar:42.7.3]
logstash-1 | at org.postgresql.Driver.connect(org/postgresql/Driver.java:298) ~[postgresql-42.7.3.jar:42.7.3]
logstash-1 | at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
logstash-1 | at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(jdk/internal/reflect/NativeMethodAccessorImpl.java:77) ~[?:?]
logstash-1 | at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(jdk/internal/reflect/DelegatingMethodAccessorImpl.java:43) ~[?:?]
logstash-1 | at java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:568) ~[?:?]
logstash-1 | at org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:330) ~[jruby.jar:?]
logstash-1 | at org.jruby.javasupport.JavaMethod.invokeDirect(org/jruby/javasupport/JavaMethod.java:188) ~[jruby.jar:?]
logstash-1 | at RUBY.connect(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/adapters/jdbc.rb:237) ~[?:?]
logstash-1 | at RUBY.new_connection(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/database/connecting.rb:248) ~[?:?]
logstash-1 | at RUBY.make_new(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/connection_pool.rb:163) ~[?:?]
logstash-1 | at RUBY.assign_connection(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/connection_pool/threaded.rb:209) ~[?:?]
logstash-1 | at RUBY.acquire(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/connection_pool/threaded.rb:139) ~[?:?]
logstash-1 | at RUBY.hold(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/connection_pool/threaded.rb:91) ~[?:?]
logstash-1 | at RUBY.synchronize(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/database/connecting.rb:293) ~[?:?]
logstash-1 | at RUBY.test_connection(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/database/connecting.rb:302) ~[?:?]
logstash-1 | at RUBY.initialize(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/database/misc.rb:189) ~[?:?]
logstash-1 | at org.jruby.RubyClass.new(org/jruby/RubyClass.java:904) ~[jruby.jar:?]
logstash-1 | at org.jruby.RubyClass$INVOKER$i$newInstance.call(org/jruby/RubyClass$INVOKER$i$newInstance.gen) ~[jruby.jar:?]
logstash-1 | at RUBY.connect(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/database/connecting.rb:57) ~[?:?]
logstash-1 | at RUBY.connect(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/core.rb:124) ~[?:?]
logstash-1 | at RUBY.jdbc_connect(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-integration-jdbc-5.4.9/lib/logstash/plugin_mixins/jdbc/jdbc.rb:123) ~[?:?]
logstash-1 | at org.jruby.RubyKernel.loop(org/jruby/RubyKernel.java:1603) ~[jruby.jar:?]
logstash-1 | at org.jruby.RubyKernel$INVOKER$s$0$0$loop.call(org/jruby/RubyKernel$INVOKER$s$0$0$loop.gen) ~[jruby.jar:?]
logstash-1 | at RUBY.jdbc_connect(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-integration-jdbc-5.4.9/lib/logstash/plugin_mixins/jdbc/jdbc.rb:120) ~[?:?]
logstash-1 | at RUBY.open_jdbc_connection(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-integration-jdbc-5.4.9/lib/logstash/plugin_mixins/jdbc/jdbc.rb:163) ~[?:?]
logstash-1 | at RUBY.register(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-integration-jdbc-5.4.9/lib/logstash/inputs/jdbc.rb:309) ~[?:?]
logstash-1 | at RUBY.register(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-mixin-ecs_compatibility_support-1.3.0-java/lib/logstash/plugin_mixins/ecs_compatibility_support/target_check.rb:48) ~[?:?]
logstash-1 | at RUBY.register_plugins(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:237) ~[?:?]
logstash-1 | at org.jruby.RubyArray.each(org/jruby/RubyArray.java:1989) ~[jruby.jar:?]
logstash-1 | at org.jruby.RubyArray$INVOKER$i$0$0$each.call(org/jruby/RubyArray$INVOKER$i$0$0$each.gen) ~[jruby.jar:?]
logstash-1 | at RUBY.register_plugins(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:236) ~[?:?]
logstash-1 | at RUBY.start_inputs(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:395) ~[?:?]
logstash-1 | at RUBY.start_workers(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:320) ~[?:?]
logstash-1 | at RUBY.run(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:194) ~[?:?]
logstash-1 | at RUBY.start(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:146) ~[?:?]
logstash-1 | at org.jruby.RubyProc.call(org/jruby/RubyProc.java:352) ~[jruby.jar:?]
logstash-1 | at java.lang.Thread.run(java/lang/Thread.java:840) [?:?]
logstash-1 | Caused by: java.net.ConnectException: Connection refused
logstash-1 | at sun.nio.ch.Net.pollConnect(Native Method) ~[?:?]
logstash-1 | at sun.nio.ch.Net.pollConnectNow(Net.java:672) ~[?:?]
logstash-1 | at sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:547) ~[?:?]
logstash-1 | at sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:602) ~[?:?]
logstash-1 | at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327) ~[?:?]
logstash-1 | at java.net.Socket.connect(Socket.java:633) ~[?:?]
logstash-1 | at org.postgresql.core.PGStream.createSocket(PGStream.java:243) ~[postgresql-42.7.3.jar:42.7.3]
logstash-1 | at org.postgresql.core.PGStream.<init>(PGStream.java:98) ~[postgresql-42.7.3.jar:42.7.3]
logstash-1 | at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:136) ~[postgresql-42.7.3.jar:42.7.3]
logstash-1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262) ~[postgresql-42.7.3.jar:42.7.3]
logstash-1 | at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) ~[postgresql-42.7.3.jar:42.7.3]
logstash-1 | at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:273) ~[postgresql-42.7.3.jar:42.7.3]
logstash-1 | at org.postgresql.Driver.makeConnection(Driver.java:446) ~[postgresql-42.7.3.jar:42.7.3]
logstash-1 | at org.postgresql.Driver.connect(Driver.java:298) ~[postgresql-42.7.3.jar:42.7.3]
logstash-1 | at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
logstash-1 | at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
logstash-1 | at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
logstash-1 | at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
logstash-1 | at org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(JavaMethod.java:330) ~[jruby.jar:?]
logstash-1 | at org.jruby.javasupport.JavaMethod.invokeDirect(JavaMethod.java:188) ~[jruby.jar:?]
logstash-1 | at org.jruby.java.invokers.InstanceMethodInvoker.call(InstanceMethodInvoker.java:53) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:476) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:293) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:328) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:82) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:201) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:188) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:220) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:466) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:244) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:318) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:82) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:201) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:188) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:220) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:466) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:244) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:318) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:82) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:201) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:188) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:220) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:466) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:244) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:318) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:82) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:201) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:188) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:220) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:466) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:244) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:318) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:82) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:201) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:188) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:220) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:466) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:244) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:318) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:82) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:201) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:188) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:471) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:259) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:342) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:82) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:201) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:188) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:471) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:259) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.callIter(CachingCallSite.java:270) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:341) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:76) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:164) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:151) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:212) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:456) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:195) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:350) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:82) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:201) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:188) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:471) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:259) ~[jruby.jar:?]
logstash-1 | at org.jruby.RubyClass.newInstance(RubyClass.java:904) ~[jruby.jar:?]
logstash-1 | at org.jruby.RubyClass$INVOKER$i$newInstance.call(RubyClass$INVOKER$i$newInstance.gen) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.JavaMethod$JavaMethodZeroOrOneOrNBlock.call(JavaMethod.java:355) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:466) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:244) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:318) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:128) ~[jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:115) ~[jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:446) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:92) [jruby.jar:?]
logstash-1 | at org.jruby.ir.instructions.CallBase.interpret(CallBase.java:548) ~[jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:367) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:88) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:238) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:225) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:228) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:476) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:293) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:328) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.Interpreter.INTERPRET_BLOCK(Interpreter.java:116) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.MixedModeIRBlockBody.commonYieldPath(MixedModeIRBlockBody.java:136) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.IRBlockBody.yieldSpecific(IRBlockBody.java:76) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.Block.yieldSpecific(Block.java:158) [jruby.jar:?]
logstash-1 | at org.jruby.RubyKernel.loop(RubyKernel.java:1603) [jruby.jar:?]
logstash-1 | at org.jruby.RubyKernel$INVOKER$s$0$0$loop.call(RubyKernel$INVOKER$s$0$0$loop.gen) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.JavaMethod$JavaMethodZeroBlock.call(JavaMethod.java:561) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:446) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:92) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.callIter(CachingCallSite.java:103) [jruby.jar:?]
logstash-1 | at org.jruby.ir.instructions.CallBase.interpret(CallBase.java:545) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:367) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:76) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:164) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:151) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:212) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:456) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:195) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:350) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:76) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:164) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:151) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:212) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:456) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:195) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:350) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:128) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:115) [jruby.jar:?]
logstash-1 | at org.jruby.ir.runtime.IRRuntimeHelpers.unresolvedSuper(IRRuntimeHelpers.java:1428) [jruby.jar:?]
logstash-1 | at org.jruby.ir.instructions.UnresolvedSuperInstr.interpret(UnresolvedSuperInstr.java:123) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:367) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:76) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:164) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:151) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:212) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:456) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:195) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:350) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.Interpreter.INTERPRET_BLOCK(Interpreter.java:116) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.MixedModeIRBlockBody.commonYieldPath(MixedModeIRBlockBody.java:136) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.IRBlockBody.doYield(IRBlockBody.java:170) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.BlockBody.yield(BlockBody.java:108) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.Block.yield(Block.java:189) [jruby.jar:?]
logstash-1 | at org.jruby.RubyArray.each(RubyArray.java:1989) [jruby.jar:?]
logstash-1 | at org.jruby.RubyArray$INVOKER$i$0$0$each.call(RubyArray$INVOKER$i$0$0$each.gen) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.JavaMethod$JavaMethodZeroBlock.call(JavaMethod.java:561) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:90) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.callIter(CachingCallSite.java:103) [jruby.jar:?]
logstash-1 | at org.jruby.ir.instructions.CallBase.interpret(CallBase.java:545) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:367) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:82) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:201) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:188) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:220) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:466) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:244) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:318) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:76) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:164) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:151) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:212) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:456) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:195) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:350) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:76) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:164) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:151) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:212) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:456) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:195) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:350) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:76) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:164) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:151) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:212) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:456) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:195) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:350) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:66) [jruby.jar:?]
logstash-1 | at org.jruby.ir.interpreter.Interpreter.INTERPRET_BLOCK(Interpreter.java:116) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.MixedModeIRBlockBody.commonYieldPath(MixedModeIRBlockBody.java:136) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.IRBlockBody.call(IRBlockBody.java:66) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.IRBlockBody.call(IRBlockBody.java:58) [jruby.jar:?]
logstash-1 | at org.jruby.runtime.Block.call(Block.java:144) [jruby.jar:?]
logstash-1 | at org.jruby.RubyProc.call(RubyProc.java:352) [jruby.jar:?]
logstash-1 | at org.jruby.internal.runtime.RubyRunnable.run(RubyRunnable.java:111) [jruby.jar:?]
logstash-1 | at java.lang.Thread.run(Thread.java:840) ~[?:?]
logstash-1 | [2024-05-31T06:52:12,028][ERROR][logstash.inputs.jdbc ][main] Unable to connect to database. Tried 1 times {:message=>"Java::OrgPostgresqlUtil::PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.", :exception=>Sequel::DatabaseConnectionError, :cause=>#<Java::OrgPostgresqlUtil::PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.>, :backtrace=>["org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(org/postgresql/core/v3/ConnectionFactoryImpl.java:346)", "org.postgresql.core.ConnectionFactory.openConnection(org/postgresql/core/ConnectionFactory.java:54)", "org.postgresql.jdbc.PgConnection.<init>(org/postgresql/jdbc/PgConnection.java:273)", "org.postgresql.Driver.makeConnection(org/postgresql/Driver.java:446)", "org.postgresql.Driver.connect(org/postgresql/Driver.java:298)", "jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)", "jdk.internal.reflect.NativeMethodAccessorImpl.invoke(jdk/internal/reflect/NativeMethodAccessorImpl.java:77)", "jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(jdk/internal/reflect/DelegatingMethodAccessorImpl.java:43)", "java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:568)", "org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:330)", "org.jruby.javasupport.JavaMethod.invokeDirect(org/jruby/javasupport/JavaMethod.java:188)", "RUBY.connect(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/adapters/jdbc.rb:237)", "RUBY.new_connection(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/database/connecting.rb:248)", "RUBY.make_new(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/connection_pool.rb:163)", "RUBY.assign_connection(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/connection_pool/threaded.rb:209)", "RUBY.acquire(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/connection_pool/threaded.rb:139)", "RUBY.hold(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/connection_pool/threaded.rb:91)", "RUBY.synchronize(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/database/connecting.rb:293)", "RUBY.test_connection(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/database/connecting.rb:302)", "RUBY.initialize(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/database/misc.rb:189)", "org.jruby.RubyClass.new(org/jruby/RubyClass.java:904)", "org.jruby.RubyClass$INVOKER$i$newInstance.call(org/jruby/RubyClass$INVOKER$i$newInstance.gen)", "RUBY.connect(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/database/connecting.rb:57)", "RUBY.connect(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/sequel-5.78.0/lib/sequel/core.rb:124)", "RUBY.jdbc_connect(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-integration-jdbc-5.4.9/lib/logstash/plugin_mixins/jdbc/jdbc.rb:123)", "org.jruby.RubyKernel.loop(org/jruby/RubyKernel.java:1603)", "org.jruby.RubyKernel$INVOKER$s$0$0$loop.call(org/jruby/RubyKernel$INVOKER$s$0$0$loop.gen)", "RUBY.jdbc_connect(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-integration-jdbc-5.4.9/lib/logstash/plugin_mixins/jdbc/jdbc.rb:120)", "RUBY.open_jdbc_connection(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-integration-jdbc-5.4.9/lib/logstash/plugin_mixins/jdbc/jdbc.rb:163)", "RUBY.register(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-integration-jdbc-5.4.9/lib/logstash/inputs/jdbc.rb:309)", "RUBY.register(/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-mixin-ecs_compatibility_support-1.3.0-java/lib/logstash/plugin_mixins/ecs_compatibility_support/target_check.rb:48)", "RUBY.register_plugins(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:237)", "org.jruby.RubyArray.each(org/jruby/RubyArray.java:1989)", "org.jruby.RubyArray$INVOKER$i$0$0$each.call(org/jruby/RubyArray$INVOKER$i$0$0$each.gen)", "RUBY.register_plugins(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:236)", "RUBY.start_inputs(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:395)", "RUBY.start_workers(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:320)", "RUBY.run(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:194)", "RUBY.start(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:146)", "org.jruby.RubyProc.call(org/jruby/RubyProc.java:352)", "java.lang.Thread.run(java/lang/Thread.java:840)"]}
logstash-1 | [2024-05-31T06:52:12,030][WARN ][logstash.inputs.jdbc ][main] Exception when executing JDBC query {:exception=>Sequel::DatabaseConnectionError, :message=>"Java::OrgPostgresqlUtil::PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.", :cause=>"#<Java::OrgPostgresqlUtil::PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.>"}
logstash-1 | [2024-05-31T06:52:12,792][ERROR][logstash.javapipeline ][main] Pipeline error {:pipeline_id=>"main", :exception=>#<LogStash::ConfigurationError: Can't create a connection pool to the database>, :backtrace=>["/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-integration-jdbc-5.4.9/lib/logstash/inputs/jdbc.rb:318:in `register'", "/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-mixin-ecs_compatibility_support-1.3.0-java/lib/logstash/plugin_mixins/ecs_compatibility_support/target_check.rb:48:in `register'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:237:in `block in register_plugins'", "org/jruby/RubyArray.java:1989:in `each'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:236:in `register_plugins'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:395:in `start_inputs'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:320:in `start_workers'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:194:in `run'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:146:in `block in start'"], "pipeline.sources"=>["/usr/share/logstash/pipeline/logstash.conf"], :thread=>"#<Thread:0x6857fcf0 /usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:134 run>"}
logstash-1 | [2024-05-31T06:52:12,793][INFO ][logstash.javapipeline ][main] Pipeline terminated {"pipeline.id"=>"main"}
logstash-1 | [2024-05-31T06:52:12,803][ERROR][logstash.agent ] Failed to execute action {:id=>:main, :action_type=>LogStash::ConvergeResult::FailedAction, :message=>"Could not execute action: PipelineAction::Create<main>, action_result: false", :backtrace=>nil}
logstash-1 | [2024-05-31T06:52:12,813][INFO ][logstash.runner ] Logstash shut down.
logstash-1 | [2024-05-31T06:52:12,817][FATAL][org.logstash.Logstash ] Logstash stopped processing because of an error: (SystemExit) exit
logstash-1 | org.jruby.exceptions.SystemExit: (SystemExit) exit
logstash-1 | at org.jruby.RubyKernel.exit(org/jruby/RubyKernel.java:808) ~[jruby.jar:?]
logstash-1 | at org.jruby.RubyKernel.exit(org/jruby/RubyKernel.java:767) ~[jruby.jar:?]
logstash-1 | at usr.share.logstash.lib.bootstrap.environment.<main>(/usr/share/logstash/lib/bootstrap/environment.rb:90) ~[?:?]
logstash-1 exited with code 0
Does this help? https://stackoverflow.com/a/24326540/4716370 See the case about the "bridge" mode.
Unfortunately I am not quite sure what is the solution, have tried changing the host to jdbc:postgresql://host.docker.internal:5432/test
but still same error.
I feel like it has something to do with the connections my Postgresql server is accepting, will try changing that to allow all addresses. (edit: seems like this was not the issue, already listening for all addresses)
It would help to know a little bit about your setup. Is Postgresql running in the host's network or is it running as a container?
host.docker.internal
is only valid in the Docker for Desktop virtual machine. On a Linux machine, this hostname will most likely not exist.
@antoineco Postgresql is running in the host's network in my case
I'm going to need the full information requested in the issue template (the one you deleted when you created the issue) to be able to help you.
I realised that I missed out the setup section of the READ.ME, however after setting up I am still unable to connect logstash to elasticsearch (note that here I have freshly re-cloned the repo and not edited any files except change the passwords to those generated from the commands as per the setup section)
2024-06-03 10:57:54 kibana-1 | Kibana is currently running with legacy OpenSSL providers enabled! For details and instructions on how to disable see https://www.elastic.co/guide/en/kibana/8.13/production.html#openssl-legacy-provider
2024-06-03 10:57:52 logstash-1 | Using bundled JDK: /usr/share/logstash/jdk
2024-06-03 10:57:53 elasticsearch-1 | Created elasticsearch keystore in /usr/share/elasticsearch/config/elasticsearch.keystore
2024-06-03 10:58:05 elasticsearch-1 | Jun 03, 2024 2:58:05 AM sun.util.locale.provider.LocaleProviderAdapter <clinit>
2024-06-03 10:57:56 kibana-1 | {"log.level":"info","@timestamp":"2024-06-03T02:57:56.168Z","log.logger":"elastic-apm-node","ecs.version":"8.10.0","agentVersion":"4.4.0","env":{"pid":7,"proctitle":"/usr/share/kibana/bin/../node/bin/node","os":"linux 5.15.146.1-microsoft-standard-WSL2","arch":"x64","host":"fc98e8147da6","timezone":"UTC+00","runtime":"Node.js v20.12.2"},"config":{"active":{"source":"start","value":true},"breakdownMetrics":{"source":"start","value":false},"captureBody":{"source":"start","value":"off","commonName":"capture_body"},"captureHeaders":{"source":"start","value":false},"centralConfig":{"source":"start","value":false},"contextPropagationOnly":{"source":"start","value":true},"environment":{"source":"start","value":"production"},"globalLabels":{"source":"start","value":[["git_rev","f5dc24d1969f80e4aa3ced7cc375dd00554f8c0c"]],"sourceValue":{"git_rev":"f5dc24d1969f80e4aa3ced7cc375dd00554f8c0c"}},"logLevel":{"source":"default","value":"info","commonName":"log_level"},"metricsInterval":{"source":"start","value":120,"sourceValue":"120s"},"serverUrl":{"source":"start","value":"https://kibana-cloud-apm.apm.us-east-1.aws.found.io/","commonName":"server_url"},"transactionSampleRate":{"source":"start","value":0.1,"commonName":"transaction_sample_rate"},"captureSpanStackTraces":{"source":"start","sourceValue":false},"secretToken":{"source":"start","value":"[REDACTED]","commonName":"secret_token"},"serviceName":{"source":"start","value":"kibana","commonName":"service_name"},"serviceVersion":{"source":"start","value":"8.13.4","commonName":"service_version"}},"activationMethod":"require","message":"Elastic APM Node.js Agent v4.4.0"}
2024-06-03 10:57:56 kibana-1 | Native global console methods have been overridden in production environment.
2024-06-03 10:57:59 kibana-1 | [2024-06-03T02:57:59.708+00:00][INFO ][root] Kibana is starting
2024-06-03 10:57:59 kibana-1 | [2024-06-03T02:57:59.967+00:00][INFO ][node] Kibana process configured with roles: [background_tasks, ui]
2024-06-03 10:58:11 logstash-1 | /usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/concurrent-ruby-1.1.9/lib/concurrent-ruby/concurrent/executor/java_thread_pool_executor.rb:13: warning: method redefined; discarding old to_int
2024-06-03 10:58:05 elasticsearch-1 | WARNING: COMPAT locale provider will be removed in a future release
2024-06-03 10:58:06 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:06.445Z", "log.level": "INFO", "message":"Using [jdk] native provider and native methods for [Linux]", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.elasticsearch.nativeaccess.NativeAccess","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:07 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:07.355Z", "log.level": "INFO", "message":"Java vector incubator API enabled; uses preferredBitSize=256; FMA enabled", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.apache.lucene.internal.vectorization.PanamaVectorizationProvider","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:08 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:08.820Z", "log.level": "INFO", "message":"version[8.13.4], pid[178], build[docker/da95df118650b55a500dcc181889ac35c6d8da7c/2024-05-06T22:04:45.107454559Z], OS[Linux/5.15.146.1-microsoft-standard-WSL2/amd64], JVM[Oracle Corporation/OpenJDK 64-Bit Server VM/21.0.2/21.0.2+13-58]", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.elasticsearch.node.Node","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:08 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:08.822Z", "log.level": "INFO", "message":"JVM home [/usr/share/elasticsearch/jdk], using bundled JDK [true]", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.elasticsearch.node.Node","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:08 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:08.823Z", "log.level": "INFO", "message":"JVM arguments [-Des.networkaddress.cache.ttl=60, -Des.networkaddress.cache.negative.ttl=10, -Djava.security.manager=allow, -XX:+AlwaysPreTouch, -Xss1m, -Djava.awt.headless=true, -Dfile.encoding=UTF-8, -Djna.nosys=true, -XX:-OmitStackTraceInFastThrow, -Dio.netty.noUnsafe=true, -Dio.netty.noKeySetOptimization=true, -Dio.netty.recycler.maxCapacityPerThread=0, -Dlog4j.shutdownHookEnabled=false, -Dlog4j2.disable.jmx=true, -Dlog4j2.formatMsgNoLookups=true, -Djava.locale.providers=SPI,COMPAT, --add-opens=java.base/java.io=org.elasticsearch.preallocate, --enable-native-access=org.elasticsearch.nativeaccess, -Des.cgroups.hierarchy.override=/, -XX:ReplayDataFile=logs/replay_pid%p.log, -Des.distribution.type=docker, -XX:+UseG1GC, -Djava.io.tmpdir=/tmp/elasticsearch-2970068686501001818, --add-modules=jdk.incubator.vector, -XX:+HeapDumpOnOutOfMemoryError, -XX:+ExitOnOutOfMemoryError, -XX:HeapDumpPath=data, -XX:ErrorFile=logs/hs_err_pid%p.log, -Xlog:gc*,gc+age=trace,safepoint:file=logs/gc.log:utctime,level,pid,tags:filecount=32,filesize=64m, -Xms512m, -Xmx512m, -XX:MaxDirectMemorySize=268435456, -XX:G1HeapRegionSize=4m, -XX:InitiatingHeapOccupancyPercent=30, -XX:G1ReservePercent=15, --module-path=/usr/share/elasticsearch/lib, --add-modules=jdk.net, --add-modules=ALL-MODULE-PATH, -Djdk.module.main=org.elasticsearch.server]", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.elasticsearch.node.Node","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:08 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:08.824Z", "log.level": "INFO", "message":"Default Locale [en_US]", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.elasticsearch.node.Node","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:11 logstash-1 | /usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/concurrent-ruby-1.1.9/lib/concurrent-ruby/concurrent/executor/java_thread_pool_executor.rb:13: warning: method redefined; discarding old to_f
2024-06-03 10:58:24 logstash-1 | Sending Logstash logs to /usr/share/logstash/logs which is now configured via log4j2.properties
2024-06-03 10:58:25 logstash-1 | [2024-06-03T02:58:25,241][INFO ][logstash.runner ] Log4j configuration path used is: /usr/share/logstash/config/log4j2.properties
2024-06-03 10:58:25 logstash-1 | [2024-06-03T02:58:25,253][INFO ][logstash.runner ] Starting Logstash {"logstash.version"=>"8.13.4", "jruby.version"=>"jruby 9.4.5.0 (3.1.4) 2023-11-02 1abae2700f OpenJDK 64-Bit Server VM 17.0.11+9 on 17.0.11+9 +indy +jit [x86_64-linux]"}
2024-06-03 10:58:25 logstash-1 | [2024-06-03T02:58:25,257][INFO ][logstash.runner ] JVM bootstrap flags: [-Xms1g, -Xmx1g, -Djava.awt.headless=true, -Dfile.encoding=UTF-8, -Djruby.compile.invokedynamic=true, -XX:+HeapDumpOnOutOfMemoryError, -Djava.security.egd=file:/dev/urandom, -Dlog4j2.isThreadContextMapInheritable=true, -Dlogstash.jackson.stream-read-constraints.max-string-length=200000000, -Dlogstash.jackson.stream-read-constraints.max-number-length=10000, -Dls.cgroup.cpuacct.path.override=/, -Dls.cgroup.cpu.path.override=/, -Xms256m, -Xmx256m, -Djruby.regexp.interruptible=true, -Djdk.io.File.enableADS=true, --add-exports=jdk.compiler/com.sun.tools.javac.api=ALL-UNNAMED, --add-exports=jdk.compiler/com.sun.tools.javac.file=ALL-UNNAMED, --add-exports=jdk.compiler/com.sun.tools.javac.parser=ALL-UNNAMED, --add-exports=jdk.compiler/com.sun.tools.javac.tree=ALL-UNNAMED, --add-exports=jdk.compiler/com.sun.tools.javac.util=ALL-UNNAMED, --add-opens=java.base/java.security=ALL-UNNAMED, --add-opens=java.base/java.io=ALL-UNNAMED, --add-opens=java.base/java.nio.channels=ALL-UNNAMED, --add-opens=java.base/sun.nio.ch=ALL-UNNAMED, --add-opens=java.management/sun.management=ALL-UNNAMED, -Dio.netty.allocator.maxOrder=11]
2024-06-03 10:58:25 logstash-1 | [2024-06-03T02:58:25,260][INFO ][logstash.runner ] Jackson default value override `logstash.jackson.stream-read-constraints.max-string-length` configured to `200000000`
2024-06-03 10:58:25 logstash-1 | [2024-06-03T02:58:25,260][INFO ][logstash.runner ] Jackson default value override `logstash.jackson.stream-read-constraints.max-number-length` configured to `10000`
2024-06-03 10:58:20 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:20.211Z", "log.level": "INFO", "message":"loaded module [repository-url]", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.elasticsearch.plugins.PluginsService","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:20 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:20.213Z", "log.level": "INFO", "message":"loaded module [rest-root]", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.elasticsearch.plugins.PluginsService","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:20 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:20.214Z", "log.level": "INFO", "message":"loaded module [x-pack-core]", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.elasticsearch.plugins.PluginsService","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:20 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:20.214Z", "log.level": "INFO", "message":"loaded module [x-pack-redact]", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.elasticsearch.plugins.PluginsService","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:20 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:20.215Z", "log.level": "INFO", "message":"loaded module [ingest-user-agent]", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.elasticsearch.plugins.PluginsService","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:20 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:20.215Z", "log.level": "INFO", "message":"loaded module [x-pack-async-search]", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.elasticsearch.plugins.PluginsService","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:20 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:20.216Z", "log.level": "INFO", "message":"loaded module [x-pack-monitoring]", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.elasticsearch.plugins.PluginsService","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:20 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:20.216Z", "log.level": "INFO", "message":"loaded module [repository-s3]", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.elasticsearch.plugins.PluginsService","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:20 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:20.216Z", "log.level": "INFO", "message":"loaded module [x-pack-analytics]", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.elasticsearch.plugins.PluginsService","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:25 logstash-1 | [2024-06-03T02:58:25,275][INFO ][logstash.settings ] Creating directory {:setting=>"path.queue", :path=>"/usr/share/logstash/data/queue"}
2024-06-03 10:58:20 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:20.217Z", "log.level": "INFO", "message":"loaded module [x-pack-ent-search]", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.elasticsearch.plugins.PluginsService","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:25 logstash-1 | [2024-06-03T02:58:25,293][INFO ][logstash.settings ] Creating directory {:setting=>"path.dead_letter_queue", :path=>"/usr/share/logstash/data/dead_letter_queue"}
2024-06-03 10:58:31 kibana-1 | [2024-06-03T02:58:31.568+00:00][INFO ][plugins-service] The following plugins are disabled: "cloudChat,cloudExperiments,cloudFullStory,profilingDataAccess,profiling,securitySolutionServerless,serverless,serverlessObservability,serverlessSearch".
2024-06-03 10:58:31 kibana-1 | [2024-06-03T02:58:31.701+00:00][INFO ][http.server.Preboot] http server running at http://0.0.0.0:5601
2024-06-03 10:58:31 kibana-1 | [2024-06-03T02:58:31.884+00:00][INFO ][plugins-system.preboot] Setting up [1] plugins: [interactiveSetup]
2024-06-03 10:58:25 logstash-1 | [2024-06-03T02:58:25,609][INFO ][logstash.agent ] No persistent UUID file found. Generating new UUID {:uuid=>"62af05d2-20e5-4f4e-9963-b7ff4976e593", :path=>"/usr/share/logstash/data/uuid"}
2024-06-03 10:58:26 logstash-1 | [2024-06-03T02:58:26,621][INFO ][logstash.agent ] Successfully started Logstash API endpoint {:port=>9600, :ssl_enabled=>false}
2024-06-03 10:58:27 logstash-1 | [2024-06-03T02:58:27,047][INFO ][org.reflections.Reflections] Reflections took 141 ms to scan 1 urls, producing 132 keys and 468 values
2024-06-03 10:58:27 logstash-1 | [2024-06-03T02:58:27,837][INFO ][logstash.javapipeline ] Pipeline `main` is configured with `pipeline.ecs_compatibility: v8` setting. All plugins in this pipeline will default to `ecs_compatibility => v8` unless explicitly configured otherwise.
2024-06-03 10:58:27 logstash-1 | [2024-06-03T02:58:27,884][INFO ][logstash.outputs.elasticsearch][main] New Elasticsearch output {:class=>"LogStash::Outputs::ElasticSearch", :hosts=>["//elasticsearch:9200"]}
2024-06-03 10:58:28 logstash-1 | [2024-06-03T02:58:28,230][INFO ][logstash.outputs.elasticsearch][main] Elasticsearch pool URLs updated {:changes=>{:removed=>[], :added=>[http://logstash_internal:xxxxxx@elasticsearch:9200/]}}
2024-06-03 10:58:28 logstash-1 | [2024-06-03T02:58:28,595][INFO ][logstash.outputs.elasticsearch][main] Failed to perform request {:message=>"Connect to elasticsearch:9200 [elasticsearch/172.22.0.2] failed: Connection refused", :exception=>Manticore::SocketException, :cause=>#<Java::OrgApacheHttpConn::HttpHostConnectException: Connect to elasticsearch:9200 [elasticsearch/172.22.0.2] failed: Connection refused>}
2024-06-03 10:58:28 logstash-1 | [2024-06-03T02:58:28,601][WARN ][logstash.outputs.elasticsearch][main] Attempted to resurrect connection to dead ES instance, but got an error {:url=>"http://logstash_internal:xxxxxx@elasticsearch:9200/", :exception=>LogStash::Outputs::ElasticSearch::HttpClient::Pool::HostUnreachableError, :message=>"Elasticsearch Unreachable: [http://elasticsearch:9200/][Manticore::SocketException] Connect to elasticsearch:9200 [elasticsearch/172.22.0.2] failed: Connection refused"}
2024-06-03 10:58:20 elasticsearch-1 | {"@timestamp":"2024-06-03T02:58:20.217Z", "log.level": "INFO", "message":"loaded module [x-pack-autoscaling]", "ecs.version": "1.2.0","service.name":"ES_ECS","event.dataset":"elasticsearch.server","process.thread.name":"main","log.logger":"org.elasticsearch.plugins.PluginsService","elasticsearch.node.name":"elasticsearch","elasticsearch.cluster.name":"docker-cluster"}
2024-06-03 10:58:28 logstash-1 | [2024-06-03T02:58:28,657][INFO ][logstash.outputs.elasticsearch][main] Data streams auto configuration (`data_stream => auto` or unset) resolved to `true`
2024-06-03 10:58:28 logstash-1 | [2024-06-03T02:58:28,721][INFO ][logstash.javapipeline ][main] Starting pipeline {:pipeline_id=>"main", "pipeline.workers"=>12, "pipeline.batch.size"=>125, "pipeline.batch.delay"=>50, "pipeline.max_inflight"=>1500, "pipeline.sources"=>["/usr/share/logstash/pipeline/logstash.conf"], :thread=>"#<Thread:0x46eeb13b /usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:134 run>"}
2024-06-03 10:58:30 logstash-1 | [2024-06-03T02:58:30,309][INFO ][logstash.javapipeline ][main] Pipeline Java execution initialization time {"seconds"=>1.59}
2024-06-03 10:58:30 logstash-1 | [2024-06-03T02:58:30,665][INFO ][logstash.inputs.beats ][main] Starting input listener {:address=>"0.0.0.0:5044"}
2024-06-03 10:58:30 logstash-1 | [2024-06-03T02:58:30,677][INFO ][logstash.javapipeline ][main] Pipeline started {"pipeline.id"=>"main"}
2024-06-03 10:58:30 logstash-1 | [2024-06-03T02:58:30,681][INFO ][logstash.inputs.tcp ][main][47bf9e2a815e07532c9c0bc66d632adb219ab8e7d15684c1dcc92905d3f719e5] Starting tcp input listener {:address=>"0.0.0.0:50000", :ssl_enabled=>false}
2024-06-03 10:58:30 logstash-1 | [2024-06-03T02:58:30,701][INFO ][logstash.agent ] Pipelines running {:count=>1, :running_pipelines=>[:main], :non_running_pipelines=>[]}
2024-06-03 10:58:31 kibana-1 | [2024-06-03T02:58:31.955+00:00][WARN ][config.deprecation] The default mechanism for Reporting privileges will work differently in future versions, which will affect the behavior of this cluster. Set "xpack.reporting.roles.enabled" to "false" to adopt the future behavior before upgrading.
2024-06-03 10:58:30 logstash-1 | [2024-06-03T02:58:30,712][INFO ][org.logstash.beats.Server][main][4b6d3f4cefcc400fe734e12faf90d71e2483abca1632c490a79dac639f6b83ea] Starting server on port: 5044
2024-06-03 10:58:33 logstash-1 | [2024-06-03T02:58:33,631][INFO ][logstash.outputs.elasticsearch][main] Failed to perform request {:message=>"Connect to elasticsearch:9200 [elasticsearch/172.22.0.2] failed: Connection refused", :exception=>Manticore::SocketException, :cause=>#<Java::OrgApacheHttpConn::HttpHostConnectException: Connect to elasticsearch:9200 [elasticsearch/172.22.0.2] failed: Connection refused>}
2024-06-03 10:58:33 logstash-1 | [2024-06-03T02:58:33,634][WARN ][logstash.outputs.elasticsearch][main] Attempted to resurrect connection to dead ES instance, but got an error {:url=>"http://logstash_internal:xxxxxx@elasticsearch:9200/", :exception=>LogStash::Outputs::ElasticSearch::HttpClient::Pool::HostUnreachableError, :message=>"Elasticsearch Unreachable: [http://elasticsearch:9200/][Manticore::SocketException] Connect to elasticsearch:9200 [elasticsearch/172.22.0.2] failed: Connection refused"}
These logs are truncated. They show that Elasticsearch is still in the process of starting, and do not contain any reference to the JDBC input.
Regardless, I am going to close this issue now because we can't possibly act as a support forum for Elastic products. For this I kindly redirect you to https://discuss.elastic.co/ as indicated in the issue template.
I am trying to connect my PostgreSQL database to elasticsearch, I downloaded the JDBC driver and included it in logstash/plugins. I then updated the logstash.conf
I then included these 2 lines in the docker-compose.yml file
However, I am unable to get logstash up and running, here are the logs: