View Issue Details

IDProjectCategoryView StatusLast Update
0003505SymmetricDSBugpublic2023-10-01 23:46
Reporterwoehrl01 Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Target Version3.15.0Fixed in Version3.15.0 
Summary0003505: SYM_TABLE_RELOAD_REQUEST is updated via DateTime which sometimes fails due to precision mismatch
DescriptionThe updateProcessedTableReloadRequest sql in DataServiceSqlMap uses a datetime to update the row entry.

On MSSQL this always fails if the precision is less than 0.00x milliseconds.

An entry with '2018-03-26 13:45:34.680' is updated, an entry with '2018-03-26 13:45:34.673' failes, which leads to reprocessing this entry over and over again.
Steps To ReproduceUse Microsoft SQL Server

Insert a table_reload_request with a create_time value of '2018-03-26 13:45:34.673'
Tagsdata conversion

Relationships

related to 0005778 closedcquamme Change timestamp size on sym tables with a timestamp as a primary key 

Activities

woehrl01

2018-05-08 11:25

reporter   ~0001182

see https://github.com/JumpMind/symmetric-ds/pull/89

emiller

2022-08-17 18:54

developer   ~0002169

I followed your steps to reproduce this issue using SymmetricDS 3.14.0 and SQL Server 2019 and the load completed without fail. It's possible that this issue has already been resolved since SymmetricDS 3.9.

Can you upgrade to the latest version of SymmetricDS and see if you still encounter this issue? If you still experience it, are there any additional details you can provide to help me reproduce the issue?

elong

2023-05-17 20:32

developer   ~0002327

Issue 0005778 will change the precision of the timestamp on sym_table_reload_request and other similar tables, which will fix this problem.

Related Changesets

SymmetricDS: 3.9 30983763

2018-05-08 12:32:31

mmichalek

Details Diff
0003505: Throw error if it can't update a table_reload_request Affected Issues
0003505
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File

Issue History

Date Modified Username Field Change
2018-03-26 13:25 woehrl01 New Issue
2018-05-08 11:25 woehrl01 Note Added: 0001182
2018-05-08 17:00 mmichalek Changeset attached => SymmetricDS 3.9 30983763
2019-04-24 17:41 elong Tag Attached: runtime
2020-09-03 12:56 admin Tag Detached: runtime
2022-08-02 19:36 elong Tag Attached: data conversion
2022-08-17 18:54 emiller Note Added: 0002169
2022-08-17 18:54 emiller Status new => feedback
2023-05-17 15:29 elong Relationship added related to 0005778
2023-05-17 20:32 elong Assigned To => elong
2023-05-17 20:32 elong Status feedback => resolved
2023-05-17 20:32 elong Resolution open => fixed
2023-05-17 20:32 elong Fixed in Version => 3.15.0
2023-05-17 20:32 elong Note Added: 0002327
2023-10-01 23:46 admin Status resolved => closed