View Issue Details

IDProjectCategoryView StatusLast Update
0004178SymmetricDS ProBugpublic2019-12-03 11:14
ReporterhanesAssigned To 
Prioritynormal 
Status confirmedResolutionopen 
Product Version3.11.1 
Target VersionFixed in Version 
Summary0004178: Queuing an initial load in Interbase results in deadlock
DescriptionWhen 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
Tagsdialect: interbase

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-12-03 11:14 hanes New Issue
2019-12-03 11:14 hanes Tag Attached: dialect: interbase
2019-12-03 11:14 hanes Status new => confirmed