Am getting this continuous warnings related to cle...

# exposed

[Tarun Chawla]

Am getting this continuous warnings related to cleanup:

Feb 13, 2021 5:28:37 PM com.impossibl.postgres.jdbc.ThreadedHousekeeper$HousekeeperReference cleanup
WARNING: Cleaning up leaked result-set
Allocation occurred @
  at org.jetbrains.exposed.sql.statements.jdbc.JdbcPreparedStatementImpl.executeQuery(JdbcPreparedStatementImpl.kt:21)
  at org.jetbrains.exposed.sql.Query.executeInternal(Query.kt:79)
  at org.jetbrains.exposed.sql.Query.executeInternal(Query.kt:15)
  at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed_core(Statement.kt:61)
  at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:129)

Due to this elephant sql is complaining about too many multiple connections. Am using exposed version 0.29.1 and latest pgjdbc-ng:0.8.6. Please help me understand the issue and share any code snippet if any.
Am opening db connection like below:

fun getDBConn(): Database? {
    if (DBConnection == null) {
      synchronized(this) {
        if (DBConnection == null) {
          try {
            DBConnection = DataBaseConnection.connectWithDb(
              Config.DB_URL,
              Config.DB_DRIVER,
              Config.DB_USERNAME,
              Config.DB_PASSWORD
            )
          } catch (e: Exception) {
            println("error while connecting to db $e")
            return null
          }
        }
      }
    }
    return DBConnection
  }

[hichem fazai]

There are some related issues opened in pgjdbc-ng repo:
Take a look at these :
https://github.com/impossibl/pgjdbc-ng/issues/129
https://github.com/impossibl/pgjdbc-ng/issues/44

[Tarun Chawla]

in exposed we are not dealing with pgjdbc directly. most likely its either issue in the way am using expose or there is some bug in expose.

create this issue: https://github.com/JetBrains/Exposed/issues/1171