static模式没有报错
表结构:
CREATE TABLE weibo_user
(
id
bigint(20) unsigned NOT NULL,
name
varchar(45) NOT NULL,
homeurl
varchar(1024) NOT NULL,
description
varchar(500) DEFAULT NULL,
profile_image_url
varchar(1024) DEFAULT NULL,
location
varchar(45) DEFAULT NULL,
province
varchar(20) DEFAULT NULL,
city
varchar(20) DEFAULT NULL,
gender
varchar(45) DEFAULT NULL,
birthday
date DEFAULT NULL,
age
varchar(45) DEFAULT NULL,
interests
text DEFAULT NULL,
followers_count
int(11) NOT NULL DEFAULT ‘0’,
friends_count
int(11) NOT NULL DEFAULT ‘0’ ,
statuses_count
int(11) NOT NULL DEFAULT ‘0’ ,
buy_power
tinyint(4) DEFAULT NULL,
life_stage
varchar(10) DEFAULT NULL,
career_label
varchar(20) DEFAULT NULL,
is_navy
tinyint(4) DEFAULT NULL,
navy_probability
float(9,8) DEFAULT NULL,
verified
tinyint(1) DEFAULT ‘0’,
verified_type
smallint(6) DEFAULT NULL,
verifiyType
tinyint(4) NOT NULL DEFAULT ‘4’,
verified_reason
varchar(100) DEFAULT NULL,
verified_detail
json DEFAULT NULL,
verified_level
tinyint(4) DEFAULT NULL,
active
tinyint(1) DEFAULT ‘0’,
created_at
datetime DEFAULT NULL,
spidertime
datetime NOT NULL,
create_time
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
update_time
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id
) /*T![clustered_index] CLUSTERED */,
KEY inx_name
(name
),
KEY idx_create_time
(create_time
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
PARTITION BY HASH (id
) PARTITIONS 128;
tidb.log:
[2022/06/28 16:36:05.847 +08:00] [INFO] [analyze.go:252] [“analyze table mbase_test
.weibo_user
has finished”] [partition=p127] [“job info”=“analyze table all columns with 256 buckets, 500 topn, 0.7949470276207958 samplerate”] [“start time”=2022/06/28 16:15:30.120 +08:00] [“end time”=2022/06/28 16:36:05.829 +08:00] [cost=20m35.708522053s]
[2022/06/28 16:37:12.601 +08:00] [ERROR] [conn.go:1056] [“connection running loop panic”] [conn=2401122288830536617] [lastSQL=“ANALYZE TABLE mbase_test.weibo_user ALL COLUMNS”] [err=“runtime error: index out of range [2048] with length 2048”] [stack=“github.com/pingcap/tidb/server.(*clientConn).Run.func1\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1059\
runtime.gopanic\
\t/usr/local/go/src/runtime/panic.go:838\ngithub.com/pingcap/tidb/executor.(*ExecStmt).Exec.func1\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/adapter.go:371\
runtime.gopanic\
\t/usr/local/go/src/runtime/panic.go:838\
runtime.goPanicIndex\
\t/usr/local/go/src/runtime/panic.go:89\ngithub.com/pingcap/tidb/util/chunk.(*Column).GetFloat64\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/util/chunk/column.go:557\ngithub.com/pingcap/tidb/util/chunk.Row.GetFloat64\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/util/chunk/row.go:68\
github.com/pingcap/tidb/util/chunk.Compare\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/util/chunk/compare.go:195\
github.com/pingcap/tidb/util/chunk.(*Chunk).LowerBound.func1\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/util/chunk/compare.go:227\
sort.Search\
\t/usr/local/go/src/sort/search.go:66\ngithub.com/pingcap/tidb/util/chunk.(*Chunk).LowerBound\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/util/chunk/compare.go:226\ngithub.com/pingcap/tidb/statistics.(*Histogram).locateBucket\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/statistics/histogram.go:481\ngithub.com/pingcap/tidb/statistics.(*Histogram).equalRowCount\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/statistics/histogram.go:440\ngithub.com/pingcap/tidb/statistics.MergePartTopN2GlobalTopN\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/statistics/cmsketch.go:781\
github.com/pingcap/tidb/statistics/handle.(*Handle).mergePartitionStats2GlobalStats\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/statistics/handle/handle.go:514\ngithub.com/pingcap/tidb/statistics/handle.(*Handle).MergePartitionStats2GlobalStatsByTableID\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/statistics/handle/handle.go:405\ngithub.com/pingcap/tidb/executor.(*AnalyzeExec).Next\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/analyze.go:210\ngithub.com/pingcap/tidb/executor.Next\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/executor.go:319\
github.com/pingcap/tidb/executor.(*ExecStmt).handleNoDelayExecutor\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/adapter.go:665\ngithub.com/pingcap/tidb/executor.(*ExecStmt).handleNoDelay\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/adapter.go:516\ngithub.com/pingcap/tidb/executor.(*ExecStmt).Exec\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/adapter.go:465\ngithub.com/pingcap/tidb/session.runStmt\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:2069\
github.com/pingcap/tidb/session.(*session).ExecuteStmt\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:1938\ngithub.com/pingcap/tidb/server.(*TiDBContext).ExecuteStmt\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/driver_tidb.go:230\ngithub.com/pingcap/tidb/server.(*clientConn).handleStmt\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:2022\ngithub.com/pingcap/tidb/server.(*clientConn).handleQuery\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1876\ngithub.com/pingcap/tidb/server.(*clientConn).dispatch\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1371\ngithub.com/pingcap/tidb/server.(*clientConn).Run\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1121\ngithub.com/pingcap/tidb/server.(*Server).onConn\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/server.go:559”]
[2022/06/28 16:38:51.055 +08:00] [INFO] [domain.go:1749] [“refreshServerIDTTL succeed”] [serverID=1091904] [“lease id”=6eca81715eb7a38f]