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

Hi @joracab ,
With “Connection timed out” errors involving DB nodes, increasing the timeout value in the DB Connector node in the “JDBC parameters” tab could help.

The parameter will need to conform to the used DB type’s JDBC driver in its format.
In case of Oracle, please refer to the official Oracle documentations.

Adjusting the parameters below in the “Advanced” tab might also be beneficial:

image

1 Like