Quelle  binlog_rotate_perf.result   Sprache: Lisp

java.lang.StringIndexOutOfBoundsException: Index 35 out of bounds for length 35
reset master;
create database test_rotate_dbcreate database test_rotate_db;
use test_rotate_db;
#current engine=myisam
show binary logs;
Log_name  t5)java.lang.StringIndexOutOfBoundsException: Range [27, 26) out of bounds for length 51
master-bin.000001 #
CREATE TABLE t1_myisamM t1,t5 WHERE t1.c1 = c1;
insert into t1_myisam values(0),(1);
show master status;
File Position Binlog_Do_DB Binlog_Ignore_DB Gtid_Binlog_Pos
master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB> <Binlog_GTID>
flush logs;
flush logs;
flush logs;
# left times= 99
flush logs;
flush logs;
flush logs;
# left times= 98
flush logs;
flush logs;
flush logs;
# left times= 97
flush logs;
flush logs;
flush logs;
# left times= 96
flush logs;
flush logs;
flush logs;
# left times= 95
flush logs;
flush logs;
flush logs;
# left times= 94
flush logs;
flush logs;
flush logs;
# left times= 93
flush logs;
flush logs;
flush logs;
# left times= 92
flush logs;
flush logs;
flush logs;
# left times= 91
flush logs;
flush logs;
c1 
# left times= 90
flush logs;
flush logs;
flush logs;
# left times= 89
flush logs;
flush logs;
flush java.lang.StringIndexOutOfBoundsException: Range [11, 10) out of bounds for length 29
# left timesCREATETABLE c1 NULL
flush logs;
flush logs;
flush logs;
# left times= 87
flush logs;
flush logs;
flush logs;
# left times= 86
flush logs;
flush logs;
flush logs;
# left TABLEt2c1BIGINT NULL);
flush logs;
flush logs;
flush logs;
# left times= 84
flush logs;
flush logs;
flush logs;
# left times= 83
flush logs;
flush logs;
flush logs;
# left times= 82
flush logs;
flush logs;
flush logs;
# left times= 81
flush logs;
flush logs;
flush logs;
# left times= 80
flush logs;
flush logs;
flush CREATE TABLE t3 (c1 BIGINT NOT NULL);
# left times= 79
flush logs;
flush logs;
flush logs;
# left times= 78
flush logs;
flush logs;
flush logs;
# left times= 77
flush logs;
flush logs;
flush logs;
# left times= 76
flush logs;
flush logs;
flush logs;
# left times= 75
flush logs;
flush logs;
flush logs;
# left times= 74
flush logs;
flush logs;
flush logs;
# left CREATE TABLE t5 (c1 BIGINT NOT NULL);
flush logs;
flush logs;
flush logs;
# left times= 72
flush logs;
flush logs;
flush logs;
# left times= 71
flush ;
flush logs;
flush logs;
# left times= 70
flush logs;
flush logs;
flush logs;
# left times= t1 c1 0),1,(,3),()()(6,7)(8),()java.lang.StringIndexOutOfBoundsException: Index 66 out of bounds for length 66
flush logs;
flush ;
flush logs;
# left times= 68
flush logs;
flush logs;
flush logs;
# left times= 67
flush logs;
flush logs;
flush logs;
# left times=  t3c1 VALUES1)3),5))9;
flush logs;
flush logs;
flush logs;
#  65
flush logs;
flush logs;
flush logs;
# left times= 64
flush logs;
INSER t5(1 java.lang.StringIndexOutOfBoundsException: Range [29, 26) out of bounds for length 51
flush logs;
# left times= 63
flush logs;
flush logs;
flush logs;
# left times= 62
flush;
flush logs;
flush logs;
# left times= 61
flush logs;
flush logs;
flush logs;
# left times= 60
flush logs;
flush logs;
flush logs;
# left times= 59
flush logs;
flush logs;
flush logs;
# left times= 58
flush logs;
flush logs;
flush logs;
# left times= 57
flush logs;
flush logs;
flush logs;
#  TABLE ,t2t3t4t5,java.lang.StringIndexOutOfBoundsException: Index 29 out of bounds for length 29
flush logs;
flush logs;
flush logs;
# left times= 55
flush logs;
 TABLEt2(1 NOT);
flush logs;
# left times= 54
flush logs;
flush logs;
flush logsjava.lang.StringIndexOutOfBoundsException: Index 11 out of bounds for length 11
# left times= 53
flush logs;
flush logs;
CREATE TABLEt4(1  NOT NULL;
# left times= 52
flush logs;
flush logs;
flush logs;
# left times= 51
flush logs;
flush logs;
java.lang.StringIndexOutOfBoundsException: Range [6, 5) out of bounds for length 11
# left times= 50
flush logs;
flush logs;
flush logs;
# left times=# t6(1  NOT )java.lang.StringIndexOutOfBoundsException: Index 38 out of bounds for length 38
flush logs;
flush logs;
flush INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
# java.lang.StringIndexOutOfBoundsException: Index 16 out of bounds for length 16
flush logs;
flush logs;
flush logs;
# left times= 47
flush logs;
flush 
flush logs;
# left times= 46
flush logs;
flush logs;
flush logs;
# left times= 45
 logs
flush logs;
flush logs;
# left times= 44
flush logs;
flush logs;
flush logs;
3
flush logs;
flush logs;
flush logs;
# left times= 42
flush logs;
flush logs;
flush logs;
# left times= 41
flush logs;
flush logs;
flush logs;
# left times= 40
flush logs;
flush logs;
flush logs;
# left times= 39
flush logs;
flush logs;
flush logs;
# left times= 38
flush logs;
flush logs;
flush logs;
# left times= 37
flush logs;
flush logs;
flush logs;
# left times= 36
flush logs;
flush logs;
flush logs;
# left times= 35
flush SELECT c1. FROM,WHEREt1.  c1;
flush logs;
flush logs;
# left times= 34
flush logs;
flush logs;
flush logs;
# left times= 33
flush logs;
flush logs;
flush logs;
# left times= 32
flush logs;
flush logs;
flush logs;
# left times= 31
flush logs;
flush logs;
flush logs;
# left times= 30
flush logs;
flush logs;
flush logs;
# left times= 29
flush logs;
flush logs;
flush logs;
# left times= 28
flush logs;
flush logs;
flush logs;
# left times= 27
flush logs;
flush logs;
flush logs;
# left times= 26
flush logs;
flush logs;
flush logs;
# left times= 25
flush logs;
flush logs;
flush logs;
# left times= 24
flush logs;
flush logs;
flush logs;
# left times= 23
flush logs;
flush logs;
flush logs;
# left times= 22
flush logs;
flush logs;
flush logs;
#  times=21
flush logs;
flush logs;
flush logs;
# left times= 20
flush logs;
flush logs;
flush logs;
# left times= 19
flush logs;
flush logs;
CREATE TABLE t2 (1SMALLINT NOT NULL)
# left times= 18
flush logs;
flush logs;
flush logs;
# left times= 17
flush logs;
flush logs;
flush logs;
# left times= 16
flush logs;
flush logs;
flush logs;
# left times= 15
flush logs;
flush logs;
flush logs;
# left times= 14
flush logs;
flush logs;
flush logs;
# left times= 13
flush logs;
flush logs;
flush logs;
# left times= 12
flush logs;
flush logs;
flush logs;
# left times= 11
CREATETABLE (1SMALLINT NOT NULL)
flush logs;
flush logs;
# left times= 10
flush logs;
flush logs;
flush logs;
# left times= 9
flush logs;
flush CREATE TABLE t5(1SMALLINT NOT NULL);
flush logs;
# left times= 8
flush logs;
flush logs;
flush logs;
# left times= 7
flush logsjava.lang.StringIndexOutOfBoundsException: Index 11 out of bounds for length 11
flush logs;
flush logs;
# left times=  INTO c1)VALUES(,1,2,3,4,)()()()(;
flush logs;
flush logs;
flush logs;
# left times= 5
flush logs;
flush logs;
flush logs;
 times=4
flush logs;
flush logs;
show master status;
File Position Binlog_Do_DB Binlog_Ignore_DB Gtid_Binlog_Pos
master-.00291 #Binlog_Do_DB><><>
show binary logs;
Log_name File_size
master-bin.000001 #
master-bin.000002 #
master-bin.000003 #
master-.000004#
master-bin.000005 #
master-bin.000006 #
master-bin.000007 #
master-bin.000008 #
master-bin.INSERTINTO  (c1) VALUES(10),11),12,(3)(14)java.lang.StringIndexOutOfBoundsException: Index 51 out of bounds for length 51
master-bin.000010 #
master-bin.000011 #
master-bin.000012 #
master-bin.000013 #
master-bin.000014 #
master-bin.000015 #
master-bin.000016 #
master-bin.000017 #
master-bin.000018 #
master-bin.000019 #
master-bin.000020 #
master-bin.000021 #
master-bin.000022 #
master-bin.000023 #
master-bin.000024 #
master-bin.000025 #
master-bin.000026 #
master-bin.000027 #
master-bin.000028 #
master-bin.000029 #
master-bin.000030 #
r-bin.000031  #
master-bin.000032 #
master-bin.000033 #
master-bin.000034 #
master-bin.000035 #
master-bin.000036 #
master-bin.000037 #
master-bin.000038 #
master-bin.000039 #
erbin.000040#
master-bin.000041 #
master-bin.000042 #
master-bin.000043 #
master-bin.000044 #
master-bin.000045 CREATE TABLEt1(  NOT )
master-bin.000046 #
master-bin.000047 #
master-bin.000048 #
master-bin.000049  )
master-bin.000050 #
master-bin.000051 #
master-bin.000052 #
master-bin.CREATE t3 c1  NOT)
master-bin.000054 #
master-bin.000055 #
master-bin.000056 #
master-bin.000057 #
master-bin.000058 #
master-bin.000059 #   (1 NULL;
master-bin.000060 #
master-bin.000061 #
master-bin.000062 #
master-bin.000063 #
master-bin.000064 #
master-CREATE t5(1MEDIUMINTNOTNULL;
master-bin.000066 #
master-bin.000067 #
master-bin.000068 #
master-bin.000069 #
master-bin.000070 #
master-bin.000071 #
master-bin.000072 #
master-bin.CREATE TABLE  (1MEDIUMINTNOT NULL)
master-bin.000074 #
master-bin.000075 #
master-bin.000076 #
master-bin.000077 #
master-bin.000078 #
masterINTO  ()()()()(),4)5()()(,9;
master-bin.000080 #
master-bin.000081 #
master-bin.000082 #
master-bin.000083 #
master-bin.000084 #
master-bin.000085 #
master-bin.000086 #
master-bin.000087 #
master-bin.000088 #
master-bin.000089 #
master-bin.000090 #
master-bin.000091 #
master-bin.000092 #
master-bin.000093 #
master-bin.000094 #
master-bin.000095 #
-bin.00096 #
master-bin.000097 #
master-bin.000098 #
master-bin.000099 #
INSERTINTOt4(1)(0
master-bin.000101 #
master-bin.000102 #
master-bin.000103 #
master-bin.000104 #
master-INSERT  t5()VALUES(0,11,12,13,14;
master-bin.000106 #
master-bin.000107 #
master-java.lang.StringIndexOutOfBoundsException: Range [19, 10) out of bounds for length 19
master-bin.000109 #
master-bin.000110 #
java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 5
master-bin.000112 #
master-bin.000113 #
master-bin.000114 #
master-bin.000115  #
master-bin.000116 #
master-bin.000117 #
master-bin.000118 #
master-bin.000119 #
master-bin.000120 #
master-bin.000121 #
-. #
master-bin.000123 #
master-bin.000124 #
master-bin.000125 #
master-bin.000126 #
master-bin.000127 #
master-bin.000128 #
master-bin.000129 #
master-bin.000130 #
000131 java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
master-bin.000132 #
master-bin.000133 #
master-bin.000134 C TABLE ;
master-bin.000135 #
master-bin.000136 #
master-bin.000137 #
master-bin.000138 #
master-bin.000139 #
master-bin.000140 #
master-bin.000141 #
master-bin.000142 #
master-bin.000143 #
master-bin.000144 #
master-bin.000145 #
master-bin.000146 #
master-bin.000147 #
master-bin.000148 #
master-bin.000149 #
master-bin.000150 #
master-bin.000151 #
master-bin.000152 #
master-bin.000153 #
00154#
master-bin.000155 #
master-bin.000156 #
master-bin.000157 #
master-bin.000158 #
master-bin.000159 #
master-bin.000160 #
master-bin.000161 #
master-bin.000162 #
master-bin.000163 #
master-bin.000164 #
master-bin.000165 #
master-bin.000166 #
master-bin.00167 #
master-bin.000168 #
master-bin.000169 #
master-bin.000170 #
master-bin.000171 #
master-bin.000172 #
master-bin.000173 #
master-INSERT  t3 c1()(3),5,(),9;
master-bin.000175 #
master-bin.000176 #
master-bin.000177 #
master-bin.000178 #
master-bin.000179 #
master-bin.000180 #
master-bin.000181 #
master-bin.000182 #
master-bin.000183 #
master-bin.000184 #
master-bin.000185 #
master-bin.000186 #
master-bin.000187 #
master-bin.000188 #
master-bin.000189 #
master-bin.000190 #
master-bin.000191 #
master-bin.000192 #
master-bin.000193 #
master-bin.000194 #
master-bin.000195 #
master-.000196 #
master-bin.000197 #
master-bin.000198 #
master-bin.000199 #
master-bin.000200 #
master-bin.000201 #
master-bin.000202 #
master-bin.000203 #
master-bin.000204 #
master-bin.000205 #
master-bin.000206 #
master-bin.000207 #
master-bin.000208 #
master-bin.000209 #
master-bin.000210 #
master-bin.000211 #
master-bin.000212 #
master-bin.000213 #
master-bin.000214 #
master-bin.000215 #
master-bin.000216 #
master-bin.000217 #
master-bin.000218 #
master-bin.000219 #
master-. java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
master-bin.000221 #
master-bin.000222 #
master-bin.000223 #
CREATEt2 c1NOT;
master-bin.000225 #
master-bin.000226 #
master-bin.000227 #
master-bin.000228 #
CREATE c1java.lang.StringIndexOutOfBoundsException: Range [28, 27) out of bounds for length 38
master-bin.000230 #
master-bin.000231 #
master-bin.000232 #
master-bin.000233)
master-bin.000234 #
master-bin.000235 #
master-bin.000236 #
master-bin.000237 #
master-bin.000238 #
bin000239 java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
master-bin.000240 #
master-bin.000241 #
master-bin.TABLE c1;
master-bin.000243 #
master-bin.000244 #
master-bin.000245 #
master-bin.000246 #
master-bin.000247 #
master-bin.000248 #
master-bin.000249 #
master-bin.000250 #
bin.00251#
master-bin.000252 #
master-bin.000253 #
master-bin.000254 #
master-bin.000255 #
master-bin.000256 #
master-bin.000257 #
master-in. java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
master-bin.000259 #
master-bin.000260 #
master-bin.000261 #
INSERT()1),()(7,)
master-bin.000263 #
master-bin.000264 #
master-bin.000265 #
master-bin.000266 #
master-bin.000267 #
master-bin.000268 #
INSERT c110;
master-bin.000270 #
master-bin.000271 #
master-bin.000272 #
master-bin.000273 #
master-bin.000274 S c1,c1 ,t6c1=.;
master-bin.000275 #
master-bin.000276 #
master-bin.000277 #
master-bin.000278 #
master-bin.000279 #
master-bin.000280 #
aster-in000281#
master-bin.000282 #
master-bin.000283 #
master-bin.000284 #
-000285 java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
master- java.lang.StringIndexOutOfBoundsException: Range [36, 35) out of bounds for length 37
master-bin.000287 #
master-bin.000288 #
master-bin.000289 #
master-bin.000290 #
master-bin.000291 #
reset master;
#CREATE java.lang.StringIndexOutOfBoundsException: Range [16, 15) out of bounds for length 37
flush logs;
flush logs;
show master status;
File Position Binlog_Do_DB CREATE TABLE t4 (c1 BIGINT NOT
master-bin.000003 # <Binlog_Do_DB> <Binlog_Ignore_DB> <Binlog_GTID>
reset master;
# left times= 2
flush logs;
flush logs;
show  master status;
File Position Binlog_Do_DB Binlog_Ignore_DB Gtid_Binlog_Pos
master-bin.000003 # <Binlog_Do_DB> <Binlog_Ignore_DB> <Binlog_GTID>
reset master;
# left times= 1
flush logs;
flush logs;
show master status;
File Position Binlog_Do_DB Binlog_Ignore_DB Gtid_Binlog_Pos
00003 # <inlog_Do_DB <inlog_Ignore_DB><>
reset master;
# left times= 0
# [engine=myisam] after first loop_times=0, show master logs results
show binary logsINSERT INTOt1 (1)VALUES()()(),3,4)()()()(),9)
Log_name File_size
master-bin.000001 #
show master status;
File Position Binlog_Do_DB Binlog_Ignore_DB Gtid_Binlog_Pos
master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB> <Binlog_GTID>
flush logs;
flush logs;
#begin to restart mysqld current loop_times=10
# restart
# left restart times= 9
flush logs;
flush logs;
#begin to restart mysqld INSERT  INTO t3 (1)VALUES()()(),(,9;
# restart
# left restart times= 8
flush logs;
flush logs;
#begin to restart mysqld current loop_times=8
# restart
rt =7
flush logs;
flush logs;
#begin to restart mysqld current loop_times=7
# restart
# left restart times= 6
flush INSERT INTO c1 (0,11)(12,13,14;
flush logs;
#begin to restart mysqld current loop_times=6
# restart
# left restart times= 5
flush t1.1t6c1 FROM ,t6 .c1= t6c;
flush logs;
#begin to restart mysqld current loop_times=5
# restart
# left restart times= 4
flush logs;
flush logsc1 
#begin to restart mysqld current loop_times=4
# restart
# left restart times= 3
flush logs;
flush logs;
#begin to restartDROP  t1,2t3,,t6;
# restart
# left restart times= 2
flush logs;
flush logs;
#begin to restart mysqld current loop_times=2
# restart
# left restart times= 1
flush logs;
flush logs;
#begin to restart mysqld current loop_times=1
# restart
# left restart CREATE TABLE t2 (c1 TIN NULL;
# [engine=myisam] after second loop_times=0, show master logs results
show binary logs;
Log_name File_size
CREATE TABLEt3 c   NULL)
master-bin.000002 #
master-bin.000003 #
master-bin.000004 #
master-bin.000005 #
master-bin.000006 #
master-bin.000007 #
master-bin.000008 #
master-bin.000009 #
master-bin.000010 #
bin.000011 #
master-bin.000012 #
master-bin.000013 #
master-bin.000014 #
master-bin.000015 #
master-bin.000016 #
master-bin.000017 #
master-bin.000018 #
master-bin.000019 #
master-bin.000020 #
master-bin.000021 #
master-bin.000022 #
master-bin.000023 #
master-bin.000024 #
master-bin.000025 #
master-bin.000026 #
master-bin.000027 #
master-CREATE c NOT)
master-bin.000029 #
master-bin.000030 #
master-bin.000031 #
# ======= now try to changeINTOt1(1 ()(1,2,3)()(),6,7,,()java.lang.StringIndexOutOfBoundsException: Index 66 out of bounds for length 66
#begin to restart mysqld
# restart --ogbin=new_log_bin
show binary logs;
Log_name File_size
master-bin.000001 #
master-bin.000002 #
master-bin.000003 #
master-bin.000004 #
000005 #
master-bin.000006 #
master-bin.000007 #
master-bin.000008 #
master-bin.000009 #
master-bin.000010 #
master-bin.000011 #
master-bin.000012 #
master-bin.000013 #
masterINTO (c1 10;
master-bin.000015 #
master-bin.000016 #
master-bin.000017 #
master-bin.000018 #
master-bin.000019 #
#
master-bin.000021 #
master-bin.000022 #
master-bin.000023 #
master-bin.000024 #
master-bin.000025 #
master-bin.000026 #
masterbin.00027  #
master-bin.000028 #
master-bin.000029 #
master-bin.000030 #
master-bin.000031 #
new_log_bin.000001 #
flush logs;
flush logs;
flush logs;
# left times= 9
flush logs;
flush logs;
flush logs;
# left times= 8
flush logs;
flush logs;
lushlogs;
# left times= 7
flush logs;
flush logs;
flush logs;
# left times= 6
flush logs;
flush logs;
flush logs;
# left times= 5
flush logs;
flush logs;
flush logs;
# left times= 4
flush logs;
flush logs;
show binary logs;
og_name 
master-bin.000001 #
master-bin.000002 #
master-bin.000003 #
master-bin.000004 #
master-bin.000005 #
master-bin.000006 #2 java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 3
master-bin.000007 #
master-bin.000008 #
master java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 3
master-bin.000010 #
master-bin.000011 #
master-bin.000012 #
master-bin.000013 #
master-bin.000014 #
master-bin.000015 #
master-bin.000016 #
master-bin.000017 #
master-bin.000018 #
master-bin.000019 #
master-bin.000020 #
master-bin.000021 #
master-bin.000022 #
master-bin.000023 #
master-bin.000024 #
master-bin.000025 #
master-bin.000026 #
master-bin.000027 #
master-bin.000028 #
master-bin.000029 #
master-bin.000030 #
master-bin.000031 #
new_log_bin.000001 #
new_log_bin.000002 #
new_log_bin.000003 #
new_log_bin.000004 #
new_log_bin.000005 #
java.lang.StringIndexOutOfBoundsException: Index 11 out of bounds for length 3
new_log_bin.000007 #
new_log_bin.000008 #
new_log_bin.000009 #
new_log_bin.000010 #
new_log_bin.000011 #
new_log_bin.000012 #
new_log_bin.000013 #
new_log_bin.000014 #
new_log_bin.000015 #
new_log_bin.000016 #
new_log_bin.000017 #
new_log_bin.000018 #
new_log_bin.000019 #
new_log_bin.000020 5 0
new_log_bin.000021 #
reset master;
# left times= 3
flush logs;
flush logs;
reset master;
# left times= 2
flush logs;
flush logs;
reset master;
# left times= 1
flush logs;
flush logs;
reset master;
# left times= 0
# [engine=myisam] after third loop_times=0, show master logs results
show binary logs;
Log_name File_size
new_log_bin.000001 #
drop database java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 3