View Issue Details

IDProjectCategoryView StatusLast Update
0003849SymmetricDSBugpublic2019-02-11 21:28
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.8.0 
Target Version3.8.42Fixed in Version3.8.42 
Summary0003849: 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 0003850 closedelong On startup with Postgres 10, always alters sym_sequence 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-01-08 21:02 elong New Issue
2019-01-08 21:02 elong Status new => assigned
2019-01-08 21:02 elong Assigned To => elong
2019-01-08 21:14 elong Relationship added related to 0003850
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.8.42
2019-02-11 21:28 admin Status resolved => closed