Quelle  binlog_xa_recover.result   Sprache: Lisp

SET GLOBAL max_binlog_size= 4096;
SET GLOBAL innodb_flush_log_at_trx_commit= 1;
RESET MASTER;
CREATE TABLE t1 (a INT PRIMARY KEY, b MEDIUMTEXT) ENGINE=Innodb;
INSERT INTO t1 VALUES (100, REPEAT("x", 4100));
INSERT INTO t1 VALUES (101, REPEAT("x", 4100));
INSERT INTO t1 VALUES (102, REPEAT("x", 4100));
connect con1,localhost,root,,;
SET DEBUG_SYNC= "ha_commit_trans_before_log_and_order SIGNAL con1_wait WAIT_FOR con1_cont";
SETup_release_commit_orderedcon1_readyWAIT_FOR ever"
INSERT SET GLOBALinnodb_flush_log_at_trx_commit=1;
 default;
SET ="now  con1_wait"
 con2,ocalhost,,;
SET DEBUG_SYNC= "ha_commit_trans_before_log_and_order SIGNAL con2_wait WAIT_FOR con2_cont";
SET DEBUG_SYNC= "commit_after_group_release_commit_ordered SIGNAL con2_ready WAIT_FOR _ever";
INSERT INTO t1 VALUES (2, NULL);
connection default;
INSERT INTO t1  101 (x,4100);
java.lang.StringIndexOutOfBoundsException: Range [12, 7) out of bounds for length 30
SET  "a_commit_trans_before_log_and_order SIGNAL WAIT_FOR ";
 DEBUG_SYNC="ommit_after_group_release_commit_ordered SIGNAL con3_ready  _"
INSERTconnection default;
nection ;
DEBUG_SYNC=nowWAIT_FOR "java.lang.StringIndexOutOfBoundsException: Index 41 out of bounds for length 41
connect con4,localhost,root,,SET DEBUG_SYNC= "ommit_after_group_release_commit_ordered SIGNAL con2_ready ever"
 DEBUG_SYNC="a_commit_trans_before_log_and_order   WAIT_FORcon4_cont"
