View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004900 | SymmetricDS | Bug | public | 2021-03-16 21:01 | 2021-03-30 19:46 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.7 | ||||
| Target Version | 3.12.8 | Fixed in Version | 3.12.8 | ||
| Summary | 0004900: Symmetric upgrade with Firebird database fails to upgrade when upgrading to 3.12 | ||||
| Description | When upgrading SymmetricDS to 3.12, and the database type is Firebird, the startup of the upgraded software fails to run because it is unable to drop two columns from the sym_node table because the triggers on that table are not removed first. Firebird stops the drop of the columns because of the trigger text that references the two columns. The ultimate problem is that the code that drops the triggers as a result of the database upgrade listener trying to upgrade the symmetric tables does not execute for the symmetric tables. The code searches in sym_trigger for the existence of trigger definitions on the symmetric tables, but the trigger definitions are not stored in the sym_trigger table, but they are dynamically created in the code. The code needs to look up the existence of triggers in sym_trigger_hist table for the symmetric tables. | ||||
| Steps To Reproduce | 1. Install version of SymmetricDS before 3.12. 2. Create a Firebird database node. 3. Upgrade to the 3.12 software. 4. Run the instance. | ||||
| Tags | dialect: firebird, upgrade | ||||
|
SymmetricDS: 3.12 91b68ab0 2021-03-16 21:04:40 Details Diff |
0004900: Symmetric upgrade with Firebird database fails to upgrade when upgrading to 3.12 |
Affected Issues 0004900 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterServiceSqlMap.java | Diff File | ||
|
SymmetricDS: 3.12 b7d25d43 2021-03-17 12:52:49 Details Diff |
0004900: Symmetric upgrade with Firebird database fails to upgrade when upgrading to 3.12 |
Affected Issues 0004900 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterServiceSqlMap.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-03-16 21:01 | pmarzullo | New Issue | |
| 2021-03-16 21:01 | pmarzullo | Status | new => assigned |
| 2021-03-16 21:01 | pmarzullo | Assigned To | => pmarzullo |
| 2021-03-16 21:01 | pmarzullo | Tag Attached: dialect: firebird | |
| 2021-03-16 21:01 | pmarzullo | Tag Attached: upgrade | |
| 2021-03-16 21:05 | pmarzullo | Status | assigned => resolved |
| 2021-03-16 21:05 | pmarzullo | Resolution | open => fixed |
| 2021-03-16 21:05 | pmarzullo | Fixed in Version | => 3.12.8 |
| 2021-03-16 22:00 | pmarzullo | Changeset attached | => SymmetricDS 3.12 91b68ab0 |
| 2021-03-17 13:00 | pmarzullo | Changeset attached | => SymmetricDS 3.12 b7d25d43 |
| 2021-03-30 19:46 | admin | Status | resolved => closed |