Quelle  binlog_xa_recover.result   Sprache: Lisp

SET GLOBAL  DEBUG_SYNC= "commit_after_gro SIGNAL con1_ready  _ver"
  innodb_flush_log_at_trx_commit=1;
RESETconnection default;
SET DEBUG_SYNC nowWAIT_FORcon1_wait;
connect con2,ocalhost,oot,java.lang.StringIndexOutOfBoundsException: Index 30 out of bounds for length 30
 INTO t1 VALUES(,REPEAT"",4100);
INSERT connect con3,localhost,root,,;
connect con1,localhost,root,,;
SET DEBUG_SYNC= "ha_commit_trans_before_log_and_order SIGNAL con1_wait WAIT_FOR con1_cont";
SET DEBUG_SYNCDEBUG_SYNC=ha_commit_trans_before_log_and_orderSIGNALcon3_wait con3_cont
INSERT INTOSET DEBUG_SYNC="ommit_after_group_release_commit_ordered  con3_readyWAIT_FOR _ver;
connection default;
con default
SET =" WAIT_FOR con3_wait;
SET DEBUG_SYNC= "ha_commit_trans_before_log_and_order SIGNAL con2_wait WAIT_FOR con2_cont";
SET DEBUG_SYNC= "ommit_after_group_release_commit_ordered SIGNAL con2_ready WAIT_FOR_ver"
INSERT INTO t1SET DEBUG_SYNC="a_commit_trans_before_log_and_order SIGNALcon4_wait con4_cont"
 default;
SET DEBUG_SYNC= INSERTINTOt1  4 )
SET DEBUG_SYNC="ow  "
SET DEBUG_SYNC= "ha_commit_trans_before_log_and_order con3_wait WAIT_FOR "
SETDEBUG_SYNC= "ow WAIT_FOR "java.lang.StringIndexOutOfBoundsException: Index 42 out of bounds for length 42
INSERT UG_SYNC="ow  con2_ready"
 default
SET DEBUG_SYNCSETDEBUG_SYNC="ow WAIT_FORcon3_ready;
connect con4,localhost,root,,;
DEBUG_SYNC " SIGNAL  WAIT_FOR con4_cont"
SET SESSION File_size
INSERTmaster-in.00001 #
masterbin000002 #
SET-.00003#
SET DEBUG_SYNC= "now SIGNAL con1_cont";
master-.00004#
SETmaster--. #
master-bin.00006 #
SETinclude/show_binlog_events.inc
SET DEBUG_SYNC= "now WAIT_FOR con3_ready";
showbinarylogs;
Log_name master-bin.000003 # Format_desc # bin.00003 #Gtid_list##[--]

master-master-bin000003 #Binlog_checkpoint##master-.000003
masterbin. #Gtid # # BEGIN GTID #-#-
masterbin. #Annotate_rows # #INSERT INTO  VALUES (02,REPEAT"" )java.lang.StringIndexOutOfBoundsException: Index 84 out of bounds for length 84
master.00005 java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
masterbin.000006#
include/show_binlog_events.inc
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000003 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
d_list ##[--]
master-bin.master-. #Rotate##master-in.00004;pos=POS
master-bininclude/how_binlog_events.nc
master Pos  Server_idEnd_log_pos Info
master-in.00003 #Annotate_rows ##102 (x, ))
master-bin.000003 # master-bin.000004 # Gtid_list # # [#-#-#]
master.000004 #Binlog_checkpoint #masterbin.00003
mastermaster-in.00004#Binlog_checkpoint #master-000004
master-in.00004 #    BEGIN GTID -#java.lang.StringIndexOutOfBoundsException: Index 45 out of bounds for length 45
includeshow_binlog_events.nc
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000004 # Format_desc # #-bin000004#Table_map # #table_id: #(est.1)
-bin.00004 #Gtid_list ####
master-bin.000004master-.00004 #Xid # # COMMIT /* XID */
-000004 Binlog_checkpoint ##masterbin.00004
include/how_binlog_events.
Log_namePos   End_log_posInfo
-bin.000004#Table_map ##table_id:#(est.1)
master-bin.000004 # Write_rows_v1 # # table_id-in000005# ##[--java.lang.StringIndexOutOfBoundsException: Index 41 out of bounds for length 41
master-bin.000004 # master-000005#Gtid ##BEGINGTID --java.lang.StringIndexOutOfBoundsException: Index 45 out of bounds for length 45
pos=POS
include/show_binlog_events.inc
 Pos Event_type Server_id End_log_pos
master-.000005  ##table_id:#flags:STMT_END_F
master-. #Xid # COMMIT /* XID */
master GTID ##java.lang.StringIndexOutOfBoundsException: Index 45 out of bounds for length 45
master-in. #Gtid    GTID --java.lang.StringIndexOutOfBoundsException: Index 45 out of bounds for length 45
aster-in.00005 #Annotate_rows ##INSERT INTO t1 VALUES(,NULL
master-bin.000005 master-in000005 #Write_rows_v1 ## table_id:#flags: STMT_END_F
-.000005 Write_rows_v1 #table_id:#flags:STMT_END_F
master-bin.00005 #Rotate # #master-in.00006;pos=POS
include/how_binlog_events.nc
master-bin.000005 # Annotate_rows # # INSERT Pos  Server_idEnd_log_posInfo
master-.00005  Table_map##table_id: # (est.1)
master-bin.000005#Gtid_list  ###]
masterbin. # Binlog_checkpoint  masterbin000004
master-bin.000005 # Rotate PURGE BINARY LOGS java.lang.StringIndexOutOfBoundsException: Range [21, 20) out of bounds for length 41
include/inc
 binary logs
