View Issue Details

IDProjectCategoryView StatusLast Update
0003849SymmetricDSBugpublic2019-02-11 16:28
ReporterelongAssigned 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.

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