View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005407 | SymmetricDS Pro | Bug | public | 2022-08-12 20:02 | 2022-08-30 13:04 |
| Reporter | emiller | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.0 | ||||
| Target Version | 3.14.1 | Fixed in Version | 3.14.1 | ||
| Summary | 0005407: UniqueKeyException when bulk editing trigger routers | ||||
| Description | When bulk editing trigger routers, a UniqueKeyException similar to the following can occur: Exception while refreshing class com.jumpmind.symmetric.console.ui.common.InProgressDialog$1 org.jumpmind.db.sql.UniqueKeyException: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY_KEY_26 ON PUBLIC.SYM_TRIGGER_ROUTER(TRIGGER_ID, ROUTER_ID) VALUES ( /* key:5 */ 'item', 'corp_2_store', null, null, null, null, null, null, null, null, null)"; SQL statement: insert into sym_trigger_router (initial_load_order,initial_load_select,initial_load_delete_stmt,ping_back_enabled,create_time,last_update_by,last_update_time,enabled,trigger_id,router_id) values(?,?,?,?,?,?,?,?,?,?) [23505-176] at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:302) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:297) at org.jumpmind.db.sql.JdbcSqlTransaction.addRow(JdbcSqlTransaction.java:443) at org.jumpmind.symmetric.service.impl.TriggerRouterService.insertUpdateTriggerRouters(TriggerRouterService.java:1167) at org.jumpmind.symmetric.service.impl.TriggerRouterService.insertTriggerRouters(TriggerRouterService.java:1138) at com.jumpmind.symmetric.console.ui.form.TableRoutingForm$2.doWork(TableRoutingForm.java:256) at com.jumpmind.symmetric.console.ui.common.InProgressDialog$1.onBackgroundDataRefresh(InProgressDialog.java:102) at com.jumpmind.symmetric.console.ui.BackgroundRefresherService.refresh(BackgroundRefresherService.java:87) at com.jumpmind.symmetric.console.ui.BackgroundRefresherService$2.run(BackgroundRefresherService.java:126) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) 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:750) Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY_KEY_26 ON PUBLIC.SYM_TRIGGER_ROUTER(TRIGGER_ID, ROUTER_ID) VALUES ( /* key:5 */ 'item', 'corp_2_store', null, null, null, null, null, null, null, null, null)"; SQL statement: insert into sym_trigger_router (initial_load_order,initial_load_select,initial_load_delete_stmt,ping_back_enabled,create_time,last_update_by,last_update_time,enabled,trigger_id,router_id) values(?,?,?,?,?,?,?,?,?,?) [23505-176] at org.h2.message.DbException.getJdbcSQLException(DbException.java:344) at org.h2.message.DbException.get(DbException.java:178) at org.h2.message.DbException.get(DbException.java:154) at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:103) at org.h2.index.PageBtree.find(PageBtree.java:121) at org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:151) at org.h2.index.PageBtreeLeaf.addRowTry(PageBtreeLeaf.java:104) at org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java:97) at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:88) at org.h2.table.RegularTable.addRow(RegularTable.java:120) at org.h2.command.dml.Insert.insertRows(Insert.java:157) at org.h2.command.dml.Insert.update(Insert.java:115) at org.h2.command.CommandContainer.update(CommandContainer.java:79) at org.h2.command.Command.executeUpdate(Command.java:254) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:158) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:144) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) at org.jumpmind.db.sql.JdbcSqlTransaction.executePreparedUpdate(JdbcSqlTransaction.java:462) at org.jumpmind.db.sql.JdbcSqlTransaction.addRow(JdbcSqlTransaction.java:440) ... 13 more | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-08-12 20:02 | emiller | New Issue | |
| 2022-08-12 20:02 | emiller | Status | new => assigned |
| 2022-08-12 20:02 | emiller | Assigned To | => emiller |
| 2022-08-12 20:07 | emiller | Status | assigned => resolved |
| 2022-08-12 20:07 | emiller | Resolution | open => fixed |
| 2022-08-12 20:07 | emiller | Fixed in Version | => 3.14.1 |
| 2022-08-30 13:04 | admin | Status | resolved => closed |