Skipping 16,002 KB.. Full Log

[2024/05/06 18:36:50.874 +08:00] [INFO] [scheduler.rs:769] ["get snapshot failed"] [err="Error(Request(message: \"EpochNotMatch current epoch of region 14 is conf_ver: 1 version: 8061, but you sent conf_ver: 1 version: 8060\" epoch_not_match { current_regions { id: 14 start_key: 7480000000000050FF4000000000000000F8 end_key: 748000FFFFFFFFFFFFF900000000000000F8 region_epoch { conf_ver: 1 version: 8061 } peers { id: 15 store_id: 1 } } current_regions { id: 16812 start_key: 7480000000000050FF3E00000000000000F8 end_key: 7480000000000050FF4000000000000000F8 region_epoch { conf_ver: 1 version: 8061 } peers { id: 16813 store_id: 1 } } }))"] [cid=549881] [thread_id=61]
[2024/05/06 18:36:50.874 +08:00] [INFO] [endpoint.rs:358] ["Resolver initialized"] [pending_data_index=0] [snapshot_index=20820] [observe_id=ObserveId(16197)] [region=14] [thread_id=68]
[2024/05/06 18:36:50.874 +08:00] [INFO] [pd.rs:1705] ["succeed to update max timestamp"] [region_id=16812] [thread_id=31]
[2024/05/06 18:36:50.874 +08:00] [INFO] [endpoint.rs:701] ["register observe region"] [region="id: 16812 start_key: 7480000000000050FF3E00000000000000F8 end_key: 7480000000000050FF4000000000000000F8 region_epoch { conf_ver: 1 version: 8061 } peers { id: 16813 store_id: 1 }"] [thread_id=68]
[2024/05/06 18:36:50.874 +08:00] [INFO] [endpoint.rs:358] ["Resolver initialized"] [pending_data_index=0] [snapshot_index=6] [observe_id=ObserveId(16198)] [region=16812] [thread_id=68]
[2024/05/06 18:36:50.911 +08:00] [WARN] [prewrite.rs:832] ["commit_ts is too large, fallback to normal 2PC"] [lock="Lock { lock_type: Put, primary_key: 7480000000000050405F728000000000000003, start_ts: TimeStamp(449574813270540319), ttl: 3000, short_value: 80000100000002010003, for_update_ts: TimeStamp(0), txn_size: 1, min_commit_ts: TimeStamp(449574813270540320), use_async_commit: true, secondaries: [], rollback_ts: [], last_change: Unknown, txn_source: 0, is_locked_with_conflict: false, generation: 0 }"] [max_commit_ts=449574813270540319] [min_commit_ts=449574813270540320] [start_ts=449574813270540319] [key=7480000000000050FF405F728000000000FF0000030000000000FA] [thread_id=62]
+ find . -name '*.out' -type f -exec tail -n 500 '{}' +
[2024/05/06 18:36:46.459 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24637] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a > 0;"]
[2024/05/06 18:36:46.460 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24637] [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/06 18:36:46.461 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24637] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a > -1;"]
[2024/05/06 18:36:46.463 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24637] [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/06 18:36:46.463 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24637] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t where a > 3;"]
[2024/05/06 18:36:46.464 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24637] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_partition_prune_mode`=DEFAULT"]
[2024/05/06 18:36:46.465 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24637] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_executor_concurrency`=DEFAULT"]
[2024/05/06 18:36:46.465 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24637] [cur_db=util__ranger] [sql="drop table if exists t2;"] [user=root@%]
[2024/05/06 18:36:46.479 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20515, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20507, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:46.427 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:46.479 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20515, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20507, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:46.427 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t2;"]
[2024/05/06 18:36:46.506 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20515] [conn=3428845956] [category=ddl] [job="ID:20515, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20507, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:46.427 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:46.531 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20515] [conn=3428845956] [category=ddl] [job="ID:20515, Type:drop table, State:running, SchemaState:write only, SchemaID:20499, TableID:20507, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:46.427 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:46.554 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20515] [conn=3428845956] [category=ddl] [job="ID:20515, Type:drop table, State:running, SchemaState:delete only, SchemaID:20499, TableID:20507, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:46.427 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:46.581 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20515] [tableIDs="[20507]"] [comment="drop table: table ID"]
[2024/05/06 18:36:46.583 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20515] [jobType="drop table"]
[2024/05/06 18:36:46.584 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20515] [conn=3428845956] [job="ID:20515, Type:drop table, State:synced, SchemaState:none, SchemaID:20499, TableID:20507, RowCount:0, ArgLen:3, start time: 2024-05-06 18:36:46.427 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:46.588 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20515]
[2024/05/06 18:36:46.588 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:46.590 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24637] [neededSchemaVersion=24640] ["start time"=759.499µs] [gotSchemaVersion=24640] [phyTblIDs="[20507]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/06 18:36:46.592 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24640] [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/06 18:36:46.607 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20517, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20516, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:46.577 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:46.607 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20517, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20516, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:46.577 +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/06 18:36:46.646 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20517] [conn=3428845956] [category=ddl] [job="ID:20517, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20516, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:46.577 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:46.670 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20517] [conn=3428845956] [job="ID:20517, Type:create table, State:synced, SchemaState:public, SchemaID:20499, TableID:20516, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:46.577 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:46.674 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20517]
[2024/05/06 18:36:46.674 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:46.674 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=14] ["first split key"=748000000000005024]
[2024/05/06 18:36:46.675 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005024] ["first new region left"="{Id:16790 StartKey:7480000000000050ff2100000000000000f8 EndKey:7480000000000050ff2400000000000000f8 RegionEpoch:{ConfVer:1 Version:8050} Peers:[id:16791 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/06 18:36:46.675 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16790]"]
[2024/05/06 18:36:46.675 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24640] [neededSchemaVersion=24641] ["start time"=646.345µs] [gotSchemaVersion=24641] [phyTblIDs="[20516]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 18:36:46.676 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24641] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t2 (t) values ('aaaa'),('a');"]
[2024/05/06 18:36:46.679 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24641] [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/06 18:36:46.680 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24641] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t2 where t='aaaa';"]
[2024/05/06 18:36:46.682 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24641] [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/06 18:36:46.682 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24641] [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/06 18:36:46.684 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24641] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t2;"]
[2024/05/06 18:36:46.724 +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/06 18:36:46.688 +08:00] ["end time"=2024/05/06 18:36:46.722 +08:00] [cost=33.68788ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/06 18:36:46.738 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24641] [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/06 18:36:46.738 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24641] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="select * from t2 where t='aaaa';"]
[2024/05/06 18:36:46.739 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24641] [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/06 18:36:46.740 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24641] [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/06 18:36:46.741 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24641] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/05/06 18:36:46.754 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20518, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20510, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:46.727 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:46.754 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20518, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20510, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:46.727 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/05/06 18:36:46.780 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20518] [conn=3428845956] [category=ddl] [job="ID:20518, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20510, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:46.727 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:46.809 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20518] [conn=3428845956] [category=ddl] [job="ID:20518, Type:drop table, State:running, SchemaState:write only, SchemaID:20499, TableID:20510, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:46.727 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:46.839 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20518] [conn=3428845956] [category=ddl] [job="ID:20518, Type:drop table, State:running, SchemaState:delete only, SchemaID:20499, TableID:20510, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:46.727 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:46.868 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20518] [tableIDs="[20511,20512,20513]"] [comment="drop table: partition table IDs"]
[2024/05/06 18:36:46.870 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20518] [tableIDs="[20510]"] [comment="drop table: table ID"]
[2024/05/06 18:36:46.872 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20518] [jobType="drop table"]
[2024/05/06 18:36:46.873 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20518] [conn=3428845956] [job="ID:20518, Type:drop table, State:synced, SchemaState:none, SchemaID:20499, TableID:20510, RowCount:0, ArgLen:3, start time: 2024-05-06 18:36:46.727 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:46.877 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20518]
[2024/05/06 18:36:46.877 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:46.879 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24641] [neededSchemaVersion=24644] ["start time"=596.535µs] [gotSchemaVersion=24644] [phyTblIDs="[20510,20511,20512,20513]"] [actionTypes="[4,4,4,4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/06 18:36:46.880 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24644] [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/06 18:36:46.898 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20520, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20519, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:46.877 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:46.898 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20520, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20519, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:46.877 +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/06 18:36:46.950 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20520] [conn=3428845956] [category=ddl] [job="ID:20520, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20519, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:46.877 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:46.981 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20520] [conn=3428845956] [job="ID:20520, Type:create table, State:synced, SchemaState:public, SchemaID:20499, TableID:20519, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:46.877 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:46.986 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20520]
[2024/05/06 18:36:46.986 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:46.986 +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"=748000000000005027]
[2024/05/06 18:36:46.987 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005027] ["first new region left"="{Id:16792 StartKey:7480000000000050ff2400000000000000f8 EndKey:7480000000000050ff2700000000000000f8 RegionEpoch:{ConfVer:1 Version:8051} Peers:[id:16793 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/06 18:36:46.987 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16792]"]
[2024/05/06 18:36:46.987 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24644] [neededSchemaVersion=24645] ["start time"=647.804µs] [gotSchemaVersion=24645] [phyTblIDs="[20519]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 18:36:46.988 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24645] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into 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/06 18:36:46.992 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24645] [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/06 18:36:46.992 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24645] [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/06 18:36:46.994 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24645] [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/06 18:36:46.995 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24645] [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/06 18:36:46.997 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24645] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/05/06 18:36:47.010 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20521, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20519, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:46.977 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:47.010 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20521, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20519, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:46.977 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/05/06 18:36:47.045 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20521] [conn=3428845956] [category=ddl] [job="ID:20521, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20519, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:46.977 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.075 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20521] [conn=3428845956] [category=ddl] [job="ID:20521, Type:drop table, State:running, SchemaState:write only, SchemaID:20499, TableID:20519, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:46.977 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.099 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20521] [conn=3428845956] [category=ddl] [job="ID:20521, Type:drop table, State:running, SchemaState:delete only, SchemaID:20499, TableID:20519, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:46.977 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.122 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20521] [tableIDs="[20519]"] [comment="drop table: table ID"]
[2024/05/06 18:36:47.124 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20521] [jobType="drop table"]
[2024/05/06 18:36:47.125 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20521] [conn=3428845956] [job="ID:20521, Type:drop table, State:synced, SchemaState:none, SchemaID:20499, TableID:20519, RowCount:0, ArgLen:3, start time: 2024-05-06 18:36:46.977 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.129 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20521]
[2024/05/06 18:36:47.129 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:47.131 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24645] [neededSchemaVersion=24648] ["start time"=658.358µs] [gotSchemaVersion=24648] [phyTblIDs="[20519]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/06 18:36:47.132 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24648] [cur_db=util__ranger] [sql="create table t(a int, b int, c int, primary key(a,b,c));"] [user=root@%]
[2024/05/06 18:36:47.149 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20523, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20522, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:47.127 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:47.149 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20523, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20522, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:47.127 +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/06 18:36:47.183 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20523] [conn=3428845956] [category=ddl] [job="ID:20523, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20522, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.127 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.208 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20523] [conn=3428845956] [job="ID:20523, Type:create table, State:synced, SchemaState:public, SchemaID:20499, TableID:20522, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.127 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.213 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20523]
[2024/05/06 18:36:47.213 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:47.213 +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"=74800000000000502a]
[2024/05/06 18:36:47.214 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=74800000000000502a] ["first new region left"="{Id:16794 StartKey:7480000000000050ff2700000000000000f8 EndKey:7480000000000050ff2a00000000000000f8 RegionEpoch:{ConfVer:1 Version:8052} Peers:[id:16795 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/06 18:36:47.214 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16794]"]
[2024/05/06 18:36:47.215 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24648] [neededSchemaVersion=24649] ["start time"=697.449µs] [gotSchemaVersion=24649] [phyTblIDs="[20522]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 18:36:47.216 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.219 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t;"]
[2024/05/06 18:36:47.258 +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/06 18:36:47.223 +08:00] ["end time"=2024/05/06 18:36:47.256 +08:00] [cost=32.806481ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/06 18:36:47.280 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.281 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.282 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.283 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.284 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.284 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.285 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.286 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.287 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.288 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.289 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.290 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.291 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.292 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.293 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.293 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.295 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.295 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24649] [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/06 18:36:47.296 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24649] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/05/06 18:36:47.311 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20524, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20522, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:47.277 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:47.311 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20524, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20522, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:47.277 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/05/06 18:36:47.337 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20524] [conn=3428845956] [category=ddl] [job="ID:20524, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20522, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.277 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.360 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20524] [conn=3428845956] [category=ddl] [job="ID:20524, Type:drop table, State:running, SchemaState:write only, SchemaID:20499, TableID:20522, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.277 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.383 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20524] [conn=3428845956] [category=ddl] [job="ID:20524, Type:drop table, State:running, SchemaState:delete only, SchemaID:20499, TableID:20522, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.277 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.410 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20524] [tableIDs="[20522]"] [comment="drop table: table ID"]
[2024/05/06 18:36:47.412 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20524] [jobType="drop table"]
[2024/05/06 18:36:47.412 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20524] [conn=3428845956] [job="ID:20524, Type:drop table, State:synced, SchemaState:none, SchemaID:20499, TableID:20522, RowCount:0, ArgLen:3, start time: 2024-05-06 18:36:47.277 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.416 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20524]
[2024/05/06 18:36:47.416 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:47.418 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24649] [neededSchemaVersion=24652] ["start time"=513.008µs] [gotSchemaVersion=24652] [phyTblIDs="[20522]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/06 18:36:47.419 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24652] [cur_db=util__ranger] [sql="create table t(a int, b int, c int, primary key(a,b));"] [user=root@%]
[2024/05/06 18:36:47.441 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20526, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20525, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:47.427 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:47.441 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20526, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20525, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:47.427 +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/06 18:36:47.468 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20526] [conn=3428845956] [category=ddl] [job="ID:20526, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20525, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.427 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.495 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20526] [conn=3428845956] [job="ID:20526, Type:create table, State:synced, SchemaState:public, SchemaID:20499, TableID:20525, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.427 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.499 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20526]
[2024/05/06 18:36:47.499 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:47.499 +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"=74800000000000502d]
[2024/05/06 18:36:47.500 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=74800000000000502d] ["first new region left"="{Id:16796 StartKey:7480000000000050ff2a00000000000000f8 EndKey:7480000000000050ff2d00000000000000f8 RegionEpoch:{ConfVer:1 Version:8053} Peers:[id:16797 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/06 18:36:47.500 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16796]"]
[2024/05/06 18:36:47.501 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24652] [neededSchemaVersion=24653] ["start time"=574.017µs] [gotSchemaVersion=24653] [phyTblIDs="[20525]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 18:36:47.502 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24653] [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/06 18:36:47.505 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24653] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t;"]
[2024/05/06 18:36:47.542 +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/06 18:36:47.509 +08:00] ["end time"=2024/05/06 18:36:47.540 +08:00] [cost=30.724194ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/06 18:36:47.562 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24653] [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/06 18:36:47.562 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24653] [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/06 18:36:47.564 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24653] [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/06 18:36:47.564 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24653] [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/06 18:36:47.565 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24653] [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/06 18:36:47.566 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24653] [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/06 18:36:47.568 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24653] [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/06 18:36:47.568 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24653] [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/06 18:36:47.569 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24653] [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/06 18:36:47.570 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24653] [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/06 18:36:47.571 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24653] [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/06 18:36:47.571 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24653] [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/06 18:36:47.572 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24653] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_regard_null_as_point`=FALSE"]
[2024/05/06 18:36:47.572 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24653] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/05/06 18:36:47.585 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20527, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20525, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:47.577 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:47.585 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20527, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20525, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:47.577 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/05/06 18:36:47.607 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20527] [conn=3428845956] [category=ddl] [job="ID:20527, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20525, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.577 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.629 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20527] [conn=3428845956] [category=ddl] [job="ID:20527, Type:drop table, State:running, SchemaState:write only, SchemaID:20499, TableID:20525, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.577 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.653 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20527] [conn=3428845956] [category=ddl] [job="ID:20527, Type:drop table, State:running, SchemaState:delete only, SchemaID:20499, TableID:20525, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.577 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.676 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20527] [tableIDs="[20525]"] [comment="drop table: table ID"]
[2024/05/06 18:36:47.678 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20527] [jobType="drop table"]
[2024/05/06 18:36:47.678 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20527] [conn=3428845956] [job="ID:20527, Type:drop table, State:synced, SchemaState:none, SchemaID:20499, TableID:20525, RowCount:0, ArgLen:3, start time: 2024-05-06 18:36:47.577 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.682 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20527]
[2024/05/06 18:36:47.682 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:47.684 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24653] [neededSchemaVersion=24656] ["start time"=530.464µs] [gotSchemaVersion=24656] [phyTblIDs="[20525]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/06 18:36:47.685 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24656] [cur_db=util__ranger] [sql="create table t(a int, b int, c int, key(a,b,c));"] [user=root@%]
[2024/05/06 18:36:47.700 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20529, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20528, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:47.677 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:47.700 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20529, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20528, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:47.677 +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/06 18:36:47.732 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20529] [conn=3428845956] [category=ddl] [job="ID:20529, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20528, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.677 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.764 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20529] [conn=3428845956] [job="ID:20529, Type:create table, State:synced, SchemaState:public, SchemaID:20499, TableID:20528, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.677 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.769 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20529]
[2024/05/06 18:36:47.769 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:47.769 +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"=748000000000005030]
[2024/05/06 18:36:47.770 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005030] ["first new region left"="{Id:16798 StartKey:7480000000000050ff2d00000000000000f8 EndKey:7480000000000050ff3000000000000000f8 RegionEpoch:{ConfVer:1 Version:8054} Peers:[id:16799 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/06 18:36:47.770 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16798]"]
[2024/05/06 18:36:47.770 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24656] [neededSchemaVersion=24657] ["start time"=678.333µs] [gotSchemaVersion=24657] [phyTblIDs="[20528]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 18:36:47.772 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t values(1,2,2);"]
[2024/05/06 18:36:47.775 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.775 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.776 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.777 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.778 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.778 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.779 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.780 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.780 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.781 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.782 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.782 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.783 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.784 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.785 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.785 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.786 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.786 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [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/06 18:36:47.787 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_regard_null_as_point`=DEFAULT"]
[2024/05/06 18:36:47.787 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24657] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_cost_model_version`=2"]
[2024/05/06 18:36:47.787 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24657] [cur_db=util__ranger] [sql="drop table if exists t0;"] [user=root@%]
[2024/05/06 18:36:47.787 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24657] [cur_db=util__ranger] [sql="CREATE TABLE t0(c0 TEXT(10));"] [user=root@%]
[2024/05/06 18:36:47.788 +08:00] [INFO] [ddl_api.go:1133] ["Automatically convert BLOB(10) to TINYBLOB"] [category=ddl]
[2024/05/06 18:36:47.803 +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:20499, TableID:20530, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:47.777 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:47.803 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20531, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20530, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:47.777 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE TABLE t0(c0 TEXT(10));"]
[2024/05/06 18:36:47.828 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20531] [conn=3428845956] [category=ddl] [job="ID:20531, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20530, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.777 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.854 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20531] [conn=3428845956] [job="ID:20531, Type:create table, State:synced, SchemaState:public, SchemaID:20499, TableID:20530, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.777 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:47.858 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20531]
[2024/05/06 18:36:47.858 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:47.858 +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/06 18:36:47.859 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005032] ["first new region left"="{Id:16800 StartKey:7480000000000050ff3000000000000000f8 EndKey:7480000000000050ff3200000000000000f8 RegionEpoch:{ConfVer:1 Version:8055} Peers:[id:16801 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/06 18:36:47.859 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16800]"]
[2024/05/06 18:36:47.860 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24657] [neededSchemaVersion=24658] ["start time"=647.909µs] [gotSchemaVersion=24658] [phyTblIDs="[20530]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 18:36:47.861 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [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 t0(c0) VALUES (1);"]
[2024/05/06 18:36:47.865 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24658] [cur_db=util__ranger] [sql="CREATE INDEX i0 ON t0(c0(255));"] [user=root@%]
[2024/05/06 18:36:47.880 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20532, Type:add index, State:queueing, SchemaState:none, SchemaID:20499, TableID:20530, RowCount:0, ArgLen:6, start time: 2024-05-06 18:36:47.827 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0; "] [table=true]
[2024/05/06 18:36:47.880 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20532, Type:add index, State:queueing, SchemaState:none, SchemaID:20499, TableID:20530, RowCount:0, ArgLen:6, start time: 2024-05-06 18:36:47.827 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"] [query="CREATE INDEX i0 ON t0(c0(255));"]
[2024/05/06 18:36:47.924 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20532] [conn=3428845956] [category=ddl] [job="ID:20532, Type:add index, State:queueing, SchemaState:none, SchemaID:20499, TableID:20530, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.827 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 18:36:47.925 +08:00] [INFO] [index.go:654] ["run add index job"] [category=ddl] [job="ID:20532, Type:add index, State:running, SchemaState:none, SchemaID:20499, TableID:20530, RowCount:0, ArgLen:6, start time: 2024-05-06 18:36:47.827 +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/06 18:36:47.948 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20532] [conn=3428845956] [category=ddl] [job="ID:20532, Type:add index, State:running, SchemaState:delete only, SchemaID:20499, TableID:20530, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.827 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 18:36:47.971 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20532] [conn=3428845956] [category=ddl] [job="ID:20532, Type:add index, State:running, SchemaState:write only, SchemaID:20499, TableID:20530, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.827 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 18:36:47.995 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20532] [conn=3428845956] [category=ddl] [job="ID:20532, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20499, TableID:20530, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.827 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 18:36:47.996 +08:00] [INFO] [index.go:857] ["index backfill state running"] [category=ddl] ["job ID"=20532] [table=t0] ["ingest mode"=true] [index=i0]
[2024/05/06 18:36:47.997 +08:00] [INFO] [reorg.go:718] ["job get table range"] [category=ddl] [jobID=20532] [physicalTableID=20530] [startKey=7480000000000050325f728000000000000001] [endKey=7480000000000050325f72800000000000000100]
[2024/05/06 18:36:48.017 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20532] [conn=3428845956] [category=ddl] [job="ID:20532, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20499, TableID:20530, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:47.827 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449574812510322693, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 18:36:48.018 +08:00] [INFO] [index.go:857] ["index backfill state running"] [category=ddl] ["job ID"=20532] [table=t0] ["ingest mode"=true] [index=i0]
[2024/05/06 18:36:48.025 +08:00] [INFO] [index.go:2089] ["adjusted add-index task concurrency"] [category=ddl] [worker-cnt=4] [task-concurrency=4] [task-key=ddl/backfill/20532]
[2024/05/06 18:36:48.038 +08:00] [INFO] [index.go:2178] ["estimate row size"] [tableID=20530] [size=0] [error="less than 3 regions"]
[2024/05/06 18:36:48.048 +08:00] [INFO] [scheduler_manager.go:355] ["task scheduler started"] [task-id=660015]
[2024/05/06 18:36:48.048 +08:00] [INFO] [scheduler.go:120] ["schedule task"] [task-id=660015] [task-type=backfill] [allocated-slots=true] [state=pending] [concurrency=4]
[2024/05/06 18:36:48.550 +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/06 18:36:48.550 +08:00] [INFO] [scheduler.go:446] ["eligible instances"] [task-id=660015] [task-type=backfill] [allocated-slots=true] [num=1]
[2024/05/06 18:36:48.552 +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/06 18:36:48.553 +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/06 18:36:48.809 +08:00] [INFO] [manager.go:328] ["task executor started"] [task-id=660015] [type=backfill] [remaining-slots=4]
[2024/05/06 18:36:49.113 +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/06 18:36:49.116 +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/06 18:36:49.116 +08:00] [INFO] [backend_mgr.go:248] ["create local backend for adding index"] [category=ddl-ingest] [sortDir=/tmp/tidb/tmp_ddl-33239/20532] [keyspaceName=]
[2024/05/06 18:36:49.118 +08:00] [INFO] [pd_service_discovery.go:1016] ["[pd] switch leader"] [new-leader=http://127.0.0.1:2379] [old-leader=]
[2024/05/06 18:36:49.118 +08:00] [INFO] [pd_service_discovery.go:498] ["[pd] init cluster id"] [cluster-id=7365825859822244185]
[2024/05/06 18:36:49.118 +08:00] [INFO] [client.go:613] ["[pd] changing service mode"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/06 18:36:49.118 +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/06 18:36:49.119 +08:00] [INFO] [client.go:619] ["[pd] service mode changed"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/06 18:36:49.119 +08:00] [INFO] [tso_dispatcher.go:168] ["[tso] tso dispatcher created"] [dc-location=global]
[2024/05/06 18:36:49.119 +08:00] [INFO] [tso_dispatcher.go:119] ["[tso] start tso deadline watcher"] [dc-location=global]
[2024/05/06 18:36:49.119 +08:00] [INFO] [tso_client.go:130] ["[tso] start tso dispatcher check loop"]
[2024/05/06 18:36:49.119 +08:00] [INFO] [tso_dispatcher.go:336] ["[tso] start tso connection contexts updater"] [dc-location=global]
[2024/05/06 18:36:49.121 +08:00] [INFO] [local.go:682] ["multi ingest support"] [category=ddl-ingest]
[2024/05/06 18:36:49.122 +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/06 18:36:49.122 +08:00] [INFO] [backend_mgr.go:161] ["create one backend for an DDL job"] ["job ID"=20532] ["current memory usage"=33776] ["max memory quota"=17179869184] ["is unique index"=false]
[2024/05/06 18:36:49.122 +08:00] [INFO] [backfilling_read_index.go:91] ["read index executor init subtask exec env"] [category=ddl]
[2024/05/06 18:36:49.127 +08:00] [INFO] [backfilling_read_index.go:96] ["read index executor run subtask"] [category=ddl] ["use cloud"=false]
[2024/05/06 18:36:49.129 +08:00] [INFO] [backend.go:253] ["open engine"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba]
[2024/05/06 18:36:49.129 +08:00] [INFO] [engine_mgr.go:81] ["open an engine for index reorg task"] ["job ID"=20532] ["index ID"=1] ["current memory usage"=671122560] ["memory limitation"=17179869184] ["current writer count"=1]
[2024/05/06 18:36:49.130 +08:00] [INFO] [backfilling_operators.go:160] ["build add index local storage operators"] [task-id=660015] [subtask-id=60015] [jobID=20532] [avgRowSize=0] [reader=2] [writer=4]
[2024/05/06 18:36:49.130 +08:00] [INFO] [backfilling.go:416] ["split table range from PD"] [category=ddl] [physicalTableID=20530] ["start key"=7480000000000050325f728000000000000001] ["end key"=7480000000000050325f72800000000000000100]
[2024/05/06 18:36:49.130 +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=7480000000000050325f728000000000000001, endKey=7480000000000050325f72800000000000000100"]
[2024/05/06 18:36:49.142 +08:00] [INFO] [engine.go:198] ["create one local writer for index reorg task"] ["job ID"=20532] ["index ID"=1] ["worker ID"=1] ["allocate memory"=40] ["current memory usage"=671122600] ["max memory quota"=17179869184]
[2024/05/06 18:36:49.185 +08:00] [INFO] [engine.go:198] ["create one local writer for index reorg task"] ["job ID"=20532] ["index ID"=1] ["worker ID"=2] ["allocate memory"=40] ["current memory usage"=671122640] ["max memory quota"=17179869184]
[2024/05/06 18:36:49.274 +08:00] [INFO] [engine.go:198] ["create one local writer for index reorg task"] ["job ID"=20532] ["index ID"=1] ["worker ID"=3] ["allocate memory"=40] ["current memory usage"=672171256] ["max memory quota"=17179869184]
[2024/05/06 18:36:49.186 +08:00] [INFO] [backfilling_operators.go:697] ["finish a index ingest task"] [task-id=660015] [subtask-id=60015] [id=1]
[2024/05/06 18:36:49.319 +08:00] [INFO] [engine.go:198] ["create one local writer for index reorg task"] ["job ID"=20532] ["index ID"=1] ["worker ID"=4] ["allocate memory"=40] ["current memory usage"=672171296] ["max memory quota"=17179869184]
[2024/05/06 18:36:49.319 +08:00] [INFO] [engine.go:867] ["write data to local DB"] [category=ddl-ingest] [size=39] [kvs=1] [files=1] [sstFileSize=945] [file=/tmp/tidb/tmp_ddl-33239/20532/4229afb8-665d-5dce-bb97-2afa316b67ba.sst/81d3b934-e347-4f31-962f-4f0c16428f33.sst] [firstKey=7480000000000050325F698000000000000001013100000000000000F8038000000000000001] [lastKey=7480000000000050325F698000000000000001013100000000000000F8038000000000000001]
[2024/05/06 18:36:49.322 +08:00] [INFO] [backend.go:215] ["acquire distributed flush lock success"] [jobID=20532]
[2024/05/06 18:36:49.322 +08:00] [INFO] [backend.go:237] ["do a partial import data into the storage"] ["index ID"=1] ["usage info"="disk usage: 215548145664/940431265792, backend usage: 0"]
[2024/05/06 18:36:49.322 +08:00] [INFO] [backend.go:372] ["import start"] [category=ddl-ingest] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba] [retryCnt=0]
[2024/05/06 18:36:49.322 +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/06 18:36:49.322 +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/06 18:36:49.322 +08:00] [INFO] [local.go:1280] ["pause pd scheduler of table scope"] [category=ddl-ingest]
[2024/05/06 18:36:49.344 +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/06 18:36:49.344 +08:00] [INFO] [local.go:835] ["import engine ranges"] [category=ddl-ingest] [count=1]
[2024/05/06 18:36:49.352 +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/06 18:36:49.353 +08:00] [INFO] [backend.go:378] ["import completed"] [category=ddl-ingest] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba] [retryCnt=0] [takeTime=31.210638ms] []
[2024/05/06 18:36:49.356 +08:00] [INFO] [backend.go:221] ["release distributed flush lock success"] [jobID=20532]
[2024/05/06 18:36:49.363 +08:00] [INFO] [backfilling_read_index.go:151] ["read index executor cleanup subtask exec env"]
[2024/05/06 18:36:49.363 +08:00] [INFO] [backend.go:330] ["engine close start"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba]
[2024/05/06 18:36:49.363 +08:00] [INFO] [backend.go:332] ["engine close completed"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba] [takeTime=695.35µs] []
[2024/05/06 18:36:49.364 +08:00] [INFO] [backend.go:391] ["cleanup start"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba]
[2024/05/06 18:36:49.364 +08:00] [INFO] [backend.go:393] ["cleanup completed"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba] [takeTime=451.496µs] []
[2024/05/06 18:36:49.364 +08:00] [INFO] [pd_service_discovery.go:550] ["[pd] exit member loop due to context canceled"]
[2024/05/06 18:36:49.364 +08:00] [INFO] [tso_dispatcher.go:350] ["[tso] exit tso connection contexts updater"] [dc-location=global]
[2024/05/06 18:36:49.364 +08:00] [INFO] [resource_manager_client.go:295] ["[resource manager] exit resource token dispatcher"]
[2024/05/06 18:36:49.364 +08:00] [INFO] [tso_client.go:145] ["[tso] exit tso dispatcher check loop"]
[2024/05/06 18:36:49.364 +08:00] [INFO] [tso_dispatcher.go:137] ["[tso] exit tso deadline watcher"] [dc-location=global]
[2024/05/06 18:36:49.364 +08:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 18:36:49.364 +08:00] [INFO] [tso_dispatcher.go:210] ["[tso] stop fetching the pending tso requests due to context canceled"] [dc-location=global]
[2024/05/06 18:36:49.364 +08:00] [INFO] [tso_dispatcher.go:171] ["[tso] exit tso dispatcher"] [dc-location=global]
[2024/05/06 18:36:49.365 +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/06 18:36:49.365 +08:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 18:36:49.365 +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/06 18:36:49.365 +08:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 18:36:49.365 +08:00] [INFO] [pd_service_discovery.go:637] ["[pd] close pd service discovery client"]
[2024/05/06 18:36:49.365 +08:00] [INFO] [client.go:329] ["[pd] http client closed"] [source=lightning]
[2024/05/06 18:36:49.365 +08:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 18:36:49.365 +08:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 18:36:49.365 +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/06 18:36:49.365 +08:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 18:36:49.365 +08:00] [INFO] [backend_mgr.go:309] ["close one backend for DDL job"] ["job ID"=20532] ["current memory usage"=33720] ["max memory quota"=17179869184]
[2024/05/06 18:36:49.365 +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=251.942394ms] []
[2024/05/06 18:36:49.552 +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/06 18:36:49.666 +08:00] [INFO] [manager.go:332] ["task executor exit"] [task-id=660015] [type=backfill]
[2024/05/06 18:36:49.852 +08:00] [INFO] [reorg.go:232] ["run reorg job done"] [category=ddl] ["handled rows"=1]
[2024/05/06 18:36:49.888 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20532] [conn=3428845956] [category=ddl] [job="ID:20532, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20499, TableID:20530, RowCount:1, ArgLen:0, start time: 2024-05-06 18:36:47.827 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449574812510322693, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 18:36:49.888 +08:00] [INFO] [index.go:880] ["index backfill state ready to merge"] [category=ddl] ["job ID"=20532] [table=t0] [index=i0]
[2024/05/06 18:36:49.916 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20532] [conn=3428845956] [category=ddl] [job="ID:20532, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20499, TableID:20530, RowCount:1, ArgLen:0, start time: 2024-05-06 18:36:47.827 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 18:36:49.917 +08:00] [INFO] [reorg.go:718] ["job get table range"] [category=ddl] [jobID=20532] [physicalTableID=20530] [startKey=7480000000000050325f69ffff000000000001] [endKey=7480000000000050325f69ffff000000000001ff]
[2024/05/06 18:36:49.944 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20532] [conn=3428845956] [category=ddl] [job="ID:20532, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20499, TableID:20530, RowCount:1, ArgLen:0, start time: 2024-05-06 18:36:47.827 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449574813008396300, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 18:36:49.946 +08:00] [INFO] [index.go:1928] ["start to merge temp index"] [category=ddl] [job="ID:20532, Type:add index, State:running, SchemaState:write reorganization, SchemaID:20499, TableID:20530, RowCount:1, ArgLen:6, start time: 2024-05-06 18:36:47.827 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449574813008396300, LocalMode: false, UniqueWarnings:0"] [reorgInfo="CurrElementType:_idx_,CurrElementID:1,StartKey:7480000000000050325f69ffff000000000001,EndKey:7480000000000050325f69ffff000000000001ff,First:false,PhysicalTableID:20530,Ingest mode:false"]
[2024/05/06 18:36:49.949 +08:00] [INFO] [backfilling.go:416] ["split table range from PD"] [category=ddl] [physicalTableID=20530] ["start key"=7480000000000050325f69ffff000000000001] ["end key"=7480000000000050325f69ffff000000000001ff]
[2024/05/06 18:36:49.949 +08:00] [INFO] [backfilling.go:692] ["start backfill workers to reorg record"] [category=ddl] [type="merge temporary index"] [workerCnt=4] [regionCnt=1] [startKey=7480000000000050325f69ffff000000000001] [endKey=7480000000000050325f69ffff000000000001ff]
[2024/05/06 18:36:49.949 +08:00] [INFO] [backfilling.go:475] ["get backfill range task, change end key"] [category=ddl] [id=1] [pTbl=20530] ["end key"=7480000000000050325f69ffff000000000001ff] ["current end key"=7480000000000050325f69ffff00000000000100]
[2024/05/06 18:36:49.950 +08:00] [INFO] [backfilling.go:369] ["backfill worker exit"] [category=ddl] [worker="backfill-worker 2, tp merge temporary index"] [jobID=20532]
[2024/05/06 18:36:49.950 +08:00] [INFO] [backfilling.go:369] ["backfill worker exit"] [category=ddl] [worker="backfill-worker 3, tp merge temporary index"] [jobID=20532]
[2024/05/06 18:36:49.950 +08:00] [INFO] [backfilling.go:369] ["backfill worker exit"] [category=ddl] [worker="backfill-worker 1, tp merge temporary index"] [jobID=20532]
[2024/05/06 18:36:49.950 +08:00] [INFO] [backfilling.go:330] ["backfill worker finish task"] [category=ddl] [worker="backfill-worker 0, tp merge temporary index"] [task="taskID: 1, physicalTableID: 20530, range: [7480000000000050325f69ffff000000000001, 7480000000000050325f69ffff00000000000100), jobID: 20532"] ["added count"=0] ["scan count"=0] ["next key"=7480000000000050325f69ffff0000000000010000] ["take time"=547.565µs]
[2024/05/06 18:36:49.950 +08:00] [INFO] [backfilling.go:369] ["backfill worker exit"] [category=ddl] [worker="backfill-worker 0, tp merge temporary index"] [jobID=20532]
[2024/05/06 18:36:49.950 +08:00] [INFO] [backfilling.go:632] ["backfill workers successfully processed"] [category=ddl] [element=ID:1,TypeKey:_idx_] ["total added count"=1] ["start key"=7480000000000050325f69ffff000000000001]
[2024/05/06 18:36:49.950 +08:00] [INFO] [reorg.go:232] ["run reorg job done"] [category=ddl] ["handled rows"=1]
[2024/05/06 18:36:49.956 +08:00] [INFO] [index.go:781] ["run add index job done"] [category=ddl] [charset=utf8mb4] [collation=utf8mb4_general_ci]
[2024/05/06 18:36:49.984 +08:00] [INFO] [delete_range.go:422] ["insert into delete-range indices"] [category=ddl] [jobID=20532] [tableID=20530] [indexIDs="[9223090561878065153]"] [comment="add index: physical table ID(s)"]
[2024/05/06 18:36:49.986 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20532] [jobType="add index"]
[2024/05/06 18:36:49.987 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20532] [conn=3428845956] [job="ID:20532, Type:add index, State:synced, SchemaState:public, SchemaID:20499, TableID:20530, RowCount:1, ArgLen:3, start time: 2024-05-06 18:36:47.827 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449574813008396300, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 18:36:49.992 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20532]
[2024/05/06 18:36:49.992 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:49.995 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24658] [neededSchemaVersion=24664] ["start time"=1.901385ms] [gotSchemaVersion=24664] [phyTblIDs="[20530,20530,20530,20530,20530,20530]"] [actionTypes="[7,7,7,7,7,7]"] [diffTypes="[\"add index\",\"add index\",\"add index\",\"add index\",\"add index\",\"add index\"]"]
[2024/05/06 18:36:49.996 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t0;"]
[2024/05/06 18:36:50.025 +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/06 18:36:50.001 +08:00] ["end time"=2024/05/06 18:36:50.023 +08:00] [cost=22.374108ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/06 18:36:50.040 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="explain format = 'brief' select * from t0 where c0;"]
[2024/05/06 18:36:50.040 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [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/06 18:36:50.041 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [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/06 18:36:50.041 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [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/06 18:36:50.042 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [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/06 18:36:50.042 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [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/06 18:36:50.043 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [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/06 18:36:50.043 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_cost_model_version`=DEFAULT"]
[2024/05/06 18:36:50.043 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24664] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_cost_model_version`=2"]
[2024/05/06 18:36:50.043 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24664] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/05/06 18:36:50.049 +08:00] [INFO] [scheduler_manager.go:364] ["task scheduler exist"] [task-id=660015]
[2024/05/06 18:36:50.051 +08:00] [INFO] [scheduler_manager.go:410] ["cleanup routine start"]
[2024/05/06 18:36:50.051 +08:00] [INFO] [scheduler_manager.go:426] ["cleanup task"] [task-id=660015]
[2024/05/06 18:36:50.056 +08:00] [INFO] [scheduler_manager.go:419] ["cleanup routine success"]
[2024/05/06 18:36:50.056 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20533, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20528, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:50.027 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:50.057 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20533, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20528, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:50.027 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/05/06 18:36:50.080 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20533] [conn=3428845956] [category=ddl] [job="ID:20533, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20528, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.027 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.102 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20533] [conn=3428845956] [category=ddl] [job="ID:20533, Type:drop table, State:running, SchemaState:write only, SchemaID:20499, TableID:20528, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.027 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.125 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20533] [conn=3428845956] [category=ddl] [job="ID:20533, Type:drop table, State:running, SchemaState:delete only, SchemaID:20499, TableID:20528, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.027 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.145 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20533] [tableIDs="[20528]"] [comment="drop table: table ID"]
[2024/05/06 18:36:50.148 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20533] [jobType="drop table"]
[2024/05/06 18:36:50.148 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20533] [conn=3428845956] [job="ID:20533, Type:drop table, State:synced, SchemaState:none, SchemaID:20499, TableID:20528, RowCount:0, ArgLen:3, start time: 2024-05-06 18:36:50.027 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.152 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20533]
[2024/05/06 18:36:50.152 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:50.153 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24664] [neededSchemaVersion=24667] ["start time"=533.175µs] [gotSchemaVersion=24667] [phyTblIDs="[20528]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/06 18:36:50.154 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24667] [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/06 18:36:50.169 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20535, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20534, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:50.127 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:50.169 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20535, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20534, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:50.127 +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/06 18:36:50.198 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20535] [conn=3428845956] [category=ddl] [job="ID:20535, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20534, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.127 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.220 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20535] [conn=3428845956] [job="ID:20535, Type:create table, State:synced, SchemaState:public, SchemaID:20499, TableID:20534, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.127 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.224 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20535]
[2024/05/06 18:36:50.224 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:50.224 +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"=748000000000005036]
[2024/05/06 18:36:50.225 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005036] ["first new region left"="{Id:16806 StartKey:7480000000000050ff325f698000000000ff0000010131000000ff00000000f8038000ff0000000000010000fe EndKey:7480000000000050ff3600000000000000f8 RegionEpoch:{ConfVer:1 Version:8058} Peers:[id:16807 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/06 18:36:50.225 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16806]"]
[2024/05/06 18:36:50.226 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24667] [neededSchemaVersion=24668] ["start time"=775.065µs] [gotSchemaVersion=24668] [phyTblIDs="[20534]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 18:36:50.227 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24668] [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/06 18:36:50.228 +08:00] [WARN] [prewrite.go:382] ["1pc failed and fallbacks to normal commit procedure"] [conn=3428845956] [session_alias=] [startTS=449574813100146689]
[2024/05/06 18:36:50.230 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24668] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t;"]
[2024/05/06 18:36:50.276 +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/06 18:36:50.234 +08:00] ["end time"=2024/05/06 18:36:50.275 +08:00] [cost=40.220316ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/06 18:36:50.300 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24668] [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/06 18:36:50.301 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24668] [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/06 18:36:50.304 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24668] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_cost_model_version`=DEFAULT"]
[2024/05/06 18:36:50.304 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24668] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/05/06 18:36:50.318 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20536, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20534, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:50.277 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:50.318 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20536, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20534, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:50.277 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/05/06 18:36:50.342 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20536] [conn=3428845956] [category=ddl] [job="ID:20536, Type:drop table, State:queueing, SchemaState:public, SchemaID:20499, TableID:20534, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.277 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.363 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20536] [conn=3428845956] [category=ddl] [job="ID:20536, Type:drop table, State:running, SchemaState:write only, SchemaID:20499, TableID:20534, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.277 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.384 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20536] [conn=3428845956] [category=ddl] [job="ID:20536, Type:drop table, State:running, SchemaState:delete only, SchemaID:20499, TableID:20534, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.277 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.406 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20536] [tableIDs="[20534]"] [comment="drop table: table ID"]
[2024/05/06 18:36:50.408 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20536] [jobType="drop table"]
[2024/05/06 18:36:50.408 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20536] [conn=3428845956] [job="ID:20536, Type:drop table, State:synced, SchemaState:none, SchemaID:20499, TableID:20534, RowCount:0, ArgLen:3, start time: 2024-05-06 18:36:50.277 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.412 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20536]
[2024/05/06 18:36:50.412 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:50.414 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24668] [neededSchemaVersion=24671] ["start time"=493.723µs] [gotSchemaVersion=24671] [phyTblIDs="[20534]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/06 18:36:50.415 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845956] [schemaVersion=24671] [cur_db=util__ranger] [sql="create table t(a int not null, b int not null, primary key(a,b));"] [user=root@%]
[2024/05/06 18:36:50.430 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20538, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20537, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:50.377 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:50.430 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20538, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20537, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:50.377 +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/06 18:36:50.457 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20538] [conn=3428845956] [category=ddl] [job="ID:20538, Type:create table, State:queueing, SchemaState:none, SchemaID:20499, TableID:20537, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.377 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.478 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20538] [conn=3428845956] [job="ID:20538, Type:create table, State:synced, SchemaState:public, SchemaID:20499, TableID:20537, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.377 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.482 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20538]
[2024/05/06 18:36:50.482 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:50.482 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=14] ["first split key"=748000000000005039]
[2024/05/06 18:36:50.483 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005039] ["first new region left"="{Id:16808 StartKey:7480000000000050ff3600000000000000f8 EndKey:7480000000000050ff3900000000000000f8 RegionEpoch:{ConfVer:1 Version:8059} Peers:[id:16809 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/06 18:36:50.483 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16808]"]
[2024/05/06 18:36:50.484 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24671] [neededSchemaVersion=24672] ["start time"=617.312µs] [gotSchemaVersion=24672] [phyTblIDs="[20537]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 18:36:50.485 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24672] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t values(1,2);"]
[2024/05/06 18:36:50.488 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24672] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=util__ranger] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t;"]
[2024/05/06 18:36:50.519 +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/06 18:36:50.492 +08:00] ["end time"=2024/05/06 18:36:50.517 +08:00] [cost=24.472935ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/06 18:36:50.533 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24672] [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/06 18:36:50.534 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845956] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24672] [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/06 18:36:50.535 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845960] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24672] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="use `test`"]
[2024/05/06 18:36:50.535 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845960] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24672] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`time_zone`=_UTF8MB4'Asia/Shanghai'"]
[2024/05/06 18:36:50.536 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845960] [schemaVersion=24672] [cur_db=test] [sql="drop database `util__ranger`"] [user=root@%]
[2024/05/06 18:36:50.549 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20539, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20499, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 18:36:50.527 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:50.549 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20539, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20499, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 18:36:50.527 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop database `util__ranger`"]
[2024/05/06 18:36:50.571 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20539] [conn=3428845960] [category=ddl] [job="ID:20539, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20499, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.527 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.595 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20539] [conn=3428845960] [category=ddl] [job="ID:20539, Type:drop schema, State:running, SchemaState:write only, SchemaID:20499, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.527 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.618 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20539] [conn=3428845960] [category=ddl] [job="ID:20539, Type:drop schema, State:running, SchemaState:delete only, SchemaID:20499, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.527 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.639 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20539] [tableIDs="[20503,20505,20516,20530,20537]"] [comment="drop schema: table IDs"]
[2024/05/06 18:36:50.641 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20539] [jobType="drop schema"]
[2024/05/06 18:36:50.642 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20539] [conn=3428845960] [job="ID:20539, Type:drop schema, State:synced, SchemaState:none, SchemaID:20499, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 18:36:50.527 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.645 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20539]
[2024/05/06 18:36:50.645 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:50.646 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24672] [neededSchemaVersion=24675] ["start time"=412.231µs] [gotSchemaVersion=24675] [phyTblIDs="[20503,20505,20516,20530,20537]"] [actionTypes="[2,2,2,2,2]"] [diffTypes="[\"drop schema\",\"drop schema\",\"drop schema\"]"]
[2024/05/06 18:36:50.648 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845962] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24675] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="use `test`"]
[2024/05/06 18:36:50.648 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845962] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24675] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`time_zone`=_UTF8MB4'Asia/Shanghai'"]
[2024/05/06 18:36:50.649 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845962] [schemaVersion=24675] [cur_db=test] [sql="create database `window_function`"] [user=root@%]
[2024/05/06 18:36:50.662 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20541, Type:create schema, State:queueing, SchemaState:none, SchemaID:20540, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 18:36:50.627 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:50.662 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20541, Type:create schema, State:queueing, SchemaState:none, SchemaID:20540, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 18:36:50.627 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create database `window_function`"]
[2024/05/06 18:36:50.692 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20541] [conn=3428845962] [category=ddl] [job="ID:20541, Type:create schema, State:queueing, SchemaState:none, SchemaID:20540, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.627 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.714 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20541] [conn=3428845962] [job="ID:20541, Type:create schema, State:synced, SchemaState:public, SchemaID:20540, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.627 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.717 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20541]
[2024/05/06 18:36:50.717 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:50.718 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24675] [neededSchemaVersion=24676] ["start time"=238.771µs] [gotSchemaVersion=24676] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"create schema\"]"]
[2024/05/06 18:36:50.720 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [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/06 18:36:50.720 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [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/06 18:36:50.720 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845966] [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/06 18:36:50.720 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845966] [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/06 18:36:50.721 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845966] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24676] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SELECT tidb_version()"]
[2024/05/06 18:36:50.721 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [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.`tidb_init_chunk_size`=1"]
[2024/05/06 18:36:50.721 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [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.`tidb_max_chunk_size`=32"]
[2024/05/06 18:36:50.721 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [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.`tidb_multi_statement_mode`=1"]
[2024/05/06 18:36:50.721 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [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.`tidb_hash_join_concurrency`=1"]
[2024/05/06 18:36:50.721 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [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.`tidb_enable_pseudo_for_outdated_stats`=FALSE"]
[2024/05/06 18:36:50.722 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [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.`tidb_enable_analyze_snapshot`=1"]
[2024/05/06 18:36:50.722 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [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.`tidb_enable_clustered_index`=_UTF8MB4'int_only'"]
[2024/05/06 18:36:50.722 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24676] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="use `window_function`"]
[2024/05/06 18:36:50.722 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24676] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`tidb_cost_model_version`=1"]
[2024/05/06 18:36:50.722 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845964] [schemaVersion=24676] [cur_db=window_function] [sql="drop table if exists t;"] [user=root@%]
[2024/05/06 18:36:50.723 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845964] [schemaVersion=24676] [cur_db=window_function] [sql="create table t (a int, b int, c timestamp, index idx(a));"] [user=root@%]
[2024/05/06 18:36:50.737 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20543, Type:create table, State:queueing, SchemaState:none, SchemaID:20540, TableID:20542, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:50.727 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:50.737 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20543, Type:create table, State:queueing, SchemaState:none, SchemaID:20540, TableID:20542, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:50.727 +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/06 18:36:50.765 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20543] [conn=3428845964] [category=ddl] [job="ID:20543, Type:create table, State:queueing, SchemaState:none, SchemaID:20540, TableID:20542, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.727 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.790 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20543] [conn=3428845964] [job="ID:20543, Type:create table, State:synced, SchemaState:public, SchemaID:20540, TableID:20542, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.727 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.794 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20543]
[2024/05/06 18:36:50.794 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:50.794 +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"=74800000000000503e]
[2024/05/06 18:36:50.795 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=74800000000000503e] ["first new region left"="{Id:16810 StartKey:7480000000000050ff3900000000000000f8 EndKey:7480000000000050ff3e00000000000000f8 RegionEpoch:{ConfVer:1 Version:8060} Peers:[id:16811 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/06 18:36:50.795 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16810]"]
[2024/05/06 18:36:50.795 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24676] [neededSchemaVersion=24677] ["start time"=644.472µs] [gotSchemaVersion=24677] [phyTblIDs="[20542]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 18:36:50.796 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [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_enable_window_function`=1"]
[2024/05/06 18:36:50.796 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [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_window_concurrency`=1"]
[2024/05/06 18:36:50.797 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [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/06 18:36:50.797 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [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/06 18:36:50.798 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [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/06 18:36:50.798 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [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/06 18:36:50.799 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [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/06 18:36:50.799 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [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/06 18:36:50.800 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [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/06 18:36:50.800 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [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_window_concurrency`=4"]
[2024/05/06 18:36:50.800 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [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/06 18:36:50.801 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [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/06 18:36:50.801 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [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/06 18:36:50.802 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [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/06 18:36:50.802 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [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/06 18:36:50.803 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [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/06 18:36:50.803 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24677] [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/06 18:36:50.804 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845964] [schemaVersion=24677] [cur_db=window_function] [sql="drop table if exists t1;"] [user=root@%]
[2024/05/06 18:36:50.804 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845964] [schemaVersion=24677] [cur_db=window_function] [sql="create table t1(a int primary key, b int);"] [user=root@%]
[2024/05/06 18:36:50.820 +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:20540, TableID:20544, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:50.777 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:50.820 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20545, Type:create table, State:queueing, SchemaState:none, SchemaID:20540, TableID:20544, RowCount:0, ArgLen:2, start time: 2024-05-06 18:36:50.777 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table t1(a int primary key, b int);"]
[2024/05/06 18:36:50.845 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20545] [conn=3428845964] [category=ddl] [job="ID:20545, Type:create table, State:queueing, SchemaState:none, SchemaID:20540, TableID:20544, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.777 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.866 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20545] [conn=3428845964] [job="ID:20545, Type:create table, State:synced, SchemaState:public, SchemaID:20540, TableID:20544, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.777 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:50.870 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20545]
[2024/05/06 18:36:50.870 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:50.870 +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/06 18:36:50.871 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24677] [neededSchemaVersion=24678] ["start time"=513.485µs] [gotSchemaVersion=24678] [phyTblIDs="[20544]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 18:36:50.872 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t1 values(1, 1), (2, 1);"]
[2024/05/06 18:36:50.873 +08:00] [WARN] [prewrite.go:382] ["1pc failed and fallbacks to normal commit procedure"] [conn=3428845964] [session_alias=] [startTS=449574813257433114]
[2024/05/06 18:36:50.873 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=14] ["first at"=748000000000005040] ["first new region left"="{Id:16812 StartKey:7480000000000050ff3e00000000000000f8 EndKey:7480000000000050ff4000000000000000f8 RegionEpoch:{ConfVer:1 Version:8061} Peers:[id:16813 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/06 18:36:50.873 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16812]"]
[2024/05/06 18:36:50.875 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t1;"]
[2024/05/06 18:36:50.899 +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/06 18:36:50.879 +08:00] ["end time"=2024/05/06 18:36:50.897 +08:00] [cost=18.486617ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/06 18:36:50.911 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [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 b) from t1;"]
[2024/05/06 18:36:50.911 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="insert into t1 values(3, 3);"]
[2024/05/06 18:36:50.912 +08:00] [WARN] [prewrite.go:382] ["1pc failed and fallbacks to normal commit procedure"] [conn=3428845964] [session_alias=] [startTS=449574813270540319]
[2024/05/06 18:36:50.913 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=window_function] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="analyze table t1;"]
[2024/05/06 18:36:50.919 +08:00] [INFO] [save.go:200] ["incrementally update modifyCount"] [category=stats] [tableID=20544] [curModifyCnt=0] [results.BaseModifyCnt=0] [modifyCount=0]
[2024/05/06 18:36:50.919 +08:00] [INFO] [save.go:211] ["incrementally update count"] [category=stats] [tableID=20544] [curCnt=2] [results.Count=3] [results.BaseCount=2] [count=3]
[2024/05/06 18:36:50.936 +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/06 18:36:50.915 +08:00] ["end time"=2024/05/06 18:36:50.935 +08:00] [cost=19.382896ms] ["sample rate reason"="use min(1, 110000/2) as the sample-rate=1"]
[2024/05/06 18:36:50.945 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845964] [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 b) from t1;"]
[2024/05/06 18:36:50.946 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845968] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="use `test`"]
[2024/05/06 18:36:50.947 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3428845968] [session_alias=] [user=root@127.0.0.1] [schemaVersion=24678] [txnStartTS=0] [forUpdateTS=0] [isReadConsistency=false] [currentDB=test] [isPessimistic=false] [sessionTxnMode=PESSIMISTIC] [sql="SET @@SESSION.`time_zone`=_UTF8MB4'Asia/Shanghai'"]
[2024/05/06 18:36:50.947 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3428845968] [schemaVersion=24678] [cur_db=test] [sql="drop database `window_function`"] [user=root@%]
[2024/05/06 18:36:50.964 +08:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20546, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20540, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 18:36:50.927 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 18:36:50.964 +08:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:20546, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20540, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 18:36:50.927 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop database `window_function`"]
[2024/05/06 18:36:50.988 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20546] [conn=3428845968] [category=ddl] [job="ID:20546, Type:drop schema, State:queueing, SchemaState:public, SchemaID:20540, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.927 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:51.011 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20546] [conn=3428845968] [category=ddl] [job="ID:20546, Type:drop schema, State:running, SchemaState:write only, SchemaID:20540, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.927 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:51.031 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20546] [conn=3428845968] [category=ddl] [job="ID:20546, Type:drop schema, State:running, SchemaState:delete only, SchemaID:20540, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 18:36:50.927 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:51.053 +08:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=20546] [tableIDs="[20542,20544]"] [comment="drop schema: table IDs"]
[2024/05/06 18:36:51.055 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20546] [jobType="drop schema"]
[2024/05/06 18:36:51.055 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20546] [conn=3428845968] [job="ID:20546, Type:drop schema, State:synced, SchemaState:none, SchemaID:20540, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 18:36:50.927 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 18:36:51.059 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20546]
[2024/05/06 18:36:51.059 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 18:36:51.061 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24678] [neededSchemaVersion=24681] ["start time"=521.682µs] [gotSchemaVersion=24681] [phyTblIDs="[20542,20544]"] [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