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

              • Assignee:
                sachin.setiya.007 Sachin Setiya
                Reporter:
                michaeldg Michaël de groot (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: