sql/opt/exec/execbuilder: TestExecBuild failed

[cockroach-teamcity]

sql/opt/exec/execbuilder.TestExecBuild failed with artifacts on master @ 394e35cbbb7ae466383c3ee6f2bbcc76857afeed:

=== RUN   TestExecBuild
    test_log_scope.go:73: test logs captured to: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestExecBuild649580079
    test_log_scope.go:74: use -show-logs to present logs inline
=== CONT  TestExecBuild
    logic.go:3424: -- test log scope end --
test logs left over in: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestExecBuild649580079
--- FAIL: TestExecBuild (83.56s)
=== RUN   TestExecBuild/local/show_trace_nonmetamorphic/system_table_lookup
    logic.go:2352: let $rangeid = 44
=== CONT  TestExecBuild/local/show_trace_nonmetamorphic/system_table_lookup
    logic.go:2311: 
         
        testdata/show_trace_nonmetamorphic:364: SELECT operation, message FROM [SHOW KV TRACE FOR SESSION]
        WHERE message     LIKE '%r44: sending batch%'
          AND message NOT LIKE '%PushTxn%'
          AND message NOT LIKE '%QueryTxn%'
        expected:
            dist sender send  r44: sending batch 6 CPut to (n1,s1):1
            dist sender send  r44: sending batch 6 CPut to (n1,s1):1
            dist sender send  r44: sending batch 6 CPut to (n1,s1):1
            dist sender send  r44: sending batch 6 CPut to (n1,s1):1
            dist sender send  r44: sending batch 1 EndTxn to (n1,s1):1
        but found (query options: "") :
            dist sender send  r44: sending batch 14 CPut to (n1,s1):1
            dist sender send  r44: sending batch 10 CPut, 1 EndTxn to (n1,s1):1
--- done: testdata/show_trace_nonmetamorphic with config local: 48 tests, 1 failures
--- done: testdata/tuple with config local: 19 tests, 0 failures
            --- FAIL: TestExecBuild/local/show_trace_nonmetamorphic/system_table_lookup (0.76s)
=== RUN   TestExecBuild/local/show_trace_nonmetamorphic
=== PAUSE TestExecBuild/local/show_trace_nonmetamorphic
=== CONT  TestExecBuild/local/show_trace_nonmetamorphic
        --- FAIL: TestExecBuild/local/show_trace_nonmetamorphic (2.71s)
=== RUN   TestExecBuild/local
    --- FAIL: TestExecBuild/local (0.00s)

Reproduce

To reproduce, try:

make stressrace TESTS=TestExecBuild PKG=./pkg/sql/opt/exec/execbuilder TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Parameters in this failure:

• GOFLAGS=-parallel=4

/cc @cockroachdb/sql-queries RaduBerinde

This test on roachdash | Improve this report!

[yuzefovich]

Hm, I'm not able to repro after thousands of runs on the gceworker.

I also don't understand how this could occur - we're forcing the production value for sql.mutations.mutation_batch_byte_size cluster setting (which is 4MiB) as well as the production values for mutations.MaxBatchSize, so we should always be getting batches with 6 rows.

Closing as unreproducible.