Console Output

Skipping 13,610 KB.. Full Log
[2024/05/07 10:06:21.006 +08:00] [INFO] [endpoint.rs:701] ["register observe region"] [region="id: 10 start_key: 7800000000000000FB end_key: 7800000100000000FB region_epoch { conf_ver: 1 version: 5 } peers { id: 11 store_id: 1 }"] [thread_id=68]
[2024/05/07 10:06:21.006 +08:00] [INFO] [pd.rs:1705] ["succeed to update max timestamp"] [region_id=4] [thread_id=31]
[2024/05/07 10:06:21.006 +08:00] [INFO] [pd.rs:1705] ["succeed to update max timestamp"] [region_id=6] [thread_id=31]
[2024/05/07 10:06:21.006 +08:00] [INFO] [pd.rs:1705] ["succeed to update max timestamp"] [region_id=8] [thread_id=31]
[2024/05/07 10:06:21.006 +08:00] [INFO] [pd.rs:1705] ["succeed to update max timestamp"] [region_id=10] [thread_id=31]
[2024/05/07 10:06:21.006 +08:00] [INFO] [endpoint.rs:701] ["register observe region"] [region="id: 8 start_key: 7200000100000000FB end_key: 7800000000000000FB region_epoch { conf_ver: 1 version: 5 } peers { id: 9 store_id: 1 }"] [thread_id=68]
[2024/05/07 10:06:21.006 +08:00] [INFO] [endpoint.rs:358] ["Resolver initialized"] [pending_data_index=0] [snapshot_index=6] [observe_id=ObserveId(2)] [region=6] [thread_id=68]
[2024/05/07 10:06:21.006 +08:00] [INFO] [endpoint.rs:358] ["Resolver initialized"] [pending_data_index=0] [snapshot_index=6] [observe_id=ObserveId(4)] [region=10] [thread_id=68]
[2024/05/07 10:06:21.006 +08:00] [INFO] [endpoint.rs:358] ["Resolver initialized"] [pending_data_index=0] [snapshot_index=6] [observe_id=ObserveId(5)] [region=8] [thread_id=68]
[2024/05/07 10:06:21.006 +08:00] [INFO] [endpoint.rs:358] ["Resolver initialized"] [pending_data_index=0] [snapshot_index=6] [observe_id=ObserveId(3)] [region=4] [thread_id=68]
[2024/05/07 10:06:28.000 +08:00] [INFO] [client.rs:799] ["set cluster version to 8.2.0-alpha"] [thread_id=31]
[2024/05/07 10:16:17.888 +08:00] [INFO] [util.rs:639] ["connecting to PD endpoint"] [endpoints=http://127.0.0.1:2399] [thread_id=12]
[2024/05/07 10:26:17.890 +08:00] [INFO] [util.rs:639] ["connecting to PD endpoint"] [endpoints=http://127.0.0.1:2399] [thread_id=12]
[2024/05/07 10:36:17.891 +08:00] [INFO] [util.rs:639] ["connecting to PD endpoint"] [endpoints=http://127.0.0.1:2399] [thread_id=12]
+ find . -name '*.out' -type f -exec tail -n 500 '{}' +
[2024/05/07 10:36:59.952 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24638] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a > 0;"]
[2024/05/07 10:36:59.954 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24638] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where a > -1;"]
[2024/05/07 10:36:59.954 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24638] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a > -1;"]
[2024/05/07 10:36:59.956 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24638] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t where a > 3;"]
[2024/05/07 10:36:59.957 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24638] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a > 3;"]
[2024/05/07 10:36:59.958 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24638] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_partition_prune_mode`=DEFAULT"]
[2024/05/07 10:36:59.958 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24638] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_executor_concurrency`=DEFAULT"]
[2024/05/07 10:36:59.958 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24638] [cur_db=util__ranger] [sql="drop table if exists t2;"] [user=root@%]
[2024/05/07 10:36:59.975 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20517, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20509, RowCount:0, ArgLen:2, start time: 2024-05-07 10:36:59.939 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:36:59.975 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20517, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20509, RowCount:0, ArgLen:2, start time: 2024-05-07 10:36:59.939 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t2;"]
[2024/05/07 10:37:00.002 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20517] [conn=1631586692] [category=ddl] [job="ID:20517, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20509, RowCount:0, ArgLen:0, start time: 2024-05-07 10:36:59.939 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.027 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20517] [conn=1631586692] [category=ddl] [job="ID:20517, Type:drop table, State:running, SchemaState:write only, SchemaID:20501, TableID:20509, RowCount:0, ArgLen:0, start time: 2024-05-07 10:36:59.939 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.061 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20517] [conn=1631586692] [category=ddl] [job="ID:20517, Type:drop table, State:running, SchemaState:delete only, SchemaID:20501, TableID:20509, RowCount:0, ArgLen:0, start time: 2024-05-07 10:36:59.939 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.087 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20517] [tableIDs="[20509]"] [comment="drop table: table ID"]
[2024/05/07 10:37:00.090 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20517] [jobType="drop table"]
[2024/05/07 10:37:00.090 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20517] [conn=1631586692] [job="ID:20517, Type:drop table, State:synced, SchemaState:none, SchemaID:20501, TableID:20509, RowCount:0, ArgLen:3, start time: 2024-05-07 10:36:59.939 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.095 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20517]
[2024/05/07 10:37:00.095 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:00.097 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24638] [neededSchemaVersion=24641] ["start time"=546.885µs] [gotSchemaVersion=24641] [phyTblIDs="[20509]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/07 10:37:00.098 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24641] [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/05/07 10:37:00.117 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20519, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20518, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:00.09 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:00.117 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20519, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20518, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:00.09 +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/05/07 10:37:00.159 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20519] [conn=1631586692] [category=ddl] [job="ID:20519, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20518, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.09 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.189 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20519] [conn=1631586692] [job="ID:20519, Type:create table, State:synced, SchemaState:public, SchemaID:20501, TableID:20518, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.09 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.194 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20519]
[2024/05/07 10:37:00.194 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:00.194 +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"=748000000000005026]
[2024/05/07 10:37:00.195 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005026] ["first new region left"="{Id:16670 StartKey:7480000000000050ff2300000000000000f8 EndKey:7480000000000050ff2600000000000000f8 RegionEpoch:{ConfVer:1 Version:8062} Peers:[id:16671 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/07 10:37:00.195 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16670]"]
[2024/05/07 10:37:00.195 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24641] [neededSchemaVersion=24642] ["start time"=668.398µs] [gotSchemaVersion=24642] [phyTblIDs="[20518]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/07 10:37:00.196 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24642] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t2 (t) values ('aaaa'),('a');"]
[2024/05/07 10:37:00.200 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24642] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t2 where t='aaaa';"]
[2024/05/07 10:37:00.200 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24642] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t2 where t='aaaa';"]
[2024/05/07 10:37:00.202 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24642] [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/05/07 10:37:00.203 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24642] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t2 where t='aaaa' or t = 'a';"]
[2024/05/07 10:37:00.205 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24642] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t2;"]
[2024/05/07 10:37:00.245 +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/05/07 10:37:00.210 +08:00] ["end time"=2024/05/07 10:37:00.243 +08:00] [cost=33.145161ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/07 10:37:00.259 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24642] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format='brief' select * from t2 where t='aaaa';"]
[2024/05/07 10:37:00.259 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24642] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t2 where t='aaaa';"]
[2024/05/07 10:37:00.261 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24642] [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/05/07 10:37:00.262 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24642] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t2 where t='aaaa' or t = 'a';"]
[2024/05/07 10:37:00.264 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24642] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/05/07 10:37:00.279 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20520, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20512, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:00.24 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:00.279 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20520, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20512, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:00.24 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/05/07 10:37:00.305 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20520] [conn=1631586692] [category=ddl] [job="ID:20520, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20512, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.24 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.329 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20520] [conn=1631586692] [category=ddl] [job="ID:20520, Type:drop table, State:running, SchemaState:write only, SchemaID:20501, TableID:20512, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.24 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.351 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20520] [conn=1631586692] [category=ddl] [job="ID:20520, Type:drop table, State:running, SchemaState:delete only, SchemaID:20501, TableID:20512, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.24 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.373 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20520] [tableIDs="[20513,20514,20515]"] [comment="drop table: partition table IDs"]
[2024/05/07 10:37:00.376 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20520] [tableIDs="[20512]"] [comment="drop table: table ID"]
[2024/05/07 10:37:00.377 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20520] [jobType="drop table"]
[2024/05/07 10:37:00.378 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20520] [conn=1631586692] [job="ID:20520, Type:drop table, State:synced, SchemaState:none, SchemaID:20501, TableID:20512, RowCount:0, ArgLen:3, start time: 2024-05-07 10:37:00.24 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.381 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20520]
[2024/05/07 10:37:00.381 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:00.383 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24642] [neededSchemaVersion=24645] ["start time"=462.668µs] [gotSchemaVersion=24645] [phyTblIDs="[20512,20513,20514,20515]"] [actionTypes="[4,4,4,4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/07 10:37:00.384 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24645] [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/05/07 10:37:00.398 +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:20501, TableID:20521, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:00.389 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:00.398 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20522, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20521, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:00.389 +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/05/07 10:37:00.429 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20522] [conn=1631586692] [category=ddl] [job="ID:20522, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20521, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.389 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.453 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20522] [conn=1631586692] [job="ID:20522, Type:create table, State:synced, SchemaState:public, SchemaID:20501, TableID:20521, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.389 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.457 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20522]
[2024/05/07 10:37:00.457 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:00.457 +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/05/07 10:37:00.459 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005029] ["first new region left"="{Id:16672 StartKey:7480000000000050ff2600000000000000f8 EndKey:7480000000000050ff2900000000000000f8 RegionEpoch:{ConfVer:1 Version:8063} Peers:[id:16673 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/07 10:37:00.459 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16672]"]
[2024/05/07 10:37:00.459 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24645] [neededSchemaVersion=24646] ["start time"=568.267µs] [gotSchemaVersion=24646] [phyTblIDs="[20521]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/07 10:37:00.460 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24646] [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/05/07 10:37:00.463 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24646] [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/05/07 10:37:00.464 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24646] [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/05/07 10:37:00.466 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24646] [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/05/07 10:37:00.467 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24646] [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/05/07 10:37:00.468 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24646] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/05/07 10:37:00.481 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20523, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20521, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:00.44 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:00.481 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20523, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20521, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:00.44 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/05/07 10:37:00.511 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20523] [conn=1631586692] [category=ddl] [job="ID:20523, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20521, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.44 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.533 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20523] [conn=1631586692] [category=ddl] [job="ID:20523, Type:drop table, State:running, SchemaState:write only, SchemaID:20501, TableID:20521, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.44 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.556 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20523] [conn=1631586692] [category=ddl] [job="ID:20523, Type:drop table, State:running, SchemaState:delete only, SchemaID:20501, TableID:20521, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.44 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.580 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20523] [tableIDs="[20521]"] [comment="drop table: table ID"]
[2024/05/07 10:37:00.583 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20523] [jobType="drop table"]
[2024/05/07 10:37:00.583 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20523] [conn=1631586692] [job="ID:20523, Type:drop table, State:synced, SchemaState:none, SchemaID:20501, TableID:20521, RowCount:0, ArgLen:3, start time: 2024-05-07 10:37:00.44 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.587 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20523]
[2024/05/07 10:37:00.587 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:00.588 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24646] [neededSchemaVersion=24649] ["start time"=479.116µs] [gotSchemaVersion=24649] [phyTblIDs="[20521]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/07 10:37:00.589 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24649] [cur_db=util__ranger] [sql="create table t(a int, b int, c int, primary key(a,b,c));"] [user=root@%]
[2024/05/07 10:37:00.604 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20525, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20524, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:00.59 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:00.604 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20525, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20524, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:00.59 +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/05/07 10:37:00.638 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20525] [conn=1631586692] [category=ddl] [job="ID:20525, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20524, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.59 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.663 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20525] [conn=1631586692] [job="ID:20525, Type:create table, State:synced, SchemaState:public, SchemaID:20501, TableID:20524, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.59 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.667 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20525]
[2024/05/07 10:37:00.667 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:00.667 +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"=74800000000000502c]
[2024/05/07 10:37:00.668 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=74800000000000502c] ["first new region left"="{Id:16674 StartKey:7480000000000050ff2900000000000000f8 EndKey:7480000000000050ff2c00000000000000f8 RegionEpoch:{ConfVer:1 Version:8064} Peers:[id:16675 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/07 10:37:00.668 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16674]"]
[2024/05/07 10:37:00.668 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24649] [neededSchemaVersion=24650] ["start time"=601.653µs] [gotSchemaVersion=24650] [phyTblIDs="[20524]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/07 10:37:00.669 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.672 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t;"]
[2024/05/07 10:37:00.705 +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/05/07 10:37:00.676 +08:00] ["end time"=2024/05/07 10:37:00.703 +08:00] [cost=27.039981ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/07 10:37:00.721 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.722 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.723 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.724 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.724 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.725 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.726 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.726 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.727 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.728 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.729 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.730 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.731 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.732 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.733 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.733 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.734 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.735 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24650] [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/05/07 10:37:00.736 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24650] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/05/07 10:37:00.751 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20526, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20524, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:00.74 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:00.751 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20526, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20524, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:00.74 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/05/07 10:37:00.777 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20526] [conn=1631586692] [category=ddl] [job="ID:20526, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20524, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.74 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.803 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20526] [conn=1631586692] [category=ddl] [job="ID:20526, Type:drop table, State:running, SchemaState:write only, SchemaID:20501, TableID:20524, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.74 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.829 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20526] [conn=1631586692] [category=ddl] [job="ID:20526, Type:drop table, State:running, SchemaState:delete only, SchemaID:20501, TableID:20524, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.74 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.851 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20526] [tableIDs="[20524]"] [comment="drop table: table ID"]
[2024/05/07 10:37:00.852 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20526] [jobType="drop table"]
[2024/05/07 10:37:00.853 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20526] [conn=1631586692] [job="ID:20526, Type:drop table, State:synced, SchemaState:none, SchemaID:20501, TableID:20524, RowCount:0, ArgLen:3, start time: 2024-05-07 10:37:00.74 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.856 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20526]
[2024/05/07 10:37:00.856 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:00.857 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24650] [neededSchemaVersion=24653] ["start time"=387.247µs] [gotSchemaVersion=24653] [phyTblIDs="[20524]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/07 10:37:00.858 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24653] [cur_db=util__ranger] [sql="create table t(a int, b int, c int, primary key(a,b));"] [user=root@%]
[2024/05/07 10:37:00.872 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20528, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20527, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:00.839 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:00.872 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20528, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20527, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:00.839 +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/05/07 10:37:00.906 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20528] [conn=1631586692] [category=ddl] [job="ID:20528, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20527, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.839 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.935 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20528] [conn=1631586692] [job="ID:20528, Type:create table, State:synced, SchemaState:public, SchemaID:20501, TableID:20527, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.839 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:00.939 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20528]
[2024/05/07 10:37:00.940 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:00.940 +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"=74800000000000502f]
[2024/05/07 10:37:00.941 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=74800000000000502f] ["first new region left"="{Id:16676 StartKey:7480000000000050ff2c00000000000000f8 EndKey:7480000000000050ff2f00000000000000f8 RegionEpoch:{ConfVer:1 Version:8065} Peers:[id:16677 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/07 10:37:00.941 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16676]"]
[2024/05/07 10:37:00.941 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24653] [neededSchemaVersion=24654] ["start time"=635.393µs] [gotSchemaVersion=24654] [phyTblIDs="[20527]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/07 10:37:00.942 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24654] [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/05/07 10:37:00.946 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24654] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t;"]
[2024/05/07 10:37:00.981 +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/05/07 10:37:00.950 +08:00] ["end time"=2024/05/07 10:37:00.980 +08:00] [cost=29.660291ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/07 10:37:00.999 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24654] [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/05/07 10:37:01.000 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24654] [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/05/07 10:37:01.001 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24654] [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/05/07 10:37:01.001 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24654] [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/05/07 10:37:01.003 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24654] [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/05/07 10:37:01.003 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24654] [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/05/07 10:37:01.005 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24654] [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/05/07 10:37:01.005 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24654] [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/05/07 10:37:01.006 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24654] [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/05/07 10:37:01.007 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24654] [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/05/07 10:37:01.008 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24654] [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/05/07 10:37:01.009 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24654] [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/05/07 10:37:01.010 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24654] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_regard_null_as_point`=FALSE"]
[2024/05/07 10:37:01.010 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24654] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/05/07 10:37:01.025 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20529, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20527, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:00.99 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:01.025 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20529, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20527, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:00.99 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/05/07 10:37:01.051 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20529] [conn=1631586692] [category=ddl] [job="ID:20529, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20527, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.99 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:01.080 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20529] [conn=1631586692] [category=ddl] [job="ID:20529, Type:drop table, State:running, SchemaState:write only, SchemaID:20501, TableID:20527, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.99 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:01.109 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20529] [conn=1631586692] [category=ddl] [job="ID:20529, Type:drop table, State:running, SchemaState:delete only, SchemaID:20501, TableID:20527, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:00.99 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:01.131 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20529] [tableIDs="[20527]"] [comment="drop table: table ID"]
[2024/05/07 10:37:01.132 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20529] [jobType="drop table"]
[2024/05/07 10:37:01.133 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20529] [conn=1631586692] [job="ID:20529, Type:drop table, State:synced, SchemaState:none, SchemaID:20501, TableID:20527, RowCount:0, ArgLen:3, start time: 2024-05-07 10:37:00.99 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:01.136 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20529]
[2024/05/07 10:37:01.136 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:01.138 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24654] [neededSchemaVersion=24657] ["start time"=459.163µs] [gotSchemaVersion=24657] [phyTblIDs="[20527]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/07 10:37:01.139 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24657] [cur_db=util__ranger] [sql="create table t(a int, b int, c int, key(a,b,c));"] [user=root@%]
[2024/05/07 10:37:01.154 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20531, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20530, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:01.14 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:01.154 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20531, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20530, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:01.14 +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/05/07 10:37:01.191 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20531] [conn=1631586692] [category=ddl] [job="ID:20531, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20530, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:01.14 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:01.227 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20531] [conn=1631586692] [job="ID:20531, Type:create table, State:synced, SchemaState:public, SchemaID:20501, TableID:20530, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:01.14 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:01.231 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20531]
[2024/05/07 10:37:01.231 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:01.231 +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"=748000000000005032]
[2024/05/07 10:37:01.232 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005032] ["first new region left"="{Id:16678 StartKey:7480000000000050ff2f00000000000000f8 EndKey:7480000000000050ff3200000000000000f8 RegionEpoch:{ConfVer:1 Version:8066} Peers:[id:16679 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/07 10:37:01.232 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16678]"]
[2024/05/07 10:37:01.233 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24657] [neededSchemaVersion=24658] ["start time"=590.516µs] [gotSchemaVersion=24658] [phyTblIDs="[20530]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/07 10:37:01.234 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t values(1,2,2);"]
[2024/05/07 10:37:01.236 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.237 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.238 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.238 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.239 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.239 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.240 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.241 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.241 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.242 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.242 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.243 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.244 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.244 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.245 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.246 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.246 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.247 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [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/05/07 10:37:01.247 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_regard_null_as_point`=DEFAULT"]
[2024/05/07 10:37:01.247 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24658] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_cost_model_version`=2"]
[2024/05/07 10:37:01.247 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24658] [cur_db=util__ranger] [sql="drop table if exists t0;"] [user=root@%]
[2024/05/07 10:37:01.248 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24658] [cur_db=util__ranger] [sql="CREATE TABLE t0(c0 TEXT(10));"] [user=root@%]
[2024/05/07 10:37:01.248 +08:00] [INFO] [ddl_api.go:1133] ["Automatically convert BLOB(10) to TINYBLOB"] [category=ddl]
[2024/05/07 10:37:01.262 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20533, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20532, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:01.24 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:01.262 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20533, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20532, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:01.24 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE TABLE t0(c0 TEXT(10));"]
[2024/05/07 10:37:01.285 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20533] [conn=1631586692] [category=ddl] [job="ID:20533, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20532, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:01.24 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:01.308 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20533] [conn=1631586692] [job="ID:20533, Type:create table, State:synced, SchemaState:public, SchemaID:20501, TableID:20532, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:01.24 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:01.311 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20533]
[2024/05/07 10:37:01.311 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:01.311 +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"=748000000000005034]
[2024/05/07 10:37:01.312 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005034] ["first new region left"="{Id:16680 StartKey:7480000000000050ff3200000000000000f8 EndKey:7480000000000050ff3400000000000000f8 RegionEpoch:{ConfVer:1 Version:8067} Peers:[id:16681 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/07 10:37:01.312 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16680]"]
[2024/05/07 10:37:01.312 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24658] [neededSchemaVersion=24659] ["start time"=531.909µs] [gotSchemaVersion=24659] [phyTblIDs="[20532]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/07 10:37:01.313 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [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 t0(c0) VALUES (1);"]
[2024/05/07 10:37:01.316 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24659] [cur_db=util__ranger] [sql="CREATE INDEX i0 ON t0(c0(255));"] [user=root@%]
[2024/05/07 10:37:01.329 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20534, Type:add index, State:queueing, SchemaState:none, SchemaID:20501, TableID:20532, RowCount:0, ArgLen:6, start time: 2024-05-07 10:37:01.289 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0; "] [table=true]
[2024/05/07 10:37:01.329 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20534, Type:add index, State:queueing, SchemaState:none, SchemaID:20501, TableID:20532, RowCount:0, ArgLen:6, start time: 2024-05-07 10:37:01.289 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"] [query="CREATE INDEX i0 ON t0(c0(255));"]
[2024/05/07 10:37:01.371 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20534] [conn=1631586692] [category=ddl] [job="ID:20534, Type:add index, State:queueing, SchemaState:none, SchemaID:20501, TableID:20532, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:01.289 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/05/07 10:37:01.372 +08:00] [INFO] [index.go:654] ["run add index job"] [category=ddl] [job="ID:20534, Type:add index, State:running, SchemaState:none, SchemaID:20501, TableID:20532, RowCount:0, ArgLen:6, start time: 2024-05-07 10:37:01.289 +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/05/07 10:37:01.402 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20534] [conn=1631586692] [category=ddl] [job="ID:20534, Type:add index, State:running, SchemaState:delete only, SchemaID:20501, TableID:20532, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:01.289 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/05/07 10:37:01.432 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20534] [conn=1631586692] [category=ddl] [job="ID:20534, Type:add index, State:running, SchemaState:write only, SchemaID:20501, TableID:20532, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:01.289 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/05/07 10:37:01.461 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20534] [conn=1631586692] [category=ddl] [job="ID:20534, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20501, TableID:20532, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:01.289 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/05/07 10:37:01.461 +08:00] [INFO] [index.go:857] ["index backfill state running"] [category=ddl] ["job ID"=20534] [table=t0] ["ingest mode"=true] [index=i0]
[2024/05/07 10:37:01.462 +08:00] [INFO] [reorg.go:718] ["job get table range"] [category=ddl] [jobID=20534] [physicalTableID=20532] [startKey=7480000000000050345f728000000000000001] [endKey=7480000000000050345f72800000000000000100]
[2024/05/07 10:37:01.489 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20534] [conn=1631586692] [category=ddl] [job="ID:20534, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20501, TableID:20532, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:01.289 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449589915533967364, LocalMode: false, UniqueWarnings:0"]
[2024/05/07 10:37:01.490 +08:00] [INFO] [index.go:857] ["index backfill state running"] [category=ddl] ["job ID"=20534] [table=t0] ["ingest mode"=true] [index=i0]
[2024/05/07 10:37:01.494 +08:00] [INFO] [index.go:2089] ["adjusted add-index task concurrency"] [category=ddl] [worker-cnt=4] [task-concurrency=4] [task-key=ddl/backfill/20534]
[2024/05/07 10:37:01.503 +08:00] [INFO] [index.go:2178] ["estimate row size"] [tableID=20532] [size=0] [error="less than 3 regions"]
[2024/05/07 10:37:01.511 +08:00] [INFO] [scheduler_manager.go:355] ["task scheduler started"] [task-id=660015]
[2024/05/07 10:37:01.511 +08:00] [INFO] [scheduler.go:120] ["schedule task"] [task-id=660015] [task-type=backfill] [allocated-slots=true] [state=pending] [concurrency=4]
[2024/05/07 10:37:02.012 +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/05/07 10:37:02.012 +08:00] [INFO] [scheduler.go:446] ["eligible instances"] [task-id=660015] [task-type=backfill] [allocated-slots=true] [num=1]
[2024/05/07 10:37:02.013 +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/05/07 10:37:02.015 +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/05/07 10:37:02.058 +08:00] [INFO] [manager.go:328] ["task executor started"] [task-id=660015] [type=backfill] [remaining-slots=4]
[2024/05/07 10:37:02.361 +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/05/07 10:37:02.362 +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/05/07 10:37:02.362 +08:00] [INFO] [backend_mgr.go:248] ["create local backend for adding index"] [category=ddl-ingest] [sortDir=/tmp/tidb/tmp_ddl-44213/20534] [keyspaceName=]
[2024/05/07 10:37:02.363 +08:00] [INFO] [pd_service_discovery.go:1016] ["[pd] switch leader"] [new-leader=http://127.0.0.1:2379] [old-leader=]
[2024/05/07 10:37:02.364 +08:00] [INFO] [pd_service_discovery.go:498] ["[pd] init cluster id"] [cluster-id=7366073261567730576]
[2024/05/07 10:37:02.364 +08:00] [INFO] [client.go:613] ["[pd] changing service mode"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/07 10:37:02.364 +08:00] [INFO] [tso_client.go:293] ["[tso] switch dc tso global allocator serving url"] [dc-location=global] [new-url=http://127.0.0.1:2379]
[2024/05/07 10:37:02.364 +08:00] [INFO] [client.go:619] ["[pd] service mode changed"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/07 10:37:02.364 +08:00] [INFO] [tso_dispatcher.go:119] ["[tso] start tso deadline watcher"] [dc-location=global]
[2024/05/07 10:37:02.364 +08:00] [INFO] [tso_dispatcher.go:168] ["[tso] tso dispatcher created"] [dc-location=global]
[2024/05/07 10:37:02.364 +08:00] [INFO] [tso_client.go:130] ["[tso] start tso dispatcher check loop"]
[2024/05/07 10:37:02.364 +08:00] [INFO] [tso_dispatcher.go:336] ["[tso] start tso connection contexts updater"] [dc-location=global]
[2024/05/07 10:37:02.366 +08:00] [INFO] [local.go:682] ["multi ingest support"] [category=ddl-ingest]
[2024/05/07 10:37:02.367 +08:00] [INFO] [local.go:704] ["TiKV server side free space check is enabled, so lightning will turn it off"] [category=ddl-ingest]
[2024/05/07 10:37:02.367 +08:00] [INFO] [backend_mgr.go:161] ["create one backend for an DDL job"] ["job ID"=20534] ["current memory usage"=33656] ["max memory quota"=17179869184] ["is unique index"=false]
[2024/05/07 10:37:02.367 +08:00] [INFO] [backfilling_read_index.go:91] ["read index executor init subtask exec env"] [category=ddl]
[2024/05/07 10:37:02.372 +08:00] [INFO] [backfilling_read_index.go:96] ["read index executor run subtask"] [category=ddl] ["use cloud"=false]
[2024/05/07 10:37:02.374 +08:00] [INFO] [backend.go:253] ["open engine"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba]
[2024/05/07 10:37:02.374 +08:00] [INFO] [engine_mgr.go:81] ["open an engine for index reorg task"] ["job ID"=20534] ["index ID"=1] ["current memory usage"=671122440] ["memory limitation"=17179869184] ["current writer count"=1]
[2024/05/07 10:37:02.374 +08:00] [INFO] [backfilling_operators.go:160] ["build add index local storage operators"] [task-id=660015] [subtask-id=60015] [jobID=20534] [avgRowSize=0] [reader=2] [writer=4]
[2024/05/07 10:37:02.374 +08:00] [INFO] [backfilling.go:416] ["split table range from PD"] [category=ddl] [physicalTableID=20532] ["start key"=7480000000000050345f728000000000000001] ["end key"=7480000000000050345f72800000000000000100]
[2024/05/07 10:37:02.375 +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=7480000000000050345f728000000000000001, endKey=7480000000000050345f72800000000000000100"]
[2024/05/07 10:37:02.386 +08:00] [INFO] [engine.go:198] ["create one local writer for index reorg task"] ["job ID"=20534] ["index ID"=1] ["worker ID"=1] ["allocate memory"=40] ["current memory usage"=671122480] ["max memory quota"=17179869184]
[2024/05/07 10:37:02.391 +08:00] [INFO] [engine.go:198] ["create one local writer for index reorg task"] ["job ID"=20534] ["index ID"=1] ["worker ID"=2] ["allocate memory"=40] ["current memory usage"=671122520] ["max memory quota"=17179869184]
[2024/05/07 10:37:02.391 +08:00] [INFO] [backfilling_operators.go:697] ["finish a index ingest task"] [task-id=660015] [subtask-id=60015] [id=1]
[2024/05/07 10:37:02.408 +08:00] [INFO] [engine.go:198] ["create one local writer for index reorg task"] ["job ID"=20534] ["index ID"=1] ["worker ID"=3] ["allocate memory"=40] ["current memory usage"=672171136] ["max memory quota"=17179869184]
[2024/05/07 10:37:02.433 +08:00] [INFO] [engine.go:198] ["create one local writer for index reorg task"] ["job ID"=20534] ["index ID"=1] ["worker ID"=4] ["allocate memory"=40] ["current memory usage"=672171176] ["max memory quota"=17179869184]
[2024/05/07 10:37:02.433 +08:00] [INFO] [engine.go:867] ["write data to local DB"] [category=ddl-ingest] [size=39] [kvs=1] [files=1] [sstFileSize=942] [file=/tmp/tidb/tmp_ddl-44213/20534/4229afb8-665d-5dce-bb97-2afa316b67ba.sst/f469bb9a-e52d-4df9-8a50-c1b5b18633f7.sst] [firstKey=7480000000000050345F698000000000000001013100000000000000F8038000000000000001] [lastKey=7480000000000050345F698000000000000001013100000000000000F8038000000000000001]
[2024/05/07 10:37:02.436 +08:00] [INFO] [backend.go:215] ["acquire distributed flush lock success"] [jobID=20534]
[2024/05/07 10:37:02.436 +08:00] [INFO] [backend.go:237] ["do a partial import data into the storage"] ["index ID"=1] ["usage info"="disk usage: 469229101056/940431265792, backend usage: 0"]
[2024/05/07 10:37:02.436 +08:00] [INFO] [backend.go:372] ["import start"] [category=ddl-ingest] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba] [retryCnt=0]
[2024/05/07 10:37:02.436 +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/05/07 10:37:02.436 +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/05/07 10:37:02.436 +08:00] [INFO] [local.go:1280] ["pause pd scheduler of table scope"] [category=ddl-ingest]
[2024/05/07 10:37:02.458 +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/05/07 10:37:02.458 +08:00] [INFO] [local.go:835] ["import engine ranges"] [category=ddl-ingest] [count=1]
[2024/05/07 10:37:02.464 +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/05/07 10:37:02.465 +08:00] [INFO] [backend.go:378] ["import completed"] [category=ddl-ingest] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba] [retryCnt=0] [takeTime=29.204472ms] []
[2024/05/07 10:37:02.468 +08:00] [INFO] [backend.go:221] ["release distributed flush lock success"] [jobID=20534]
[2024/05/07 10:37:02.475 +08:00] [INFO] [backfilling_read_index.go:151] ["read index executor cleanup subtask exec env"]
[2024/05/07 10:37:02.475 +08:00] [INFO] [backend.go:330] ["engine close start"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba]
[2024/05/07 10:37:02.475 +08:00] [INFO] [backend.go:332] ["engine close completed"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba] [takeTime=695.719µs] []
[2024/05/07 10:37:02.475 +08:00] [INFO] [backend.go:391] ["cleanup start"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba]
[2024/05/07 10:37:02.476 +08:00] [INFO] [backend.go:393] ["cleanup completed"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba] [takeTime=413.946µs] []
[2024/05/07 10:37:02.476 +08:00] [INFO] [tso_dispatcher.go:137] ["[tso] exit tso deadline watcher"] [dc-location=global]
[2024/05/07 10:37:02.476 +08:00] [INFO] [tso_client.go:145] ["[tso] exit tso dispatcher check loop"]
[2024/05/07 10:37:02.476 +08:00] [INFO] [pd_service_discovery.go:550] ["[pd] exit member loop due to context canceled"]
[2024/05/07 10:37:02.476 +08:00] [INFO] [tso_dispatcher.go:210] ["[tso] stop fetching the pending tso requests due to context canceled"] [dc-location=global]
[2024/05/07 10:37:02.476 +08:00] [INFO] [tso_dispatcher.go:171] ["[tso] exit tso dispatcher"] [dc-location=global]
[2024/05/07 10:37:02.476 +08:00] [INFO] [tso_batch_controller.go:160] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=5] [collected-request-count=0] [pending-request-count=0]
[2024/05/07 10:37:02.476 +08:00] [INFO] [tso_dispatcher.go:350] ["[tso] exit tso connection contexts updater"] [dc-location=global]
[2024/05/07 10:37:02.476 +08:00] [INFO] [resource_manager_client.go:295] ["[resource manager] exit resource token dispatcher"]
[2024/05/07 10:37:02.476 +08:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/07 10:37:02.476 +08:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/07 10:37:02.476 +08:00] [INFO] [tso_batch_controller.go:160] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=5] [collected-request-count=0] [pending-request-count=0]
[2024/05/07 10:37:02.476 +08:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/07 10:37:02.476 +08:00] [INFO] [pd_service_discovery.go:637] ["[pd] close pd service discovery client"]
[2024/05/07 10:37:02.476 +08:00] [INFO] [client.go:329] ["[pd] http client closed"] [source=lightning]
[2024/05/07 10:37:02.476 +08:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/07 10:37:02.476 +08:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/07 10:37:02.476 +08:00] [INFO] [tso_batch_controller.go:160] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=5] [collected-request-count=0] [pending-request-count=0]
[2024/05/07 10:37:02.477 +08:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/07 10:37:02.477 +08:00] [INFO] [backend_mgr.go:309] ["close one backend for DDL job"] ["job ID"=20534] ["current memory usage"=33600] ["max memory quota"=17179869184]
[2024/05/07 10:37:02.477 +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=115.488288ms] []
[2024/05/07 10:37:02.515 +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/05/07 10:37:02.714 +08:00] [INFO] [reorg.go:232] ["run reorg job done"] [category=ddl] ["handled rows"=1]
[2024/05/07 10:37:02.771 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20534] [conn=1631586692] [category=ddl] [job="ID:20534, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20501, TableID:20532, RowCount:1, ArgLen:0, start time: 2024-05-07 10:37:01.289 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449589915533967364, LocalMode: false, UniqueWarnings:0"]
[2024/05/07 10:37:02.772 +08:00] [INFO] [index.go:880] ["index backfill state ready to merge"] [category=ddl] ["job ID"=20534] [table=t0] [index=i0]
[2024/05/07 10:37:02.777 +08:00] [INFO] [manager.go:332] ["task executor exit"] [task-id=660015] [type=backfill]
[2024/05/07 10:37:02.805 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20534] [conn=1631586692] [category=ddl] [job="ID:20534, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20501, TableID:20532, RowCount:1, ArgLen:0, start time: 2024-05-07 10:37:01.289 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/05/07 10:37:02.806 +08:00] [INFO] [reorg.go:718] ["job get table range"] [category=ddl] [jobID=20534] [physicalTableID=20532] [startKey=7480000000000050345f69ffff000000000001] [endKey=7480000000000050345f69ffff000000000001ff]
[2024/05/07 10:37:02.846 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20534] [conn=1631586692] [category=ddl] [job="ID:20534, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20501, TableID:20532, RowCount:1, ArgLen:0, start time: 2024-05-07 10:37:01.289 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449589915887861763, LocalMode: false, UniqueWarnings:0"]
[2024/05/07 10:37:02.848 +08:00] [INFO] [index.go:1928] ["start to merge temp index"] [category=ddl] [job="ID:20534, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20501, TableID:20532, RowCount:1, ArgLen:6, start time: 2024-05-07 10:37:01.289 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449589915887861763, LocalMode: false, UniqueWarnings:0"] [reorgInfo="CurrElementType:_idx_,CurrElementID:1,StartKey:7480000000000050345f69ffff000000000001,EndKey:7480000000000050345f69ffff000000000001ff,First:false,PhysicalTableID:20532,Ingest mode:false"]
[2024/05/07 10:37:02.850 +08:00] [INFO] [backfilling.go:416] ["split table range from PD"] [category=ddl] [physicalTableID=20532] ["start key"=7480000000000050345f69ffff000000000001] ["end key"=7480000000000050345f69ffff000000000001ff]
[2024/05/07 10:37:02.850 +08:00] [INFO] [backfilling.go:692] ["start backfill workers to reorg record"] [category=ddl] [type="merge temporary index"] [workerCnt=4] [regionCnt=1] [startKey=7480000000000050345f69ffff000000000001] [endKey=7480000000000050345f69ffff000000000001ff]
[2024/05/07 10:37:02.851 +08:00] [INFO] [backfilling.go:475] ["get backfill range task, change end key"] [category=ddl] [id=1] [pTbl=20532] ["end key"=7480000000000050345f69ffff000000000001ff] ["current end key"=7480000000000050345f69ffff00000000000100]
[2024/05/07 10:37:02.851 +08:00] [INFO] [backfilling.go:369] ["backfill worker exit"] [category=ddl] [worker="backfill-worker 3, tp merge temporary index"] [jobID=20534]
[2024/05/07 10:37:02.851 +08:00] [INFO] [backfilling.go:369] ["backfill worker exit"] [category=ddl] [worker="backfill-worker 1, tp merge temporary index"] [jobID=20534]
[2024/05/07 10:37:02.851 +08:00] [INFO] [backfilling.go:369] ["backfill worker exit"] [category=ddl] [worker="backfill-worker 2, tp merge temporary index"] [jobID=20534]
[2024/05/07 10:37:02.851 +08:00] [INFO] [backfilling.go:330] ["backfill worker finish task"] [category=ddl] [worker="backfill-worker 0, tp merge temporary index"] [task="taskID: 1, physicalTableID: 20532, range: [7480000000000050345f69ffff000000000001, 7480000000000050345f69ffff00000000000100), jobID: 20534"] ["added count"=0] ["scan count"=0] ["next key"=7480000000000050345f69ffff0000000000010000] ["take time"=539.533µs]
[2024/05/07 10:37:02.851 +08:00] [INFO] [backfilling.go:369] ["backfill worker exit"] [category=ddl] [worker="backfill-worker 0, tp merge temporary index"] [jobID=20534]
[2024/05/07 10:37:02.851 +08:00] [INFO] [backfilling.go:632] ["backfill workers successfully processed"] [category=ddl] [element=ID:1,TypeKey:_idx_] ["total added count"=1] ["start key"=7480000000000050345f69ffff000000000001]
[2024/05/07 10:37:02.851 +08:00] [INFO] [reorg.go:232] ["run reorg job done"] [category=ddl] ["handled rows"=1]
[2024/05/07 10:37:02.860 +08:00] [INFO] [index.go:781] ["run add index job done"] [category=ddl] [charset=utf8mb4] [collation=utf8mb4_general_ci]
[2024/05/07 10:37:02.890 +08:00] [INFO] [delete_range.go:422] ["insert into delete-range indices"] [category=ddl] [jobID=20534] [tableID=20532] [indexIDs="[9223090561878065153]"] [comment="add index: physical table ID(s)"]
[2024/05/07 10:37:02.893 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20534] [jobType="add index"]
[2024/05/07 10:37:02.893 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20534] [conn=1631586692] [job="ID:20534, Type:add index, State:synced, SchemaState:public, SchemaID:20501, TableID:20532, RowCount:1, ArgLen:3, start time: 2024-05-07 10:37:01.289 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449589915887861763, LocalMode: false, UniqueWarnings:0"]
[2024/05/07 10:37:02.900 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20534]
[2024/05/07 10:37:02.900 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:02.903 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24659] [neededSchemaVersion=24665] ["start time"=1.868573ms] [gotSchemaVersion=24665] [phyTblIDs="[20532,20532,20532,20532,20532,20532]"] [actionTypes="[7,7,7,7,7,7]"] [diffTypes="[\"add index\",\"add index\",\"add index\",\"add index\",\"add index\",\"add index\"]"]
[2024/05/07 10:37:02.905 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t0;"]
[2024/05/07 10:37:02.939 +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/05/07 10:37:02.911 +08:00] ["end time"=2024/05/07 10:37:02.937 +08:00] [cost=26.286643ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/07 10:37:02.950 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select * from t0 where c0;"]
[2024/05/07 10:37:02.951 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [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/05/07 10:37:02.951 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [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/05/07 10:37:02.952 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [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/05/07 10:37:02.952 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [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/05/07 10:37:02.952 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [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/05/07 10:37:02.953 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [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/05/07 10:37:02.953 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_cost_model_version`=DEFAULT"]
[2024/05/07 10:37:02.953 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24665] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_cost_model_version`=2"]
[2024/05/07 10:37:02.953 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24665] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/05/07 10:37:02.968 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20535, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20530, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:02.94 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:02.968 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20535, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20530, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:02.94 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/05/07 10:37:02.994 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20535] [conn=1631586692] [category=ddl] [job="ID:20535, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20530, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:02.94 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.012 +08:00] [INFO] [scheduler_manager.go:364] ["task scheduler exist"] [task-id=660015]
[2024/05/07 10:37:03.014 +08:00] [INFO] [scheduler_manager.go:410] ["cleanup routine start"]
[2024/05/07 10:37:03.015 +08:00] [INFO] [scheduler_manager.go:426] ["cleanup task"] [task-id=660015]
[2024/05/07 10:37:03.019 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20535] [conn=1631586692] [category=ddl] [job="ID:20535, Type:drop table, State:running, SchemaState:write only, SchemaID:20501, TableID:20530, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:02.94 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.020 +08:00] [INFO] [scheduler_manager.go:419] ["cleanup routine success"]
[2024/05/07 10:37:03.042 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20535] [conn=1631586692] [category=ddl] [job="ID:20535, Type:drop table, State:running, SchemaState:delete only, SchemaID:20501, TableID:20530, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:02.94 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.064 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20535] [tableIDs="[20530]"] [comment="drop table: table ID"]
[2024/05/07 10:37:03.066 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20535] [jobType="drop table"]
[2024/05/07 10:37:03.067 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20535] [conn=1631586692] [job="ID:20535, Type:drop table, State:synced, SchemaState:none, SchemaID:20501, TableID:20530, RowCount:0, ArgLen:3, start time: 2024-05-07 10:37:02.94 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.070 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20535]
[2024/05/07 10:37:03.070 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:03.072 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24665] [neededSchemaVersion=24668] ["start time"=509.838µs] [gotSchemaVersion=24668] [phyTblIDs="[20530]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/07 10:37:03.073 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24668] [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/05/07 10:37:03.092 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20537, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20536, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:03.04 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:03.092 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20537, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20536, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:03.04 +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/05/07 10:37:03.126 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20537] [conn=1631586692] [category=ddl] [job="ID:20537, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20536, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.04 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.151 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20537] [conn=1631586692] [job="ID:20537, Type:create table, State:synced, SchemaState:public, SchemaID:20501, TableID:20536, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.04 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.155 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20537]
[2024/05/07 10:37:03.155 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:03.155 +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"=748000000000005038]
[2024/05/07 10:37:03.156 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005038] ["first new region left"="{Id:16686 StartKey:7480000000000050ff345f698000000000ff0000010131000000ff00000000f8038000ff0000000000010000fe EndKey:7480000000000050ff3800000000000000f8 RegionEpoch:{ConfVer:1 Version:8070} Peers:[id:16687 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/07 10:37:03.156 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16686]"]
[2024/05/07 10:37:03.157 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24668] [neededSchemaVersion=24669] ["start time"=683.459µs] [gotSchemaVersion=24669] [phyTblIDs="[20536]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/07 10:37:03.158 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24669] [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/05/07 10:37:03.159 +08:00] [WARN] [prewrite.go:382] ["1pc failed and fallbacks to normal commit procedure"] [conn=1631586692] [session_alias=] [startTS=449589915979612169]
[2024/05/07 10:37:03.161 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24669] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t;"]
[2024/05/07 10:37:03.207 +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/05/07 10:37:03.165 +08:00] ["end time"=2024/05/07 10:37:03.205 +08:00] [cost=40.392611ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/07 10:37:03.230 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24669] [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/05/07 10:37:03.231 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24669] [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/05/07 10:37:03.233 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24669] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_cost_model_version`=DEFAULT"]
[2024/05/07 10:37:03.234 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24669] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/05/07 10:37:03.249 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20538, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20536, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:03.24 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:03.249 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20538, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20536, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:03.24 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/05/07 10:37:03.278 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20538] [conn=1631586692] [category=ddl] [job="ID:20538, Type:drop table, State:queueing, SchemaState:public, SchemaID:20501, TableID:20536, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.24 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.303 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20538] [conn=1631586692] [category=ddl] [job="ID:20538, Type:drop table, State:running, SchemaState:write only, SchemaID:20501, TableID:20536, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.24 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.328 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20538] [conn=1631586692] [category=ddl] [job="ID:20538, Type:drop table, State:running, SchemaState:delete only, SchemaID:20501, TableID:20536, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.24 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.354 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20538] [tableIDs="[20536]"] [comment="drop table: table ID"]
[2024/05/07 10:37:03.356 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20538] [jobType="drop table"]
[2024/05/07 10:37:03.357 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20538] [conn=1631586692] [job="ID:20538, Type:drop table, State:synced, SchemaState:none, SchemaID:20501, TableID:20536, RowCount:0, ArgLen:3, start time: 2024-05-07 10:37:03.24 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.361 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20538]
[2024/05/07 10:37:03.361 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:03.363 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24669] [neededSchemaVersion=24672] ["start time"=546.068µs] [gotSchemaVersion=24672] [phyTblIDs="[20536]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/07 10:37:03.364 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586692] [schemaVersion=24672] [cur_db=util__ranger] [sql="create table t(a int not null, b int not null, primary key(a,b));"] [user=root@%]
[2024/05/07 10:37:03.380 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20540, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20539, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:03.34 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:03.380 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20540, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20539, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:03.34 +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/05/07 10:37:03.414 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20540] [conn=1631586692] [category=ddl] [job="ID:20540, Type:create table, State:queueing, SchemaState:none, SchemaID:20501, TableID:20539, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.34 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.440 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20540] [conn=1631586692] [job="ID:20540, Type:create table, State:synced, SchemaState:public, SchemaID:20501, TableID:20539, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.34 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.445 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20540]
[2024/05/07 10:37:03.445 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:03.445 +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"=74800000000000503b]
[2024/05/07 10:37:03.446 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=74800000000000503b] ["first new region left"="{Id:16688 StartKey:7480000000000050ff3800000000000000f8 EndKey:7480000000000050ff3b00000000000000f8 RegionEpoch:{ConfVer:1 Version:8071} Peers:[id:16689 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/07 10:37:03.446 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16688]"]
[2024/05/07 10:37:03.446 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24672] [neededSchemaVersion=24673] ["start time"=640.356µs] [gotSchemaVersion=24673] [phyTblIDs="[20539]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/07 10:37:03.448 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24673] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t values(1,2);"]
[2024/05/07 10:37:03.451 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24673] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t;"]
[2024/05/07 10:37:03.492 +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/05/07 10:37:03.456 +08:00] ["end time"=2024/05/07 10:37:03.490 +08:00] [cost=33.868713ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/07 10:37:03.508 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24673] [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/05/07 10:37:03.509 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586692] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24673] [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/05/07 10:37:03.510 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586696] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24673] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="use `test`"]
[2024/05/07 10:37:03.510 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586696] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24673] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`time_zone`=_UTF8MB4'Asia/Shanghai'"]
[2024/05/07 10:37:03.511 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586696] [schemaVersion=24673] [cur_db=test] [sql="drop database `util__ranger`"] [user=root@%]
[2024/05/07 10:37:03.526 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20541, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20501, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-07 10:37:03.489 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:03.526 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20541, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20501, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-07 10:37:03.489 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop database `util__ranger`"]
[2024/05/07 10:37:03.552 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20541] [conn=1631586696] [category=ddl] [job="ID:20541, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20501, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.489 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.577 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20541] [conn=1631586696] [category=ddl] [job="ID:20541, Type:drop schema, State:running, SchemaState:write only, SchemaID:20501, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.489 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.601 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20541] [conn=1631586696] [category=ddl] [job="ID:20541, Type:drop schema, State:running, SchemaState:delete only, SchemaID:20501, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.489 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.624 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20541] [tableIDs="[20505,20507,20518,20532,20539]"] [comment="drop schema: table IDs"]
[2024/05/07 10:37:03.627 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20541] [jobType="drop schema"]
[2024/05/07 10:37:03.627 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20541] [conn=1631586696] [job="ID:20541, Type:drop schema, State:synced, SchemaState:none, SchemaID:20501, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-07 10:37:03.489 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.630 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20541]
[2024/05/07 10:37:03.630 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:03.632 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24673] [neededSchemaVersion=24676] ["start time"=516.185µs] [gotSchemaVersion=24676] [phyTblIDs="[20505,20507,20518,20532,20539]"] [actionTypes="[2,2,2,2,2]"] [diffTypes="[\"drop schema\",\"drop schema\",\"drop schema\"]"]
[2024/05/07 10:37:03.633 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586698] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24676] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="use `test`"]
[2024/05/07 10:37:03.634 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586698] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24676] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`time_zone`=_UTF8MB4'Asia/Shanghai'"]
[2024/05/07 10:37:03.634 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586698] [schemaVersion=24676] [cur_db=test] [sql="create database `window_function`"] [user=root@%]
[2024/05/07 10:37:03.648 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20543, Type:create schema, State:queueing, SchemaState:none, SchemaID:20542, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-07 10:37:03.64 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:03.648 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20543, Type:create schema, State:queueing, SchemaState:none, SchemaID:20542, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-07 10:37:03.64 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create database `window_function`"]
[2024/05/07 10:37:03.685 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20543] [conn=1631586698] [category=ddl] [job="ID:20543, Type:create schema, State:queueing, SchemaState:none, SchemaID:20542, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.64 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.709 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20543] [conn=1631586698] [job="ID:20543, Type:create schema, State:synced, SchemaState:public, SchemaID:20542, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.64 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.712 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20543]
[2024/05/07 10:37:03.712 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:03.713 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24676] [neededSchemaVersion=24677] ["start time"=295.391µs] [gotSchemaVersion=24677] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"create schema\"]"]
[2024/05/07 10:37:03.715 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="use `test`"]
[2024/05/07 10:37:03.715 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`time_zone`=_UTF8MB4'Asia/Shanghai'"]
[2024/05/07 10:37:03.716 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586702] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="use `test`"]
[2024/05/07 10:37:03.716 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586702] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`time_zone`=_UTF8MB4'Asia/Shanghai'"]
[2024/05/07 10:37:03.716 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586702] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SELECT tidb_version()"]
[2024/05/07 10:37:03.716 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_init_chunk_size`=1"]
[2024/05/07 10:37:03.716 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_max_chunk_size`=32"]
[2024/05/07 10:37:03.717 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_multi_statement_mode`=1"]
[2024/05/07 10:37:03.717 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_hash_join_concurrency`=1"]
[2024/05/07 10:37:03.717 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_enable_pseudo_for_outdated_stats`=FALSE"]
[2024/05/07 10:37:03.717 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_enable_analyze_snapshot`=1"]
[2024/05/07 10:37:03.717 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_enable_clustered_index`=_UTF8MB4'int_only'"]
[2024/05/07 10:37:03.717 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="use `window_function`"]
[2024/05/07 10:37:03.717 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_cost_model_version`=1"]
[2024/05/07 10:37:03.718 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586700] [schemaVersion=24677] [cur_db=window_function] [sql="drop table if exists t;"] [user=root@%]
[2024/05/07 10:37:03.718 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586700] [schemaVersion=24677] [cur_db=window_function] [sql="create table t (a int, b int, c timestamp, index idx(a));"] [user=root@%]
[2024/05/07 10:37:03.734 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20545, Type:create table, State:queueing, SchemaState:none, SchemaID:20542, TableID:20544, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:03.69 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:03.734 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20545, Type:create table, State:queueing, SchemaState:none, SchemaID:20542, TableID:20544, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:03.69 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table t (a int, b int, c timestamp, index idx(a));"]
[2024/05/07 10:37:03.767 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20545] [conn=1631586700] [category=ddl] [job="ID:20545, Type:create table, State:queueing, SchemaState:none, SchemaID:20542, TableID:20544, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.69 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.791 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20545] [conn=1631586700] [job="ID:20545, Type:create table, State:synced, SchemaState:public, SchemaID:20542, TableID:20544, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.69 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.795 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20545]
[2024/05/07 10:37:03.795 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:03.795 +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"=748000000000005040]
[2024/05/07 10:37:03.797 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005040] ["first new region left"="{Id:16690 StartKey:7480000000000050ff3b00000000000000f8 EndKey:7480000000000050ff4000000000000000f8 RegionEpoch:{ConfVer:1 Version:8072} Peers:[id:16691 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/07 10:37:03.797 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16690]"]
[2024/05/07 10:37:03.797 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24677] [neededSchemaVersion=24678] ["start time"=625.815µs] [gotSchemaVersion=24678] [phyTblIDs="[20544]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/07 10:37:03.798 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_enable_window_function`=1"]
[2024/05/07 10:37:03.798 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_window_concurrency`=1"]
[2024/05/07 10:37:03.799 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over() from t;"]
[2024/05/07 10:37:03.799 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [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/05/07 10:37:03.800 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [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/05/07 10:37:03.800 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [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/05/07 10:37:03.801 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [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/05/07 10:37:03.801 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [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/05/07 10:37:03.802 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [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/05/07 10:37:03.802 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_window_concurrency`=4"]
[2024/05/07 10:37:03.802 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select sum(a) over() from t;"]
[2024/05/07 10:37:03.803 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [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/05/07 10:37:03.803 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [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/05/07 10:37:03.803 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [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/05/07 10:37:03.804 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [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/05/07 10:37:03.804 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [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/05/07 10:37:03.805 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [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/05/07 10:37:03.805 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586700] [schemaVersion=24678] [cur_db=window_function] [sql="drop table if exists t1;"] [user=root@%]
[2024/05/07 10:37:03.806 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586700] [schemaVersion=24678] [cur_db=window_function] [sql="create table t1(a int primary key, b int);"] [user=root@%]
[2024/05/07 10:37:03.823 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20547, Type:create table, State:queueing, SchemaState:none, SchemaID:20542, TableID:20546, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:03.79 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:03.823 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20547, Type:create table, State:queueing, SchemaState:none, SchemaID:20542, TableID:20546, RowCount:0, ArgLen:2, start time: 2024-05-07 10:37:03.79 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table t1(a int primary key, b int);"]
[2024/05/07 10:37:03.852 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20547] [conn=1631586700] [category=ddl] [job="ID:20547, Type:create table, State:queueing, SchemaState:none, SchemaID:20542, TableID:20546, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.79 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.877 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20547] [conn=1631586700] [job="ID:20547, Type:create table, State:synced, SchemaState:public, SchemaID:20542, TableID:20546, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.79 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:03.881 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20547]
[2024/05/07 10:37:03.881 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:03.881 +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"=748000000000005042]
[2024/05/07 10:37:03.882 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24678] [neededSchemaVersion=24679] ["start time"=515.756µs] [gotSchemaVersion=24679] [phyTblIDs="[20546]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/07 10:37:03.883 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24679] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t1 values(1, 1), (2, 1);"]
[2024/05/07 10:37:03.884 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005042] ["first new region left"="{Id:16692 StartKey:7480000000000050ff4000000000000000f8 EndKey:7480000000000050ff4200000000000000f8 RegionEpoch:{ConfVer:1 Version:8073} Peers:[id:16693 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/07 10:37:03.884 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16692]"]
[2024/05/07 10:37:03.885 +08:00] [WARN] [prewrite.go:382] ["1pc failed and fallbacks to normal commit procedure"] [conn=1631586700] [session_alias=] [startTS=449589916163112979]
[2024/05/07 10:37:03.887 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24679] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t1;"]
[2024/05/07 10:37:03.912 +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/05/07 10:37:03.891 +08:00] ["end time"=2024/05/07 10:37:03.910 +08:00] [cost=19.062785ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/07 10:37:03.923 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24679] [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/05/07 10:37:03.924 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24679] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t1 values(3, 3);"]
[2024/05/07 10:37:03.925 +08:00] [WARN] [prewrite.go:382] ["1pc failed and fallbacks to normal commit procedure"] [conn=1631586700] [session_alias=] [startTS=449589916176220188]
[2024/05/07 10:37:03.926 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24679] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t1;"]
[2024/05/07 10:37:03.932 +08:00] [INFO] [save.go:200] ["incrementally update modifyCount"] [category=stats] [tableID=20546] [curModifyCnt=0] [results.BaseModifyCnt=0] [modifyCount=0]
[2024/05/07 10:37:03.932 +08:00] [INFO] [save.go:211] ["incrementally update count"] [category=stats] [tableID=20546] [curCnt=2] [results.Count=3] [results.BaseCount=2] [count=3]
[2024/05/07 10:37:03.952 +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/05/07 10:37:03.928 +08:00] ["end time"=2024/05/07 10:37:03.950 +08:00] [cost=21.4164ms] ["sample rate reason"="use min(1, 110000/2) as the sample-rate=1"]
[2024/05/07 10:37:03.963 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586700] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24679] [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/05/07 10:37:03.964 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586704] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24679] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="use `test`"]
[2024/05/07 10:37:03.965 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=1631586704] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24679] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`time_zone`=_UTF8MB4'Asia/Shanghai'"]
[2024/05/07 10:37:03.965 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=1631586704] [schemaVersion=24679] [cur_db=test] [sql="drop database `window_function`"] [user=root@%]
[2024/05/07 10:37:03.980 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20548, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20542, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-07 10:37:03.94 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/07 10:37:03.980 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20548, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20542, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-07 10:37:03.94 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop database `window_function`"]
[2024/05/07 10:37:04.005 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20548] [conn=1631586704] [category=ddl] [job="ID:20548, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20542, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.94 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:04.029 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20548] [conn=1631586704] [category=ddl] [job="ID:20548, Type:drop schema, State:running, SchemaState:write only, SchemaID:20542, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.94 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:04.055 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20548] [conn=1631586704] [category=ddl] [job="ID:20548, Type:drop schema, State:running, SchemaState:delete only, SchemaID:20542, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-07 10:37:03.94 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:04.080 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20548] [tableIDs="[20544,20546]"] [comment="drop schema: table IDs"]
[2024/05/07 10:37:04.082 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20548] [jobType="drop schema"]
[2024/05/07 10:37:04.083 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20548] [conn=1631586704] [job="ID:20548, Type:drop schema, State:synced, SchemaState:none, SchemaID:20542, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-07 10:37:03.94 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/07 10:37:04.086 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20548]
[2024/05/07 10:37:04.086 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/07 10:37:04.088 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24679] [neededSchemaVersion=24682] ["start time"=522.308µs] [gotSchemaVersion=24682] [phyTblIDs="[20544,20546]"] [actionTypes="[2,2]"] [diffTypes="[\"drop schema\",\"drop schema\",\"drop schema\"]"]
[Pipeline] archiveArtifacts
Archiving artifacts
No test report files were found. Configuration error?
[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