search

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
https://www.yugabyte.com
Other
8.91k stars 1.06k forks source link

[YSQL] pg_locks view returning no results after lock acquisition #21575

Open Karvy-yb opened 6 months ago

Karvy-yb commented 6 months ago

Jira Link: DB-10459

Description

We are observing intermittent failure while trying to select from pg_locks in recent builds of master and 2.20.2.1 -b1 Basically sometimes the pg_locks view returns no results (empty) even when we select from it after starting a transaction that has acquired a lock. Since the test is flaky, it passes in rerun

The tests only select from pg_locks after acquiring locks and sleeping for 1 minute.

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

rajapriya371 commented 6 months ago

observing for above issue for test testwaitonconflictwithmanualtabletsplitting-aws-rf3 in builds 2.23.0.0-b15,b33

rajapriya371 commented 6 months ago

Observing above issue for test testwaitonconflictwithmanualtabletsplitting-aws-rf3 within versions 2.20.4.0-b3 and 2.20.4.0-b7