flaky test in the TestCreateNonUniqueIndex

[hawkingrei]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

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

3. What did you see instead (Required)

        	Error Trace:	tests/realtikvtest/addindextestutil/common.go:273
        	            				tests/realtikvtest/addindextestutil/common.go:470
        	            				tests/realtikvtest/addindextestutil/common.go:377
        	Error:      	Received unexpected error:
        	            	[0]open /tmp/tidb/tmp_ddl-4000/173/5a881f23-adeb-5d60-808c-61172d0aea0b.sst/072848f4-3440-4169-a87d-0b3c3f265000.sst: no such file or directory
        	            	github.com/pingcap/errors.AddStack
        	            		external/com_github_pingcap_errors/errors.go:178
        	            	github.com/pingcap/errors.Trace
        	            		external/com_github_pingcap_errors/juju_adaptor.go:15
        	            	github.com/pingcap/tidb/pkg/ddl.(*ddl).DoDDLJob
        	            		pkg/ddl/ddl.go:1326
        	            	github.com/pingcap/tidb/pkg/ddl.(*ddl).createIndex
        	            		pkg/ddl/ddl_api.go:7887
        	            	github.com/pingcap/tidb/pkg/ddl.(*ddl).AlterTable
        	            		pkg/ddl/ddl_api.go:4081
        	            	github.com/pingcap/tidb/pkg/executor.(*DDLExec).executeAlterTable
        	            		pkg/executor/ddl.go:389
        	            	github.com/pingcap/tidb/pkg/executor.(*DDLExec).Next
        	            		pkg/executor/ddl.go:152
        	            	github.com/pingcap/tidb/pkg/executor/internal/exec.Next
        	            		pkg/executor/internal/exec/executor.go:410
        	            	github.com/pingcap/tidb/pkg/executor.(*ExecStmt).next
        	            		pkg/executor/adapter.go:1242
        	            	github.com/pingcap/tidb/pkg/executor.(*ExecStmt).handleNoDelayExecutor
        	            		pkg/executor/adapter.go:991
        	            	github.com/pingcap/tidb/pkg/executor.(*ExecStmt).handleNoDelay
        	            		pkg/executor/adapter.go:825
        	            	github.com/pingcap/tidb/pkg/executor.(*ExecStmt).Exec
        	            		pkg/executor/adapter.go:589
        	            	github.com/pingcap/tidb/pkg/session.runStmt
        	            		pkg/session/session.go:2289
        	            	github.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt
        	            		pkg/session/session.go:2150
        	            	github.com/pingcap/tidb/pkg/testkit.(*TestKit).ExecWithContext
        	            		pkg/testkit/testkit.go:385
        	            	github.com/pingcap/tidb/pkg/testkit.(*TestKit).Exec
        	            		pkg/testkit/testkit.go:358
        	            	github.com/pingcap/tidb/tests/realtikvtest/addindextestutil.createIndexOneCol
        	            		tests/realtikvtest/addindextestutil/common.go:267
        	            	github.com/pingcap/tidb/tests/realtikvtest/addindextestutil.AddIndexNonUnique
        	            		tests/realtikvtest/addindextestutil/common.go:470
        	            	github.com/pingcap/tidb/tests/realtikvtest/addindextestutil.TestOneColFrame
        	            		tests/realtikvtest/addindextestutil/common.go:377
        	            	tests/realtikvtest/addindextest/addindextest_test.TestCreateNonUniqueIndex
        	            		tests/realtikvtest/addindextest/add_index_test.go:46
        	            	testing.tRunner
        	            		GOROOT/src/testing/testing.go:1595
        	            	runtime.goexit
        	            		src/runtime/asm_amd64.s:1650
        	Test:       	TestCreateNonUniqueIndex

https://do.pingcap.net/jenkins/blue/rest/organizations/jenkins/pipelines/pingcap/pipelines/tidb/pipelines/ghpr_check2/runs/12929/nodes/108/steps/628/log/?start=0

4. What is your TiDB version? (Required)

[lance6716]

[2024/07/10 05:00:34.307 +00:00] [INFO] [env.go:159] ["remove stale temp index data"] [category=ddl-ingest] [jobID=173]