Skipping 12,491 KB.. Full Log

[2024/04/26 19:48:06.380 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:06.382 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24624] [neededSchemaVersion=24627] ["start time"=437.508µs] [gotSchemaVersion=24627] [phyTblIDs="[20486]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/04/26 19:48:06.383 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490876] [schemaVersion=24627] [cur_db=util__ranger] [sql="create table t2 (id int unsigned not null auto_increment primary key, t text, index(t(3)));"] [user=root@%]
[2024/04/26 19:48:06.396 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20496, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20495, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:06.354 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:06.396 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20496, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20495, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:06.354 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table t2 (id int unsigned not null auto_increment primary key, t text, index(t(3)));"]
[2024/04/26 19:48:06.435 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20496] [conn=3248490876] [category=ddl] [job="ID:20496, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20495, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:06.354 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:06.460 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20496] [conn=3248490876] [job="ID:20496, Type:create table, State:synced, SchemaState:public, SchemaID:20478, TableID:20495, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:06.354 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:06.464 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20496]
[2024/04/26 19:48:06.464 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:06.464 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=14] ["first split key"=74800000000000500f]
[2024/04/26 19:48:06.465 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=74800000000000500f] ["first new region left"="{Id:16632 StartKey:7480000000000050ff0c00000000000000f8 EndKey:7480000000000050ff0f00000000000000f8 RegionEpoch:{ConfVer:1 Version:8041} Peers:[id:16633 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/04/26 19:48:06.465 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16632]"]
[2024/04/26 19:48:06.465 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24627] [neededSchemaVersion=24628] ["start time"=527.974µs] [gotSchemaVersion=24628] [phyTblIDs="[20495]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/04/26 19:48:06.466 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24628] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t2 (t) values ('aaaa'),('a');"]
[2024/04/26 19:48:06.468 +08:00] [INFO] [region_request.go:1686] ["send request meet region error without retry"] [conn=3248490876] [session_alias=] [req-ts=449349441671397385] [req-type=Prewrite] [region="{ region id: 14, ver: 8040, confVer: 1 }"] [replica-read-type=leader] [stale-read=false] [request-sender="{rpcError:<nil>, replicaSelector: replicaSelectorV2{replicaReadType: leader, attempts: 1, cacheRegionIsValid: false, replicaStatus: [peer: 15, store: 1, isEpochStale: false, attempts: 1, replica-epoch: 0, store-epoch: 0, store-state: resolved, store-liveness-state: reachable]}}"] [retry-times=0] [total-backoff-ms=0] [total-backoff-times=0] [max-exec-timeout-ms=20000] [total-region-errors=15-epoch_not_match:1]
[2024/04/26 19:48:06.469 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24628] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t2 where t='aaaa';"]
[2024/04/26 19:48:06.470 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24628] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t2 where t='aaaa';"]
[2024/04/26 19:48:06.471 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24628] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t2 where t='aaaa' or t = 'a';"]
[2024/04/26 19:48:06.472 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24628] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t2 where t='aaaa' or t = 'a';"]
[2024/04/26 19:48:06.473 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24628] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t2;"]
[2024/04/26 19:48:06.503 +08:00] [INFO] [analyze.go:747] ["analyze table `util__ranger`.`t2` has finished"] [partition=] ["job info"="analyze table all columns with 256 buckets, 500 topn, 1 samplerate"] ["start time"=2024/04/26 19:48:06.477 +08:00] ["end time"=2024/04/26 19:48:06.502 +08:00] [cost=25.015091ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/04/26 19:48:06.515 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24628] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t2 where t='aaaa';"]
[2024/04/26 19:48:06.516 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24628] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t2 where t='aaaa';"]
[2024/04/26 19:48:06.517 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24628] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t2 where t='aaaa' or t = 'a';"]
[2024/04/26 19:48:06.517 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24628] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t2 where t='aaaa' or t = 'a';"]
[2024/04/26 19:48:06.518 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490876] [schemaVersion=24628] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/04/26 19:48:06.530 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20497, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20489, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:06.504 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:06.530 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20497, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20489, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:06.504 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/04/26 19:48:06.551 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20497] [conn=3248490876] [category=ddl] [job="ID:20497, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20489, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:06.504 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:06.570 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20497] [conn=3248490876] [category=ddl] [job="ID:20497, Type:drop table, State:running, SchemaState:write only, SchemaID:20478, TableID:20489, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:06.504 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:06.588 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20497] [conn=3248490876] [category=ddl] [job="ID:20497, Type:drop table, State:running, SchemaState:delete only, SchemaID:20478, TableID:20489, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:06.504 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:06.618 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20497] [tableIDs="[20490,20491,20492]"] [comment="drop table: partition table IDs"]
[2024/04/26 19:48:06.620 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20497] [tableIDs="[20489]"] [comment="drop table: table ID"]
[2024/04/26 19:48:06.621 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20497] [jobType="drop table"]
[2024/04/26 19:48:06.622 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20497] [conn=3248490876] [job="ID:20497, Type:drop table, State:synced, SchemaState:none, SchemaID:20478, TableID:20489, RowCount:0, ArgLen:3, start time: 2024-04-26 19:48:06.504 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:06.625 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20497]
[2024/04/26 19:48:06.625 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:06.627 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24628] [neededSchemaVersion=24631] ["start time"=530.513µs] [gotSchemaVersion=24631] [phyTblIDs="[20489,20490,20491,20492]"] [actionTypes="[4,4,4,4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/04/26 19:48:06.628 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490876] [schemaVersion=24631] [cur_db=util__ranger] [sql="create table t(a varchar(100), b int, c int, d int, index idx(a, b, c));"] [user=root@%]
[2024/04/26 19:48:06.645 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20499, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20498, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:06.604 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:06.645 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20499, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20498, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:06.604 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table t(a varchar(100), b int, c int, d int, index idx(a, b, c));"]
[2024/04/26 19:48:06.672 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20499] [conn=3248490876] [category=ddl] [job="ID:20499, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20498, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:06.604 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:06.698 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20499] [conn=3248490876] [job="ID:20499, Type:create table, State:synced, SchemaState:public, SchemaID:20478, TableID:20498, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:06.604 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:06.701 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20499]
[2024/04/26 19:48:06.701 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:06.701 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=14] ["first split key"=748000000000005012]
[2024/04/26 19:48:06.702 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005012] ["first new region left"="{Id:16634 StartKey:7480000000000050ff0f00000000000000f8 EndKey:7480000000000050ff1200000000000000f8 RegionEpoch:{ConfVer:1 Version:8042} Peers:[id:16635 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/04/26 19:48:06.702 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16634]"]
[2024/04/26 19:48:06.703 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24631] [neededSchemaVersion=24632] ["start time"=587.139µs] [gotSchemaVersion=24632] [phyTblIDs="[20498]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/04/26 19:48:06.703 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24632] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t values ('t',1,1,1),('t',1,3,3),('t',2,1,3),('t',2,3,1),('w',0,3,3),('z',0,1,1);"]
[2024/04/26 19:48:06.705 +08:00] [INFO] [region_request.go:1686] ["send request meet region error without retry"] [conn=3248490876] [session_alias=] [req-ts=449349441723826197] [req-type=Prewrite] [region="{ region id: 14, ver: 8041, confVer: 1 }"] [replica-read-type=leader] [stale-read=false] [request-sender="{rpcError:<nil>, replicaSelector: replicaSelectorV2{replicaReadType: leader, attempts: 1, cacheRegionIsValid: false, replicaStatus: [peer: 15, store: 1, isEpochStale: false, attempts: 1, replica-epoch: 0, store-epoch: 0, store-state: resolved, store-liveness-state: reachable]}}"] [retry-times=0] [total-backoff-ms=0] [total-backoff-times=0] [max-exec-timeout-ms=20000] [total-region-errors=15-epoch_not_match:1]
[2024/04/26 19:48:06.706 +08:00] [WARN] [prewrite.go:382] ["1pc failed and fallbacks to normal commit procedure"] [conn=3248490876] [session_alias=] [startTS=449349441723826197]
[2024/04/26 19:48:06.707 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24632] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t use index (idx) where ((a = 't' and b = 1) or (a = 't' and b = 2) or (a = 'w' and b = 0)) and c > 2;"]
[2024/04/26 19:48:06.708 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24632] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t use index (idx) where ((a = 't' and b = 1) or (a = 't' and b = 2) or (a = 'w' and b = 0)) and c > 2;"]
[2024/04/26 19:48:06.709 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24632] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t use index (idx) where ((a = 't' and b = 1) or (a = 't' and b = 2) or (a = 'w' and b = 0)) and d > 2;"]
[2024/04/26 19:48:06.710 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24632] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t use index (idx) where ((a = 't' and b = 1) or (a = 't' and b = 2) or (a = 'w' and b = 0)) and d > 2;"]
[2024/04/26 19:48:06.711 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490876] [schemaVersion=24632] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/04/26 19:48:06.727 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20500, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20498, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:06.704 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:06.727 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20500, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20498, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:06.704 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/04/26 19:48:06.747 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20500] [conn=3248490876] [category=ddl] [job="ID:20500, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20498, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:06.704 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:06.770 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20500] [conn=3248490876] [category=ddl] [job="ID:20500, Type:drop table, State:running, SchemaState:write only, SchemaID:20478, TableID:20498, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:06.704 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:06.797 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20500] [conn=3248490876] [category=ddl] [job="ID:20500, Type:drop table, State:running, SchemaState:delete only, SchemaID:20478, TableID:20498, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:06.704 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:06.818 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20500] [tableIDs="[20498]"] [comment="drop table: table ID"]
[2024/04/26 19:48:06.820 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20500] [jobType="drop table"]
[2024/04/26 19:48:06.820 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20500] [conn=3248490876] [job="ID:20500, Type:drop table, State:synced, SchemaState:none, SchemaID:20478, TableID:20498, RowCount:0, ArgLen:3, start time: 2024-04-26 19:48:06.704 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:06.823 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20500]
[2024/04/26 19:48:06.823 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:06.824 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24632] [neededSchemaVersion=24635] ["start time"=362.08µs] [gotSchemaVersion=24635] [phyTblIDs="[20498]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/04/26 19:48:06.825 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490876] [schemaVersion=24635] [cur_db=util__ranger] [sql="create table t(a int, b int, c int, primary key(a,b,c));"] [user=root@%]
[2024/04/26 19:48:06.845 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20502, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20501, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:06.804 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:06.845 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20502, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20501, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:06.804 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table t(a int, b int, c int, primary key(a,b,c));"]
[2024/04/26 19:48:06.872 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20502] [conn=3248490876] [category=ddl] [job="ID:20502, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20501, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:06.804 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:06.892 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20502] [conn=3248490876] [job="ID:20502, Type:create table, State:synced, SchemaState:public, SchemaID:20478, TableID:20501, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:06.804 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:06.896 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20502]
[2024/04/26 19:48:06.896 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:06.896 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=14] ["first split key"=748000000000005015]
[2024/04/26 19:48:06.897 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005015] ["first new region left"="{Id:16636 StartKey:7480000000000050ff1200000000000000f8 EndKey:7480000000000050ff1500000000000000f8 RegionEpoch:{ConfVer:1 Version:8043} Peers:[id:16637 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/04/26 19:48:06.897 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16636]"]
[2024/04/26 19:48:06.897 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24635] [neededSchemaVersion=24636] ["start time"=615.221µs] [gotSchemaVersion=24636] [phyTblIDs="[20501]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/04/26 19:48:06.898 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t values(1,1,1),(2,2,3);"]
[2024/04/26 19:48:06.900 +08:00] [INFO] [region_request.go:1686] ["send request meet region error without retry"] [conn=3248490876] [session_alias=] [req-ts=449349441776254997] [req-type=Prewrite] [region="{ region id: 14, ver: 8042, confVer: 1 }"] [replica-read-type=leader] [stale-read=false] [request-sender="{rpcError:<nil>, replicaSelector: replicaSelectorV2{replicaReadType: leader, attempts: 1, cacheRegionIsValid: false, replicaStatus: [peer: 15, store: 1, isEpochStale: false, attempts: 1, replica-epoch: 0, store-epoch: 0, store-state: resolved, store-liveness-state: reachable]}}"] [retry-times=0] [total-backoff-ms=0] [total-backoff-times=0] [max-exec-timeout-ms=20000] [total-region-errors=15-epoch_not_match:1]
[2024/04/26 19:48:06.901 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t;"]
[2024/04/26 19:48:06.933 +08:00] [INFO] [analyze.go:747] ["analyze table `util__ranger`.`t` has finished"] [partition=] ["job info"="analyze table all columns with 256 buckets, 500 topn, 1 samplerate"] ["start time"=2024/04/26 19:48:06.905 +08:00] ["end time"=2024/04/26 19:48:06.931 +08:00] [cost=26.401836ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/04/26 19:48:06.949 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where a = 1 and (b,c) in ((1,1),(2,3));"]
[2024/04/26 19:48:06.949 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a = 1 and (b,c) in ((1,1),(2,3));"]
[2024/04/26 19:48:06.950 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where a = 1 and ((b = 1 and c = 1) or (b = 2 and c = 3));"]
[2024/04/26 19:48:06.951 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a = 1 and ((b = 1 and c = 1) or (b = 2 and c = 3));"]
[2024/04/26 19:48:06.952 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where a = 1 and ((b = 1) or (b = 2 and c = 3));"]
[2024/04/26 19:48:06.952 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a = 1 and ((b = 1) or (b = 2 and c = 3));"]
[2024/04/26 19:48:06.953 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where (a,b) in ((1,1),(2,2)) and c = 3;"]
[2024/04/26 19:48:06.954 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where (a,b) in ((1,1),(2,2)) and c = 3;"]
[2024/04/26 19:48:06.955 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where ((a = 1 and b = 1) or (a = 2 and b = 2)) and c = 3;"]
[2024/04/26 19:48:06.955 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where ((a = 1 and b = 1) or (a = 2 and b = 2)) and c = 3;"]
[2024/04/26 19:48:06.956 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t use index(primary) where ((a = 1) or (a = 2 and b = 2)) and c = 3;"]
[2024/04/26 19:48:06.957 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t use index(primary) where ((a = 1) or (a = 2 and b = 2)) and c = 3;"]
[2024/04/26 19:48:06.958 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where (a,b) in ((1,1),(2,2)) and c > 2 and (a,b,c) in ((1,1,1),(2,2,3));"]
[2024/04/26 19:48:06.959 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where (a,b) in ((1,1),(2,2)) and c > 2 and (a,b,c) in ((1,1,1),(2,2,3));"]
[2024/04/26 19:48:06.960 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where (a,b) in ((1,1),(2,2)) and c > 2;"]
[2024/04/26 19:48:06.960 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where (a,b) in ((1,1),(2,2)) and c > 2;"]
[2024/04/26 19:48:06.961 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where ((a = 1 and b = 1) or (a = 2 and b = 2)) and c > 2;"]
[2024/04/26 19:48:06.962 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24636] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where ((a = 1 and b = 1) or (a = 2 and b = 2)) and c > 2;"]
[2024/04/26 19:48:06.962 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490876] [schemaVersion=24636] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/04/26 19:48:06.975 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20503, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20501, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:06.953 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:06.975 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20503, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20501, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:06.953 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/04/26 19:48:06.998 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20503] [conn=3248490876] [category=ddl] [job="ID:20503, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20501, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:06.953 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:07.018 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20503] [conn=3248490876] [category=ddl] [job="ID:20503, Type:drop table, State:running, SchemaState:write only, SchemaID:20478, TableID:20501, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:06.953 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:07.037 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20503] [conn=3248490876] [category=ddl] [job="ID:20503, Type:drop table, State:running, SchemaState:delete only, SchemaID:20478, TableID:20501, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:06.953 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:07.057 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20503] [tableIDs="[20501]"] [comment="drop table: table ID"]
[2024/04/26 19:48:07.058 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20503] [jobType="drop table"]
[2024/04/26 19:48:07.059 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20503] [conn=3248490876] [job="ID:20503, Type:drop table, State:synced, SchemaState:none, SchemaID:20478, TableID:20501, RowCount:0, ArgLen:3, start time: 2024-04-26 19:48:06.953 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:07.062 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20503]
[2024/04/26 19:48:07.062 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:07.063 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24636] [neededSchemaVersion=24639] ["start time"=397.848µs] [gotSchemaVersion=24639] [phyTblIDs="[20501]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/04/26 19:48:07.064 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490876] [schemaVersion=24639] [cur_db=util__ranger] [sql="create table t(a int, b int, c int, primary key(a,b));"] [user=root@%]
[2024/04/26 19:48:07.077 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20505, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20504, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:07.054 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:07.077 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20505, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20504, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:07.054 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table t(a int, b int, c int, primary key(a,b));"]
[2024/04/26 19:48:07.112 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20505] [conn=3248490876] [category=ddl] [job="ID:20505, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20504, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:07.054 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:07.132 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20505] [conn=3248490876] [job="ID:20505, Type:create table, State:synced, SchemaState:public, SchemaID:20478, TableID:20504, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:07.054 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:07.135 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20505]
[2024/04/26 19:48:07.135 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:07.135 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=14] ["first split key"=748000000000005018]
[2024/04/26 19:48:07.136 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005018] ["first new region left"="{Id:16638 StartKey:7480000000000050ff1500000000000000f8 EndKey:7480000000000050ff1800000000000000f8 RegionEpoch:{ConfVer:1 Version:8044} Peers:[id:16639 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/04/26 19:48:07.136 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16638]"]
[2024/04/26 19:48:07.137 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24639] [neededSchemaVersion=24640] ["start time"=521.015µs] [gotSchemaVersion=24640] [phyTblIDs="[20504]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/04/26 19:48:07.138 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24640] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t values(1,1,1),(2,2,3);"]
[2024/04/26 19:48:07.140 +08:00] [INFO] [region_request.go:1686] ["send request meet region error without retry"] [conn=3248490876] [session_alias=] [req-ts=449349441841790995] [req-type=Prewrite] [region="{ region id: 14, ver: 8043, confVer: 1 }"] [replica-read-type=leader] [stale-read=false] [request-sender="{rpcError:<nil>, replicaSelector: replicaSelectorV2{replicaReadType: leader, attempts: 1, cacheRegionIsValid: false, replicaStatus: [peer: 15, store: 1, isEpochStale: false, attempts: 1, replica-epoch: 0, store-epoch: 0, store-state: resolved, store-liveness-state: reachable]}}"] [retry-times=0] [total-backoff-ms=0] [total-backoff-times=0] [max-exec-timeout-ms=20000] [total-region-errors=15-epoch_not_match:1]
[2024/04/26 19:48:07.141 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24640] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t;"]
[2024/04/26 19:48:07.175 +08:00] [INFO] [analyze.go:747] ["analyze table `util__ranger`.`t` has finished"] [partition=] ["job info"="analyze table all columns with 256 buckets, 500 topn, 1 samplerate"] ["start time"=2024/04/26 19:48:07.144 +08:00] ["end time"=2024/04/26 19:48:07.174 +08:00] [cost=29.633868ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/04/26 19:48:07.192 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24640] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where (a,b) in ((1,1),(2,2)) and c = 3;"]
[2024/04/26 19:48:07.193 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24640] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where (a,b) in ((1,1),(2,2)) and c = 3;"]
[2024/04/26 19:48:07.193 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24640] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where ((a = 1 and b = 1) or (a = 2 and b = 2)) and c = 3;"]
[2024/04/26 19:48:07.194 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24640] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where ((a = 1 and b = 1) or (a = 2 and b = 2)) and c = 3;"]
[2024/04/26 19:48:07.195 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24640] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t use index(primary) where ((a = 1) or (a = 2 and b = 2)) and c = 3;"]
[2024/04/26 19:48:07.195 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24640] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t use index(primary) where ((a = 1) or (a = 2 and b = 2)) and c = 3;"]
[2024/04/26 19:48:07.197 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24640] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where ((a = 1 and b = 1) or (a = 2 and b = 2)) and c = 3 and (a = 1 or a = 2);"]
[2024/04/26 19:48:07.198 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24640] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where ((a = 1 and b = 1) or (a = 2 and b = 2)) and c = 3 and (a = 1 or a = 2);"]
[2024/04/26 19:48:07.199 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24640] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where (a,b) in ((1,1),(2,2)) and c > 2;"]
[2024/04/26 19:48:07.199 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24640] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where (a,b) in ((1,1),(2,2)) and c > 2;"]
[2024/04/26 19:48:07.204 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24640] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where ((a = 1 and b = 1) or (a = 2 and b = 2)) and c > 2;"]
[2024/04/26 19:48:07.204 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24640] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where ((a = 1 and b = 1) or (a = 2 and b = 2)) and c > 2;"]
[2024/04/26 19:48:07.205 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24640] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_regard_null_as_point`=FALSE"]
[2024/04/26 19:48:07.205 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490876] [schemaVersion=24640] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/04/26 19:48:07.218 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20506, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20504, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:07.204 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:07.218 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20506, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20504, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:07.204 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/04/26 19:48:07.239 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20506] [conn=3248490876] [category=ddl] [job="ID:20506, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20504, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:07.204 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:07.259 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20506] [conn=3248490876] [category=ddl] [job="ID:20506, Type:drop table, State:running, SchemaState:write only, SchemaID:20478, TableID:20504, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:07.204 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:07.277 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20506] [conn=3248490876] [category=ddl] [job="ID:20506, Type:drop table, State:running, SchemaState:delete only, SchemaID:20478, TableID:20504, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:07.204 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:07.295 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20506] [tableIDs="[20504]"] [comment="drop table: table ID"]
[2024/04/26 19:48:07.297 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20506] [jobType="drop table"]
[2024/04/26 19:48:07.297 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20506] [conn=3248490876] [job="ID:20506, Type:drop table, State:synced, SchemaState:none, SchemaID:20478, TableID:20504, RowCount:0, ArgLen:3, start time: 2024-04-26 19:48:07.204 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:07.301 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20506]
[2024/04/26 19:48:07.301 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:07.302 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24640] [neededSchemaVersion=24643] ["start time"=384.193µs] [gotSchemaVersion=24643] [phyTblIDs="[20504]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/04/26 19:48:07.303 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490876] [schemaVersion=24643] [cur_db=util__ranger] [sql="create table t(a int, b int, c int, key(a,b,c));"] [user=root@%]
[2024/04/26 19:48:07.316 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20508, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20507, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:07.304 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:07.316 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20508, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20507, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:07.304 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table t(a int, b int, c int, key(a,b,c));"]
[2024/04/26 19:48:07.342 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20508] [conn=3248490876] [category=ddl] [job="ID:20508, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20507, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:07.304 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:07.363 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20508] [conn=3248490876] [job="ID:20508, Type:create table, State:synced, SchemaState:public, SchemaID:20478, TableID:20507, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:07.304 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:07.367 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20508]
[2024/04/26 19:48:07.367 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:07.367 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=14] ["first split key"=74800000000000501b]
[2024/04/26 19:48:07.368 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=74800000000000501b] ["first new region left"="{Id:16640 StartKey:7480000000000050ff1800000000000000f8 EndKey:7480000000000050ff1b00000000000000f8 RegionEpoch:{ConfVer:1 Version:8045} Peers:[id:16641 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/04/26 19:48:07.368 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16640]"]
[2024/04/26 19:48:07.368 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24643] [neededSchemaVersion=24644] ["start time"=586.924µs] [gotSchemaVersion=24644] [phyTblIDs="[20507]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/04/26 19:48:07.370 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t values(1,2,2);"]
[2024/04/26 19:48:07.371 +08:00] [INFO] [region_request.go:1686] ["send request meet region error without retry"] [conn=3248490876] [session_alias=] [req-ts=449349441907326986] [req-type=Prewrite] [region="{ region id: 14, ver: 8044, confVer: 1 }"] [replica-read-type=leader] [stale-read=false] [request-sender="{rpcError:<nil>, replicaSelector: replicaSelectorV2{replicaReadType: leader, attempts: 1, cacheRegionIsValid: false, replicaStatus: [peer: 15, store: 1, isEpochStale: false, attempts: 1, replica-epoch: 0, store-epoch: 0, store-state: resolved, store-liveness-state: reachable]}}"] [retry-times=0] [total-backoff-ms=0] [total-backoff-times=0] [max-exec-timeout-ms=20000] [total-region-errors=15-epoch_not_match:1]
[2024/04/26 19:48:07.372 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where a = 1 and b in (1, 2) and c > 1;"]
[2024/04/26 19:48:07.373 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a = 1 and b in (1, 2) and c > 1;"]
[2024/04/26 19:48:07.374 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where a = 1 and (b = 1 or b = 2) and c > 1;"]
[2024/04/26 19:48:07.374 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a = 1 and (b = 1 or b = 2) and c > 1;"]
[2024/04/26 19:48:07.375 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where a = 1 and (b = 1 or b in (2, 3)) and c > 1;"]
[2024/04/26 19:48:07.376 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a = 1 and (b = 1 or b in (2, 3)) and c > 1;"]
[2024/04/26 19:48:07.377 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where a = 1 and (b = 1 or b = 2) and b = 3 and c > 1;"]
[2024/04/26 19:48:07.377 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a = 1 and (b = 1 or b = 2) and b = 3 and c > 1;"]
[2024/04/26 19:48:07.378 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where a = 1 and (b is null or b = 2);"]
[2024/04/26 19:48:07.378 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a = 1 and (b is null or b = 2);"]
[2024/04/26 19:48:07.379 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where a = 1 and (b is null or b = 2) and c > 1;"]
[2024/04/26 19:48:07.379 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a = 1 and (b is null or b = 2) and c > 1;"]
[2024/04/26 19:48:07.380 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where a = 1 and b is null and c > 1;"]
[2024/04/26 19:48:07.381 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a = 1 and b is null and c > 1;"]
[2024/04/26 19:48:07.382 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where a = 1 and b is null and b is null and c > 1;"]
[2024/04/26 19:48:07.382 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a = 1 and b is null and b is null and c > 1;"]
[2024/04/26 19:48:07.383 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where a = 1 and b is null and b = 1 and c > 1;"]
[2024/04/26 19:48:07.383 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a = 1 and b is null and b = 1 and c > 1;"]
[2024/04/26 19:48:07.384 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_regard_null_as_point`=DEFAULT"]
[2024/04/26 19:48:07.384 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24644] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_cost_model_version`=2"]
[2024/04/26 19:48:07.384 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490876] [schemaVersion=24644] [cur_db=util__ranger] [sql="drop table if exists t0;"] [user=root@%]
[2024/04/26 19:48:07.384 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490876] [schemaVersion=24644] [cur_db=util__ranger] [sql="CREATE TABLE t0(c0 TEXT(10));"] [user=root@%]
[2024/04/26 19:48:07.384 +08:00] [INFO] [ddl_api.go:1133] ["Automatically convert BLOB(10) to TINYBLOB"] [category=ddl]
[2024/04/26 19:48:07.397 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20510, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20509, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:07.354 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:07.397 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20510, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20509, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:07.354 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE TABLE t0(c0 TEXT(10));"]
[2024/04/26 19:48:07.418 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20510] [conn=3248490876] [category=ddl] [job="ID:20510, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20509, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:07.354 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:07.437 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20510] [conn=3248490876] [job="ID:20510, Type:create table, State:synced, SchemaState:public, SchemaID:20478, TableID:20509, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:07.354 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:07.441 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20510]
[2024/04/26 19:48:07.441 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:07.441 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=14] ["first split key"=74800000000000501d]
[2024/04/26 19:48:07.442 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=74800000000000501d] ["first new region left"="{Id:16642 StartKey:7480000000000050ff1b00000000000000f8 EndKey:7480000000000050ff1d00000000000000f8 RegionEpoch:{ConfVer:1 Version:8046} Peers:[id:16643 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/04/26 19:48:07.442 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16642]"]
[2024/04/26 19:48:07.442 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24644] [neededSchemaVersion=24645] ["start time"=565.465µs] [gotSchemaVersion=24645] [phyTblIDs="[20509]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/04/26 19:48:07.443 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24645] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="INSERT INTO t0(c0) VALUES (1);"]
[2024/04/26 19:48:07.445 +08:00] [INFO] [region_request.go:1686] ["send request meet region error without retry"] [conn=3248490876] [session_alias=] [req-ts=449349441920434196] [req-type=Prewrite] [region="{ region id: 14, ver: 8045, confVer: 1 }"] [replica-read-type=leader] [stale-read=false] [request-sender="{rpcError:<nil>, replicaSelector: replicaSelectorV2{replicaReadType: leader, attempts: 1, cacheRegionIsValid: false, replicaStatus: [peer: 15, store: 1, isEpochStale: false, attempts: 1, replica-epoch: 0, store-epoch: 0, store-state: resolved, store-liveness-state: reachable]}}"] [retry-times=0] [total-backoff-ms=0] [total-backoff-times=0] [max-exec-timeout-ms=20000] [total-region-errors=15-epoch_not_match:1]
[2024/04/26 19:48:07.446 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490876] [schemaVersion=24645] [cur_db=util__ranger] [sql="CREATE INDEX i0 ON t0(c0(255));"] [user=root@%]
[2024/04/26 19:48:07.458 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20511, Type:add index, State:queueing, SchemaState:none, SchemaID:20478, TableID:20509, RowCount:0, ArgLen:6, start time: 2024-04-26 19:48:07.454 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0; "] [table=true]
[2024/04/26 19:48:07.458 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20511, Type:add index, State:queueing, SchemaState:none, SchemaID:20478, TableID:20509, RowCount:0, ArgLen:6, start time: 2024-04-26 19:48:07.454 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"] [query="CREATE INDEX i0 ON t0(c0(255));"]
[2024/04/26 19:48:07.509 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20511] [conn=3248490876] [category=ddl] [job="ID:20511, Type:add index, State:queueing, SchemaState:none, SchemaID:20478, TableID:20509, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:07.454 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/04/26 19:48:07.510 +08:00] [INFO] [index.go:654] ["run add index job"] [category=ddl] [job="ID:20511, Type:add index, State:running, SchemaState:none, SchemaID:20478, TableID:20509, RowCount:0, ArgLen:6, start time: 2024-04-26 19:48:07.454 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"] [indexInfo="{\"id\":1,\"idx_name\":{\"O\":\"i0\",\"L\":\"i0\"},\"tbl_name\":{\"O\":\"\",\"L\":\"\"},\"idx_cols\":[{\"name\":{\"O\":\"c0\",\"L\":\"c0\"},\"offset\":0,\"length\":255}],\"state\":0,\"backfill_state\":0,\"comment\":\"\",\"index_type\":1,\"is_unique\":false,\"is_primary\":false,\"is_invisible\":false,\"is_global\":false,\"mv_index\":false}"]
[2024/04/26 19:48:07.537 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20511] [conn=3248490876] [category=ddl] [job="ID:20511, Type:add index, State:running, SchemaState:delete only, SchemaID:20478, TableID:20509, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:07.454 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/04/26 19:48:07.570 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20511] [conn=3248490876] [category=ddl] [job="ID:20511, Type:add index, State:running, SchemaState:write only, SchemaID:20478, TableID:20509, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:07.454 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/04/26 19:48:07.598 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20511] [conn=3248490876] [category=ddl] [job="ID:20511, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20478, TableID:20509, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:07.454 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/04/26 19:48:07.599 +08:00] [INFO] [index.go:857] ["index backfill state running"] [category=ddl] ["job ID"=20511] [table=t0] ["ingest mode"=true] [index=i0]
[2024/04/26 19:48:07.600 +08:00] [INFO] [reorg.go:718] ["job get table range"] [category=ddl] [jobID=20511] [physicalTableID=20509] [startKey=74800000000000501d5f728000000000000001] [endKey=74800000000000501d5f72800000000000000100]
[2024/04/26 19:48:07.624 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20511] [conn=3248490876] [category=ddl] [job="ID:20511, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20478, TableID:20509, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:07.454 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449349441959755788, LocalMode: false, UniqueWarnings:0"]
[2024/04/26 19:48:07.625 +08:00] [INFO] [index.go:857] ["index backfill state running"] [category=ddl] ["job ID"=20511] [table=t0] ["ingest mode"=true] [index=i0]
[2024/04/26 19:48:07.628 +08:00] [INFO] [index.go:2089] ["adjusted add-index task concurrency"] [category=ddl] [worker-cnt=4] [task-concurrency=4] [task-key=ddl/backfill/20511]
[2024/04/26 19:48:07.637 +08:00] [INFO] [index.go:2178] ["estimate row size"] [tableID=20509] [size=0] [error="less than 3 regions"]
[2024/04/26 19:48:07.645 +08:00] [INFO] [scheduler_manager.go:355] ["task scheduler started"] [task-id=660015]
[2024/04/26 19:48:07.645 +08:00] [INFO] [scheduler.go:120] ["schedule task"] [task-id=660015] [task-type=backfill] [allocated-slots=true] [state=pending] [concurrency=4]
[2024/04/26 19:48:08.146 +08:00] [INFO] [scheduler.go:422] ["switch to next step"] [task-id=660015] [task-type=backfill] [allocated-slots=true] [current-step=init] [next-step=read-index]
[2024/04/26 19:48:08.146 +08:00] [INFO] [scheduler.go:446] ["eligible instances"] [task-id=660015] [task-type=backfill] [allocated-slots=true] [num=1]
[2024/04/26 19:48:08.147 +08:00] [INFO] [backfilling_dist_scheduler.go:95] ["on next subtasks batch"] [category=ddl] [type=backfill] [task-id=660015] [curr-step=init] [next-step=read-index]
[2024/04/26 19:48:08.149 +08:00] [INFO] [scheduler.go:472] ["schedule subtasks"] [task-id=660015] [task-type=backfill] [allocated-slots=true] [state=pending] [step=read-index] [concurrency=4] [subtasks=1]
[2024/04/26 19:48:08.201 +08:00] [INFO] [manager.go:328] ["task executor started"] [task-id=660015] [type=backfill] [remaining-slots=4]
[2024/04/26 19:48:08.504 +08:00] [INFO] [task_executor.go:301] ["execute task step start"] [task-id=660015] [task-type=backfill] [step=read-index] [mem-limit-percent=0.7] [server-mem-limit=80%] [resource="[CPU=4, Mem=16GiB]"]
[2024/04/26 19:48:08.505 +08:00] [INFO] [config.go:169] ["change memory setting for ingest"] ["local writer memory cache size"=134217728] ["engine memory cache size"=536870912] ["range concurrency"=4]
[2024/04/26 19:48:08.505 +08:00] [INFO] [backend_mgr.go:248] ["create local backend for adding index"] [category=ddl-ingest] [sortDir=/tmp/tidb/tmp_ddl-42545/20511] [keyspaceName=]
[2024/04/26 19:48:08.506 +08:00] [INFO] [pd_service_discovery.go:1016] ["[pd] switch leader"] [new-leader=http://127.0.0.1:2379] [old-leader=]
[2024/04/26 19:48:08.506 +08:00] [INFO] [pd_service_discovery.go:498] ["[pd] init cluster id"] [cluster-id=7362130818876274454]
[2024/04/26 19:48:08.507 +08:00] [INFO] [client.go:606] ["[pd] changing service mode"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/04/26 19:48:08.507 +08:00] [INFO] [tso_client.go:236] ["[tso] switch dc tso global allocator serving url"] [dc-location=global] [new-url=http://127.0.0.1:2379]
[2024/04/26 19:48:08.507 +08:00] [INFO] [tso_dispatcher.go:359] ["[tso] tso dispatcher created"] [dc-location=global]
[2024/04/26 19:48:08.507 +08:00] [INFO] [client.go:612] ["[pd] service mode changed"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/04/26 19:48:08.509 +08:00] [INFO] [local.go:682] ["multi ingest support"] [category=ddl-ingest]
[2024/04/26 19:48:08.509 +08:00] [INFO] [local.go:704] ["TiKV server side free space check is enabled, so lightning will turn it off"] [category=ddl-ingest]
[2024/04/26 19:48:08.509 +08:00] [INFO] [backend_mgr.go:161] ["create one backend for an DDL job"] ["job ID"=20511] ["current memory usage"=33776] ["max memory quota"=17179869184] ["is unique index"=false]
[2024/04/26 19:48:08.509 +08:00] [INFO] [backfilling_read_index.go:91] ["read index executor init subtask exec env"] [category=ddl]
[2024/04/26 19:48:08.514 +08:00] [INFO] [backfilling_read_index.go:96] ["read index executor run subtask"] [category=ddl] ["use cloud"=false]
[2024/04/26 19:48:08.516 +08:00] [INFO] [backend.go:253] ["open engine"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba]
[2024/04/26 19:48:08.516 +08:00] [INFO] [engine_mgr.go:81] ["open an engine for index reorg task"] ["job ID"=20511] ["index ID"=1] ["current memory usage"=671122560] ["memory limitation"=17179869184] ["current writer count"=1]
[2024/04/26 19:48:08.516 +08:00] [INFO] [backfilling_operators.go:160] ["build add index local storage operators"] [task-id=660015] [subtask-id=60015] [jobID=20511] [avgRowSize=0] [reader=2] [writer=4]
[2024/04/26 19:48:08.516 +08:00] [INFO] [backfilling.go:416] ["split table range from PD"] [category=ddl] [physicalTableID=20509] ["start key"=74800000000000501d5f728000000000000001] ["end key"=74800000000000501d5f72800000000000000100]
[2024/04/26 19:48:08.516 +08:00] [INFO] [backfilling_operators.go:451] ["start a table scan task"] [task-id=660015] [subtask-id=60015] [id=1] [task="TableScanTask: id=1, startKey=74800000000000501d5f728000000000000001, endKey=74800000000000501d5f72800000000000000100"]
[2024/04/26 19:48:08.528 +08:00] [INFO] [engine.go:198] ["create one local writer for index reorg task"] ["job ID"=20511] ["index ID"=1] ["worker ID"=1] ["allocate memory"=40] ["current memory usage"=671122600] ["max memory quota"=17179869184]
[2024/04/26 19:48:08.540 +08:00] [INFO] [engine.go:198] ["create one local writer for index reorg task"] ["job ID"=20511] ["index ID"=1] ["worker ID"=2] ["allocate memory"=40] ["current memory usage"=671122640] ["max memory quota"=17179869184]
[2024/04/26 19:48:08.541 +08:00] [INFO] [backfilling_operators.go:697] ["finish a index ingest task"] [task-id=660015] [subtask-id=60015] [id=1]
[2024/04/26 19:48:08.552 +08:00] [INFO] [engine.go:198] ["create one local writer for index reorg task"] ["job ID"=20511] ["index ID"=1] ["worker ID"=3] ["allocate memory"=40] ["current memory usage"=672171256] ["max memory quota"=17179869184]
[2024/04/26 19:48:08.565 +08:00] [INFO] [engine.go:198] ["create one local writer for index reorg task"] ["job ID"=20511] ["index ID"=1] ["worker ID"=4] ["allocate memory"=40] ["current memory usage"=672171296] ["max memory quota"=17179869184]
[2024/04/26 19:48:08.571 +08:00] [INFO] [engine.go:867] ["write data to local DB"] [category=ddl-ingest] [size=39] [kvs=1] [files=1] [sstFileSize=945] [file=/tmp/tidb/tmp_ddl-42545/20511/4229afb8-665d-5dce-bb97-2afa316b67ba.sst/e53f94d5-b078-40cf-a678-1ae5a4f93f1b.sst] [firstKey=74800000000000501D5F698000000000000001013100000000000000F8038000000000000001] [lastKey=74800000000000501D5F698000000000000001013100000000000000F8038000000000000001]
[2024/04/26 19:48:08.586 +08:00] [INFO] [backend.go:215] ["acquire distributed flush lock success"] [jobID=20511]
[2024/04/26 19:48:08.586 +08:00] [INFO] [backend.go:237] ["do a partial import data into the storage"] ["index ID"=1] ["usage info"="disk usage: 142905409536/467794132992, backend usage: 0"]
[2024/04/26 19:48:08.586 +08:00] [INFO] [backend.go:372] ["import start"] [category=ddl-ingest] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba] [retryCnt=0]
[2024/04/26 19:48:08.587 +08:00] [WARN] [local.go:1687] ["get region split size and keys failed"] [category=ddl-ingest] [error="Get \"http://127.0.0.1:20165/config\": dial tcp 127.0.0.1:20165: connect: connection refused"] [store=127.0.0.1:20165]
[2024/04/26 19:48:08.587 +08:00] [WARN] [local.go:1270] ["fail to get region split keys and size"] [category=ddl-ingest] [error="get region split size and keys failed"]
[2024/04/26 19:48:08.587 +08:00] [INFO] [local.go:1280] ["pause pd scheduler of table scope"] [category=ddl-ingest]
[2024/04/26 19:48:08.608 +08:00] [INFO] [local.go:1318] ["start import engine"] [category=ddl-ingest] [uuid=4229afb8-665d-5dce-bb97-2afa316b67ba] ["region ranges"=1] [count=1] [size=39]
[2024/04/26 19:48:08.608 +08:00] [INFO] [local.go:835] ["import engine ranges"] [category=ddl-ingest] [count=1]
[2024/04/26 19:48:08.613 +08:00] [INFO] [local.go:1329] ["import engine success"] [category=ddl-ingest] [uuid=4229afb8-665d-5dce-bb97-2afa316b67ba] [size=39] [kvs=1] [importedSize=39] [importedCount=1]
[2024/04/26 19:48:08.614 +08:00] [INFO] [backend.go:378] ["import completed"] [category=ddl-ingest] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba] [retryCnt=0] [takeTime=28.080229ms] []
[2024/04/26 19:48:08.617 +08:00] [INFO] [backend.go:221] ["release distributed flush lock success"] [jobID=20511]
[2024/04/26 19:48:08.624 +08:00] [INFO] [backfilling_read_index.go:151] ["read index executor cleanup subtask exec env"]
[2024/04/26 19:48:08.624 +08:00] [INFO] [backend.go:330] ["engine close start"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba]
[2024/04/26 19:48:08.624 +08:00] [INFO] [backend.go:332] ["engine close completed"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba] [takeTime=634.802µs] []
[2024/04/26 19:48:08.624 +08:00] [INFO] [backend.go:391] ["cleanup start"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba]
[2024/04/26 19:48:08.625 +08:00] [INFO] [backend.go:393] ["cleanup completed"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba] [takeTime=435.721µs] []
[2024/04/26 19:48:08.625 +08:00] [INFO] [pd_service_discovery.go:550] ["[pd] exit member loop due to context canceled"]
[2024/04/26 19:48:08.625 +08:00] [INFO] [tso_dispatcher.go:455] ["[tso] stop fetching the pending tso requests due to context canceled"] [dc-location=global]
[2024/04/26 19:48:08.625 +08:00] [INFO] [tso_dispatcher.go:214] ["exit tso requests cancel loop"]
[2024/04/26 19:48:08.625 +08:00] [INFO] [tso_dispatcher.go:380] ["[tso] exit tso dispatcher"] [dc-location=global]
[2024/04/26 19:48:08.625 +08:00] [INFO] [resource_manager_client.go:295] ["[resource manager] exit resource token dispatcher"]
[2024/04/26 19:48:08.625 +08:00] [INFO] [tso_batch_controller.go:158] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=5] [collected-request-count=0] [pending-request-count=0]
[2024/04/26 19:48:08.625 +08:00] [INFO] [tso_dispatcher.go:268] ["exit tso dispatcher loop"]
[2024/04/26 19:48:08.625 +08:00] [INFO] [tso_client.go:140] ["closing tso client"]
[2024/04/26 19:48:08.625 +08:00] [INFO] [tso_client.go:145] ["close tso client"]
[2024/04/26 19:48:08.625 +08:00] [INFO] [tso_batch_controller.go:158] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=5] [collected-request-count=0] [pending-request-count=0]
[2024/04/26 19:48:08.625 +08:00] [INFO] [tso_client.go:155] ["tso client is closed"]
[2024/04/26 19:48:08.625 +08:00] [INFO] [pd_service_discovery.go:637] ["[pd] close pd service discovery client"]
[2024/04/26 19:48:08.625 +08:00] [INFO] [client.go:320] ["[pd] http client closed"] [source=lightning]
[2024/04/26 19:48:08.625 +08:00] [INFO] [tso_client.go:140] ["closing tso client"]
[2024/04/26 19:48:08.625 +08:00] [INFO] [tso_client.go:145] ["close tso client"]
[2024/04/26 19:48:08.625 +08:00] [INFO] [tso_batch_controller.go:158] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=5] [collected-request-count=0] [pending-request-count=0]
[2024/04/26 19:48:08.625 +08:00] [INFO] [tso_client.go:155] ["tso client is closed"]
[2024/04/26 19:48:08.625 +08:00] [INFO] [backend_mgr.go:309] ["close one backend for DDL job"] ["job ID"=20511] ["current memory usage"=33720] ["max memory quota"=17179869184]
[2024/04/26 19:48:08.626 +08:00] [INFO] [task_executor.go:309] ["execute task step completed"] [task-id=660015] [task-type=backfill] [step=read-index] [mem-limit-percent=0.7] [server-mem-limit=80%] [resource="[CPU=4, Mem=16GiB]"] [takeTime=121.35586ms] []
[2024/04/26 19:48:08.648 +08:00] [INFO] [scheduler.go:422] ["switch to next step"] [task-id=660015] [task-type=backfill] [allocated-slots=true] [current-step=read-index] [next-step=done]
[2024/04/26 19:48:08.848 +08:00] [INFO] [reorg.go:232] ["run reorg job done"] [category=ddl] ["handled rows"=1]
[2024/04/26 19:48:08.882 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20511] [conn=3248490876] [category=ddl] [job="ID:20511, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20478, TableID:20509, RowCount:1, ArgLen:0, start time: 2024-04-26 19:48:07.454 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449349441959755788, LocalMode: false, UniqueWarnings:0"]
[2024/04/26 19:48:08.882 +08:00] [INFO] [index.go:880] ["index backfill state ready to merge"] [category=ddl] ["job ID"=20511] [table=t0] [index=i0]
[2024/04/26 19:48:08.908 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20511] [conn=3248490876] [category=ddl] [job="ID:20511, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20478, TableID:20509, RowCount:1, ArgLen:0, start time: 2024-04-26 19:48:07.454 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/04/26 19:48:08.909 +08:00] [INFO] [reorg.go:718] ["job get table range"] [category=ddl] [jobID=20511] [physicalTableID=20509] [startKey=74800000000000501d5f69ffff000000000001] [endKey=74800000000000501d5f69ffff000000000001ff]
[2024/04/26 19:48:08.927 +08:00] [INFO] [manager.go:332] ["task executor exit"] [task-id=660015] [type=backfill]
[2024/04/26 19:48:08.934 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20511] [conn=3248490876] [category=ddl] [job="ID:20511, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20478, TableID:20509, RowCount:1, ArgLen:0, start time: 2024-04-26 19:48:07.454 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449349442313650178, LocalMode: false, UniqueWarnings:0"]
[2024/04/26 19:48:08.935 +08:00] [INFO] [index.go:1928] ["start to merge temp index"] [category=ddl] [job="ID:20511, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20478, TableID:20509, RowCount:1, ArgLen:6, start time: 2024-04-26 19:48:07.454 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449349442313650178, LocalMode: false, UniqueWarnings:0"] [reorgInfo="CurrElementType:_idx_,CurrElementID:1,StartKey:74800000000000501d5f69ffff000000000001,EndKey:74800000000000501d5f69ffff000000000001ff,First:false,PhysicalTableID:20509,Ingest mode:false"]
[2024/04/26 19:48:08.937 +08:00] [INFO] [backfilling.go:416] ["split table range from PD"] [category=ddl] [physicalTableID=20509] ["start key"=74800000000000501d5f69ffff000000000001] ["end key"=74800000000000501d5f69ffff000000000001ff]
[2024/04/26 19:48:08.937 +08:00] [INFO] [backfilling.go:692] ["start backfill workers to reorg record"] [category=ddl] [type="merge temporary index"] [workerCnt=4] [regionCnt=1] [startKey=74800000000000501d5f69ffff000000000001] [endKey=74800000000000501d5f69ffff000000000001ff]
[2024/04/26 19:48:08.937 +08:00] [INFO] [region_request.go:1686] ["send request meet region error without retry"] [req-ts=18446744073709551615] [req-type=Scan] [region="{ region id: 14, ver: 8046, confVer: 1 }"] [replica-read-type=leader] [stale-read=false] [request-sender="{rpcError:<nil>, replicaSelector: replicaSelectorV2{replicaReadType: leader, attempts: 1, cacheRegionIsValid: false, replicaStatus: [peer: 15, store: 1, isEpochStale: false, attempts: 1, replica-epoch: 0, store-epoch: 0, store-state: resolved, store-liveness-state: reachable]}}"] [retry-times=0] [total-backoff-ms=0] [total-backoff-times=0] [max-exec-timeout-ms=60000] [total-region-errors=15-epoch_not_match:1]
[2024/04/26 19:48:08.938 +08:00] [INFO] [backfilling.go:475] ["get backfill range task, change end key"] [category=ddl] [id=1] [pTbl=20509] ["end key"=74800000000000501d5f69ffff000000000001ff] ["current end key"=74800000000000501d5f69ffff00000000000100]
[2024/04/26 19:48:08.938 +08:00] [INFO] [backfilling.go:369] ["backfill worker exit"] [category=ddl] [worker="backfill-worker 2, tp merge temporary index"] [jobID=20511]
[2024/04/26 19:48:08.938 +08:00] [INFO] [backfilling.go:369] ["backfill worker exit"] [category=ddl] [worker="backfill-worker 3, tp merge temporary index"] [jobID=20511]
[2024/04/26 19:48:08.938 +08:00] [INFO] [backfilling.go:369] ["backfill worker exit"] [category=ddl] [worker="backfill-worker 1, tp merge temporary index"] [jobID=20511]
[2024/04/26 19:48:08.938 +08:00] [INFO] [backfilling.go:330] ["backfill worker finish task"] [category=ddl] [worker="backfill-worker 0, tp merge temporary index"] [task="taskID: 1, physicalTableID: 20509, range: [74800000000000501d5f69ffff000000000001, 74800000000000501d5f69ffff00000000000100), jobID: 20511"] ["added count"=0] ["scan count"=0] ["next key"=74800000000000501d5f69ffff0000000000010000] ["take time"=446.742µs]
[2024/04/26 19:48:08.938 +08:00] [INFO] [backfilling.go:369] ["backfill worker exit"] [category=ddl] [worker="backfill-worker 0, tp merge temporary index"] [jobID=20511]
[2024/04/26 19:48:08.938 +08:00] [INFO] [backfilling.go:632] ["backfill workers successfully processed"] [category=ddl] [element=ID:1,TypeKey:_idx_] ["total added count"=1] ["start key"=74800000000000501d5f69ffff000000000001]
[2024/04/26 19:48:08.938 +08:00] [INFO] [reorg.go:232] ["run reorg job done"] [category=ddl] ["handled rows"=1]
[2024/04/26 19:48:08.944 +08:00] [INFO] [index.go:781] ["run add index job done"] [category=ddl] [charset=utf8mb4] [collation=utf8mb4_general_ci]
[2024/04/26 19:48:08.969 +08:00] [INFO] [delete_range.go:422] ["insert into delete-range indices"] [category=ddl] [jobID=20511] [tableID=20509] [indexIDs="[9223090561878065153]"] [comment="add index: physical table ID(s)"]
[2024/04/26 19:48:08.970 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20511] [jobType="add index"]
[2024/04/26 19:48:08.971 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20511] [conn=3248490876] [job="ID:20511, Type:add index, State:synced, SchemaState:public, SchemaID:20478, TableID:20509, RowCount:1, ArgLen:3, start time: 2024-04-26 19:48:07.454 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449349442313650178, LocalMode: false, UniqueWarnings:0"]
[2024/04/26 19:48:08.975 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20511]
[2024/04/26 19:48:08.975 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:08.978 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24645] [neededSchemaVersion=24651] ["start time"=1.474291ms] [gotSchemaVersion=24651] [phyTblIDs="[20509,20509,20509,20509,20509,20509]"] [actionTypes="[7,7,7,7,7,7]"] [diffTypes="[\"add index\",\"add index\",\"add index\",\"add index\",\"add index\",\"add index\"]"]
[2024/04/26 19:48:08.979 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24651] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t0;"]
[2024/04/26 19:48:09.011 +08:00] [INFO] [analyze.go:747] ["analyze table `util__ranger`.`t0` has finished"] [partition=] ["job info"="analyze table all columns with 256 buckets, 500 topn, 1 samplerate"] ["start time"=2024/04/26 19:48:08.983 +08:00] ["end time"=2024/04/26 19:48:09.010 +08:00] [cost=26.388291ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/04/26 19:48:09.022 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24651] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select * from t0 where c0;"]
[2024/04/26 19:48:09.023 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24651] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select * from t0 where c0 and c0 > '123';"]
[2024/04/26 19:48:09.023 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24651] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select * from t0 where c0 and c0 <> '123';"]
[2024/04/26 19:48:09.024 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24651] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select * from t0 where c0 is true;"]
[2024/04/26 19:48:09.024 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24651] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select * from t0 where c0 is false;"]
[2024/04/26 19:48:09.025 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24651] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select * from t0 where c0 and c0 in ('123','456','789');"]
[2024/04/26 19:48:09.025 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24651] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select * FROM t0 WHERE ('a' != t0.c0) AND t0.c0;"]
[2024/04/26 19:48:09.025 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24651] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_cost_model_version`=DEFAULT"]
[2024/04/26 19:48:09.026 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24651] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_cost_model_version`=2"]
[2024/04/26 19:48:09.026 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490876] [schemaVersion=24651] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/04/26 19:48:09.038 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20512, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20507, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:09.004 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:09.039 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20512, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20507, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:09.004 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/04/26 19:48:09.064 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20512] [conn=3248490876] [category=ddl] [job="ID:20512, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20507, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.004 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.084 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20512] [conn=3248490876] [category=ddl] [job="ID:20512, Type:drop table, State:running, SchemaState:write only, SchemaID:20478, TableID:20507, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.004 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.104 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20512] [conn=3248490876] [category=ddl] [job="ID:20512, Type:drop table, State:running, SchemaState:delete only, SchemaID:20478, TableID:20507, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.004 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.131 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20512] [tableIDs="[20507]"] [comment="drop table: table ID"]
[2024/04/26 19:48:09.133 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20512] [jobType="drop table"]
[2024/04/26 19:48:09.133 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20512] [conn=3248490876] [job="ID:20512, Type:drop table, State:synced, SchemaState:none, SchemaID:20478, TableID:20507, RowCount:0, ArgLen:3, start time: 2024-04-26 19:48:09.004 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.137 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20512]
[2024/04/26 19:48:09.137 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:09.138 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24651] [neededSchemaVersion=24654] ["start time"=514.922µs] [gotSchemaVersion=24654] [phyTblIDs="[20507]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/04/26 19:48:09.140 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490876] [schemaVersion=24654] [cur_db=util__ranger] [sql="create table t(a int primary key, b int, c int, d int, e int, index idx(b,c,d));"] [user=root@%]
[2024/04/26 19:48:09.146 +08:00] [INFO] [scheduler_manager.go:364] ["task scheduler exist"] [task-id=660015]
[2024/04/26 19:48:09.148 +08:00] [INFO] [scheduler_manager.go:410] ["cleanup routine start"]
[2024/04/26 19:48:09.148 +08:00] [INFO] [scheduler_manager.go:426] ["cleanup task"] [task-id=660015]
[2024/04/26 19:48:09.153 +08:00] [INFO] [scheduler_manager.go:419] ["cleanup routine success"]
[2024/04/26 19:48:09.154 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20514, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20513, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:09.104 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:09.154 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20514, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20513, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:09.104 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table t(a int primary key, b int, c int, d int, e int, index idx(b,c,d));"]
[2024/04/26 19:48:09.189 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20514] [conn=3248490876] [category=ddl] [job="ID:20514, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20513, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.104 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.213 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20514] [conn=3248490876] [job="ID:20514, Type:create table, State:synced, SchemaState:public, SchemaID:20478, TableID:20513, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.104 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.217 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20514]
[2024/04/26 19:48:09.217 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:09.217 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=14] ["first split key"=748000000000005021]
[2024/04/26 19:48:09.218 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005021] ["first new region left"="{Id:16648 StartKey:7480000000000050ff1d5f698000000000ff0000010131000000ff00000000f8038000ff0000000000010000fe EndKey:7480000000000050ff2100000000000000f8 RegionEpoch:{ConfVer:1 Version:8049} Peers:[id:16649 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/04/26 19:48:09.218 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16648]"]
[2024/04/26 19:48:09.218 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24654] [neededSchemaVersion=24655] ["start time"=642.906µs] [gotSchemaVersion=24655] [phyTblIDs="[20513]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/04/26 19:48:09.219 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24655] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t values(1,1,1,1,2),(2,1,2,1,0);"]
[2024/04/26 19:48:09.220 +08:00] [INFO] [region_request.go:1686] ["send request meet region error without retry"] [conn=3248490876] [session_alias=] [req-ts=449349442392293385] [req-type=Prewrite] [region="{ region id: 14, ver: 8048, confVer: 1 }"] [replica-read-type=leader] [stale-read=false] [request-sender="{rpcError:<nil>, replicaSelector: replicaSelectorV2{replicaReadType: leader, attempts: 1, cacheRegionIsValid: false, replicaStatus: [peer: 15, store: 1, isEpochStale: false, attempts: 1, replica-epoch: 0, store-epoch: 0, store-state: resolved, store-liveness-state: reachable]}}"] [retry-times=0] [total-backoff-ms=0] [total-backoff-times=0] [max-exec-timeout-ms=20000] [total-region-errors=15-epoch_not_match:1]
[2024/04/26 19:48:09.220 +08:00] [WARN] [prewrite.go:382] ["1pc failed and fallbacks to normal commit procedure"] [conn=3248490876] [session_alias=] [startTS=449349442392293385]
[2024/04/26 19:48:09.222 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24655] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t;"]
[2024/04/26 19:48:09.264 +08:00] [INFO] [analyze.go:747] ["analyze table `util__ranger`.`t` has finished"] [partition=] ["job info"="analyze table all columns with 256 buckets, 500 topn, 1 samplerate"] ["start time"=2024/04/26 19:48:09.226 +08:00] ["end time"=2024/04/26 19:48:09.262 +08:00] [cost=36.600303ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/04/26 19:48:09.285 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24655] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select t.e in (select count(*) from t s use index(idx), t t1 where s.b = 1 and s.c in (1, 2) and s.d = t.a and s.a = t1.a) from t;"]
[2024/04/26 19:48:09.286 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24655] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select t.e in (select count(*) from t s use index(idx), t t1 where s.b = 1 and s.c in (1, 2) and s.d = t.a and s.a = t1.a) from t;"]
[2024/04/26 19:48:09.288 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24655] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_cost_model_version`=DEFAULT"]
[2024/04/26 19:48:09.288 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490876] [schemaVersion=24655] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/04/26 19:48:09.302 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20515, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20513, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:09.254 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:09.302 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20515, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20513, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:09.254 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/04/26 19:48:09.328 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20515] [conn=3248490876] [category=ddl] [job="ID:20515, Type:drop table, State:queueing, SchemaState:public, SchemaID:20478, TableID:20513, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.254 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.353 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20515] [conn=3248490876] [category=ddl] [job="ID:20515, Type:drop table, State:running, SchemaState:write only, SchemaID:20478, TableID:20513, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.254 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.379 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20515] [conn=3248490876] [category=ddl] [job="ID:20515, Type:drop table, State:running, SchemaState:delete only, SchemaID:20478, TableID:20513, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.254 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.400 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20515] [tableIDs="[20513]"] [comment="drop table: table ID"]
[2024/04/26 19:48:09.402 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20515] [jobType="drop table"]
[2024/04/26 19:48:09.402 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20515] [conn=3248490876] [job="ID:20515, Type:drop table, State:synced, SchemaState:none, SchemaID:20478, TableID:20513, RowCount:0, ArgLen:3, start time: 2024-04-26 19:48:09.254 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.405 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20515]
[2024/04/26 19:48:09.405 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:09.406 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24655] [neededSchemaVersion=24658] ["start time"=374.715µs] [gotSchemaVersion=24658] [phyTblIDs="[20513]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/04/26 19:48:09.407 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490876] [schemaVersion=24658] [cur_db=util__ranger] [sql="create table t(a int not null, b int not null, primary key(a,b));"] [user=root@%]
[2024/04/26 19:48:09.421 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20517, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20516, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:09.404 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:09.421 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20517, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20516, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:09.404 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table t(a int not null, b int not null, primary key(a,b));"]
[2024/04/26 19:48:09.459 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20517] [conn=3248490876] [category=ddl] [job="ID:20517, Type:create table, State:queueing, SchemaState:none, SchemaID:20478, TableID:20516, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.404 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.479 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20517] [conn=3248490876] [job="ID:20517, Type:create table, State:synced, SchemaState:public, SchemaID:20478, TableID:20516, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.404 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.482 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20517]
[2024/04/26 19:48:09.482 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:09.482 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=14] ["first split key"=748000000000005024]
[2024/04/26 19:48:09.483 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005024] ["first new region left"="{Id:16650 StartKey:7480000000000050ff2100000000000000f8 EndKey:7480000000000050ff2400000000000000f8 RegionEpoch:{ConfVer:1 Version:8050} Peers:[id:16651 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/04/26 19:48:09.483 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16650]"]
[2024/04/26 19:48:09.483 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24658] [neededSchemaVersion=24659] ["start time"=588.303µs] [gotSchemaVersion=24659] [phyTblIDs="[20516]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/04/26 19:48:09.484 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24659] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t values(1,2);"]
[2024/04/26 19:48:09.486 +08:00] [INFO] [region_request.go:1686] ["send request meet region error without retry"] [conn=3248490876] [session_alias=] [req-ts=449349442457829395] [req-type=Prewrite] [region="{ region id: 14, ver: 8049, confVer: 1 }"] [replica-read-type=leader] [stale-read=false] [request-sender="{rpcError:<nil>, replicaSelector: replicaSelectorV2{replicaReadType: leader, attempts: 1, cacheRegionIsValid: false, replicaStatus: [peer: 15, store: 1, isEpochStale: false, attempts: 1, replica-epoch: 0, store-epoch: 0, store-state: resolved, store-liveness-state: reachable]}}"] [retry-times=0] [total-backoff-ms=0] [total-backoff-times=0] [max-exec-timeout-ms=20000] [total-region-errors=15-epoch_not_match:1]
[2024/04/26 19:48:09.487 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24659] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t;"]
[2024/04/26 19:48:09.513 +08:00] [INFO] [analyze.go:747] ["analyze table `util__ranger`.`t` has finished"] [partition=] ["job info"="analyze table all columns with 256 buckets, 500 topn, 1 samplerate"] ["start time"=2024/04/26 19:48:09.491 +08:00] ["end time"=2024/04/26 19:48:09.511 +08:00] [cost=19.970372ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/04/26 19:48:09.525 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24659] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select * from (select * from t union all select a, b from t) sub where a > 0;"]
[2024/04/26 19:48:09.526 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490876] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24659] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from (select * from t union all select ifnull(a,b), b from t) sub where a > 0;"]
[2024/04/26 19:48:09.527 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490880] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24659] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="use `test`"]
[2024/04/26 19:48:09.527 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490880] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24659] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`time_zone`=_UTF8MB4'Asia/Shanghai'"]
[2024/04/26 19:48:09.527 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490880] [schemaVersion=24659] [cur_db=test] [sql="drop database `util__ranger`"] [user=root@%]
[2024/04/26 19:48:09.539 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20518, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20478, TableID:0, RowCount:0, ArgLen:1, start time: 2024-04-26 19:48:09.504 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:09.539 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20518, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20478, TableID:0, RowCount:0, ArgLen:1, start time: 2024-04-26 19:48:09.504 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop database `util__ranger`"]
[2024/04/26 19:48:09.561 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20518] [conn=3248490880] [category=ddl] [job="ID:20518, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20478, TableID:0, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.504 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.584 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20518] [conn=3248490880] [category=ddl] [job="ID:20518, Type:drop schema, State:running, SchemaState:write only, SchemaID:20478, TableID:0, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.504 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.605 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20518] [conn=3248490880] [category=ddl] [job="ID:20518, Type:drop schema, State:running, SchemaState:delete only, SchemaID:20478, TableID:0, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.504 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.624 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20518] [tableIDs="[20482,20484,20495,20509,20516]"] [comment="drop schema: table IDs"]
[2024/04/26 19:48:09.626 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20518] [jobType="drop schema"]
[2024/04/26 19:48:09.627 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20518] [conn=3248490880] [job="ID:20518, Type:drop schema, State:synced, SchemaState:none, SchemaID:20478, TableID:0, RowCount:0, ArgLen:1, start time: 2024-04-26 19:48:09.504 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.630 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20518]
[2024/04/26 19:48:09.630 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:09.631 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24659] [neededSchemaVersion=24662] ["start time"=363.406µs] [gotSchemaVersion=24662] [phyTblIDs="[20482,20484,20495,20509,20516]"] [actionTypes="[2,2,2,2,2]"] [diffTypes="[\"drop schema\",\"drop schema\",\"drop schema\"]"]
[2024/04/26 19:48:09.632 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490882] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24662] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="use `test`"]
[2024/04/26 19:48:09.632 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490882] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24662] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`time_zone`=_UTF8MB4'Asia/Shanghai'"]
[2024/04/26 19:48:09.633 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490882] [schemaVersion=24662] [cur_db=test] [sql="create database `window_function`"] [user=root@%]
[2024/04/26 19:48:09.645 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20520, Type:create schema, State:queueing, SchemaState:none, SchemaID:20519, TableID:0, RowCount:0, ArgLen:1, start time: 2024-04-26 19:48:09.604 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:09.645 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20520, Type:create schema, State:queueing, SchemaState:none, SchemaID:20519, TableID:0, RowCount:0, ArgLen:1, start time: 2024-04-26 19:48:09.604 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create database `window_function`"]
[2024/04/26 19:48:09.673 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20520] [conn=3248490882] [category=ddl] [job="ID:20520, Type:create schema, State:queueing, SchemaState:none, SchemaID:20519, TableID:0, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.604 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.693 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20520] [conn=3248490882] [job="ID:20520, Type:create schema, State:synced, SchemaState:public, SchemaID:20519, TableID:0, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.604 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.696 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20520]
[2024/04/26 19:48:09.696 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:09.697 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24662] [neededSchemaVersion=24663] ["start time"=246.019µs] [gotSchemaVersion=24663] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"create schema\"]"]
[2024/04/26 19:48:09.699 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24663] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="use `test`"]
[2024/04/26 19:48:09.699 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24663] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`time_zone`=_UTF8MB4'Asia/Shanghai'"]
[2024/04/26 19:48:09.699 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490886] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24663] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="use `test`"]
[2024/04/26 19:48:09.700 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490886] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24663] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`time_zone`=_UTF8MB4'Asia/Shanghai'"]
[2024/04/26 19:48:09.700 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490886] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24663] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SELECT tidb_version()"]
[2024/04/26 19:48:09.700 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24663] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_init_chunk_size`=1"]
[2024/04/26 19:48:09.700 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24663] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_max_chunk_size`=32"]
[2024/04/26 19:48:09.700 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24663] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_multi_statement_mode`=1"]
[2024/04/26 19:48:09.700 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24663] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_hash_join_concurrency`=1"]
[2024/04/26 19:48:09.700 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24663] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_enable_pseudo_for_outdated_stats`=FALSE"]
[2024/04/26 19:48:09.701 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24663] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_enable_analyze_snapshot`=1"]
[2024/04/26 19:48:09.701 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24663] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_enable_clustered_index`=_UTF8MB4'int_only'"]
[2024/04/26 19:48:09.701 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24663] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="use `window_function`"]
[2024/04/26 19:48:09.701 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24663] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_cost_model_version`=1"]
[2024/04/26 19:48:09.701 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490884] [schemaVersion=24663] [cur_db=window_function] [sql="drop table if exists t;"] [user=root@%]
[2024/04/26 19:48:09.701 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490884] [schemaVersion=24663] [cur_db=window_function] [sql="create table t (a int, b int, c timestamp, index idx(a));"] [user=root@%]
[2024/04/26 19:48:09.715 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20522, Type:create table, State:queueing, SchemaState:none, SchemaID:20519, TableID:20521, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:09.704 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:09.715 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20522, Type:create table, State:queueing, SchemaState:none, SchemaID:20519, TableID:20521, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:09.704 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table t (a int, b int, c timestamp, index idx(a));"]
[2024/04/26 19:48:09.749 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20522] [conn=3248490884] [category=ddl] [job="ID:20522, Type:create table, State:queueing, SchemaState:none, SchemaID:20519, TableID:20521, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.704 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.772 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20522] [conn=3248490884] [job="ID:20522, Type:create table, State:synced, SchemaState:public, SchemaID:20519, TableID:20521, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.704 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.776 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20522]
[2024/04/26 19:48:09.776 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:09.776 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=14] ["first split key"=748000000000005029]
[2024/04/26 19:48:09.777 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005029] ["first new region left"="{Id:16652 StartKey:7480000000000050ff2400000000000000f8 EndKey:7480000000000050ff2900000000000000f8 RegionEpoch:{ConfVer:1 Version:8051} Peers:[id:16653 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/04/26 19:48:09.777 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16652]"]
[2024/04/26 19:48:09.777 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24663] [neededSchemaVersion=24664] ["start time"=544.398µs] [gotSchemaVersion=24664] [phyTblIDs="[20521]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/04/26 19:48:09.778 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_enable_window_function`=1"]
[2024/04/26 19:48:09.778 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_window_concurrency`=1"]
[2024/04/26 19:48:09.778 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over() from t;"]
[2024/04/26 19:48:09.779 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over(partition by a) from t;"]
[2024/04/26 19:48:09.779 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over(partition by a order by b) from t;"]
[2024/04/26 19:48:09.780 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over(partition by a order by b rows unbounded preceding) from t;"]
[2024/04/26 19:48:09.780 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over(partition by a order by b rows between 1 preceding and 1 following) from t;"]
[2024/04/26 19:48:09.781 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over(partition by a order by b range between 1 preceding and 1 following) from t;"]
[2024/04/26 19:48:09.781 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over(partition by a order by c range between interval '2:30' minute_second preceding and interval '2:30' minute_second following) from t;"]
[2024/04/26 19:48:09.781 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_window_concurrency`=4"]
[2024/04/26 19:48:09.782 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over() from t;"]
[2024/04/26 19:48:09.782 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over(partition by a) from t;"]
[2024/04/26 19:48:09.782 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over(partition by a order by b) from t;"]
[2024/04/26 19:48:09.783 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over(partition by a order by b rows unbounded preceding) from t;"]
[2024/04/26 19:48:09.783 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over(partition by a order by b rows between 1 preceding and 1 following) from t;"]
[2024/04/26 19:48:09.784 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over(partition by a order by b range between 1 preceding and 1 following) from t;"]
[2024/04/26 19:48:09.785 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over(partition by a order by c range between interval '2:30' minute_second preceding and interval '2:30' minute_second following) from t;"]
[2024/04/26 19:48:09.785 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490884] [schemaVersion=24664] [cur_db=window_function] [sql="drop table if exists t1;"] [user=root@%]
[2024/04/26 19:48:09.785 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490884] [schemaVersion=24664] [cur_db=window_function] [sql="create table t1(a int primary key, b int);"] [user=root@%]
[2024/04/26 19:48:09.798 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20524, Type:create table, State:queueing, SchemaState:none, SchemaID:20519, TableID:20523, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:09.754 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:09.798 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20524, Type:create table, State:queueing, SchemaState:none, SchemaID:20519, TableID:20523, RowCount:0, ArgLen:2, start time: 2024-04-26 19:48:09.754 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table t1(a int primary key, b int);"]
[2024/04/26 19:48:09.822 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20524] [conn=3248490884] [category=ddl] [job="ID:20524, Type:create table, State:queueing, SchemaState:none, SchemaID:20519, TableID:20523, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.754 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.842 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20524] [conn=3248490884] [job="ID:20524, Type:create table, State:synced, SchemaState:public, SchemaID:20519, TableID:20523, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.754 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.846 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20524]
[2024/04/26 19:48:09.846 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:09.846 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=14] ["first split key"=74800000000000502b]
[2024/04/26 19:48:09.846 +08:00] [INFO] [region_request.go:1686] ["send request meet region error without retry"] [req-ts=0] [req-type=SplitRegion] [region="{ region id: 14, ver: 8050, confVer: 1 }"] [replica-read-type=leader] [stale-read=false] [request-sender="{rpcError:<nil>, replicaSelector: replicaSelectorV2{replicaReadType: leader, attempts: 1, cacheRegionIsValid: false, replicaStatus: [peer: 15, store: 1, isEpochStale: false, attempts: 1, replica-epoch: 0, store-epoch: 0, store-state: resolved, store-liveness-state: reachable]}}"] [retry-times=0] [total-backoff-ms=0] [total-backoff-times=0] [max-exec-timeout-ms=30000] [total-region-errors=15-epoch_not_match:1]
[2024/04/26 19:48:09.847 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24664] [neededSchemaVersion=24665] ["start time"=431.092µs] [gotSchemaVersion=24665] [phyTblIDs="[20523]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/04/26 19:48:09.848 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t1 values(1, 1), (2, 1);"]
[2024/04/26 19:48:09.849 +08:00] [WARN] [prewrite.go:382] ["1pc failed and fallbacks to normal commit procedure"] [conn=3248490884] [session_alias=] [startTS=449349442549579795]
[2024/04/26 19:48:09.849 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=74800000000000502b] ["first new region left"="{Id:16654 StartKey:7480000000000050ff2900000000000000f8 EndKey:7480000000000050ff2b00000000000000f8 RegionEpoch:{ConfVer:1 Version:8052} Peers:[id:16655 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/04/26 19:48:09.849 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16654]"]
[2024/04/26 19:48:09.849 +08:00] [INFO] [region_request.go:1686] ["send request meet region error without retry"] [conn=3248490884] [session_alias=] [req-ts=449349442549579795] [req-type=Commit] [region="{ region id: 14, ver: 8051, confVer: 1 }"] [replica-read-type=leader] [stale-read=false] [request-sender="{rpcError:<nil>, replicaSelector: replicaSelectorV2{replicaReadType: leader, attempts: 1, cacheRegionIsValid: false, replicaStatus: [peer: 15, store: 1, isEpochStale: false, attempts: 1, replica-epoch: 0, store-epoch: 0, store-state: resolved, store-liveness-state: reachable]}}"] [retry-times=0] [total-backoff-ms=0] [total-backoff-times=0] [max-exec-timeout-ms=20000] [total-region-errors=15-epoch_not_match:1]
[2024/04/26 19:48:09.850 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t1;"]
[2024/04/26 19:48:09.874 +08:00] [INFO] [analyze.go:747] ["analyze table `window_function`.`t1` has finished"] [partition=] ["job info"="analyze table all columns with 256 buckets, 500 topn, 1 samplerate"] ["start time"=2024/04/26 19:48:09.855 +08:00] ["end time"=2024/04/26 19:48:09.872 +08:00] [cost=17.384101ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/04/26 19:48:09.883 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over(partition by b) from t1;"]
[2024/04/26 19:48:09.884 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t1 values(3, 3);"]
[2024/04/26 19:48:09.884 +08:00] [WARN] [prewrite.go:382] ["1pc failed and fallbacks to normal commit procedure"] [conn=3248490884] [session_alias=] [startTS=449349442562687002]
[2024/04/26 19:48:09.885 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t1;"]
[2024/04/26 19:48:09.891 +08:00] [INFO] [save.go:200] ["incrementally update modifyCount"] [category=stats] [tableID=20523] [curModifyCnt=0] [results.BaseModifyCnt=0] [modifyCount=0]
[2024/04/26 19:48:09.891 +08:00] [INFO] [save.go:211] ["incrementally update count"] [category=stats] [tableID=20523] [curCnt=2] [results.Count=3] [results.BaseCount=2] [count=3]
[2024/04/26 19:48:09.907 +08:00] [INFO] [analyze.go:747] ["analyze table `window_function`.`t1` has finished"] [partition=] ["job info"="analyze table all columns with 256 buckets, 500 topn, 1 samplerate"] ["start time"=2024/04/26 19:48:09.888 +08:00] ["end time"=2024/04/26 19:48:09.905 +08:00] [cost=17.477234ms] ["sample rate reason"="use min(1, 110000/2) as the sample-rate=1"]
[2024/04/26 19:48:09.915 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490884] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over(partition by b) from t1;"]
[2024/04/26 19:48:09.916 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490888] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="use `test`"]
[2024/04/26 19:48:09.916 +08:00] [INFO] [session.go:3954] [GENERAL_LOG] [conn=3248490888] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`time_zone`=_UTF8MB4'Asia/Shanghai'"]
[2024/04/26 19:48:09.917 +08:00] [INFO] [session.go:3928] ["CRUCIAL OPERATION"] [conn=3248490888] [schemaVersion=24665] [cur_db=test] [sql="drop database `window_function`"] [user=root@%]
[2024/04/26 19:48:09.929 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20525, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20519, TableID:0, RowCount:0, ArgLen:1, start time: 2024-04-26 19:48:09.904 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/04/26 19:48:09.929 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20525, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20519, TableID:0, RowCount:0, ArgLen:1, start time: 2024-04-26 19:48:09.904 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop database `window_function`"]
[2024/04/26 19:48:09.954 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20525] [conn=3248490888] [category=ddl] [job="ID:20525, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20519, TableID:0, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.904 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.975 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20525] [conn=3248490888] [category=ddl] [job="ID:20525, Type:drop schema, State:running, SchemaState:write only, SchemaID:20519, TableID:0, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.904 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:09.993 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20525] [conn=3248490888] [category=ddl] [job="ID:20525, Type:drop schema, State:running, SchemaState:delete only, SchemaID:20519, TableID:0, RowCount:0, ArgLen:0, start time: 2024-04-26 19:48:09.904 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:10.011 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20525] [tableIDs="[20521,20523]"] [comment="drop schema: table IDs"]
[2024/04/26 19:48:10.013 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20525] [jobType="drop schema"]
[2024/04/26 19:48:10.014 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20525] [conn=3248490888] [job="ID:20525, Type:drop schema, State:synced, SchemaState:none, SchemaID:20519, TableID:0, RowCount:0, ArgLen:1, start time: 2024-04-26 19:48:09.904 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/04/26 19:48:10.016 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20525]
[2024/04/26 19:48:10.016 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/04/26 19:48:10.018 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24665] [neededSchemaVersion=24668] ["start time"=389.812µs] [gotSchemaVersion=24668] [phyTblIDs="[20521,20523]"] [actionTypes="[2,2]"] [diffTypes="[\"drop schema\",\"drop schema\",\"drop schema\"]"]
[Pipeline] archiveArtifacts
Archiving artifacts
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - SCRIPT_AND_ARGS = 'integrationtest_with_tikv.sh y'
[Pipeline] // parallel
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] End of Pipeline
ERROR: script returned exit code 1
Finished: FAILURE