CTE query execute failed: type assertion for CTEStorageMap failed

[knull-cn]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

run cte-query

2. What did you expect to see? (Required)

run success and no error

3. What did you see instead (Required)

run failed and stack info

4. What is your TiDB version? (Required)

v6.5.3

[knull-cn]

here is the stack error information:

[err="type assertion for CTEStorageMap failed
github.com/pingcap/tidb/executor.(*executorBuilder).buildCTE
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/builder.go:5140
github.com/pingcap/tidb/executor.(*executorBuilder).build
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/builder.go:308
github.com/pingcap/tidb/executor.(*executorBuilder).buildIndexLookUpJoin
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/builder.go:3059
github.com/pingcap/tidb/executor.(*executorBuilder).buildIndexNestedLoopHashJoin
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/builder.go:3289
github.com/pingcap/tidb/executor.(*executorBuilder).build
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/builder.go:262
github.com/pingcap/tidb/executor.(*executorBuilder).buildProjection
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/builder.go:1686
github.com/pingcap/tidb/executor.(*executorBuilder).build
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/builder.go:270
github.com/pingcap/tidb/executor.(*executorBuilder).buildInsert
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/builder.go:867
github.com/pingcap/tidb/executor.(*executorBuilder).build
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/builder.go:200
github.com/pingcap/tidb/executor.(*ExecStmt).buildExecutor
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/adapter.go:1110
github.com/pingcap/tidb/executor.(*ExecStmt).Exec
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/adapter.go:513
github.com/pingcap/tidb/session.(*session).retry
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:1286
github.com/pingcap/tidb/session.(*session).doCommitWithRetry
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:1008
github.com/pingcap/tidb/session.(*session).CommitTxn
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:1114
github.com/pingcap/tidb/session.autoCommitAfterStmt
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/tidb.go:282
github.com/pingcap/tidb/session.finishStmt
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/tidb.go:248
github.com/pingcap/tidb/session.runStmt
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:2392
github.com/pingcap/tidb/session.(*session).ExecuteStmt
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:2237
github.com/pingcap/tidb/server.(*TiDBContext).ExecuteStmt
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/driver_tidb.go:252
github.com/pingcap/tidb/server.(*clientConn).handleStmt
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:2122
github.com/pingcap/tidb/server.(*clientConn).handleQuery
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1972
github.com/pingcap/tidb/server.(*clientConn).dispatch
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1403
github.com/pingcap/tidb/server.(*clientConn).Run
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1152
github.com/pingcap/tidb/server.(*Server).onConn
    /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/server.go:648
runtime.goexit
    /usr/local/go/src/runtime/asm_amd64.s:1594"]

[tiancaiamao]

What's the SQL and table schema? @knull-cn

[seiya-annie]

/found gs

[jebter]

/label affects-6.5

[tiancaiamao]

From @jackysp

diff --git a/sessionctx/stmtctx/stmtctx.go b/sessionctx/stmtctx/stmtctx.go
index d5f19e8fe6..e0c167f08c 100644
--- a/sessionctx/stmtctx/stmtctx.go
+++ b/sessionctx/stmtctx/stmtctx.go
@@ -22,6 +22,7 @@ import (
        "sync/atomic"
        "time"
 
+       "github.com/pingcap/tidb/executor"
        "github.com/pingcap/tidb/parser"
        "github.com/pingcap/tidb/parser/ast"
        "github.com/pingcap/tidb/parser/model"
@@ -703,6 +704,7 @@ func (sc *StatementContext) resetMuForRetry() {
 // ResetForRetry resets the changed states during execution.
 func (sc *StatementContext) ResetForRetry() {
        sc.resetMuForRetry()
+       sc.CTEStorageMap = map[int]*executor.CTEStorages{}
        sc.MaxRowID = 0
        sc.BaseRowID = 0
        sc.TableIDs = sc.TableIDs[:0] 

[tiancaiamao]

The root cause is that if the CTE run to commit and auto retry, it rebuild the executor, but the sctx.CTEStorageMap was reset already, so this time it assert fail.

[seiya-annie]

/found customer