-
Bug
-
Resolution: Done
-
Major
-
2.5.0.CR1
-
None
-
False
-
None
-
False
-
-
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
- links to
-
RHEA-2024:129636 Red Hat build of Debezium 2.5.4 release