View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006289 | SymmetricDS Pro | Bug | public | 2024-03-12 20:05 | 2024-03-12 20:08 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.4 | Fixed in Version | 3.15.4 | ||
| Summary | 0006289: Compare request can't update status, loops creating new request IDs | ||||
| Description | The Compare Service is unable to update the compare request with a request ID and mark it as processed when using the jTDS driver (for SQL-Server and Sybase ASE). In the log, it can be seen processing the same compare request over and over: 2024-03-12 10:41:52,487 INFO [server] [CompareService] [server-job-1] Found 1 compare requests to process, thread pool size is 10 with demand of 0 2024-03-12 10:41:52,502 INFO [server] [CompareService] [server-job-1] Creating compare request 44 from node 'server' to node '1' for 1 tables 2024-03-12 10:41:54,511 INFO [server] [CompareService] [server-job-1] Found 1 compare requests to process, thread pool size is 10 with demand of 0 2024-03-12 10:41:54,534 INFO [server] [CompareService] [server-job-1] Creating compare request 45 from node 'server' to node '1' for 1 tables Two known workarounds: 1) Switch to the vendor-specific driver, such as Microsoft JDBC driver, which is now the supported driver going forward. jTDS is considered legacy. 2) Manually insert the request into sym_compare_request, and use a create_time with the millis set to 0. | ||||
| Tags | compare repair | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-03-12 20:05 | elong | New Issue | |
| 2024-03-12 20:05 | elong | Status | new => assigned |
| 2024-03-12 20:05 | elong | Assigned To | => elong |
| 2024-03-12 20:05 | elong | Tag Attached: compare repair | |
| 2024-03-12 20:08 | elong | Status | assigned => resolved |
| 2024-03-12 20:08 | elong | Resolution | open => fixed |
| 2024-03-12 20:08 | elong | Fixed in Version | => 3.15.4 |
| 2024-03-19 16:20 | admin | Status | resolved => closed |