Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[YSQL] Populate the node field in yb_lock_status() #18252

Closed
1 task done
tvesely opened this issue Jul 14, 2023 · 0 comments
Closed
1 task done

[YSQL] Populate the node field in yb_lock_status() #18252

tvesely opened this issue Jul 14, 2023 · 0 comments
Assignees
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue

Comments

@tvesely
Copy link
Contributor

tvesely commented Jul 14, 2023

Jira Link: DB-7254

Description

Issue #17940 will populate a map of of transaction IDs to the UUID of the node that originated the Postgres session in the PgGetLockStatusResponsePB.

The 'node' field in the yb_lock_status() function needs to be updated to utilize the information from this map.

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

  • I confirm this issue does not contain any sensitive information.
@tvesely tvesely added area/ysql Yugabyte SQL (YSQL) status/awaiting-triage Issue awaiting triage labels Jul 14, 2023
@tvesely tvesely self-assigned this Jul 14, 2023
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue kind/enhancement This is an enhancement of an existing feature and removed status/awaiting-triage Issue awaiting triage kind/bug This issue is a bug labels Jul 14, 2023
@sushantrmishra sushantrmishra added this to Needs Triage in Wait-Queue Based Locking via automation Jul 18, 2023
@sushantrmishra sushantrmishra moved this from Needs Triage to Tech-Preview (Due 7/21/23) in Wait-Queue Based Locking Jul 21, 2023
@sushantrmishra sushantrmishra moved this from Tech-Preview (Due 7/21/23) to In progress in Wait-Queue Based Locking Jul 21, 2023
tvesely added a commit that referenced this issue Jul 27, 2023
Summary:
Commit 6a79146 added mappings between
transaction ID and the UUID of node that originated the Postgres session
holding a lock. This commit uses this mapping to populate the 'node' field in
yb_lock_status().
Jira: DB-7254

Test Plan: ./yb_build.sh --java-test 'org.yb.pgsql.TestPgRegressProc'

Reviewers: bkolagani, pjain

Reviewed By: pjain

Subscribers: smishra, yql

Differential Revision: https://phorge.dev.yugabyte.com/D27126
@sushantrmishra sushantrmishra moved this from In progress to Done in Wait-Queue Based Locking Jul 28, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue
Projects
Status: Done
Development

No branches or pull requests

3 participants