cockroach icon indicating copy to clipboard operation
cockroach copied to clipboard

Published 20 hours ago • verified publisher icon cockroachdb

sql/opt/exec/execbuilder: TestExecBuild failed

Open cockroach-teamcity opened this issue 3 years ago • 4 comments

sql/opt/exec/execbuilder.TestExecBuild failed with artifacts on release-22.1 @ 3e49622f029f8d1935c9142ef1faba1d557cbbf0:

=== RUN   TestExecBuild
    test_log_scope.go:79: test logs captured to: /artifacts/tmp/_tmp/c0bf42d6e433409ba2f3b1c91d4717d6/logTestExecBuild2894899490
    test_log_scope.go:80: use -show-logs to present logs inline
=== CONT  TestExecBuild
    logic.go:4452: -- test log scope end --
--- FAIL: TestExecBuild (135.16s)
=== RUN   TestExecBuild/5node/distsql_distinct_on
=== PAUSE TestExecBuild/5node/distsql_distinct_on
=== CONT  TestExecBuild/5node/distsql_distinct_on
=== CONT  TestExecBuild/5node/distsql_distinct_on
    logic.go:3484: 
        
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1037/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_distinct_on:38: 
        expected success, but found
        (XXUUU) while carrying out changes [{ADD_VOTER n1,s1} {REMOVE_VOTER n5,s5}]: change replicas of r65 failed: descriptor changed: [expected] r65:/Table/107/1/{NULL/NULL/NULL-"1"/"1"/"2"} [(n5,s5):1, next=2, gen=10, sticky=9223372036.854775807,2147483647] != [actual] r65:/Table/107/1/{NULL/NULL/NULL-"1"/"1"/"2"} [(n5,s5):1, next=3, gen=12, sticky=9223372036.854775807,2147483647]
        markers.go:51: in newDescChangedError()
[10:06:20] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1037/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_distinct_on with config 5node: 5 tests, 1 failures
    logic.go:4216: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1037/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_distinct_on:38: error while processing
    logic.go:4216: pq: while carrying out changes [{ADD_VOTER n1,s1} {REMOVE_VOTER n5,s5}]: change replicas of r65 failed: descriptor changed: [expected] r65:/Table/107/1/{NULL/NULL/NULL-"1"/"1"/"2"} [(n5,s5):1, next=2, gen=10, sticky=9223372036.854775807,2147483647] != [actual] r65:/Table/107/1/{NULL/NULL/NULL-"1"/"1"/"2"} [(n5,s5):1, next=3, gen=12, sticky=9223372036.854775807,2147483647]
[10:06:20] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1037/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_indexjoin with config 5node: 8 tests, 0 failures
[10:06:21] --- total progress: 2922 statements
        --- FAIL: TestExecBuild/5node/distsql_distinct_on (6.95s)
=== RUN   TestExecBuild/5node
    --- FAIL: TestExecBuild/5node (0.00s)
Help

See also: How To Investigate a Go Test Failure (internal) Parameters in this failure:

  • TAGS=bazel,gss
Same failure on other branches

  • #81636 sql/opt/exec/execbuilder: TestExecBuild failed [C-test-failure O-robot T-sql-queries branch-release-22.1.0]
  • #81428 sql/opt/exec/execbuilder: TestExecBuild failed [C-test-failure O-robot T-sql-queries branch-master]
/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-16079

cockroach-teamcity avatar May 25 '22 10:05 cockroach-teamcity

Looks like a rebalancer error duing nightly testing?

rharding6373 avatar May 27 '22 01:05 rharding6373

sql/opt/exec/execbuilder.TestExecBuild failed with artifacts on release-22.1 @ 34e6fcfdc8f3155831305ab4a78f960aaad3e7bc:

=== RUN   TestExecBuild
    test_log_scope.go:79: test logs captured to: /artifacts/tmp/_tmp/c0bf42d6e433409ba2f3b1c91d4717d6/logTestExecBuild995720977
    test_log_scope.go:80: use -show-logs to present logs inline
=== CONT  TestExecBuild
    logic.go:4452: -- test log scope end --
