flaky TestRenameTableAutoIDs, report Lock wait timeout exceeded; try restarting transaction

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

see https://do.pingcap.net/jenkins/blue/rest/organizations/jenkins/pipelines/pingcap/pipelines/tidb/pipelines/ghpr_unit_test/runs/15858/nodes/63/steps/69/log/?start=0
```
Messages: sql:insert into RenameTableAutoIDs2.t2 values (20, 5), [], error stack [tikv:1205]Lock wait timeout exceeded; try restarting transaction
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/testkit.(*TestKit).ExecWithContext
pkg/testkit/testkit.go:441
github.com/pingcap/tidb/pkg/testkit.(*TestKit).MustExecWithContext
pkg/testkit/testkit.go:159
github.com/pingcap/tidb/pkg/testkit.(*TestKit).MustExec
pkg/testkit/testkit.go:154
github.com/pingcap/tidb/pkg/ddl_test.TestRenameTableAutoIDs
pkg/ddl/schema_test.go:441
testing.tRunner
GOROOT/src/testing/testing.go:1595
runtime.goexit
src/runtime/asm_amd64.s:1650
```
### 2. What did you expect to see? (Required)
success
### 3. What did you see instead (Required)
fail
### 4. What is your TiDB version? (Required)
master