View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004976 | SymmetricDS | Bug | public | 2021-05-05 15:11 | 2021-05-28 20:40 |
| Reporter | pmarzullo | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.4 | ||||
| Target Version | 3.12.10 | Fixed in Version | 3.12.10 | ||
| Summary | 0004976: MySQL: Drop trigger silently fails | ||||
| Description | When syncing triggers on MySQL, it silently fails to drop a trigger and then tries to create a trigger that already exists. The drop trigger routine gets the following message: There are triggers that have been marked as inactive. Please remove triggers represented by trigger_id=<some id> and trigger_hist_id=<some number> Reproduced by creating a database with all capital letters and configuring triggers from it. create database `ABCD` character set utf8mb4; | ||||
| Tags | dialect: mysql/mariadb, trigger | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-05-05 15:11 | pmarzullo | New Issue | |
| 2021-05-05 15:11 | pmarzullo | Tag Attached: dialect: mysql/mariadb | |
| 2021-05-05 15:11 | pmarzullo | Tag Attached: trigger | |
| 2021-05-06 12:51 | elong | Assigned To | => elong |
| 2021-05-06 12:51 | elong | Status | new => resolved |
| 2021-05-06 12:51 | elong | Resolution | open => fixed |
| 2021-05-06 12:51 | elong | Product Version | 3.12.9 => 3.12.4 |
| 2021-05-06 12:51 | elong | Fixed in Version | => 3.12.10 |
| 2021-05-06 12:51 | elong | Target Version | => 3.12.10 |
| 2021-05-06 12:51 | elong | Description Updated | View Revisions |
| 2021-05-06 12:56 | elong | Relationship added | related to 0004519 |
| 2021-05-06 13:00 | admin | Changeset attached | => SymmetricDS 3.12 4544cdce |
| 2021-05-28 20:40 | admin | Status | resolved => closed |