Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-40104

Triggers after startup/before shutdown are replicated as ENABLEd, which may lead to divergence

    XMLWordPrintable

Details

    • Q3/2026 Server Maintenance

    Description

      bb-13.0-MDEV-30645 a51f81628b0cc9b74d0b

      --source include/master-slave.inc
      --connection master
      CREATE TABLE t (a INT) ENGINE=MyISAM;
      CREATE TRIGGER trg_su AFTER STARTUP INSERT INTO test.t VALUES (1);
      --sync_slave_with_master
       
      --connection slave
      SELECT name,kind,status FROM mysql.event WHERE name='trg_su';
       
      --let $rpl_server_number= 2
      --source include/rpl_restart_server.inc
       
      --connection slave
       
      SELECT a  FROM t;
      --connection master
      SELECT a FROM t;
      

      SELECT a  FROM t;
      a
      1
      connection master;
      SELECT a FROM t;
      a
      

      Attachments

        Issue Links

          Activity

            People

              shulga Dmitry Shulga
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 4d
                  4d
                  Remaining:
                  Remaining Estimate - 4d
                  4d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.