One Star

Socket read timed out

Hello,
I have a scheduled job that starts every Sunday, but sometimes it bug, you find down the error message.
I am inclined to say that it is a network problem because of the error message is "Socket read timed out"
It works when I launch it manually, but sometimes the automatic scheduling of Sunday fails !!!
Best regards


Exception in component tOracleInput_4
java.sql.SQLException: Exception d'E/S: Socket read timed out
                at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
                at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
                at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
                at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
                at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:566)
                at oracle.jdbc.driver.T4CStatement.fetch(T4CStatement.java:1013)
                at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:314)
                at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:228)
                at reporting.tb_com_alim_s_2_bcl_sais_0_1.TB_COM_Alim_S_2_Bcl_Sais.tOracleInput_4Process(TB_COM_Alim_S_2_Bcl_Sais.java:15761)
                at reporting.tb_com_alim_s_2_bcl_sais_0_1.TB_COM_Alim_S_2_Bcl_Sais.tOracleInput_5Process(TB_COM_Alim_S_2_Bcl_Sais.java:9956)
                at reporting.tb_com_alim_s_2_bcl_sais_0_1.TB_COM_Alim_S_2_Bcl_Sais.tOracleInput_2Process(TB_COM_Alim_S_2_Bcl_Sais.java:6491)
                at reporting.tb_com_alim_s_2_bcl_sais_0_1.TB_COM_Alim_S_2_Bcl_Sais.tOracleRow_1Process(TB_COM_Alim_S_2_Bcl_Sais.java:1086)
                at reporting.tb_com_alim_s_2_bcl_sais_0_1.TB_COM_Alim_S_2_Bcl_Sais.runJobInTOS(TB_COM_Alim_S_2_Bcl_Sais.java:17522)
                at reporting.tb_com_alim_s_2_bcl_sais_0_1.TB_COM_Alim_S_2_Bcl_Sais.runJob(TB_COM_Alim_S_2_Bcl_Sais.java:17203)
                at reporting.tb_com_alim_s_2_0_1.TB_COM_Alim_S_2.tOracleInput_5Process(TB_COM_Alim_S_2.java:1495)
                at reporting.tb_com_alim_s_2_0_1.TB_COM_Alim_S_2.runJobInTOS(TB_COM_Alim_S_2.java:3389)
                at reporting.tb_com_alim_s_2_0_1.TB_COM_Alim_S_2.runJob(TB_COM_Alim_S_2.java:3042)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_7Process(COM_Hebdo.java:6317)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_6Process(COM_Hebdo.java:6140)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_5Process(COM_Hebdo.java:5942)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_2Process(COM_Hebdo.java:5314)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_19Process(COM_Hebdo.java:5095)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_26Process(COM_Hebdo.java:4876)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_15Process(COM_Hebdo.java:4039)
                at reporting.com_hebdo_0_1.COM_Hebdo.tOracleInput_2Process(COM_Hebdo.java:3457)
                at reporting.com_hebdo_0_1.COM_Hebdo$2.run(COM_Hebdo.java:18044)
Caused by: oracle.net.ns.NetException: Socket read timed out
                at oracle.net.ns.Packet.receive(Packet.java:249)
                at oracle.net.ns.DataPacket.receive(DataPacket.java:92)
                at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:172)
                at oracle.net.ns.NetInputStream.read(NetInputStream.java:117)
                at oracle.net.ns.NetInputStream.read(NetInputStream.java:92)
                at oracle.net.ns.NetInputStream.read(NetInputStream.java:77)
                at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1034)
                at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1010)
                at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:588)
                at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
                at oracle.jdbc.driver.T4CStatement.fetch(T4CStatement.java:1006)
                ... 20 more
Exception in component tRunJob_4
java.lang.RuntimeException: Child job running failed
                at reporting.tb_com_alim_s_2_0_1.TB_COM_Alim_S_2.tOracleInput_5Process(TB_COM_Alim_S_2.java:1506)
                at reporting.tb_com_alim_s_2_0_1.TB_COM_Alim_S_2.runJobInTOS(TB_COM_Alim_S_2.java:3389)
                at reporting.tb_com_alim_s_2_0_1.TB_COM_Alim_S_2.runJob(TB_COM_Alim_S_2.java:3042)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_7Process(COM_Hebdo.java:6317)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_6Process(COM_Hebdo.java:6140)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_5Process(COM_Hebdo.java:5942)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_2Process(COM_Hebdo.java:5314)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_19Process(COM_Hebdo.java:5095)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_26Process(COM_Hebdo.java:4876)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_15Process(COM_Hebdo.java:4039)
                at reporting.com_hebdo_0_1.COM_Hebdo.tOracleInput_2Process(COM_Hebdo.java:3457)
                at reporting.com_hebdo_0_1.COM_Hebdo$2.run(COM_Hebdo.java:18044)
Exception in component tRunJob_7
java.lang.RuntimeException: Child job running failed
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_7Process(COM_Hebdo.java:6328)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_6Process(COM_Hebdo.java:6140)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_5Process(COM_Hebdo.java:5942)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_2Process(COM_Hebdo.java:5314)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_19Process(COM_Hebdo.java:5095)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_26Process(COM_Hebdo.java:4876)
                at reporting.com_hebdo_0_1.COM_Hebdo.tRunJob_15Process(COM_Hebdo.java:4039)
                at reporting.com_hebdo_0_1.COM_Hebdo.tOracleInput_2Process(COM_Hebdo.java:3457)
                at reporting.com_hebdo_0_1.COM_Hebdo$2.run(COM_Hebdo.java:18044)
at reporting.com_hebdo_0_1.COM_Hebdo$2.run(COM_Hebdo.java:18044)
1 REPLY
Seventeen Stars

Re: Socket read timed out

I have a customer with similar problems and it turns out the backup slows down the server in a terrible way. Are you sure at this time nothing special happens on your server or the hardware host?
Another reason could be Oracle itself. Check this thread:
https://community.oracle.com/thread/1042247?tstart=0