db connection manager issue
Hi we are testing some workflows with io database operations.We are receving the following message:
2024-02-20 16:32:38,320 : WARN : KNIME-Database-Connection-Closer-64 : f3064b3a-502d-4277-bea1-e9bcbacd19f6 : DBConnectionManager : : : An error occurred while closing the database connection [URL=“jdbc:oracle:thin:@XXX.XXX.XX.XX:XXXX/DBname”, user=“Test”]: IO Error: Connection timed out java.sql.SQLRecoverableException: IO Error: Connection timed out at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:1053) at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:2296) at org.knime.database.connection.wrappers.AbstractConnectionWrapper.close(AbstractConnectionWrapper.java:170) at org.knime.database.connection.impl.DBConnectionManager.lambda$1(DBConnectionManager.java:198) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Caused by: java.io.IOException: Connection timed out at java.base/sun.nio.ch.SocketDispatcher.read0(Native Method) at java.base/sun.nio.ch.SocketDispatcher.read(Unknown Source) at java.base/sun.nio.ch.IOUtil.readIntoNativeBuffer(Unknown Source) at java.base/sun.nio.ch.IOUtil.read(Unknown Source) at java.base/sun.nio.ch.IOUtil.read(Unknown Source) at java.base/sun.nio.ch.SocketChannelImpl.read(Unknown Source) at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:182) at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:572) at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:263) at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:195) at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:137) at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:110) at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:91) at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:791) at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:449)
Does anyone have teh same problem or a work around to this issue