Skip to content

2.25.0.0-b486

2.25.0.0-b486: [BACKPORT 2.25.0][#25387] ASH: Create a new wait event type "Lock"
@abhinab-yb abhinab-yb tagged this 31 Dec 10:03 
Summary:
Original commit: cb0dfba56b1bc5764fd118054387da5e81b1c3de / D40944
This diff creates a new wait event type "Lock" and
moves the tserver wait events LockedBatchEntry_Lock
and ConflictResolution_WaitOnConflictingTxns in this.
Jira: DB-14616

Test Plan:
Manually tested

```
Session 1                                                                  Session 2
yugabyte=# create table a (k int);
CREATE TABLE
yugabyte=# drop table a;
DROP TABLE
yugabyte=# create table a (k int, v int);
CREATE TABLE
yugabyte=# insert into a values (1, 1);
INSERT 0 1
yugabyte=# begin;
BEGIN
yugabyte=*# update a set v = v + 1 where k = 1;                             yugabyte=# update a set v = v + 1 where k = 1;
UPDATE 1
....
yugabyte=*# commit;
COMMIT

yugabyte=# SELECT
yugabyte-#     SUBSTRING(query, 1, 50) AS query,
yugabyte-#     wait_event_component,
yugabyte-#     wait_event,
yugabyte-#     wait_event_type,
yugabyte-#     COUNT(*)
yugabyte-# FROM
yugabyte-#     yb_active_session_history
yugabyte-# JOIN
yugabyte-#     pg_stat_statements
yugabyte-# ON
yugabyte-#     query_id = queryid
yugabyte-# GROUP BY
yugabyte-#     query,
yugabyte-#     wait_event_component,
yugabyte-#     wait_event,
yugabyte-#     wait_event_type
yugabyte-# ORDER BY
yugabyte-#     query,
yugabyte-#     wait_event_component,
yugabyte-#     wait_event_type;
                query                 | wait_event_component |                wait_event                | wait_event_type | count
--------------------------------------+----------------------+------------------------------------------+-----------------+-------
 create table a (k int)               | TServer              | OnCpu_Active                             | Cpu             |     1
 create table a (k int)               | YSQL                 | WaitingOnTServer                         | Network         |     1
 update a set v = v + $1 where k = $2 | TServer              | ConflictResolution_WaitOnConflictingTxns | Lock            |    33
 update a set v = v + $1 where k = $2 | YSQL                 | StorageFlush                             | Network         |    33
(4 rows)
```

Reviewers: amitanand, hbhanawat

Reviewed By: amitanand

Subscribers: ybase

Differential Revision: https://phorge.dev.yugabyte.com/D40963
Assets 2
Loading