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

sql/logictest: TestSqlLiteLogic failed #82783

Closed
cockroach-teamcity opened this issue Jun 11, 2022 · 3 comments · Fixed by #82829
Closed

sql/logictest: TestSqlLiteLogic failed #82783

cockroach-teamcity opened this issue Jun 11, 2022 · 3 comments · Fixed by #82829
Assignees
Labels
branch-release-22.1 Used to mark GA and release blockers, technical advisories, and bugs for 22.1 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-queries SQL Queries Team

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Jun 11, 2022

sql/logictest.TestSqlLiteLogic failed with artifacts on release-22.1 @ 3181b7faa2f3b41d6a15ab4b74d2c60bcfe5132d:

[09:26:23] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_0.test: 2700 statements
[09:26:23] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_1.test: 6973 statements
[09:26:23] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_3.test: 848 statements
[09:26:24] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_6.test: 3930 statements
[09:26:25] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_0.test: 2861 statements
[09:26:25] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_1.test: 7125 statements
[09:26:25] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_3.test: 1021 statements
[09:26:26] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_6.test: 4091 statements
[09:26:27] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_0.test: 3032 statements
[09:26:27] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_1.test: 7288 statements
[09:26:27] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_3.test: 1182 statements
[09:26:28] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_6.test: 4256 statements
[09:26:29] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_0.test: 3184 statements
[09:26:29] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_1.test: 7466 statements
[09:26:29] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_3.test: 1358 statements
[09:26:30] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_6.test: 4379 statements
[09:26:31] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_0.test: 3344 statements
[09:26:31] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_1.test: 7628 statements
[09:26:31] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_3.test: 1548 statements
[09:26:32] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_6.test: 4528 statements
[09:26:33] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_0.test: 3505 statements
[09:26:33] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_1.test: 7743 statements
[09:26:33] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_3.test: 1721 statements
[09:26:34] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_6.test: 4691 statements
[09:26:35] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_0.test: 3675 statements
[09:26:35] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_1.test: 7905 statements
[09:26:35] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_3.test: 1895 statements
[09:26:36] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_6.test: 4838 statements
[09:26:37] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_0.test: 3828 statements
[09:26:37] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_1.test: 8078 statements
[09:26:37] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_3.test: 2079 statements
[09:26:38] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_6.test: 5001 statements
[09:26:39] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_0.test: 3988 statements
[09:26:39] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_1.test with config fakedist-metadata: 8172 tests, 0 failures
[09:26:39] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_3.test: 2240 statements
[09:26:40] --- total progress: 9491370 statements
=== CONT  TestSqlLiteLogic/fakedist-metadata/slt_good_3.test#13
    logic.go:3484: 
        
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_3.test:18360: SELECT pk, col0 FROM view_2_tab2_410
        expected success, but found
        (XXUUU) txn already encountered an error; cannot be used anymore (previous err: concurrent txn use detected. ba: Scan [/Table/108/1/5,/Table/108/1/6), [txn: 5142c00a])
    logic.go:3195: 
         pq: txn already encountered an error; cannot be used anymore (previous err: concurrent txn use detected. ba: Scan [/Table/108/1/5,/Table/108/1/6), [txn: 5142c00a])
[09:27:07] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_3.test with config fakedist-metadata: 3888 tests, 2 failures
    logic.go:4216: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_3.test:18366: error while processing
    logic.go:4216: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_3.test:18366: too many errors encountered, skipping the rest of the input
[09:27:07] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/100/slt_good_0.test: 5930 statements
        --- FAIL: TestSqlLiteLogic/fakedist-metadata/slt_good_3.test#13 (57.24s)
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-16658

@cockroach-teamcity cockroach-teamcity added branch-release-22.1 Used to mark GA and release blockers, technical advisories, and bugs for 22.1 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. labels Jun 11, 2022
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label Jun 11, 2022
@cockroach-teamcity
Copy link
Member Author

sql/logictest.TestSqlLiteLogic failed with artifacts on release-22.1 @ 3181b7faa2f3b41d6a15ab4b74d2c60bcfe5132d:

