View Issue Details

IDProjectCategoryView StatusLast Update
0003850SymmetricDSBugpublic2019-02-11 16:46
ReporterelongAssigned Toelong 
Prioritynormal 
Status closedResolutionfixed 
Product Version3.9.0 
Target Version3.9.17Fixed in Version3.9.17 
Summary0003850: On startup with Postgres 10, always alters sym_sequence
DescriptionDuring 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.

Relationships

related to 0003849 closedelong On startup with Postgres 10, always alters sym_sequence 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.8 72ebcaf5

2019-01-08 16:17:22

admin

Details Diff
0003850: On startup with Postgres 10, always alters sym_sequence
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

admin

Details Diff
0003850: On startup with Postgres 10, always alters sym_sequence
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

admin

Details Diff
0003850: On startup with Postgres 10, always alters sym_sequence
0003850
mod - symmetric-db/src/main/java/org/jumpmind/db/model/Column.java Diff File

Issue History

Date Modified Username Field Change
2019-01-08 16:14 elong New Issue
2019-01-08 16:14 elong Status new => assigned
2019-01-08 16:14 elong Assigned To => elong
2019-01-08 16:14 elong Relationship added related to 0003849
2019-01-08 16:20 elong Status assigned => resolved
2019-01-08 16:20 elong Resolution open => fixed
2019-01-08 16:20 elong Fixed in Version => 3.9.17
2019-01-08 17:00 admin Changeset attached => SymmetricDS 3.8 72ebcaf5
2019-01-08 17:00 admin Changeset attached => SymmetricDS 3.9 a4218364
2019-01-08 17:00 admin Changeset attached => SymmetricDS 3.10 5435f62d
2019-02-11 16:46 admin Status resolved => closed