View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004942 | SymmetricDS | Bug | public | 2021-04-06 12:53 | 2021-11-04 14:58 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.2 | ||||
| Target Version | 3.11.14 | Fixed in Version | 3.11.14 | ||
| Summary | 0004942: Initial load blocking | ||||
| Description | Initial load won't start because it can't get next batch number due to some kind of blocking. Appears to affect SQL-Server the most. As a workaround, set datareload.batch.insert.transactional=false parameter. 2021-03-25 22:16:16,560 ERROR [AWSSASMSSQL] [InitialLoadService] [AWSSASMSSQL-job-3] Error while queuing initial loads StackTraceKey.init [SqlException:751401462] org.jumpmind.db.sql.SqlException: The query has timed out. at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:306) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:295) at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:398) at org.jumpmind.db.sql.JdbcSqlTransaction.queryForObject(JdbcSqlTransaction.java:217) at org.jumpmind.db.sql.JdbcSqlTransaction.queryForLong(JdbcSqlTransaction.java:209) at org.jumpmind.symmetric.service.impl.SequenceService.currVal(SequenceService.java:289) at org.jumpmind.symmetric.service.impl.SequenceService.tryToGetNextVal(SequenceService.java:154) at org.jumpmind.symmetric.service.impl.SequenceService.nextValFromDatabase(SequenceService.java:141) at org.jumpmind.symmetric.service.impl.SequenceService$2.execute(SequenceService.java:128) at org.jumpmind.symmetric.service.impl.SequenceService$2.execute(SequenceService.java:126) at org.jumpmind.symmetric.service.impl.SequenceService$DoTransaction.execute(SequenceService.java:364) at org.jumpmind.symmetric.service.impl.SequenceService.nextValFromDatabase(SequenceService.java:130) at org.jumpmind.symmetric.service.impl.SequenceService.nextRange(SequenceService.java:239) at org.jumpmind.symmetric.service.impl.SequenceService.nextRange(SequenceService.java:251) at org.jumpmind.symmetric.service.impl.DataService.insertRequestedOutgoingBatches(DataService.java:696) at org.jumpmind.symmetric.service.impl.DataService.insertLoadBatchesForReload(DataService.java:1535) at org.jumpmind.symmetric.service.impl.DataService.insertReloadEvents(DataService.java:1022) at org.jumpmind.symmetric.service.impl.InitialLoadService.processTableRequestLoads(InitialLoadService.java:282) at org.jumpmind.symmetric.service.impl.InitialLoadService.queueLoads(InitialLoadService.java:98) at org.jumpmind.symmetric.job.InitialLoadJob.doJob(InitialLoadJob.java:43) at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:227) at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:298) 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:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLTimeoutException: The query has timed out. at net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:4131) at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1086) at net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:536) at net.sourceforge.jtds.jdbc.MSCursorResultSet.<init>(MSCursorResultSet.java:154) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:452) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.jumpmind.db.sql.JdbcSqlTransaction$1.execute(JdbcSqlTransaction.java:230) at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:396) ... 27 more | ||||
| Tags | dialect: sql-server, initial/partial load | ||||
|
SymmetricDS: 3.11 75982a83 2021-04-06 12:54:35 Details Diff |
0004942: Initial load blocking |
Affected Issues 0004942 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-04-06 12:53 | elong | New Issue | |
| 2021-04-06 12:53 | elong | Status | new => assigned |
| 2021-04-06 12:53 | elong | Assigned To | => elong |
| 2021-04-06 12:53 | elong | Tag Attached: dialect: sql-server | |
| 2021-04-06 12:53 | elong | Tag Attached: initial/partial load | |
| 2021-04-06 12:53 | elong | Issue generated from: 0004920 | |
| 2021-04-06 12:53 | elong | Relationship added | related to 0004920 |
| 2021-04-06 12:54 | elong | Status | assigned => resolved |
| 2021-04-06 12:54 | elong | Resolution | open => fixed |
| 2021-04-06 12:54 | elong | Fixed in Version | => 3.11.14 |
| 2021-04-06 13:00 | admin | Changeset attached | => SymmetricDS 3.11 75982a83 |
| 2021-11-04 14:58 | admin | Status | resolved => closed |