View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004352 | SymmetricDS | Improvement | public | 2020-04-16 15:04 | 2020-06-04 17:55 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.0 | Fixed in Version | 3.12.0 | ||
| Summary | 0004352: Sybase dialect should enable row locking and set identity gap | ||||
| Description | Sybase dialect should enable row-level locking on runtime tables, similar to what SQL-Server dialect is doing today: alter table sym_data lock datarows alter table sym_data_event lock datarows alter table sym_outgoing_batch lock datarows Sybase dialect should set the identity gap on sym_data to a reasonable number of IDs to skip when recycling the server. When Sybase recycles, it can by default skip millions of IDs that causes routing to stop moving forward. sp_chgattribute sym_data, 'identity_gap', 1000 | ||||
| Tags | dialect: sybase | ||||
|
SymmetricDS: 3.12 900b6515 2020-04-28 16:44:04 Details Diff |
0004352: Sybase dialect should enable row locking and set identity gap |
Affected Issues 0004352 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/ase/AseSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java | Diff File | ||
| mod - symmetric-core/src/main/resources/symmetric-default.properties | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-04-16 15:04 | elong | New Issue | |
| 2020-04-28 18:13 | elong | Tag Attached: dialect: sybase | |
| 2020-04-28 20:45 | elong | Assigned To | => elong |
| 2020-04-28 20:45 | elong | Status | new => resolved |
| 2020-04-28 20:45 | elong | Resolution | open => fixed |
| 2020-04-28 20:45 | elong | Product Version | 3.11.0 => 3.12.0 |
| 2020-04-28 20:45 | elong | Fixed in Version | => 3.12.0 |
| 2020-04-28 20:45 | elong | Target Version | => 3.12.0 |
| 2020-05-26 18:48 | elong | Status | resolved => closed |
| 2020-06-04 17:55 | admin | Changeset attached | => SymmetricDS 3.12 900b6515 |