pkg/sql/logictest/tests/local-mixed-24.2/local-mixed-24_2_test: TestLogic_union failed [aborted in DistSender: result is ambiguous]

[cockroach-teamcity]

pkg/sql/logictest/tests/local-mixed-24.2/local-mixed-24_2_test.TestLogic_union failed with artifacts on master @ dcce4cafa234525fc859d32745c11ed87890dc7b:

                  96   6         9600          100       1            0       0            0         0        1          100            1              0  128   3  0.781            1       0            0       0            1            0       0               8       0               0       0               0       0               4       0               0         0               0           0
                 112   7        11200          100       1            0       0            0         0        1          100            1              0  256   7  0.390            1       0            0       0            1            0       0               8       0               0       0               0       0               4       0               0         0               0           0
                 128   8         4096           32       0            0       0            0         0        1           32            1              0   32   1      1            1       0            0       0            1            0       0               8       0               0       0               0       0               4       0               0         0               0           0
                 160   9        16000          100       1            0       0            0         0        1          100            1              0  128   5  0.781            1       0            0       0            1            0       0               8       0               0       0               0       0               4       0               0         0               0           0
                 192  10        12288           64       1            0       0            0         0        1           64            1              0   64   3      1            1       0            0       0            1            0       0               8       0               0       0               0       0               4       0               0         0               0           0
                 224  11        22400          100       1            0       0            0         0        1          100            1              0  128   7  0.781            1       0            0       0            1            0       0               8       0               0       0               0       0               4       0               0         0               0           0
                 256  12         4096           16       0            0       0            0         0        1           16            1              0   16   1      1            1       0            0       0            1            0       0               8       0               0       0               0       0               4       0               0         0               0           0
                     ---
                 384  14        12288           32       0            0       0            0         0        1           32            1              0   32   3      1            1       0            0       0            1            0       0               8       0               0       0               0       0               4       0               0         0               0           0
                     ---
                 512  16         5120           10       0            0       0            0         0        1           10            2              0    8   1  0.625            1       0            0       0            2            0       0               9       0               0       0               0       0               4       0               0         0               0           0
                 640  17        20480           32       0            0       0            0         0        1           32            1              0   32   5      1            1       0            0       0            1            0       0               8       0               0       0               0       0               4       0               0         0               0           0
                 768  18        12288           16       0            0       0            0         0        1           16            1              0   16   3      1            1       0            0       0            1            0       0               8       0               0       0               0       0               4       0               0         0               0           0
                 896  19        28672           32       0            0       0            0         0        1           32            1              0   32   7      1            1       0            0       0            1            0       0               8       0               0       0               0       0               4       0               0         0               0           0
                     ---
                1280  21        20480           16       0            0       0            0         0        1           16            1              0   16   5      1            1       0            0       0            1            0       0               8       0               0       0               0       0               4       0               0         0               0           0
                1536  22        15360           10       0            0       0            0         0        1           10            2              0    8   3  0.625            1       0            0       0            2            0       0               9       0               0       0               0       0               4       0               0         0               0           0
                     ---
large:          size ind    allocated      nmalloc (#/sec)      ndalloc (#/sec)    nrequests (#/sec)  curlextents
                     ---
extents:        size ind       ndirty        dirty       nmuzzy        muzzy    nretained     retained       ntotal        total
                     ---
             1835008  30            0            0            0            0            1      1810432            1      1810432
                     ---
Bytes in small extent cache: 0
HPA shard stats:
  Purge passes: 0 (0 / sec)
  Purges: 0 (0 / sec)
  Hugeifies: 0 (0 / sec)
  Dehugifies: 0 (0 / sec)

  In full slabs:
      npageslabs: 0 huge, 0 nonhuge
      nactive: 0 huge, 0 nonhuge 
      ndirty: 0 huge, 0 nonhuge 
      nretained: 0 huge, 0 nonhuge 
  In empty slabs:
      npageslabs: 0 huge, 0 nonhuge
      nactive: 0 huge, 0 nonhuge 
      ndirty: 0 huge, 0 nonhuge 
      nretained: 0 huge, 0 nonhuge 

                size ind npageslabs_huge    nactive_huge     ndirty_huge  npageslabs_nonhuge     nactive_nonhuge      ndirty_nonhuge   nretained_nonhuge
                     ---
--- End jemalloc statistics ---
[07:46:12] --- total progress: 104 statements
--- total: 104 tests, 1 failures
    logic.go:4393: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/cdcd0c3db9daf1c57aa54dab64af8178/logTestLogic_union3268361560
--- FAIL: TestLogic_union (11.10s)

Help

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

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-42797

[annrpom]

 [07:46:08] CREATE VIEW v127043 (k, v) AS
        SELECT
          k1 AS k, v1 AS v FROM t127043_1@t127043_1_k1_idx
        UNION SELECT
          k2 AS k, v2 AS v FROM t127043_2@t127043_2_k2_idx
        UNION SELECT
          k3 AS k, v3 AS v FROM t127043_3@t127043_3_k3_idx;;
      [07:46:09] SELECT k, v FROM v127043 WHERE k = 1 LIMIT 1;;
      [07:46:09]   -- FAIL
          logic.go:3034: 
               pq: txn already encountered an error; cannot be used anymore (previous err: aborted in DistSender: result is ambiguous: context canceled)

[rafiss]

Same as #127942

[DrewKimball]

Closing as dupe of #127942.