The ddl test suite of stmtflow failed with 1pc enabled

[zyguan]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

stmtflow play ddl/add_column/addcolumn_createindex_complex.t.sql  --dsn 'root:@tcp(...)/test'

The stmtflow tool is located at here and the test suite can be found here.

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

No error reported.

3. What did you see instead (Required)

One of DDL got stuck and the test finally timed out.

4. What is your TiDB version? (Required)

master (cad8e15)

[cfzjywxk]

There seem to be two problems:

1. The left pessimistic locks are not cleaned up using 1pc protocol to commit, blocking other concurrent transactions on these keys.
2. The ttlManager is not closed, if the max ts caculation error is reported using async commit or 1pc, thus the left pessimistic locks could not be resolved by the ddl backfill worker.

[ti-srebot]

Please edit this comment or add a new comment to complete the following information

Not a bug

1. Remove the 'type/bug' label
2. Add notes to indicate why it is not a bug

Duplicate bug

1. Add the 'type/duplicate' label
2. Add the link to the original bug

Bug

Note: Make Sure that 'component', and 'severity' labels are added
Example for how to fill out the template: #20100

1. Root Cause Analysis (RCA) (optional)

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

6. Fixed versions