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] Lack of failures on rapid row lock queries #2910

Closed
jaki opened this issue Nov 12, 2019 · 1 comment
Closed

[YSQL] Lack of failures on rapid row lock queries #2910

jaki opened this issue Nov 12, 2019 · 1 comment
Assignees
Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug priority/medium Medium priority issue

Comments

@jaki
Copy link
Contributor

jaki commented Nov 12, 2019

Jira Link: DB-2190
When rapidly executing statements interleaved in transactions and related to row locking, there may be cases where failures don't happen when they should. For instance, executing the following rapidly can work (ignoring issue #2857):

Session A Session B
CREATE TABLE t (i int, j int PRIMARY KEY)
INSERT INTO t VALUES (1, 10), (2, 20), (3, 30)
BEGIN ISOLATION LEVEL REPEATABLE READ
SELECT '(setting read point)'
BEGIN ISOLATION LEVEL REPEATABLE READ
SELECT '(setting read point)'
SELECT * FROM t FOR UPDATE
SELECT * FROM t FOR UPDATE
COMMIT
COMMIT

The test function PgMiniTest::TestRowLockConflictMatrix encounters this, so some time between queries is added as a workaround.

@jaki jaki added the area/ysql Yugabyte SQL (YSQL) label Nov 12, 2019
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jun 9, 2022
@yugabyte-ci yugabyte-ci assigned pkj415 and unassigned mbautin Aug 31, 2023
@pkj415
Copy link
Contributor

pkj415 commented Aug 31, 2023

I think the issue doesn't exist anymore since I don't see a sleep anymore between explicit row-locking statements in TestRowLockConflictMatrix().

@pkj415 pkj415 closed this as completed Aug 31, 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/bug This issue is a bug priority/medium Medium priority issue
Projects
Status: Done
Development

No branches or pull requests

4 participants