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