=== CONT  TestSqlLiteLogic/fakedist-vec-off/slt_good_3.test#07
    logic.go:3484: 
        
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test:49221: SELECT pk FROM tab4 WHERE (col0 = 27 AND col1 < 91.77 AND ((col4 IS NULL AND col3 > 62) AND col4 > 16.31) AND ((col3 IN (15,85,58,85,28) OR (col3 < 92))) OR col3 <= 63 AND (col4 > 72.55 OR col4 IS NULL AND col3 IS NULL) OR col0 IS NULL AND col4 >= 24.62 AND ((col4 > 49.70 OR col4 = 10.16 OR col3 BETWEEN 57 AND 58 OR col4 >= 31.50) OR col0 = 26 OR ((((col4 >= 30.11) AND (col4 > 89.54))))) OR col3 <= 44 AND ((((((col3 >= 36) OR col1 > 92.44 AND (col3 > 31) AND col3 IN (9,81,84,72) AND (col3 > 79 AND ((col3 <= 89 OR col0 < 63))) AND (col4 < 28.60)) AND col0 < 3))))) AND (col1 > 45.94 AND col3 >= 52 OR col3 > 5 OR col4 < 36.32)
        expected success, but found
        (XX000) internal error: concurrent txn use detected. ba: Scan [/Table/110/1/9/0,/Table/110/1/9/1/2), Get [/Table/110/1/9/3/1,/Min), Get [/Table/110/1/9/5/1,/Min), [txn: d39d1a75], [can-forward-ts]
        txn_lock_gatekeeper.go:70: in SendLocked()
        DETAIL: stack trace:
        github.com/cockroachdb/cockroach/pkg/kv/kvclient/kvcoord/txn_lock_gatekeeper.go:70: SendLocked()
        github.com/cockroachdb/cockroach/pkg/kv/kvclient/kvcoord/txn_interceptor_metric_recorder.go:46: SendLocked()
        github.com/cockroachdb/cockroach/pkg/kv/kvclient/kvcoord/txn_interceptor_committer.go:129: SendLocked()
        github.com/cockroachdb/cockroach/pkg/kv/kvclient/kvcoord/txn_interceptor_span_refresher.go:242: sendLockedWithRefreshAttempts()
        github.com/cockroachdb/cockroach/pkg/kv/kvclient/kvcoord/txn_interceptor_span_refresher.go:177: SendLocked()
        github.com/cockroachdb/cockroach/pkg/kv/kvclient/kvcoord/txn_interceptor_pipeliner.go:290: SendLocked()
        github.com/cockroachdb/cockroach/pkg/kv/kvclient/kvcoord/txn_interceptor_seq_num_allocator.go:105: SendLocked()
        github.com/cockroachdb/cockroach/pkg/kv/kvclient/kvcoord/txn_interceptor_heartbeater.go:232: SendLocked()
        github.com/cockroachdb/cockroach/pkg/kv/kvclient/kvcoord/txn_coord_sender.go:532: Send()
        github.com/cockroachdb/cockroach/pkg/kv/db.go:985: sendUsingSender()
        github.com/cockroachdb/cockroach/pkg/kv/txn.go:1124: Send()
        github.com/cockroachdb/cockroach/pkg/sql/row/kv_batch_fetcher.go:181: func1()
        github.com/cockroachdb/cockroach/pkg/sql/row/kv_batch_fetcher.go:347: fetch()
        github.com/cockroachdb/cockroach/pkg/sql/row/kv_batch_fetcher.go:531: nextBatch()
        github.com/cockroachdb/cockroach/pkg/sql/row/kv_fetcher.go:209: NextKV()
        github.com/cockroachdb/cockroach/pkg/sql/row/fetcher.go:539: nextKey()
        github.com/cockroachdb/cockroach/pkg/sql/row/fetcher.go:509: StartScanFrom()
        github.com/cockroachdb/cockroach/pkg/sql/row/fetcher.go:379: StartScan()
        github.com/cockroachdb/cockroach/pkg/sql/rowexec/stats.go:104: StartScan()
        github.com/cockroachdb/cockroach/pkg/sql/rowexec/joinreader.go:894: readInput()
        github.com/cockroachdb/cockroach/pkg/sql/rowexec/joinreader.go:658: Next()
        github.com/cockroachdb/cockroach/pkg/sql/rowexec/stats.go:68: Next()
        github.com/cockroachdb/cockroach/pkg/sql/rowexec/filterer.go:81: Next()
        github.com/cockroachdb/cockroach/pkg/sql/rowflow/input_sync.go:387: Next()
        github.com/cockroachdb/cockroach/pkg/sql/rowexec/stats.go:68: Next()
        github.com/cockroachdb/cockroach/pkg/sql/rowexec/noop.go:74: Next()
        github.com/cockroachdb/cockroach/pkg/sql/rowexec/stats.go:68: Next()
        github.com/cockroachdb/cockroach/pkg/sql/rowexec/distinct.go:221: Next()
        github.com/cockroachdb/cockroach/pkg/sql/execinfra/base.go:187: Run()
        github.com/cockroachdb/cockroach/pkg/sql/execinfra/processorsbase.go:753: Run()
        github.com/cockroachdb/cockroach/pkg/sql/flowinfra/flow.go:419: func1()
        GOROOT/src/runtime/asm_amd64.s:1581: goexit()
        
        NOTE: internal errors may have more details in logs. Use -show-logs.
    logic.go:3195: 
         pq: internal error: concurrent txn use detected. ba: Scan [/Table/110/1/9/0,/Table/110/1/9/1/2), Get [/Table/110/1/9/3/1,/Min), Get [/Table/110/1/9/5/1,/Min), [txn: d39d1a75], [can-forward-ts]
[09:01:29] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test with config fakedist-vec-off: 8775 tests, 2 failures
    logic.go:4216: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test:49227: error while processing
    logic.go:4216: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test:49227: too many errors encountered, skipping the rest of the input
[09:01:30] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/orderby_nosort/10/slt_good_15.test: 6364 statements
        --- FAIL: TestSqlLiteLogic/fakedist-vec-off/slt_good_3.test#07 (108.86s)
Help

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

This test on roachdash | Improve this report!

@yuzefovich
Copy link
Member

Pretty sure #82651 is to blame.

@yuzefovich yuzefovich self-assigned this Jun 12, 2022
@cockroach-teamcity
Copy link
Member Author

sql/logictest.TestSqlLiteLogic failed with artifacts on release-22.1 @ 3181b7faa2f3b41d6a15ab4b74d2c60bcfe5132d:

[09:25:27] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_4.test: 5126 statements
[09:25:28] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test: 5005 statements
[09:25:28] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_5.test: 7797 statements
[09:25:28] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_4.test: 8006 statements
[09:25:29] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_4.test: 5274 statements
[09:25:30] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_5.test: 7969 statements
[09:25:30] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test: 5116 statements
[09:25:30] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_4.test: 8319 statements
[09:25:31] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_4.test: 5416 statements
[09:25:32] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test: 5203 statements
[09:25:32] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_5.test: 8010 statements
[09:25:32] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_4.test: 8436 statements
[09:25:33] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_4.test: 5586 statements
[09:25:34] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test: 5418 statements
[09:25:34] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_4.test: 8644 statements
[09:25:34] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_5.test: 8034 statements
[09:25:35] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_4.test: 5738 statements
[09:25:36] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test: 5553 statements
[09:25:36] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_4.test: 8958 statements
[09:25:36] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_5.test: 8056 statements
[09:25:37] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_4.test: 5900 statements
[09:25:38] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test: 5815 statements
[09:25:38] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_4.test: 9199 statements
[09:25:38] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_5.test: 8077 statements
[09:25:39] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_4.test: 6060 statements
[09:25:40] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test: 6071 statements
[09:25:40] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_4.test: 9341 statements
[09:25:40] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_5.test: 8085 statements
[09:25:41] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_4.test: 6209 statements
[09:25:42] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test: 6299 statements
[09:25:42] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_4.test: 9525 statements
[09:25:43] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_5.test: 8224 statements
[09:25:43] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_4.test: 6382 statements
[09:25:44] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/view/10/slt_good_5.test with config fakedist-metadata: 8317 tests, 0 failures
[09:25:44] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test: 6472 statements
[09:25:44] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_4.test: 9690 statements
[09:25:44] --- total progress: 9325536 statements
=== CONT  TestSqlLiteLogic/fakedist-metadata/slt_good_3.test#07
    logic.go:3484: 
        
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test:49233: SELECT pk FROM tab4 WHERE (col0 = 27 AND col1 < 91.77 AND ((col4 IS NULL AND col3 > 62) AND col4 > 16.31) AND (((col3 = 15 OR col3 = 85 OR col3 = 58 OR col3 = 85 OR col3 = 28) OR (col3 < 92))) OR col3 <= 63 AND (col4 > 72.55 OR col4 IS NULL AND col3 IS NULL) OR col0 IS NULL AND col4 >= 24.62 AND ((col4 > 49.70 OR col4 = 10.16 OR col3 BETWEEN 57 AND 58 OR col4 >= 31.50) OR col0 = 26 OR ((((col4 >= 30.11) AND (col4 > 89.54))))) OR col3 <= 44 AND ((((((col3 >= 36) OR col1 > 92.44 AND (col3 > 31) AND (col3 = 9 OR col3 = 81 OR col3 = 84 OR col3 = 72) AND (col3 > 79 AND ((col3 <= 89 OR col0 < 63))) AND (col4 < 28.60)) AND col0 < 3))))) AND (col1 > 45.94 AND col3 >= 52 OR col3 > 5 OR col4 < 36.32)
        expected success, but found
        (XXUUU) txn already encountered an error; cannot be used anymore (previous err: concurrent txn use detected. ba: Scan [/Table/110/1/1,/Table/110/1/2), Scan [/Table/110/1/2,/Table/110/1/3), Scan [/Table/110/1/4,/Table/110/1/5), Scan [/Table/110/1/5,/Table/110/1/6), Scan [/Table/110/1/6,/Table/110/1/7), Scan [/Table/110/1/7,/Table/110/1/8), Scan [/Table/110/1/8,/Table/110/1/9), [txn: 224028d1], [can-forward-ts])
    logic.go:3195: 
         pq: txn already encountered an error; cannot be used anymore (previous err: concurrent txn use detected. ba: Scan [/Table/110/1/1,/Table/110/1/2), Scan [/Table/110/1/2,/Table/110/1/3), Scan [/Table/110/1/4,/Table/110/1/5), Scan [/Table/110/1/5,/Table/110/1/6), Scan [/Table/110/1/6,/Table/110/1/7), Scan [/Table/110/1/7,/Table/110/1/8), Scan [/Table/110/1/8,/Table/110/1/9), [txn: 224028d1], [can-forward-ts])
