fix: lock mgr may failed to release lock in time

[dantengsky]

I hereby agree to the terms of the CLA available at: https://docs.databend.com/dev/policies/cla/

Summary

Replaces tokio::sync::Notify with WatchNotify which is safe to nofity_one before Notified future has been polled, otherwise, we risk not being able to release the lock in time.

Tests

• [x] Unit Test
• [ ] Logic Test
• [ ] Benchmark Test
• [ ] No Test - Explain why

Type of change

• [x] Bug Fix (non-breaking change which fixes an issue)
• [ ] New Feature (non-breaking change which adds functionality)
• [ ] Breaking Change (fix or feature that could cause existing functionality not to work as expected)
• [ ] Documentation Update
• [ ] Refactoring
• [ ] Performance Improvement
• [ ] Other (please describe):

---

This change is 

[what-the-diff[bot]]

PR Summary

• Configuration Updates:
  • The system has been made more efficient by setting a limit to the number of concurrent queries through a max_running_queries parameter.
  • The logging level has been changed to INFO for databend-query-node-1, reducing the amount of log data produced during normal operations.
• Enhancement in Notification Methods:
  • A new method named notify_one() has been introduced that enhances the system's capability to send notifications.
• Addition of Test for New Method:
  • A test named test_notify_one() has been added to ensure the correct functionality of the newly introduced notification method.
• Improved LockHolder Notifications:
  • The LockHolder structure utilization has been improved by replacing the old notification type with the new WatchNotify type, increasing efficiency and notifications abilities of the system.

[github-actions[bot]]

Docker Image for PR

• tag: pr-16611-9f5838c-1728994369

note: this image tag is only available for internal use, please check the internal doc for more details.

[github-actions[bot]]

ClickBench Report

• hits: https://benchmark.databend.com/clickbench/pr/16611/11345343834/hits.html
• internal: https://benchmark.databend.com/clickbench/pr/16611/11345343834/internal.html
• load: https://benchmark.databend.com/clickbench/pr/16611/11345343834/load.html
• tpch: https://benchmark.databend.com/clickbench/pr/16611/11345343834/tpch.html