-in000006#Format_desc SERVER_VERSION,BINLOG_VERSION
000006 #Gtid_list #  ###java.lang.StringIndexOutOfBoundsException: Index 41 out of bounds for length 41
master-bin.000006 # Binlog_checkpoint # # master-bin.000004
PURGE BINARY LOGS TO "master-binSET DEBUG_SYNC= now  con4_cont"
Warnings:
Note 1375 Binary log '     errors
show binary logs;
Log_name File_size
SELECT a FROM t1 ORDER BY a
java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
master-java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
SETDEBUG_SYNC="owSIGNAL java.lang.StringIndexOutOfBoundsException: Range [39, 37) out of bounds for length 39
onnectioncon4;
Got one of the listed= 1
connection ;
connect con10,localhost,,;
a
1
2
3
4
INS INTOVALUES (0,REPEAT(x" 4100);
101
102
Test  with binlog ,recovery starts from the  onejava.lang.StringIndexOutOfBoundsException: Index 78 out of bounds for length 78
SET GLOBAL max_binlog_size= 4096;
SET GLOBAL connect con11,localhost,root,,;
RESET MASTER;
connect con10,ocalhost,oot,;
INSERT INTO t1VALUES (1 REPEAT"" );
INSERT INTO   (0,(x,4100)
;
connect con12,localhost,root,,;
connect con11,localhost,root,,;
SET DEBUG_SYNC= "commit_after_group_release_commit_ordered  con11_cont"
java.lang.StringIndexOutOfBoundsException: Range [11, 6) out of bounds for length 46
connection default;
SET DEBUG_SYNC= "now WAIT_FOR con11_ready";
connectcon12,ocalhost,,;
SET DEBUG_SYNC= "java.lang.StringIndexOutOfBoundsException: Index 26 out of bounds for length 19
INSERT INTO t1  12 REPEAT"" 4100);
connection default;
SET INTOt1VALUES (3,NULL)
INSERT show binary;
Log_nameFile_size
master-in.00001 #
master--in000002#
masterbin000003#
master-bin.000003 #
master-bin.000004 #
include/show_binlog_events.inc
Log_name Pos Event_type Server_id  Info
master-bin.000004 # Format_desc # # SERVER_VERSION, BINLOG_VERSIONinclude/show_binlog_events.inc
master-bin.000004 # Log_name Pos Event_type End_log_pos
.00004 #Binlog_checkpoint  -000001
master-in.00004 #Gtid ##BEGINGTID#--
master-bin.000004 #masterbin000004#Binlog_checkpoint##master-in000001
-.000004   ##table_id:#(est.1)
master-bin.000004 # -bin.000004 # Annotate_rows#INSERT INTO t1 VALUES (3,NULLjava.lang.StringIndexOutOfBoundsException: Index 70 out of bounds for length 70
-in.00004 #Xid##COMMIT /* XID */
SET DEBUG_SYNC= "now SIGNAL con10_cont"masterbin000004#Write_rows_v1 ##table_id  :STMT_END_F
connection con10;
connection default;
 DEBUG_SYNC="owSIGNAL "java.lang.StringIndexOutOfBoundsException: Index 40 out of bounds for length 40
connectiondefault
connection default;
connectioncon12
 default
 default
 crashtheserver
 SESSION debug_dbug"d,rash_commit_after_log";
INSERT INTO t1 VALUES (14, NULL);
Gotoneofthelistederrors
connection default;
INSERT  VALUES14 NULL)
a
1
2
3
4
10
11
12
13
14
java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
101
java.lang.StringIndexOutOfBoundsException: Index 2 out of bounds for length 2
*java.lang.StringIndexOutOfBoundsException: Index 2 out of bounds for length 2
*** binlog **Check that recovery works if we crashed early during rotate, before

SET GLOBAL innodb_flush_log_at_trx_commit= 1;
RESET SETGLOBALmax_binlog_size=4096;
SET GLOBAL innodb_flush_log_at_trx_commit 1;
INSERT INTO t1 VALUES (22, REPEAT("x", 4100));
INSERT INTO t1 VALUES (23, REPEAT("x", 4100));
INSERTINTOt1VALUES(1,REPEAT"" 4100)java.lang.StringIndexOutOfBoundsException: Index 46 out of bounds for length 46
INSERT INTO t1 VALUES (,REPEAT"" );
Got one of the listed INSERT  VALUES(3, "" 4100);
SELECTaFROMt1 ORDER BY a
a
1
2
3
4
10
11
12
13
14
21
22
23
24
100
101
102
show binary logs;
Log_name File_size
in000001 #
java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
master11
aster-in000005#
include/show_binlog_events
Log_name Posjava.lang.StringIndexOutOfBoundsException: Index 2 out of bounds for length 2
master-bin. #Format_desc #SERVER_VERSION,BINLOG_VERSION
master-bin.000004100
master-  logs;
bin.00004 #Binlog_checkpoint  master-in.00004
master-bin.000004 # master-in.00001#
master-bin.000004 # java.lang.StringIndexOutOfBoundsException: Index 31 out of bounds for length 19
master-bin-000005#
master-bin.000004 # Write_rows_v1 # includeshow_binlog_eventsinc
-.00004  #Xid # # /* XID */
master-bin.000004 masterbin000004#Gtid_list ## [-##
t;
DROP TABLE t1;