fix: remove previous lock file when processes try to open the same db

[smellthemoon]

#30501

[mergify[bot]]

@smellthemoon E2e jenkins job failed, comment /run-cpu-e2e can trigger the job again.

[mergify[bot]]

@smellthemoon ut workflow job failed, comment rerun ut can trigger the job again.

[codecov[bot]]

Codecov Report

Attention: Patch coverage is 21.42857% with 22 lines in your changes are missing coverage. Please review.

Project coverage is 81.44%. Comparing base (c002745) to head (67c2543). Report is 265 commits behind head on master.

Additional details and impacted files

@@            Coverage Diff             @@
##           master   #31709      +/-   ##
==========================================
- Coverage   81.82%   81.44%   -0.38%     
==========================================
  Files         990      999       +9     
  Lines      124471   124284     -187     
==========================================
- Hits       101852   101228     -624     
- Misses      18754    19177     +423     
- Partials     3865     3879      +14     

Files	Coverage Δ
internal/kv/rocksdb/rocksdb_kv.go	82.33% <ø> (ø)
internal/mq/mqimpl/rocksmq/server/rocksmq_impl.go	82.48% <21.42%> (-2.50%)	:arrow_down:

... and 215 files with indirect coverage changes

[smellthemoon]

related with #30355

[zhuwenxing]

/run-cpu-e2e

[sre-ci-robot]

[APPROVALNOTIFIER] This PR is NOT APPROVED

This pull-request has been approved by: smellthemoon To complete the pull request process, please assign yanliang567 after the PR has been reviewed. You can assign the PR to them by writing /assign @yanliang567 in a comment when ready.

The full list of commands accepted by this bot can be found here.

Needs approval from an approver in each of these files:

• OWNERS

Approvers can indicate their approval by writing /approve in a comment Approvers can cancel approval by writing /approve cancel in a comment

[mergify[bot]]

@smellthemoon E2e jenkins job failed, comment /run-cpu-e2e can trigger the job again.

[mergify[bot]]

@smellthemoon E2e jenkins job failed, comment /run-cpu-e2e can trigger the job again.

[mergify[bot]]

@smellthemoon E2e jenkins job failed, comment /run-cpu-e2e can trigger the job again.

[mergify[bot]]

@smellthemoon E2e jenkins job failed, comment /run-cpu-e2e can trigger the job again.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. Rotten issues close after 30d of inactivity. Reopen the issue with /reopen.