cockroach-teamcity
commented
3 years ago compose.TestComposeCompare failed with artifacts on master @ f0e2aa6abbbbf3318ea20e7dbcbe40819a809b83:
test_1 | tab_198823.col1_1 AS col_350666,
test_1 | tab_198819.col1_14 AS col_350667
test_1 | FROM
test_1 | postgres.public.table1@[0] AS tab_198815,
test_1 | postgres.public.table1@[0] AS tab_198816
test_1 | JOIN postgres.public.table1@[0] AS tab_198817
test_1 | JOIN postgres.public.table1@[0] AS tab_198818
test_1 | JOIN postgres.public.table1@[0] AS tab_198819
test_1 | JOIN postgres.public.table1@[0] AS tab_198820
test_1 | JOIN postgres.public.table1@[0] AS tab_198821 ON
test_1 | (tab_198820.col1_11) = (tab_198821.col1_11) ON
test_1 | (tab_198819.col1_2) = (tab_198820.col1_2)
test_1 | JOIN postgres.public.table1@[0] AS tab_198822 ON (tab_198820.col1_0) = (tab_198822.col1_0) ON
test_1 | (tab_198818.col1_8) = (tab_198821.col1_8)
test_1 | AND (tab_198818.col1_6) = (tab_198822.col1_15)
test_1 | AND (tab_198818.col1_14) = (tab_198821.col1_15)
test_1 | AND (tab_198818.col1_6) = (tab_198820.col1_0)
test_1 | AND (tab_198818.col1_0) = (tab_198820.col1_0)
test_1 | AND (tab_198818.col1_5) = (tab_198822.col1_9) ON
test_1 | (tab_198817.col1_6) = (tab_198818.col1_6) ON
test_1 | (tab_198816.col1_6) = (tab_198820.col1_0) AND (tab_198816.col1_0) = (tab_198817.col1_14),
test_1 | postgres.public.table1@[0] AS tab_198823
test_1 | )
test_1 | AS tab_198824
test_1 | ORDER BY
test_1 | col_350664 NULLS FIRST, col_350665 NULLS FIRST, col_350666 NULLS FIRST, col_350667 NULLS FIRST
test_1 | compare_test.go:189: cockroach1: ping: context deadline exceeded
test_1 | --- FAIL: TestCompare/postgres (1.52s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:149: CREATE TABLE table1 (col1_0 REGCLASS NOT NULL, col1_1 INT4 NOT NULL, col1_2 DECIMAL NOT NULL, col1_3 VARCHAR, col1_4 REGPROCEDURE NOT NULL, col1_5 JSONB NOT NULL, col1_6 TIMESTAMP NOT NULL, col1_7 "char" NOT NULL, PRIMARY KEY (col1_2, col1_7, col1_0, col1_6, col1_1, col1_4), col1_8 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_6 IS NULL THEN e'\x1b\x03e\x10'::TEXT ELSE e'\x1c'::TEXT END) STORED, col1_9 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_6 IS NULL THEN NULL ELSE ''::TEXT END) STORED, col1_10 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_6 IS NULL THEN NULL ELSE e'\x00'::TEXT END) STORED, col1_11 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_0 IS NULL THEN e'R6Bvg\x19'::TEXT ELSE NULL END) STORED, col1_12 TEXT NOT NULL GENERATED ALWAYS AS (lower(col1_7)) STORED);
test_1 | CREATE UNIQUE INDEX ON table1 (col1_3, col1_8 DESC, col1_1, col1_10 DESC);
test_1 | CREATE UNIQUE INDEX ON table1 (col1_1 DESC, col1_9 DESC, col1_3, col1_10 DESC, col1_2 ASC, col1_11 ASC, col1_8 DESC);
test_1 | CREATE TYPE rand_typ_0 AS ENUM ('x', 'xcogl', 'gsrzhc', 'gmw', 'eaoem');
test_1 | CREATE TYPE rand_typ_1 AS ENUM ('eb', 'zjgs', 'ttab', 'el', 'nld', 'ishpey');
test_1 | CREATE TYPE rand_typ_2 AS ENUM ('i', 'tng', 'hcv', 'edxkp');
test_1 |
test_1 | compare_test.go:150: postgres: exec: ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach1_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach1_1 ... done
Stopping compare_cockroach2_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1Reproduce
To reproduce, try: ```bash make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1 ```
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
Internal log
``` mjibson marked as alumn{us/a}; resolving to rafiss instead ```
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on master @ 5fd1dda1cde0a91643d39209c6458dcefcbfc180:
Reproduce
To reproduce, try: ```bash make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1 ```
Internal log
``` mjibson marked as alumn{us/a}; resolving to rafiss instead ```
/cc @cockroachdb/sql-experience rafiss
This test on roachdash | Improve this report!
Jira issue: CRDB-8721