--- FAIL: TestExecBuild (130.48s)
=== RUN   TestExecBuild/local/vectorize_local
=== PAUSE TestExecBuild/local/vectorize_local
=== CONT  TestExecBuild/local/vectorize_local
=== CONT  TestExecBuild/local/vectorize_local
    logic.go:3195: 
         
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2608/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/vectorize_local:235: SELECT message FROM [SHOW TRACE FOR SESSION]
        WHERE message LIKE 'querying next range at %' OR
              message = '=== SPAN START: kv.DistSender: sending partial batch ==='
        expected:
            querying next range at /Table/109/1/0/0
            querying next range at /Table/109/1/10/0
            querying next range at /Table/109/1/0/0
            === SPAN START: kv.DistSender: sending partial batch ===
            querying next range at /Table/109/1/10/0
            
        but found (query options: "") :
            querying next range at /Table/109/1/0/0
            querying next range at /Table/109/1/0/0
            querying next range at /Table/109/1/0/0
            === SPAN START: kv.DistSender: sending partial batch ===
            querying next range at /Table/109/1/10/0
[08:30:19] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2608/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/vectorize_local with config local: 21 tests, 1 failures
    logic.go:4216: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2608/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/vectorize_local:246: error while processing
    logic.go:4216: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2608/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/vectorize_local:246: too many errors encountered, skipping the rest of the input
        --- FAIL: TestExecBuild/local/vectorize_local (2.79s)
=== RUN   TestExecBuild/local
    --- FAIL: TestExecBuild/local (0.00s)
Help

See also: How To Investigate a Go Test Failure (internal) Parameters in this failure:

  • TAGS=bazel,gss
Same failure on other branches

  • #81636 sql/opt/exec/execbuilder: TestExecBuild failed [C-test-failure O-robot T-sql-queries branch-release-22.1.0]
  • #81428 sql/opt/exec/execbuilder: TestExecBuild failed [C-test-failure O-robot T-sql-queries branch-master]

This test on roachdash | Improve this report!

cockroach-teamcity avatar May 30 '22 08:05 cockroach-teamcity

We have marked this test failure issue as stale because it has been inactive for 1 month. If this failure is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 5 days to keep the test failure queue tidy.

github-actions[bot] avatar Jul 11 '22 10:07 github-actions[bot]

We have marked this test failure issue as stale because it has been inactive for 1 month. If this failure is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 5 days to keep the test failure queue tidy.

github-actions[bot] avatar Aug 11 '22 10:08 github-actions[bot]

sql/opt/exec/execbuilder.TestExecBuild failed with artifacts on release-22.1 @ 58afeb694a1451d5ae2c9bb38dd804ce22f2bb3e:

            │ order: +a
            │
            └── • lookup join
                │ estimated row count: 0
                │ table: json_tab@json_tab_pkey
                │ equality: (a) = (a)
                │ equality cols are key
                │ pred: b @> '[1, 2]'
                │
                └── • zigzag join
                      estimated row count: 0
                      left table: json_tab@foo_inv
                      left columns: (a)
                      left fixed values: 1 column
                      right table: json_tab@foo_inv
                      right columns: ()
                      right fixed values: 1 column
            ·
            Diagram: https://cockroachdb.github.io/distsqlplan/decode.html#eJyUkk9v1DAQxe98itFcCsLSxtmbT6FtEFstm5JU4k-JVt7NELlNPcF2ELDKd0dJRGGhXXVvnnl-b35jeYf-a4MK0w-Xy1eLFTw_XxRXxbvlCyjSZXp2BRpe59lbuPFs10Fv4P2bNE9hA8nnLormBCfXUkBcnkCWn6c5nH4EjQItV7TSd-RRXaPEUmDreEvesxtau_HCovqOKhJobNuFoV0K3LIjVDsMJjSECj-Z-qeuL9hYcrMIBVYUtGnG3MJUBJG6Z0u-MK-N_YZikuSDUtYFBYnEshfIXfgz2gddEyrZi6fjDWA56YrcTO7D3U_-fVi3t_QDBS6Zb7sWbthYYDuiCMxWkMT_valS6qLIVqco8Iyb7s56BZsnrBAfs0LBLpCbxfv4iXz5aPz8mPicfMvW0178Y8lRXwqkqqbpk3ju3JYuHW_HMVOZjb6xUZEPkyqnYmEnaQD82ywPmuPD5vigef6Pueyf_QoAAP__rQARbQ==
            
        but found (query options: "") :
            distribution: local
            vectorized: true
            ·
            • sort
            │ order: +a
            │
            └── • inverted filter
                │ inverted column: b_inverted_key
                │ num spans: 2
                │
                └── • scan
                      missing stats
                      table: json_tab@foo_inv
                      spans: 2 spans
            ·
            Diagram: https://cockroachdb.github.io/distsqlplan/decode.html#eJyUUlFr2zwUff9-xeW-9NumYct5GOjJXesyQ9ZkdmAbtSlKdNt5uJJ3JZdAyH8ftunWDJKtL1c6995zdA5oh_5HiwqzL8v5eX4N_1_m5ar8NH8FZTbPLlag4apYfITv3tnboNfw-UNWZLCGtOrjeEZwdiMFJPUZLIrLrID3X0GjQOsMXesH8qhuUGItsGO3Ie8dD63duJCbLapYYGO7PgztWuDGMaHaYWhCS6hwpdctFaQNcRSjQENBN-0o-2QpvXPutrGPKPDCtf2D9Qq0gDUKLDs9oOicOZJvpyNaMt0128wa0NaABBe-EWO9F-j68NuJD_qeUMm9-He3uX0kDmSumjYQE0fy0PLTPNt2DM5CKhX4wSP4oDmoCt9VVRzHQ5n9usnXQ00mjEDW_H1RVgjP83kUuOiDglQejZq8JGrpOBBHyWHAVL45Kj97iXxBvnPW04H8MeV4Xwskc0_T3_Ku5w0t2W3GZya4GHljw5AP01ROILfTaDD4nCxPkpPT5OQkefYHud7_9zMAAP__O_8gvg==
    logic.go:2553: 
         /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1129/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_inverted_index:104: too many errors encountered, skipping the rest of the input
