Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.0.23
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
- relates to
-
MDEV-20720 Galera: Replicate MariaDB GTID to other nodes in the cluster
-
- Closed
-