Timeout Oracle After a while of time

Alwaleed

Hi everyone , I not sure about the problem but the recipes raised timeout error after 1 hour

It was working fine with no errors anyone can help ?

Thanks in advance

Alexandru

Hi @Alwaleed
,
Could you please raise support with the job diagnostics?

https://doc.dataiku.com/dss/latest/troubleshooting/obtaining-support.html

We need to look at the exact error you see to advise further.
Most likely, it is on the database side.

Alexandru

Hi @Alwaleed
,
Note we don't recommend adding job diagnostics to the community. I've asked the community admins to remove it.

We can see the timeout occurred while doing SQL insert batch

[2023/08/13-16:26:20.442] [FRT-62-FlowRunnable] [INFO] [dku.output.sql] act.compute_FL-CahsierWTID_NP - Executing SQL insert batch ...

About ~15 minutes later the timeout occurred in the JDBC Oracle code :

[2023/08/13-16:42:04.933] [FRT-62-FlowRunnable] [ERROR] [dku.output.sql] act.compute_FL-CahsierWTID_NP - Encountered SQL exception

Encountered SQL exception
java.sql.BatchUpdateException: IO Error: Connection timed out
at oracle.jdbc.driver.OraclePreparedStatement.generateBatchUpdateException(OraclePreparedStatement.java:10345)

https://support.oracle.com/knowledge/Middleware/2008225_1.html


It's unclear what caused the timeout. It would be best to work with your DBA and Network team to reproduce and isolate the issue. It could be a network/firewall timeout or something on the Oracle database side if the database was under load during that time.

If you need further assistance on this please open a support ticket.