pkg/sql/logictest/tests/local-legacy-schema-changer/local-legacy-schema-changer_test: TestLogic_union failed

[cockroach-teamcity]

pkg/sql/logictest/tests/local-legacy-schema-changer/local-legacy-schema-changer_test.TestLogic_union failed with artifacts on master @ 9e48858c6c8b22af4ec1159bcff6e233e7bfddff:

[05:27:09] CREATE TABLE abcd (a INT, b INT, c INT, d INT, INDEX (a, b, c DESC) STORING (d));
INSERT INTO abcd VALUES (1, 1, 1, 1), (1, 2, 2, 2), (1, 2, 3, 3), (2, 2, 2, 2), (2, 2, 3, 3);
CREATE TABLE efgh (e INT PRIMARY KEY, f INT, g INT, h INT);
INSERT INTO efgh VALUES (1, 1, 1, 1), (2, 2, 2, 2), (3, 2, 3, 3), (4, 2, 2, 2), (5, 2, 3, 3);;
[05:27:09] rewrote:
CREATE TABLE abcd (a INT8, b INT8, c INT8, d INT8, INDEX (a, b, c DESC) STORING (d), FAMILY (d), FAMILY (a, c), FAMILY (b));
INSERT INTO abcd VALUES (1, 1, 1, 1), (1, 2, 2, 2), (1, 2, 3, 3), (2, 2, 2, 2), (2, 2, 3, 3);
CREATE TABLE efgh (e INT8 PRIMARY KEY, f INT8, g INT8, h INT8, FAMILY (e), FAMILY (h), FAMILY (g), FAMILY (f));
INSERT INTO efgh VALUES (1, 1, 1, 1), (2, 2, 2, 2), (3, 2, 3, 3), (4, 2, 2, 2), (5, 2, 3, 3);


[05:27:10] SELECT e, f, g, h FROM efgh EXCEPT SELECT a, b, c, d FROM abcd ORDER by e, f;
[05:27:10] 	-- OK;
[05:27:10] SELECT a, b AS b1, b AS b2 FROM abc EXCEPT SELECT a, b, c FROM abc ORDER by a, b1;
[05:27:10] 	-- OK;
[05:27:10] SELECT a, b AS b1, b AS b2 FROM abc INTERSECT SELECT a, c, b FROM abc ORDER by a, b2;
[05:27:10] 	-- OK;
[05:27:10] CREATE TABLE t127043_1 (k1 INT, v1 INT, INDEX (k1));
INSERT INTO t127043_1 VALUES (1, 1);
CREATE TABLE t127043_2 (k2 INT, v2 INT, INDEX (k2));
INSERT INTO t127043_2 VALUES (1, 1);
CREATE TABLE t127043_3 (k3 INT, v3 INT, INDEX (k3));
INSERT INTO t127043_3 VALUES (1, 1);
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;;
[05:27:10] rewrote:
CREATE TABLE t127043_1 (k1 INT8, v1 INT8, INDEX (k1), FAMILY (k1), FAMILY (v1));
INSERT INTO t127043_1 VALUES (1, 1);
CREATE TABLE t127043_2 (k2 INT8, v2 INT8, INDEX (k2), FAMILY (k2), FAMILY (v2));
INSERT INTO t127043_2 VALUES (1, 1);
CREATE TABLE t127043_3 (k3 INT8, v3 INT8, INDEX (k3), FAMILY (k3, v3));
INSERT INTO t127043_3 VALUES (1, 1);
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;


[05:27:10] SELECT k, v FROM v127043 WHERE k = 1 LIMIT 1;;
[05:27:10] 	-- FAIL
    logic.go:3018: 
         pq: txn already encountered an error; cannot be used anymore (previous err: aborted in DistSender: result is ambiguous: context canceled)
[05:27:10] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3189/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/local-legacy-schema-changer/local-legacy-schema-changer_test_/local-legacy-schema-changer_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/union with config local-legacy-schema-changer: 102 tests, 1 failures
[05:27:12] --- total progress: 102 statements
--- total: 102 tests, 1 failures
    logic.go:4364: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/1e6164bb91fde4e73ace9bf19eb94b85/logTestLogic_union2763967742
--- FAIL: TestLogic_union (9.21s)

Help

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

This test on roachdash | Improve this report!

Jira issue: CRDB-41614

[DrewKimball]

Dupe of #127942