View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004178 | SymmetricDS Pro | Bug | public | 2019-12-03 16:14 | 2019-12-03 16:14 |
| Reporter | hanes | Assigned To | |||
| Priority | normal | ||||
| Status | confirmed | Resolution | open | ||
| Product Version | 3.11.1 | ||||
| Summary | 0004178: Queuing an initial load in Interbase results in deadlock | ||||
| Description | When using the Pro UI, queuing a basic load of a table (corp-> store) results in a deadlock: [corp-000] - InitialLoadService - Found 1 table reload requests to process. [corp-000] - DataService - Queueing up an initial load to node 001 [corp-000] - InitialLoadService - Error while queuing initial loads org.jumpmind.db.sql.SqlException: [interclient][interbase]deadlock [interclient][interbase]update conflicts with concurrent update at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:305) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:294) at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:398) at org.jumpmind.db.sql.JdbcSqlTransaction.prepareAndExecute(JdbcSqlTransaction.java:364) at org.jumpmind.symmetric.service.impl.DataService.insertReloadEvents(DataService.java:1000) at org.jumpmind.symmetric.service.impl.InitialLoadService.processTableRequestLoads(InitialLoadService.java:224) at org.jumpmind.symmetric.service.impl.InitialLoadService.queueLoads(InitialLoadService.java:93) 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.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLException: [interclient][interbase]deadlock [interclient][interbase]update conflicts with concurrent update at interbase.interclient.Statement.remote_EXECUTE_STATEMENT(Unknown Source) at interbase.interclient.PreparedStatement.remote_EXECUTE_PREPARED_STATEMENT(Unknown Source) at interbase.interclient.PreparedStatement.execute(Unknown Source) 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$6.execute(JdbcSqlTransaction.java:374) at org.jumpmind.db.sql.JdbcSqlTransaction$6.execute(JdbcSqlTransaction.java:364) at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:396) ... 14 more | ||||
| Tags | dialect: interbase | ||||