[09:26:10] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test with config fakedist-metadata: 8777 tests, 2 failures
    logic.go:4216: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test:49239: error while processing
    logic.go:4216: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3574/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/logictest_test_/logictest_test.runfiles/cockroach/external/com_github_cockroachdb_sqllogictest/test/index/in/10/slt_good_3.test:49239: too many errors encountered, skipping the rest of the input
        --- FAIL: TestSqlLiteLogic/fakedist-metadata/slt_good_3.test#07 (100.33s)
Help

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

This test on roachdash | Improve this report!

craig bot pushed a commit that referenced this issue Jun 13, 2022
82548: randgen: fix postgres mutator for session vars r=otan a=rafiss

fixes #67791

Release note: None

82693: rowexec: improve join reader memory usage when ordering is maintained r=yuzefovich a=yuzefovich

This commit improves the join reader behavior when used by lookup joins
when ordering is maintained. In that case, we have a disk-backed row
container that we can spill to disk in order to free up some memory.
Previously, we would do so only in the case when the memory error occurs
inside of the strategy but would make the query error out if the memory
reservation is denied in the span generator or in the join reader
itself. This commit makes it so that in all places where the memory
accounting is performed, we try to ask the strategy to handle the memory
reservations. This allows the join reader ordering strategy attempt
spilling looked up rows to disk in all scenarios first, before erroring
out the query.

Additionally, this commit makes it so that the memory monitor used by
that disk-backed row container doesn't hold on to any memory when the
corresponding memory account is cleared. By default, our memory monitor
can keep a margin of 100KiB in reserve, but this behavior doesn't make
sense when we're forcing the disk-backed container to use disk.

