Enhancement: Should enhance ResolveLocks to support release secondary lock if txn has been commit or rollback #1768
Description
After a transaction is successfully committed or rolled back, there might be residual locks that will only be cleaned up by GC after the GC life time expires. This affects the advancement of resolved ts, which in turn causes synchronization lag in CDC. It is recommended to enhance the resolve lock interface so that such residual locks can be cleaned up early without waiting for GC.
As shown in the following picture.
Primary key mvcc:
Secondary key mvcc:
