View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003505 | SymmetricDS | Bug | public | 2018-03-26 13:25 | 2023-10-01 23:46 |
| Reporter | woehrl01 | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Target Version | 3.15.0 | Fixed in Version | 3.15.0 | ||
| Summary | 0003505: SYM_TABLE_RELOAD_REQUEST is updated via DateTime which sometimes fails due to precision mismatch | ||||
| Description | The 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 Reproduce | Use Microsoft SQL Server Insert a table_reload_request with a create_time value of '2018-03-26 13:45:34.673' | ||||
| Tags | data conversion | ||||
|
|
see https://github.com/JumpMind/symmetric-ds/pull/89 |
|
|
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? |
|
|
Issue 0005778 will change the precision of the timestamp on sym_table_reload_request and other similar tables, which will fix this problem. |
| 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 |