升级到v4.0.12 运行一天集群奔溃 2个tikv失败, 之前运行1年都没问题

为提高效率,请提供以下信息,问题描述清晰能够更快得到解决:

【TiDB 版本】
v4.0.12
【问题描述】

凌晨3点18分 一直有一个全库冷备份(已经运行了1年, 超大数据量库都没备份), 凌晨3点20 tikv 就烂了, 4月13日凌晨4点升级到v4.0.12, 4月14日凌晨3点20 就崩了, 感觉是备份时 tikv卡住

备份脚本片段

# 需要排除哪些数据库
exclude_databases="____x_x_x_____"
if [ $# -ge 6 ]; then
    exclude_databases=$6
fi

cd $backup_dir
log_dir=$backup_dir/out.log

for db_name in `mysql -h \${db_host} -P\${db_port} -u\${db_user} -p\${db_passwd} --default-auth=mysql_native_password -e "show databases;" | awk -F '|' '{print $1}' | grep -v "Database" | grep -v "sys" | grep -v "performance_schema" | grep -v "mysql"`
do
   should_backup ${exclude_databases} ${db_name}
   if [ $? -eq 0 ]; then
       log "backup ${db_name}" >> ${log_dir}
       /usr/bin/mysqldump -h$db_host -P$db_port -u$db_user  -p$db_passwd --default-auth=mysql_native_password -C --databases $db_name | gzip > "$backup_dir/$db_name"_"$time.sql.gz"
   else
       log "database ${db_name} should not backup" >> ${log_dir}
   fi
done

tidb 错误日志

[2021/04/14 07:50:48.741 +08:00] [ERROR] [update.go:796] ["[stats] auto analyze failed"] [sql="analyze table %n.%n"] [cost_time=56.246675ms] [error="analyze worker panic"]

[2021/04/14 07:50:51.718 +08:00] [ERROR] [analyze.go:172] ["analyze worker panicked"] [stack="goroutine 150110 [running]:\
github.com/pingcap/tidb/executor.(*AnalyzeExec).analyzeWo

rker.func1(0xc018a79860, 0xc0013f3ed8, 0xc00a0ad560, 0x1)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/analyze.go:170

+0xff\
panic(0x3169660, 0xc018013ce0)\
\t/usr/local/go/src/runtime/panic.go:679 +0x1b2\
github.com/pingcap/tidb/util/collate.decodeRune(0xc017fc8462, 0x6, 0x5, 0x7f, 0x5)\
\t/home/

jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/util/collate/unicode_ci.go:44 +0x129\
github.com/pingcap/tidb/util/collate.(*generalCIColla

tor).Compare(0x54fb878, 0xc017fc8462, 0x6, 0xc017fc8422, 0x6, 0xffffffffffffffff)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/

util/collate/general_ci.go:39 +0xdb\
github.com/pingcap/tidb/types.CompareString(0xc017fc8462, 0x6, 0xc017fc8422, 0x6, 0xc001874fc0, 0x12, 0xffffffffffffffff)\
\t/home/jenkins/agen

t/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/types/compare.go:118 +0x71\
github.com/pingcap/tidb/types.(*Datum).compareString(0xc0172deb40, 0xc00977

d200, 0xc017fc8422, 0x6, 0xc001874fc0, 0x12, 0xffffffffffffffff, 0x0, 0x0)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/types/d

atum.go:665 +0x112\
github.com/pingcap/tidb/types.(*Datum).CompareDatum(0xc0172deb40, 0xc00977d200, 0xc0172de840, 0xffffffffffffffff, 0x0, 0x0)\
\t/home/jenkins/agent/workspace/opt

imization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/types/datum.go:565 +0x28c\
github.com/pingcap/tidb/statistics.(*sampleItemSorter).Less(0xc00f6b6900, 0x15, 0x14, 0x1)\

n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/statistics/sample.go:67 +0x68\
sort.insertionSort(0x38b0f00, 0xc00f6b6900, 0x14, 0

x28)\
\t/usr/local/go/src/sort/sort.go:27 +0xc4\
sort.stable(0x38b0f00, 0xc00f6b6900, 0x3e8)\
\t/usr/local/go/src/sort/sort.go:364 +0x51\
sort.Stable(0x38b0f00, 0xc00f6b6900)\
\t/u

sr/local/go/src/sort/sort.go:357 +0x53\
github.com/pingcap/tidb/statistics.SortSampleItems(...)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com

/pingcap/tidb/statistics/sample.go:51\
github.com/pingcap/tidb/statistics.BuildColumnHist(0x39090e0, 0xc0042819e0, 0x100, 0x3, 0xc018a79b00, 0xc0017325a8, 0x7ae, 0xe, 0x0, 0x6, ...

)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/statistics/builder.go:113 +0x1b8\
github.com/pingcap/tidb/statistics.BuildColumn

(0x39090e0, 0xc0042819e0, 0x100, 0x3, 0xc018a79b00, 0xc0017325a8, 0xc001874fc0, 0x12, 0x0)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/ping

cap/tidb/statistics/builder.go:185 +0xa3\
github.com/pingcap/tidb/executor.(*AnalyzeColumnsExec).buildStats(0xc013186e00, 0xc018e05718, 0x1, 0x1, 0xc001381660, 0x2, 0x2, 0xc0013816

70, 0x2, 0x2, ...)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/analyze.go:527 +0xa5f\
github.com/pingcap/tidb/executo

r.analyzeColumnsPushdown(0xc013186e00, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, ...)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingca

p/tidb/executor/analyze.go:379 +0xab\
github.com/pingcap/tidb/executor.(*AnalyzeExec).analyzeWorker(0xc00a0ad560, 0xc018a79800, 0xc018a79860, 0x1)\
\t/home/jenkins/agent/workspace/

optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/analyze.go:195 +0x1ce\
created by github.com/pingcap/tidb/executor.(*AnalyzeExec).Next\
\t/home/jenkins/ag

ent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/analyze.go:87 +0x147\
"]

[2021/04/14 07:50:51.718 +08:00] [ERROR] [update.go:796] ["[stats] auto analyze failed"] [sql="analyze table %n.%n"] [cost_time=22.440662ms] [error="analyze worker panic"]

[2021/04/14 07:50:54.736 +08:00] [ERROR] [analyze.go:172] ["analyze worker panicked"] [stack="goroutine 154777 [running]:\
github.com/pingcap/tidb/executor.(*AnalyzeExec).analyzeWo

rker.func1(0xc01655de60, 0xc018bc9ed8, 0xc018fe67e0, 0x1)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/analyze.go:170

+0xff\
panic(0x3169660, 0xc070e18120)\
\t/usr/local/go/src/runtime/panic.go:679 +0x1b2\
github.com/pingcap/tidb/util/collate.decodeRune(0xc084325fb2, 0x8, 0x7, 0x43e, 0x7)\
\t/home

/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/util/collate/unicode_ci.go:53 +0x111\
github.com/pingcap/tidb/util/collate.(*generalCIColl

ator).Compare(0x54fb878, 0xc084325fb2, 0x8, 0xc084325fa2, 0x8, 0x1bd419f)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/util/col

late/general_ci.go:39 +0xdb\
github.com/pingcap/tidb/types.CompareString(0xc084325fb2, 0x8, 0xc084325fa2, 0x8, 0xc00136dbc0, 0x12, 0xc081ad87f2)\
\t/home/jenkins/agent/workspace/op

timization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/types/compare.go:118 +0x71\
github.com/pingcap/tidb/types.(*Datum).compareString(0xc01425ef60, 0xc00c0f9200, 0xc08432

5fa2, 0x8, 0xc00136dbc0, 0x12, 0x1, 0xc018bc9830, 0x1be0303)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/types/datum.go:665 +0

x112\
github.com/pingcap/tidb/types.(*Datum).CompareDatum(0xc01425ef60, 0xc00c0f9200, 0xc01425eea0, 0xc018bc9940, 0x11b4596, 0xc0a8897c20)\
\t/home/jenkins/agent/workspace/optimiza

tion-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/types/datum.go:565 +0x28c\
github.com/pingcap/tidb/statistics.(*sampleItemSorter).Less(0xc0a8897c20, 0x1, 0x0, 0x30)\
\t/ho

me/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/statistics/sample.go:67 +0x68\
sort.insertionSort(0x38b0f00, 0xc0a8897c20, 0x0, 0x14)\
\

t/usr/local/go/src/sort/sort.go:27 +0xc4\
sort.stable(0x38b0f00, 0xc0a8897c20, 0x3e8)\
\t/usr/local/go/src/sort/sort.go:364 +0x51\
sort.Stable(0x38b0f00, 0xc0a8897c20)\
\t/usr/loca

l/go/src/sort/sort.go:357 +0x53\
github.com/pingcap/tidb/statistics.SortSampleItems(...)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingca

p/tidb/statistics/sample.go:51\
github.com/pingcap/tidb/statistics.BuildColumnHist(0x39090e0, 0xc001e426c0, 0x100, 0x3, 0xc018e0e180, 0xc00169a828, 0x2bb5, 0x11, 0x0, 0x6, ...)\
\t

/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/statistics/builder.go:113 +0x1b8\
github.com/pingcap/tidb/statistics.BuildColumn(0x39

090e0, 0xc001e426c0, 0x100, 0x3, 0xc018e0e180, 0xc00169a828, 0xc00136dbc0, 0x12, 0x0)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/t

idb/statistics/builder.go:185 +0xa3\
github.com/pingcap/tidb/executor.(*AnalyzeColumnsExec).buildStats(0xc00a2b6af0, 0xc0180b7ff0, 0x1, 0x1, 0xc017e051b0, 0x2, 0x2, 0xc017e051c0, 0

x2, 0x2, ...)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/analyze.go:527 +0xa5f\
github.com/pingcap/tidb/executor.ana

lyzeColumnsPushdown(0xc00a2b6af0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, ...)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tid

b/executor/analyze.go:379 +0xab\
github.com/pingcap/tidb/executor.(*AnalyzeExec).analyzeWorker(0xc018fe67e0, 0xc01655de00, 0xc01655de60, 0x1)\
\t/home/jenkins/agent/workspace/optim

ization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/analyze.go:195 +0x1ce\
created by github.com/pingcap/tidb/executor.(*AnalyzeExec).Next\
\t/home/jenkins/agent/w

orkspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/analyze.go:87 +0x147\
"]

[2021/04/14 07:50:54.736 +08:00] [ERROR] [update.go:796] ["[stats] auto analyze failed"] [sql="analyze table %n.%n"] [cost_time=52.42499ms] [error="analyze worker panic"]

若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。

tikv 3节点日志 saas1 saas2 data11 error log

[root@saas1 log]# cat tikv.log.2021-04-14-03\:36\:00.609374145 | grep ERROR

[2021/04/14 03:20:07.565 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:26056: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:07.566 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:20:07.567 +08:00] [ **ERROR** ] [kv.rs:603] ["KvService::batch_raft send response fail"] [err=RemoteStopped]

[2021/04/14 03:20:18.845 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:13716: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:18.850 +08:00] [ **ERROR** ] [kv.rs:603] ["KvService::batch_raft send response fail"] [err=RemoteStopped]

[2021/04/14 03:20:20.593 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:20.610 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:20:33.610 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:33.629 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:20:33.919 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:20:46.629 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:46.643 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:20:46.921 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:46.930 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:20:59.646 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:59.657 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:20:59.930 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:59.943 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:21:12.658 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:21:12.673 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:21:12.943 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:21:12.959 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:21:25.685 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:21:25.695 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:21:25.966 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:21:25.996 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:21:38.695 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:21:38.701 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:21:38.996 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:21:39.008 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:21:51.701 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:21:51.718 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:21:52.016 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:21:52.025 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:22:04.763 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:22:04.781 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:22:05.026 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:22:05.040 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:22:17.802 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:22:17.935 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:22:18.040 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:22:18.053 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:22:30.973 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:22:30.990 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:22:31.053 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:22:31.058 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:22:44.054 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:22:44.065 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:22:44.070 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:22:44.089 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:22:57.065 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:22:57.091 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:22:57.106 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:22:57.109 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:23:10.140 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:23:10.141 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:23:10.158 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:23:10.161 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:23:23.210 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:23:23.210 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:23:23.229 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:23:23.231 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:23:36.272 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:23:36.273 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:23:36.280 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:23:36.284 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:23:49.287 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:23:49.287 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:23:49.294 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:23:49.297 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:24:02.297 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:24:02.298 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:24:02.304 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:24:02.308 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:24:15.308 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:24:15.309 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:24:15.319 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:24:15.324 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:24:28.324 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:24:28.324 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:24:28.343 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:24:28.346 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:24:41.347 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:24:41.347 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:24:41.361 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:24:41.363 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:24:54.364 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:24:54.365 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:24:54.376 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:24:54.379 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:25:07.379 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:25:07.380 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:25:07.406 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:25:07.408 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:25:20.408 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:25:20.409 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:25:20.421 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:25:20.423 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:25:33.423 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:25:33.424 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:25:33.435 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:25:33.438 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:25:46.439 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:25:46.439 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:25:46.453 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:25:46.455 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:25:59.456 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:25:59.456 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:25:59.467 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:25:59.470 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:26:12.472 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:26:12.473 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:26:12.483 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:26:12.486 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:26:25.486 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:26:25.486 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:26:25.496 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:26:25.547 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:26:38.496 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:26:38.512 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:26:38.547 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.32:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:26:38.562 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:26:51.513 +08:00] [ **ERROR** ] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:26:51.529 +08:00] [ **ERROR** ] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]



[root@saas1 log]#

[root@saas2 log]# cat tikv.log| grep ERROR

[2021/04/14 03:20:07.588 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.13:16868: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:10.426 +08:00] [ERROR] [transport.rs:163] ["send raft msg err"] [err="Other(\"[src/server/raft_client.rs:208]: RaftClient send fail\")"]

[2021/04/14 03:20:18.437 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.32:27264: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:18.721 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.13:17352: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:18.745 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.31:17914: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:23.669 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.13:9385: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:25.369 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.13:17350: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:25.468 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.32:27258: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:25.481 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.31:17910: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:25.511 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.31:17912: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:30.360 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.13:17354: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:30.503 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.32:27260: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:35.374 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.13:17356: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:35.508 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.32:27262: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:35.625 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.31:13478: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:35.659 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.31:17916: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:23:37.867 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.32:9379: Keepalive watchdog fired. Closing transport."]

[root@saas2 log]#


[tidb@data11 log]$ cat tikv.log | grep ERROR

[2021/04/14 03:20:07.274 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.13:46232: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:07.276 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.13:46230: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:07.412 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.31:16870: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:07.412 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.32:43140: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:07.522 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.31:11098: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:07.613 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.31:16876: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:07.779 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.32:43144: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:07.835 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.32:42414: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:12.100 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.13:46228: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:13.153 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.31:16874: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:13.207 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.32:43142: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:23.915 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.32:43138: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:25.373 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.13:39980: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:25.378 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.13:46226: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:25.427 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.13:40106: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:25.496 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.31:16872: Keepalive watchdog fired. Closing transport."]

[2021/04/14 03:20:57.026 +08:00] [ERROR] [<unknown>] ["ipv4:192.168.254.32:9379: Keepalive watchdog fired. Closing transport."]

  1. 重新启动 tikv 节点可以拉起来么
  2. 在 tikv.log 中 grep -i fatal 和 panic 关键字看有没有信息
  3. 看下 tikv_stderr.log 文件中有没有什么信息

1 目前整个集群重启后正常使用
还有一个报警持续:

increase(tidb_server_panic_total[10m]) > 0

{instance="192.168.254.32:9384",job="tidb",type="analyze"} ==== 196.9230769230769

2 没有fatal日志, 有panic关键字 但是是info级别的日志 时间也不太对, 进程应该是活着 就是卡死了

[root@data11 log]# cat tikv.log| grep panic
[2021/04/14 07:48:49.189 +08:00] [INFO] [server.rs:212] ["using config"] [config="{\"log-level\":\"info\",\"log-file\":\"/data/tidb-deploy-v2/tikv-9385/log/tikv.log\",\"log-format\":\"text\",\"slow-log-file\":\"\",\"slow-log-threshold\":\"1s\",\"log-rotation-timespan\":\"1d\",\"log-rotation-size\":\"300MiB\",\"panic-when-unexpected-key-or-data\":false,\"readpool\":{\"unified\":{\"min-thread-count\":1,\"max-thread-count\":57,\"stack-size\":\"10MiB\",\"max-tasks-per-worker\":2000},\"storage\":{\"use-unified-pool\":false,\"high-concurrency\":8,\"normal-concurrency\":8,\"low-concurrency\":8,\"max-tasks-per-worker-high\":2000,\"max-tasks-per-worker-normal\":2000,\"max-tasks-per-worker-low\":2000,\"stack-size\":\"10MiB\"},\"coprocessor\":{\"use-unified-pool\":true,\"high-concurrency\":57,\"normal-concurrency\":57,\"low-concurrency\":57,\"max-tasks-per-worker-high\":2000,\"max-tasks-per-worker-normal\":2000,\"max-tasks-per-worker-low\":2000,\"stack-size\":\"10MiB\"}},\"server\":{\"addr\":\"0.0.0.0:9385\",\"advertise-addr\":\"192.168.254.13:9385\",\"status-addr\":\"0.0.0.0:9386\",\"advertise-status-addr\":\"192.168.254.13:9386\",\"status-thread-pool-size\":1,\"max-grpc-send-msg-len\":10485760,\"grpc-compression-type\":\"none\",\"grpc-concurrency\":4,\"grpc-concurrent-stream\":1024,\"grpc-raft-conn-num\":1,\"grpc-memory-pool-quota\":9223372036854775807,\"grpc-stream-initial-window-size\":\"2MiB\",\"grpc-keepalive-time\":\"10s\",\"grpc-keepalive-timeout\":\"3s\",\"concurrent-send-snap-limit\":32,\"concurrent-recv-snap-limit\":32,\"end-point-recursion-limit\":1000,\"end-point-stream-channel-size\":8,\"end-point-batch-row-limit\":64,\"end-point-stream-batch-row-limit\":128,\"end-point-enable-batch-if-possible\":true,\"end-point-request-max-handle-duration\":\"1m\",\"end-point-max-concurrency\":72,\"snap-max-write-bytes-per-sec\":\"100MiB\",\"snap-max-total-size\":\"0KiB\",\"stats-concurrency\":1,\"heavy-load-threshold\":300,\"heavy-load-wait-duration\":\"1ms\",\"enable-request-batch\":true,\"request-batch-enable-cross-command\":false,\"request-batch-wait-duration\":\"1ms\",\"end-point-slow-log-threshold\":\"1s\",\"labels\":{}},\"storage\":{\"data-dir\":\"/data/tidb-data-v2/tikv-9385\",\"gc-ratio-threshold\":1.1,\"max-key-size\":4096,\"scheduler-concurrency\":524288,\"scheduler-worker-pool-size\":8,\"scheduler-pending-write-threshold\":\"100MiB\",\"reserve-space\":\"2GiB\",\"block-cache\":{\"shared\":true,\"capacity\":\"20GiB\",\"num-shard-bits\":6,\"strict-capacity-limit\":false,\"high-pri-pool-ratio\":0.8,\"memory-allocator\":\"nodump\"}},\"pd\":{\"endpoints\":[\"192.168.254.13:9379\",\"192.168.254.31:9379\",\"192.168.254.32:9379\"],\"retry-interval\":\"300ms\",\"retry-max-count\":9223372036854775807,\"retry-log-every\":10,\"update-interval\":\"10m\"},\"metric\":{\"interval\":\"15s\",\"address\":\"\",\"job\":\"tikv\"},\"raftstore\":{\"sync-log\":true,\"prevote\":true,\"raftdb-path\":\"/data/tidb-data-v2/tikv-9385/raft\",\"capacity\":\"0KiB\",\"raft-base-tick-interval\":\"1s\",\"raft-heartbeat-ticks\":2,\"raft-election-timeout-ticks\":10,\"raft-min-election-timeout-ticks\":10,\"raft-max-election-timeout-ticks\":20,\"raft-max-size-per-msg\":\"1MiB\",\"raft-max-inflight-msgs\":256,\"raft-entry-max-size\":\"8MiB\",\"raft-log-gc-tick-interval\":\"10s\",\"raft-log-gc-threshold\":50,\"raft-log-gc-count-limit\":73728,\"raft-log-gc-size-limit\":\"72MiB\",\"raft-entry-cache-life-time\":\"30s\",\"raft-reject-transfer-leader-duration\":\"3s\",\"split-region-check-tick-interval\":\"10s\",\"region-split-check-diff\":\"6MiB\",\"region-compact-check-interval\":\"5m\",\"region-compact-check-step\":100,\"region-compact-min-tombstones\":10000,\"region-compact-tombstones-percent\":30,\"pd-heartbeat-tick-interval\":\"1m\",\"pd-store-heartbeat-tick-interval\":\"10s\",\"snap-mgr-gc-tick-interval\":\"1m\",\"snap-gc-timeout\":\"4h\",\"lock-cf-compact-interval\":\"10m\",\"lock-cf-compact-bytes-threshold\":\"256MiB\",\"notify-capacity\":40960,\"messages-per-tick\":4096,\"max-peer-down-duration\":\"5m\",\"max-leader-missing-duration\":\"2h\",\"abnormal-leader-missing-duration\":\"10m\",\"peer-stale-state-check-interval\":\"5m\",\"leader-transfer-max-log-lag\":128,\"snap-apply-batch-size\":\"10MiB\",\"consistency-check-interval\":\"0s\",\"report-region-flow-interval\":\"1m\",\"raft-store-max-leader-lease\":\"9s\",\"right-derive-when-split\":true,\"allow-remove-leader\":false,\"merge-max-log-gap\":10,\"merge-check-tick-interval\":\"10s\",\"use-delete-range\":false,\"cleanup-import-sst-interval\":\"10m\",\"local-read-batch-size\":1024,\"apply-max-batch-size\":1024,\"apply-pool-size\":2,\"apply-reschedule-duration\":\"5s\",\"store-max-batch-size\":1024,\"store-pool-size\":2,\"store-reschedule-duration\":\"5s\",\"future-poll-size\":1,\"hibernate-regions\":false,\"hibernate-timeout\":\"10m\",\"early-apply\":true,\"dev-assert\":false,\"apply-yield-duration\":\"500ms\",\"perf-level\":1},\"coprocessor\":{\"split-region-on-table\":false,\"batch-split-limit\":10,\"region-max-size\":\"144MiB\",\"region-split-size\":\"96MiB\",\"region-max-keys\":1440000,\"region-split-keys\":960000},\"rocksdb\":{\"wal-recovery-mode\":2,\"wal-dir\":\"\",\"wal-ttl-seconds\":0,\"wal-size-limit\":\"0KiB\",\"max-total-wal-size\":\"4GiB\",\"max-background-jobs\":8,\"max-background-flushes\":2,\"max-manifest-file-size\":\"128MiB\",\"create-if-missing\":true,\"max-open-files\":40960,\"enable-statistics\":true,\"stats-dump-period\":\"10m\",\"compaction-readahead-size\":\"0KiB\",\"info-log-max-size\":\"1GiB\",\"info-log-roll-time\":\"0s\",\"info-log-keep-log-file-num\":10,\"info-log-dir\":\"\",\"rate-bytes-per-sec\":\"0KiB\",\"rate-limiter-mode\":2,\"auto-tuned\":false,\"bytes-per-sync\":\"1MiB\",\"wal-bytes-per-sync\":\"512KiB\",\"max-sub-compactions\":3,\"writable-file-max-buffer-size\":\"1MiB\",\"use-direct-io-for-flush-and-compaction\":false,\"enable-pipelined-write\":true,\"enable-multi-batch-write\":true,\"enable-unordered-write\":false,\"defaultcf\":{\"block-size\":\"64KiB\",\"block-cache-size\":\"47962MiB\",\"disable-block-cache\":false,\"cache-index-and-filter-blocks\":true,\"pin-l0-filter-and-index-blocks\":true,\"use-bloom-filter\":true,\"optimize-filters-for-hits\":true,\"whole-key-filtering\":true,\"bloom-filter-bits-per-key\":10,\"block-based-bloom-filter\":false,\"read-amp-bytes-per-bit\":0,\"compression-per-level\":[\"no\",\"no\",\"lz4\",\"lz4\",\"lz4\",\"zstd\",\"zstd\"],\"write-buffer-size\":\"128MiB\",\"max-write-buffer-number\":5,\"min-write-buffer-number-to-merge\":1,\"max-bytes-for-level-base\":\"512MiB\",\"target-file-size-base\":\"8MiB\",\"level0-file-num-compaction-trigger\":4,\"level0-slowdown-writes-trigger\":20,\"level0-stop-writes-trigger\":36,\"max-compaction-bytes\":\"2GiB\",\"compaction-pri\":3,\"dynamic-level-bytes\":true,\"num-levels\":7,\"max-bytes-for-level-multiplier\":10,\"compaction-style\":0,\"disable-auto-compactions\":false,\"soft-pending-compaction-bytes-limit\":\"64GiB\",\"hard-pending-compaction-bytes-limit\":\"256GiB\",\"force-consistency-checks\":false,\"prop-size-index-distance\":4194304,\"prop-keys-index-distance\":40960,\"enable-doubly-skiplist\":true,\"titan\":{\"min-blob-size\":\"1KiB\",\"blob-file-compression\":\"lz4\",\"blob-cache-size\":\"0KiB\",\"min-gc-batch-size\":\"16MiB\",\"max-gc-batch-size\":\"64MiB\",\"discardable-ratio\":0.5,\"sample-ratio\":0.1,\"merge-small-file-threshold\":\"8MiB\",\"blob-run-mode\":\"normal\",\"level-merge\":false,\"range-merge\":true,\"max-sorted-runs\":20,\"gc-merge-rewrite\":false}},\"writecf\":{\"block-size\":\"64KiB\",\"block-cache-size\":\"28777MiB\",\"disable-block-cache\":false,\"cache-index-and-filter-blocks\":true,\"pin-l0-filter-and-index-blocks\":true,\"use-bloom-filter\":true,\"optimize-filters-for-hits\":false,\"whole-key-filtering\":false,\"bloom-filter-bits-per-key\":10,\"block-based-bloom-filter\":false,\"read-amp-bytes-per-bit\":0,\"compression-per-level\":[\"no\",\"no\",\"lz4\",\"lz4\",\"lz4\",\"zstd\",\"zstd\"],\"write-buffer-size\":\"128MiB\",\"max-write-buffer-number\":5,\"min-write-buffer-number-to-merge\":1,\"max-bytes-for-level-base\":\"512MiB\",\"target-file-size-base\":\"8MiB\",\"level0-file-num-compaction-trigger\":4,\"level0-slowdown-writes-trigger\":20,\"level0-stop-writes-trigger\":36,\"max-compaction-bytes\":\"2GiB\",\"compaction-pri\":3,\"dynamic-level-bytes\":true,\"num-levels\":7,\"max-bytes-for-level-multiplier\":10,\"compaction-style\":0,\"disable-auto-compactions\":false,\"soft-pending-compaction-bytes-limit\":\"64GiB\",\"hard-pending-compaction-bytes-limit\":\"256GiB\",\"force-consistency-checks\":false,\"prop-size-index-distance\":4194304,\"prop-keys-index-distance\":40960,\"enable-doubly-skiplist\":true,\"titan\":{\"min-blob-size\":\"1KiB\",\"blob-file-compression\":\"lz4\",\"blob-cache-size\":\"0KiB\",\"min-gc-batch-size\":\"16MiB\",\"max-gc-batch-size\":\"64MiB\",\"discardable-ratio\":0.5,\"sample-ratio\":0.1,\"merge-small-file-threshold\":\"8MiB\",\"blob-run-mode\":\"read-only\",\"level-merge\":false,\"range-merge\":true,\"max-sorted-runs\":20,\"gc-merge-rewrite\":false}},\"lockcf\":{\"block-size\":\"16KiB\",\"block-cache-size\":\"1GiB\",\"disable-block-cache\":false,\"cache-index-and-filter-blocks\":true,\"pin-l0-filter-and-index-blocks\":true,\"use-bloom-filter\":true,\"optimize-filters-for-hits\":false,\"whole-key-filtering\":true,\"bloom-filter-bits-per-key\":10,\"block-based-bloom-filter\":false,\"read-amp-bytes-per-bit\":0,\"compression-per-level\":[\"no\",\"no\",\"no\",\"no\",\"no\",\"no\",\"no\"],\"write-buffer-size\":\"32MiB\",\"max-write-buffer-number\":5,\"min-write-buffer-number-to-merge\":1,\"max-bytes-for-level-base\":\"128MiB\",\"target-file-size-base\":\"8MiB\",\"level0-file-num-compaction-trigger\":1,\"level0-slowdown-writes-trigger\":20,\"level0-stop-writes-trigger\":36,\"max-compaction-bytes\":\"2GiB\",\"compaction-pri\":0,\"dynamic-level-bytes\":true,\"num-levels\":7,\"max-bytes-for-level-multiplier\":10,\"compaction-style\":0,\"disable-auto-compactions\":false,\"soft-pending-compaction-bytes-limit\":\"64GiB\",\"hard-pending-compaction-bytes-limit\":\"256GiB\",\"force-consistency-checks\":false,\"prop-size-index-distance\":4194304,\"prop-keys-index-distance\":40960,\"enable-doubly-skiplist\":true,\"titan\":{\"min-blob-size\":\"1KiB\",\"blob-file-compression\":\"lz4\",\"blob-cache-size\":\"0KiB\",\"min-gc-batch-size\":\"16MiB\",\"max-gc-batch-size\":\"64MiB\",\"discardable-ratio\":0.5,\"sample-ratio\":0.1,\"merge-small-file-threshold\":\"8MiB\",\"blob-run-mode\":\"read-only\",\"level-merge\":false,\"range-merge\":true,\"max-sorted-runs\":20,\"gc-merge-rewrite\":false}},\"raftcf\":{\"block-size\":\"16KiB\",\"block-cache-size\":\"128MiB\",\"disable-block-cache\":false,\"cache-index-and-filter-blocks\":true,\"pin-l0-filter-and-index-blocks\":true,\"use-bloom-filter\":true,\"optimize-filters-for-hits\":true,\"whole-key-filtering\":true,\"bloom-filter-bits-per-key\":10,\"block-based-bloom-filter\":false,\"read-amp-bytes-per-bit\":0,\"compression-per-level\":[\"no\",\"no\",\"no\",\"no\",\"no\",\"no\",\"no\"],\"write-buffer-size\":\"128MiB\",\"max-write-buffer-number\":5,\"min-write-buffer-number-to-merge\":1,\"max-bytes-for-level-base\":\"128MiB\",\"target-file-size-base\":\"8MiB\",\"level0-file-num-compaction-trigger\":1,\"level0-slowdown-writes-trigger\":20,\"level0-stop-writes-trigger\":36,\"max-compaction-bytes\":\"2GiB\",\"compaction-pri\":0,\"dynamic-level-bytes\":true,\"num-levels\":7,\"max-bytes-for-level-multiplier\":10,\"compaction-style\":0,\"disable-auto-compactions\":false,\"soft-pending-compaction-bytes-limit\":\"64GiB\",\"hard-pending-compaction-bytes-limit\":\"256GiB\",\"force-consistency-checks\":false,\"prop-size-index-distance\":4194304,\"prop-keys-index-distance\":40960,\"enable-doubly-skiplist\":true,\"titan\":{\"min-blob-size\":\"1KiB\",\"blob-file-compression\":\"lz4\",\"blob-cache-size\":\"0KiB\",\"min-gc-batch-size\":\"16MiB\",\"max-gc-batch-size\":\"64MiB\",\"discardable-ratio\":0.5,\"sample-ratio\":0.1,\"merge-small-file-threshold\":\"8MiB\",\"blob-run-mode\":\"read-only\",\"level-merge\":false,\"range-merge\":true,\"max-sorted-runs\":20,\"gc-merge-rewrite\":false}},\"titan\":{\"enabled\":false,\"dirname\":\"\",\"disable-gc\":false,\"max-background-gc\":4,\"purge-obsolete-files-period\":\"10s\"}},\"raftdb\":{\"wal-recovery-mode\":2,\"wal-dir\":\"\",\"wal-ttl-seconds\":0,\"wal-size-limit\":\"0KiB\",\"max-total-wal-size\":\"4GiB\",\"max-background-jobs\":4,\"max-background-flushes\":1,\"max-manifest-file-size\":\"20MiB\",\"create-if-missing\":true,\"max-open-files\":40960,\"enable-statistics\":true,\"stats-dump-period\":\"10m\",\"compaction-readahead-size\":\"0KiB\",\"info-log-max-size\":\"1GiB\",\"info-log-roll-time\":\"0s\",\"info-log-keep-log-file-num\":10,\"info-log-dir\":\"\",\"max-sub-compactions\":2,\"writable-file-max-buffer-size\":\"1MiB\",\"use-direct-io-for-flush-and-compaction\":false,\"enable-pipelined-write\":true,\"enable-unordered-write\":false,\"allow-concurrent-memtable-write\":true,\"bytes-per-sync\":\"1MiB\",\"wal-bytes-per-sync\":\"512KiB\",\"defaultcf\":{\"block-size\":\"64KiB\",\"block-cache-size\":\"2GiB\",\"disable-block-cache\":false,\"cache-index-and-filter-blocks\":true,\"pin-l0-filter-and-index-blocks\":true,\"use-bloom-filter\":false,\"optimize-filters-for-hits\":true,\"whole-key-filtering\":true,\"bloom-filter-bits-per-key\":10,\"block-based-bloom-filter\":false,\"read-amp-bytes-per-bit\":0,\"compression-per-level\":[\"no\",\"no\",\"lz4\",\"lz4\",\"lz4\",\"zstd\",\"zstd\"],\"write-buffer-size\":\"128MiB\",\"max-write-buffer-number\":5,\"min-write-buffer-number-to-merge\":1,\"max-bytes-for-level-base\":\"512MiB\",\"target-file-size-base\":\"8MiB\",\"level0-file-num-compaction-trigger\":4,\"level0-slowdown-writes-trigger\":20,\"level0-stop-writes-trigger\":36,\"max-compaction-bytes\":\"2GiB\",\"compaction-pri\":0,\"dynamic-level-bytes\":true,\"num-levels\":7,\"max-bytes-for-level-multiplier\":10,\"compaction-style\":0,\"disable-auto-compactions\":false,\"soft-pending-compaction-bytes-limit\":\"64GiB\",\"hard-pending-compaction-bytes-limit\":\"256GiB\",\"force-consistency-checks\":false,\"prop-size-index-distance\":4194304,\"prop-keys-index-distance\":40960,\"enable-doubly-skiplist\":true,\"titan\":{\"min-blob-size\":\"1KiB\",\"blob-file-compression\":\"lz4\",\"blob-cache-size\":\"0KiB\",\"min-gc-batch-size\":\"16MiB\",\"max-gc-batch-size\":\"64MiB\",\"discardable-ratio\":0.5,\"sample-ratio\":0.1,\"merge-small-file-threshold\":\"8MiB\",\"blob-run-mode\":\"normal\",\"level-merge\":false,\"range-merge\":true,\"max-sorted-runs\":20,\"gc-merge-rewrite\":false}},\"titan\":{\"enabled\":false,\"dirname\":\"\",\"disable-gc\":false,\"max-background-gc\":4,\"purge-obsolete-files-period\":\"10s\"}},\"security\":{\"ca-path\":\"\",\"cert-path\":\"\",\"key-path\":\"\",\"cert-allowed-cn\":[],\"redact-info-log\":null,\"encryption\":{\"data-encryption-method\":\"plaintext\",\"data-key-rotation-period\":\"7d\",\"enable-file-dictionary-log\":true,\"file-dictionary-rewrite-threshold\":1000000,\"master-key\":{\"type\":\"plaintext\"},\"previous-master-key\":{\"type\":\"plaintext\"}}},\"import\":{\"num-threads\":8,\"stream-channel-window\":128},\"backup\":{\"num-threads\":32,\"batch-size\":8,\"sst-max-size\":\"144MiB\"},\"pessimistic-txn\":{\"enabled\":true,\"wait-for-lock-timeout\":\"1s\",\"wake-up-delay-duration\":\"20ms\",\"pipelined\":false},\"gc\":{\"ratio-threshold\":1.1,\"batch-keys\":512,\"max-write-bytes-per-sec\":\"0KiB\"},\"split\":{\"qps-threshold\":3000,\"split-balance-score\":0.25,\"split-contained-score\":0.5,\"detect-times\":10,\"sample-num\":20,\"sample-threshold\":100,\"size-threshold\":4194304,\"key-threshold\":40960},\"cdc\":{\"min-ts-interval\":\"1s\"}}"]

[2021/04/14 07:48:49.226 +08:00] [INFO] [server.rs:212] ["using config"] [config="{\"log-level\":\"info\",\"log-file\":\"/data/tidb-deploy-v2/tikv-9385/log/tikv.log\",\"log-format\":\"text\",\"slow-log-file\":\"\",\"slow-log-threshold\":\"1s\",\"log-rotation-timespan\":\"1d\",\"log-rotation-size\":\"300MiB\",\"panic-when-unexpected-key-or-data\":false,\"readpool\":{\"unified\":{\"min-thread-count\":1,\"max-thread-count\":57,\"stack-size\":\"10MiB\",\"max-tasks-per-worker\":2000},\"storage\":{\"use-unified-pool\":false,\"high-concurrency\":8,\"normal-concurrency\":8,\"low-concurrency\":8,\"max-tasks-per-worker-high\":2000,\"max-tasks-per-worker-normal\":2000,\"max-tasks-per-worker-low\":2000,\"stack-size\":\"10MiB\"},\"coprocessor\":{\"use-unified-pool\":true,\"high-concurrency\":57,\"normal-concurrency\":57,\"low-concurrency\":57,\"max-tasks-per-worker-high\":2000,\"max-tasks-per-worker-normal\":2000,\"max-tasks-per-worker-low\":2000,\"stack-size\":\"10MiB\"}},\"server\":{\"addr\":\"0.0.0.0:9385\",\"advertise-addr\":\"192.168.254.31:9385\",\"status-addr\":\"0.0.0.0:9386\",\"advertise-status-addr\":\"192.168.254.31:9386\",\"status-thread-pool-size\":1,\"max-grpc-send-msg-len\":10485760,\"grpc-compression-type\":\"none\",\"grpc-concurrency\":4,\"grpc-concurrent-stream\":1024,\"grpc-raft-conn-num\":1,\"grpc-memory-pool-quota\":9223372036854775807,\"grpc-stream-initial-window-size\":\"2MiB\",\"grpc-keepalive-time\":\"10s\",\"grpc-keepalive-timeout\":\"3s\",\"concurrent-send-snap-limit\":32,\"concurrent-recv-snap-limit\":32,\"end-point-recursion-limit\":1000,\"end-point-stream-channel-size\":8,\"end-point-batch-row-limit\":64,\"end-point-stream-batch-row-limit\":128,\"end-point-enable-batch-if-possible\":true,\"end-point-request-max-handle-duration\":\"1m\",\"end-point-max-concurrency\":72,\"snap-max-write-bytes-per-sec\":\"100MiB\",\"snap-max-total-size\":\"0KiB\",\"stats-concurrency\":1,\"heavy-load-threshold\":300,\"heavy-load-wait-duration\":\"1ms\",\"enable-request-batch\":true,\"request-batch-enable-cross-command\":false,\"request-batch-wait-duration\":\"1ms\",\"end-point-slow-log-threshold\":\"1s\",\"labels\":{}},\"storage\":{\"data-dir\":\"/data/tidb-data-v2/tikv-9385\",\"gc-ratio-threshold\":1.1,\"max-key-size\":4096,\"scheduler-concurrency\":524288,\"scheduler-worker-pool-size\":8,\"scheduler-pending-write-threshold\":\"100MiB\",\"reserve-space\":\"2GiB\",\"block-cache\":{\"shared\":true,\"capacity\":\"20GiB\",\"num-shard-bits\":6,\"strict-capacity-limit\":false,\"high-pri-pool-ratio\":0.8,\"memory-allocator\":\"nodump\"}},\"pd\":{\"endpoints\":[\"192.168.254.13:9379\",\"192.168.254.31:9379\",\"192.168.254.32:9379\"],\"retry-interval\":\"300ms\",\"retry-max-count\":9223372036854775807,\"retry-log-every\":10,\"update-interval\":\"10m\"},\"metric\":{\"interval\":\"15s\",\"address\":\"\",\"job\":\"tikv\"},\"raftstore\":{\"sync-log\":true,\"prevote\":true,\"raftdb-path\":\"/data/tidb-data-v2/tikv-9385/raft\",\"capacity\":\"0KiB\",\"raft-base-tick-interval\":\"1s\",\"raft-heartbeat-ticks\":2,\"raft-election-timeout-ticks\":10,\"raft-min-election-timeout-ticks\":10,\"raft-max-election-timeout-ticks\":20,\"raft-max-size-per-msg\":\"1MiB\",\"raft-max-inflight-msgs\":256,\"raft-entry-max-size\":\"8MiB\",\"raft-log-gc-tick-interval\":\"10s\",\"raft-log-gc-threshold\":50,\"raft-log-gc-count-limit\":73728,\"raft-log-gc-size-limit\":\"72MiB\",\"raft-entry-cache-life-time\":\"30s\",\"raft-reject-transfer-leader-duration\":\"3s\",\"split-region-check-tick-interval\":\"10s\",\"region-split-check-diff\":\"6MiB\",\"region-compact-check-interval\":\"5m\",\"region-compact-check-step\":100,\"region-compact-min-tombstones\":10000,\"region-compact-tombstones-percent\":30,\"pd-heartbeat-tick-interval\":\"1m\",\"pd-store-heartbeat-tick-interval\":\"10s\",\"snap-mgr-gc-tick-interval\":\"1m\",\"snap-gc-timeout\":\"4h\",\"lock-cf-compact-interval\":\"10m\",\"lock-cf-compact-bytes-threshold\":\"256MiB\",\"notify-capacity\":40960,\"messages-per-tick\":4096,\"max-peer-down-duration\":\"5m\",\"max-leader-missing-duration\":\"2h\",\"abnormal-leader-missing-duration\":\"10m\",\"peer-stale-state-check-interval\":\"5m\",\"leader-transfer-max-log-lag\":128,\"snap-apply-batch-size\":\"10MiB\",\"consistency-check-interval\":\"0s\",\"report-region-flow-interval\":\"1m\",\"raft-store-max-leader-lease\":\"9s\",\"right-derive-when-split\":true,\"allow-remove-leader\":false,\"merge-max-log-gap\":10,\"merge-check-tick-interval\":\"10s\",\"use-delete-range\":false,\"cleanup-import-sst-interval\":\"10m\",\"local-read-batch-size\":1024,\"apply-max-batch-size\":1024,\"apply-pool-size\":2,\"apply-reschedule-duration\":\"5s\",\"store-max-batch-size\":1024,\"store-pool-size\":2,\"store-reschedule-duration\":\"5s\",\"future-poll-size\":1,\"hibernate-regions\":false,\"hibernate-timeout\":\"10m\",\"early-apply\":true,\"dev-assert\":false,\"apply-yield-duration\":\"500ms\",\"perf-level\":1},\"coprocessor\":{\"split-region-on-table\":false,\"batch-split-limit\":10,\"region-max-size\":\"144MiB\",\"region-split-size\":\"96MiB\",\"region-max-keys\":1440000,\"region-split-keys\":960000},\"rocksdb\":{\"wal-recovery-mode\":2,\"wal-dir\":\"\",\"wal-ttl-seconds\":0,\"wal-size-limit\":\"0KiB\",\"max-total-wal-size\":\"4GiB\",\"max-background-jobs\":8,\"max-background-flushes\":2,\"max-manifest-file-size\":\"128MiB\",\"create-if-missing\":true,\"max-open-files\":40960,\"enable-statistics\":true,\"stats-dump-period\":\"10m\",\"compaction-readahead-size\":\"0KiB\",\"info-log-max-size\":\"1GiB\",\"info-log-roll-time\":\"0s\",\"info-log-keep-log-file-num\":10,\"info-log-dir\":\"\",\"rate-bytes-per-sec\":\"0KiB\",\"rate-limiter-mode\":2,\"auto-tuned\":false,\"bytes-per-sync\":\"1MiB\",\"wal-bytes-per-sync\":\"512KiB\",\"max-sub-compactions\":3,\"writable-file-max-buffer-size\":\"1MiB\",\"use-direct-io-for-flush-and-compaction\":false,\"enable-pipelined-write\":true,\"enable-multi-batch-write\":true,\"enable-unordered-write\":false,\"defaultcf\":{\"block-size\":\"64KiB\",\"block-cache-size\":\"47962MiB\",\"disable-block-cache\":false,\"cache-index-and-filter-blocks\":true,\"pin-l0-filter-and-index-blocks\":true,\"use-bloom-filter\":true,\"optimize-filters-for-hits\":true,\"whole-key-filtering\":true,\"bloom-filter-bits-per-key\":10,\"block-based-bloom-filter\":false,\"read-amp-bytes-per-bit\":0,\"compression-per-level\":[\"no\",\"no\",\"lz4\",\"lz4\",\"lz4\",\"zstd\",\"zstd\"],\"write-buffer-size\":\"128MiB\",\"max-write-buffer-number\":5,\"min-write-buffer-number-to-merge\":1,\"max-bytes-for-level-base\":\"512MiB\",\"target-file-size-base\":\"8MiB\",\"level0-file-num-compaction-trigger\":4,\"level0-slowdown-writes-trigger\":20,\"level0-stop-writes-trigger\":36,\"max-compaction-bytes\":\"2GiB\",\"compaction-pri\":3,\"dynamic-level-bytes\":true,\"num-levels\":7,\"max-bytes-for-level-multiplier\":10,\"compaction-style\":0,\"disable-auto-compactions\":false,\"soft-pending-compaction-bytes-limit\":\"64GiB\",\"hard-pending-compaction-bytes-limit\":\"256GiB\",\"force-consistency-checks\":false,\"prop-size-index-distance\":4194304,\"prop-keys-index-distance\":40960,\"enable-doubly-skiplist\":true,\"titan\":{\"min-blob-size\":\"1KiB\",\"blob-file-compression\":\"lz4\",\"blob-cache-size\":\"0KiB\",\"min-gc-batch-size\":\"16MiB\",\"max-gc-batch-size\":\"64MiB\",\"discardable-ratio\":0.5,\"sample-ratio\":0.1,\"merge-small-file-threshold\":\"8MiB\",\"blob-run-mode\":\"normal\",\"level-merge\":false,\"range-merge\":true,\"max-sorted-runs\":20,\"gc-merge-rewrite\":false}},\"writecf\":{\"block-size\":\"64KiB\",\"block-cache-size\":\"28777MiB\",\"disable-block-cache\":false,\"cache-index-and-filter-blocks\":true,\"pin-l0-filter-and-index-blocks\":true,\"use-bloom-filter\":true,\"optimize-filters-for-hits\":false,\"whole-key-filtering\":false,\"bloom-filter-bits-per-key\":10,\"block-based-bloom-filter\":false,\"read-amp-bytes-per-bit\":0,\"compression-per-level\":[\"no\",\"no\",\"lz4\",\"lz4\",\"lz4\",\"zstd\",\"zstd\"],\"write-buffer-size\":\"128MiB\",\"max-write-buffer-number\":5,\"min-write-buffer-number-to-merge\":1,\"max-bytes-for-level-base\":\"512MiB\",\"target-file-size-base\":\"8MiB\",\"level0-file-num-compaction-trigger\":4,\"level0-slowdown-writes-trigger\":20,\"level0-stop-writes-trigger\":36,\"max-compaction-bytes\":\"2GiB\",\"compaction-pri\":3,\"dynamic-level-bytes\":true,\"num-levels\":7,\"max-bytes-for-level-multiplier\":10,\"compaction-style\":0,\"disable-auto-compactions\":false,\"soft-pending-compaction-bytes-limit\":\"64GiB\",\"hard-pending-compaction-bytes-limit\":\"256GiB\",\"force-consistency-checks\":false,\"prop-size-index-distance\":4194304,\"prop-keys-index-distance\":40960,\"enable-doubly-skiplist\":true,\"titan\":{\"min-blob-size\":\"1KiB\",\"blob-file-compression\":\"lz4\",\"blob-cache-size\":\"0KiB\",\"min-gc-batch-size\":\"16MiB\",\"max-gc-batch-size\":\"64MiB\",\"discardable-ratio\":0.5,\"sample-ratio\":0.1,\"merge-small-file-threshold\":\"8MiB\",\"blob-run-mode\":\"read-only\",\"level-merge\":false,\"range-merge\":true,\"max-sorted-runs\":20,\"gc-merge-rewrite\":false}},\"lockcf\":{\"block-size\":\"16KiB\",\"block-cache-size\":\"1GiB\",\"disable-block-cache\":false,\"cache-index-and-filter-blocks\":true,\"pin-l0-filter-and-index-blocks\":true,\"use-bloom-filter\":true,\"optimize-filters-for-hits\":false,\"whole-key-filtering\":true,\"bloom-filter-bits-per-key\":10,\"block-based-bloom-filter\":false,\"read-amp-bytes-per-bit\":0,\"compression-per-level\":[\"no\",\"no\",\"no\",\"no\",\"no\",\"no\",\"no\"],\"write-buffer-size\":\"32MiB\",\"max-write-buffer-number\":5,\"min-write-buffer-number-to-merge\":1,\"max-bytes-for-level-base\":\"128MiB\",\"target-file-size-base\":\"8MiB\",\"level0-file-num-compaction-trigger\":1,\"level0-slowdown-writes-trigger\":20,\"level0-stop-writes-trigger\":36,\"max-compaction-bytes\":\"2GiB\",\"compaction-pri\":0,\"dynamic-level-bytes\":true,\"num-levels\":7,\"max-bytes-for-level-multiplier\":10,\"compaction-style\":0,\"disable-auto-compactions\":false,\"soft-pending-compaction-bytes-limit\":\"64GiB\",\"hard-pending-compaction-bytes-limit\":\"256GiB\",\"force-consistency-checks\":false,\"prop-size-index-distance\":4194304,\"prop-keys-index-distance\":40960,\"enable-doubly-skiplist\":true,\"titan\":{\"min-blob-size\":\"1KiB\",\"blob-file-compression\":\"lz4\",\"blob-cache-size\":\"0KiB\",\"min-gc-batch-size\":\"16MiB\",\"max-gc-batch-size\":\"64MiB\",\"discardable-ratio\":0.5,\"sample-ratio\":0.1,\"merge-small-file-threshold\":\"8MiB\",\"blob-run-mode\":\"read-only\",\"level-merge\":false,\"range-merge\":true,\"max-sorted-runs\":20,\"gc-merge-rewrite\":false}},\"raftcf\":{\"block-size\":\"16KiB\",\"block-cache-size\":\"128MiB\",\"disable-block-cache\":false,\"cache-index-and-filter-blocks\":true,\"pin-l0-filter-and-index-blocks\":true,\"use-bloom-filter\":true,\"optimize-filters-for-hits\":true,\"whole-key-filtering\":true,\"bloom-filter-bits-per-key\":10,\"block-based-bloom-filter\":false,\"read-amp-bytes-per-bit\":0,\"compression-per-level\":[\"no\",\"no\",\"no\",\"no\",\"no\",\"no\",\"no\"],\"write-buffer-size\":\"128MiB\",\"max-write-buffer-number\":5,\"min-write-buffer-number-to-merge\":1,\"max-bytes-for-level-base\":\"128MiB\",\"target-file-size-base\":\"8MiB\",\"level0-file-num-compaction-trigger\":1,\"level0-slowdown-writes-trigger\":20,\"level0-stop-writes-trigger\":36,\"max-compaction-bytes\":\"2GiB\",\"compaction-pri\":0,\"dynamic-level-bytes\":true,\"num-levels\":7,\"max-bytes-for-level-multiplier\":10,\"compaction-style\":0,\"disable-auto-compactions\":false,\"soft-pending-compaction-bytes-limit\":\"64GiB\",\"hard-pending-compaction-bytes-limit\":\"256GiB\",\"force-consistency-checks\":false,\"prop-size-index-distance\":4194304,\"prop-keys-index-distance\":40960,\"enable-doubly-skiplist\":true,\"titan\":{\"min-blob-size\":\"1KiB\",\"blob-file-compression\":\"lz4\",\"blob-cache-size\":\"0KiB\",\"min-gc-batch-size\":\"16MiB\",\"max-gc-batch-size\":\"64MiB\",\"discardable-ratio\":0.5,\"sample-ratio\":0.1,\"merge-small-file-threshold\":\"8MiB\",\"blob-run-mode\":\"read-only\",\"level-merge\":false,\"range-merge\":true,\"max-sorted-runs\":20,\"gc-merge-rewrite\":false}},\"titan\":{\"enabled\":false,\"dirname\":\"\",\"disable-gc\":false,\"max-background-gc\":4,\"purge-obsolete-files-period\":\"10s\"}},\"raftdb\":{\"wal-recovery-mode\":2,\"wal-dir\":\"\",\"wal-ttl-seconds\":0,\"wal-size-limit\":\"0KiB\",\"max-total-wal-size\":\"4GiB\",\"max-background-jobs\":4,\"max-background-flushes\":1,\"max-manifest-file-size\":\"20MiB\",\"create-if-missing\":true,\"max-open-files\":40960,\"enable-statistics\":true,\"stats-dump-period\":\"10m\",\"compaction-readahead-size\":\"0KiB\",\"info-log-max-size\":\"1GiB\",\"info-log-roll-time\":\"0s\",\"info-log-keep-log-file-num\":10,\"info-log-dir\":\"\",\"max-sub-compactions\":2,\"writable-file-max-buffer-size\":\"1MiB\",\"use-direct-io-for-flush-and-compaction\":false,\"enable-pipelined-write\":true,\"enable-unordered-write\":false,\"allow-concurrent-memtable-write\":true,\"bytes-per-sync\":\"1MiB\",\"wal-bytes-per-sync\":\"512KiB\",\"defaultcf\":{\"block-size\":\"64KiB\",\"block-cache-size\":\"2GiB\",\"disable-block-cache\":false,\"cache-index-and-filter-blocks\":true,\"pin-l0-filter-and-index-blocks\":true,\"use-bloom-filter\":false,\"optimize-filters-for-hits\":true,\"whole-key-filtering\":true,\"bloom-filter-bits-per-key\":10,\"block-based-bloom-filter\":false,\"read-amp-bytes-per-bit\":0,\"compression-per-level\":[\"no\",\"no\",\"lz4\",\"lz4\",\"lz4\",\"zstd\",\"zstd\"],\"write-buffer-size\":\"128MiB\",\"max-write-buffer-number\":5,\"min-write-buffer-number-to-merge\":1,\"max-bytes-for-level-base\":\"512MiB\",\"target-file-size-base\":\"8MiB\",\"level0-file-num-compaction-trigger\":4,\"level0-slowdown-writes-trigger\":20,\"level0-stop-writes-trigger\":36,\"max-compaction-bytes\":\"2GiB\",\"compaction-pri\":0,\"dynamic-level-bytes\":true,\"num-levels\":7,\"max-bytes-for-level-multiplier\":10,\"compaction-style\":0,\"disable-auto-compactions\":false,\"soft-pending-compaction-bytes-limit\":\"64GiB\",\"hard-pending-compaction-bytes-limit\":\"256GiB\",\"force-consistency-checks\":false,\"prop-size-index-distance\":4194304,\"prop-keys-index-distance\":40960,\"enable-doubly-skiplist\":true,\"titan\":{\"min-blob-size\":\"1KiB\",\"blob-file-compression\":\"lz4\",\"blob-cache-size\":\"0KiB\",\"min-gc-batch-size\":\"16MiB\",\"max-gc-batch-size\":\"64MiB\",\"discardable-ratio\":0.5,\"sample-ratio\":0.1,\"merge-small-file-threshold\":\"8MiB\",\"blob-run-mode\":\"normal\",\"level-merge\":false,\"range-merge\":true,\"max-sorted-runs\":20,\"gc-merge-rewrite\":false}},\"titan\":{\"enabled\":false,\"dirname\":\"\",\"disable-gc\":false,\"max-background-gc\":4,\"purge-obsolete-files-period\":\"10s\"}},\"security\":{\"ca-path\":\"\",\"cert-path\":\"\",\"key-path\":\"\",\"cert-allowed-cn\":[],\"redact-info-log\":null,\"encryption\":{\"data-encryption-method\":\"plaintext\",\"data-key-rotation-period\":\"7d\",\"enable-file-dictionary-log\":true,\"file-dictionary-rewrite-threshold\":1000000,\"master-key\":{\"type\":\"plaintext\"},\"previous-master-key\":{\"type\":\"plaintext\"}}},\"import\":{\"num-threads\":8,\"stream-channel-window\":128},\"backup\":{\"num-threads\":32,\"batch-size\":8,\"sst-max-size\":\"144MiB\"},\"pessimistic-txn\":{\"enabled\":true,\"wait-for-lock-timeout\":\"1s\",\"wake-up-delay-duration\":\"20ms\",\"pipelined\":false},\"gc\":{\"ratio-threshold\":1.1,\"batch-keys\":512,\"max-write-bytes-per-sec\":\"0KiB\"},\"split\":{\"qps-threshold\":3000,\"split-balance-score\":0.25,\"split-contained-score\":0.5,\"detect-times\":10,\"sample-num\":20,\"sample-threshold\":100,\"size-threshold\":4194304,\"key-threshold\":40960},\"cdc\":{\"min-ts-interval\":\"1s\"}}"]

3 两台down的tikv 日志都是

[root@data11 log]# cat tikv_stderr.log 
<jemalloc>: Malformed conf string
<jemalloc>: Malformed conf string
<jemalloc>: Malformed conf string
<jemalloc>: Malformed conf string
<jemalloc>: Malformed conf string
<jemalloc>: Malformed conf string

[root@saas1 log]# cat tikv_stderr.log 
<jemalloc>: Malformed conf string
<jemalloc>: Malformed conf string
<jemalloc>: Malformed conf string
<jemalloc>: Malformed conf string
<jemalloc>: Malformed conf string
<jemalloc>: Malformed conf string
[root@saas1 log]# 


从现在运行的dashboard 里 下载4月13日23点到现在所有的错误日志
logs.zip (2.1 MB)

  1. tikv 状态是 down ,但是进程存活这个,这个是可以确认的么?
  2. 这边目前看起来是 tidb 进程有 panic 的情况,导致有告警
  3. tidb panic 的问题需要分析一下,可以拿一下完整的 tidb.log 日志文件看下么?不是仅仅只有 error 级别的日志,拿一下发生 panic 的那个 tidb 节点的日志就行

1 确认
3 日志如下

链接: 百度网盘-链接不存在 提取码: 1i5r 复制这段内容后打开百度网盘手机App,操作更方便哦
–来自百度网盘超级会员v6的分享

tidb_192_168_254_31_9383.zip (5.0 MB)

另外现在集群 分析任何表都失败

ANALYZE TABLE xxx

都报错

Task execution failed

原因:
 SQL 错误 [1105] [HY000]: analyze worker panic

panic 这个是有问题的,我们分析一下日志看,先看能不能解决 panic 这个问题。
tikv 变为 down 可能是跟这个有关。
我们先分析一下,有进度在帖子这边同步。

根据日志, tidb panic的原因是analyze的table的某个 utf8/utf8mb4 charset, general_ci collation 的列存在非法utf8字符。想问一下这样的表的数据是怎么进去的 过程中是否有可能存在插入非法utf8的情况?

都是标准java程序通过jdbc写入, 没有还原或者导入过, 应该都是标准的utf8 编码

同时, 哪怕有一些特殊数据 可以选择忽略嘛, 直接到导致panic, 甚至最终服务都不可以用, 对一个数据库而言, 违背了主要可用性保障原则

那现在对于这些不能analyze的表要怎么操作 删除后重新导入数据?

  1. 能否提供一下analyze panic表的一些utf8列数据的编码,只需要随机选择几行就好 可以用 select hex(列名) from table-paniced limit 10

  2. 我们为了一些性能的提升选择自己手动解析utf8,并且因为假设都是合法utf8编码没有做utf8检查.

3. 可以删除后重新导入数据,如果数据都是正确的utf8编码 应该就不会出现这个情况了.

现在不工作的表太多, 我们是saas化的产品, 租户表有特别多, 删除数据重新导, 这个工作量.

CREATE TABLE `im_kefu_login_records` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `staff_id` int(11) NOT NULL COMMENT '员工工号',
  `staff_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL COMMENT '员工姓名',
  `login_time` datetime NOT NULL COMMENT '登录时间',
  `xtenant` int(20) DEFAULT NULL COMMENT '多租户标识',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

只可能是 staff_name 列

select r.staff_name, hex(r.staff_name) from im_kefu_login_records r limit 1000

"staff_name","hex(r.staff_name)"
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
谢忠礼,E8B0A2E5BFA0E7A4BC
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
谢忠礼,E8B0A2E5BFA0E7A4BC
郭志文,E983ADE5BF97E69687
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
谢忠礼,E8B0A2E5BFA0E7A4BC
李淑珍,E69D8EE6B791E78F8D
郭志文,E983ADE5BF97E69687
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
郭志文,E983ADE5BF97E69687
胡燕华,E883A1E78795E58D8E
孙翠莲,E5AD99E7BFA0E88EB2
谢忠礼,E8B0A2E5BFA0E7A4BC
谢忠礼,E8B0A2E5BFA0E7A4BC
郭志文,E983ADE5BF97E69687
罗杨,E7BD97E69DA8
刘娜,E58898E5A89C
刘娜,E58898E5A89C
刘娜,E58898E5A89C
刘娜,E58898E5A89C
刘娜,E58898E5A89C
刘娜,E58898E5A89C
刘娜,E58898E5A89C
刘娜,E58898E5A89C
刘娜,E58898E5A89C
郭志文,E983ADE5BF97E69687
胡燕华,E883A1E78795E58D8E
胡燕华,E883A1E78795E58D8E
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
胡燕华,E883A1E78795E58D8E
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
胡燕华,E883A1E78795E58D8E
胡燕华,E883A1E78795E58D8E
胡燕华,E883A1E78795E58D8E
李珍贞,E69D8EE78F8DE8B49E
胡燕华,E883A1E78795E58D8E
胡燕华,E883A1E78795E58D8E
胡燕华,E883A1E78795E58D8E
郭志文,E983ADE5BF97E69687
胡燕华,E883A1E78795E58D8E
胡燕华,E883A1E78795E58D8E
胡燕华,E883A1E78795E58D8E
郭志文,E983ADE5BF97E69687
胡燕华,E883A1E78795E58D8E
郭志文,E983ADE5BF97E69687
胡燕华,E883A1E78795E58D8E
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
胡燕华,E883A1E78795E58D8E
郭志文,E983ADE5BF97E69687
胡燕华,E883A1E78795E58D8E
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
胡燕华,E883A1E78795E58D8E
郭志文,E983ADE5BF97E69687
刘娜,E58898E5A89C
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
胡燕华,E883A1E78795E58D8E
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
胡燕华,E883A1E78795E58D8E
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
胡燕华,E883A1E78795E58D8E
刘娜,E58898E5A89C
胡燕华,E883A1E78795E58D8E
胡燕华,E883A1E78795E58D8E
胡燕华,E883A1E78795E58D8E
胡燕华,E883A1E78795E58D8E
胡燕华,E883A1E78795E58D8E
郭志文,E983ADE5BF97E69687
胡燕华,E883A1E78795E58D8E
郭志文,E983ADE5BF97E69687
系统运维,E7B3BBE7BB9FE8BF90E7BBB4
九机段继蓉,E4B99DE69CBAE6AEB5E7BBA7E89389
胡燕华,E883A1E78795E58D8E
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687
郭志文,E983ADE5BF97E69687


这个bug出现于4.0.11版本,4.0.11之前的版本都是没有问题的,如果可以的话可以暂时使用4.0.11之前的版本

麻烦确认一下

  1. analyze table im_kefu_login_records 会panic

  2. select * from im_kefu_login_records order by staff_name 是否会出现问题?

1 确认会panic
2 正常查询 不会有问题

新建一个表, 然后 analyze table 这个表也会报错吗?

create table t (a int auto_increment,b varchar(100), primary key (a));
insert into t values (1,"abc");
analyze table t;     -- 这个会执行报错吗?

@yourchanges
是从什么版本升级到 v4.0.12 呀?