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

Leaking JDBC connections

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 2.5.0.Final
    • 2.5.0.CR1
    • oracle-connector
    • None

      Lots of tests fails with ORA-12516, TNS:listener could not find available handler with matching protocol stack which suggests we are probably leaking JDBC connections somewhere.

      Full exception:

      java.lang.RuntimeException: Failed to resolve Oracle database version
      	at io.debezium.connector.oracle.OracleConnection.resolveOracleDatabaseVersion(OracleConnection.java:189)
      	at io.debezium.connector.oracle.OracleConnection.<init>(OracleConnection.java:96)
      	at io.debezium.connector.oracle.OracleConnection.<init>(OracleConnection.java:79)
      	at io.debezium.connector.oracle.OracleConnector.validateConnection(OracleConnector.java:74)
      	at io.debezium.connector.common.RelationalBaseSourceConnector.validate(RelationalBaseSourceConnector.java:43)
      	at io.debezium.embedded.EmbeddedEngine.getConnectorConfig(EmbeddedEngine.java:519)
      	at io.debezium.embedded.EmbeddedEngine.run(EmbeddedEngine.java:431)
      	at io.debezium.embedded.TestingEmbeddedEngine.run(TestingEmbeddedEngine.java:24)
      	at io.debezium.embedded.AbstractConnectorTest.lambda$start$8(AbstractConnectorTest.java:423)
      	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
      	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
      	at java.base/java.lang.Thread.run(Thread.java:833)
      Caused by: java.sql.SQLException: Listener refused the connection with the following error:
      ORA-12516, TNS:listener could not find available handler with matching protocol stack
        (CONNECTION_ID=9PDt2uRiTwqaW0jIJhWQTg==)
      	at oracle.jdbc.driver.T4CConnection.handleLogonNetException(T4CConnection.java:893)
      	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:698)
      	at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1042)
      	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:90)
      	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:733)
      	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:649)
      	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:681)
      	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:190)
      	at io.debezium.jdbc.JdbcConnection.lambda$patternBasedFactory$0(JdbcConnection.java:191)
      	at io.debezium.jdbc.JdbcConnection$ConnectionFactoryDecorator.connect(JdbcConnection.java:129)
      	at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:875)
      	at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:870)
      	at io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:623)
      	at io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:497)
      	at io.debezium.connector.oracle.OracleConnection.resolveOracleDatabaseVersion(OracleConnection.java:156)
      	... 11 common frames omitted
      Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
      ORA-12516, TNS:listener could not find available handler with matching protocol stack
        (CONNECTION_ID=9PDt2uRiTwqaW0jIJhWQTg==)
      	at oracle.net.ns.NSProtocolNIO.createRefusePacketException(NSProtocolNIO.java:816)
      	at oracle.net.ns.NSProtocolNIO.handleConnectPacketResponse(NSProtocolNIO.java:396)
      	at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:207)
      	at oracle.net.ns.NSProtocol.connect(NSProtocol.java:354)
      	at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:2372)
      	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:657)
      	... 24 common frames omitted
      

            vjuranek@redhat.com Vojtech Juranek
            vjuranek@redhat.com Vojtech Juranek
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: