View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005673 | SymmetricDS | Improvement | public | 2023-01-31 18:57 | 2023-02-01 15:44 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.0 | ||||
| Target Version | 3.14.5 | Fixed in Version | 3.14.5 | ||
| Summary | 0005673: Sync triggers fails with deadlock on SQL-Server | ||||
| Description | On SQL-Server, if the mssql.trigger.order.first parameter is used, it will query system tables to see if there is any existing trigger ordered as first. The query can get a deadlock with other queries on the same system table because of the isolation used on the query. | ||||
| Tags | trigger | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-01-31 18:57 | elong | New Issue | |
| 2023-01-31 18:57 | elong | Status | new => assigned |
| 2023-01-31 18:57 | elong | Assigned To | => elong |
| 2023-01-31 18:57 | elong | Tag Attached: trigger | |
| 2023-01-31 18:57 | elong | Issue generated from: 0005672 | |
| 2023-01-31 18:57 | elong | Relationship added | related to 0005672 |
| 2023-01-31 18:57 | elong | Status | assigned => resolved |
| 2023-01-31 18:57 | elong | Resolution | open => fixed |
| 2023-01-31 18:57 | elong | Fixed in Version | => 3.14.5 |
| 2023-02-15 20:26 | admin | Status | resolved => closed |