View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002918 | SymmetricDS | Bug | public | 2016-11-24 14:17 | 2018-10-17 18:33 |
| Reporter | monoranjang | Assigned To | |||
| Priority | normal | ||||
| Status | closed | Resolution | won't fix | ||
| Product Version | 3.8.9 | ||||
| Summary | 0002918: IO Error: Socket read timed out | ||||
| Description | 2016-11-24 14:10:00,114 INFO [gui] [PullJob] [qtp238157928-18] The job.pull job has been cancelled 2016-11-24 14:10:00,114 INFO [gui] [PullJob] [qtp238157928-18] Starting job.pull on periodic schedule: every 5000ms with the first run at Thu Nov 24 14:10:07 UTC 2016 2016-11-24 14:10:10,072 ERROR [server] [RouterJob] [server-job-11] StackTraceKey [SqlException:2135036551] 2016-11-24 14:10:13,336 INFO [server] [DataGapFastDetector] [server-job-8] Full gap analysis is running 2016-11-24 14:10:13,343 INFO [server] [DataGapFastDetector] [server-job-8] Querying data in gaps from database took 7 ms 2016-11-24 14:11:13,388 ERROR [server] [RouterJob] [server-job-8] StackTraceKey.init [SqlException:2997995603] org.jumpmind.db.sql.SqlException: IO Error: Socket read timed out at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:303) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:294) at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:391) at org.jumpmind.db.sql.JdbcSqlTransaction.prepareAndExecute(JdbcSqlTransaction.java:310) at org.jumpmind.symmetric.service.impl.DataService.deleteDataGap(DataService.java:1894) at org.jumpmind.symmetric.route.DataGapFastDetector.deleteDataGaps(DataGapFastDetector.java:377) at org.jumpmind.symmetric.route.DataGapFastDetector.saveDataGaps(DataGapFastDetector.java:351) at org.jumpmind.symmetric.route.DataGapFastDetector.afterRouting(DataGapFastDetector.java:279) at org.jumpmind.symmetric.route.DataGapFastDetector.beforeRouting(DataGapFastDetector.java:124) at org.jumpmind.symmetric.service.impl.RouterService.routeData(RouterService.java:200) at org.jumpmind.symmetric.job.RouterJob.doJob(RouterJob.java:50) at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:175) at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:219) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: IO Error: Socket read timed out at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1058) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3685) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1088) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.jumpmind.db.sql.JdbcSqlTransaction$4.execute(JdbcSqlTransaction.java:319) at org.jumpmind.db.sql.JdbcSqlTransaction$4.execute(JdbcSqlTransaction.java:310) at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:389) ... 18 more Caused by: oracle.net.ns.NetException: Socket read timed out at oracle.net.ns.Packet.receive(Packet.java:339) at oracle.net.ns.DataPacket.receive(DataPacket.java:106) at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:315) at oracle.net.ns.NetInputStream.read(NetInputStream.java:260) at oracle.net.ns.NetInputStream.read(NetInputStream.java:185) at oracle.net.ns.NetInputStream.read(NetInputStream.java:102) at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124) at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80) at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1037) ... 27 more 2016-11-24 14:11:18,392 INFO [server] [DataGapFastDetector] [server-job-12] Full gap analysis is running 2016-11-24 14:11:18,399 INFO [server] [DataGapFastDetector] [server-job-12] Querying data in gaps from database took 7 ms 2016-11-24 14:12:18,460 ERROR [server] [RouterJob] [server-job-12] StackTraceKey [SqlException:2997995603] 2016-11-24 14:12:23,464 INFO [server] [DataGapFastDetector] [server-job-9] Full gap analysis is running | ||||
| Steps To Reproduce | delete from sym_data delete from sym_data_gap delete from sym_data_event insert record into source table | ||||
| Tags | No tags attached. | ||||
|
|
Not an issue in 3.9. You do get an error in the log about not being able to delete the expected "big" gap but it doesn't actually cause any issues it seems. |
|
|
In reality, the service should be stopped before a delete from sym_data_gap takes place. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-11-24 14:17 | monoranjang | New Issue | |
| 2018-10-17 16:10 | hanes | Note Added: 0001280 | |
| 2018-10-17 16:10 | hanes | Project | SymmetricDS Pro => SymmetricDS |
| 2018-10-17 18:33 | hanes | Note Added: 0001284 | |
| 2018-10-17 18:33 | hanes | Status | new => closed |
| 2018-10-17 18:33 | hanes | Resolution | open => won't fix |