Logstash-oss-with-opensearch-output-plugin-8.9.0 Connection Issue with Postgres Database

Versions (relevant - logstash-oss-with-opensearch-output-plugin-8.9.0):

Hello,

We have identified a bug in logstash-oss-with-opensearch-output-plugin with version 8.9.0 where the connection to the database opens as soon as logstash-oss-8.9.0 starts and remains open indefinitely, even after query execution is complete. This issue contrasts with the behavior observed in the older version, logstash-oss-7.16.3, where the connection opens only during query execution and closes immediately afterward.

Could anyone provide insights or solutions for addressing this issue with Logstash-oss 8.9.0? We reverted to the older version to mitigate the problem, but we would like to understand if there’s a fix or workaround available for the newer version.

Thank you!

@BSB Logstash software was designed and is supported by Elastic. Please report this issue there.

@pablo, we are using logstash-oss-with-opensearch-output-plugin-8.9.0 not logstash-8.9.0. I have edited the issue