[10:44:15] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1129/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_inverted_index with config 5node: 8 tests, 2 failures
[10:44:15] rng seed: 6052449934555611465

[10:44:16] --- total progress: 3107 statements
            --- FAIL: TestExecBuild/5node/distsql_inverted_index/json (1.87s)
=== RUN   TestExecBuild/5node/distsql_inverted_index
=== PAUSE TestExecBuild/5node/distsql_inverted_index
=== CONT  TestExecBuild/5node/distsql_inverted_index
        --- FAIL: TestExecBuild/5node/distsql_inverted_index (9.46s)
=== RUN   TestExecBuild/5node
    --- FAIL: TestExecBuild/5node (0.00s)
Help

See also: How To Investigate a Go Test Failure (internal) Parameters in this failure:

  • TAGS=bazel,gss
Same failure on other branches

  • #92989 pkg/sql/opt/exec/execbuilder/tests/5node/5node_test: TestExecBuild_distsql_misc failed [C-test-failure O-robot T-sql-queries branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity avatar Dec 12 '22 10:12 cockroach-teamcity

sql/opt/exec/execbuilder.TestExecBuild failed with artifacts on release-22.1 @ 310c0c5956115c393dea307fdd9f2e177b8c3a5e:

=== RUN   TestExecBuild
    test_log_scope.go:79: test logs captured to: /artifacts/tmp/_tmp/c0bf42d6e433409ba2f3b1c91d4717d6/logTestExecBuild1313796439
    test_log_scope.go:80: use -show-logs to present logs inline
=== CONT  TestExecBuild
    logic.go:4540: -- test log scope end --
--- FAIL: TestExecBuild (130.77s)
=== RUN   TestExecBuild/5node/distsql_distinct_on
=== PAUSE TestExecBuild/5node/distsql_distinct_on
=== CONT  TestExecBuild/5node/distsql_distinct_on
=== CONT  TestExecBuild/5node/distsql_distinct_on
    logic.go:3528: 
        
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2134/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_distinct_on:38: 
        expected success, but found
        (XXUUU) while carrying out changes [{ADD_VOTER n1,s1} {REMOVE_VOTER n5,s5}]: change replicas of r65 failed: descriptor changed: [expected] r65:/Table/107/1/{NULL/NULL/NULL-"1"/"1"/"2"} [(n5,s5):1, next=2, gen=10, sticky=9223372036.854775807,2147483647] != [actual] r65:/Table/107/1/{NULL/NULL/NULL-"1"/"1"/"2"} [(n5,s5):1, next=3, gen=12, sticky=9223372036.854775807,2147483647]
        markers.go:51: in newDescChangedError()
[10:59:43] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2134/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_distinct_on with config 5node: 5 tests, 1 failures
    logic.go:4285: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2134/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_distinct_on:38: error while processing
    logic.go:4285: pq: while carrying out changes [{ADD_VOTER n1,s1} {REMOVE_VOTER n5,s5}]: change replicas of r65 failed: descriptor changed: [expected] r65:/Table/107/1/{NULL/NULL/NULL-"1"/"1"/"2"} [(n5,s5):1, next=2, gen=10, sticky=9223372036.854775807,2147483647] != [actual] r65:/Table/107/1/{NULL/NULL/NULL-"1"/"1"/"2"} [(n5,s5):1, next=3, gen=12, sticky=9223372036.854775807,2147483647]
