tel_20190920 表信息大概1亿行,3000万重复 172.16.1.2 172.16.1.3 tidb 172.16.1.4 172.16.1.5 172.16.1.6 tikv
set tidb_batch_insert = 1; insert into tel_20190920001(tel) select tel from tel_20190920 group by tel; set tidb_batch_insert = 0;
2003 - Can't connect to MySQL server on '172.16.1.2' (10061 "Unknown error") 时间: 406.02s
tidb.log如下
[2019/09/20 15:13:58.827 +08:00] [WARN] [expensivequery.go:160] [expensive_query] [cost_time=60.03679962s] [process_time=279.514s] [wait_time=279.514s] [request_count=115] [total_keys=123510575] [process_keys=123510460] [num_cop_tasks=115] [process_avg_time=2.430556521s] [process_p90_time=2.819s] [process_max_time=3.128s] [process_max_addr=172.16.1.6:20171] [wait_avg_time=0.022669565s] [wait_p90_time=0.001s] [wait_max_time=2.249s] [wait_max_addr=172.16.1.5:20172] [stats=tel_20190920:411291777893138439] [conn_id=2] [user=root] [database=testdb] [table_ids="[831]"] [txn_start_ts=411294388388626439] [mem_max=“3.2046628016978502 GB”] [sql=" insert into tel_20190920001(tel) select tel from tel_20190920 group by tel"]
[WARN] [client_batch.go:423] [“no available connections”] [target=172.16.1.5:20175]
[2019/09/24 09:10:06.881 +08:00] [ERROR] [client_batch.go:278] [“batchRecvLoop error when receive”] [target=172.16.1.5:20177] [error=“rpc error: code = Unavailable desc = transport is closing”] [stack=“github.com/pingcap/tidb/store/tikv.(*batchCommandsClient).batchRecvLoop /home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/store/tikv/client_batch.go:278”]