waits lock is not deleted when the session is killed

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)
1. execute select get_lock('disconnecttest', 20); in session A
2. execute select get_lock('disconnecttest', 20); in session B, get_lock() function keep waiting for lock released
3. close shell window of session B
4. select * from information_schema.data_lock_waits;

### 2. What did you expect to see? (Required)
no wait locks in information_schema.data_lock_waits table

### 3. What did you see instead (Required)
mysql> select * from information_schema.data_lock_waits;
+------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+------------------------+------------------------------------------------------------------+-----------------+
| KEY | KEY_INFO | TRX_ID | CURRENT_HOLDING_TRX_ID | SQL_DIGEST | SQL_DIGEST_TEXT |
+------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+------------------------+------------------------------------------------------------------+-----------------+
| 7480000000000000465F69800000000000000101646973636F6E6E65FF6374746573740000FD | {"db_id":3,"db_name":"mysql","table_id":70,"table_name":"advisory_locks","index_id":1,"index_name":"PRIMARY","index_values":["disconnecttest"]} | 433084725223751684 | 433084710897582083 | 503fd5b0bd3ca476326b20cdb82e8088bb82376f9a3b81c2f1887bcf46bb3da6 | NULL |
+------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+------------------------+------------------------------------------------------------------+-----------------+
1 row in set (0.01 sec)

mysql>

### 4. What is your TiDB version? (Required)

| Release Version: v6.1.0-alpha
Edition: Community
Git Commit Hash: 2c19f0a116143fd8a5cefc9dcb5f3d9c6c894372
Git Branch: heads/refs/tags/v6.1.0-alpha
UTC Build Time: 2022-05-05 14:58:11
GoVersion: go1.18
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |