View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004024 | SymmetricDS | Improvement | public | 2019-06-20 19:15 | 2022-12-13 13:22 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | duplicate | ||
| Product Version | 3.14.0 | ||||
| Summary | 0004024: When instance comes up, if in cluster mode and auto.config.database is true, should get lock before updating database | ||||
| Description | More 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. | ||||
| Tags | cluster | ||||
| duplicate of | 0003280 | new | SymmetricDS servers fail to start in cluster due to sym schema upgrade race condition |
| 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 | |
| 2021-11-16 20:28 | elong | Target Version | 3.13.0 => 3.13.1 |
| 2021-12-11 17:10 | admin | Target Version | 3.13.1 => 3.12.14 |
| 2021-12-20 13:55 | admin | Target Version | 3.12.14 => 3.12.15 |
| 2022-01-12 19:30 | elong | Product Version | 3.10.2 => 3.14.0 |
| 2022-01-12 19:30 | elong | Target Version | 3.12.15 => 3.14.0 |
| 2022-07-25 16:30 | elong | Target Version | 3.14.0 => 3.14.1 |
| 2022-08-24 18:56 | elong | Target Version | 3.14.1 => 3.14.2 |
| 2022-10-03 14:41 | elong | Target Version | 3.14.2 => |
| 2022-12-13 13:22 | pmarzullo | Assigned To | => pmarzullo |
| 2022-12-13 13:22 | pmarzullo | Status | new => closed |
| 2022-12-13 13:22 | pmarzullo | Resolution | open => duplicate |
| 2022-12-13 13:22 | pmarzullo | Note Added: 0002241 | |
| 2022-12-13 13:22 | pmarzullo | Relationship replaced | duplicate of 0003280 |