[10:59:43] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2134/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/inverted_join_multi_column_dist: 14 statements
[10:59:43] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2134/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_misc: 4 statements
[10:59:43] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2134/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/explain_analyze_plans: 8 statements
[10:59:43] --- total progress: 2958 statements
        --- FAIL: TestExecBuild/5node/distsql_distinct_on (9.79s)
=== RUN   TestExecBuild/5node
    --- FAIL: TestExecBuild/5node (0.00s)
Help

See also: How To Investigate a Go Test Failure (internal) Parameters in this failure:

  • TAGS=bazel,gss
Same failure on other branches

  • #92989 pkg/sql/opt/exec/execbuilder/tests/5node/5node_test: TestExecBuild_distsql_misc failed [C-test-failure O-robot T-sql-queries branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity avatar Dec 16 '22 11:12 cockroach-teamcity

sql/opt/exec/execbuilder.TestExecBuild failed with artifacts on release-22.1 @ 0403676c25d7c9bd0cadc42211885d649085e499:

=== RUN   TestExecBuild
    test_log_scope.go:79: test logs captured to: /artifacts/tmp/_tmp/c0bf42d6e433409ba2f3b1c91d4717d6/logTestExecBuild2961137516
    test_log_scope.go:80: use -show-logs to present logs inline
=== CONT  TestExecBuild
    logic.go:4540: -- test log scope end --
--- FAIL: TestExecBuild (102.22s)
=== RUN   TestExecBuild/5node/distsql_distinct_on
=== PAUSE TestExecBuild/5node/distsql_distinct_on
=== CONT  TestExecBuild/5node/distsql_distinct_on
=== CONT  TestExecBuild/5node/distsql_distinct_on
    logic.go:3528: 
        
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2506/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_distinct_on:38: 
        expected success, but found
        (XXUUU) while carrying out changes [{ADD_VOTER n1,s1} {REMOVE_VOTER n5,s5}]: change replicas of r65 failed: descriptor changed: [expected] r65:/Table/107/1/{NULL/NULL/NULL-"1"/"1"/"2"} [(n5,s5):1, next=2, gen=10, sticky=9223372036.854775807,2147483647] != [actual] r65:/Table/107/1/{NULL/NULL/NULL-"1"/"1"/"2"} [(n5,s5):1, next=3, gen=12, sticky=9223372036.854775807,2147483647]
        markers.go:51: in newDescChangedError()
[10:24:25] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2506/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_distinct_on with config 5node: 5 tests, 1 failures
    logic.go:4285: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2506/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_distinct_on:38: error while processing
    logic.go:4285: pq: while carrying out changes [{ADD_VOTER n1,s1} {REMOVE_VOTER n5,s5}]: change replicas of r65 failed: descriptor changed: [expected] r65:/Table/107/1/{NULL/NULL/NULL-"1"/"1"/"2"} [(n5,s5):1, next=2, gen=10, sticky=9223372036.854775807,2147483647] != [actual] r65:/Table/107/1/{NULL/NULL/NULL-"1"/"1"/"2"} [(n5,s5):1, next=3, gen=12, sticky=9223372036.854775807,2147483647]
        --- FAIL: TestExecBuild/5node/distsql_distinct_on (6.25s)
=== RUN   TestExecBuild/5node
    --- FAIL: TestExecBuild/5node (0.00s)
Help

See also: How To Investigate a Go Test Failure (internal) Parameters in this failure:

  • TAGS=bazel,gss
Same failure on other branches

  • #92989 pkg/sql/opt/exec/execbuilder/tests/5node/5node_test: TestExecBuild_distsql_misc failed [C-test-failure O-robot T-sql-queries branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity avatar Dec 17 '22 10:12 cockroach-teamcity

