View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006373 | SymmetricDS | Bug | public | 2024-04-29 19:43 | 2024-05-06 19:00 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.6 | Fixed in Version | 3.15.6 | ||
| Summary | 0006373: SQLite purge fails with unrecognized token: "{" | ||||
| Description | On SQLite, if outgoing purge finds stranded data to purge and recaptures it to repair the data, it can get a SQL unrecognized token error when the table has a timestamp in the primary key. PurgeService] [source-extract-default-20] Failed to execute purge, but will try again, StackTraceKey.init [SqlException:2353737313] org.jumpmind.db.sql.SqlException: [SQLITE_ERROR] SQL error or missing database (unrecognized token: "{") at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:308) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:297) at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:377) at org.jumpmind.db.sql.JdbcSqlTransaction.queryForObject(JdbcSqlTransaction.java:202) at org.jumpmind.symmetric.service.impl.DataService.getCsvDataFor(DataService.java:2849) at org.jumpmind.symmetric.service.impl.DataService.reCaptureData(DataService.java:3573) at org.jumpmind.symmetric.service.impl.DataService.reCaptureData(DataService.java:3534) at org.jumpmind.symmetric.service.impl.PurgeService.purgeByMinMax(PurgeService.java:639) at org.jumpmind.symmetric.service.impl.PurgeService.purgeStranded(PurgeService.java:433) at org.jumpmind.symmetric.service.impl.PurgeService.purgeOutgoing(PurgeService.java:144) at org.jumpmind.symmetric.service.impl.PurgeService.purgeOutgoing(PurgeService.java:97) at org.jumpmind.symmetric.job.OutgoingPurgeJob.doJob(OutgoingPurgeJob.java:47) | ||||
| Tags | dialect: sqlite | ||||
|
SymmetricDS: 3.15 e3d54078 2024-04-29 19:45:09 Details Diff |
0006373: SQLite purge fails with unrecognized token: "{" |
Affected Issues 0006373 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/sqlite/SqliteDmlStatement.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/sql/DmlStatement.java | Diff File | ||
|
SymmetricDS: 3.15 4dda9a4a 2024-05-06 18:25:25 Details Diff |
0006373: SQLite purge fails with unrecognized token: "{" |
Affected Issues 0006373 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/DatabaseInfo.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/sqlite/SqliteDmlStatement.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/sql/DmlStatement.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/sqlite/SqliteDatabasePlatform.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-04-29 19:43 | elong | New Issue | |
| 2024-04-29 19:43 | elong | Status | new => assigned |
| 2024-04-29 19:43 | elong | Assigned To | => elong |
| 2024-04-29 19:43 | elong | Tag Attached: dialect: sqlite | |
| 2024-04-29 20:00 | admin | Changeset attached | => SymmetricDS 3.15 e3d54078 |
| 2024-05-02 14:41 | elong | Status | assigned => resolved |
| 2024-05-02 14:41 | elong | Resolution | open => fixed |
| 2024-05-02 14:41 | elong | Fixed in Version | => 3.15.6 |
| 2024-05-03 17:35 | admin | Status | resolved => closed |
| 2024-05-06 19:00 | admin | Changeset attached | => SymmetricDS 3.15 4dda9a4a |