View Issue Details

Jump to NotesRelated ChangesetsIssue History
IDProjectCategoryView StatusDate SubmittedLast Update
0003505SymmetricDSBugpublic2018-03-26 09:252018-05-08 13:00
Reporterwoehrl01Assigned To 
Prioritynormal 
Status newResolutionopen 
Product Version 
Target VersionFixed in Version 
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'

Activities

woehrl01

2018-05-08 07:25

reporter   ~0001182

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

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
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 09:25 woehrl01 New Issue
2018-05-08 07:25 woehrl01 Note Added: 0001182
2018-05-08 13:00 mmichalek Changeset attached => SymmetricDS 3.9 30983763