sql/opt/exec/execbuilder.TestExecBuild failed with artifacts on release-22.1 @ 96481c6193816b18cfb148eb21b4018f463d8565:

            │ order: +a
            │
            └── • lookup join
                │ estimated row count: 0
                │ table: json_tab@json_tab_pkey
                │ equality: (a) = (a)
                │ equality cols are key
                │ pred: b @> '[1, 2]'
                │
                └── • zigzag join
                      estimated row count: 0
                      left table: json_tab@foo_inv
                      left columns: (a)
                      left fixed values: 1 column
                      right table: json_tab@foo_inv
                      right columns: ()
                      right fixed values: 1 column
            ·
            Diagram: https://cockroachdb.github.io/distsqlplan/decode.html#eJyUkk9v1DAQxe98itFcCsLSxtmbT6FtEFstm5JU4k-JVt7NELlNPcF2ELDKd0dJRGGhXXVvnnl-b35jeYf-a4MK0w-Xy1eLFTw_XxRXxbvlCyjSZXp2BRpe59lbuPFs10Fv4P2bNE9hA8nnLormBCfXUkBcnkCWn6c5nH4EjQItV7TSd-RRXaPEUmDreEvesxtau_HCovqOKhJobNuFoV0K3LIjVDsMJjSECj-Z-qeuL9hYcrMIBVYUtGnG3MJUBJG6Z0u-MK-N_YZikuSDUtYFBYnEshfIXfgz2gddEyrZi6fjDWA56YrcTO7D3U_-fVi3t_QDBS6Zb7sWbthYYDuiCMxWkMT_valS6qLIVqco8Iyb7s56BZsnrBAfs0LBLpCbxfv4iXz5aPz8mPicfMvW0178Y8lRXwqkqqbpk3ju3JYuHW_HMVOZjb6xUZEPkyqnYmEnaQD82ywPmuPD5vigef6Pueyf_QoAAP__rQARbQ==
            
        but found (query options: "") :
            distribution: local
            vectorized: true
            ·
            • sort
            │ order: +a
            │
            └── • inverted filter
                │ inverted column: b_inverted_key
                │ num spans: 2
                │
                └── • scan
                      missing stats
                      table: json_tab@foo_inv
                      spans: 2 spans
            ·
            Diagram: https://cockroachdb.github.io/distsqlplan/decode.html#eJyUUlFr2zwUff9-xeW-9NumYct5GOjJXesyQ9ZkdmAbtSlKdNt5uJJ3JZdAyH8ftunWDJKtL1c6995zdA5oh_5HiwqzL8v5eX4N_1_m5ar8NH8FZTbPLlag4apYfITv3tnboNfw-UNWZLCGtOrjeEZwdiMFJPUZLIrLrID3X0GjQOsMXesH8qhuUGItsGO3Ie8dD63duJCbLapYYGO7PgztWuDGMaHaYWhCS6hwpdctFaQNcRSjQENBN-0o-2QpvXPutrGPKPDCtf2D9Qq0gDUKLDs9oOicOZJvpyNaMt0128wa0NaABBe-EWO9F-j68NuJD_qeUMm9-He3uX0kDmSumjYQE0fy0PLTPNt2DM5CKhX4wSP4oDmoCt9VVRzHQ5n9usnXQ00mjEDW_H1RVgjP83kUuOiDglQejZq8JGrpOBBHyWHAVL45Kj97iXxBvnPW04H8MeV4Xwskc0_T3_Ku5w0t2W3GZya4GHljw5AP01ROILfTaDD4nCxPkpPT5OQkefYHud7_9zMAAP__O_8gvg==
    logic.go:2553: 
         /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1112/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_inverted_index:104: too many errors encountered, skipping the rest of the input
[11:10:11] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1112/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_inverted_index with config 5node: 8 tests, 2 failures
[11:10:11] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1112/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_numtables with config 5node: 25 tests, 0 failures
[11:10:11] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1112/execroot/cockroach/bazel-out/k8-dbg/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execbuilder/testdata/distsql_indexjoin with config 5node: 8 tests, 0 failures
[11:10:11] --- total progress: 2961 statements
            --- FAIL: TestExecBuild/5node/distsql_inverted_index/json (1.24s)
=== RUN   TestExecBuild/5node/distsql_inverted_index
=== PAUSE TestExecBuild/5node/distsql_inverted_index
=== CONT  TestExecBuild/5node/distsql_inverted_index
        --- FAIL: TestExecBuild/5node/distsql_inverted_index (8.21s)
=== RUN   TestExecBuild/5node
    --- FAIL: TestExecBuild/5node (0.00s)

Parameters: TAGS=bazel,gss

Help

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

Same failure on other branches

  • #97003 pkg/sql/opt/exec/execbuilder/tests/local/local_test: TestExecBuild_explain failed [C-test-failure O-robot T-sql-queries branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity avatar Feb 13 '23 11:02 cockroach-teamcity

22.1 is now out of support, closing.

erikgrinaker avatar May 24 '23 07:05 erikgrinaker