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

Xid is only shown for RBR events

    XMLWordPrintable

Details

    Description

      We use Xid to failover a asynchronous slave to a different Galera master. Some users have automated scripts to do this as well.

      With RBR events the Xid is shown at the bottom of a transaction. With SBR events it it is not shown. Please change this so Xid is always shown in mysqlbinlog output.

      #151222 17:51:03 server id 10  end_log_pos 1166         Query   thread_id=35728 exec_time=0     error_code=0
      use `mariadb_test_7`/*!*/;
      SET TIMESTAMP=1450803063/*!*/;
      create table testy (id serial)
      /*!*/;
      # at 1166
      #151222 17:51:08 server id 10  end_log_pos 1204         GTID 0-10-7
      /*!100001 SET @@session.gtid_seq_no=7*//*!*/;
      BEGIN
      /*!*/;
      # at 1204
      # at 1258
      #151222 17:51:08 server id 10  end_log_pos 1258         Table_map: `mariadb_test_7`.`testy` mapped to number 80
      #151222 17:51:08 server id 10  end_log_pos 1296         Write_rows: table id 80 flags: STMT_END_F
       
      BINLOG '
      fH95VhMKAAAANgAAAOoEAAAAAFAAAAAAAAEADm1hcmlhZGJfdGVzdF83AAV0ZXN0eQABCAAA
      fH95VhcKAAAAJgAAABAFAAAAAFAAAAAAAAEAAf/+AwAAAAAAAAA=
      '/*!*/;
      ### INSERT INTO `mariadb_test_7`.`testy`
      ### SET
      ###   @1=3 /* LONGINT meta=0 nullable=0 is_null=0 */
      # at 1296
      #151222 17:51:08 server id 10  end_log_pos 1323         Xid = 153192
      COMMIT/*!*/;
      # at 1323

      Attachments

        Issue Links

          Activity

            People

              sachin.setiya.007 Sachin Setiya (Inactive)
              michaeldg Michaël de groot
              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.