View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004341 | SymmetricDS | Bug | public | 2020-04-09 19:38 | 2020-04-21 19:02 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.7 | ||||
| Target Version | 3.11.8 | Fixed in Version | 3.11.8 | ||
| Summary | 0004341: MySQL: Drop of transaction function when database upgrade occurs is happening after the create of the database objects | ||||
| Description | When the issue (4318, https://www.symmetricds.org/issues/view.php?id=4318) changed the order of execution from schema changes then database objects to database objects then schema changes, it broke MySQL. In DatabaseUpgradeListener, there is functionality to remove the MySQL transaction function when database upgrade is executing, expecting that the creation of the database objects is run after the schema changes. The reason that this was done was because there was a point in time (issue 3045, https://www.symmetricds.org/issues/view.php?id=3045) that changed the deployed MySQL function, and so in order to get the updated function definition, the DatabaseUpgradeListener was coded to remove that function. This doesn't work anymore. Let's try instead to execute the following functionality during the database object creation: check to see if the expected function body is different than the installed function body. If it is different, then drop the function, and install the new function. | ||||
| Tags | ddl/schema, dialect: mysql/mariadb | ||||
|
SymmetricDS: 3.11 5c1da1e6 2020-04-10 13:53:56 Philip Marzullo Details Diff |
0004341: MySQL: Drop of transaction function when database upgrade occurs is happening after the create of the database objects |
Affected Issues 0004341 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mysql/MySqlSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/DatabaseUpgradeListener.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-04-09 19:38 | pmarzullo | New Issue | |
| 2020-04-09 19:38 | pmarzullo | Status | new => assigned |
| 2020-04-09 19:38 | pmarzullo | Assigned To | => pmarzullo |
| 2020-04-09 19:38 | pmarzullo | Tag Attached: ddl/schema | |
| 2020-04-09 19:38 | pmarzullo | Tag Attached: dialect: mysql/mariadb | |
| 2020-04-10 17:54 | pmarzullo | Status | assigned => resolved |
| 2020-04-10 17:54 | pmarzullo | Resolution | open => fixed |
| 2020-04-10 17:54 | pmarzullo | Fixed in Version | => 3.11.8 |
| 2020-04-10 18:00 | Changeset attached | => SymmetricDS 3.11 5c1da1e6 | |
| 2020-04-21 19:02 | admin | Status | resolved => closed |