View Revisions: Issue #4976
| Summary | 0004976: MySQL: Drop trigger silently fails | ||
|---|---|---|---|
| Revision | 2021-05-06 12:51 by elong | ||
| 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; |
||
| Revision | 2021-05-05 15:11 by pmarzullo | ||
| Description | Log indicates: There are triggers that have been marked as inactive. Please remove triggers represented by trigger_id=<some id> and trigger_hist_id=<some number> May be a problem with case regarding the database name and maybe the trigger name. |
||