Analyze Large Table Error: Context Provider Not Set

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: analyze 大表报错：context provider not set

| username: dba-kit

Environment: v7.3.0, Partitioned Raft KV enabled
Operation: After importing data with BR, start analyzing tables one by one
Phenomenon:
Most tables are normal during the analyze process. However, some large tables report an error: context provider not set

[2023/09/26 13:53:17.872 +08:00] [WARN] [session.go:2297] ["run statement failed"] [conn=1113597200] [schemaVersion=82] [error="context provider not set"] [session="{\n  \"currDBName\": \"\",\n  \"id\": 1113597200,\n  \"status\": 2,\n  \"strictMode\": true,\n  \"user\": {\n    \"Username\": \"root\",\n    \"Hostname\": \"127.0.0.1\",\n    \"CurrentUser\": false,\n    \"AuthUsername\": \"root\",\n    \"AuthHostname\": \"%\",\n    \"AuthPlugin\": \"mysql_native_password\"\n  }\n}"]
[2023/09/26 13:53:17.872 +08:00] [INFO] [conn.go:1081] ["command dispatched failed"] [conn=1113597200] [connInfo="id:1113597200, addr:127.0.0.1:55194 status:10, collation:utf8mb4_0900_ai_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="analyze table test.t1"] [txn_mode=PESSIMISTIC] [timestamp=444519564617449478] [err="context provider not set
github.com/pingcap/tidb/session.(*txnManager).GetStmtReadTS
	/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/txnmanager.go:96
github.com/pingcap/tidb/executor.(*executorBuilder).getSnapshotTS
	/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/builder.go:1916
github.com/pingcap/tidb/executor.(*executorBuilder).buildAnalyzeFastColumn
	/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/builder.go:2978
github.com/pingcap/tidb/executor.(*executorBuilder).buildAnalyze
	/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/builder.go:3074
github.com/pingcap/tidb/executor.(*executorBuilder).build
	/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/builder.go:283
github.com/pingcap/tidb/executor.(*ExecStmt).buildExecutor
	/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/adapter.go:1179
github.com/pingcap/tidb/executor.(*ExecStmt).Exec
	/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/adapter.go:527
github.com/pingcap/tidb/session.runStmt
	/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:2435
github.com/pingcap/tidb/session.(*session).ExecuteStmt
	/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:2285
github.com/pingcap/tidb/server.(*TiDBContext).ExecuteStmt
	/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/driver_tidb.go:291
github.com/pingcap/tidb/server.(*clientConn).handleStmt
	/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1993
github.com/pingcap/tidb/server.(*clientConn).handleQuery
	/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1784
github.com/pingcap/tidb/server.(*clientConn).dispatch
	/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1271
github.com/pingcap/tidb/server.(*clientConn).Run
	/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1050
github.com/pingcap/tidb/server.(*Server).onConn
	/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/server.go:662
runtime.goexit
	/usr/local/go/src/runtime/asm_amd64.s:1598"]
2
| username: TiDBer_oHSwKxOH | Original post link

br is not supported yet.

3
| username: dba-kit | Original post link

It is already supported, and the import was successful. Querying data is also normal. However, there are errors when running analyze table on a few large tables.

4
| username: dba-kit | Original post link

It seems to have hit this BUG, fast analyze + partitioned table.

5
| username: 像风一样的男子 | Original post link

7.3 is the dev version, can you test if version 7.1 has this bug?

6
| username: ajin0514 | Original post link

Let’s test the new version.

7
| username: dba-kit | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.