fix lock waiter leak #9771

Job	Run time
CHECK PR VALID	3s
Matrixone Standlone CI / Multi-CN e2e BVT Test on Linux/x64(LAUNCH, PROXY)	16m 32s
Matrixone Compose CI / multi cn e2e bvt test docker compose(PESSIMISTIC)	18m 11s
Matrixone Compose CI / multi cn e2e bvt test docker compose(Optimistic/PUSH)	12m 34s
Matrixone Standlone CI / e2e BVT Test on Linux/x64(LAUNCH,Optimistic)	18m 37s
Matrixone Standlone CI / e2e BVT Test on Linux/x64(LAUNCH, PESSIMISTIC)	15m 12s
Matrixone Upgrade CI / Compatibility Test With Target on Linux/x64(LAUNCH)	31m 7s
Matrixone Utils CI / check_organization_user	4s
Matrixone CI / SCA Test on Ubuntu/x86	8m 58s
Matrixone CI / UT Test on Ubuntu/x86	30m 8s
Matrixone Upgrade CI / Compatibility Test With Release on Linux/x64(LAUNCH)	27m 35s
Matrixone CI / UT Test on Darwin/x86	38m 53s
Matrixone Utils CI / PR Unit Test Coverage	18m 55s
Matrixone Utils CI / pr-size-label	2s
Matrixone Utils CI / ChatGPT Review	0s
Matrixone Utils CI / docu_issue_check	0s
	3h 56m 51s

Provide feedback