View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003505 | SymmetricDS | Bug | public | 2018-03-26 09:25 | 2018-05-08 13:00 |
| Reporter | woehrl01 | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | sometimes |
| Status | new | Resolution | open | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| 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 | No tags attached. | ||||