View Issue Details

IDProjectCategoryView StatusLast Update
0004024SymmetricDSImprovementpublic2020-07-22 17:47
Reporterpmarzullo Assigned To 
Status newResolutionopen 
Product Version3.10.2 
Target Version3.13.0 
Summary0004024: When instance comes up, if in cluster mode and auto.config.database is true, should get lock before updating database
DescriptionMore than one node in a SymmetricDS cluster should not attempt to configure the database at the same time.

Many times there are longer running steps to modify the database (e.g., primary key change requires moving data to a temporary table, drop the original table, recreate the modified table, and move the data to the new table).

If SymmetricDS is running in a cluster (cluster.lock.enabled=true) and automatic configuration of the database is set to true (auto.config.database=true), then before executing the check of the DDL changes and the execution of the DDL changes, the node should retrieve a cluster lock. It should not continue on until it successfully gets a cluster lock.

The first one in the cluster that gets the lock will execute any DDL changes necessary, and all others that follow will check and see no changes to execute.


related to 0003280 new SymmetricDS servers fail to start in cluster due to sym schema upgrade race condition 


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-06-20 19:15 pmarzullo New Issue
2019-11-14 19:50 elong Target Version 3.11.0 => 3.11.1
2019-12-02 20:13 admin Target Version 3.11.1 => 3.11.2
2019-12-09 15:25 admin Target Version 3.11.2 => 3.11.3
2020-01-02 15:10 admin Target Version 3.11.3 => 3.11.4
2020-01-08 13:49 elong Relationship added related to 0003280
2020-01-20 21:11 elong Target Version 3.11.4 => 3.12.0
2020-05-26 12:27 elong Target Version 3.12.0 => 3.13.0
2020-07-22 17:47 elong Tag Attached: cluster