Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-1596

AWS RDS Performance Insights screwed a little by non-closed statement in "SELECT COUNT(1) FROM pg_publication"

XMLWordPrintable

      A minor thing, but a little annoying: in PostgresReplicationConnection.initPublication(), since rs (ResultSet) of "SELECT COUNT(1) FROM pg_publication WHERE..." query is not destroyed manually in a finally block, I think AWS thinks that it's still executing for a long time. I also see it in pg_stat_activity as an "active" query (although it's obvious that this query finished long time ago).

      I think it's a simple and a safe fix, just call rs.close() in a finally block in this function.

              ccranfor@redhat.com Chris Cranford
              dko-slapdash Dimitri Ko (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: