pkg/sql/logictest/tests/local/local_test: TestLogic_select_for_update_read_committed failed

[cockroach-teamcity]

pkg/sql/logictest/tests/local/local_test.TestLogic_select_for_update_read_committed failed with artifacts on release-23.2 @ 3744e5655559d3350aedaf1fbbaecbf1e69c98d6:

[07:42:51] CREATE TABLE bcd (b INT PRIMARY KEY, c INT, d INT, INDEX (c), FAMILY (b, c, d));
[07:42:51] INSERT INTO bcd VALUES (20, 200, 2000), (30, 300, 3000), (40, 400, 4000);
[07:42:51] GRANT ALL on abc TO testuser;
[07:42:51] GRANT ALL on bcd TO testuser;
[07:42:51] BEGIN;
[07:42:51] SELECT * FROM abc WHERE a != 3 FOR UPDATE;
[07:42:51] 	-- OK;
[07:42:51] SELECT * FROM bcd ORDER BY c DESC LIMIT 2 FOR SHARE;
[07:42:51] 	-- OK;
[07:42:51] SELECT * FROM abc;
[07:42:51] 	-- OK;
[07:42:51] SELECT * FROM bcd;
[07:42:51] 	-- OK;
[07:42:51] SELECT * FROM abc FOR UPDATE SKIP LOCKED;
[07:42:51] 	-- OK;
[07:42:51] SELECT * FROM bcd FOR UPDATE SKIP LOCKED;
[07:42:51] 	-- OK;
[07:42:51] SELECT * FROM abc FOR SHARE;
[07:42:51] SELECT * FROM bcd FOR SHARE;
[07:42:52] 	-- OK;
[07:42:52] SELECT * FROM abc FOR UPDATE;
[07:42:52] SELECT * FROM bcd FOR UPDATE;
[07:42:52] SELECT a FROM abc WHERE a = 2 FOR UPDATE;
[07:42:52] SELECT b FROM abc WHERE a = 2 FOR UPDATE;
[07:42:52] SELECT c FROM abc WHERE a = 2 FOR UPDATE;
[07:42:52] SELECT c FROM abc ORDER BY a DESC LIMIT 2 FOR UPDATE;
[07:42:52] SELECT a + b + c FROM abc FOR UPDATE;
[07:42:52] SELECT * FROM abc JOIN bcd USING (b) FOR SHARE;
[07:42:52] SELECT * FROM abc JOIN bcd USING (c) FOR UPDATE;
[07:42:52] UPDATE abc SET b = b + 1, c = c + 1 WHERE a != 3;
[07:42:52] COMMIT;
[07:42:52] 	-- OK;
[07:42:52] 	-- OK;
[07:42:52] 	-- OK;
[07:42:52] 	-- OK;
[07:42:52] 	-- OK;
[07:42:52] 	-- OK;
[07:42:52] 	-- OK;
[07:42:52] 	-- OK;
[07:42:52] 	-- FAIL
    logic.go:2606: 
         to prevent flakes in queries that return multiple rows, add the rowsort option, the valuesort option, the partialsort option, or an ORDER BY clause. If you are certain that your test will not flake due to a non-deterministic ordering of rows, you can add the nosort option to ignore this error
[07:42:52] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/4185/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/local/local_test_/local_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/select_for_update_read_committed with config local: 37 tests, 1 failures

    logic.go:3998: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/4185/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/local/local_test_/local_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/select_for_update_read_committed:181: error while processing
    logic.go:3998: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/4185/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/local/local_test_/local_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/select_for_update_read_committed:181: too many errors encountered, skipping the rest of the input
    panic.go:522: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/9842ae56c415bac8da2062d2590d733b/logTestLogic_select_for_update_read_committed1621277230
--- FAIL: TestLogic_select_for_update_read_committed (8.38s)

Help

See also: How To Investigate a Go Test Failure (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-32549