View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003850 | SymmetricDS | Bug | public | 2019-01-08 21:14 | 2019-02-11 21:46 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.0 | ||||
| Target Version | 3.9.17 | Fixed in Version | 3.9.17 | ||
| Summary | 0003850: On startup with Postgres 10, always alters sym_sequence | ||||
| Description | During startup, SymmetricDS will check its schema for changes and make any alterations needed. On PostgreSQL 10, it incorrect detects that the sym_sequence table needs altered. From the log: [PostgreSqlSymmetricDialect] [symmetric-engine-startup-0] DDL failed: ALTER TABLE "public"."sym_sequence" ALTER COLUMN "max_value" SET DEFAULT 9999999999 Since an alter needs a table lock, it can cause the startup to fail if the lock can't be acquired. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.8 72ebcaf5 2019-01-08 16:17:22 Details Diff |
0003850: On startup with Postgres 10, always alters sym_sequence |
Affected Issues 0003850 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/model/Column.java | Diff File | ||
|
SymmetricDS: 3.9 a4218364 2019-01-08 16:17:22 Details Diff |
0003850: On startup with Postgres 10, always alters sym_sequence |
Affected Issues 0003850 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/model/Column.java | Diff File | ||
|
SymmetricDS: 3.10 5435f62d 2019-01-08 16:17:22 Details Diff |
0003850: On startup with Postgres 10, always alters sym_sequence |
Affected Issues 0003850 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/model/Column.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-01-08 21:14 | elong | New Issue | |
| 2019-01-08 21:14 | elong | Status | new => assigned |
| 2019-01-08 21:14 | elong | Assigned To | => elong |
| 2019-01-08 21:14 | elong | Relationship added | related to 0003849 |
| 2019-01-08 21:20 | elong | Status | assigned => resolved |
| 2019-01-08 21:20 | elong | Resolution | open => fixed |
| 2019-01-08 21:20 | elong | Fixed in Version | => 3.9.17 |
| 2019-01-08 22:00 | admin | Changeset attached | => SymmetricDS 3.8 72ebcaf5 |
| 2019-01-08 22:00 | admin | Changeset attached | => SymmetricDS 3.9 a4218364 |
| 2019-01-08 22:00 | admin | Changeset attached | => SymmetricDS 3.10 5435f62d |
| 2019-02-11 21:46 | admin | Status | resolved => closed |