View Issue Details

IDProjectCategoryView StatusLast Update
0004996SymmetricDSBugpublic2021-05-28 20:40
Reporterelong Assigned Toelong  
Status closedResolutionfixed 
Product Version3.12.1 
Target Version3.12.10Fixed in Version3.12.10 
Summary0004996: Table PK column order mismatch with column order can cause errors
DescriptionThe internal data model for a table returns columns in their natural order, but it returns primary keys in the order based on the PK index. The difference in order can cause trouble for callers, such as the auto resolver that chooses a winner when rows are in conflict. Issue 0004421 changed the order so tables can be created with the columns in one order and primary keys columns ordered differently in the PK index. This issue will make the order match for getColumns() and getPrimaryKeyColumns(). Instead, a new getPrimaryKeyColumnsInIndexOrder() method will be added that callers can use when that order is required, such as the DdlBuilders.

2021-05-15 14:42:50,084 INFO [central] [DefaultDatabaseWriter] [central-dataloader-11497] Failed to process delete event in batch 50-289105 on channel 'default'.
 StackTraceKey.init [RuntimeException:2433083009] java.lang.RuntimeException: Could not convert a value of for column pay_num of type BIGINT
    at org.jumpmind.db.platform.AbstractDatabasePlatform.getObjectValues(
    at org.jumpmind.db.platform.AbstractDatabasePlatform.getObjectValues(
    at org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(
    at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$
    at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$
    at java.util.concurrent.ThreadPoolExecutor.runWorker(
    at java.util.concurrent.ThreadPoolExecutor$
Caused by: java.lang.NumberFormatException
    at java.math.BigDecimal.<init>(
    at java.math.BigDecimal.<init>(
    at java.math.BigDecimal.<init>(
    at org.jumpmind.db.platform.AbstractDatabasePlatform.parseBigInteger(
    at org.jumpmind.db.platform.AbstractDatabasePlatform.getObjectValue(
    at org.jumpmind.db.platform.AbstractDatabasePlatform.getObjectValues(
    ... 17 more


related to 0004421 closedjosh-a-hicks Primary key ordering based on the sequence of the PK 


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 60a4b733

2021-05-21 17:41:32


Details Diff
0004996: Table PK column order mismatch with column order can cause
Affected Issues
mod - symmetric-db/src/main/java/org/jumpmind/db/alter/ Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/model/ Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/ Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/firebird/ Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mssql/ Diff File

Issue History

Date Modified Username Field Change
2021-05-19 16:51 elong New Issue
2021-05-19 16:51 elong Status new => assigned
2021-05-19 16:51 elong Assigned To => elong
2021-05-19 16:51 elong Tag Attached: ddl/schema
2021-05-19 16:52 elong Relationship added related to 0004421
2021-05-21 17:41 elong Status assigned => resolved
2021-05-21 17:41 elong Resolution open => fixed
2021-05-21 17:41 elong Fixed in Version => 3.12.10
2021-05-21 18:00 admin Changeset attached => SymmetricDS 3.12 60a4b733
2021-05-28 20:40 admin Status resolved => closed