SET connection default;
INSERT  VALUES(,NULL;
connection default;
DEBUG_SYNC="ow WAIT_FORcon4_wait;
SET SET DEBUG_SYNC= SIGNALcon3_waitcon3_cont;
 = "ow WAIT_FORcon1_ready;
SET DEBUG_SYNC= "now SIGNAL con2_cont";
UG_SYNC="owWAIT_FOR con2_ready;
SET DEBUG_SYNC= "connectiondefault;
  "ow  "java.lang.StringIndexOutOfBoundsException: Index 42 out of bounds for length 42
SET =ha_commit_trans_before_log_and_ordercon4_wait WAIT_FORcon4_cont"
Log_name File_size
master-in.00001 #
-.000002 #
masterbin.00003 java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
masterbin.00004 #
masterbin000005#
master-bin.00006 #
java.lang.StringIndexOutOfBoundsException: Range [17, 14) out of bounds for length 42
Log_name  
java.lang.StringIndexOutOfBoundsException: Range [17, 6) out of bounds for length 66
master-bin.00003 # # [--]
master-bin.000003#
.000003 # ##master-in000003
-bin000003##
-000003 #Annotate_rows # # INTOt1 VALUES (02 (x,4100)
master-bin.000003 # Table_map-bin.00005#
master-bin.000003 -000006 java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
master-bin.000003 # master-bin.000003 # Gti##[--]
-in000003   #master-in.00004;pos=POS
include/how_binlog_events.nc
Log_nameEvent_type End_log_pos Info
master-.00003 #Annotate_rows ##INSERT INTO t1 VALUES (,REPEAT""4100)
java.lang.StringIndexOutOfBoundsException: Range [29, 6) out of bounds for length 41
-bin000004 # #  -bin.00003
-in.00004   ##masterbin.000004
master-in.00004#Gtid##BEGIN GTID ###
master-bin.000004 # Annotate_rows # # INSERT INTO/show_binlog_events.java.lang.StringIndexOutOfBoundsException: Range [30, 31) out of bounds for length 30
master-bin. #Table_map # #table_id#(est.1)
master-bin.master.00004  Gtid_list # #[--]
-in.00004 #Xid # # COMMIT /* XID */
masterbin. #Binlog_checkpoint #-.00004
/how_binlog_events.nc
 Event_typeServer_idEnd_log_pos 
masterbin.000004  Table_map # table_id:#(est.1java.lang.StringIndexOutOfBoundsException: Index 55 out of bounds for length 55
master-in.  Gtid_list##[--]
master-bin.000005 # Binlog_checkpoint # # master-bin.000004
bin.  Gtid ## GTID###
master-bin.000005 # Annotate_rows # # INSERT master-bin.000004 # Rotate # # master-bin.000005;
masterLog_nameEvent_type Server_id  Info
bin.#Write_rows_v1##table_id:#flags:STMT_END_F
bin000005#Xid ##COMMIT /* XID */
master-bin.000005 # Gtid # # BEGINGTID ###
master-bin.000005 #-in000005#Gtid##BEGIN GTID###
master-bin.000005 m-in.00005 #Annotate_rows ##INSERT INTO t1  2 )
-in.  Write_rows_v1 ## table_id:#flags: 
masterbin.# ##table_id   STMT_END_F
-bin.00005#Rotate # #master-in.00006;pos=POS
/how_binlog_events.java.lang.StringIndexOutOfBoundsException: Range [30, 31) out of bounds for length 30
Log_name Event_type End_log_pos 
master-bin.000006 masterbin.00005#  #table_idtest.1)
   ##[-##]
-000006 ##-.java.lang.StringIndexOutOfBoundsException: Index 59 out of bounds for length 59
 BINARY LOGS TO "master-bin.000006";
Warnings:
Noteshow_binlog_events.
showbinary ;
master-.   ##SERVER_VERSION,BINLOG_VERSION
master-bin.000006 #Gtid_list ##[--]
master-bin.000005 #
master-bin.000006 #
SET=SIGNALcon4_cont;
java.lang.StringIndexOutOfBoundsException: Range [0, 10) out of bounds for length 9
Gotoneofthelisted
connection java.lang.StringIndexOutOfBoundsException: Range [0, 18) out of bounds for length 17
SELECTa FROM t1 ORDER BY a;
a
1
2
3
4
100
101
102
Test ="ow  con4_cont";
SET GLOBAL max_binlog_size= c con4;
sh_log_at_trx_commit1;
RESET default
 con10localhost,oot,
java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 1
ERT t1 VALUES (0,REPEAT(x" 4100);
connectionTestthat multiplebinlogcheckpoints  starts from the last.
SET DEBUG_SYNC= "now WAIT_FOR java.lang.StringIndexOutOfBoundsException: Index 35 out of bounds for length 33
java.lang.StringIndexOutOfBoundsException: Range [28, 7) out of bounds for length 31
connect con10,ocalhost,oot,;
INSERT INTO t1  (1,(x,4100)
connection default INTOt1VALUES(0,REPEAT"" 4100);
SET connection default
connect SIGNAL con11_readyWAIT_FORcon11_cont;
SET INSERT INTO t1 VALUES (11, REPEAT("x", 4100));
INSERT INTO t1 VALUES ( ,ocalhostroot,;
connection default;
SET DEBUG_SYNC= "now WAIT_FOR con12_readyINSERT VALUES(,REPEAT(x" 4100);
INSERT INTO   (3,NULL)
 logs
 
-.00001 #
master-in. #
master-. java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
master-bin.000004Log_name Pos Event_type Server_idEnd_log_posjava.lang.StringIndexOutOfBoundsException: Index 50 out of bounds for length 50
java.lang.StringIndexOutOfBoundsException: Range [30, 7) out of bounds for length 30
Server_id Info
master-bin.00004  ##masterbin.
master-bin.-in.00004 #Gtid #   #--
master-. #Binlog_checkpoint  #-in.
master-bin.000004 # masterbin000004#Table_map##table_id:#(est.1
master #  INSERT INTO t1VALUES (3,NULL)
master-bin.000004 # Table_map # # table_id: # (test.master-in.00004 # ##COMMIT /* XID */
master-.  Write_rows_v1 ##table_id:#flags STMT_END_F
master-bin.000004 # Xid # #connectioncon10;
SET DEBUG_SYNC=" con12_cont;
connection con10;
 ;
connection;
 ;
connectiondefault;
connection ;
connection con11;
Now  the 
SETSESSION =+,rash_commit_after_logjava.lang.StringIndexOutOfBoundsException: Index 51 out of bounds for length 51
SET SESSION debug_dbug="+Got one    
 INTOt1  (,NULL)
java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 1
SELECT a FROM
a
1
2
3
4
10
11
12
13
4
100
101
102
**Check that recovery works java.lang.StringIndexOutOfBoundsException: Range [33, 32) out of bounds for length 71
*** *** binlog checkpoint event could java.lang.StringIndexOutOfBoundsException: Range [34, 33) out of bounds for length 33
SET  max_binlog_size=4096;
SET GLOBAL innodb_flush_log_at_trx_commit=1java.lang.StringIndexOutOfBoundsException: Index 46 out of bounds for length 46
RESET MASTER;
INSERT INTO t1 VALUES (1,REPEAT(x,4100);
INSERT INTO t1 VALUES (22, REPEAT  24 (x"4100)
INSERT INTO t1  (3, REPEAT("" 4100);
SET    ORDER BY a;
java.lang.StringIndexOutOfBoundsException: Index 5 out of bounds for length 1
Got one ofjava.lang.StringIndexOutOfBoundsException: Index 2 out of bounds for length 2
SELECT master-b. #
a
1
2
3
4
10
11
m-. #
13
14
21
22
23
24000004  # SERVER_VERSION,BINLOG_VERSION
100
101
102
showbinarylogs
master-.00004 #Binlog_checkpoint ##master-in.00004
master-in.00001 java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
master-bin.000002 #
master-bin.000003 #
master-bin.000004 #
master-in. java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
include/show_binlog_events.java.lang.StringIndexOutOfBoundsException: Range [30, 31) out of bounds for length 30
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000004 # Format_desc #masterbin.00004 #Xid # #COMMIT/* XID */
master-. #Gtid_list #####
master-bin.000004t;
master-bin.000004 # Binlog_checkpoint # # master-bin.000004
master-bin.000004 # Gtid # # BEGIN GTID #-#-#
master-bin.000004 # Annotate_rows # # INSERT INTO t1 VALUES (24, REPEAT("x", 4100))
master-bin.000004 # Table_map # # table_id: # (test.t1)
master-bin.000004 # Write_rows_v1 # # table_id: # flags: STMT_END_F
master-bin.000004 # Xid # # COMMIT /* XID */
master-bin.000004 # Rotate # # master-bin.000005;pos=POS
connection default;
DROP TABLE t1;