Timeout Oracle After a while of time
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
Answers
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,225 Dataiker
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 Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,225 Dataiker
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.