View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002378 | SymmetricDS | Improvement | public | 2015-08-28 20:24 | 2015-09-11 20:14 |
| Reporter | chenson | Assigned To | chenson | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.7.21 | ||||
| Target Version | 3.7.21 | Fixed in Version | 3.7.21 | ||
| Summary | 0002378: Protect against duplicate sym_data_gap entries | ||||
| Description | Protect against duplicate sym_data_gap entries | ||||
| Additional Information | 2015-08-28 14:50:37,944 ERROR [server] [RouterJob] [server-job-9] org.jumpmind.db.sql.UniqueKeyException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '1209456-1216009' for key 'PRIMARY' at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:284) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:279) at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:338) at org.jumpmind.db.sql.JdbcSqlTransaction.prepareAndExecute(JdbcSqlTransaction.java:285) at org.jumpmind.symmetric.service.impl.DataService.insertDataGap(DataService.java:1436) at org.jumpmind.symmetric.route.DataGapDetector.beforeRouting(DataGapDetector.java:126) at org.jumpmind.symmetric.service.impl.RouterService.routeData(RouterService.java:174) at org.jumpmind.symmetric.job.RouterJob.doJob(RouterJob.java:40) at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:180) at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:224) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.runAndReset(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '1209456-1216009' for key 'PRIMARY' at sun.reflect.GeneratedConstructorAccessor57.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1307) 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:293) at org.jumpmind.db.sql.JdbcSqlTransaction$4.execute(JdbcSqlTransaction.java:285) at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:336) ... 15 more | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.7 9289d29a 2015-08-28 16:48:45 Details Diff |
0002378: Protect against duplicate sym_data_gap entries |
Affected Issues 0002378 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/DataGapDetector.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/model/DataGap.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-08-28 20:24 | chenson | New Issue | |
| 2015-08-28 20:24 | chenson | Status | new => assigned |
| 2015-08-28 20:24 | chenson | Assigned To | => chenson |
| 2015-08-28 20:49 | chenson | Status | assigned => resolved |
| 2015-08-28 20:49 | chenson | Fixed in Version | => 3.7.21 |
| 2015-08-28 20:49 | chenson | Resolution | open => fixed |
| 2015-08-28 21:00 | chenson | Changeset attached | => SymmetricDS 3.7 9289d29a |
| 2015-09-11 20:14 | chenson | Status | resolved => closed |