[MDEV-21578] CREATE OR REPLACE TRIGGER in Galera cluster not replicating Created: 2020-01-27 Updated: 2020-10-06 Resolved: 2020-08-28 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Galera, Triggers |
| Affects Version/s: | 10.2, 10.3, 10.4, 10.5 |
| Fix Version/s: | 10.2.35, 10.3.26, 10.4.16, 10.5.7 |
| Type: | Bug | Priority: | Major |
| Reporter: | Immanuel | Assignee: | Jan Lindström (Inactive) |
| Resolution: | Fixed | Votes: | 2 |
| Labels: | create, galera, replace, replication, triggers | ||
| Environment: |
Ubuntu, Galera cluster with 3 nodes, MariaDB version 10.4.1, wsrep_patch_version: wsrep_622 |
||
| Issue Links: |
|
||||||||
| Description |
|
When I execute this Statements: And than (I change the Value which i assign to the NEW.id to 200): The change to the trigger is only on one node of the galera cluster. The other nodes still have the old trigger definition, which assignes NEW.id the value of 100. Looking in the mysqld.log of one of the nodes which did not replicate, I get the following error message: TL/TD: |
| Comments |
| Comment by Fabrykowski [ 2020-08-28 ] |
|
Any news on this bug? The same phenomenon can be observed, when trying to drop a trigger. I have set up an MWE demonstrating it: fabrykowski/galera_drop_trigger_mwe |