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

Impact of slave_run_trigger_for_rbr

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 10.1.1
    • N/A
    • Replication
    • None
    • Linux 2.6.32-220.17.1.el6.x86_64 #1 SMP Wed May 16 00:01:37 BST 2012 x86_64 x86_64 x86_64 GNU/Linux

    Description

      When slave_run_trigger_for_rbr is set to logging on the slave, does it mean triggers can be fired only on the slave? In our test case it works when the trigger is on the slave, but we do have users who has triggers on master as well and we hope it can work on both cases, but right now it looks like the change made by triggers on master can not be replicated to the slave, we get an error
      Last_SQL_Error: Could not execute Write_rows_v1 event on table tsom.z; Can't update table 'xx' in stored function/trigger because it is already used by statement which invoked this stored function/trigger., Error_code: 1442; handler error HA_ERR_GENERIC; the event's master log mysql-bin.000045, end_log_pos 2776

      the master is on MySQL 5.5.39 while the slave is on MariaDB 10.1.1.

      mysql 00:08:45 [PA1 DEV 001] [tsom] [3101]> select @@version;
      +---------------------------------+
      | @@version                       |
      +---------------------------------+
      | 5.5.39-tokudb-7.5.0-MariaDB-log |
      +---------------------------------+
      mysql 00:09:02 [PA1 DEV 001] [tsom] [3108]> select @@version;
      +--------------------------+
      | @@version                |
      +--------------------------+
      | 10.1.1-MariaDB-wsrep-log |
      +--------------------------+

      Is this working as designed?

      Thank you.

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            dyan Daisy Yan
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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