Release note: None

82749: schemachanger: eager statement phase r=ajwerner a=postamar

This commit reworks how the declarative schema changer performs DROPs by
removing support for synthetic descriptors in the statement transaction.
In-transaction operations are now executed eagerly in the statement
phase instead of being deferred to the pre-commit phase.

The most significant change this entails is to the rules definitions,
since we now no longer have the TXN_DROPPED status. I have taken this
opportunity to rewrite them in a way that involves more element set
definitions, whose properties are enforced by init-time assertions.

The operation implementations in scexec have been simplified somewhat,
not having to concern ourselves with synthetic descriptors any more.
The opgen definitions are also simplified now that they are no longer
peppered with pre-commit phase constraints. Instead, phase constraints
are implied by the number of transitions: more than 1 and those other
than the first are implied to be restricted to post-commit. This makes
all phase constraints implicit.

This commit improves the graph validation logic to detect all cycles,
not just dep-edge cycles, and renders any detected cycle in the detail
of the resulting error.

This commit makes some changes in the test dependencies which mock the
catalog API, as this now has to support both the in-txn and committed
state of the catalog. In the process this commit adds better support for
descriptor modification times.

Release note: None

82751: scripts: adjust bump-pebble.sh to add build/bazelutil/distdir_files.bzl r=nicktrav a=jbowens

The bump-pebble.sh script should `git add build/bazelutil/distdir_files.bzl`
which requires updates whenever the Pebble version is bumped.

Release note: None

82757: kvserver: implied GCThreshold should be computed from readAt r=ajwerner a=adityamaru

`checkGCThresholdAndLeaseRLocked` checks a batch request against
a replicas' lease and GCThreshold. When computing the implied
GCThreshold we were incorrectly using the clock timestamp at which the
lease for the request was evaluated, instead of the timestamp at
which the cached protected timestamp state was last updated.

The cached pts state is updated everytime the replica observes
a fresher protected timestamp state when being considered for GC.
In order to uphold the invariants provided by the protected timestamp
subsystem, GC decisions must be made based on the timestamp at which
the PTS state  was last `readAt`. This is akin to how
the GC queue picks its implied GCTimestamp in `checkProtectedTimestampsForGC`.

Concretely, this bug manifested as an ExportRequest failing with a
`BatchTimestampBeforeGCError` even though a protected timestamp record
had been written and reconciled. This was a consequence of the implied
GCThreshold not taking into account the PTS state.

Informs: https://github.com/cockroachlabs/support/issues/1638

Release note: None

82829: distsql: create LeafTxn eagerly for local flow of a distributed plan r=yuzefovich a=yuzefovich

This commit makes it so that we eagerly create LeafTxns for local flows
of distributed plans. I believe it was an oversight in d6077d5
(added during 21.2 release cycle) where we started creating LeafTxns
eagerly when the local flow has concurrency. We can do the same thing
for local flows of distributed queries since we know that they must use
LeafTxns anyway.

This oversight was recently exposed by 6c88496
where some processors began storing the txn internally, rather than
accessing it from the flow context. The thing is that we do update the
references to the correct txn from the flow context, but it is done
_after_ the flow setup has been complete, at which point some processors
might have already captured the wrong txn. In particular, this is the
case for a local flow of a distributed query with index / lookup joins
when the streamer API is disabled.

Fixes: #82775.
Fixes: #82776.
Fixes: #82777.
Fixes: #82783.

Release note: None

Co-authored-by: Rafi Shamim <[email protected]>
Co-authored-by: Yahor Yuzefovich <[email protected]>
Co-authored-by: Marius Posta <[email protected]>
Co-authored-by: Jackson Owens <[email protected]>
Co-authored-by: Aditya Maru <[email protected]>
@craig craig bot closed this as completed in #82829 Jun 13, 2022
@mgartner mgartner moved this to Done in SQL Queries Jul 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
branch-release-22.1 Used to mark GA and release blockers, technical advisories, and bugs for 22.1 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-queries SQL Queries Team
Projects
Archived in project
Development

Successfully merging a pull request may close this issue.

2 participants