- 系统版本 & kernel 版本：Centos 7.3
- TiDB 版本：3.0.1
- 集群节点分布：4 kv+3 pd + 3 Tidb, 分别在7台服务器上
- 问题描述： 执行时 analyze table ***，提示： analyze worker panic。
请问要如何处理？
麻烦上传报错时的 tidb 日志，多谢。
SELECT order_number FROM s_order WHERE order_create_date>‘2020-05-01 00:00:00’ AND order_create_date<=‘2020-05-22 23:59:59’ AND order_status=‘3’
发现就是这个表，出现不能analyze后，执行上面这句SQL提示如下：
1105 - InvalidDataType(“Unsupported datum flag 2 for DateTime vector”), Time: 0.026000s
日志如下：
[2020/06/05 04:03:01.803 +08:00] [ERROR] [conn.go:599] [“connection running loop panic”] [conn=321342] [lastCmd=“SELECT * FROM erp_stock_order WHERE id=1055506”] [err="“index out of range”"] [stack=“goroutine 1946535288 [running]:\ngithub.com/pingcap/tidb/server.(*clientConn).Run.func1(0x2250900, 0xc03c336480, 0xc04d7104e0)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/conn.go:597 +0xee\ panic(0x1d85fe0, 0x3198a70)\ \t/usr/local/go/src/runtime/panic.go:522 +0x1b5\ngithub.com/pingcap/tidb/server.(*clientConn).writeResultset.func1(0x0, 0x22626c0, 0xc01af0d5e0, 0xc000289778, 0x2250900, 0xc03c336480, 0xc04d7104e0)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/conn.go:1255 +0x59c\ panic(0x1d85fe0, 0x3198a70)\ \t/usr/local/go/src/runtime/panic.go:522 +0x1b5\ngithub.com/pingcap/tidb/util/chunk.(*column).appendInt64(…)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/util/chunk/column.go:140\ngithub.com/pingcap/tidb/util/chunk.(*Chunk).AppendInt64(0xc00b8b9200, 0x1, 0x101b12)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/util/chunk/chunk.go:469 +0x217\ngithub.com/pingcap/tidb/util/codec.appendIntToChunk(0x101b12, 0xc00b8b9200, 0x1, 0xc0169f8788)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/util/codec/codec.go:658 +0x7e\ngithub.com/pingcap/tidb/util/codec.(*Decoder).DecodeOne(0xc000289330, 0xc003e614a7, 0x0, 0x159, 0x1, 0xc0169f8788, 0x28, 0x0, 0x0, 0xc0d4948b40, …)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/util/codec/codec.go:590 +0x1240\ngithub.com/pingcap/tidb/executor.(*PointGetExecutor).decodeRowValToChunk(0xc0155d5b00, 0xc003e614a0, 0x15f, 0x160, 0xc00b8b9200, 0x13, 0x0)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/executor/point_get.go:232 +0x540\ngithub.com/pingcap/tidb/executor.(*PointGetExecutor).Next(0xc0155d5b00, 0x2250900, 0xc03c336480, 0xc00b8b9200, 0x0, 0x0)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/executor/point_get.go:143 +0x45f\ngithub.com/pingcap/tidb/executor.Next(0x2250900, 0xc03c336480, 0x2257100, 0xc0155d5b00, 0xc00b8b9200, 0xc00b8b9200, 0x3512910)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/executor/executor.go:190 +0xbd\ngithub.com/pingcap/tidb/executor.(*recordSet).Next(0xc01af0d590, 0x2250900, 0xc03c336480, 0xc00b8b9200, 0x0, 0x0)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/executor/adapter.go:109 +0xb0\ngithub.com/pingcap/tidb/server.(*tidbResultSet).Next(0xc01af0d5e0, 0x2250900, 0xc03c336480, 0xc00b8b9200, 0x4, 0x400)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/driver_tidb.go:365 +0x51\ngithub.com/pingcap/tidb/server.(*clientConn).writeChunks(0xc04d7104e0, 0x2250900, 0xc03c336480, 0x22626c0, 0xc01af0d5e0, 0xc000009700, 0x2250900, 0xc03c336480)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/conn.go:1302 +0x319\ngithub.com/pingcap/tidb/server.(*clientConn).writeResultset(0xc04d7104e0, 0x2250900, 0xc03c336480, 0x22626c0, 0xc01af0d5e0, 0xc000002800, 0x0, 0x0, 0x0)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/conn.go:1268 +0x1a1\ngithub.com/pingcap/tidb/server.(*clientConn).handleQuery(0xc04d7104e0, 0x2250900, 0xc03c336480, 0xc06055dc51, 0x2e, 0x0, 0x0)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/conn.go:1185 +0x212\ngithub.com/pingcap/tidb/server.(*clientConn).dispatch(0xc04d7104e0, 0x2250900, 0xc03c336480, 0xc06055dc51, 0x2f, 0x2f, 0x0, 0x0)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/conn.go:895 +0x5c6\ngithub.com/pingcap/tidb/server.(*clientConn).Run(0xc04d7104e0, 0x2250900, 0xc03c336480)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/conn.go:650 +0x258\ngithub.com/pingcap/tidb/server.(*Server).onConn(0xc00019b480, 0xc04d7104e0)\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/server.go:440 +0x481\ created by github.com/pingcap/tidb/server.(*Server).Run\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/server.go:357 +0x83d\ ”] [stack=“github.com/pingcap/tidb/server.(*clientConn).Run.func1\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/conn.go:599\ runtime.gopanic\ \t/usr/local/go/src/runtime/panic.go:522\ngithub.com/pingcap/tidb/server.(*clientConn).writeResultset.func1\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/conn.go:1255\ runtime.gopanic\ \t/usr/local/go/src/runtime/panic.go:522\ runtime.panicindex\ \t/usr/local/go/src/runtime/panic.go:44\ngithub.com/pingcap/tidb/util/chunk.(*column).appendInt64\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/util/chunk/column.go:140\ngithub.com/pingcap/tidb/util/chunk.(*Chunk).AppendInt64\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/util/chunk/chunk.go:469\ngithub.com/pingcap/tidb/util/codec.appendIntToChunk\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/util/codec/codec.go:658\ github.com/pingcap/tidb/util/codec.(*Decoder).DecodeOne\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/util/codec/codec.go:590\ngithub.com/pingcap/tidb/executor.(*PointGetExecutor).decodeRowValToChunk\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/executor/point_get.go:232\ngithub.com/pingcap/tidb/executor.(*PointGetExecutor).Next\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/executor/point_get.go:143\ngithub.com/pingcap/tidb/executor.Next\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/executor/executor.go:190\ github.com/pingcap/tidb/executor.(*recordSet).Next\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/executor/adapter.go:109\ngithub.com/pingcap/tidb/server.(*tidbResultSet).Next\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/driver_tidb.go:365\ngithub.com/pingcap/tidb/server.(*clientConn).writeChunks\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/conn.go:1302\ngithub.com/pingcap/tidb/server.(*clientConn).writeResultset\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/conn.go:1268\ngithub.com/pingcap/tidb/server.(*clientConn).handleQuery\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/conn.go:1185\ngithub.com/pingcap/tidb/server.(*clientConn).dispatch\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/conn.go:895\ngithub.com/pingcap/tidb/server.(*clientConn).Run\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/conn.go:650\ngithub.com/pingcap/tidb/server.(*Server).onConn\ \t/home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/server/server.go:440”]
请问 tidb_index_lookup_size，chunk size 是多少呢？
- 请问，是否有过升级到4.0？
- 或者是扩容的tidb有4.0版本的？