View Issue Details

IDProjectCategoryView StatusLast Update
0004976SymmetricDSBugpublic2021-05-28 20:40
Reporterpmarzullo Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.4 
Target Version3.12.10Fixed in Version3.12.10 
Summary0004976: MySQL: Drop trigger silently fails
DescriptionWhen 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;
Tagsdialect: mysql/mariadb, trigger

Relationships

related to 0004519 closedpmarzullo Database name with special character like minus sign, fails to create trigger when in same database 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 4544cdce

2021-05-06 12:51:42

admin

Details Diff
0004976: MySQL: Drop trigger silently fails Affected Issues
0004976
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mysql/MySqlSymmetricDialect.java Diff File

Issue History

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