Skipping 11,885 KB.. Full Log

[2024/05/06 08:34:42.345 +08:00] [INFO] [peer.rs:6130] ["on split"] [source=ipv4:127.0.0.1:57608] [split_keys="key 7480000000000050FF3600000000000000F8"] [peer_id=23] [region_id=22] [thread_id=102]
[2024/05/06 08:34:42.345 +08:00] [INFO] [pd.rs:1031] ["try to batch split region"] [task=batch_split] [region="id: 22 start_key: 7480000000000050FF325F698000000000FF0000010131000000FF00000000F8038000FF0000000000010000FE end_key: 748000FFFFFFFFFFFFF900000000000000F8 region_epoch { conf_ver: 1 version: 8084 } peers { id: 23 store_id: 1 }"] [new_region_ids="[new_region_id: 16674 new_peer_ids: 16675]"] [region_id=22] [thread_id=31]
[2024/05/06 08:34:42.345 +08:00] [INFO] [apply.rs:1712] ["execute admin command"] [command="cmd_type: BatchSplit splits { requests { split_key: 7480000000000050FF3600000000000000F8 new_region_id: 16674 new_peer_ids: 16675 } right_derive: true }"] [index=20842] [term=6] [peer_id=23] [region_id=22] [thread_id=103]
[2024/05/06 08:34:42.345 +08:00] [INFO] [apply.rs:2578] ["split region"] [keys="key 7480000000000050FF3600000000000000F8"] [region="id: 22 start_key: 7480000000000050FF325F698000000000FF0000010131000000FF00000000F8038000FF0000000000010000FE end_key: 748000FFFFFFFFFFFFF900000000000000F8 region_epoch { conf_ver: 1 version: 8084 } peers { id: 23 store_id: 1 }"] [peer_id=23] [region_id=22] [thread_id=103]
[2024/05/06 08:34:42.345 +08:00] [INFO] [endpoint.rs:279] ["region met split/merge command, stop tracking since key range changed, wait for re-register"] [req_type=BatchSplit] [thread_id=68]
[2024/05/06 08:34:42.346 +08:00] [INFO] [peer.rs:4250] ["moving 0 locks to new regions"] [region_id=22] [thread_id=102]
[2024/05/06 08:34:42.346 +08:00] [INFO] [peer.rs:4296] ["notify pd with split"] [split_count=2] [peer_id=23] [region_id=22] [thread_id=102]
[2024/05/06 08:34:42.346 +08:00] [INFO] [endpoint.rs:748] ["deregister observe region"] [observe_id=ObserveId(16185)] [region_id=22] [store_id=Some(1)] [thread_id=68]
[2024/05/06 08:34:42.346 +08:00] [INFO] [endpoint.rs:701] ["register observe region"] [region="id: 22 start_key: 7480000000000050FF3600000000000000F8 end_key: 748000FFFFFFFFFFFFF900000000000000F8 region_epoch { conf_ver: 1 version: 8085 } peers { id: 23 store_id: 1 }"] [thread_id=68]
[2024/05/06 08:34:42.346 +08:00] [INFO] [peer.rs:4378] ["insert new region"] [store_id=1] [is_uninitialized_peer_exist=false] [region="id: 16674 start_key: 7480000000000050FF325F698000000000FF0000010131000000FF00000000F8038000FF0000000000010000FE end_key: 7480000000000050FF3600000000000000F8 region_epoch { conf_ver: 1 version: 8085 } peers { id: 16675 store_id: 1 }"] [region_id=16674] [thread_id=102]
[2024/05/06 08:34:42.346 +08:00] [INFO] [peer.rs:275] ["create peer"] [peer_id=16675] [region_id=16674] [thread_id=102]
[2024/05/06 08:34:42.346 +08:00] [INFO] [raft.rs:2684] ["switched to configuration"] [config="Configuration { voters: Configuration { incoming: Configuration { voters: {16675} }, outgoing: Configuration { voters: {} } }, learners: {}, learners_next: {}, auto_leave: false }"] [raft_id=16675] [region_id=16674] [thread_id=102]
[2024/05/06 08:34:42.346 +08:00] [INFO] [raft.rs:1151] ["became follower at term 5"] [term=5] [raft_id=16675] [region_id=16674] [thread_id=102]
[2024/05/06 08:34:42.346 +08:00] [INFO] [raft.rs:387] [newRaft] [peers="Configuration { incoming: Configuration { voters: {16675} }, outgoing: Configuration { voters: {} } }"] ["last term"=5] ["last index"=5] [applied=5] [commit=5] [term=5] [raft_id=16675] [region_id=16674] [thread_id=102]
[2024/05/06 08:34:42.346 +08:00] [INFO] [raw_node.rs:315] ["RawNode created with id 16675."] [id=16675] [raft_id=16675] [region_id=16674] [thread_id=102]
[2024/05/06 08:34:42.346 +08:00] [INFO] [raft.rs:1556] ["starting a new election"] [term=5] [raft_id=16675] [region_id=16674] [thread_id=102]
[2024/05/06 08:34:42.346 +08:00] [INFO] [raft.rs:1201] ["became pre-candidate at term 5"] [term=5] [raft_id=16675] [region_id=16674] [thread_id=102]
[2024/05/06 08:34:42.346 +08:00] [INFO] [raft.rs:1175] ["became candidate at term 6"] [term=6] [raft_id=16675] [region_id=16674] [thread_id=102]
[2024/05/06 08:34:42.346 +08:00] [INFO] [raft.rs:1259] ["became leader at term 6"] [term=6] [raft_id=16675] [region_id=16674] [thread_id=102]
[2024/05/06 08:34:42.346 +08:00] [INFO] [peer.rs:5712] ["require updating max ts"] [initial_status=25769819946] [region_id=16674] [thread_id=101]
[2024/05/06 08:34:42.346 +08:00] [INFO] [endpoint.rs:358] ["Resolver initialized"] [pending_data_index=0] [snapshot_index=20842] [observe_id=ObserveId(16188)] [region=22] [thread_id=68]
[2024/05/06 08:34:42.346 +08:00] [INFO] [endpoint.rs:701] ["register observe region"] [region="id: 16674 start_key: 7480000000000050FF325F698000000000FF0000010131000000FF00000000F8038000FF0000000000010000FE end_key: 7480000000000050FF3600000000000000F8 region_epoch { conf_ver: 1 version: 8085 } peers { id: 16675 store_id: 1 }"] [thread_id=68]
[2024/05/06 08:34:42.346 +08:00] [INFO] [pd.rs:1705] ["succeed to update max timestamp"] [region_id=16674] [thread_id=31]
[2024/05/06 08:34:42.346 +08:00] [INFO] [endpoint.rs:358] ["Resolver initialized"] [pending_data_index=0] [snapshot_index=6] [observe_id=ObserveId(16189)] [region=16674] [thread_id=68]
[2024/05/06 08:34:42.347 +08:00] [INFO] [scheduler.rs:769] ["get snapshot failed"] [err="Error(Request(message: \"EpochNotMatch current epoch of region 22 is conf_ver: 1 version: 8085, but you sent conf_ver: 1 version: 8084\" epoch_not_match { current_regions { id: 22 start_key: 7480000000000050FF3600000000000000F8 end_key: 748000FFFFFFFFFFFFF900000000000000F8 region_epoch { conf_ver: 1 version: 8085 } peers { id: 23 store_id: 1 } } current_regions { id: 16674 start_key: 7480000000000050FF325F698000000000FF0000010131000000FF00000000F8038000FF0000000000010000FE end_key: 7480000000000050FF3600000000000000F8 region_epoch { conf_ver: 1 version: 8085 } peers { id: 16675 store_id: 1 } } }))"] [cid=552141] [thread_id=63]
[2024/05/06 08:34:42.348 +08:00] [WARN] [prewrite.rs:832] ["commit_ts is too large, fallback to normal 2PC"] [lock="Lock { lock_type: Put, primary_key: 7480000000000050365F698000000000000001038000000000000001038000000000000001038000000000000001038000000000000001, start_ts: TimeStamp(449565342380851221), ttl: 3000, short_value: 30, for_update_ts: TimeStamp(0), txn_size: 4, min_commit_ts: TimeStamp(449565342380851222), use_async_commit: true, secondaries: [7480000000000050365F698000000000000001038000000000000001038000000000000002038000000000000001038000000000000002, 7480000000000050365F728000000000000001, 7480000000000050365F728000000000000002], rollback_ts: [], last_change: Unknown, txn_source: 0, is_locked_with_conflict: false, generation: 0 }"] [max_commit_ts=449565342380851221] [min_commit_ts=449565342380851222] [start_ts=449565342380851221] [key=7480000000000050FF365F698000000000FF0000010380000000FF0000000103800000FF0000000001038000FF0000000000010380FF0000000000000100FE] [thread_id=62]
[2024/05/06 08:34:42.584 +08:00] [INFO] [peer.rs:6130] ["on split"] [source=ipv4:127.0.0.1:57606] [split_keys="key 7480000000000050FF3900000000000000F8"] [peer_id=23] [region_id=22] [thread_id=102]
[2024/05/06 08:34:42.585 +08:00] [INFO] [pd.rs:1031] ["try to batch split region"] [task=batch_split] [region="id: 22 start_key: 7480000000000050FF3600000000000000F8 end_key: 748000FFFFFFFFFFFFF900000000000000F8 region_epoch { conf_ver: 1 version: 8085 } peers { id: 23 store_id: 1 }"] [new_region_ids="[new_region_id: 16676 new_peer_ids: 16677]"] [region_id=22] [thread_id=31]
[2024/05/06 08:34:42.585 +08:00] [INFO] [apply.rs:1712] ["execute admin command"] [command="cmd_type: BatchSplit splits { requests { split_key: 7480000000000050FF3900000000000000F8 new_region_id: 16676 new_peer_ids: 16677 } right_derive: true }"] [index=20845] [term=6] [peer_id=23] [region_id=22] [thread_id=103]
[2024/05/06 08:34:42.585 +08:00] [INFO] [apply.rs:2578] ["split region"] [keys="key 7480000000000050FF3900000000000000F8"] [region="id: 22 start_key: 7480000000000050FF3600000000000000F8 end_key: 748000FFFFFFFFFFFFF900000000000000F8 region_epoch { conf_ver: 1 version: 8085 } peers { id: 23 store_id: 1 }"] [peer_id=23] [region_id=22] [thread_id=103]
[2024/05/06 08:34:42.585 +08:00] [INFO] [endpoint.rs:279] ["region met split/merge command, stop tracking since key range changed, wait for re-register"] [req_type=BatchSplit] [thread_id=68]
[2024/05/06 08:34:42.585 +08:00] [INFO] [peer.rs:4250] ["moving 0 locks to new regions"] [region_id=22] [thread_id=101]
[2024/05/06 08:34:42.585 +08:00] [INFO] [peer.rs:4296] ["notify pd with split"] [split_count=2] [peer_id=23] [region_id=22] [thread_id=101]
[2024/05/06 08:34:42.585 +08:00] [INFO] [endpoint.rs:748] ["deregister observe region"] [observe_id=ObserveId(16188)] [region_id=22] [store_id=Some(1)] [thread_id=68]
[2024/05/06 08:34:42.585 +08:00] [INFO] [endpoint.rs:701] ["register observe region"] [region="id: 22 start_key: 7480000000000050FF3900000000000000F8 end_key: 748000FFFFFFFFFFFFF900000000000000F8 region_epoch { conf_ver: 1 version: 8086 } peers { id: 23 store_id: 1 }"] [thread_id=68]
[2024/05/06 08:34:42.585 +08:00] [INFO] [peer.rs:4378] ["insert new region"] [store_id=1] [is_uninitialized_peer_exist=false] [region="id: 16676 start_key: 7480000000000050FF3600000000000000F8 end_key: 7480000000000050FF3900000000000000F8 region_epoch { conf_ver: 1 version: 8086 } peers { id: 16677 store_id: 1 }"] [region_id=16676] [thread_id=101]
[2024/05/06 08:34:42.585 +08:00] [INFO] [peer.rs:275] ["create peer"] [peer_id=16677] [region_id=16676] [thread_id=101]
[2024/05/06 08:34:42.585 +08:00] [INFO] [raft.rs:2684] ["switched to configuration"] [config="Configuration { voters: Configuration { incoming: Configuration { voters: {16677} }, outgoing: Configuration { voters: {} } }, learners: {}, learners_next: {}, auto_leave: false }"] [raft_id=16677] [region_id=16676] [thread_id=101]
[2024/05/06 08:34:42.585 +08:00] [INFO] [raft.rs:1151] ["became follower at term 5"] [term=5] [raft_id=16677] [region_id=16676] [thread_id=101]
[2024/05/06 08:34:42.585 +08:00] [INFO] [raft.rs:387] [newRaft] [peers="Configuration { incoming: Configuration { voters: {16677} }, outgoing: Configuration { voters: {} } }"] ["last term"=5] ["last index"=5] [applied=5] [commit=5] [term=5] [raft_id=16677] [region_id=16676] [thread_id=101]
[2024/05/06 08:34:42.585 +08:00] [INFO] [raw_node.rs:315] ["RawNode created with id 16677."] [id=16677] [raft_id=16677] [region_id=16676] [thread_id=101]
[2024/05/06 08:34:42.585 +08:00] [INFO] [raft.rs:1556] ["starting a new election"] [term=5] [raft_id=16677] [region_id=16676] [thread_id=101]
[2024/05/06 08:34:42.585 +08:00] [INFO] [raft.rs:1201] ["became pre-candidate at term 5"] [term=5] [raft_id=16677] [region_id=16676] [thread_id=101]
[2024/05/06 08:34:42.585 +08:00] [INFO] [raft.rs:1175] ["became candidate at term 6"] [term=6] [raft_id=16677] [region_id=16676] [thread_id=101]
[2024/05/06 08:34:42.585 +08:00] [INFO] [raft.rs:1259] ["became leader at term 6"] [term=6] [raft_id=16677] [region_id=16676] [thread_id=101]
[2024/05/06 08:34:42.585 +08:00] [INFO] [peer.rs:5712] ["require updating max ts"] [initial_status=25769819948] [region_id=16676] [thread_id=102]
[2024/05/06 08:34:42.585 +08:00] [INFO] [endpoint.rs:358] ["Resolver initialized"] [pending_data_index=0] [snapshot_index=20845] [observe_id=ObserveId(16190)] [region=22] [thread_id=68]
[2024/05/06 08:34:42.586 +08:00] [INFO] [endpoint.rs:701] ["register observe region"] [region="id: 16676 start_key: 7480000000000050FF3600000000000000F8 end_key: 7480000000000050FF3900000000000000F8 region_epoch { conf_ver: 1 version: 8086 } peers { id: 16677 store_id: 1 }"] [thread_id=68]
[2024/05/06 08:34:42.586 +08:00] [INFO] [endpoint.rs:358] ["Resolver initialized"] [pending_data_index=0] [snapshot_index=6] [observe_id=ObserveId(16191)] [region=16676] [thread_id=68]
[2024/05/06 08:34:42.586 +08:00] [INFO] [pd.rs:1705] ["succeed to update max timestamp"] [region_id=16676] [thread_id=31]
[2024/05/06 08:34:42.588 +08:00] [INFO] [scheduler.rs:769] ["get snapshot failed"] [err="Error(Request(message: \"EpochNotMatch current epoch of region 22 is conf_ver: 1 version: 8086, but you sent conf_ver: 1 version: 8085\" epoch_not_match { current_regions { id: 22 start_key: 7480000000000050FF3900000000000000F8 end_key: 748000FFFFFFFFFFFFF900000000000000F8 region_epoch { conf_ver: 1 version: 8086 } peers { id: 23 store_id: 1 } } current_regions { id: 16676 start_key: 7480000000000050FF3600000000000000F8 end_key: 7480000000000050FF3900000000000000F8 region_epoch { conf_ver: 1 version: 8086 } peers { id: 16677 store_id: 1 } } }))"] [cid=552263] [thread_id=60]
[2024/05/06 08:34:42.860 +08:00] [INFO] [peer.rs:6130] ["on split"] [source=ipv4:127.0.0.1:57606] [split_keys="key 7480000000000050FF3E00000000000000F8"] [peer_id=23] [region_id=22] [thread_id=101]
[2024/05/06 08:34:42.861 +08:00] [INFO] [pd.rs:1031] ["try to batch split region"] [task=batch_split] [region="id: 22 start_key: 7480000000000050FF3900000000000000F8 end_key: 748000FFFFFFFFFFFFF900000000000000F8 region_epoch { conf_ver: 1 version: 8086 } peers { id: 23 store_id: 1 }"] [new_region_ids="[new_region_id: 16678 new_peer_ids: 16679]"] [region_id=22] [thread_id=31]
[2024/05/06 08:34:42.861 +08:00] [INFO] [apply.rs:1712] ["execute admin command"] [command="cmd_type: BatchSplit splits { requests { split_key: 7480000000000050FF3E00000000000000F8 new_region_id: 16678 new_peer_ids: 16679 } right_derive: true }"] [index=20847] [term=6] [peer_id=23] [region_id=22] [thread_id=104]
[2024/05/06 08:34:42.861 +08:00] [INFO] [apply.rs:2578] ["split region"] [keys="key 7480000000000050FF3E00000000000000F8"] [region="id: 22 start_key: 7480000000000050FF3900000000000000F8 end_key: 748000FFFFFFFFFFFFF900000000000000F8 region_epoch { conf_ver: 1 version: 8086 } peers { id: 23 store_id: 1 }"] [peer_id=23] [region_id=22] [thread_id=104]
[2024/05/06 08:34:42.861 +08:00] [INFO] [endpoint.rs:279] ["region met split/merge command, stop tracking since key range changed, wait for re-register"] [req_type=BatchSplit] [thread_id=68]
[2024/05/06 08:34:42.861 +08:00] [INFO] [peer.rs:4250] ["moving 0 locks to new regions"] [region_id=22] [thread_id=102]
[2024/05/06 08:34:42.861 +08:00] [INFO] [peer.rs:4296] ["notify pd with split"] [split_count=2] [peer_id=23] [region_id=22] [thread_id=102]
[2024/05/06 08:34:42.861 +08:00] [INFO] [endpoint.rs:748] ["deregister observe region"] [observe_id=ObserveId(16190)] [region_id=22] [store_id=Some(1)] [thread_id=68]
[2024/05/06 08:34:42.861 +08:00] [INFO] [endpoint.rs:701] ["register observe region"] [region="id: 22 start_key: 7480000000000050FF3E00000000000000F8 end_key: 748000FFFFFFFFFFFFF900000000000000F8 region_epoch { conf_ver: 1 version: 8087 } peers { id: 23 store_id: 1 }"] [thread_id=68]
[2024/05/06 08:34:42.861 +08:00] [INFO] [peer.rs:4378] ["insert new region"] [store_id=1] [is_uninitialized_peer_exist=false] [region="id: 16678 start_key: 7480000000000050FF3900000000000000F8 end_key: 7480000000000050FF3E00000000000000F8 region_epoch { conf_ver: 1 version: 8087 } peers { id: 16679 store_id: 1 }"] [region_id=16678] [thread_id=102]
[2024/05/06 08:34:42.861 +08:00] [INFO] [peer.rs:275] ["create peer"] [peer_id=16679] [region_id=16678] [thread_id=102]
[2024/05/06 08:34:42.861 +08:00] [INFO] [raft.rs:2684] ["switched to configuration"] [config="Configuration { voters: Configuration { incoming: Configuration { voters: {16679} }, outgoing: Configuration { voters: {} } }, learners: {}, learners_next: {}, auto_leave: false }"] [raft_id=16679] [region_id=16678] [thread_id=102]
[2024/05/06 08:34:42.861 +08:00] [INFO] [raft.rs:1151] ["became follower at term 5"] [term=5] [raft_id=16679] [region_id=16678] [thread_id=102]
[2024/05/06 08:34:42.861 +08:00] [INFO] [raft.rs:387] [newRaft] [peers="Configuration { incoming: Configuration { voters: {16679} }, outgoing: Configuration { voters: {} } }"] ["last term"=5] ["last index"=5] [applied=5] [commit=5] [term=5] [raft_id=16679] [region_id=16678] [thread_id=102]
[2024/05/06 08:34:42.861 +08:00] [INFO] [raw_node.rs:315] ["RawNode created with id 16679."] [id=16679] [raft_id=16679] [region_id=16678] [thread_id=102]
[2024/05/06 08:34:42.861 +08:00] [INFO] [raft.rs:1556] ["starting a new election"] [term=5] [raft_id=16679] [region_id=16678] [thread_id=102]
[2024/05/06 08:34:42.861 +08:00] [INFO] [raft.rs:1201] ["became pre-candidate at term 5"] [term=5] [raft_id=16679] [region_id=16678] [thread_id=102]
[2024/05/06 08:34:42.861 +08:00] [INFO] [raft.rs:1175] ["became candidate at term 6"] [term=6] [raft_id=16679] [region_id=16678] [thread_id=102]
[2024/05/06 08:34:42.861 +08:00] [INFO] [raft.rs:1259] ["became leader at term 6"] [term=6] [raft_id=16679] [region_id=16678] [thread_id=102]
[2024/05/06 08:34:42.861 +08:00] [INFO] [peer.rs:5712] ["require updating max ts"] [initial_status=25769819950] [region_id=16678] [thread_id=101]
[2024/05/06 08:34:42.861 +08:00] [INFO] [endpoint.rs:358] ["Resolver initialized"] [pending_data_index=0] [snapshot_index=20847] [observe_id=ObserveId(16192)] [region=22] [thread_id=68]
[2024/05/06 08:34:42.862 +08:00] [INFO] [endpoint.rs:701] ["register observe region"] [region="id: 16678 start_key: 7480000000000050FF3900000000000000F8 end_key: 7480000000000050FF3E00000000000000F8 region_epoch { conf_ver: 1 version: 8087 } peers { id: 16679 store_id: 1 }"] [thread_id=68]
[2024/05/06 08:34:42.862 +08:00] [INFO] [pd.rs:1705] ["succeed to update max timestamp"] [region_id=16678] [thread_id=31]
[2024/05/06 08:34:42.862 +08:00] [INFO] [endpoint.rs:358] ["Resolver initialized"] [pending_data_index=0] [snapshot_index=6] [observe_id=ObserveId(16193)] [region=16678] [thread_id=68]
[2024/05/06 08:34:42.925 +08:00] [INFO] [peer.rs:6130] ["on split"] [source=ipv4:127.0.0.1:57602] [split_keys="key 7480000000000050FF4000000000000000F8"] [peer_id=23] [region_id=22] [thread_id=101]
[2024/05/06 08:34:42.925 +08:00] [INFO] [peer.rs:6158] ["invalid split request"] [source=ipv4:127.0.0.1:57602] [peer_id=23] [region_id=22] [err="EpochNotMatch(\"[region 22] 23 epoch changed conf_ver: 1 version: 8087 != conf_ver: 1 version: 8086, retry later\", [id: 22 start_key: 7480000000000050FF3E00000000000000F8 end_key: 748000FFFFFFFFFFFFF900000000000000F8 region_epoch { conf_ver: 1 version: 8087 } peers { id: 23 store_id: 1 }])"] [thread_id=101]
[2024/05/06 08:34:42.928 +08:00] [WARN] [prewrite.rs:832] ["commit_ts is too large, fallback to normal 2PC"] [lock="Lock { lock_type: Put, primary_key: 7480000000000050405F728000000000000001, start_ts: TimeStamp(449565342538137618), ttl: 3000, short_value: 80000100000002010001, for_update_ts: TimeStamp(0), txn_size: 2, min_commit_ts: TimeStamp(449565342538137619), use_async_commit: true, secondaries: [7480000000000050405F728000000000000002], rollback_ts: [], last_change: Unknown, txn_source: 0, is_locked_with_conflict: false, generation: 0 }"] [max_commit_ts=449565342538137618] [min_commit_ts=449565342538137619] [start_ts=449565342538137618] [key=7480000000000050FF405F728000000000FF0000010000000000FA] [thread_id=61]
[2024/05/06 08:34:42.928 +08:00] [INFO] [peer.rs:6130] ["on split"] [source=ipv4:127.0.0.1:57606] [split_keys="key 7480000000000050FF4000000000000000F8"] [peer_id=23] [region_id=22] [thread_id=101]
[2024/05/06 08:34:42.928 +08:00] [INFO] [pd.rs:1031] ["try to batch split region"] [task=batch_split] [region="id: 22 start_key: 7480000000000050FF3E00000000000000F8 end_key: 748000FFFFFFFFFFFFF900000000000000F8 region_epoch { conf_ver: 1 version: 8087 } peers { id: 23 store_id: 1 }"] [new_region_ids="[new_region_id: 16680 new_peer_ids: 16681]"] [region_id=22] [thread_id=31]
[2024/05/06 08:34:42.929 +08:00] [INFO] [apply.rs:1712] ["execute admin command"] [command="cmd_type: BatchSplit splits { requests { split_key: 7480000000000050FF4000000000000000F8 new_region_id: 16680 new_peer_ids: 16681 } right_derive: true }"] [index=20850] [term=6] [peer_id=23] [region_id=22] [thread_id=103]
[2024/05/06 08:34:42.929 +08:00] [INFO] [apply.rs:2578] ["split region"] [keys="key 7480000000000050FF4000000000000000F8"] [region="id: 22 start_key: 7480000000000050FF3E00000000000000F8 end_key: 748000FFFFFFFFFFFFF900000000000000F8 region_epoch { conf_ver: 1 version: 8087 } peers { id: 23 store_id: 1 }"] [peer_id=23] [region_id=22] [thread_id=103]
[2024/05/06 08:34:42.929 +08:00] [INFO] [endpoint.rs:279] ["region met split/merge command, stop tracking since key range changed, wait for re-register"] [req_type=BatchSplit] [thread_id=68]
[2024/05/06 08:34:42.929 +08:00] [INFO] [peer.rs:4250] ["moving 0 locks to new regions"] [region_id=22] [thread_id=102]
[2024/05/06 08:34:42.929 +08:00] [INFO] [peer.rs:4296] ["notify pd with split"] [split_count=2] [peer_id=23] [region_id=22] [thread_id=102]
[2024/05/06 08:34:42.929 +08:00] [INFO] [endpoint.rs:748] ["deregister observe region"] [observe_id=ObserveId(16192)] [region_id=22] [store_id=Some(1)] [thread_id=68]
[2024/05/06 08:34:42.929 +08:00] [INFO] [endpoint.rs:701] ["register observe region"] [region="id: 22 start_key: 7480000000000050FF4000000000000000F8 end_key: 748000FFFFFFFFFFFFF900000000000000F8 region_epoch { conf_ver: 1 version: 8088 } peers { id: 23 store_id: 1 }"] [thread_id=68]
[2024/05/06 08:34:42.929 +08:00] [INFO] [peer.rs:4378] ["insert new region"] [store_id=1] [is_uninitialized_peer_exist=false] [region="id: 16680 start_key: 7480000000000050FF3E00000000000000F8 end_key: 7480000000000050FF4000000000000000F8 region_epoch { conf_ver: 1 version: 8088 } peers { id: 16681 store_id: 1 }"] [region_id=16680] [thread_id=102]
[2024/05/06 08:34:42.929 +08:00] [INFO] [peer.rs:275] ["create peer"] [peer_id=16681] [region_id=16680] [thread_id=102]
[2024/05/06 08:34:42.929 +08:00] [INFO] [raft.rs:2684] ["switched to configuration"] [config="Configuration { voters: Configuration { incoming: Configuration { voters: {16681} }, outgoing: Configuration { voters: {} } }, learners: {}, learners_next: {}, auto_leave: false }"] [raft_id=16681] [region_id=16680] [thread_id=102]
[2024/05/06 08:34:42.929 +08:00] [INFO] [raft.rs:1151] ["became follower at term 5"] [term=5] [raft_id=16681] [region_id=16680] [thread_id=102]
[2024/05/06 08:34:42.929 +08:00] [INFO] [raft.rs:387] [newRaft] [peers="Configuration { incoming: Configuration { voters: {16681} }, outgoing: Configuration { voters: {} } }"] ["last term"=5] ["last index"=5] [applied=5] [commit=5] [term=5] [raft_id=16681] [region_id=16680] [thread_id=102]
[2024/05/06 08:34:42.929 +08:00] [INFO] [raw_node.rs:315] ["RawNode created with id 16681."] [id=16681] [raft_id=16681] [region_id=16680] [thread_id=102]
[2024/05/06 08:34:42.929 +08:00] [INFO] [raft.rs:1556] ["starting a new election"] [term=5] [raft_id=16681] [region_id=16680] [thread_id=102]
[2024/05/06 08:34:42.929 +08:00] [INFO] [raft.rs:1201] ["became pre-candidate at term 5"] [term=5] [raft_id=16681] [region_id=16680] [thread_id=102]
[2024/05/06 08:34:42.929 +08:00] [INFO] [raft.rs:1175] ["became candidate at term 6"] [term=6] [raft_id=16681] [region_id=16680] [thread_id=102]
[2024/05/06 08:34:42.929 +08:00] [INFO] [raft.rs:1259] ["became leader at term 6"] [term=6] [raft_id=16681] [region_id=16680] [thread_id=102]
[2024/05/06 08:34:42.929 +08:00] [INFO] [peer.rs:5712] ["require updating max ts"] [initial_status=25769819952] [region_id=16680] [thread_id=101]
[2024/05/06 08:34:42.929 +08:00] [INFO] [endpoint.rs:358] ["Resolver initialized"] [pending_data_index=0] [snapshot_index=20850] [observe_id=ObserveId(16194)] [region=22] [thread_id=68]
[2024/05/06 08:34:42.929 +08:00] [INFO] [endpoint.rs:701] ["register observe region"] [region="id: 16680 start_key: 7480000000000050FF3E00000000000000F8 end_key: 7480000000000050FF4000000000000000F8 region_epoch { conf_ver: 1 version: 8088 } peers { id: 16681 store_id: 1 }"] [thread_id=68]
[2024/05/06 08:34:42.929 +08:00] [INFO] [pd.rs:1705] ["succeed to update max timestamp"] [region_id=16680] [thread_id=31]
[2024/05/06 08:34:42.929 +08:00] [INFO] [endpoint.rs:358] ["Resolver initialized"] [pending_data_index=0] [snapshot_index=6] [observe_id=ObserveId(16195)] [region=16680] [thread_id=68]
[2024/05/06 08:34:42.970 +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(449565342551244815), ttl: 3000, short_value: 80000100000002010003, for_update_ts: TimeStamp(0), txn_size: 1, min_commit_ts: TimeStamp(449565342551244816), use_async_commit: true, secondaries: [], rollback_ts: [], last_change: Unknown, txn_source: 0, is_locked_with_conflict: false, generation: 0 }"] [max_commit_ts=449565342551244815] [min_commit_ts=449565342551244816] [start_ts=449565342551244815] [key=7480000000000050FF405F728000000000FF0000030000000000FA] [thread_id=63]
[2024/05/06 08:34:45.690 +08:00] [INFO] [kv.rs:1067] ["kv rpc failed"] [err=RemoteStopped] [request=batch_commands] [thread_id=7]
[2024/05/06 08:34:45.690 +08:00] [INFO] [kv.rs:1067] ["kv rpc failed"] [err=RemoteStopped] [request=batch_commands] [thread_id=8]
[2024/05/06 08:34:45.691 +08:00] [INFO] [kv.rs:1067] ["kv rpc failed"] [err=RemoteStopped] [request=batch_commands] [thread_id=9]
[2024/05/06 08:34:45.691 +08:00] [INFO] [kv.rs:1067] ["kv rpc failed"] [err=RemoteStopped] [request=batch_commands] [thread_id=10]
+ find . -name '*.out' -type f -exec tail -n 500 '{}' +
[2024/05/06 08:34:39.801 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.802 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.802 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3756001668] [schemaVersion=24653] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/05/06 08:34:39.814 +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 08:34:39.799 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 08:34:39.814 +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 08:34:39.799 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/05/06 08:34:39.834 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20527] [conn=3756001668] [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 08:34:39.799 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:39.853 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20527] [conn=3756001668] [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 08:34:39.799 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:39.871 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20527] [conn=3756001668] [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 08:34:39.799 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:39.889 +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 08:34:39.891 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20527] [jobType="drop table"]
[2024/05/06 08:34:39.891 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20527] [conn=3756001668] [job="ID:20527, Type:drop table, State:synced, SchemaState:none, SchemaID:20499, TableID:20525, RowCount:0, ArgLen:3, start time: 2024-05-06 08:34:39.799 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:39.894 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20527]
[2024/05/06 08:34:39.894 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 08:34:39.895 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24653] [neededSchemaVersion=24656] ["start time"=374.497µs] [gotSchemaVersion=24656] [phyTblIDs="[20525]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/06 08:34:39.900 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3756001668] [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 08:34:39.913 +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 08:34:39.899 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 08:34:39.913 +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 08:34:39.899 +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 08:34:39.938 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20529] [conn=3756001668] [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 08:34:39.899 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:39.960 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20529] [conn=3756001668] [job="ID:20529, Type:create table, State:synced, SchemaState:public, SchemaID:20499, TableID:20528, RowCount:0, ArgLen:0, start time: 2024-05-06 08:34:39.899 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:39.964 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20529]
[2024/05/06 08:34:39.964 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 08:34:39.964 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=22] ["first split key"=748000000000005030]
[2024/05/06 08:34:39.965 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=22] ["first at"=748000000000005030] ["first new region left"="{Id:16666 StartKey:7480000000000050ff2d00000000000000f8 EndKey:7480000000000050ff3000000000000000f8 RegionEpoch:{ConfVer:1 Version:8081} Peers:[id:16667 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/06 08:34:39.965 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16666]"]
[2024/05/06 08:34:39.965 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24656] [neededSchemaVersion=24657] ["start time"=677.853µs] [gotSchemaVersion=24657] [phyTblIDs="[20528]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 08:34:39.966 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.969 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.969 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.970 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.971 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.972 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.972 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.973 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.973 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.974 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.974 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.975 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.976 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.976 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.977 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.978 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.978 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.979 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.979 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.980 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.980 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:39.980 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3756001668] [schemaVersion=24657] [cur_db=util__ranger] [sql="drop table if exists t0;"] [user=root@%]
[2024/05/06 08:34:39.980 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3756001668] [schemaVersion=24657] [cur_db=util__ranger] [sql="CREATE TABLE t0(c0 TEXT(10));"] [user=root@%]
[2024/05/06 08:34:39.980 +08:00] [INFO] [ddl_api.go:1133] ["Automatically convert BLOB(10) to TINYBLOB"] [category=ddl]
[2024/05/06 08:34:39.993 +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 08:34:39.95 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 08:34:39.993 +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 08:34:39.95 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE TABLE t0(c0 TEXT(10));"]
[2024/05/06 08:34:40.020 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20531] [conn=3756001668] [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 08:34:39.95 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:40.046 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20531] [conn=3756001668] [job="ID:20531, Type:create table, State:synced, SchemaState:public, SchemaID:20499, TableID:20530, RowCount:0, ArgLen:0, start time: 2024-05-06 08:34:39.95 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:40.049 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20531]
[2024/05/06 08:34:40.049 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 08:34:40.049 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=22] ["first split key"=748000000000005032]
[2024/05/06 08:34:40.050 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=22] ["first at"=748000000000005032] ["first new region left"="{Id:16668 StartKey:7480000000000050ff3000000000000000f8 EndKey:7480000000000050ff3200000000000000f8 RegionEpoch:{ConfVer:1 Version:8082} Peers:[id:16669 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/06 08:34:40.050 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16668]"]
[2024/05/06 08:34:40.050 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24657] [neededSchemaVersion=24658] ["start time"=513.488µs] [gotSchemaVersion=24658] [phyTblIDs="[20530]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 08:34:40.051 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:40.053 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3756001668] [schemaVersion=24658] [cur_db=util__ranger] [sql="CREATE INDEX i0 ON t0(c0(255));"] [user=root@%]
[2024/05/06 08:34:40.064 +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 08:34:40.049 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0; "] [table=true]
[2024/05/06 08:34:40.064 +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 08:34:40.049 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"] [query="CREATE INDEX i0 ON t0(c0(255));"]
[2024/05/06 08:34:40.108 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20532] [conn=3756001668] [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 08:34:40.049 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 08:34:40.109 +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 08:34:40.049 +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 08:34:40.128 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20532] [conn=3756001668] [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 08:34:40.049 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 08:34:40.146 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20532] [conn=3756001668] [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 08:34:40.049 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 08:34:40.165 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20532] [conn=3756001668] [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 08:34:40.049 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 08:34:40.165 +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 08:34:40.166 +08:00] [INFO] [reorg.go:718] ["job get table range"] [category=ddl] [jobID=20532] [physicalTableID=20530] [startKey=7480000000000050325f728000000000000001] [endKey=7480000000000050325f72800000000000000100]
[2024/05/06 08:34:40.183 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20532] [conn=3756001668] [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 08:34:40.049 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449565341817241606, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 08:34:40.183 +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 08:34:40.187 +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 08:34:40.194 +08:00] [INFO] [index.go:2178] ["estimate row size"] [tableID=20530] [size=0] [error="less than 3 regions"]
[2024/05/06 08:34:40.202 +08:00] [INFO] [scheduler_manager.go:355] ["task scheduler started"] [task-id=660015]
[2024/05/06 08:34:40.202 +08:00] [INFO] [scheduler.go:120] ["schedule task"] [task-id=660015] [task-type=backfill] [allocated-slots=true] [state=pending] [concurrency=4]
[2024/05/06 08:34:40.703 +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 08:34:40.703 +08:00] [INFO] [scheduler.go:446] ["eligible instances"] [task-id=660015] [task-type=backfill] [allocated-slots=true] [num=1]
[2024/05/06 08:34:40.704 +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 08:34:40.705 +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 08:34:40.943 +08:00] [INFO] [manager.go:328] ["task executor started"] [task-id=660015] [type=backfill] [remaining-slots=4]
[2024/05/06 08:34:41.246 +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 08:34:41.247 +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 08:34:41.247 +08:00] [INFO] [backend_mgr.go:248] ["create local backend for adding index"] [category=ddl-ingest] [sortDir=/tmp/tidb/tmp_ddl-41703/20532] [keyspaceName=]
[2024/05/06 08:34:41.249 +08:00] [INFO] [pd_service_discovery.go:1016] ["[pd] switch leader"] [new-leader=http://127.0.0.1:2379] [old-leader=]
[2024/05/06 08:34:41.249 +08:00] [INFO] [pd_service_discovery.go:498] ["[pd] init cluster id"] [cluster-id=7365671069594846003]
[2024/05/06 08:34:41.249 +08:00] [INFO] [client.go:613] ["[pd] changing service mode"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/06 08:34:41.249 +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 08:34:41.249 +08:00] [INFO] [client.go:619] ["[pd] service mode changed"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/06 08:34:41.249 +08:00] [INFO] [tso_dispatcher.go:119] ["[tso] start tso deadline watcher"] [dc-location=global]
[2024/05/06 08:34:41.249 +08:00] [INFO] [tso_dispatcher.go:168] ["[tso] tso dispatcher created"] [dc-location=global]
[2024/05/06 08:34:41.249 +08:00] [INFO] [tso_client.go:130] ["[tso] start tso dispatcher check loop"]
[2024/05/06 08:34:41.249 +08:00] [INFO] [tso_dispatcher.go:336] ["[tso] start tso connection contexts updater"] [dc-location=global]
[2024/05/06 08:34:41.251 +08:00] [INFO] [local.go:682] ["multi ingest support"] [category=ddl-ingest]
[2024/05/06 08:34:41.252 +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 08:34:41.252 +08:00] [INFO] [backend_mgr.go:161] ["create one backend for an DDL job"] ["job ID"=20532] ["current memory usage"=33656] ["max memory quota"=17179869184] ["is unique index"=false]
[2024/05/06 08:34:41.252 +08:00] [INFO] [backfilling_read_index.go:91] ["read index executor init subtask exec env"] [category=ddl]
[2024/05/06 08:34:41.255 +08:00] [INFO] [backfilling_read_index.go:96] ["read index executor run subtask"] [category=ddl] ["use cloud"=false]
[2024/05/06 08:34:41.257 +08:00] [INFO] [backend.go:253] ["open engine"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba]
[2024/05/06 08:34:41.257 +08:00] [INFO] [engine_mgr.go:81] ["open an engine for index reorg task"] ["job ID"=20532] ["index ID"=1] ["current memory usage"=671122440] ["memory limitation"=17179869184] ["current writer count"=1]
[2024/05/06 08:34:41.258 +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 08:34:41.258 +08:00] [INFO] [backfilling.go:416] ["split table range from PD"] [category=ddl] [physicalTableID=20530] ["start key"=7480000000000050325f728000000000000001] ["end key"=7480000000000050325f72800000000000000100]
[2024/05/06 08:34:41.258 +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 08:34:41.270 +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"=671122480] ["max memory quota"=17179869184]
[2024/05/06 08:34:41.282 +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"=671122520] ["max memory quota"=17179869184]
[2024/05/06 08:34:41.283 +08:00] [INFO] [backfilling_operators.go:697] ["finish a index ingest task"] [task-id=660015] [subtask-id=60015] [id=1]
[2024/05/06 08:34:41.294 +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"=672171136] ["max memory quota"=17179869184]
[2024/05/06 08:34:41.299 +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"=672171176] ["max memory quota"=17179869184]
[2024/05/06 08:34:41.300 +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-41703/20532/4229afb8-665d-5dce-bb97-2afa316b67ba.sst/d168f9b6-fddd-4b08-bfa1-1713f02e2245.sst] [firstKey=7480000000000050325F698000000000000001013100000000000000F8038000000000000001] [lastKey=7480000000000050325F698000000000000001013100000000000000F8038000000000000001]
[2024/05/06 08:34:41.301 +08:00] [INFO] [backend.go:215] ["acquire distributed flush lock success"] [jobID=20532]
[2024/05/06 08:34:41.301 +08:00] [INFO] [backend.go:237] ["do a partial import data into the storage"] ["index ID"=1] ["usage info"="disk usage: 174163681280/940431265792, backend usage: 0"]
[2024/05/06 08:34:41.301 +08:00] [INFO] [backend.go:372] ["import start"] [category=ddl-ingest] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba] [retryCnt=0]
[2024/05/06 08:34:41.302 +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 08:34:41.302 +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 08:34:41.302 +08:00] [INFO] [local.go:1280] ["pause pd scheduler of table scope"] [category=ddl-ingest]
[2024/05/06 08:34:41.323 +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 08:34:41.323 +08:00] [INFO] [local.go:835] ["import engine ranges"] [category=ddl-ingest] [count=1]
[2024/05/06 08:34:41.333 +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 08:34:41.334 +08:00] [INFO] [backend.go:378] ["import completed"] [category=ddl-ingest] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba] [retryCnt=0] [takeTime=32.563124ms] []
[2024/05/06 08:34:41.336 +08:00] [INFO] [backend.go:221] ["release distributed flush lock success"] [jobID=20532]
[2024/05/06 08:34:41.342 +08:00] [INFO] [backfilling_read_index.go:151] ["read index executor cleanup subtask exec env"]
[2024/05/06 08:34:41.342 +08:00] [INFO] [backend.go:330] ["engine close start"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba]
[2024/05/06 08:34:41.343 +08:00] [INFO] [backend.go:332] ["engine close completed"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba] [takeTime=549.754µs] []
[2024/05/06 08:34:41.343 +08:00] [INFO] [backend.go:391] ["cleanup start"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba]
[2024/05/06 08:34:41.343 +08:00] [INFO] [backend.go:393] ["cleanup completed"] [category=ddl-ingest] [engineTag=t0:1] [engineUUID=4229afb8-665d-5dce-bb97-2afa316b67ba] [takeTime=352.608µs] []
[2024/05/06 08:34:41.344 +08:00] [INFO] [tso_dispatcher.go:137] ["[tso] exit tso deadline watcher"] [dc-location=global]
[2024/05/06 08:34:41.344 +08:00] [INFO] [pd_service_discovery.go:550] ["[pd] exit member loop due to context canceled"]
[2024/05/06 08:34:41.344 +08:00] [INFO] [tso_client.go:145] ["[tso] exit tso dispatcher check loop"]
[2024/05/06 08:34:41.344 +08:00] [INFO] [resource_manager_client.go:295] ["[resource manager] exit resource token dispatcher"]
[2024/05/06 08:34:41.344 +08:00] [INFO] [tso_dispatcher.go:350] ["[tso] exit tso connection contexts updater"] [dc-location=global]
[2024/05/06 08:34:41.344 +08:00] [INFO] [tso_dispatcher.go:210] ["[tso] stop fetching the pending tso requests due to context canceled"] [dc-location=global]
[2024/05/06 08:34:41.344 +08:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 08:34:41.344 +08:00] [INFO] [tso_dispatcher.go:171] ["[tso] exit tso dispatcher"] [dc-location=global]
[2024/05/06 08:34:41.344 +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 08:34:41.344 +08:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 08:34:41.344 +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 08:34:41.344 +08:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 08:34:41.344 +08:00] [INFO] [pd_service_discovery.go:637] ["[pd] close pd service discovery client"]
[2024/05/06 08:34:41.344 +08:00] [INFO] [client.go:329] ["[pd] http client closed"] [source=lightning]
[2024/05/06 08:34:41.344 +08:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 08:34:41.344 +08:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 08:34:41.344 +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 08:34:41.344 +08:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 08:34:41.344 +08:00] [INFO] [backend_mgr.go:309] ["close one backend for DDL job"] ["job ID"=20532] ["current memory usage"=33600] ["max memory quota"=17179869184]
[2024/05/06 08:34:41.344 +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=97.60831ms] []
[2024/05/06 08:34:41.704 +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 08:34:41.949 +08:00] [INFO] [manager.go:332] ["task executor exit"] [task-id=660015] [type=backfill]
[2024/05/06 08:34:42.004 +08:00] [INFO] [reorg.go:232] ["run reorg job done"] [category=ddl] ["handled rows"=1]
[2024/05/06 08:34:42.040 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20532] [conn=3756001668] [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 08:34:40.049 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449565341817241606, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 08:34:42.041 +08:00] [INFO] [index.go:880] ["index backfill state ready to merge"] [category=ddl] ["job ID"=20532] [table=t0] [index=i0]
[2024/05/06 08:34:42.066 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 5, tp add index"] [category=ddl] [jobID=20532] [conn=3756001668] [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 08:34:40.049 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 08:34:42.067 +08:00] [INFO] [reorg.go:718] ["job get table range"] [category=ddl] [jobID=20532] [physicalTableID=20530] [startKey=7480000000000050325f69ffff000000000001] [endKey=7480000000000050325f69ffff000000000001ff]
[2024/05/06 08:34:42.089 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20532] [conn=3756001668] [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 08:34:40.049 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449565342315315204, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 08:34:42.091 +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 08:34:40.049 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449565342315315204, LocalMode: false, UniqueWarnings:0"] [reorgInfo="CurrElementType:_idx_,CurrElementID:1,StartKey:7480000000000050325f69ffff000000000001,EndKey:7480000000000050325f69ffff000000000001ff,First:false,PhysicalTableID:20530,Ingest mode:false"]
[2024/05/06 08:34:42.092 +08:00] [INFO] [backfilling.go:416] ["split table range from PD"] [category=ddl] [physicalTableID=20530] ["start key"=7480000000000050325f69ffff000000000001] ["end key"=7480000000000050325f69ffff000000000001ff]
[2024/05/06 08:34:42.092 +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 08:34:42.093 +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 08:34:42.093 +08:00] [INFO] [backfilling.go:369] ["backfill worker exit"] [category=ddl] [worker="backfill-worker 3, tp merge temporary index"] [jobID=20532]
[2024/05/06 08:34:42.093 +08:00] [INFO] [backfilling.go:369] ["backfill worker exit"] [category=ddl] [worker="backfill-worker 2, tp merge temporary index"] [jobID=20532]
[2024/05/06 08:34:42.093 +08:00] [INFO] [backfilling.go:369] ["backfill worker exit"] [category=ddl] [worker="backfill-worker 1, tp merge temporary index"] [jobID=20532]
[2024/05/06 08:34:42.094 +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"=320.001µs]
[2024/05/06 08:34:42.094 +08:00] [INFO] [backfilling.go:369] ["backfill worker exit"] [category=ddl] [worker="backfill-worker 0, tp merge temporary index"] [jobID=20532]
[2024/05/06 08:34:42.094 +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 08:34:42.094 +08:00] [INFO] [reorg.go:232] ["run reorg job done"] [category=ddl] ["handled rows"=1]
[2024/05/06 08:34:42.099 +08:00] [INFO] [index.go:781] ["run add index job done"] [category=ddl] [charset=utf8mb4] [collation=utf8mb4_general_ci]
[2024/05/06 08:34:42.130 +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 08:34:42.131 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20532] [jobType="add index"]
[2024/05/06 08:34:42.132 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 6, tp add index"] [category=ddl] [jobID=20532] [conn=3756001668] [job="ID:20532, Type:add index, State:synced, SchemaState:public, SchemaID:20499, TableID:20530, RowCount:1, ArgLen:3, start time: 2024-05-06 08:34:40.049 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:449565342315315204, LocalMode: false, UniqueWarnings:0"]
[2024/05/06 08:34:42.136 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20532]
[2024/05/06 08:34:42.136 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 08:34:42.138 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24658] [neededSchemaVersion=24664] ["start time"=1.459903ms] [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 08:34:42.139 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.164 +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 08:34:42.143 +08:00] ["end time"=2024/05/06 08:34:42.162 +08:00] [cost=18.905181ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/06 08:34:42.173 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.174 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.174 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.175 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.175 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.175 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.176 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.176 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.176 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.176 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3756001668] [schemaVersion=24664] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/05/06 08:34:42.188 +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 08:34:42.149 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 08:34:42.188 +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 08:34:42.149 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/05/06 08:34:42.203 +08:00] [INFO] [scheduler_manager.go:364] ["task scheduler exist"] [task-id=660015]
[2024/05/06 08:34:42.204 +08:00] [INFO] [scheduler_manager.go:410] ["cleanup routine start"]
[2024/05/06 08:34:42.204 +08:00] [INFO] [scheduler_manager.go:426] ["cleanup task"] [task-id=660015]
[2024/05/06 08:34:42.208 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20533] [conn=3756001668] [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 08:34:42.149 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.208 +08:00] [INFO] [scheduler_manager.go:419] ["cleanup routine success"]
[2024/05/06 08:34:42.228 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20533] [conn=3756001668] [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 08:34:42.149 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.247 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20533] [conn=3756001668] [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 08:34:42.149 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.271 +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 08:34:42.274 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20533] [jobType="drop table"]
[2024/05/06 08:34:42.274 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20533] [conn=3756001668] [job="ID:20533, Type:drop table, State:synced, SchemaState:none, SchemaID:20499, TableID:20528, RowCount:0, ArgLen:3, start time: 2024-05-06 08:34:42.149 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.281 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20533]
[2024/05/06 08:34:42.282 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 08:34:42.283 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24664] [neededSchemaVersion=24667] ["start time"=492.79µs] [gotSchemaVersion=24667] [phyTblIDs="[20528]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/06 08:34:42.284 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3756001668] [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 08:34:42.297 +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 08:34:42.25 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 08:34:42.297 +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 08:34:42.25 +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 08:34:42.322 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20535] [conn=3756001668] [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 08:34:42.25 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.341 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20535] [conn=3756001668] [job="ID:20535, Type:create table, State:synced, SchemaState:public, SchemaID:20499, TableID:20534, RowCount:0, ArgLen:0, start time: 2024-05-06 08:34:42.25 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.344 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20535]
[2024/05/06 08:34:42.345 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 08:34:42.345 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=22] ["first split key"=748000000000005036]
[2024/05/06 08:34:42.346 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=22] ["first at"=748000000000005036] ["first new region left"="{Id:16674 StartKey:7480000000000050ff325f698000000000ff0000010131000000ff00000000f8038000ff0000000000010000fe EndKey:7480000000000050ff3600000000000000f8 RegionEpoch:{ConfVer:1 Version:8085} Peers:[id:16675 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/06 08:34:42.346 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16674]"]
[2024/05/06 08:34:42.346 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24667] [neededSchemaVersion=24668] ["start time"=467.049µs] [gotSchemaVersion=24668] [phyTblIDs="[20534]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 08:34:42.347 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.348 +08:00] [WARN] [prewrite.go:382] ["1pc failed and fallbacks to normal commit procedure"] [conn=3756001668] [session_alias=] [startTS=449565342380851221]
[2024/05/06 08:34:42.349 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.388 +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 08:34:42.353 +08:00] ["end time"=2024/05/06 08:34:42.387 +08:00] [cost=33.820869ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/06 08:34:42.411 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.412 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.414 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.414 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3756001668] [schemaVersion=24668] [cur_db=util__ranger] [sql="drop table if exists t;"] [user=root@%]
[2024/05/06 08:34:42.426 +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 08:34:42.399 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 08:34:42.426 +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 08:34:42.399 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table if exists t;"]
[2024/05/06 08:34:42.447 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20536] [conn=3756001668] [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 08:34:42.399 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.466 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20536] [conn=3756001668] [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 08:34:42.399 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.484 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20536] [conn=3756001668] [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 08:34:42.399 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.502 +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 08:34:42.503 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20536] [jobType="drop table"]
[2024/05/06 08:34:42.504 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20536] [conn=3756001668] [job="ID:20536, Type:drop table, State:synced, SchemaState:none, SchemaID:20499, TableID:20534, RowCount:0, ArgLen:3, start time: 2024-05-06 08:34:42.399 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.507 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20536]
[2024/05/06 08:34:42.507 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 08:34:42.508 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24668] [neededSchemaVersion=24671] ["start time"=371.544µs] [gotSchemaVersion=24671] [phyTblIDs="[20534]"] [actionTypes="[4]"] [diffTypes="[\"drop table\",\"drop table\",\"drop table\"]"]
[2024/05/06 08:34:42.509 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3756001668] [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 08:34:42.521 +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 08:34:42.5 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 08:34:42.521 +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 08:34:42.5 +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 08:34:42.557 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20538] [conn=3756001668] [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 08:34:42.5 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.580 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20538] [conn=3756001668] [job="ID:20538, Type:create table, State:synced, SchemaState:public, SchemaID:20499, TableID:20537, RowCount:0, ArgLen:0, start time: 2024-05-06 08:34:42.5 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.584 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20538]
[2024/05/06 08:34:42.584 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 08:34:42.584 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=22] ["first split key"=748000000000005039]
[2024/05/06 08:34:42.585 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=22] ["first at"=748000000000005039] ["first new region left"="{Id:16676 StartKey:7480000000000050ff3600000000000000f8 EndKey:7480000000000050ff3900000000000000f8 RegionEpoch:{ConfVer:1 Version:8086} Peers:[id:16677 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/06 08:34:42.585 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16676]"]
[2024/05/06 08:34:42.586 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24671] [neededSchemaVersion=24672] ["start time"=591.026µs] [gotSchemaVersion=24672] [phyTblIDs="[20537]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 08:34:42.587 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.589 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.615 +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 08:34:42.593 +08:00] ["end time"=2024/05/06 08:34:42.614 +08:00] [cost=20.464111ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/06 08:34:42.630 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.630 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001668] [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 08:34:42.632 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001672] [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 08:34:42.632 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001672] [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 08:34:42.632 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3756001672] [schemaVersion=24672] [cur_db=test] [sql="drop database `util__ranger`"] [user=root@%]
[2024/05/06 08:34:42.643 +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 08:34:42.6 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 08:34:42.643 +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 08:34:42.6 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop database `util__ranger`"]
[2024/05/06 08:34:42.663 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20539] [conn=3756001672] [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 08:34:42.6 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.683 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20539] [conn=3756001672] [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 08:34:42.6 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.701 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20539] [conn=3756001672] [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 08:34:42.6 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.720 +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 08:34:42.722 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20539] [jobType="drop schema"]
[2024/05/06 08:34:42.723 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20539] [conn=3756001672] [job="ID:20539, Type:drop schema, State:synced, SchemaState:none, SchemaID:20499, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 08:34:42.6 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.725 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20539]
[2024/05/06 08:34:42.725 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 08:34:42.727 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24672] [neededSchemaVersion=24675] ["start time"=442.182µ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 08:34:42.728 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001674] [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 08:34:42.728 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001674] [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 08:34:42.729 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3756001674] [schemaVersion=24675] [cur_db=test] [sql="create database `window_function`"] [user=root@%]
[2024/05/06 08:34:42.740 +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 08:34:42.7 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 08:34:42.740 +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 08:34:42.7 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create database `window_function`"]
[2024/05/06 08:34:42.770 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20541] [conn=3756001674] [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 08:34:42.7 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.790 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20541] [conn=3756001674] [job="ID:20541, Type:create schema, State:synced, SchemaState:public, SchemaID:20540, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 08:34:42.7 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.794 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20541]
[2024/05/06 08:34:42.794 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 08:34:42.795 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24675] [neededSchemaVersion=24676] ["start time"=265.886µs] [gotSchemaVersion=24676] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"create schema\"]"]
[2024/05/06 08:34:42.796 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.796 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.797 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001678] [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 08:34:42.797 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001678] [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 08:34:42.797 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001678] [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 08:34:42.797 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.798 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.798 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.798 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.798 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.798 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.798 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.798 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.799 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.799 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3756001676] [schemaVersion=24676] [cur_db=window_function] [sql="drop table if exists t;"] [user=root@%]
[2024/05/06 08:34:42.799 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3756001676] [schemaVersion=24676] [cur_db=window_function] [sql="create table t (a int, b int, c timestamp, index idx(a));"] [user=root@%]
[2024/05/06 08:34:42.813 +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 08:34:42.799 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 08:34:42.813 +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 08:34:42.799 +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 08:34:42.837 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20543] [conn=3756001676] [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 08:34:42.799 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.857 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20543] [conn=3756001676] [job="ID:20543, Type:create table, State:synced, SchemaState:public, SchemaID:20540, TableID:20542, RowCount:0, ArgLen:0, start time: 2024-05-06 08:34:42.799 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.860 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20543]
[2024/05/06 08:34:42.860 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 08:34:42.860 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=22] ["first split key"=74800000000000503e]
[2024/05/06 08:34:42.861 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=22] ["first at"=74800000000000503e] ["first new region left"="{Id:16678 StartKey:7480000000000050ff3900000000000000f8 EndKey:7480000000000050ff3e00000000000000f8 RegionEpoch:{ConfVer:1 Version:8087} Peers:[id:16679 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/06 08:34:42.861 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16678]"]
[2024/05/06 08:34:42.861 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24676] [neededSchemaVersion=24677] ["start time"=502.187µs] [gotSchemaVersion=24677] [phyTblIDs="[20542]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 08:34:42.862 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.862 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.863 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.863 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.864 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.864 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.865 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.865 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.866 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.866 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.866 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.867 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.867 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.868 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.868 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.869 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.869 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.870 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3756001676] [schemaVersion=24677] [cur_db=window_function] [sql="drop table if exists t1;"] [user=root@%]
[2024/05/06 08:34:42.870 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3756001676] [schemaVersion=24677] [cur_db=window_function] [sql="create table t1(a int primary key, b int);"] [user=root@%]
[2024/05/06 08:34:42.883 +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 08:34:42.85 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 08:34:42.883 +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 08:34:42.85 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table t1(a int primary key, b int);"]
[2024/05/06 08:34:42.903 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20545] [conn=3756001676] [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 08:34:42.85 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.922 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20545] [conn=3756001676] [job="ID:20545, Type:create table, State:synced, SchemaState:public, SchemaID:20540, TableID:20544, RowCount:0, ArgLen:0, start time: 2024-05-06 08:34:42.85 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:42.925 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20545]
[2024/05/06 08:34:42.925 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 08:34:42.925 +08:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=22] ["first split key"=748000000000005040]
[2024/05/06 08:34:42.926 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24677] [neededSchemaVersion=24678] ["start time"=439.575µs] [gotSchemaVersion=24678] [phyTblIDs="[20544]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 08:34:42.927 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.928 +08:00] [WARN] [prewrite.go:382] ["1pc failed and fallbacks to normal commit procedure"] [conn=3756001676] [session_alias=] [startTS=449565342538137618]
[2024/05/06 08:34:42.929 +08:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=22] ["first at"=748000000000005040] ["first new region left"="{Id:16680 StartKey:7480000000000050ff3e00000000000000f8 EndKey:7480000000000050ff4000000000000000f8 RegionEpoch:{ConfVer:1 Version:8088} Peers:[id:16681 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/06 08:34:42.929 +08:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[16680]"]
[2024/05/06 08:34:42.929 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.958 +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 08:34:42.936 +08:00] ["end time"=2024/05/06 08:34:42.956 +08:00] [cost=19.950378ms] ["sample rate reason"="use min(1, 110000/10000) as the sample-rate=1"]
[2024/05/06 08:34:42.969 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.969 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.970 +08:00] [WARN] [prewrite.go:382] ["1pc failed and fallbacks to normal commit procedure"] [conn=3756001676] [session_alias=] [startTS=449565342551244815]
[2024/05/06 08:34:42.971 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:42.977 +08:00] [INFO] [save.go:200] ["incrementally update modifyCount"] [category=stats] [tableID=20544] [curModifyCnt=0] [results.BaseModifyCnt=0] [modifyCount=0]
[2024/05/06 08:34:42.977 +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 08:34:42.995 +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 08:34:42.974 +08:00] ["end time"=2024/05/06 08:34:42.993 +08:00] [cost=19.118791ms] ["sample rate reason"="use min(1, 110000/2) as the sample-rate=1"]
[2024/05/06 08:34:43.004 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001676] [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 08:34:43.005 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001680] [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 08:34:43.005 +08:00] [INFO] [session.go:3971] [GENERAL_LOG] [conn=3756001680] [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 08:34:43.006 +08:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=3756001680] [schemaVersion=24678] [cur_db=test] [sql="drop database `window_function`"] [user=root@%]
[2024/05/06 08:34:43.018 +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 08:34:43 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 08:34:43.018 +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 08:34:43 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop database `window_function`"]
[2024/05/06 08:34:43.039 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20546] [conn=3756001680] [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 08:34:43 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:43.058 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20546] [conn=3756001680] [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 08:34:43 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:43.076 +08:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20546] [conn=3756001680] [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 08:34:43 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:43.095 +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 08:34:43.097 +08:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=20546] [jobType="drop schema"]
[2024/05/06 08:34:43.097 +08:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=20546] [conn=3756001680] [job="ID:20546, Type:drop schema, State:synced, SchemaState:none, SchemaID:20540, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 08:34:43 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 08:34:43.100 +08:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=20546]
[2024/05/06 08:34:43.100 +08:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 08:34:43.101 +08:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=24678] [neededSchemaVersion=24681] ["start time"=442.709µs] [gotSchemaVersion=24681] [phyTblIDs="[20542,20544]"] [actionTypes="[2,2]"] [diffTypes="[\"drop schema\",\"drop schema\",\"drop schema\"]"]
[2024/05/06 08:34:43.104 +08:00] [INFO] [signal_posix.go:54] ["got signal to exit"] [signal=terminated]
[2024/05/06 08:34:43.104 +08:00] [INFO] [server.go:584] ["setting tidb-server to report unhealthy (shutting-down)"]
[2024/05/06 08:34:43.105 +08:00] [ERROR] [http_status.go:526] ["http server error"] [error="http: Server closed"]
[2024/05/06 08:34:43.105 +08:00] [ERROR] [http_status.go:531] ["start status/rpc server error"] [error="accept tcp 127.0.0.1:32791: use of closed network connection"]
[2024/05/06 08:34:43.105 +08:00] [ERROR] [http_status.go:521] ["grpc server error"] [error="mux: server closed"]
[2024/05/06 08:34:43.106 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=7028] [tblID=7196] [from=0] [to=30] [isUnsigned=false] [category="autoid service"]
[2024/05/06 08:34:43.107 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=7028] [tblID=7202] [from=0] [to=4008] [isUnsigned=true] [category="autoid service"]
[2024/05/06 08:34:43.109 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=7028] [tblID=7063] [from=0] [to=256] [isUnsigned=true] [category="autoid service"]
[2024/05/06 08:34:43.110 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=7028] [tblID=7072] [from=0] [to=8388608] [isUnsigned=false] [category="autoid service"]
[2024/05/06 08:34:43.111 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=7028] [tblID=7075] [from=0] [to=16777216] [isUnsigned=true] [category="autoid service"]
[2024/05/06 08:34:43.112 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=7028] [tblID=7081] [from=0] [to=4294967296] [isUnsigned=true] [category="autoid service"]
[2024/05/06 08:34:43.113 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=7028] [tblID=7190] [from=0] [to=51] [isUnsigned=false] [category="autoid service"]
[2024/05/06 08:34:43.114 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=7028] [tblID=7066] [from=0] [to=32768] [isUnsigned=false] [category="autoid service"]
[2024/05/06 08:34:43.115 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=7028] [tblID=7199] [from=0] [to=4008] [isUnsigned=false] [category="autoid service"]
[2024/05/06 08:34:43.116 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=9743] [tblID=9906] [from=0] [to=6] [isUnsigned=false] [category="autoid service"]
[2024/05/06 08:34:43.117 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=7028] [tblID=7060] [from=0] [to=128] [isUnsigned=false] [category="autoid service"]
[2024/05/06 08:34:43.118 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=7028] [tblID=7069] [from=0] [to=65536] [isUnsigned=true] [category="autoid service"]
[2024/05/06 08:34:43.119 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=7028] [tblID=7084] [from=0] [to=9223372036854775807] [isUnsigned=false] [category="autoid service"]
[2024/05/06 08:34:43.120 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=7028] [tblID=7078] [from=0] [to=2147483648] [isUnsigned=false] [category="autoid service"]
[2024/05/06 08:34:43.121 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=7028] [tblID=7125] [from=0] [to=2] [isUnsigned=false] [category="autoid service"]
[2024/05/06 08:34:43.126 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=7028] [tblID=7184] [from=0] [to=11] [isUnsigned=false] [category="autoid service"]
[2024/05/06 08:34:43.128 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=9743] [tblID=9895] [from=0] [to=2147483647] [isUnsigned=false] [category="autoid service"]
[2024/05/06 08:34:43.129 +08:00] [INFO] [autoid.go:569] ["forceRebase from"] [dbID=9743] [tblID=9900] [from=0] [to=2] [isUnsigned=false] [category="autoid service"]
[2024/05/06 08:34:43.129 +08:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[autoid] tidb/autoid/leader ownerManager 127.0.0.1:32791"]
[2024/05/06 08:34:43.129 +08:00] [INFO] [manager.go:257] ["etcd session is done, creates a new one"] ["owner info"="[autoid] tidb/autoid/leader ownerManager 127.0.0.1:32791"]
[2024/05/06 08:34:43.129 +08:00] [INFO] [manager.go:261] ["break campaign loop, NewSession failed"] ["owner info"="[autoid] tidb/autoid/leader ownerManager 127.0.0.1:32791"] [error="context canceled"]
[2024/05/06 08:34:43.129 +08:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[autoid] tidb/autoid/leader ownerManager 127.0.0.1:32791"] []
[2024/05/06 08:34:43.130 +08:00] [INFO] [server.go:978] ["start drain clients"]
[2024/05/06 08:34:43.130 +08:00] [INFO] [server.go:1007] ["all sessions quit in drain wait time"]
[2024/05/06 08:34:43.130 +08:00] [INFO] [server.go:959] ["kill all connections."] [category=server]
[2024/05/06 08:34:43.130 +08:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager 03b652b8-33da-443b-9d2c-99992c54bb76"]
[2024/05/06 08:34:43.130 +08:00] [INFO] [manager.go:257] ["etcd session is done, creates a new one"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager 03b652b8-33da-443b-9d2c-99992c54bb76"]
[2024/05/06 08:34:43.130 +08:00] [INFO] [manager.go:261] ["break campaign loop, NewSession failed"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager 03b652b8-33da-443b-9d2c-99992c54bb76"] [error="context canceled"]
[2024/05/06 08:34:43.130 +08:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager 03b652b8-33da-443b-9d2c-99992c54bb76"] []
[2024/05/06 08:34:43.131 +08:00] [INFO] [ddl_workerpool.go:82] ["closing workerPool"] [category=ddl]
[2024/05/06 08:34:43.131 +08:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 6, tp add index"] [category=ddl] ["take time"=1.899µs]
[2024/05/06 08:34:43.131 +08:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 5, tp add index"] [category=ddl] ["take time"=1.04µs]
[2024/05/06 08:34:43.131 +08:00] [INFO] [ddl_workerpool.go:82] ["closing workerPool"] [category=ddl]
[2024/05/06 08:34:43.131 +08:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 4, tp general"] [category=ddl] ["take time"=920ns]
[2024/05/06 08:34:43.131 +08:00] [INFO] [ddl_workerpool.go:82] ["closing workerPool"] [category=ddl]
[2024/05/06 08:34:43.131 +08:00] [INFO] [delete_range.go:162] ["closing delRange"] [category=ddl]
[2024/05/06 08:34:43.131 +08:00] [INFO] [session_pool.go:99] ["closing session pool"] [category=ddl]
[2024/05/06 08:34:43.132 +08:00] [INFO] [ddl.go:951] ["DDL closed"] [category=ddl] [ID=03b652b8-33da-443b-9d2c-99992c54bb76] ["take time"=2.024557ms]
[2024/05/06 08:34:43.132 +08:00] [INFO] [ddl.go:769] ["stop DDL"] [category=ddl] [ID=03b652b8-33da-443b-9d2c-99992c54bb76]
[2024/05/06 08:34:43.132 +08:00] [INFO] [domain.go:1026] ["stopping ttlJobManager"]
[2024/05/06 08:34:43.132 +08:00] [INFO] [notifier.go:142] ["etcd watcher exited to watch timer events"] [EtcdKey=/tidb/timer/cluster/1/notify/57d33698-5469-4355-ac08-c0c0fcfebe12] [watcherID=79006815-6a53-4f5d-bf19-b4abf11ce6a3]
[2024/05/06 08:34:43.132 +08:00] [INFO] [runtime.go:190] ["TimerGroupRuntime loop exit"] [groupID=ttl]
[2024/05/06 08:34:43.132 +08:00] [INFO] [notifier.go:227] ["etcd notify loop to watch timer events stopped"] [EtcdKey=/tidb/timer/cluster/1/notify/57d33698-5469-4355-ac08-c0c0fcfebe12]
[2024/05/06 08:34:43.132 +08:00] [INFO] [task_manager.go:194] ["shrink ttl worker"] [ttl-worker=job-manager] [ttl-worker=task-manager] [originalCount=4] [newCount=0]
[2024/05/06 08:34:43.132 +08:00] [INFO] [scan.go:309] ["ttlScanWorker loop exited."]
[2024/05/06 08:34:43.132 +08:00] [INFO] [scan.go:309] ["ttlScanWorker loop exited."]
[2024/05/06 08:34:43.132 +08:00] [INFO] [scan.go:309] ["ttlScanWorker loop exited."]
[2024/05/06 08:34:43.132 +08:00] [INFO] [scan.go:309] ["ttlScanWorker loop exited."]
[2024/05/06 08:34:43.132 +08:00] [INFO] [task_manager.go:194] ["shrink ttl worker"] [ttl-worker=job-manager] [ttl-worker=task-manager] [originalCount=4] [newCount=0]
[2024/05/06 08:34:43.132 +08:00] [INFO] [del.go:261] ["ttlDeleteWorker loop exited."]
[2024/05/06 08:34:43.132 +08:00] [INFO] [del.go:261] ["ttlDeleteWorker loop exited."]
[2024/05/06 08:34:43.132 +08:00] [INFO] [del.go:261] ["ttlDeleteWorker loop exited."]
[2024/05/06 08:34:43.132 +08:00] [INFO] [del.go:261] ["ttlDeleteWorker loop exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [job_manager.go:174] ["ttlJobManager loop exited."] [ttl-worker=job-manager]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:1037] ["ttlJobManager exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:2817] ["releaseServerID succeed"] [serverID=1791]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:711] ["infoSyncerKeeper exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=infoSyncerKeeper]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=requestUnitsWriterLoop]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:1542] ["stopping dist task scheduler manager because the current node is not DDL owner anymore"] [id=03b652b8-33da-443b-9d2c-99992c54bb76]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:1700] ["loadPrivilegeInLoop exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:737] ["globalConfigSyncerKeeper exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [scheduler_manager.go:206] ["schedule task loop exits"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [scheduler_manager.go:318] ["subtask history table gc loop exits"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=loadSigningCertLoop]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:2323] ["loadStatsWorker exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [scheduler_manager.go:379] ["cleanup loop exits"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [manager.go:446] ["watcher is closed, no owner"] ["owner info"="[stats] ownerManager 03b652b8-33da-443b-9d2c-99992c54bb76 watch owner key /tidb/stats/owner/6e648f4b38598a48"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=runawayRecordFlushLoop]
[2024/05/06 08:34:43.133 +08:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=globalConfigSyncerKeeper]
[2024/05/06 08:34:43.133 +08:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 08:34:43.133 +08:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[stats] /tidb/stats/owner ownerManager 03b652b8-33da-443b-9d2c-99992c54bb76"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [scheduler_manager.go:459] ["collect loop exits"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=runawayWatchSyncLoop]
[2024/05/06 08:34:43.133 +08:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:2074] ["dumpFileGcChecker exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:2105] ["HistoricalStatsWorker exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:2040] ["PlanReplayerTaskDumpHandle exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [manager.go:446] ["watcher is closed, no owner"] ["owner info"="[log-backup] ownerManager 253aed27-59fe-42a9-b2c6-0df33b7ffb58 watch owner key /tidb/br-stream/owner/6e648f4b38598a3c"]
[2024/05/06 08:34:43.133 +08:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager 253aed27-59fe-42a9-b2c6-0df33b7ffb58"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:2881] ["serverIDKeeper exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=HistoricalStatsWorker]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:2352] ["indexUsageWorker exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=indexUsageWorker]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:2020] ["PlanReplayerTaskCollectHandle exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=PlanReplayerTaskCollectHandle]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=loadPrivilegeInLoop]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:1750] ["LoadSysVarCacheLoop exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=LoadSysVarCacheLoop]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:761] ["topologySyncerKeeper exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=topologySyncerKeeper]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=loadStatsWorker]
[2024/05/06 08:34:43.133 +08:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[bindinfo] /tidb/bindinfo/owner ownerManager 03b652b8-33da-443b-9d2c-99992c54bb76"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [manager.go:257] ["etcd session is done, creates a new one"] ["owner info"="[bindinfo] /tidb/bindinfo/owner ownerManager 03b652b8-33da-443b-9d2c-99992c54bb76"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [manager.go:261] ["break campaign loop, NewSession failed"] ["owner info"="[bindinfo] /tidb/bindinfo/owner ownerManager 03b652b8-33da-443b-9d2c-99992c54bb76"] [error="context canceled"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=mdlCheckLoop]
[2024/05/06 08:34:43.133 +08:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [manager.go:273] ["break campaign loop, context is done"] ["owner info"="[stats] /tidb/stats/owner ownerManager 03b652b8-33da-443b-9d2c-99992c54bb76"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:1544] ["dist task scheduler manager stopped"] [id=03b652b8-33da-443b-9d2c-99992c54bb76]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:1527] ["stopping dist task executor manager"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=dumpFileGcChecker]
[2024/05/06 08:34:43.133 +08:00] [INFO] [manager.go:179] ["handle tasks loop done"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [advancer.go:397] ["Meet task event"] [category="log backup advancer"] [event="Err(, err = EOF)"]
[2024/05/06 08:34:43.133 +08:00] [ERROR] [advancer.go:400] ["listen task meet error, would reopen."] [error=EOF]
[2024/05/06 08:34:43.133 +08:00] [INFO] [advancer.go:403] ["Task watcher exits due to some error."] [category="log backup advancer"] [error=EOF]
[2024/05/06 08:34:43.133 +08:00] [INFO] [plan_replayer.go:413] ["planReplayerTaskDumpWorker exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=PlanReplayerTaskDumpHandle]
[2024/05/06 08:34:43.133 +08:00] [INFO] [manager.go:280] ["recoverMetaLoop done"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:1529] ["dist task executor manager stopped"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=distTaskFrameworkLoop]
[2024/05/06 08:34:43.133 +08:00] [INFO] [manager.go:292] ["failed to campaign"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager 253aed27-59fe-42a9-b2c6-0df33b7ffb58"] [error="context canceled"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:1361] ["closestReplicaReadCheckLoop exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [manager.go:273] ["break campaign loop, context is done"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager 253aed27-59fe-42a9-b2c6-0df33b7ffb58"]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=closestReplicaReadCheckLoop]
[2024/05/06 08:34:43.133 +08:00] [INFO] [flush_subscriber.go:109] [Clearing.] [category="log backup flush subscriber"] [timeout=1m0s]
[2024/05/06 08:34:43.133 +08:00] [INFO] [owner_daemon.go:87] ["daemon loop exits"] [id=253aed27-59fe-42a9-b2c6-0df33b7ffb58] [daemon-id=LogBackup::Advancer]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=logBackupAdvancer]
[2024/05/06 08:34:43.133 +08:00] [INFO] [domain.go:683] ["topNSlowQueryLoop exited."]
[2024/05/06 08:34:43.133 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=topNSlowQueryLoop]
[2024/05/06 08:34:45.659 +08:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager 253aed27-59fe-42a9-b2c6-0df33b7ffb58"] [error="rpc error: code = Canceled desc = grpc: the client connection is closing"]
[2024/05/06 08:34:45.666 +08:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[stats] /tidb/stats/owner ownerManager 03b652b8-33da-443b-9d2c-99992c54bb76"] [error="rpc error: code = Canceled desc = grpc: the client connection is closing"]
[2024/05/06 08:34:45.666 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=quitStatsOwner]
[2024/05/06 08:34:45.687 +08:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[bindinfo] /tidb/bindinfo/owner ownerManager 03b652b8-33da-443b-9d2c-99992c54bb76"] [error="rpc error: code = Canceled desc = grpc: the client connection is closing"]
[2024/05/06 08:34:45.687 +08:00] [INFO] [domain.go:1889] ["globalBindHandleWorkerLoop exited."]
[2024/05/06 08:34:45.687 +08:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=globalBindHandleWorkerLoop]
[2024/05/06 08:34:45.689 +08:00] [INFO] [domain.go:1074] ["domain closed"] ["take time"=2.559796307s]
[2024/05/06 08:34:45.689 +08:00] [INFO] [gc_worker.go:223] [quit] [category="gc worker"] [uuid=63d2ce2002c0011]
[2024/05/06 08:34:45.690 +08:00] [INFO] [pd_service_discovery.go:550] ["[pd] exit member loop due to context canceled"]
[2024/05/06 08:34:45.690 +08:00] [INFO] [tso_dispatcher.go:350] ["[tso] exit tso connection contexts updater"] [dc-location=global]
[2024/05/06 08:34:45.690 +08:00] [INFO] [tso_client.go:145] ["[tso] exit tso dispatcher check loop"]
[2024/05/06 08:34:45.690 +08:00] [INFO] [tso_dispatcher.go:210] ["[tso] stop fetching the pending tso requests due to context canceled"] [dc-location=global]
[2024/05/06 08:34:45.690 +08:00] [INFO] [tso_dispatcher.go:171] ["[tso] exit tso dispatcher"] [dc-location=global]
[2024/05/06 08:34:45.690 +08:00] [INFO] [resource_manager_client.go:295] ["[resource manager] exit resource token dispatcher"]
[2024/05/06 08:34:45.690 +08:00] [INFO] [tso_dispatcher.go:137] ["[tso] exit tso deadline watcher"] [dc-location=global]
[2024/05/06 08:34:45.690 +08:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 08:34:45.690 +08:00] [INFO] [tso_batch_controller.go:160] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=1] [collected-request-count=0] [pending-request-count=0]
[2024/05/06 08:34:45.690 +08:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 08:34:45.690 +08:00] [INFO] [tso_batch_controller.go:160] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=1] [collected-request-count=0] [pending-request-count=0]
[2024/05/06 08:34:45.690 +08:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 08:34:45.690 +08:00] [INFO] [pd_service_discovery.go:637] ["[pd] close pd service discovery client"]
[2024/05/06 08:34:45.690 +08:00] [INFO] [client.go:329] ["[pd] http client closed"] [source=tikv-driver]
[2024/05/06 08:34:45.691 +08:00] [INFO] [cpu.go:98] ["sql cpu collector stopped"]
[2024/05/06 08:34:45.691 +08:00] [INFO] [cgmon.go:77] ["cgroup monitor stopped"]
[2024/05/06 08:34:45.691 +08:00] [INFO] [cpuprofile.go:130] ["parallel cpu profiler stopped"]
[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] }
[Pipeline] // parallel
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Declarative: Post Actions)
[Pipeline] sh
+ echo 72a0fd5b00235a7c56014b77ddd933e2a0d33c88
+ echo 1679dbca25b3483d1375c7e747da27e99ad77360
+ echo 600b2ed4bf0aa38224a1c4c4c68831820735515c
+ curl -F refs/pingcap/tikv/master/sha1.verify=@tikv.sha1.verify http://fileserver.pingcap.net/upload
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed

  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
100   382  100   101  100   281   2818   7841 --:--:-- --:--:-- --:--:--  8028
{"msg":"success","url":"http://fileserver.pingcap.net/download/refs/pingcap/tikv/master/sha1.verify"}+ curl -F refs/pingcap/pd/master/sha1.verify=@pd.sha1.verify http://fileserver.pingcap.net/upload
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed

  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
100   376  100    99  100   277   4110  11502 --:--:-- --:--:-- --:--:-- 11541
{"msg":"success","url":"http://fileserver.pingcap.net/download/refs/pingcap/pd/master/sha1.verify"}+ curl -F refs/pingcap/tidb/master/sha1.verify=@tidb.sha1.verify http://fileserver.pingcap.net/upload
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed

  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
100   382  100   101  100   281   2209   6146 --:--:-- --:--:-- --:--:--  6244
{"msg":"success","url":"http://fileserver.pingcap.net/download/refs/pingcap/tidb/master/sha1.verify"}
[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
Finished: SUCCESS