View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006270 | SymmetricDS | Bug | public | 2024-03-01 15:46 | 2024-04-19 15:46 |
| Reporter | emiller | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.4 | Fixed in Version | 3.15.4 | ||
| Summary | 0006270: Prevent OracleSymmetricDialect from underestimating the current value of a sequence | ||||
| Description | It isn't possible to get the currval of a sequence on Oracle without calling nextval first in the same session. Because of this, OracleSymmetricDialect estimates the current value using the user_sequences view. Currently, it subtracts the cache_size from the last_number which can cause it to underestimate the current value of the sequence. It would be best to avoid this because it causes alerts to go off in SymmetricDS Pro, as it makes it seem like the next data_id is outside of any data gap. | ||||
| Tags | dialect: oracle | ||||
|
SymmetricDS: 3.15 93343e41 2024-03-01 15:50:42 evan-miller-jumpmind Details Diff |
0006270: Prevented OracleSymmetricDialect from underestimating the current value of a sequence |
Affected Issues 0006270 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleSymmetricDialect.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-03-01 15:46 | emiller | New Issue | |
| 2024-03-01 15:46 | emiller | Status | new => assigned |
| 2024-03-01 15:46 | emiller | Assigned To | => emiller |
| 2024-03-01 15:46 | emiller | Tag Attached: dialect: oracle | |
| 2024-03-01 15:46 | emiller | Issue generated from: 0006269 | |
| 2024-03-01 15:46 | emiller | Relationship added | related to 0006269 |
| 2024-03-01 15:51 | emiller | Status | assigned => resolved |
| 2024-03-01 15:51 | emiller | Resolution | open => fixed |
| 2024-03-01 15:51 | emiller | Fixed in Version | => 3.15.4 |
| 2024-03-19 16:20 | admin | Status | resolved => closed |
| 2024-04-19 15:46 | Changeset attached | => SymmetricDS 3.15 93343e41 |