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.
TagsNo tags attached.

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