compose: TestComposeCompare failed

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.

https://www.cockroachlabs.com

Other

30.07k stars 3.8k forks source link

compose: TestComposeCompare failed #89361

Closed cockroach-teamcity closed 5 months ago

cockroach-teamcity commented 2 years ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 18da6141d87f76c04f74ad6f9685fa619b97738a:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #82867 compose: TestComposeCompare failed [C-test-failure O-robot T-sql-experience branch-master] - #78068 compose: TestComposeCompare failed [C-test-failure O-robot T-sql-experience branch-release-22.1 sync-me-8] - #73421 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.2 sync-me-8]

/cc @cockroachdb/sql-experience

This test on roachdash | Improve this report!

Jira issue: CRDB-20216

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ fd133ba3af3954c93584a501cf68dfa3131e586c:

        test_1        |             ORDER BY
        test_1        |                 col_76922 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_69096.col_76921 AS col_76922
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 ('2000-01-01 01:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ),
        test_1        |                                 ('2000-01-01 04:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ),
        test_1        |                                 ('2000-01-01 00:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ),
        test_1        |                                 ('2000-01-01 08:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ),
        test_1        |                                 ('2000-01-01 07:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ)
        test_1        |                         )
        test_1        |                             AS tab_69096 (col_76921)
        test_1        |                     WHERE
        test_1        |                         overlaps('00:09:00'::TIME::TIME::TIME, '00:05:00'::TIME::TIME::TIME, NULL::TIME::TIME, '00:06:00'::TIME::TIME::TIME)::BOOL
        test_1        |                     ORDER BY
        test_1        |                         tab_69096.col_76921 ASC
        test_1        |                 )
        test_1        |                     AS tab_69097
        test_1        |             ORDER BY
        test_1        |                 col_76922 NULLS FIRST;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.30s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: cockroach2
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 BOOL NOT NULL, col1_1 FLOAT8 NOT NULL, col1_2 BOX2D, col1_3 NAME NOT NULL, col1_4 INT8 NOT NULL, col1_5 STRING NOT NULL AS (lower(CAST(col1_0 AS STRING))) VIRTUAL, INVERTED INDEX (col1_5 gin_trgm_ops), INDEX (col1_5, col1_1 ASC, col1_3 DESC, col1_2, col1_0 ASC, col1_4 ASC), INDEX (col1_2 ASC, col1_3 DESC, col1_4 ASC) STORING (col1_0), FAMILY (col1_3, col1_0), FAMILY (col1_1), FAMILY (col1_2), FAMILY (col1_4));
        test_1        |             ALTER TABLE table1 INJECT STATISTICS e'[{"avg_size": 7, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 40, "histo_col_type": "BOX2D", "name": "__auto__", "null_count": 6, "row_count": 50}, {"avg_size": 5, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 19, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 50}, {"avg_size": 25, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 42, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 50}, {"avg_size": 20, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 17, "histo_buckets": [{"distinct_range": 0, "num_eq": 2266768241530634795, "num_range": 0, "upper_bound": "\\u0005"}, {"distinct_range": 4000000, "num_eq": 70000000000, "num_range": 4000000, "upper_bound": "uq\\u0010%"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 50}, {"avg_size": 31, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 21, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 50}, {"avg_size": 31, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 50}]':::JSONB;
        test_1        |             ALTER TABLE table1 INJECT STATISTICS e'[{"avg_size": 19, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6, "histo_col_type": "", "name": "__auto__", "null_count": 8, "row_count": 20}, {"avg_size": 30, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 13, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 20}, {"avg_size": 19, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 16, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 20}, {"avg_size": 9, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 9, "histo_buckets": [{"distinct_range": 0, "num_eq": 2373385359308452781, "num_range": 0, "upper_bound": "\\u0008Q\\rSY[t\\u000ez"}, {"distinct_range": 50, "num_eq": 10000000, "num_range": 50, "upper_bound": "7Yj_2"}, {"distinct_range": 514925766540107460, "num_eq": 20000, "num_range": 775508388043471849, "upper_bound": "9xdx"}, {"distinct_range": 40000000000, "num_eq": 8062705774276402507, "num_range": 40000000000, "upper_bound": "Ch]\\u000bh"}, {"distinct_range": 0, "num_eq": 7099801570147940773, "num_range": 600, "upper_bound": "``\\u0018v\\u0002Hp$%\\n"}, {"distinct_range": 114338878.41633743, "num_eq": 131273284130235269, "num_range": 400000000, "upper_bound": "kf"}, {"distinct_range": 2021502188037335600, "num_eq": 6760002591233840280, "num_range": 2245609333036233001, "upper_bound": "|"}, {"distinct_range": 5000000, "num_eq": 4000, "num_range": 5000000, "upper_bound": "\U00002603"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 20}, {"avg_size": 14, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 17, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 20}, {"avg_size": 13, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 20}]':::JSONB;
        test_1        |             
        test_1        |         compare_test.go:160: cockroach2: exec: ERROR: cannot inject statistics in an explicit transaction (SQLSTATE XXUUU)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (117.58s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ fd133ba3af3954c93584a501cf68dfa3131e586c:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ fd133ba3af3954c93584a501cf68dfa3131e586c:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 0ebce067f89a997f1daf04b4180d4dc5035c4fea:

        test_1        |         compare_test.go:137: initializing connection: postgres
        test_1        |         compare_test.go:188: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare4223199460/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:190: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   string("H2000-01-01 06:00:05+00:00"),
        test_1        |             +   string("H2000-01-01 06:00:05+00"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (CASE WHEN true::BOOL THEN 'H':::STRING::STRING ELSE 'J':::STRING::STRING END::STRING || ('2000-01-01 06:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ::TIMESTAMPTZ + '00:00:05':::INTERVAL::INTERVAL::INTERVAL)::TIMESTAMPTZ::TIMESTAMPTZ)::STRING
        test_1        |                             AS col_36021
        test_1        |                 )
        test_1        |                     AS tab_22076
        test_1        |             ORDER BY
        test_1        |                 col_36021 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (CASE WHEN true::BOOL THEN 'H'::TEXT::TEXT ELSE 'J'::TEXT::TEXT END::TEXT || ('2000-01-01 06:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ::TIMESTAMPTZ + '00:00:05'::INTERVAL::INTERVAL::INTERVAL)::TIMESTAMPTZ::TIMESTAMPTZ)::TEXT
        test_1        |                             AS col_36021
        test_1        |                 )
        test_1        |                     AS tab_22076
        test_1        |             ORDER BY
        test_1        |                 col_36021 NULLS FIRST;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.28s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 "char" NOT NULL, col1_1 TIMESTAMPTZ NOT NULL, col1_2 FLOAT8 NOT NULL, col1_3 FLOAT8 NOT NULL AS (col1_2 + 1.0743068028104399:::FLOAT8) STORED, PRIMARY KEY (col1_2 DESC, col1_1 ASC, col1_0), INDEX (col1_3, col1_1 ASC, (CASE WHEN col1_1 IS NULL THEN e'\x1cwE<':::STRING ELSE e'I\x1a\x1cRse':::STRING END) DESC) WHERE table1.col1_1 = '294276-12-31 23:59:59.999999+00:00':::TIMESTAMPTZ, INDEX (col1_3, col1_2 ASC, col1_0 DESC, col1_1 ASC) PARTITION BY LIST (col1_3) (PARTITION table1_part_0 VALUES IN ((0.21158079363952992:::FLOAT8,), ((-0.08495486951553777):::FLOAT8,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))) WHERE (table1.col1_1 > '0001-01-01 00:00:00+00:00':::TIMESTAMPTZ) OR (table1.col1_3 >= (-1.0):::FLOAT8), UNIQUE (col1_3, col1_2 ASC), UNIQUE (col1_2 ASC, col1_1 DESC, col1_0), UNIQUE (col1_3, col1_1 DESC, lower(col1_0), col1_0), UNIQUE (col1_1 DESC, col1_3 ASC) WHERE (((table1.col1_1 != '3000-01-01 00:00:00+00:00':::TIMESTAMPTZ) OR (table1.col1_3 <= 1.401298464324817e-45:::FLOAT8)) OR (table1.col1_2 > '+Inf':::FLOAT8)) OR (table1.col1_0 <= e'\U00002603':::STRING))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=f7f2c671-b7f2-4689-be6e-004ab0f546ea for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (58.39s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ d978988afcfc78c02c23a3836ba90e4a4faeeb25:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ ca673993473629a46370100108dd8c185a592e91:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ ca673993473629a46370100108dd8c185a592e91:

=== RUN   TestComposeCompare
    compose_test.go:65: -cockroach not set
--- FAIL: TestComposeCompare (0.00s)

Parameters: TAGS=bazel,gss,deadlock

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ ca673993473629a46370100108dd8c185a592e91:

=== RUN   TestComposeCompare
    compose_test.go:65: -cockroach not set
--- FAIL: TestComposeCompare (0.00s)

Parameters: TAGS=bazel,gss

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ ca673993473629a46370100108dd8c185a592e91:

=== RUN   TestComposeCompare
    compose_test.go:65: -cockroach not set
--- FAIL: TestComposeCompare (0.00s)

Parameters: TAGS=bazel,gss,race

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ b1378718eb74f0412035acee659ce3b7941ab3dd:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ ddca6ce770299653164c0c04fcf753af1c3069ca:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #92892 compose: TestComposeCompare failed [C-test-failure O-robot T-sql-experience branch-release-22.2.0] - #82867 compose: TestComposeCompare failed [C-test-failure O-robot T-sql-experience branch-master] - #78068 compose: TestComposeCompare failed [C-test-failure O-robot T-sql-experience branch-release-22.1 sync-me-8] - #73421 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.2 sync-me-8]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ b8353892e5198e402456d54d5c41297d3a9287aa:

        postgres_1    | 2022-12-04 06:18:48.065 UTC [52] LOG:  shutting down
        postgres_1    | 2022-12-04 06:18:48.164 UTC [50] LOG:  database system is shut down
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2022-12-04 06:18:48.281 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2022-12-04 06:18:48.281 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2022-12-04 06:18:48.281 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2022-12-04 06:18:48.284 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2022-12-04 06:18:48.289 UTC [69] LOG:  database system was shut down at 2022-12-04 06:18:48 UTC
        postgres_1    | 2022-12-04 06:18:48.294 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2022-12-04 06:18:49.466 UTC [79] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2022-12-04 06:18:49.466 UTC [79] STATEMENT:  CREATE TABLE table1 (col1_0 REGTYPE, col1_1 BOOL NOT NULL, col1_2 INT8 NULL, col1_3 REGNAMESPACE, col1_4 INTERVAL NOT NULL, col1_5 "char" NOT NULL, col1_6 REGNAMESPACE NULL, col1_7 FLOAT4 NOT NULL, col1_8 BIT NOT NULL, col1_9 GEOMETRY NOT NULL, col1_10 OID NULL, col1_11 REGPROC NULL, col1_12 TEXT GENERATED ALWAYS AS (CASE WHEN col1_0 IS NULL THEN NULL ELSE e'\x00'::TEXT END) STORED, col1_13 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col1_10 AS TEXT))) STORED, col1_14 TEXT NULL GENERATED ALWAYS AS (CASE WHEN col1_11 IS NULL THEN e',O\rLa|H'::TEXT ELSE 'X'::TEXT END) STORED, col1_15 INT8 NULL GENERATED ALWAYS AS (col1_2 + 2409279103745072156::INT8) STORED, col1_16 FLOAT8 NOT NULL GENERATED ALWAYS AS (col1_7 + 0.4800208806991577::FLOAT8) STORED);
        postgres_1    |     CREATE INDEX ON table1 (col1_6, col1_16, col1_13 ASC, col1_1 DESC, (CASE WHEN col1_4 IS NULL THEN '"'::TEXT ELSE e'R\x03'::TEXT END) ASC, col1_11 ASC) INCLUDE (col1_0, col1_4, col1_7, col1_8, col1_9, col1_12);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (4.79s)
        test_1        |     compare_test.go:119: Checking connection to: postgres
        test_1        |     compare_test.go:119: Checking connection to: cockroach1
        test_1        |     compare_test.go:119: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.94s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: postgres
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 REGTYPE, col1_1 BOOL NOT NULL, col1_2 INT8 NULL, col1_3 REGNAMESPACE, col1_4 INTERVAL NOT NULL, col1_5 "char" NOT NULL, col1_6 REGNAMESPACE NULL, col1_7 FLOAT4 NOT NULL, col1_8 BIT NOT NULL, col1_9 GEOMETRY NOT NULL, col1_10 OID NULL, col1_11 REGPROC NULL, col1_12 TEXT GENERATED ALWAYS AS (CASE WHEN col1_0 IS NULL THEN NULL ELSE e'\x00'::TEXT END) STORED, col1_13 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col1_10 AS TEXT))) STORED, col1_14 TEXT NULL GENERATED ALWAYS AS (CASE WHEN col1_11 IS NULL THEN e',O\rLa|H'::TEXT ELSE 'X'::TEXT END) STORED, col1_15 INT8 NULL GENERATED ALWAYS AS (col1_2 + 2409279103745072156::INT8) STORED, col1_16 FLOAT8 NOT NULL GENERATED ALWAYS AS (col1_7 + 0.4800208806991577::FLOAT8) STORED);
        test_1        |             CREATE INDEX ON table1 (col1_6, col1_16, col1_13 ASC, col1_1 DESC, (CASE WHEN col1_4 IS NULL THEN '"'::TEXT ELSE e'R\x03'::TEXT END) ASC, col1_11 ASC) INCLUDE (col1_0, col1_4, col1_7, col1_8, col1_9, col1_12);
        test_1        |             
        test_1        |         compare_test.go:160: postgres: exec: ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
        test_1        |     --- FAIL: TestCompare/mutators (0.72s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: cockroach2
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 REGPROCEDURE NULL, col1_1 TIMETZ NOT NULL, col1_2 TIMESTAMPTZ NOT NULL, col1_3 REGNAMESPACE NULL, col1_4 BYTES NOT NULL, col1_5 STRING NOT NULL AS (CASE WHEN col1_4 IS NULL THEN e'\x1c}>\r;':::STRING ELSE 'j>v^N':::STRING END) STORED, PRIMARY KEY (col1_2, col1_1 DESC), INDEX (col1_1 ASC, col1_3 ASC) WHERE ((table1.col1_5 != '':::STRING) OR (table1.col1_1 = '24:00:00-15:59:00':::TIMETZ)) AND (table1.col1_2 = '-4713-11-24 00:00:00+00:00':::TIMESTAMPTZ) NOT VISIBLE, FAMILY (col1_2), FAMILY (col1_3, col1_5, col1_0), FAMILY (col1_4, col1_1));
        test_1        |             ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 8, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1557238439, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 7000000000}, {"avg_size": 17, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 540186396, "histo_buckets": [{"distinct_range": 0, "num_eq": 485460432296520802, "num_range": 0, "upper_bound": "1976-06-04 13:59:01.000322+00:00"}, {"distinct_range": 6247183879.384644, "num_eq": 810647556829602207, "num_range": 9000000000, "upper_bound": "2019-03-02 08:54:16.000656+00:00"}], "histo_col_type": "TIMESTAMPTZ", "name": "__auto__", "null_count": 0, "row_count": 7000000000}, {"avg_size": 26, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 588336452, "histo_col_type": "", "name": "__auto__", "null_count": 5546261119, "row_count": 7000000000}, {"avg_size": 12, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4035237780, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 7000000000}, {"avg_size": 16, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5886597518, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 7000000000}, {"avg_size": 16, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3121196427, "histo_col_type": "", "name": "__auto__", "null_count": 2150960220, "row_count": 7000000000}]':::JSONB;
        test_1        |             ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 1, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 214548421867543165, "histo_col_type": "", "name": "__auto__", "null_count": 4803834172956322247, "row_count": 6579690218083174124}, {"avg_size": 26, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5221161690205422605, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6579690218083174124}, {"avg_size": 7, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 361808923597491244, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6579690218083174124}, {"avg_size": 3, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 133987171746682416, "histo_col_type": "", "name": "__auto__", "null_count": 4729870484559073868, "row_count": 6579690218083174124}, {"avg_size": 22, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4143333229681160221, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6579690218083174124}, {"avg_size": 13, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6176122170981166183, "histo_buckets": [{"distinct_range": 0, "num_eq": 4000, "num_range": 0, "upper_bound": "1988-05-13 01:09:38.000155+00:00"}, {"distinct_range": 525.8191522253466, "num_eq": 100000000, "num_range": 700, "upper_bound": "1994-03-25 03:35:29.000883+00:00"}, {"distinct_range": 12470.76374408487, "num_eq": 4192126274627362188, "num_range": 20000, "upper_bound": "1996-03-10 15:38:34.000682+00:00"}, {"distinct_range": 1832383137808827100, "num_eq": 700000, "num_range": 2907468959354452260, "upper_bound": "3000-01-01 00:00:00+00:00"}], "histo_col_type": "TIMESTAMPTZ", "name": "__auto__", "null_count": 0, "row_count": 6579690218083174124}]':::JSONB;
        test_1        |             
        test_1        |         compare_test.go:160: cockroach2: exec: ERROR: cannot inject statistics in an explicit transaction (SQLSTATE XXUUU)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (19.36s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ b8353892e5198e402456d54d5c41297d3a9287aa:

        postgres_1    | .2022-12-05 06:18:04.343 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2022-12-05 06:18:04.345 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2022-12-05 06:18:04.347 UTC [51] LOG:  shutting down
        postgres_1    | 2022-12-05 06:18:04.451 UTC [49] LOG:  database system is shut down
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2022-12-05 06:18:04.565 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2022-12-05 06:18:04.565 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2022-12-05 06:18:04.565 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2022-12-05 06:18:04.568 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2022-12-05 06:18:04.574 UTC [68] LOG:  database system was shut down at 2022-12-05 06:18:04 UTC
        postgres_1    | 2022-12-05 06:18:04.578 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2022-12-05 06:18:05.747 UTC [78] ERROR:  syntax error at or near "DESC" at character 458
        postgres_1    | 2022-12-05 06:18:05.747 UTC [78] STATEMENT:  CREATE TABLE table2 (col2_0 INT2 NOT NULL, col2_1 GEOGRAPHY NOT NULL, col2_2 JSONB NULL, col2_3 REGPROCEDURE, col2_4 INT8 NULL, col2_5 UUID NOT NULL, col2_6 INT8 NOT NULL, col2_7 "char" NOT NULL, col2_8 BIT(28) NULL, col2_9 TIMESTAMP NULL, col2_10 JSONB NULL, col2_11 FLOAT4[] NOT NULL, col2_12 BIT(11) NOT NULL, col2_13 TEXT GENERATED ALWAYS AS (CASE WHEN col2_3 IS NULL THEN 'K2g'::TEXT ELSE e'\\[K_\x14\x10_T\''::TEXT END) STORED, INVERTED INDEX (col2_9 DESC, col2_0 DESC, col2_3 DESC, col2_13 ASC, col2_5, col2_10) WHERE ((((table2.col2_7 <= ''::TEXT) OR (table2.col2_0 > 1::INT8)) AND (table2.col2_9 < '-2000-01-01 00:00:00'::TIMESTAMP)) AND (table2.col2_4 > 2147483647::INT8)) AND (table2.col2_6 > 1::INT8));
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (4.57s)
        test_1        |     compare_test.go:119: Checking connection to: postgres
        test_1        |     compare_test.go:119: Checking connection to: cockroach1
        test_1        |     compare_test.go:119: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.94s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: postgres
        test_1        |         compare_test.go:159: CREATE TABLE table2 (col2_0 INT2 NOT NULL, col2_1 GEOGRAPHY NOT NULL, col2_2 JSONB NULL, col2_3 REGPROCEDURE, col2_4 INT8 NULL, col2_5 UUID NOT NULL, col2_6 INT8 NOT NULL, col2_7 "char" NOT NULL, col2_8 BIT(28) NULL, col2_9 TIMESTAMP NULL, col2_10 JSONB NULL, col2_11 FLOAT4[] NOT NULL, col2_12 BIT(11) NOT NULL, col2_13 TEXT GENERATED ALWAYS AS (CASE WHEN col2_3 IS NULL THEN 'K2g'::TEXT ELSE e'\\[K_\x14\x10_T\''::TEXT END) STORED, INVERTED INDEX (col2_9 DESC, col2_0 DESC, col2_3 DESC, col2_13 ASC, col2_5, col2_10) WHERE ((((table2.col2_7 <= ''::TEXT) OR (table2.col2_0 > 1::INT8)) AND (table2.col2_9 < '-2000-01-01 00:00:00'::TIMESTAMP)) AND (table2.col2_4 > 2147483647::INT8)) AND (table2.col2_6 > 1::INT8));
        test_1        |             
        test_1        |         compare_test.go:160: postgres: exec: ERROR: syntax error at or near "DESC" (SQLSTATE 42601)
        test_1        |     --- FAIL: TestCompare/mutators (0.50s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: cockroach2
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 "char" NOT NULL, col1_1 BOOL NOT NULL, col1_2 FLOAT4 NOT NULL, col1_3 GEOMETRY NOT NULL, col1_4 INT4 NOT NULL, col1_5 CHAR NOT NULL, col1_6 JSONB, col1_7 STRING NOT NULL, col1_8 STRING NOT NULL AS (lower(col1_0)) VIRTUAL, col1_9 STRING NOT NULL AS (lower(col1_7)) VIRTUAL, col1_10 STRING NOT NULL AS (lower(col1_0)) STORED, col1_11 STRING NOT NULL AS (lower(CAST(col1_3 AS STRING))) VIRTUAL, PRIMARY KEY (col1_2, col1_1, col1_10 ASC, col1_4 DESC), INDEX (col1_10 DESC, col1_9 ASC, col1_4 DESC, col1_11 ASC, col1_0, col1_7 DESC, col1_8 ASC) STORING (col1_3, col1_5, col1_6) WHERE (((((((((table1.col1_2 <= 3.4028234663852886e+38:::FLOAT8) OR (table1.col1_10 <= e'\U00002603':::STRING)) OR (table1.col1_9 > e'\U00002603':::STRING)) AND (table1.col1_0 >= e'\'':::STRING)) OR (table1.col1_7 > 'X':::STRING)) OR (table1.col1_11 != e'\'':::STRING)) AND (table1.col1_5 > e'\'':::STRING)) AND (table1.col1_8 <= '':::STRING)) AND (NOT table1.col1_1)) OR (table1.col1_4 <= (-1):::INT8), INDEX (col1_2, col1_11 DESC) STORING (col1_3, col1_7) WHERE ((((table1.col1_5 < '':::STRING) AND table1.col1_1) AND (table1.col1_2 < 0.0:::FLOAT8)) AND (table1.col1_11 > 'X':::STRING)) OR (table1.col1_4 <= 127:::INT8), INVERTED INDEX (col1_9 ASC, col1_2, col1_8, col1_5 ASC, col1_0 ASC, col1_1, col1_7 ASC, lower(CAST(col1_6 AS STRING)) ASC, col1_4, col1_10 ASC, col1_3) WHERE (((((((table1.col1_10 <= 'X':::STRING) AND (table1.col1_4 > (-128):::INT8)) AND (table1.col1_8 < e'\x00':::STRING)) AND (NOT table1.col1_1)) OR (table1.col1_5 >= '"':::STRING)) OR (table1.col1_11 >= e'\U00002603':::STRING)) OR (table1.col1_7 != e'\x00':::STRING)) AND (table1.col1_9 < '':::STRING), INDEX (col1_0 DESC, col1_1) STORING (col1_3, col1_6, col1_7) WHERE ((((table1.col1_2 > 1.401298464324817e-45:::FLOAT8) AND (table1.col1_0 > e'\U00002603':::STRING)) OR (table1.col1_10 = e'\x00':::STRING)) AND (table1.col1_7 = '':::STRING)) OR (table1.col1_9 < e'\U00002603':::STRING), INDEX (col1_8 ASC, col1_5 ASC) STORING (col1_0, col1_3, col1_7) WHERE ((table1.col1_9 > '"':::STRING) AND (table1.col1_11 = 'X':::STRING)) OR (table1.col1_2 <= 0.0:::FLOAT8), INVERTED INDEX (col1_10 ASC, col1_2, col1_6) WHERE (((((((((NOT table1.col1_1) OR (table1.col1_2 < 1.401298464324817e-45:::FLOAT8)) OR (table1.col1_10 >= '':::STRING)) OR (table1.col1_0 != e'\'':::STRING)) OR (table1.col1_7 = 'X':::STRING)) OR (table1.col1_5 != '"':::STRING)) OR (table1.col1_11 != '"':::STRING)) AND (table1.col1_8 != e'\U00002603':::STRING)) OR (table1.col1_9 >= 'X':::STRING)) OR (table1.col1_4 > 127:::INT8) NOT VISIBLE, FAMILY (col1_3), FAMILY (col1_2, col1_5, col1_6, col1_4, col1_1), FAMILY (col1_0, col1_7, col1_10));
        test_1        |             ALTER TABLE table1 INJECT STATISTICS e'[{"avg_size": 26, "columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 91, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 200}, {"avg_size": 19, "columns": ["col1_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 142, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 200}, {"avg_size": 18, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 18, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 200}, {"avg_size": 6, "columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 112, "histo_col_type": "", "name": "__auto__", "null_count": 44, "row_count": 200}, {"avg_size": 7, "columns": ["col1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 12, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 200}, {"avg_size": 13, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 141, "histo_col_type": "\\"char\\"", "name": "__auto__", "null_count": 0, "row_count": 200}, {"avg_size": 5, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 23, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 200}, {"avg_size": 16, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 52, "histo_buckets": [{"distinct_range": 0, "num_eq": 2103889847572477783, "num_range": 0, "upper_bound": "-3.0062973499298096"}, {"distinct_range": 0, "num_eq": 3994638552897906862, "num_range": 0, "upper_bound": "-0.6276273727416992"}, {"distinct_range": 2292122470403393300, "num_eq": 600, "num_range": 4134609910023031033, "upper_bound": "-0.4189387857913971"}, {"distinct_range": 4000, "num_eq": 7408986142357048603, "num_range": 4000, "upper_bound": "0.33360010385513306"}, {"distinct_range": 0, "num_eq": 7978998900557491026, "num_range": 1323033848879162221, "upper_bound": "0.4518009126186371"}, {"distinct_range": 0, "num_eq": 10000000000, "num_range": 2547662407888733831, "upper_bound": "0.7209694981575012"}, {"distinct_range": 45623.73246100655, "num_eq": 2386639752119521668, "num_range": 50000, "upper_bound": "0.793285071849823"}, {"distinct_range": 800000, "num_eq": 2617317747752780213, "num_range": 800000, "upper_bound": "2.5894017219543457"}], "histo_col_type": "FLOAT4", "name": "__auto__", "null_count": 0, "row_count": 200}, {"avg_size": 0, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 77, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 200}, {"avg_size": 27, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 184, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 200}, {"avg_size": 23, "columns": ["col1_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 143, "histo_buckets": [{"distinct_range": 0, "num_eq": 0, "num_range": 0, "upper_bound": ""}, {"distinct_range": 0, "num_eq": 60, "num_range": 3847618745497076415, "upper_bound": "#\'\\n[5\\u001b"}, {"distinct_range": 0, "num_eq": 50000000000, "num_range": 4000, "upper_bound": "cU?c"}, {"distinct_range": 43.94474213512621, "num_eq": 60000, "num_range": 900, "upper_bound": "hB]5\\u001e*^"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 200}, {"avg_size": 28, "columns": ["col1_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 32, "histo_buckets": [{"distinct_range": 0, "num_eq": 40, "num_range": 0, "upper_bound": ""}, {"distinct_range": 0, "num_eq": 70, "num_range": 4051366126026729896, "upper_bound": "7x\\u0011x"}, {"distinct_range": 0, "num_eq": 4048581910885849729, "num_range": 0, "upper_bound": "j``\\nH1\\u001f\\u0006"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 200}]':::JSONB;
        test_1        |             ALTER TABLE table1 INJECT STATISTICS e'[{"avg_size": 7, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3290580171986063914, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6902485263434656014}, {"avg_size": 18, "columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6814745111171128998, "histo_col_type": "", "name": "__auto__", "null_count": 3005750906031854472, "row_count": 6902485263434656014}, {"avg_size": 25, "columns": ["col1_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4649939635915949539, "histo_buckets": [{"distinct_range": 0, "num_eq": 1000000, "num_range": 0, "upper_bound": ""}, {"distinct_range": 0, "num_eq": 1536878020510799133, "num_range": 900, "upper_bound": "ln\'d;\\u001d\\u001b_\\u0002"}, {"distinct_range": 30000000, "num_eq": 3682461125223998681, "num_range": 30000000, "upper_bound": "pd6aF\\u000b\\u000b5"}, {"distinct_range": 3308239292629950000, "num_eq": 1746549132796539656, "num_range": 7832941689421440315, "upper_bound": "sH"}, {"distinct_range": 4919784.824757114, "num_eq": 9000000000, "num_range": 90000000, "upper_bound": "z"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 6902485263434656014}, {"avg_size": 17, "columns": ["col1_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3643832555448878079, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6902485263434656014}, {"avg_size": 6, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3545250055424590042, "histo_buckets": [{"distinct_range": 0, "num_eq": 8378273360716174925, "num_range": 0, "upper_bound": ""}, {"distinct_range": 4153006890178538500, "num_eq": 4000, "num_range": 4153006890178538475, "upper_bound": "\\u000e"}, {"distinct_range": 2054973733358617300, "num_eq": 9000000, "num_range": 7196951617032344091, "upper_bound": "\\u001f"}, {"distinct_range": 900, "num_eq": 76155532806305947, "num_range": 900, "upper_bound": "6"}, {"distinct_range": 655744463288194600, "num_eq": 0, "num_range": 1704664442339489085, "upper_bound": "8"}, {"distinct_range": 1123430629769317500, "num_eq": 3000000, "num_range": 1832365344341115914, "upper_bound": "``"}], "histo_col_type": "\\"char\\"", "name": "__auto__", "null_count": 0, "row_count": 6902485263434656014}, {"avg_size": 17, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5423887822889920620, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6902485263434656014}, {"avg_size": 27, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3641597681341548307, "histo_buckets": [{"distinct_range": 0, "num_eq": 2014833150868289384, "num_range": 0, "upper_bound": "-1.232754111289978"}, {"distinct_range": 595595.1069228817, "num_eq": 1000, "num_range": 1000000, "upper_bound": "-0.7938448786735535"}, {"distinct_range": 181363168257001820, "num_eq": 90, "num_range": 181363168257001831, "upper_bound": "-0.4211828112602234"}, {"distinct_range": 500, "num_eq": 4283901446083944709, "num_range": 500, "upper_bound": "-0.3286915123462677"}, {"distinct_range": 0, "num_eq": 1231125374299124364, "num_range": 5334212290395101338, "upper_bound": "2.520400285720825"}], "histo_col_type": "FLOAT4", "name": "__auto__", "null_count": 0, "row_count": 6902485263434656014}, {"avg_size": 1, "columns": ["col1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1478775930466701553, "histo_buckets": [{"distinct_range": 0, "num_eq": 1557462369980989978, "num_range": 0, "upper_bound": ""}, {"distinct_range": 37113926670.72113, "num_eq": 40000, "num_range": 60000000000, "upper_bound": "\\u001a\\u0017j0S!v#2"}, {"distinct_range": 60111.89830078772, "num_eq": 2000000, "num_range": 90000, "upper_bound": "1a\\u0002"}, {"distinct_range": 4298143941080140000, "num_eq": 20000000000, "num_range": 5396909946415202483, "upper_bound": "^gbu7\\r\\u0010\\nW"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 6902485263434656014}, {"avg_size": 22, "columns": ["col1_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2942767513128273454, "histo_buckets": [{"distinct_range": 0, "num_eq": 8457292210184707453, "num_range": 0, "upper_bound": "\\u000ePi.+a"}, {"distinct_range": 59579.39656923323, "num_eq": 400000, "num_range": 80000, "upper_bound": "\'"}, {"distinct_range": 130964.76427580597, "num_eq": 0, "num_range": 5000000, "upper_bound": "*oo["}, {"distinct_range": 3562528598855007700, "num_eq": 200, "num_range": 6173925608520184623, "upper_bound": ";"}, {"distinct_range": 100, "num_eq": 4496635460202308769, "num_range": 100, "upper_bound": "=f"}, {"distinct_range": 0, "num_eq": 900000, "num_range": 3090498858194169048, "upper_bound": "X"}, {"distinct_range": 0, "num_eq": 0, "num_range": 3549333574069983331, "upper_bound": "ja9\\u0002\\u0018"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 6902485263434656014}, {"avg_size": 19, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6358116739542328317, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6902485263434656014}, {"avg_size": 24, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 419206327026766135, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6902485263434656014}, {"avg_size": 7, "columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3591260853201617880, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6902485263434656014}]':::JSONB;
        test_1        |             
        test_1        |         compare_test.go:160: cockroach2: exec: ERROR: cannot inject statistics in an explicit transaction (SQLSTATE XXUUU)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (19.31s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ adf24a585553397a7ad8e4bb6da0609bb5d2e930:

Slow failing tests:
TestComposeCompare - 295.09s

Slow passing tests:
<none>

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 208b1d3ad46811dcf527ff53636f47b040ff62a5:

        postgres_1    | .2022-12-07 06:19:47.654 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2022-12-07 06:19:47.656 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2022-12-07 06:19:47.658 UTC [51] LOG:  shutting down
        postgres_1    | 2022-12-07 06:19:47.759 UTC [49] LOG:  database system is shut down
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2022-12-07 06:19:47.874 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2022-12-07 06:19:47.874 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2022-12-07 06:19:47.874 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2022-12-07 06:19:47.879 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2022-12-07 06:19:47.883 UTC [68] LOG:  database system was shut down at 2022-12-07 06:19:47 UTC
        postgres_1    | 2022-12-07 06:19:47.889 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2022-12-07 06:19:49.089 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2022-12-07 06:19:49.089 UTC [78] STATEMENT:  CREATE TABLE table2 (col2_0 DECIMAL[] NOT NULL, col2_1 BIT(7) NOT NULL, col2_2 REGNAMESPACE, col2_3 DATE NOT NULL, col2_4 INET NOT NULL, col2_5 GEOGRAPHY NULL, col2_6 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col2_1 AS TEXT))) STORED, col2_7 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_3 IS NULL THEN 'X'::TEXT ELSE e'\x00'::TEXT END) STORED);
        postgres_1    |     CREATE UNIQUE INDEX ON table2 (col2_4 DESC) INCLUDE (col2_0, col2_1, col2_2, col2_3, col2_5, col2_7);
        postgres_1    |     CREATE UNIQUE INDEX ON table2 (lower(CAST(col2_5 AS TEXT)) ASC, col2_7, lower(CAST(col2_4 AS TEXT)) DESC, col2_1 DESC, col2_2);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (4.43s)
        test_1        |     compare_test.go:119: Checking connection to: postgres
        test_1        |     compare_test.go:119: Checking connection to: cockroach1
        test_1        |     compare_test.go:119: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.93s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: postgres
        test_1        |         compare_test.go:159: CREATE TABLE table2 (col2_0 DECIMAL[] NOT NULL, col2_1 BIT(7) NOT NULL, col2_2 REGNAMESPACE, col2_3 DATE NOT NULL, col2_4 INET NOT NULL, col2_5 GEOGRAPHY NULL, col2_6 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col2_1 AS TEXT))) STORED, col2_7 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_3 IS NULL THEN 'X'::TEXT ELSE e'\x00'::TEXT END) STORED);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_4 DESC) INCLUDE (col2_0, col2_1, col2_2, col2_3, col2_5, col2_7);
        test_1        |             CREATE UNIQUE INDEX ON table2 (lower(CAST(col2_5 AS TEXT)) ASC, col2_7, lower(CAST(col2_4 AS TEXT)) DESC, col2_1 DESC, col2_2);
        test_1        |             
        test_1        |         compare_test.go:160: postgres: exec: ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
        test_1        |     --- FAIL: TestCompare/mutators (0.37s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 REGNAMESPACE, col1_1 REGPROC NULL, col1_2 STRING NULL, col1_3 FLOAT8 NOT NULL, col1_4 BYTES NOT NULL, col1_5 TIMETZ NOT NULL, col1_6 BOX2D NOT NULL, col1_7 REGPROC NULL, col1_8 OID, col1_9 BYTES, col1_10 BOOL NOT NULL, col1_11 REGNAMESPACE NULL, col1_12 GEOGRAPHY NULL, col1_13 GEOMETRY NOT NULL, col1_14 CHAR, col1_15 GEOGRAPHY NOT NULL, col1_16 GEOGRAPHY NOT NULL, col1_17 STRING NULL AS (CASE WHEN col1_11 IS NULL THEN NULL ELSE ':"':::STRING END) STORED, col1_18 STRING AS (CASE WHEN col1_0 IS NULL THEN 'QU':::STRING ELSE e'\x1c(O':::STRING END) VIRTUAL, INDEX (col1_14 DESC) PARTITION BY LIST (col1_14) (PARTITION table1_part_0 VALUES IN (('J':::STRING,), ('K':::STRING,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))), INVERTED INDEX (col1_17 ASC, col1_14, col1_13), UNIQUE (lower(CAST(col1_8 AS STRING)) ASC, lower(CAST(col1_15 AS STRING))))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=5cbf44ff-791a-4a70-8199-e45bcf18908a for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (19.08s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 163fc1d72bb1e66344309c65dd497156694b72c4:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #92892 compose: TestComposeCompare failed [C-test-failure O-robot T-sql-experience deprecated-branch-release-22.2.0] - #82867 compose: TestComposeCompare failed [C-test-failure O-robot T-sql-experience branch-master] - #78068 compose: TestComposeCompare failed [C-test-failure O-robot T-sql-experience branch-release-22.1 sync-me-8] - #73421 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.2 sync-me-8]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 45cceae6a1277ab1970d24806cb57230814bf494:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 97d5489387634dfd25462c01cace49445d5698de:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ ff69f981a02ea6906d4be138189c4531a6a420d1:

        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | waiting for server to shut down...2022-12-11 06:17:54.300 UTC [49] LOG:  received fast shutdown request
        postgres_1    | .2022-12-11 06:17:54.302 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2022-12-11 06:17:54.304 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2022-12-11 06:17:54.306 UTC [51] LOG:  shutting down
        postgres_1    | 2022-12-11 06:17:54.413 UTC [49] LOG:  database system is shut down
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2022-12-11 06:17:54.524 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2022-12-11 06:17:54.524 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2022-12-11 06:17:54.524 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2022-12-11 06:17:54.529 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2022-12-11 06:17:54.534 UTC [68] LOG:  database system was shut down at 2022-12-11 06:17:54 UTC
        postgres_1    | 2022-12-11 06:17:54.540 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2022-12-11 06:17:55.883 UTC [78] ERROR:  syntax error at or near "ASC" at character 100
        postgres_1    | 2022-12-11 06:17:55.883 UTC [78] STATEMENT:  CREATE TABLE table5 (col5_0 INT8 NOT NULL, col5_1 BOX2D[] NOT NULL, INVERTED INDEX (col5_0, col5_1 ASC), INVERTED INDEX (col5_1), INVERTED INDEX (col5_1), INVERTED INDEX (col5_1 ASC) NOT VISIBLE, INVERTED INDEX (col5_0, col5_1 ASC));
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (4.66s)
        test_1        |     compare_test.go:119: Checking connection to: postgres
        test_1        |     compare_test.go:119: Checking connection to: cockroach1
        test_1        |     compare_test.go:119: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (1.12s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: postgres
        test_1        |         compare_test.go:159: CREATE TABLE table5 (col5_0 INT8 NOT NULL, col5_1 BOX2D[] NOT NULL, INVERTED INDEX (col5_0, col5_1 ASC), INVERTED INDEX (col5_1), INVERTED INDEX (col5_1), INVERTED INDEX (col5_1 ASC) NOT VISIBLE, INVERTED INDEX (col5_0, col5_1 ASC));
        test_1        |             
        test_1        |         compare_test.go:160: postgres: exec: ERROR: syntax error at or near "ASC" (SQLSTATE 42601)
        test_1        |     --- FAIL: TestCompare/mutators (0.42s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table3 (col3_0 BIT(32) NULL, col3_1 CHAR NOT NULL, col3_2 FLOAT8 NOT NULL, col3_3 REGPROC NOT NULL, col3_4 NAME NOT NULL, col3_5 STRING NULL AS (lower(CAST(col3_0 AS STRING))) VIRTUAL, col3_6 FLOAT8 AS (col3_2 + (-1.6780128493593214):::FLOAT8) VIRTUAL, col3_7 STRING NULL AS (lower(CAST(col3_0 AS STRING))) VIRTUAL, PRIMARY KEY (col3_2 ASC, col3_1, col3_3 ASC), UNIQUE (col3_1 ASC, col3_3 DESC) STORING (col3_0) WHERE (((table3.col3_2 != '+Inf':::FLOAT8) AND (table3.col3_6 >= 1.0:::FLOAT8)) OR (table3.col3_7 > 'X':::STRING)) AND (table3.col3_1 = e'\'':::STRING), INDEX (col3_4 DESC, col3_3, lower(CAST(col3_0 AS STRING)) DESC, col3_0) WHERE (((((table3.col3_2 = '+Inf':::FLOAT8) AND (table3.col3_1 != e'\x00':::STRING)) AND (table3.col3_5 != 'X':::STRING)) OR (table3.col3_6 > 5e-324:::FLOAT8)) AND (table3.col3_4 >= '"':::STRING:::NAME)) OR (table3.col3_7 != e'\U00002603':::STRING), UNIQUE (col3_0, col3_7 DESC, col3_5, col3_1 DESC, col3_4 ASC, (CASE WHEN col3_3 IS NULL THEN e'\x04d':::STRING ELSE e'\x05\x07A;^CQ@':::STRING END)) PARTITION BY LIST (col3_0, col3_7, col3_5, col3_1) (PARTITION table3_part_0 VALUES IN ((B'00000000000000000000000000000000', e'\x18x#\x04M':::STRING, e'\x0e\'=1LZDT2':::STRING, '7':::STRING), (B'11110110100100000010101101110111', e'\x03Dv$b':::STRING, '':::STRING, '7':::STRING)), PARTITION table3_part_1 VALUES IN ((B'10111101100011110001100001100000', e'qvs\x027"ZZ':::STRING, e'StA3\tBlwC':::STRING, 'A':::STRING), (B'00101000010010011111100110010101', 'WE*':::STRING, 'J~RdW>y':::STRING, '+':::STRING)), PARTITION table3_part_2 VALUES IN ((B'10110110110001110010100100001011', e'\x02}[5)':::STRING, e'\x01]c':::STRING, e'\x05':::STRING), (B'00101101011011111110100111011010', '':::STRING, e'hhMs\x04d\x14 \x1f':::STRING, e'\x05':::STRING)), PARTITION "DEFAULT" VALUES IN ((DEFAULT, DEFAULT, DEFAULT, DEFAULT))) WHERE ((table3.col3_5 <= '':::STRING) AND (table3.col3_1 >= e'\'':::STRING)) OR (table3.col3_6 > 'NaN':::FLOAT8), UNIQUE (col3_2 DESC, col3_5) WHERE (table3.col3_5 < '"':::STRING) AND (table3.col3_7 < e'\'':::STRING), INDEX (col3_0 DESC, col3_1, col3_7 ASC) STORING (col3_4) WHERE ((table3.col3_1 >= '"':::STRING) OR (table3.col3_5 <= e'\U00002603':::STRING)) OR (table3.col3_6 < 1.7976931348623157e+308:::FLOAT8), FAMILY (col3_2), FAMILY (col3_3, col3_1), FAMILY (col3_4), FAMILY (col3_0))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=f3a05ccd-bfb2-4bd0-8a7a-49de3a35b437 for details on how to enable enterprise features (SQLSTATE XXC02)
        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_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (20.75s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ ff69f981a02ea6906d4be138189c4531a6a420d1:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ c50f15fae7e62a9b5ad905e88314f69eb46c3e5c:

        test_1        |     compare_test.go:119: Checking connection to: postgres
        test_1        |     compare_test.go:119: Checking connection to: cockroach1
        test_1        |     compare_test.go:119: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.00s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        | panic: geos: no locations to init GEOS [recovered]
        test_1        |     panic: geos: no locations to init GEOS
        test_1        | 
        test_1        | goroutine 50 [running]:
        test_1        | testing.tRunner.func1.2({0x1d73c20, 0xc001c987c0})
        test_1        |     GOROOT/src/testing/testing.go:1396 +0x24e
        test_1        | testing.tRunner.func1()
        test_1        |     GOROOT/src/testing/testing.go:1399 +0x39f
        test_1        | panic({0x1d73c20, 0xc001c987c0})
        test_1        |     GOROOT/src/runtime/panic.go:884 +0x212
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x3625f00?, {0x25bb548?, 0xc001ca6750?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:371 +0x445
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x258ae60?, 0x3625f00)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:304 +0x13c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc001e9e1a0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:221 +0x92
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc001bbe9c0, {0xc001d4e050?, 0x5, 0xc000068d28?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:254 +0x71f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0xc001d69990?, 0x1f0b8d0?, {0xc001d4e050?, 0x1c00220?, 0xc001bbe901?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:98 +0x2e
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0x1c00220?, {0x1f0b8d0, 0x5}, 0x5, 0xbf?, {0xc001d07a58, 0x3, 0x2a6294e?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/schema.go:90 +0x16a
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTablesN(0x4a5f1b5bc9bfb53c?, 0x4a5f1b5bc9bfb53c?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:83 +0x186
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc000282000?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:72 +0x33
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.wrapCommonSetup.func1(0xc001c2f520?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:45 +0x22
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc001c2f520)
        test_1        |     github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:130 +0xe5
        test_1        | testing.tRunner(0xc001c2f520, 0xc001bbe930)
        test_1        |     GOROOT/src/testing/testing.go:1446 +0x10b
        test_1        | created by testing.(*T).Run
        test_1        |     GOROOT/src/testing/testing.go:1493 +0x35f
        compare_test_1 exited with code 2
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 2
--- FAIL: TestComposeCompare (18.07s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ bd54db769eed3e1f2a91cf63fcbb2d36182f0901:

        postgres_1    | waiting for server to shut down...2022-12-14 06:17:46.677 UTC [49] LOG:  received fast shutdown request
        postgres_1    | .2022-12-14 06:17:46.679 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2022-12-14 06:17:46.680 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2022-12-14 06:17:46.683 UTC [51] LOG:  shutting down
        postgres_1    | 2022-12-14 06:17:46.778 UTC [49] LOG:  database system is shut down
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2022-12-14 06:17:46.899 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2022-12-14 06:17:46.899 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2022-12-14 06:17:46.899 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2022-12-14 06:17:46.902 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2022-12-14 06:17:46.907 UTC [68] LOG:  database system was shut down at 2022-12-14 06:17:46 UTC
        postgres_1    | 2022-12-14 06:17:46.912 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2022-12-14 06:17:48.331 UTC [78] ERROR:  foreign key constraint "table1_col1_4_col1_7_fkey" cannot be implemented
        postgres_1    | 2022-12-14 06:17:48.331 UTC [78] DETAIL:  Key columns "col1_4" and "col3_1" are of incompatible types: name and "char".
        postgres_1    | 2022-12-14 06:17:48.331 UTC [78] STATEMENT:  ALTER TABLE table1 ADD FOREIGN KEY (col1_4, col1_7) REFERENCES table3 (col3_1, col3_5)
        test_1        | --- FAIL: TestCompare (4.79s)
        test_1        |     compare_test.go:119: Checking connection to: postgres
        test_1        |     compare_test.go:119: Checking connection to: cockroach1
        test_1        |     compare_test.go:119: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (1.13s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: postgres
        test_1        |         compare_test.go:159: ALTER TABLE table1 ADD FOREIGN KEY (col1_4, col1_7) REFERENCES table3 (col3_1, col3_5)
        test_1        |         compare_test.go:160: postgres: exec: ERROR: foreign key constraint "table1_col1_4_col1_7_fkey" cannot be implemented (SQLSTATE 42804)
        test_1        |     --- FAIL: TestCompare/mutators (0.52s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: cockroach2
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 DECIMAL NULL, col1_1 CHAR NOT NULL, col1_2 TIMETZ[] NOT NULL, col1_3 "char" NOT NULL, col1_4 INT2 NULL, col1_5 REGPROCEDURE, col1_6 STRING NOT NULL AS (lower(col1_3)) STORED, col1_7 INT8 NULL AS (col1_4 + (-24754):::INT8) VIRTUAL, col1_8 STRING NOT NULL AS (lower(col1_3)) STORED, col1_9 STRING NOT NULL AS (lower(col1_1)) STORED, INDEX (lower(col1_1) ASC, col1_9 ASC, col1_3 DESC, col1_8 ASC, col1_4, col1_0 DESC, col1_7 DESC) STORING (col1_1, col1_2, col1_6) WHERE (((table1.col1_8 = 'X':::STRING) AND (table1.col1_0 = (-1):::DECIMAL)) AND (table1.col1_7 != 1:::INT8)) AND (table1.col1_1 >= 'X':::STRING), INVERTED INDEX (col1_0 DESC, col1_2), INDEX (col1_6 DESC, col1_3 DESC, col1_5, col1_4 ASC, col1_8, col1_9) STORING (col1_0) WHERE (((((((table1.col1_4 <= 127:::INT8) AND (table1.col1_8 > e'\U00002603':::STRING)) AND (table1.col1_9 > e'\x00':::STRING)) OR (table1.col1_7 > 9223372036854775807:::INT8)) AND (table1.col1_6 < e'\'':::STRING)) AND (table1.col1_0 < 0:::DECIMAL)) AND (table1.col1_3 > 'X':::STRING)) OR (table1.col1_1 <= 'X':::STRING), FAMILY (col1_5), FAMILY (col1_9), FAMILY (col1_1), FAMILY (col1_2), FAMILY (col1_6, col1_8, col1_3), FAMILY (col1_4), FAMILY (col1_0));
        test_1        |             ALTER TABLE table1 INJECT STATISTICS e'[{"avg_size": 3, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 300537443, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1000000000}, {"avg_size": 8, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 903211654, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1000000000}, {"avg_size": 0, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 171987172, "histo_col_type": "", "name": "__auto__", "null_count": 604709073, "row_count": 1000000000}, {"avg_size": 23, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 536473310, "histo_col_type": "", "name": "__auto__", "null_count": 971044972, "row_count": 1000000000}, {"avg_size": 23, "columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 272990243, "histo_col_type": "", "name": "__auto__", "null_count": 166190047, "row_count": 1000000000}, {"avg_size": 27, "columns": ["col1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 648894697, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1000000000}, {"avg_size": 3, "columns": ["col1_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 354144494, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1000000000}, {"avg_size": 26, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 416390525, "histo_buckets": [{"distinct_range": 0, "num_eq": 600000000, "num_range": 0, "upper_bound": "-83.54766861152146841"}, {"distinct_range": 0, "num_eq": 284417638774702467, "num_range": 0, "upper_bound": "7.579177720906022243E+22"}], "histo_col_type": "DECIMAL", "name": "__auto__", "null_count": 983606583, "row_count": 1000000000}, {"avg_size": 15, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 861905303, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1000000000}, {"avg_size": 29, "columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 779529897, "histo_buckets": [{"distinct_range": 0, "num_eq": 40000000, "num_range": 0, "upper_bound": ""}, {"distinct_range": 0, "num_eq": 993746731894772072, "num_range": 2000, "upper_bound": "nj\\u0008"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 1000000000}]':::JSONB;
        test_1        |             ALTER TABLE table1 INJECT STATISTICS e'[{"avg_size": 0, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2033683493426346008, "histo_col_type": "", "name": "__auto__", "null_count": 1205971483648615580, "row_count": 6002107020519384686}, {"avg_size": 2, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 964582033085906074, "histo_col_type": "", "name": "__auto__", "null_count": 3506856488913992097, "row_count": 6002107020519384686}, {"avg_size": 23, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5525002516456325938, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6002107020519384686}, {"avg_size": 23, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3237966817997811094, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6002107020519384686}, {"avg_size": 27, "columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 61765811847606037, "histo_buckets": [{"distinct_range": 0, "num_eq": 1445312850233808243, "num_range": 0, "upper_bound": "\\u0013YHW,U"}, {"distinct_range": 90853540647041940, "num_eq": 0, "num_range": 743026661215889889, "upper_bound": "\\u0017\\u0002``^w_\\u001b"}, {"distinct_range": 284354552363176100, "num_eq": 2121133464661555362, "num_range": 3828489923760423327, "upper_bound": "1^Z\\u0008K"}, {"distinct_range": 1577751558.1833105, "num_eq": 1553364628321182711, "num_range": 3000000000, "upper_bound": "K\\tFd\\u0008*"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 6002107020519384686}, {"avg_size": 29, "columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5914745522311567074, "histo_col_type": "", "name": "__auto__", "null_count": 5250817660853322347, "row_count": 6002107020519384686}, {"avg_size": 12, "columns": ["col1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1782111774620457013, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6002107020519384686}, {"avg_size": 8, "columns": ["col1_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4257655420123481192, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6002107020519384686}, {"avg_size": 19, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 346005669951705926, "histo_buckets": [{"distinct_range": 0, "num_eq": 70000000000, "num_range": 0, "upper_bound": "NaN"}, {"distinct_range": 32821603.520574305, "num_eq": 30000000, "num_range": 100000000, "upper_bound": "-Infinity"}, {"distinct_range": 0, "num_eq": 2820900523119655338, "num_range": 3664850168017194963, "upper_bound": "-6.418785635897182786E+32"}, {"distinct_range": 0, "num_eq": 8579080413107742930, "num_range": 3902709903162057275, "upper_bound": "-2.194473564128463438E+23"}, {"distinct_range": 20000, "num_eq": 3251073335864994380, "num_range": 20000, "upper_bound": "7.478144116440098457E+21"}, {"distinct_range": 0, "num_eq": 700000, "num_range": 70000, "upper_bound": "6.015718066345170689E+26"}], "histo_col_type": "DECIMAL", "name": "__auto__", "null_count": 818653444050102133, "row_count": 6002107020519384686}, {"avg_size": 17, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 420363632718476917, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6002107020519384686}]':::JSONB;
        test_1        |             
        test_1        |         compare_test.go:160: cockroach2: exec: ERROR: cannot inject statistics in an explicit transaction (SQLSTATE XXUUU)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (19.31s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #92892 compose: TestComposeCompare failed [C-test-failure O-robot T-sql-sessions branch-release-22.2.0] - #82867 compose: TestComposeCompare failed [C-test-failure O-robot T-sql-sessions branch-master] - #78068 compose: TestComposeCompare failed [C-test-failure O-robot T-sql-sessions branch-release-22.1 sync-me-8] - #73421 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.2 sync-me-8]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ cab302aa7adeaf41f45b7b6532d9f72bb0d81b6e:

        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_1090.col_2131 AS col_2132
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (
        test_1        |                                     CASE
        test_1        |                                     WHEN ('::4/0'::INET::INET::INET >> '::9/0'::INET::INET::INET)::BOOL THEN 'C'::TEXT::"char"
        test_1        |                                     ELSE 'A'::TEXT::"char"
        test_1        |                                     END
        test_1        |                                 ),
        test_1        |                                 (NULL::"char"),
        test_1        |                                 ('I'::TEXT::"char")
        test_1        |                         )
        test_1        |                             AS tab_1090 (col_2131)
        test_1        |                     ORDER BY
        test_1        |                         tab_1090.col_2131,
        test_1        |                         tab_1090.col_2131 DESC,
        test_1        |                         tab_1090.col_2131 ASC,
        test_1        |                         tab_1090.col_2131 ASC,
        test_1        |                         tab_1090.col_2131 DESC
        test_1        |                 )
        test_1        |                     AS tab_1091
        test_1        |             ORDER BY
        test_1        |                 col_2132 ASC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.41s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: cockroach2
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 FLOAT4 NOT NULL, col1_1 REGPROCEDURE NOT NULL, col1_2 UUID NOT NULL, col1_3 DECIMAL NOT NULL, col1_4 TIMESTAMP NOT NULL, col1_5 UUID NOT NULL, col1_6 NAME NOT NULL, col1_7 STRING NOT NULL AS (lower(CAST(col1_5 AS STRING))) STORED, PRIMARY KEY (col1_5, col1_6 ASC, col1_1 DESC, col1_7 DESC, col1_4 ASC, col1_2 ASC, col1_3), FAMILY (col1_6, col1_3, col1_7, col1_5), FAMILY (col1_4, col1_1), FAMILY (col1_2), FAMILY (col1_0));
        test_1        |             ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 8, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 48062828, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100000000}, {"avg_size": 16, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 25422174, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100000000}, {"avg_size": 31, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 22051105, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100000000}, {"avg_size": 15, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 95265309, "histo_buckets": [{"distinct_range": 0, "num_eq": 4173267887116353074, "num_range": 0, "upper_bound": "44aa5bb3-dca0-456e-9d37-4c1add331f36"}, {"distinct_range": 20000, "num_eq": 5591758588432634708, "num_range": 20000, "upper_bound": "bc68a0b5-8dd2-4a03-b7fc-1d03bb268e4a"}], "histo_col_type": "UUID", "name": "__auto__", "null_count": 0, "row_count": 100000000}, {"avg_size": 0, "columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 42954561, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100000000}, {"avg_size": 6, "columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 99340490, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100000000}, {"avg_size": 7, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1716508, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100000000}, {"avg_size": 25, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 50512607, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100000000}]':::JSONB;
        test_1        |             ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 29, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 646443, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 700000}, {"avg_size": 21, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 231248, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 700000}, {"avg_size": 12, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 97847, "histo_buckets": [{"distinct_range": 0, "num_eq": 411872739237357976, "num_range": 0, "upper_bound": "04f48740-99b1-4355-941b-a286abf216bc"}, {"distinct_range": 0, "num_eq": 800000, "num_range": 4465828135742094620, "upper_bound": "141a595b-c415-49c4-8fbb-bddfd2e9bbfe"}, {"distinct_range": 3425040818537936000, "num_eq": 994367075339757610, "num_range": 6404705288923104562, "upper_bound": "49277d23-ef75-458f-8fa7-3b6f730f4a44"}, {"distinct_range": 4000, "num_eq": 902225402463930412, "num_range": 4000, "upper_bound": "6cbe1d9d-aa86-462a-959c-4848a893b025"}, {"distinct_range": 5129272722931614000, "num_eq": 2000000, "num_range": 5129272722931613394, "upper_bound": "95babd23-035f-429a-814b-22596806e00e"}, {"distinct_range": 2000000000, "num_eq": 4000, "num_range": 2000000000, "upper_bound": "b2c0aff6-de5b-4d57-8f3f-8c2cab9f86b8"}, {"distinct_range": 7217174.937436116, "num_eq": 90000000000, "num_range": 9000000, "upper_bound": "b749c0b8-fd43-4bdc-952c-01660f731ebe"}, {"distinct_range": 900000, "num_eq": 500000000, "num_range": 900000, "upper_bound": "f82e180a-a963-49c2-b751-8f735202cf1f"}], "histo_col_type": "UUID", "name": "__auto__", "null_count": 0, "row_count": 700000}, {"avg_size": 28, "columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 342657, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 700000}, {"avg_size": 8, "columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 366921, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 700000}, {"avg_size": 1, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 224316, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 700000}, {"avg_size": 31, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 699722, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 700000}, {"avg_size": 26, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 690381, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 700000}]':::JSONB;
        test_1        |             
        test_1        |         compare_test.go:160: cockroach2: exec: ERROR: cannot inject statistics in an explicit transaction (SQLSTATE XXUUU)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (25.09s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ d6abb72b4f5b5fca4deac73c3b0f80c6560e8c1b:

        postgres_1    | waiting for server to shut down....2022-12-16 06:14:45.758 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2022-12-16 06:14:45.759 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2022-12-16 06:14:45.761 UTC [51] LOG:  shutting down
        postgres_1    | 2022-12-16 06:14:45.844 UTC [49] LOG:  database system is shut down
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2022-12-16 06:14:45.872 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2022-12-16 06:14:45.872 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2022-12-16 06:14:45.872 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2022-12-16 06:14:45.875 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2022-12-16 06:14:45.878 UTC [68] LOG:  database system was shut down at 2022-12-16 06:14:45 UTC
        postgres_1    | 2022-12-16 06:14:45.881 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2022-12-16 06:14:47.953 UTC [78] ERROR:  syntax error at or near "ASC" at character 397
        postgres_1    | 2022-12-16 06:14:47.953 UTC [78] STATEMENT:  CREATE TABLE table2 (col2_0 TIME NULL, col2_1 UUID NOT NULL, col2_2 JSONB NOT NULL, col2_3 NAME NOT NULL, col2_4 GEOGRAPHY, col2_5 TIMESTAMPTZ NOT NULL, col2_6 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col2_0 AS TEXT))) STORED, col2_7 TEXT GENERATED ALWAYS AS (lower(CAST(col2_4 AS TEXT))) STORED, col2_8 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col2_0 AS TEXT))) STORED, INVERTED INDEX (col2_5 ASC, col2_1 DESC, col2_6 ASC, col2_4));
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (4.26s)
        test_1        |     compare_test.go:119: Checking connection to: postgres
        test_1        |     compare_test.go:119: Checking connection to: cockroach1
        test_1        |     compare_test.go:119: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/mutators (0.30s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: cockroach2
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 REGNAMESPACE NOT NULL, PRIMARY KEY (col1_0), INDEX (col1_0 ASC), UNIQUE (col1_0), UNIQUE (col1_0 DESC));
        test_1        |             ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 31, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 815, "histo_buckets": [{"distinct_range": 0, "num_eq": 100000, "num_range": 0, "upper_bound": "172091204"}, {"distinct_range": 0, "num_eq": 5499889729858475300, "num_range": 6921188403606992898, "upper_bound": "906424495"}, {"distinct_range": 800000000, "num_eq": 3627368196509749311, "num_range": 800000000, "upper_bound": "1190935628"}, {"distinct_range": 1991456977942660000, "num_eq": 8093557900959912726, "num_range": 8643725980485395989, "upper_bound": "1314723342"}, {"distinct_range": 7.577127435170789, "num_eq": 1859892101859277604, "num_range": 40, "upper_bound": "1321342277"}, {"distinct_range": 0, "num_eq": 30000, "num_range": 6000000, "upper_bound": "2594500056"}, {"distinct_range": 6612.036705642331, "num_eq": 300000000, "num_range": 100000, "upper_bound": "2690125901"}, {"distinct_range": 5000000, "num_eq": 3324070072031393314, "num_range": 5000000, "upper_bound": "3721011667"}, {"distinct_range": 0, "num_eq": 700000, "num_range": 7501573772749110298, "upper_bound": "4106383846"}], "histo_col_type": "REGNAMESPACE", "name": "__auto__", "null_count": 0, "row_count": 7000}]':::JSONB;
        test_1        |             ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 0, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 560534013787771517, "histo_buckets": [{"distinct_range": 0, "num_eq": 600000000, "num_range": 0, "upper_bound": "1944909698"}, {"distinct_range": 0, "num_eq": 2828178818580884813, "num_range": 0, "upper_bound": "2013453557"}, {"distinct_range": 892007913715663500, "num_eq": 3636412861009097750, "num_range": 1566851964568413691, "upper_bound": "2247264546"}, {"distinct_range": 0, "num_eq": 4585560639621444201, "num_range": 5542463623080250133, "upper_bound": "2581567950"}, {"distinct_range": 2402498070230748700, "num_eq": 30000000000, "num_range": 8427033967308189731, "upper_bound": "3465983089"}, {"distinct_range": 695009433704186400, "num_eq": 8989469544848101923, "num_range": 5841209681178022649, "upper_bound": "3619101848"}, {"distinct_range": 400000, "num_eq": 20000000000, "num_range": 400000, "upper_bound": "3968727741"}, {"distinct_range": 0, "num_eq": 6000000, "num_range": 800, "upper_bound": "4108716801"}], "histo_col_type": "REGNAMESPACE", "name": "__auto__", "null_count": 0, "row_count": 646694037181471629}]':::JSONB;
        test_1        |             
        test_1        |         compare_test.go:160: cockroach2: exec: ERROR: cannot inject statistics in an explicit transaction (SQLSTATE XXUUU)
        test_1        |     --- FAIL: TestCompare/postgres (0.84s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: postgres
        test_1        |         compare_test.go:159: CREATE TABLE table2 (col2_0 TIME NULL, col2_1 UUID NOT NULL, col2_2 JSONB NOT NULL, col2_3 NAME NOT NULL, col2_4 GEOGRAPHY, col2_5 TIMESTAMPTZ NOT NULL, col2_6 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col2_0 AS TEXT))) STORED, col2_7 TEXT GENERATED ALWAYS AS (lower(CAST(col2_4 AS TEXT))) STORED, col2_8 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col2_0 AS TEXT))) STORED, INVERTED INDEX (col2_5 ASC, col2_1 DESC, col2_6 ASC, col2_4));
        test_1        |             
        test_1        |         compare_test.go:160: postgres: exec: ERROR: syntax error at or near "ASC" (SQLSTATE 42601)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (17.07s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ a9e82c38ce99ee86eb160df5fa52e1e5e818924c:

        test_1        |                             AS tab_62295 (col_114223)
        test_1        |                 )
        test_1        |                     AS tab_62296
        test_1        |             ORDER BY
        test_1        |                 col_114224 DESC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_62295.col_114223 AS col_114224
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 ('\x42'::BYTEA::BYTEA),
        test_1        |                                 (NULL::BYTEA),
        test_1        |                                 (NULL::BYTEA),
        test_1        |                                 (
        test_1        |                                     (('\x4a'::BYTEA::BYTEA::BYTEA || '\x41'::BYTEA::BYTEA::BYTEA)::BYTEA::BYTEA || '\x47'::BYTEA::BYTEA::BYTEA)::BYTEA
        test_1        |                                 )
        test_1        |                         )
        test_1        |                             AS tab_62295 (col_114223)
        test_1        |                 )
        test_1        |                     AS tab_62296
        test_1        |             ORDER BY
        test_1        |                 col_114224 DESC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.60s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: cockroach2
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 INT4 NOT NULL, col1_1 NAME, col1_2 GEOMETRY[] NOT NULL, col1_3 INTERVAL, INDEX (col1_1 ASC, col1_3 DESC, col1_0 DESC) WHERE table1.col1_1 > 'X':::STRING:::NAME, FAMILY (col1_0), FAMILY (col1_1), FAMILY (col1_3), FAMILY (col1_2));
        test_1        |             ALTER TABLE table1 INJECT STATISTICS e'[{"avg_size": 29, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 507895, "histo_col_type": "", "name": "__auto__", "null_count": 627574, "row_count": 800000}, {"avg_size": 6, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 404129, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000}, {"avg_size": 23, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 443486, "histo_buckets": [{"distinct_range": 0, "num_eq": 0, "num_range": 0, "upper_bound": "0F"}, {"distinct_range": 0, "num_eq": 100000, "num_range": 50000000000, "upper_bound": "E\\u001fG\\u0005|Q%t/"}], "histo_col_type": "NAME", "name": "__auto__", "null_count": 798559, "row_count": 800000}, {"avg_size": 31, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 453350, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000}]':::JSONB;
        test_1        |             ALTER TABLE table1 INJECT STATISTICS e'[{"avg_size": 1, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2740907362384498836, "histo_buckets": [{"distinct_range": 0, "num_eq": 900000, "num_range": 0, "upper_bound": "\\u0007OVv\\rG"}, {"distinct_range": 0, "num_eq": 2735972511155323446, "num_range": 7000000000, "upper_bound": "\\u001f\\u0010\\"b\\u0001\\u0004UaY"}, {"distinct_range": 900000000, "num_eq": 60000, "num_range": 900000000, "upper_bound": "@\\u0008["}, {"distinct_range": 70, "num_eq": 2387690201735409369, "num_range": 70, "upper_bound": "T6zQL&"}, {"distinct_range": 6841054613798350000, "num_eq": 5000000, "num_range": 6921641854368177112, "upper_bound": "[-{(~,fyu"}, {"distinct_range": 6012456696103670000, "num_eq": 100000, "num_range": 6012456696103669639, "upper_bound": "t"}], "histo_col_type": "NAME", "name": "__auto__", "null_count": 5463432355161462615, "row_count": 6745243389602673770}, {"avg_size": 7, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3924938452604814791, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6745243389602673770}, {"avg_size": 13, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3027779085190231419, "histo_col_type": "", "name": "__auto__", "null_count": 785811708392183826, "row_count": 6745243389602673770}, {"avg_size": 27, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2127919015208111731, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6745243389602673770}]':::JSONB;
        test_1        |             
        test_1        |         compare_test.go:160: cockroach2: exec: ERROR: cannot inject statistics in an explicit transaction (SQLSTATE XXUUU)
        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_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (126.12s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ e7221ee3f22db90628f23e0c6d8754780b2b6188:

        test_1        |                                 (B'0000'::BIT(4), 2:::OID::OID)
        test_1        |                         )
        test_1        |                             AS tab_3957 (col_7333, col_7334)
        test_1        |                     ORDER BY
        test_1        |                         tab_3957.col_7334 ASC NULLS LAST, tab_3957.col_7333 ASC NULLS LAST, tab_3957.col_7333, tab_3957.col_7333
        test_1        |                 )
        test_1        |                     AS tab_3958
        test_1        |             ORDER BY
        test_1        |                 col_7335 DESC NULLS LAST, col_7336 DESC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_3957.col_7334 AS col_7335, tab_3957.col_7333 AS col_7336
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (B'0110'::BIT(4), 1::OID::OID),
        test_1        |                                 (B'0110'::BIT(4), NULL::OID),
        test_1        |                                 (NULL::BIT(4), 1::OID::OID),
        test_1        |                                 (B'0000'::BIT(4), 2::OID::OID)
        test_1        |                         )
        test_1        |                             AS tab_3957 (col_7333, col_7334)
        test_1        |                     ORDER BY
        test_1        |                         tab_3957.col_7334 ASC NULLS LAST, tab_3957.col_7333 ASC NULLS LAST, tab_3957.col_7333, tab_3957.col_7333
        test_1        |                 )
        test_1        |                     AS tab_3958
        test_1        |             ORDER BY
        test_1        |                 col_7335 DESC NULLS LAST, col_7336 DESC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.27s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 DATE NOT NULL, col1_1 BIT(41) NOT NULL, col1_2 REGCLASS NULL, col1_3 REGNAMESPACE NULL, col1_4 NAME NOT NULL, col1_5 BOX2D NOT NULL, col1_6 REGNAMESPACE NULL, col1_7 TIME NOT NULL, col1_8 STRING NULL AS (CASE WHEN col1_6 IS NULL THEN 'c':::STRING ELSE e'\rqVYU)':::STRING END) VIRTUAL, col1_9 STRING NOT NULL AS (lower(col1_4)) STORED, col1_10 STRING NOT NULL AS (CASE WHEN col1_0 IS NULL THEN '':::STRING ELSE e'G>l\x18e':::STRING END) VIRTUAL, col1_11 STRING NULL AS (CASE WHEN col1_2 IS NULL THEN e'2gHAH\t':::STRING ELSE '':::STRING END) VIRTUAL, col1_12 STRING NULL AS (CASE WHEN col1_2 IS NULL THEN 'b':::STRING ELSE e'\x1df[2K\x19':::STRING END) VIRTUAL, INDEX (col1_12, col1_11 ASC, col1_5, col1_3, col1_0 DESC, col1_6 ASC, col1_9 DESC, col1_1 DESC, col1_7, (CASE WHEN col1_6 IS NULL THEN e'\x00':::STRING ELSE e'\'':::STRING END) DESC, (CASE WHEN col1_0 IS NULL THEN e'M\x16\x10C_&':::STRING ELSE '':::STRING END) ASC) WHERE ((((((table1.col1_10 = e'\U00002603':::STRING) AND (table1.col1_0 < '5874897-12-31':::DATE)) AND (table1.col1_4 = e'\U00002603':::STRING:::NAME)) OR (table1.col1_9 <= e'\U00002603':::STRING)) OR (table1.col1_7 > '00:00:00':::TIME)) OR (table1.col1_12 = '':::STRING)) OR (table1.col1_8 < e'\U00002603':::STRING), INDEX ((CASE WHEN col1_2 IS NULL THEN e'&T>nM+\x19%E':::STRING ELSE e'<\x0f\x07jV':::STRING END) ASC, col1_10 DESC) WHERE (((((((table1.col1_0 = '5874897-12-31':::DATE) AND (table1.col1_4 < e'\'':::STRING:::NAME)) AND (table1.col1_9 = e'\U00002603':::STRING)) AND (table1.col1_12 >= 'X':::STRING)) AND (table1.col1_8 >= '"':::STRING)) AND (table1.col1_7 < '24:00:00':::TIME)) OR (table1.col1_10 != '"':::STRING)) OR (table1.col1_11 >= e'\'':::STRING), INDEX (col1_5 ASC, col1_12, col1_7 DESC, col1_4, col1_0 ASC, col1_1, lower(CAST(col1_5 AS STRING)) ASC, col1_8 DESC) PARTITION BY LIST (col1_5, col1_12, col1_7, col1_4, col1_0) (PARTITION table1_part_0 VALUES IN (('BOX(-1.7847274106610063 -0.03390357289015278,-1.7287176760364957 0.8275611846129589)':::BOX2D, '2m^':::STRING, '13:25:39.323257':::TIME, e'H\x12?+\x18[\x7fc!':::STRING:::NAME, '1986-04-08':::DATE), ('BOX(-0.7269557028095974 -0.2632339920513243,0.13960390319935428 2.0058439554589254)':::BOX2D, e'\x17\x15:(>b\x17A':::STRING, '09:24:09.608898':::TIME, e'\x1e6rKMQ|\b\x0e':::STRING:::NAME, '1974-02-13':::DATE), ('BOX(-0.018285613892529695 -0.7128542926047101,0.07111617905903367 0.47681509040663883)':::BOX2D, '0o+FZ+x':::STRING, '22:44:00.707457':::TIME, e')uE\r2}W;\x06':::STRING:::NAME, '1981-11-20':::DATE), ('BOX(0.6346936811422483 -2.1996217831042917,0.9655858670929975 -0.7452454644919675)':::BOX2D, 'X':::STRING, '20:57:27.906692':::TIME, e'F\x194&Ror':::STRING:::NAME, '1971-11-06':::DATE), ('BOX(0.26327180298403974 -1.0539140117377361,0.4761317372213961 -0.14852926330740016)':::BOX2D, e'Prk8{ \x02':::STRING, '11:55:43.988358':::TIME, '(+lEQe':::STRING:::NAME, '1994-05-30':::DATE), ('BOX(-0.7902129838794507 0.20343503963771326,0.08094153201746276 1.1646148969067456)':::BOX2D, e'\\':::STRING, '14:52:23.492317':::TIME, 'rI':::STRING:::NAME, '1976-05-09':::DATE), ('BOX(0.438364011576194 -0.14428462690209076,2.02437155453219 0.11538257837844257)':::BOX2D, e'+F?%4wV\x1a':::STRING, '19:01:57.285858':::TIME, '1L':::STRING:::NAME, '1976-01-05':::DATE), ('BOX(-0.417933633258845 -0.21526330810770178,1.3413146475621172 0.7230921180218421)':::BOX2D, ',@vx':::STRING, '12:09:00.198731':::TIME, '~^/;nmc%O':::STRING:::NAME, '1990-03-21':::DATE)), PARTITION table1_part_1 VALUES IN (('BOX(-1.6623006129755322 -1.2115886091593457,-1.1689202506078613 2.6373092934212576)':::BOX2D, e'b\x03\x06':::STRING, '16:18:23.359104':::TIME, e'\b.T1x\\!2':::STRING:::NAME, '1990-09-15':::DATE), ('BOX(-0.3652354633565663 0.8262656780327707,0.1566249258830723 0.9783692684427463)':::BOX2D, e'\U00002603':::STRING, '07:31:05.178446':::TIME, 'twOt':::STRING:::NAME, '1984-01-01':::DATE), ('BOX(-1.273453510044975 -0.32197309809512326,1.7316728853426722 0.6569614610778869)':::BOX2D, e'=}mY$\x13!c':::STRING, '09:54:02.618958':::TIME, e'\x00':::STRING:::NAME, '1981-02-22':::DATE), ('BOX(0.597461553918198 -0.3640858792437669,1.8214605069360994 -0.26545058183158865)':::BOX2D, e'\nd\\Nr\f"J}':::STRING, '03:50:14.144761':::TIME, e'``v.e\x15\x10~t':::STRING:::NAME, '1975-01-24':::DATE), ('BOX(0.41880908746070067 -0.4839074400037766,0.6019865885043113 1.011661519576705)':::BOX2D, e'LRx*\x02':::STRING, '12:05:18.980364':::TIME, e'S\x19\x1c}':::STRING:::NAME, '1984-11-06':::DATE), ('BOX(-0.9126279403839954 -0.5491356396061482,-0.2787646119307776 0.03441125995295252)':::BOX2D, e'\x1ae;\r':::STRING, '03:27:48.287886':::TIME, 'TFz':::STRING:::NAME, '1977-08-29':::DATE), ('BOX(0.05967392949521294 -0.35618437650805734,1.0586537316222902 0.24175846812077903)':::BOX2D, e'\'':::STRING, '06:26:28.368083':::TIME, e'=\tQ':::STRING:::NAME, '1994-09-17':::DATE), ('BOX(-0.7173746906725772 -0.6620976608803422,0.7054335579979594 -0.5429674997407536)':::BOX2D, e'\x03\x05':::STRING, '17:12:13.586278':::TIME, 'O+':::STRING:::NAME, '1975-10-12':::DATE)), PARTITION table1_part_2 VALUES IN (('BOX(-1.2422841556210429 -0.428295584991939,-0.5899797082163251 -0.21406505217093785)':::BOX2D, e'\x0e':::STRING, '03:55:57.675802':::TIME, e'F.\x16':::STRING:::NAME, '1973-02-13':::DATE), ('BOX(0.2255511571253258 -0.30315160425062326,2.431559842275651 1.5113162069386608)':::BOX2D, e'\x00':::STRING, '07:11:34.828242':::TIME, e'\x1djOw0a\nv':::STRING:::NAME, '1976-03-09':::DATE), ('BOX(0.8131304602143965 -0.6779358475410221,0.9577664268383707 0.7983679447724157)':::BOX2D, '':::STRING, '17:31:21.527191':::TIME, e'\x0f':::STRING:::NAME, '1990-08-22':::DATE), ('BOX(-1.6632693740980038 -0.31543103944356415,0.28878327079862487 -0.14402847092644622)':::BOX2D, '*7lk~~.':::STRING, '21:30:48.948473':::TIME, e'eCq\x7fN\x04\x0b':::STRING:::NAME, '1975-09-21':::DATE), ('BOX(-10 -10,10 10)':::BOX2D, e'BqV\x04\b\r':::STRING, '16:38:01.284213':::TIME, '"':::STRING:::NAME, '1983-12-06':::DATE), ('BOX(0.36618967347763626 -0.715206346169738,0.9899330325468911 0.24144750646231852)':::BOX2D, e'\x0f8K\x1ac~)!':::STRING, '06:09:35.326147':::TIME, e'\x18\x7f%lp':::STRING:::NAME, '1994-04-29':::DATE), ('BOX(0.03384763929415713 -0.7532360698797523,0.25212491461290565 0.7835048455444619)':::BOX2D, e'.\x1f=':::STRING, '12:23:11.431272':::TIME, 'b&':::STRING:::NAME, '1985-12-15':::DATE), ('BOX(-0.1560847562059865 -0.9894204953502979,0.9654935406083496 0.23070863534759034)':::BOX2D, e'x\x11':::STRING, '02:39:26.512089':::TIME, e'|#\r59|$':::STRING:::NAME, '1982-02-12':::DATE)), PARTITION table1_part_3 VALUES IN (('BOX(-0.6644267760961984 0.43872616238667417,1.0893561294134695 0.6269805731619387)':::BOX2D, '':::STRING, '08:36:30.032154':::TIME, e'\x18v^Z\x02':::STRING:::NAME, '1982-06-02':::DATE), ('BOX(-0.9486922741246532 -0.7483904504984781,0.14889146975774492 2.603114987292394)':::BOX2D, e'3\x1fV':::STRING, '23:57:25.680917':::TIME, 'O*PPwR':::STRING:::NAME, '1975-01-25':::DATE), ('BOX(-0.17519349075809987 0.011576594457446965,1.2039499049292495 0.42798221807233716)':::BOX2D, '8':::STRING, '24:00:00':::TIME, '':::STRING:::NAME, '1988-01-26':::DATE), ('BOX(0.4955929634566546 0.41072998671649497,1.024222782125704 0.6878023864791714)':::BOX2D, e'@\x13,\'Cv``TL':::STRING, '24:00:00':::TIME, 'Z>qt8':::STRING:::NAME, '1997-04-20':::DATE), ('BOX(-1.3414703278751152 -0.7974689310729488,-1.2083998974138046 1.0976223469251591)':::BOX2D, e'\f}S\x1b0\x0f``f~':::STRING, '05:26:47.085609':::TIME, e'\x7fNb%':::STRING:::NAME, '1979-06-26':::DATE), ('BOX(-10 -10,10 10)':::BOX2D, e'\rD0':::STRING, '22:47:36.580514':::TIME, e'Z4\x0b\x01+>':::STRING:::NAME, '1980-08-06':::DATE), ('BOX(-0.2699896323060949 -0.02656064065578323,-0.029394441554379647 0.16163747921455085)':::BOX2D, e'\'':::STRING, '17:59:05.63431':::TIME, e'2\\\f``P5=E':::STRING:::NAME, '1985-01-25':::DATE), ('BOX(-10 -10,10 10)':::BOX2D, e'\x0e>1\x02``l]':::STRING, '04:23:11.196008':::TIME, e'\U00002603':::STRING:::NAME, '1983-09-03':::DATE)), PARTITION table1_part_4 VALUES IN (('BOX(-0.5996053387478304 -0.6629524493154354,0.8358939883650756 1.1652999990630297)':::BOX2D, e'\x1exkYN':::STRING, '20:25:35.290689':::TIME, e'\x0f':::STRING:::NAME, '1977-02-05':::DATE), ('BOX(-2.15551660068464 -1.1151016165480434,0.3304193099961943 0.22849068416175805)':::BOX2D, e'7."Q#\t6':::STRING, '16:39:49.737498':::TIME, '':::STRING:::NAME, '1983-12-07':::DATE), ('BOX(-10 -10,10 10)':::BOX2D, 'a#':::STRING, '03:47:33.324785':::TIME, '_':::STRING:::NAME, '1989-02-10':::DATE), ('BOX(-0.7136526449302089 -0.47766715279422867,0.12986622925312274 0.7217824492041468)':::BOX2D, '':::STRING, '11:18:28.9341':::TIME, ':':::STRING:::NAME, '1976-08-01':::DATE), ('BOX(0.8443988247748666 -0.4768843267210221,1.1139190545504878 0.03277767488773037)':::BOX2D, e'XH\x1co':::STRING, '10:25:06.245781':::TIME, 'J':::STRING:::NAME, '1981-07-04':::DATE), ('BOX(0.07486211621475447 -1.1258478946726536,1.6565369590046035 1.236224327039694)':::BOX2D, e'8o\x01nm[':::STRING, '20:50:44.021195':::TIME, 'p':::STRING:::NAME, '1980-06-15':::DATE), ('BOX(-0.975011921681209 -0.16168086242661917,0.03020965355488414 0.6328506448294398)':::BOX2D, e'Q$\x1fg-10\x1a':::STRING, '23:15:36.465925':::TIME, e'^HE\b':::STRING:::NAME, '1985-09-16':::DATE), ('BOX(1.0926415132927585 -1.151958941596909,1.3411139405446475 0.9233172697122494)':::BOX2D, e'f0\x19B':::STRING, '14:30:04.769646':::TIME, e'9\t5D':::STRING:::NAME, '-infinity':::DATE)), PARTITION table1_part_5 VALUES IN (('BOX(-0.005059433094423138 -1.0885563345682512,2.0093656477612987 -0.18883935922433365)':::BOX2D, '<':::STRING, '02:23:06.149982':::TIME, 'm':::STRING:::NAME, '1972-02-23':::DATE), ('BOX(-0.48079010467327266 -1.3168002848678348,-0.15684129968771732 1.147835546551697)':::BOX2D, e'\x0eup&^"':::STRING, '16:45:49.244229':::TIME, '':::STRING:::NAME, '1974-01-06':::DATE), ('BOX(-0.5687768527193571 0.013000064752354656,-0.41297109166967894 0.6389933195548603)':::BOX2D, e'U\x05':::STRING, '16:48:38.649448':::TIME, e'\x1c|H\x14T/_':::STRING:::NAME, '1986-03-19':::DATE), ('BOX(-0.417908362593541 -1.3161702339596157,1.2305274454044297 0.516520981408497)':::BOX2D, e'&\x16>^\x0e"\x1a':::STRING, '04:07:51.483789':::TIME, e'6\frj':::STRING:::NAME, '1971-08-06':::DATE), ('BOX(-0.4391123429905246 -0.17180033076823054,2.6604365786044797 0.29318787520099354)':::BOX2D, e'7\x1e\r#bh':::STRING, '11:09:57.935371':::TIME, e'W:@A\x05i':::STRING:::NAME, '1976-01-27':::DATE), ('BOX(0.12708828740845082 -0.44135970026915483,1.3574567830076045 0.6542441222769863)':::BOX2D, e'\x19\x7f\x02(':::STRING, '19:51:05.820792':::TIME, 'OA':::STRING:::NAME, '1971-07-11':::DATE), ('BOX(0.9887142461702875 -0.26432883899353543,1.1709155717409376 0.44683575946958787)':::BOX2D, 'p':::STRING, '18:18:38.450597':::TIME, e'A@iF\x1a&wIt':::STRING:::NAME, '1974-03-06':::DATE), ('BOX(0.29473172234277545 -0.47181236925409237,1.4309792830257402 1.401354045977099)':::BOX2D, e'\'':::STRING, '23:59:04.586995':::TIME, e'\x17\x0e9f5\x1cT\x0eC':::STRING:::NAME, '1985-05-27':::DATE)), PARTITION table1_part_6 VALUES IN (('BOX(-0.7232057091566944 -0.4513151729993763,0.5204782243978701 0.6559812891578687)':::BOX2D, ' Qd>[{':::STRING, '00:42:00.788745':::TIME, '"':::STRING:::NAME, '1980-12-22':::DATE), ('BOX(0.21826725383754897 -1.8930265254544207,0.6145056980993804 -1.4366336285849268)':::BOX2D, e'0&Z\x013':::STRING, '14:49:43.096744':::TIME, e'L\n\t\x1f"Fo4N':::STRING:::NAME, '1991-06-06':::DATE), ('BOX(-0.44076849392352735 -2.5413370442081735,0.9048128481267792 -1.4665703295645462)':::BOX2D, e'\x1a\x1aE$':::STRING, '13:00:19.285393':::TIME, e'\x1fr':::STRING:::NAME, '1984-03-06':::DATE), ('BOX(-2.555474236801981 0.007576056566328759,-1.3541261656980987 1.3226281004717542)':::BOX2D, e'\x1c\x11C':::STRING, '06:23:52.945013':::TIME, '':::STRING:::NAME, '1979-12-26':::DATE), ('BOX(-0.0742637103676029 0.13515888770465456,0.47908743947616617 0.8514763285170994)':::BOX2D, e'bZ|l,xi:\x7f':::STRING, '23:19:10.547762':::TIME, 'WggjWa':::STRING:::NAME, '1970-01-01':::DATE), ('BOX(0.16392375508251977 -0.08816201609324803,0.7944992064985796 0.5885525912183757)':::BOX2D, e'"&/g\x18o\'s':::STRING, '06:55:25.249802':::TIME, 'm':::STRING:::NAME, '1996-03-21':::DATE), ('BOX(-0.6427867672416601 0.0340527188638165,-0.41202260973597826 1.0875756806561734)':::BOX2D, e'\U00002603':::STRING, '07:40:26.499623':::TIME, '-':::STRING:::NAME, '1994-01-29':::DATE), ('BOX(-1.4317274477802822 0.8776288907142282,-1.2868487456383852 1.7324662107841853)':::BOX2D, e'\x1f[~\x7f\'uW':::STRING, '15:24:40.266419':::TIME, e'\x1dN\x1b&+m':::STRING:::NAME, '1994-08-16':::DATE)), PARTITION table1_part_7 VALUES IN (('BOX(0.32480553250239375 0.07017075041253207,0.5415413279131199 1.739978223517212)':::BOX2D, e'\'':::STRING, '17:03:01.03445':::TIME, '':::STRING:::NAME, '1988-05-31':::DATE), ('BOX(-0.9770474956687636 0.26506202155860586,-0.3618014834530374 1.9720678511422776)':::BOX2D, '"':::STRING, '23:35:44.241919':::TIME, e'5U\x020':::STRING:::NAME, '1981-03-05':::DATE), ('BOX(-10 -10,10 10)':::BOX2D, e'i2\x19Tv%\x0f^':::STRING, '04:40:36.546174':::TIME, e'\x0eA':::STRING:::NAME, '1988-08-23':::DATE), ('BOX(-1.8005070901728923 0.17754651092132295,0.321007203279287 0.9494441451505657)':::BOX2D, e'M;f!\n}':::STRING, '08:36:15.479192':::TIME, e'4s;q%\x1f\x1b\b$':::STRING:::NAME, '1982-04-21':::DATE), ('BOX(0.7876551629509865 -2.419409298382103,1.0292805132712923 1.2847022942251523)':::BOX2D, 'L4D':::STRING, '11:44:32.400015':::TIME, '/j':::STRING:::NAME, '1987-10-22':::DATE), ('BOX(-1.052022831955019 -1.5036185609919417,-0.19813027422593948 0.4527769880392314)':::BOX2D, 'e':::STRING, '01:08:57.885688':::TIME, e'.A\x13)Yy6':::STRING:::NAME, '1994-02-02':::DATE), ('BOX(-0.8784190716832223 -0.2753357525552041,1.969033810920997 0.16343125066057362)':::BOX2D, '':::STRING, '16:28:23.358075':::TIME, e'?M_\x18h.\x07\x06@':::STRING:::NAME, '1976-11-01':::DATE), ('BOX(0.7173026516268275 -2.675836959493637,1.1414361383568177 0.566807349194158)':::BOX2D, e'pCr\x11':::STRING, '02:14:13.556185':::TIME, e'Ej\x06\x06\x12c2':::STRING:::NAME, '1982-08-04':::DATE)), PARTITION table1_part_8 VALUES IN (('BOX(-1.24289726311916 0.34254994553212226,1.6107349253186385 1.1139110030820893)':::BOX2D, e'}\x0bf``':::STRING, '12:47:59.182984':::TIME, e'fM\x19E':::STRING:::NAME, '1975-08-10':::DATE), ('BOX(0.36740989862426776 -1.0294214056228328,1.7541705243972627 -0.7488659175428029)':::BOX2D, e'\\D\x05Y[B$p\x17':::STRING, '10:33:38.867556':::TIME, '"':::STRING:::NAME, '1974-10-05':::DATE), ('BOX(-10 -10,10 10)':::BOX2D, e'\\pkD\x03\x1c':::STRING, '18:40:41.585281':::TIME, e'\x19d':::STRING:::NAME, '1986-07-07':::DATE), ('BOX(-0.7169803028656987 0.3055608021357292,-0.21981241146662572 0.6842497622164914)':::BOX2D, e'^3o*\f':::STRING, '23:14:00.156917':::TIME, 'd':::STRING:::NAME, '1996-08-17':::DATE), ('BOX(-0.22186440359709203 -0.522474860276191,0.6945406104640371 0.4581165908919783)':::BOX2D, e'\x10*/\x15':::STRING, '19:24:39.750261':::TIME, e'\x11]\x1f\x1e':::STRING:::NAME, '1984-02-18':::DATE), ('BOX(-0.6935590725364342 -0.34549807894231455,0.7805984520744552 -0.15210737253798495)':::BOX2D, e'\'':::STRING, '00:52:57.480061':::TIME, e'~N\rY\x19':::STRING:::NAME, '-infinity':::DATE), ('BOX(1.2006336103049131 -1.0322185827668688,1.222046326679596 -1.0223815547127004)':::BOX2D, '+Y':::STRING, '22:28:52.369082':::TIME, 'i12y':::STRING:::NAME, '1993-09-08':::DATE), ('BOX(-0.6063416648832676 -1.808523614761199,-0.32409715446498566 1.1073559797104449)':::BOX2D, 'uS':::STRING, '13:46:12.98628':::TIME, e'x\x1c69':::STRING:::NAME, '1987-03-29':::DATE))), UNIQUE (col1_9, col1_10 ASC, col1_12 DESC, col1_8 DESC, col1_5) STORING (col1_4) WHERE ((((((table1.col1_0 = '1970-01-01':::DATE) AND (table1.col1_7 = '00:00:00':::TIME)) OR (table1.col1_4 <= e'\x00':::STRING:::NAME)) AND (table1.col1_11 > '':::STRING)) AND (table1.col1_12 != '"':::STRING)) AND (table1.col1_9 = '':::STRING)) OR (table1.col1_8 != '"':::STRING), UNIQUE (col1_10 DESC, col1_3, col1_6, col1_8, col1_2 ASC, col1_11 DESC, col1_0, col1_1 ASC, lower(CAST(col1_1 AS STRING))), INDEX ((CASE WHEN col1_6 IS NULL THEN e'N\\W\x0e<\x07\x04':::STRING ELSE '':::STRING END) DESC, col1_7, col1_12 ASC, col1_0 DESC) WHERE (((((((table1.col1_10 > '"':::STRING) AND (table1.col1_8 = e'\U00002603':::STRING)) AND (table1.col1_7 > '00:00:00':::TIME)) OR (table1.col1_0 >= '5874897-12-31':::DATE)) AND (table1.col1_11 = 'X':::STRING)) AND (table1.col1_4 <= '':::STRING:::NAME)) OR (table1.col1_9 > 'X':::STRING)) AND (table1.col1_12 <= e'\x00':::STRING) NOT VISIBLE, UNIQUE (col1_11, col1_1 ASC, col1_7, lower(CAST(col1_5 AS STRING)) DESC, (CASE WHEN col1_0 IS NULL THEN '':::STRING ELSE e'A\x02\x05':::STRING END) ASC, col1_3, col1_10, col1_0, lower(CAST(col1_7 AS STRING)) DESC, col1_5, col1_2 ASC, col1_9), FAMILY (col1_2, col1_6, col1_4), FAMILY (col1_5), FAMILY (col1_1, col1_7, col1_9, col1_0), FAMILY (col1_3))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=1b2c7d90-1d05-475c-919c-378d9c4cad51 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (30.75s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ cf1e7e6bc6ef9e55510b9ed13bd068bb3894cd92:

        test_1        |                     AS tab_59616
        test_1        |             ORDER BY
        test_1        |                 col_116167 ASC NULLS FIRST;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_59615.col_116166 AS col_116167
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (st_pointfromgeohash('G':::STRING::STRING::STRING)::GEOMETRY),
        test_1        |                                 (st_makepoint(0.0:::FLOAT8::FLOAT8::FLOAT8, 2.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY),
        test_1        |                                 (NULL::GEOMETRY),
        test_1        |                                 (NULL::GEOMETRY),
        test_1        |                                 (NULL::GEOMETRY),
        test_1        |                                 (
        test_1        |                                     st_linesubstring(NULL::GEOMETRY::GEOMETRY, 9.0:::FLOAT8::FLOAT8::FLOAT8, 5.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                                 )
        test_1        |                         )
        test_1        |                             AS tab_59615 (col_116166)
        test_1        |                 )
        test_1        |                     AS tab_59616
        test_1        |             ORDER BY
        test_1        |                 col_116167 ASC NULLS FIRST;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.62s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: cockroach2
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 "char" NOT NULL, col1_1 TIME NOT NULL, PRIMARY KEY (col1_1 DESC, col1_0 ASC), INDEX (lower(col1_0) DESC, col1_0 ASC), UNIQUE (col1_1 DESC) WHERE table1.col1_1 > '24:00:00':::TIME, INDEX (col1_1 DESC, col1_0) WHERE (table1.col1_1 >= '00:00:00':::TIME) AND (table1.col1_0 != '':::STRING), UNIQUE (col1_0 DESC, col1_1) WHERE table1.col1_0 != e'\U00002603':::STRING, INDEX (col1_1 DESC, col1_0 DESC) WHERE (table1.col1_0 < '':::STRING) AND (table1.col1_1 < '24:00:00':::TIME), UNIQUE (col1_1 DESC, col1_0) WHERE table1.col1_0 < '':::STRING, UNIQUE (col1_1 DESC), UNIQUE (lower(CAST(col1_1 AS STRING)) DESC) WHERE table1.col1_1 < '00:00:00':::TIME, FAMILY (col1_1), FAMILY (col1_0));
        test_1        |             ALTER TABLE table1 INJECT STATISTICS e'[{"avg_size": 2, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 27853169, "histo_buckets": [{"distinct_range": 0, "num_eq": 2694785135002468412, "num_range": 0, "upper_bound": "\\u0015"}, {"distinct_range": 0, "num_eq": 8199772525811830063, "num_range": 40000000, "upper_bound": "H"}, {"distinct_range": 5616753284528946000, "num_eq": 10000, "num_range": 5616753284528945888, "upper_bound": "r"}], "histo_col_type": "\\"char\\"", "name": "__auto__", "null_count": 0, "row_count": 50000000}, {"avg_size": 24, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 15794688, "histo_buckets": [{"distinct_range": 0, "num_eq": 537667345466870139, "num_range": 0, "upper_bound": "00:00:00"}, {"distinct_range": 3168264024948305000, "num_eq": 6819758423280304343, "num_range": 3168264024948304955, "upper_bound": "04:16:05.956649"}, {"distinct_range": 0, "num_eq": 800000000, "num_range": 1535542295964599530, "upper_bound": "14:09:32.709286"}, {"distinct_range": 0, "num_eq": 1323070052731100045, "num_range": 3216927540969496908, "upper_bound": "15:33:43.319106"}, {"distinct_range": 3993529251347534000, "num_eq": 30000000000, "num_range": 3993529251347533846, "upper_bound": "22:55:47.899633"}], "histo_col_type": "TIME", "name": "__auto__", "null_count": 0, "row_count": 50000000}]':::JSONB;
        test_1        |             ALTER TABLE table1 INJECT STATISTICS e'[{"avg_size": 0, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_buckets": [{"distinct_range": 0, "num_eq": 5402694167076695508, "num_range": 0, "upper_bound": "?"}, {"distinct_range": 10000, "num_eq": 5471200652038374402, "num_range": 10000, "upper_bound": "O"}, {"distinct_range": 0, "num_eq": 200000, "num_range": 2493729352679032038, "upper_bound": "S"}, {"distinct_range": 167016908551887170, "num_eq": 800, "num_range": 8907405856088925369, "upper_bound": "}"}], "histo_col_type": "\\"char\\"", "name": "__auto__", "null_count": 0, "row_count": 0}, {"avg_size": 0, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_buckets": [{"distinct_range": 0, "num_eq": 4166935222376158196, "num_range": 0, "upper_bound": "00:06:48.137921"}, {"distinct_range": 0, "num_eq": 2000000000, "num_range": 500000000, "upper_bound": "01:21:26.969178"}, {"distinct_range": 0, "num_eq": 3809436001329236147, "num_range": 90000000000, "upper_bound": "02:59:19.449283"}, {"distinct_range": 3669135012409366000, "num_eq": 20000000, "num_range": 9014849992546238497, "upper_bound": "12:14:39.668457"}, {"distinct_range": 1000000, "num_eq": 8322278209560956472, "num_range": 1000000, "upper_bound": "13:30:03.894924"}, {"distinct_range": 800000000, "num_eq": 0, "num_range": 800000000, "upper_bound": "16:05:10.787039"}, {"distinct_range": 0, "num_eq": 2454054245182405183, "num_range": 600000, "upper_bound": "19:42:30.104531"}, {"distinct_range": 729673761155505900, "num_eq": 30000000000, "num_range": 7128214413850769325, "upper_bound": "21:52:11.192108"}, {"distinct_range": 0, "num_eq": 7000, "num_range": 1218794570579068575, "upper_bound": "24:00:00"}], "histo_col_type": "TIME", "name": "__auto__", "null_count": 0, "row_count": 0}]':::JSONB;
        test_1        |             
        test_1        |         compare_test.go:160: cockroach2: exec: ERROR: cannot inject statistics in an explicit transaction (SQLSTATE XXUUU)
        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_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (190.13s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ fc04d8e1eabf6b58d32e9792fd11f97c493480ad:

        test_1        |                                 ('2000-01-01 05:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ),
        test_1        |                                 ((NULL::TIMETZ::TIMETZ + '2000-01-09':::DATE::DATE::DATE)::TIMESTAMPTZ)
        test_1        |                         )
        test_1        |                             AS tab_5584 (col_9131)
        test_1        |                     ORDER BY
        test_1        |                         tab_5584.col_9131 DESC
        test_1        |                 )
        test_1        |                     AS tab_5585
        test_1        |             ORDER BY
        test_1        |                 col_9132 DESC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_5584.col_9131 AS col_9132
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 ('2000-01-01 04:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ),
        test_1        |                                 ('2000-01-01 05:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ),
        test_1        |                                 ((NULL::TIMETZ::TIMETZ + '2000-01-09'::DATE::DATE::DATE)::TIMESTAMPTZ)
        test_1        |                         )
        test_1        |                             AS tab_5584 (col_9131)
        test_1        |                     ORDER BY
        test_1        |                         tab_5584.col_9131 DESC
        test_1        |                 )
        test_1        |                     AS tab_5585
        test_1        |             ORDER BY
        test_1        |                 col_9132 DESC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.18s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 TIMETZ NOT NULL, col1_1 TIMESTAMP NOT NULL, col1_2 STRING NOT NULL, col1_3 GEOGRAPHY NULL, col1_4 STRING NULL AS (lower(CAST(col1_3 AS STRING))) STORED, INVERTED INDEX (col1_0, col1_2 ASC, col1_3 ASC) PARTITION BY LIST (col1_0, col1_2) (PARTITION table1_part_0 VALUES IN (('12:45:18.313756-02:25:00':::TIMETZ, e'\x113\x1aTE\'``\x1c\x18':::STRING)), PARTITION table1_part_1 VALUES IN (('04:51:12.243271-05:07:00':::TIMETZ, e'H\x03~=':::STRING)), PARTITION table1_part_2 VALUES IN (('08:36:34.383977+10:29:00':::TIMETZ, e'\nU':::STRING)), PARTITION table1_part_3 VALUES IN (('22:45:36.093+10:17:00':::TIMETZ, 'Z+':::STRING))) WHERE (table1.col1_1 < '-4713-11-24 00:00:00':::TIMESTAMP) OR (table1.col1_2 >= e'\x00':::STRING), UNIQUE (col1_0 ASC, lower(CAST(col1_0 AS STRING)), col1_1 DESC, col1_4 DESC, col1_2) WHERE (((table1.col1_1 > '-4713-11-24 00:00:00':::TIMESTAMP) AND (table1.col1_0 < '24:00:00-15:59:00':::TIMETZ)) OR (table1.col1_4 > e'\'':::STRING)) AND (table1.col1_2 <= e'\U00002603':::STRING), INDEX (col1_1 ASC) WHERE (((table1.col1_4 > 'X':::STRING) AND (table1.col1_1 = '3000-01-01 00:00:00':::TIMESTAMP)) AND (table1.col1_0 >= '24:00:00-15:59:00':::TIMETZ)) AND (table1.col1_2 = e'\U00002603':::STRING), FAMILY (col1_2), FAMILY (col1_4, col1_1, col1_0, col1_3))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=97ae4c70-f559-471a-8c0e-096741c7b0aa for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (36.76s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 773649a2b08605ba2031dce9b3c8858b15803ca2:

        test_1        |             -   nil,
        test_1        |             +   s"::8/0",
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_47891.col_79595 AS col_79596
        test_1        |                     FROM
        test_1        |                         (VALUES (NULL::INET), ('::6/0':::INET::INET), ('::7/0':::INET::INET), ('::8/0':::INET::INET))
        test_1        |                             AS tab_47891 (col_79595)
        test_1        |                 )
        test_1        |                     AS tab_47892
        test_1        |             ORDER BY
        test_1        |                 col_79596 DESC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_47891.col_79595 AS col_79596
        test_1        |                     FROM
        test_1        |                         (VALUES (NULL::INET), ('::6/0'::INET::INET), ('::7/0'::INET::INET), ('::8/0'::INET::INET))
        test_1        |                             AS tab_47891 (col_79595)
        test_1        |                 )
        test_1        |                     AS tab_47892
        test_1        |             ORDER BY
        test_1        |                 col_79596 DESC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.48s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table2 (col2_0 REGTYPE, col2_1 CHAR NULL, col2_2 INTERVAL NOT NULL, col2_3 TIMESTAMPTZ NOT NULL, col2_4 BOOL NOT NULL, col2_5 STRING NOT NULL AS (CASE WHEN col2_3 IS NULL THEN e'\x13H\x11N\x15\r':::STRING ELSE e'[<\f\x16r|#e':::STRING END) STORED, col2_6 STRING AS (CASE WHEN col2_0 IS NULL THEN e'\U00002603':::STRING ELSE '':::STRING END) STORED, col2_7 STRING AS (CASE WHEN col2_0 IS NULL THEN NULL ELSE '|)zYt$':::STRING END) VIRTUAL, col2_8 STRING AS (CASE WHEN col2_0 IS NULL THEN 'WG':::STRING ELSE 'c':::STRING END) VIRTUAL, INDEX (col2_3 DESC, (CASE WHEN col2_0 IS NULL THEN 'p':::STRING ELSE e'[ \x0eOg':::STRING END) ASC, col2_5 DESC, col2_0, lower(CAST(col2_4 AS STRING)) ASC, col2_2, col2_8 ASC, col2_6 DESC, col2_4) PARTITION BY LIST (col2_3) (PARTITION table2_part_0 VALUES IN (('2008-08-22 15:17:18.000358+00:00':::TIMESTAMPTZ,), ('1980-08-13 02:59:01.000762+00:00':::TIMESTAMPTZ,), ('1978-09-30 14:58:54.000311+00:00':::TIMESTAMPTZ,), ('2003-10-04 05:52:07.000091+00:00':::TIMESTAMPTZ,), ('2015-05-19 09:04:33.000367+00:00':::TIMESTAMPTZ,), ('2014-06-22 18:13:27.000768+00:00':::TIMESTAMPTZ,), ('1993-07-09 05:02:04.000394+00:00':::TIMESTAMPTZ,), ('1991-04-07 00:02:47.000234+00:00':::TIMESTAMPTZ,)), PARTITION table2_part_1 VALUES IN (('2012-12-07 08:28:38.000716+00:00':::TIMESTAMPTZ,), ('2026-09-18 19:21:19.000289+00:00':::TIMESTAMPTZ,), ('2019-07-17 12:03:05.00029+00:00':::TIMESTAMPTZ,), ('2027-04-08 21:53:33.000791+00:00':::TIMESTAMPTZ,), ('2018-04-14 12:58:50.00044+00:00':::TIMESTAMPTZ,), ('1975-06-10 12:04:04.000336+00:00':::TIMESTAMPTZ,), ('1980-03-01 04:18:30.000822+00:00':::TIMESTAMPTZ,), ('2016-07-15 22:32:32.000832+00:00':::TIMESTAMPTZ,)), PARTITION table2_part_2 VALUES IN (('1975-11-25 21:23:22.00031+00:00':::TIMESTAMPTZ,), ('1973-11-05 19:29:30.000177+00:00':::TIMESTAMPTZ,), ('2009-02-09 07:38:46.00002+00:00':::TIMESTAMPTZ,), ('1996-10-02 17:06:34.000675+00:00':::TIMESTAMPTZ,), ('2016-12-27 23:21:52.000125+00:00':::TIMESTAMPTZ,), ('1992-09-11 09:35:22.000496+00:00':::TIMESTAMPTZ,), ('1993-08-14 12:17:07.000318+00:00':::TIMESTAMPTZ,), ('1988-06-06 23:35:48.000455+00:00':::TIMESTAMPTZ,)), PARTITION table2_part_3 VALUES IN (('2020-07-29 17:22:22.000508+00:00':::TIMESTAMPTZ,), ('2002-03-25 23:51:08.000379+00:00':::TIMESTAMPTZ,), ('1983-04-01 00:57:51.000579+00:00':::TIMESTAMPTZ,), ('-4713-11-24 00:00:00+00:00':::TIMESTAMPTZ,), ('2005-11-29 18:07:50.000981+00:00':::TIMESTAMPTZ,), ('1985-11-09 13:07:34.000512+00:00':::TIMESTAMPTZ,), ('0001-01-01 00:00:00+00:00':::TIMESTAMPTZ,)), PARTITION table2_part_4 VALUES IN (('2019-10-14 04:23:17.00021+00:00':::TIMESTAMPTZ,), ('2006-03-21 04:16:24.000871+00:00':::TIMESTAMPTZ,), ('2022-03-07 20:58:59.000005+00:00':::TIMESTAMPTZ,), ('294276-12-31 23:59:59.999999+00:00':::TIMESTAMPTZ,), ('1982-03-05 13:41:12.00072+00:00':::TIMESTAMPTZ,), ('1972-08-10 20:17:14.000544+00:00':::TIMESTAMPTZ,), ('1990-07-08 10:05:46.000148+00:00':::TIMESTAMPTZ,), ('2023-10-13 13:30:50.000257+00:00':::TIMESTAMPTZ,)), PARTITION table2_part_5 VALUES IN (('2005-07-08 08:44:42.000265+00:00':::TIMESTAMPTZ,), ('2007-07-09 06:30:14.000951+00:00':::TIMESTAMPTZ,), ('2028-10-26 03:13:53.000943+00:00':::TIMESTAMPTZ,), ('2018-02-08 12:35:03.000785+00:00':::TIMESTAMPTZ,), ('1982-05-23 11:55:05.000964+00:00':::TIMESTAMPTZ,), ('1973-03-03 02:49:00.000721+00:00':::TIMESTAMPTZ,)), PARTITION table2_part_6 VALUES IN (('2028-06-15 12:19:24.00001+00:00':::TIMESTAMPTZ,), ('1976-04-06 02:30:38.00008+00:00':::TIMESTAMPTZ,), ('2004-12-22 20:35:48.000167+00:00':::TIMESTAMPTZ,), ('-2000-01-01 00:00:00+00:00':::TIMESTAMPTZ,), ('2003-04-18 20:47:59.000367+00:00':::TIMESTAMPTZ,), ('1979-10-30 06:17:19.000136+00:00':::TIMESTAMPTZ,), ('2001-07-14 06:44:30.000721+00:00':::TIMESTAMPTZ,), ('2000-02-27 18:54:39.000286+00:00':::TIMESTAMPTZ,))) WHERE ((((((table2.col2_6 < e'\'':::STRING) OR (table2.col2_1 != e'\x00':::STRING)) OR (table2.col2_5 >= e'\U00002603':::STRING)) AND (table2.col2_8 != '':::STRING)) AND (table2.col2_7 > e'\U00002603':::STRING)) AND (table2.col2_3 = '3000-01-01 00:00:00+00:00':::TIMESTAMPTZ)) AND table2.col2_4 NOT VISIBLE, UNIQUE (col2_1 ASC, col2_3 DESC), UNIQUE (col2_0 ASC, col2_8, col2_3, col2_4 ASC, col2_1, col2_6 ASC, col2_5 DESC, col2_7) WHERE ((((((table2.col2_3 = '0001-01-01 00:00:00+00:00':::TIMESTAMPTZ) AND (table2.col2_1 != '':::STRING)) AND (NOT table2.col2_4)) OR (table2.col2_5 <= e'\U00002603':::STRING)) OR (table2.col2_6 != e'\'':::STRING)) OR (table2.col2_7 = '':::STRING)) OR (table2.col2_8 = e'\'':::STRING), UNIQUE (col2_4 DESC, (CASE WHEN col2_0 IS NULL THEN e'\x0fy<U.T':::STRING ELSE e'x<\r\'T':::STRING END), col2_5, col2_8 DESC), INDEX (col2_7 DESC) STORING (col2_1, col2_4) WHERE table2.col2_4 OR (table2.col2_3 > '294276-12-31 23:59:59.999999+00:00':::TIMESTAMPTZ), UNIQUE (col2_1 DESC, col2_2) WHERE ((((((table2.col2_5 >= '"':::STRING) OR (table2.col2_7 >= '':::STRING)) AND (table2.col2_3 < '-4713-11-24 00:00:00+00:00':::TIMESTAMPTZ)) AND (table2.col2_1 = 'X':::STRING)) AND (table2.col2_6 < e'\x00':::STRING)) AND (NOT table2.col2_4)) OR (table2.col2_8 >= e'\x00':::STRING), INDEX ((CASE WHEN col2_0 IS NULL THEN e'\x05:\x07':::STRING ELSE e'\x15>|:':::STRING END), col2_4 ASC, lower(col2_1) DESC, lower(CAST(col2_4 AS STRING)) DESC, col2_0 ASC) WHERE ((((((table2.col2_3 < '-2000-01-01 00:00:00+00:00':::TIMESTAMPTZ) AND (table2.col2_1 != e'\U00002603':::STRING)) OR (table2.col2_7 < e'\'':::STRING)) AND (NOT table2.col2_4)) OR (table2.col2_5 = '"':::STRING)) OR (table2.col2_8 != e'\'':::STRING)) AND (table2.col2_6 = 'X':::STRING), INDEX (col2_2 DESC), INDEX (col2_3, (CASE WHEN col2_2 IS NULL THEN e'{$S\n}':::STRING ELSE '':::STRING END) DESC, col2_1 DESC) STORING (col2_0, col2_5, col2_6), FAMILY (col2_5), FAMILY (col2_0, col2_4, col2_3), FAMILY (col2_6, col2_2, col2_1))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=e9175d7a-1f9a-48c1-9f69-586137d4d38f for details on how to enable enterprise features (SQLSTATE XXC02)
        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_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (112.97s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ e528c6976451fa44b270364b18ec1107a49b6fc6:

        test_1        |     compare_test.go:119: Checking connection to: postgres
        test_1        |     compare_test.go:119: Checking connection to: cockroach1
        test_1        |     compare_test.go:119: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.00s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        | panic: geos: no locations to init GEOS [recovered]
        test_1        |     panic: geos: no locations to init GEOS
        test_1        | 
        test_1        | goroutine 66 [running]:
        test_1        | testing.tRunner.func1.2({0x1d762c0, 0xc001d9cca0})
        test_1        |     GOROOT/src/testing/testing.go:1396 +0x24e
        test_1        | testing.tRunner.func1()
        test_1        |     GOROOT/src/testing/testing.go:1399 +0x39f
        test_1        | panic({0x1d762c0, 0xc001d9cca0})
        test_1        |     GOROOT/src/runtime/panic.go:884 +0x212
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x362cee0?, {0x25c0148?, 0xc001da2570?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:371 +0x445
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x258f9c0?, 0x362cee0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:304 +0x13c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc001bd09c0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:221 +0x92
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc001b369c0, {0xc001b7a940?, 0x4, 0x0?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:254 +0x71f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0xc001d9b990?, 0x1f0e190?, {0xc001b7a940?, 0x1c025e0?, 0xc001b36901?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:98 +0x2e
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0x1c025e0?, {0x1f0e190, 0x5}, 0x4, 0xbf?, {0xc000ea7a58, 0x3, 0x2a68995?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/schema.go:90 +0x16a
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTablesN(0x420f5d06531e2de0?, 0x420f5d06531e2de0?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:83 +0x186
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc00027a000?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:72 +0x33
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.wrapCommonSetup.func1(0xc0017e9520?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:45 +0x22
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc0017e9520)
        test_1        |     github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:130 +0xe5
        test_1        | testing.tRunner(0xc0017e9520, 0xc001b36930)
        test_1        |     GOROOT/src/testing/testing.go:1446 +0x10b
        test_1        | created by testing.(*T).Run
        test_1        |     GOROOT/src/testing/testing.go:1493 +0x35f
        compare_test_1 exited with code 2
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 2
--- FAIL: TestComposeCompare (17.17s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 8ff653b220128d32bbd7eff2717d6212b2b6ac12:

        test_1        |     compare_test.go:119: Checking connection to: postgres
        test_1        |     compare_test.go:119: Checking connection to: cockroach1
        test_1        |     compare_test.go:119: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.00s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        | panic: geos: no locations to init GEOS [recovered]
        test_1        |     panic: geos: no locations to init GEOS
        test_1        | 
        test_1        | goroutine 7 [running]:
        test_1        | testing.tRunner.func1.2({0x1d762c0, 0xc001de7880})
        test_1        |     GOROOT/src/testing/testing.go:1396 +0x24e
        test_1        | testing.tRunner.func1()
        test_1        |     GOROOT/src/testing/testing.go:1399 +0x39f
        test_1        | panic({0x1d762c0, 0xc001de7880})
        test_1        |     GOROOT/src/runtime/panic.go:884 +0x212
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x362cee0?, {0x25c0128?, 0xc001dec2a0?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:371 +0x445
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x258f9a0?, 0x362cee0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:304 +0x13c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc001dcc000)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:221 +0x92
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc001d789c0, {0xc001d8a050?, 0x5, 0x0?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:254 +0x71f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0xc001d9f990?, 0x1f0e190?, {0xc001d8a050?, 0x1c025e0?, 0xc001d78901?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:98 +0x2e
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0x1c025e0?, {0x1f0e190, 0x5}, 0x5, 0xbf?, {0xc001d1ba58, 0x3, 0x2a68975?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/schema.go:90 +0x16a
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTablesN(0x500511dd2ebdd4f1?, 0x500511dd2ebdd4f1?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:83 +0x186
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc000282000?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:72 +0x33
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.wrapCommonSetup.func1(0xc00050b860?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:45 +0x22
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc00050b860)
        test_1        |     github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:130 +0xe5
        test_1        | testing.tRunner(0xc00050b860, 0xc001d78930)
        test_1        |     GOROOT/src/testing/testing.go:1446 +0x10b
        test_1        | created by testing.(*T).Run
        test_1        |     GOROOT/src/testing/testing.go:1493 +0x35f
        compare_test_1 exited with code 2
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 2
--- FAIL: TestComposeCompare (17.43s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ ea0e966fe05a788fd123a08cec8ef5e935fa5496:

        test_1        |                                 ('00000000-0000-0000-0000-000000000006'::UUID::UUID),
        test_1        |                                 ('00000000-0000-0000-0000-000000000009'::UUID::UUID),
        test_1        |                                 ('00000000-0000-0000-0000-000000000007'::UUID::UUID),
        test_1        |                                 ('00000000-0000-0000-0000-000000000009'::UUID::UUID)
        test_1        |                         )
        test_1        |                             AS tab_1626 (col_2802)
        test_1        |                     ORDER BY
        test_1        |                         tab_1626.col_2802 DESC, tab_1626.col_2802 NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_1627
        test_1        |             ORDER BY
        test_1        |                 col_2803;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_1626.col_2802 AS col_2803
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 ('00000000-0000-0000-0000-000000000001':::UUID::UUID),
        test_1        |                                 (NULL::UUID),
        test_1        |                                 ('00000000-0000-0000-0000-000000000006':::UUID::UUID),
        test_1        |                                 ('00000000-0000-0000-0000-000000000009':::UUID::UUID),
        test_1        |                                 ('00000000-0000-0000-0000-000000000007':::UUID::UUID),
        test_1        |                                 ('00000000-0000-0000-0000-000000000009':::UUID::UUID)
        test_1        |                         )
        test_1        |                             AS tab_1626 (col_2802)
        test_1        |                     ORDER BY
        test_1        |                         tab_1626.col_2802 DESC, tab_1626.col_2802 NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_1627
        test_1        |             ORDER BY
        test_1        |                 col_2803;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (26.98s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ ea0e966fe05a788fd123a08cec8ef5e935fa5496:

        test_1        |                                 ('\x46':::BYTES::BYTES),
        test_1        |                                 ('\x41':::BYTES::BYTES),
        test_1        |                                 ('\x4a':::BYTES::BYTES)
        test_1        |                         )
        test_1        |                             AS tab_3467 (col_6487)
        test_1        |                 )
        test_1        |                     AS tab_3468
        test_1        |             ORDER BY
        test_1        |                 col_6488 DESC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_3467.col_6487 AS col_6488
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 ('\x41'::BYTEA::BYTEA),
        test_1        |                                 (NULL::BYTEA),
        test_1        |                                 ('\x46'::BYTEA::BYTEA),
        test_1        |                                 ('\x46'::BYTEA::BYTEA),
        test_1        |                                 ('\x41'::BYTEA::BYTEA),
        test_1        |                                 ('\x4a'::BYTEA::BYTEA)
        test_1        |                         )
        test_1        |                             AS tab_3467 (col_6487)
        test_1        |                 )
        test_1        |                     AS tab_3468
        test_1        |             ORDER BY
        test_1        |                 col_6488 DESC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.32s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table3 (col3_0 GEOMETRY NULL, col3_1 REGPROCEDURE NULL, INVERTED INDEX (col3_1, col3_0) NOT VISIBLE, INVERTED INDEX (col3_1 DESC, col3_0 ASC) PARTITION BY LIST (col3_1) (PARTITION table3_part_0 VALUES IN ((884983342:::OID,), (3723435814:::OID,), (2326524530:::OID,)), PARTITION table3_part_1 VALUES IN ((1918823857:::OID,), (0:::OID,), (3946499049:::OID,)), PARTITION table3_part_2 VALUES IN ((2483779901:::OID,), (1947533673:::OID,), (834523745:::OID,)), PARTITION table3_part_3 VALUES IN ((3805595953:::OID,), (1465257334:::OID,)), PARTITION table3_part_4 VALUES IN ((1809036549:::OID,), (300544280:::OID,), (2393209417:::OID,)), PARTITION table3_part_5 VALUES IN ((2730548286:::OID,), (1831301101:::OID,), (1236936669:::OID,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))), INDEX (col3_1) PARTITION BY LIST (col3_1) (PARTITION table3_part_0 VALUES IN ((3102273709:::OID,), (2435490865:::OID,)), PARTITION table3_part_1 VALUES IN ((848522543:::OID,), (4174861150:::OID,)), PARTITION table3_part_2 VALUES IN ((0:::OID,)), PARTITION table3_part_3 VALUES IN ((562841121:::OID,), (3989411119:::OID,)), PARTITION table3_part_4 VALUES IN ((1368103917:::OID,), (3151264314:::OID,)), PARTITION table3_part_5 VALUES IN ((4073912827:::OID,), (3059471415:::OID,)), PARTITION table3_part_6 VALUES IN ((2584844127:::OID,), (1609218510:::OID,)), PARTITION table3_part_7 VALUES IN ((3588290069:::OID,), (1370391406:::OID,)), PARTITION table3_part_8 VALUES IN ((2791968474:::OID,), (437544854:::OID,))), FAMILY (col3_1), FAMILY (col3_0))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=86f18df0-2edc-47e8-930f-277d8b66454a for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (33.96s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ ea0e966fe05a788fd123a08cec8ef5e935fa5496:

        test_1        |                                 (NULL::INT4),
        test_1        |                                 (COALESCE(NULL::INT4, 0:::INT8::INT4)),
        test_1        |                                 (8:::INT8::INT4),
        test_1        |                                 (3:::INT8::INT4)
        test_1        |                         )
        test_1        |                             AS tab_108409 (col_186811)
        test_1        |                 )
        test_1        |                     AS tab_108410
        test_1        |             ORDER BY
        test_1        |                 col_186812;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_108409.col_186811 AS col_186812
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (NULL::INT4),
        test_1        |                                 (NULL::INT4),
        test_1        |                                 (COALESCE(NULL::INT4, 0::INT8::INT4)),
        test_1        |                                 (8::INT8::INT4),
        test_1        |                                 (3::INT8::INT4)
        test_1        |                         )
        test_1        |                             AS tab_108409 (col_186811)
        test_1        |                 )
        test_1        |                     AS tab_108410
        test_1        |             ORDER BY
        test_1        |                 col_186812;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.33s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table3 (col3_0 INT4 NULL, col3_1 INT2 NOT NULL, col3_2 JSONB NOT NULL, col3_3 DECIMAL NOT NULL, col3_4 REGNAMESPACE NULL, col3_5 BIT(26) NULL, col3_6 REGPROC, col3_7 TIMESTAMPTZ NOT NULL, col3_8 STRING AS (CASE WHEN col3_6 IS NULL THEN NULL ELSE e'RhM0j\'+io':::STRING END) STORED, col3_9 INT8 NULL AS (col3_0 + 2147483647:::INT8) STORED, col3_10 STRING NOT NULL AS (CASE WHEN col3_7 IS NULL THEN e'Q\x01f-E\f':::STRING ELSE e'\\iEF\x1a?;':::STRING END) STORED, col3_11 STRING AS (CASE WHEN col3_6 IS NULL THEN 'H?Y':::STRING ELSE ';YQ-':::STRING END) VIRTUAL, col3_12 INT8 NULL AS (col3_1 + col3_0) STORED, UNIQUE (col3_11, col3_5 ASC) PARTITION BY LIST (col3_11) (PARTITION table3_part_0 VALUES IN (('V':::STRING,), (e'NT 1\rj':::STRING,), (e'\x1d':::STRING,), (e'\x0fhK_}\x12':::STRING,), ('LM':::STRING,)), PARTITION table3_part_1 VALUES IN ((e'\x10\t':::STRING,), ('5P':::STRING,), ('0':::STRING,), ('"':::STRING,), ('':::STRING,)), PARTITION table3_part_2 VALUES IN (('iI':::STRING,), ('<':::STRING,), (e'~\x1a\t\x0f]':::STRING,), (e'\x7fJ\x14Ii=':::STRING,), (e'\f&\x02w\x0e)\x11I\x19':::STRING,)), PARTITION table3_part_3 VALUES IN ((e'\x00':::STRING,), (e'\x1b4\x1eb':::STRING,), (e'RP}\x10':::STRING,)), PARTITION table3_part_4 VALUES IN (('X':::STRING,), (e'\x1cF_6-\nK':::STRING,), ('2':::STRING,), (e'@a\x10)Z':::STRING,), (e'S\x02[':::STRING,)), PARTITION table3_part_5 VALUES IN (('))yI#':::STRING,), (e'Z!k\x06\x19':::STRING,), (e'&?/@8:$\x15\x1b':::STRING,), (e'\x0bZ?R)\x0b\x02':::STRING,)), PARTITION table3_part_6 VALUES IN ((e'lT\b~\'$Y':::STRING,), (e'\r8:\x02\'\rl':::STRING,), (e':e\x1bl\f>k!\x1b':::STRING,), (e'"^\x14\x07\x19Y|\x1bv':::STRING,), (e'``\'I\'\x06':::STRING,)), PARTITION table3_part_7 VALUES IN ((e'\x15S\'\x16':::STRING,), (e'M&``kH+\x14n>':::STRING,), (e'%\x01\x1bku':::STRING,), (e'{"t\x14%]\'U':::STRING,), (e'[\x1ar6^':::STRING,))) WHERE ((((table3.col3_12 <= 9223372036854775807:::INT8) AND (table3.col3_8 >= e'\x00':::STRING)) AND (table3.col3_3 <= '-Infinity':::DECIMAL)) OR (table3.col3_9 < 127:::INT8)) AND (table3.col3_1 < (-32768):::INT8), INDEX (col3_0 ASC, col3_1 DESC, col3_6 ASC, lower(CAST(col3_5 AS STRING))), INVERTED INDEX (col3_9 DESC, col3_8 gin_trgm_ops ASC) WHERE (((table3.col3_10 < 'X':::STRING) OR (table3.col3_11 = e'\'':::STRING)) AND (table3.col3_9 >= 2147483647:::INT8)) OR (table3.col3_7 <= '3000-01-01 00:00:00+00:00':::TIMESTAMPTZ), FAMILY (col3_3, col3_12), FAMILY (col3_7, col3_2), FAMILY (col3_10, col3_4), FAMILY (col3_5), FAMILY (col3_0, col3_6, col3_1, col3_9, col3_8))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=44e239a3-394d-485a-8b5a-cda443fd8f52 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (168.94s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ ea0e966fe05a788fd123a08cec8ef5e935fa5496:

        test_1        |     --- FAIL: TestCompare/postgres (30.14s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: postgres
        test_1        |         compare_test.go:188: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare1047637941/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:190: compare postgres to cockroach1: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   string("10000000000000"),
        test_1        |             +   nil,
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_20598.col_31826 AS col_31827
        test_1        |                     FROM
        test_1        |                         (VALUES (B'1000'::BIT(14)), (B'1000'::BIT(14)), (NULL::BIT(14)), (B'1001'::BIT(14)), (B'1001'::BIT(14)))
        test_1        |                             AS tab_20598 (col_31826)
        test_1        |                     ORDER BY
        test_1        |                         tab_20598.col_31826, tab_20598.col_31826 DESC
        test_1        |                 )
        test_1        |                     AS tab_20599
        test_1        |             ORDER BY
        test_1        |                 col_31827;
        test_1        |             
        test_1        |             cockroach1: [same as previous]
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.64s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: cockroach2
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 REGROLE NOT NULL, PRIMARY KEY (col1_0 ASC), INDEX (col1_0 DESC) NOT VISIBLE, UNIQUE (col1_0), INDEX (col1_0 DESC), INDEX (col1_0 ASC), UNIQUE (col1_0 DESC), UNIQUE (col1_0 ASC), INDEX (col1_0 DESC), INDEX (col1_0), UNIQUE (col1_0));
        test_1        |             ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 23, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1005752703248885413, "histo_buckets": [{"distinct_range": 0, "num_eq": 9204641859915430829, "num_range": 0, "upper_bound": "525391413"}, {"distinct_range": 0, "num_eq": 800, "num_range": 0, "upper_bound": "1150015950"}, {"distinct_range": 9023931553302624000, "num_eq": 6465503909368184429, "num_range": 9023931553302624039, "upper_bound": "1849397351"}, {"distinct_range": 10000000000, "num_eq": 4104527394302064327, "num_range": 10000000000, "upper_bound": "4191588055"}], "histo_col_type": "REGROLE", "name": "__auto__", "null_count": 0, "row_count": 9041580587573401985}]':::JSONB;
        test_1        |             ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 15, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 43, "histo_buckets": [{"distinct_range": 0, "num_eq": 7402759059979583877, "num_range": 0, "upper_bound": "0"}, {"distinct_range": 0, "num_eq": 1350809019804764987, "num_range": 70000, "upper_bound": "828943675"}, {"distinct_range": 2331369047474268000, "num_eq": 90000, "num_range": 4514465957048810949, "upper_bound": "1173158108"}, {"distinct_range": 52519025023.758415, "num_eq": 4713714521266909341, "num_range": 70000000000, "upper_bound": "1809582721"}, {"distinct_range": 8212088538213338000, "num_eq": 177372609090741656, "num_range": 8212088538213338180, "upper_bound": "2065914658"}, {"distinct_range": 0, "num_eq": 90000000000, "num_range": 100, "upper_bound": "3037061284"}, {"distinct_range": 645519371534785700, "num_eq": 1448707468299944519, "num_range": 1540804000679907148, "upper_bound": "4227973485"}], "histo_col_type": "REGROLE", "name": "__auto__", "null_count": 0, "row_count": 60}]':::JSONB;
        test_1        |             
        test_1        |         compare_test.go:160: cockroach2: exec: ERROR: cannot inject statistics in an explicit transaction (SQLSTATE XXUUU)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (57.21s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 6d4dd6df63c2c9d516153404fd15d62d4e3c9908:

        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | 2022-12-28 06:17:12.856 UTC [49] LOG:  received fast shutdown request
        postgres_1    | waiting for server to shut down....2022-12-28 06:17:12.858 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2022-12-28 06:17:12.859 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2022-12-28 06:17:12.861 UTC [51] LOG:  shutting down
        postgres_1    | 2022-12-28 06:17:12.957 UTC [49] LOG:  database system is shut down
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2022-12-28 06:17:13.078 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2022-12-28 06:17:13.078 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2022-12-28 06:17:13.078 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2022-12-28 06:17:13.082 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2022-12-28 06:17:13.086 UTC [68] LOG:  database system was shut down at 2022-12-28 06:17:12 UTC
        postgres_1    | 2022-12-28 06:17:13.093 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2022-12-28 06:17:14.309 UTC [78] ERROR:  syntax error at or near "ASC" at character 163
        postgres_1    | 2022-12-28 06:17:14.309 UTC [78] STATEMENT:  CREATE TABLE table2 (col2_0 DATE NOT NULL, col2_1 BOOL NOT NULL, col2_2 "char" NOT NULL, col2_3 FLOAT4 NOT NULL, col2_4 GEOMETRY NOT NULL, INVERTED INDEX (col2_0 ASC, col2_3, col2_4))
        test_1        | --- FAIL: TestCompare (4.40s)
        test_1        |     compare_test.go:119: Checking connection to: postgres
        test_1        |     compare_test.go:119: Checking connection to: cockroach1
        test_1        |     compare_test.go:119: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.94s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: postgres
        test_1        |         compare_test.go:159: CREATE TABLE table2 (col2_0 DATE NOT NULL, col2_1 BOOL NOT NULL, col2_2 "char" NOT NULL, col2_3 FLOAT4 NOT NULL, col2_4 GEOMETRY NOT NULL, INVERTED INDEX (col2_0 ASC, col2_3, col2_4))
        test_1        |         compare_test.go:160: postgres: exec: ERROR: syntax error at or near "ASC" (SQLSTATE 42601)
        test_1        |     --- FAIL: TestCompare/mutators (0.33s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 "char", col1_1 DATE NOT NULL, col1_2 VARCHAR NOT NULL, col1_3 CHAR NOT NULL, col1_4 REGPROCEDURE NULL, col1_5 REGPROC, col1_6 STRING NOT NULL AS (lower(col1_0)) VIRTUAL, PRIMARY KEY (col1_3, col1_6 ASC, col1_1 DESC), INDEX (col1_4 ASC), INDEX (col1_6 ASC, col1_2 DESC, col1_4 ASC, col1_0 DESC, col1_1 DESC) WHERE ((((table1.col1_1 > '-infinity':::DATE) AND (table1.col1_0 != e'\x00':::STRING)) AND (table1.col1_3 = e'\'':::STRING)) AND (table1.col1_2 <= e'\x00':::STRING)) OR (table1.col1_6 <= '"':::STRING), UNIQUE (col1_3) STORING (col1_2, col1_4, col1_5), UNIQUE (col1_6 ASC, col1_4 DESC) STORING (col1_0, col1_2, col1_5) WHERE (((table1.col1_2 = e'\x00':::STRING) AND (table1.col1_3 <= 'X':::STRING)) AND (table1.col1_0 != 'X':::STRING)) AND (table1.col1_6 > e'\'':::STRING), INDEX (col1_0, col1_4 ASC, col1_1 ASC, col1_2 ASC, col1_6 ASC, (CASE WHEN col1_1 IS NULL THEN e'\x0e\x03q\x0f2\b66t':::STRING ELSE '%Wf':::STRING END) ASC) STORING (col1_5) WHERE ((((table1.col1_0 <= '':::STRING) OR (table1.col1_1 <= 'infinity':::DATE)) AND (table1.col1_6 > e'\x00':::STRING)) AND (table1.col1_2 >= e'\'':::STRING)) AND (table1.col1_3 != '"':::STRING), INDEX (col1_2, col1_3 ASC, (CASE WHEN col1_1 IS NULL THEN '>':::STRING ELSE '':::STRING END) ASC, col1_4 DESC, col1_6 DESC) STORING (col1_0, col1_5), UNIQUE (col1_3, col1_5 ASC) PARTITION BY LIST (col1_3, col1_5) (PARTITION table1_part_0 VALUES IN ((e'\x04':::STRING, 371193179:::OID), (e'\'':::STRING, 786748471:::OID), (e'\x1b':::STRING, 3352526084:::OID)), PARTITION table1_part_1 VALUES IN (('k':::STRING, 2418223823:::OID), (e'\'':::STRING, 2113760445:::OID), ('=':::STRING, 506869892:::OID)), PARTITION table1_part_2 VALUES IN ((e'\x17':::STRING, 236264066:::OID), ('G':::STRING, 927761285:::OID), ('a':::STRING, 3155090735:::OID)), PARTITION table1_part_3 VALUES IN (('$':::STRING, 2705965903:::OID), ('H':::STRING, 0:::OID), ('P':::STRING, 0:::OID)), PARTITION table1_part_4 VALUES IN (('m':::STRING, 1416106151:::OID), ('Z':::STRING, 1353111086:::OID), ('V':::STRING, 925400291:::OID)), PARTITION table1_part_5 VALUES IN (('T':::STRING, 912575285:::OID), ('':::STRING, 1701475424:::OID), ('(':::STRING, 2068270146:::OID)), PARTITION table1_part_6 VALUES IN ((e'\x1f':::STRING, 2604667448:::OID), ('7':::STRING, 3465855422:::OID), ('t':::STRING, 0:::OID))) WHERE ((((table1.col1_3 < e'\'':::STRING) AND (table1.col1_0 = e'\x00':::STRING)) OR (table1.col1_6 >= e'\x00':::STRING)) OR (table1.col1_1 <= '-infinity':::DATE)) AND (table1.col1_2 <= 'X':::STRING))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=b77b213a-3bb9-4620-8b0c-900f4b6ca76c for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (19.18s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ afab335620e28c5d8c849ba09e50ec12c2836b3f:

        test_1        |         compare_test.go:190: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   nil,
        test_1        |             +   float64(8),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_175215.col_259759 AS col_259760
        test_1        |                     FROM
        test_1        |                         (VALUES (NULL::FLOAT8), (NULL::FLOAT8), (8.0::FLOAT8::FLOAT8)) AS tab_175215 (col_259759)
        test_1        |                 )
        test_1        |                     AS tab_175216
        test_1        |             ORDER BY
        test_1        |                 col_259760 ASC;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_175215.col_259759 AS col_259760
        test_1        |                     FROM
        test_1        |                         (VALUES (NULL::FLOAT8), (NULL::FLOAT8), (8.0:::FLOAT8::FLOAT8)) AS tab_175215 (col_259759)
        test_1        |                 )
        test_1        |                     AS tab_175216
        test_1        |             ORDER BY
        test_1        |                 col_259760 ASC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.21s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 REGROLE NULL, col1_1 UUID NOT NULL, col1_2 TIMESTAMPTZ NULL, INDEX (col1_0 DESC), UNIQUE (col1_1 DESC, col1_0 ASC, col1_2 ASC), UNIQUE (col1_0) WHERE table1.col1_2 < '-2000-01-01 00:00:00+00:00':::TIMESTAMPTZ, INDEX (col1_0, col1_1 DESC, col1_2 DESC) NOT VISIBLE, UNIQUE (col1_1, col1_0, col1_2) WHERE table1.col1_2 >= '0001-01-01 00:00:00+00:00':::TIMESTAMPTZ, UNIQUE (col1_0 ASC), UNIQUE (col1_2, col1_1 ASC), INDEX (col1_1 DESC) STORING (col1_0, col1_2) WHERE table1.col1_2 >= '294276-12-31 23:59:59.999999+00:00':::TIMESTAMPTZ, INDEX (col1_0 ASC, col1_1 DESC) PARTITION BY LIST (col1_0) (PARTITION table1_part_0 VALUES IN ((1054535405:::OID,)), PARTITION table1_part_1 VALUES IN ((1650611519:::OID,)), PARTITION table1_part_2 VALUES IN ((575606080:::OID,)), PARTITION table1_part_3 VALUES IN ((1565950738:::OID,)), PARTITION table1_part_4 VALUES IN ((3792186949:::OID,))) NOT VISIBLE)
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=f5ce9e1d-23ba-4d9d-8358-fd11b6070cd0 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (262.35s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 07a53a36601e9ca5fcffcff55f69b43c6dfbf1c1:

        test_1        |     compare_test.go:119: Checking connection to: postgres
        test_1        |     compare_test.go:119: Checking connection to: cockroach1
        test_1        |     compare_test.go:119: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.00s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        | panic: geos: no locations to init GEOS [recovered]
        test_1        |     panic: geos: no locations to init GEOS
        test_1        | 
        test_1        | goroutine 5 [running]:
        test_1        | testing.tRunner.func1.2({0x1d76180, 0xc001cd2100})
        test_1        |     GOROOT/src/testing/testing.go:1396 +0x24e
        test_1        | testing.tRunner.func1()
        test_1        |     GOROOT/src/testing/testing.go:1399 +0x39f
        test_1        | panic({0x1d76180, 0xc001cd2100})
        test_1        |     GOROOT/src/runtime/panic.go:884 +0x212
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x362cee0?, {0x25bffa8?, 0xc001ce2a20?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:371 +0x445
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x258f820?, 0x362cee0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:304 +0x13c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc001d6aea0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:221 +0x92
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc001be5890, {0xc001d54050?, 0x5, 0x0?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:254 +0x71f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0xc001d67990?, 0x1f0e050?, {0xc001d54050?, 0x1c024a0?, 0xc001be5801?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:98 +0x2e
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0x1c024a0?, {0x1f0e050, 0x5}, 0x5, 0xbf?, {0xc001c83a58, 0x3, 0x2a687f5?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/schema.go:90 +0x16a
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTablesN(0xed0ef60d10db274?, 0xed0ef60d10db274?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:83 +0x186
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc0005caa00?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:72 +0x33
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.wrapCommonSetup.func1(0xc0009a5520?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:45 +0x22
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc0009a5520)
        test_1        |     github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:130 +0xe5
        test_1        | testing.tRunner(0xc0009a5520, 0xc001be5800)
        test_1        |     GOROOT/src/testing/testing.go:1446 +0x10b
        test_1        | created by testing.(*T).Run
        test_1        |     GOROOT/src/testing/testing.go:1493 +0x35f
        compare_test_1 exited with code 2
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 2
--- FAIL: TestComposeCompare (17.83s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 07a53a36601e9ca5fcffcff55f69b43c6dfbf1c1:

        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2022-12-31 06:17:43.208 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2022-12-31 06:17:43.208 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2022-12-31 06:17:43.208 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2022-12-31 06:17:43.211 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2022-12-31 06:17:43.216 UTC [68] LOG:  database system was shut down at 2022-12-31 06:17:43 UTC
        postgres_1    | 2022-12-31 06:17:43.221 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2022-12-31 06:17:45.391 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2022-12-31 06:17:45.391 UTC [78] STATEMENT:  CREATE TABLE table4 (col4_0 GEOGRAPHY NOT NULL, col4_1 TIMESTAMPTZ NOT NULL, col4_2 BOOL, col4_3 BIT(2) NOT NULL, col4_4 BYTEA[] NOT NULL, col4_5 DATE NULL, col4_6 INT4 NOT NULL, col4_7 TIMETZ NOT NULL, col4_8 CHAR NOT NULL, col4_9 REGPROC NULL, col4_10 REGROLE, col4_11 VARCHAR NOT NULL, col4_12 BIT(43) NULL, col4_13 NAME NOT NULL, col4_14 FLOAT8 NOT NULL, col4_15 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col4_4 IS NULL THEN e'=KH\x10\x04E['::TEXT ELSE '=>U'::TEXT END) STORED, col4_16 TEXT GENERATED ALWAYS AS (CASE WHEN col4_10 IS NULL THEN e'\x00'::TEXT ELSE e'\x12\x16C\x7f3M\x14t'::TEXT END) STORED, col4_17 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col4_4 IS NULL THEN 'g"'::TEXT ELSE e'\x01'::TEXT END) STORED);
        postgres_1    |     CREATE INDEX ON table4 (col4_11, col4_3 ASC, col4_1, col4_7) INCLUDE (col4_0, col4_4, col4_5, col4_9, col4_10, col4_12, col4_15, col4_16);
        postgres_1    |     CREATE UNIQUE INDEX ON table4 (col4_9 DESC, col4_8 ASC, col4_10, col4_16 ASC, col4_3 DESC, col4_15 ASC, col4_17 DESC, col4_13 ASC, col4_12) INCLUDE (col4_1, col4_4, col4_7, col4_11, col4_14);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (4.77s)
        test_1        |     compare_test.go:119: Checking connection to: postgres
        test_1        |     compare_test.go:119: Checking connection to: cockroach1
        test_1        |     compare_test.go:119: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/mutators (0.37s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: cockroach2
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 REGROLE NULL, col1_1 TIME NOT NULL, col1_2 VARCHAR NOT NULL, col1_3 CHAR NULL, col1_4 DECIMAL NOT NULL, col1_5 INT4 NOT NULL, col1_6 INET NOT NULL, col1_7 "char"[] NOT NULL, col1_8 JSONB, col1_9 NAME NOT NULL, col1_10 REGROLE NULL, col1_11 STRING NOT NULL AS (lower(CAST(col1_1 AS STRING))) VIRTUAL, FAMILY (col1_2, col1_8), FAMILY (col1_7), FAMILY (col1_10, col1_9), FAMILY (col1_5, col1_3, col1_4), FAMILY (col1_1, col1_6, col1_0));
        test_1        |             ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 22, "columns": ["col1_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 522218441, "histo_col_type": "", "name": "__auto__", "null_count": 236850566, "row_count": 1000000000}, {"avg_size": 18, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 143514394, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1000000000}, {"avg_size": 13, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 351917708, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1000000000}, {"avg_size": 1, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 872738695, "histo_col_type": "", "name": "__auto__", "null_count": 274606417, "row_count": 1000000000}, {"avg_size": 31, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 596279788, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1000000000}, {"avg_size": 15, "columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 170249511, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1000000000}, {"avg_size": 28, "columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 192692631, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1000000000}, {"avg_size": 23, "columns": ["col1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 363487866, "histo_col_type": "", "name": "__auto__", "null_count": 502724156, "row_count": 1000000000}, {"avg_size": 17, "columns": ["col1_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 842777441, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1000000000}, {"avg_size": 27, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 616202506, "histo_col_type": "", "name": "__auto__", "null_count": 293975264, "row_count": 1000000000}, {"avg_size": 19, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 803266270, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1000000000}, {"avg_size": 31, "columns": ["col1_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 838884058, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1000000000}]':::JSONB;
        test_1        |             ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 27, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 72300492958690417, "histo_col_type": "", "name": "__auto__", "null_count": 2024441848916556616, "row_count": 4132878190014473523}, {"avg_size": 9, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 494790594877339434, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4132878190014473523}, {"avg_size": 19, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1302022888867104030, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4132878190014473523}, {"avg_size": 26, "columns": ["col1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2570259887314524690, "histo_col_type": "", "name": "__auto__", "null_count": 3580921357742115732, "row_count": 4132878190014473523}, {"avg_size": 4, "columns": ["col1_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1815246101066106866, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4132878190014473523}, {"avg_size": 21, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3855441658556627027, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4132878190014473523}, {"avg_size": 30, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3788246516030125467, "histo_col_type": "", "name": "__auto__", "null_count": 407074256664360998, "row_count": 4132878190014473523}, {"avg_size": 16, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3675351434800275740, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4132878190014473523}, {"avg_size": 28, "columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2593932416950958895, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4132878190014473523}, {"avg_size": 26, "columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1227970566917094899, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4132878190014473523}, {"avg_size": 9, "columns": ["col1_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4024648560267492273, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4132878190014473523}, {"avg_size": 7, "columns": ["col1_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2736243876651275649, "histo_col_type": "", "name": "__auto__", "null_count": 312019342124377976, "row_count": 4132878190014473523}]':::JSONB;
        test_1        |             
        test_1        |         compare_test.go:160: cockroach2: exec: ERROR: cannot inject statistics in an explicit transaction (SQLSTATE XXUUU)
        test_1        |     --- FAIL: TestCompare/postgres (1.28s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: postgres
        test_1        |         compare_test.go:159: CREATE TABLE table4 (col4_0 GEOGRAPHY NOT NULL, col4_1 TIMESTAMPTZ NOT NULL, col4_2 BOOL, col4_3 BIT(2) NOT NULL, col4_4 BYTEA[] NOT NULL, col4_5 DATE NULL, col4_6 INT4 NOT NULL, col4_7 TIMETZ NOT NULL, col4_8 CHAR NOT NULL, col4_9 REGPROC NULL, col4_10 REGROLE, col4_11 VARCHAR NOT NULL, col4_12 BIT(43) NULL, col4_13 NAME NOT NULL, col4_14 FLOAT8 NOT NULL, col4_15 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col4_4 IS NULL THEN e'=KH\x10\x04E['::TEXT ELSE '=>U'::TEXT END) STORED, col4_16 TEXT GENERATED ALWAYS AS (CASE WHEN col4_10 IS NULL THEN e'\x00'::TEXT ELSE e'\x12\x16C\x7f3M\x14t'::TEXT END) STORED, col4_17 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col4_4 IS NULL THEN 'g"'::TEXT ELSE e'\x01'::TEXT END) STORED);
        test_1        |             CREATE INDEX ON table4 (col4_11, col4_3 ASC, col4_1, col4_7) INCLUDE (col4_0, col4_4, col4_5, col4_9, col4_10, col4_12, col4_15, col4_16);
        test_1        |             CREATE UNIQUE INDEX ON table4 (col4_9 DESC, col4_8 ASC, col4_10, col4_16 ASC, col4_3 DESC, col4_15 ASC, col4_17 DESC, col4_13 ASC, col4_12) INCLUDE (col4_1, col4_4, col4_7, col4_11, col4_14);
        test_1        |             
        test_1        |         compare_test.go:160: postgres: exec: ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (19.45s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 07a53a36601e9ca5fcffcff55f69b43c6dfbf1c1:

        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_10733.col_21640 AS col_21641
        test_1        |                     FROM
        test_1        |                         (VALUES (NULL::OID), (NULL::OID), (0::OID::OID), (NULL::OID)) AS tab_10733 (col_21640)
        test_1        |                     WHERE
        test_1        |                         true::BOOL
        test_1        |                     ORDER BY
        test_1        |                         tab_10733.col_21640 NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_10734
        test_1        |             ORDER BY
        test_1        |                 col_21641 DESC;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_10733.col_21640 AS col_21641
        test_1        |                     FROM
        test_1        |                         (VALUES (NULL::OID), (NULL::OID), (0:::OID::OID), (NULL::OID)) AS tab_10733 (col_21640)
        test_1        |                     WHERE
        test_1        |                         true::BOOL
        test_1        |                     ORDER BY
        test_1        |                         tab_10733.col_21640 NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_10734
        test_1        |             ORDER BY
        test_1        |                 col_21641 DESC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.16s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 TIMESTAMP NOT NULL, col1_1 DECIMAL NOT NULL, col1_2 VARCHAR NOT NULL, col1_3 CHAR, col1_4 BOX2D NULL, col1_5 GEOGRAPHY, col1_6 CHAR NOT NULL, col1_7 VARCHAR NOT NULL, col1_8 REGROLE NOT NULL, col1_9 TIMETZ NOT NULL, col1_10 INT2 NOT NULL, col1_11 INT4 NOT NULL, col1_12 REGNAMESPACE NOT NULL, col1_13 STRING NULL AS (lower(CAST(col1_4 AS STRING))) STORED, PRIMARY KEY (col1_1 DESC, col1_10, col1_12 DESC, col1_6, col1_0, col1_11 DESC, col1_7 ASC, col1_2 DESC, col1_8), INDEX (col1_10 ASC, col1_1 ASC, col1_13 ASC, col1_4 ASC, col1_7 ASC, col1_9, col1_6 DESC, col1_0 ASC, col1_11 DESC, col1_2 DESC, col1_8, col1_12) WHERE (((((((table1.col1_11 <= (-32768):::INT8) AND (table1.col1_7 != '"':::STRING)) AND (table1.col1_6 = '"':::STRING)) OR (table1.col1_0 = '294276-12-31 23:59:59.999999':::TIMESTAMP)) AND (table1.col1_9 >= '24:00:00-15:59:00':::TIMETZ)) OR (table1.col1_1 > '-Infinity':::DECIMAL)) OR (table1.col1_2 != e'\'':::STRING)) AND (table1.col1_13 != e'\x00':::STRING), INVERTED INDEX (col1_2, col1_7 DESC, (col1_1 + 857219221382625780.4:::DECIMAL) ASC, col1_5 ASC) PARTITION BY LIST (col1_2, col1_7) (PARTITION table1_part_0 VALUES IN (('P':::STRING, '^':::STRING)), PARTITION table1_part_1 VALUES IN (('}y=':::STRING, e'\x0bL[a':::STRING)), PARTITION table1_part_2 VALUES IN (('#r>QR':::STRING, e'%``9\tZ&':::STRING)), PARTITION table1_part_3 VALUES IN (('J':::STRING, 'cj``':::STRING)), PARTITION table1_part_4 VALUES IN ((e'I \x01fv3\x1b\x12':::STRING, e')\x16':::STRING))) WHERE (((((((((table1.col1_10 < 1:::INT8) AND (table1.col1_13 = e'\U00002603':::STRING)) AND (table1.col1_1 < (-1.234E+401):::DECIMAL)) OR (table1.col1_11 != (-1):::INT8)) OR (table1.col1_9 < '24:00:00-15:59:00':::TIMETZ)) AND (table1.col1_0 < '3000-01-01 00:00:00':::TIMESTAMP)) OR (table1.col1_7 <= e'\U00002603':::STRING)) AND (table1.col1_6 < e'\'':::STRING)) AND (table1.col1_2 >= '':::STRING)) AND (table1.col1_3 > '':::STRING), INDEX (col1_4 DESC) STORING (col1_9) NOT VISIBLE)
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=ead676e0-9770-488c-80af-fa9bc468b563 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (41.60s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 07a53a36601e9ca5fcffcff55f69b43c6dfbf1c1:

        test_1        |               []any(Inverse(func1, []any{
        test_1        |                 s"4",
        test_1        |             -   string("0.7021090668904347B"),
        test_1        |             +   string("0.7021090668904346B"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (3:::INT8::INT8::INT8 # 7:::INT8::INT8::INT8)::INT8 AS col_56365,
        test_1        |                         (tanh(tan(7.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::FLOAT8::FLOAT8 || 'B':::STRING::STRING::STRING)::STRING
        test_1        |                             AS col_56366
        test_1        |                 )
        test_1        |                     AS tab_39958
        test_1        |             ORDER BY
        test_1        |                 col_56365 DESC, col_56366 ASC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (3::INT8::INT8::INT8 # 7::INT8::INT8::INT8)::INT8 AS col_56365,
        test_1        |                         (tanh(tan(7.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::FLOAT8::FLOAT8 || 'B'::TEXT::TEXT::TEXT)::TEXT
        test_1        |                             AS col_56366
        test_1        |                 )
        test_1        |                     AS tab_39958
        test_1        |             ORDER BY
        test_1        |                 col_56365 DESC, col_56366 ASC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.18s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 VARCHAR NOT NULL, col1_1 REGPROCEDURE NULL, col1_2 STRING NOT NULL, col1_3 INET NOT NULL, col1_4 GEOMETRY NOT NULL, col1_5 VARCHAR, col1_6 INT4 NULL, col1_7 BIT(16) NOT NULL, col1_8 STRING NOT NULL AS (lower(col1_0)) VIRTUAL, col1_9 STRING NOT NULL AS (lower(col1_2)) VIRTUAL, UNIQUE (col1_2 ASC, col1_6 DESC, col1_0 ASC, lower(col1_5) ASC, col1_8) STORING (col1_1, col1_3) WHERE table1.col1_6 < 2147483647:::INT8, INVERTED INDEX (col1_7 DESC, col1_5, col1_2, col1_4 ASC) PARTITION BY LIST (col1_7) (PARTITION table1_part_0 VALUES IN ((B'0101100011001010',), (B'1111001001001000',)), PARTITION table1_part_1 VALUES IN ((B'0101001110100100',), (B'1011110000100110',)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))), INDEX (col1_1 DESC) WHERE (((table1.col1_8 < 'X':::STRING) OR (table1.col1_9 >= e'\U00002603':::STRING)) OR (table1.col1_0 <= e'\'':::STRING)) OR (table1.col1_6 != 2147483647:::INT8) NOT VISIBLE, UNIQUE (col1_7 DESC, col1_8 ASC, col1_1 ASC, col1_5 DESC, lower(col1_5)) STORING (col1_0) PARTITION BY LIST (col1_7, col1_8) (PARTITION table1_part_0 VALUES IN ((B'0011000001001010', 'n':::STRING), (B'1000101000101011', e'F\x7f8':::STRING), (B'0100100000100001', e'\b':::STRING), (B'1001001100001110', 'y':::STRING), (B'0010101101001000', e'\f4``8':::STRING)), PARTITION table1_part_1 VALUES IN ((B'0001111010010001', e'\'':::STRING), (B'1110001001011100', e'+b<7\tsQd':::STRING), (B'1110101110111111', e'5XI``\\\x1e\x15':::STRING), (B'0000000000000000', e'\x00':::STRING), (B'1011101100011000', e'\x12EL':::STRING)), PARTITION "DEFAULT" VALUES IN ((DEFAULT, DEFAULT))) WHERE (((((table1.col1_8 < 'X':::STRING) AND (table1.col1_0 <= e'\'':::STRING)) OR (table1.col1_6 = 0:::INT8)) OR (table1.col1_5 = '"':::STRING)) AND (table1.col1_2 > e'\'':::STRING)) OR (table1.col1_9 > e'\U00002603':::STRING), UNIQUE (col1_1 DESC, col1_8, col1_9) STORING (col1_0, col1_3, col1_4, col1_5, col1_6) WHERE (table1.col1_2 <= '"':::STRING) AND (table1.col1_8 != e'\x00':::STRING))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=996cf317-8bd0-40e9-ab73-d8867e795500 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (78.43s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 07a53a36601e9ca5fcffcff55f69b43c6dfbf1c1:

        test_1        |         compare_test.go:188: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare4272357054/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:190: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   uint32(5),
        test_1        |             +   nil,
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_78804.col_128070 AS col_128071
        test_1        |                     FROM
        test_1        |                         (VALUES (NULL::OID), (1:::OID::OID), (5:::OID::OID)) AS tab_78804 (col_128070)
        test_1        |                     ORDER BY
        test_1        |                         tab_78804.col_128070
        test_1        |                 )
        test_1        |                     AS tab_78805
        test_1        |             ORDER BY
        test_1        |                 col_128071 DESC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_78804.col_128070 AS col_128071
        test_1        |                     FROM
        test_1        |                         (VALUES (NULL::OID), (1::OID::OID), (5::OID::OID)) AS tab_78804 (col_128070)
        test_1        |                     ORDER BY
        test_1        |                         tab_78804.col_128070
        test_1        |                 )
        test_1        |                     AS tab_78805
        test_1        |             ORDER BY
        test_1        |                 col_128071 DESC;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (150.50s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ b04fee28b3ab934a2826e08ca9696a22e74d0ec0:

        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_86482.col_160412 AS col_160413
        test_1        |                     FROM
        test_1        |                         (VALUES (7::OID::OID), (NULL::OID), (5::OID::OID), (3::OID::OID), (9::OID::OID), (3::OID::OID))
        test_1        |                             AS tab_86482 (col_160412)
        test_1        |                     ORDER BY
        test_1        |                         tab_86482.col_160412 DESC NULLS LAST, tab_86482.col_160412 DESC NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_86483
        test_1        |             ORDER BY
        test_1        |                 col_160413 DESC;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_86482.col_160412 AS col_160413
        test_1        |                     FROM
        test_1        |                         (VALUES (7:::OID::OID), (NULL::OID), (5:::OID::OID), (3:::OID::OID), (9:::OID::OID), (3:::OID::OID))
        test_1        |                             AS tab_86482 (col_160412)
        test_1        |                     ORDER BY
        test_1        |                         tab_86482.col_160412 DESC NULLS LAST, tab_86482.col_160412 DESC NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_86483
        test_1        |             ORDER BY
        test_1        |                 col_160413 DESC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.36s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 INTERVAL NOT NULL, col1_1 BOX2D, col1_2 REGPROCEDURE, col1_3 BYTES NOT NULL, col1_4 TIME NOT NULL, col1_5 FLOAT8, col1_6 GEOGRAPHY NOT NULL, col1_7 DATE NOT NULL, col1_8 TIMESTAMPTZ NOT NULL, col1_9 REGNAMESPACE, col1_10 STRING NOT NULL AS (CASE WHEN col1_7 IS NULL THEN 'SEp':::STRING ELSE '``%9':::STRING END) STORED, col1_11 STRING NOT NULL AS (CASE WHEN col1_0 IS NULL THEN e'\x0b-H~':::STRING ELSE e']\x02B\x1f``g':::STRING END) VIRTUAL, col1_12 FLOAT8 AS (col1_5 + 0.6855442487991228:::FLOAT8) STORED, col1_13 FLOAT8 AS (col1_5 + (-0.583121722460441):::FLOAT8) VIRTUAL, col1_14 STRING NOT NULL AS (lower(CAST(col1_4 AS STRING))) STORED, col1_15 STRING AS (CASE WHEN col1_9 IS NULL THEN e'\x108v':::STRING ELSE e'5J^4,\n':::STRING END) STORED, col1_16 STRING AS (lower(CAST(col1_1 AS STRING))) STORED, col1_17 STRING NOT NULL AS (CASE WHEN col1_3 IS NULL THEN e'*Wb\f\x042':::STRING ELSE '':::STRING END) STORED, col1_18 FLOAT8 AS (col1_5 + (-0.035488057973895204):::FLOAT8) VIRTUAL, INVERTED INDEX (col1_1, col1_2 ASC, col1_12 ASC, col1_18 ASC, lower(CAST(col1_6 AS STRING)) ASC, col1_8 ASC, col1_3, (CASE WHEN col1_7 IS NULL THEN e'\b\\\x1e':::STRING ELSE '&;=':::STRING END) ASC, col1_16, col1_4, col1_0, col1_7 DESC, col1_14, col1_6 ASC), INVERTED INDEX (col1_16, col1_8 DESC, col1_13 ASC, col1_7 ASC, col1_4, (col1_5 + 0.6933051724180816:::FLOAT8) ASC, col1_2, col1_15 DESC, col1_11 DESC, lower(CAST(col1_4 AS STRING)), col1_3, col1_17, col1_18 DESC, col1_0 ASC, col1_10 ASC, col1_12 ASC, col1_6 ASC), UNIQUE (col1_4 ASC, col1_12 DESC, col1_18 DESC, col1_8 DESC, col1_2 ASC, col1_13) STORING (col1_1, col1_9, col1_10, col1_14, col1_17) PARTITION BY LIST (col1_4, col1_12, col1_18, col1_8, col1_2) (PARTITION table1_part_0 VALUES IN (('04:50:28.149421':::TIME, 1.4577380107364193:::FLOAT8, (-0.6232091796064152):::FLOAT8, '-4713-11-24 00:00:00+00:00':::TIMESTAMPTZ, 0:::OID), ('13:49:56.185745':::TIME, (-0.6988954022500915):::FLOAT8, (-0.4839138129971836):::FLOAT8, '1976-08-18 05:30:38.000568+00:00':::TIMESTAMPTZ, 42216774:::OID), ('00:00:00':::TIME, 0.3155745466261201:::FLOAT8, (-0.7384307090305292):::FLOAT8, '2030-09-11 15:18:48.000674+00:00':::TIMESTAMPTZ, 475582486:::OID), ('17:04:57.58763':::TIME, 1.13812972119675:::FLOAT8, (-2.004680203721761):::FLOAT8, '2010-10-29 08:19:27.000995+00:00':::TIMESTAMPTZ, 3559803577:::OID)), PARTITION "DEFAULT" VALUES IN ((DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT))) WHERE (((((((((((((table1.col1_18 <= 3.4028234663852886e+38:::FLOAT8) AND (table1.col1_11 = '"':::STRING)) OR (table1.col1_14 > e'\U00002603':::STRING)) AND (table1.col1_7 < '4714-11-24 BC':::DATE)) OR (table1.col1_17 != e'\'':::STRING)) OR (table1.col1_15 <= e'\x00':::STRING)) AND (table1.col1_8 != '-2000-01-01 00:00:00+00:00':::TIMESTAMPTZ)) OR (table1.col1_10 != e'\U00002603':::STRING)) OR (table1.col1_16 < 'X':::STRING)) AND (table1.col1_4 >= '24:00:00':::TIME)) OR (table1.col1_12 >= 5e-324:::FLOAT8)) OR (table1.col1_13 < 1.7976931348623157e+308:::FLOAT8)) OR (table1.col1_3 > '\x58':::BYTES)) OR (table1.col1_5 < 1.0:::FLOAT8), UNIQUE (col1_14 ASC, col1_16, (CASE WHEN col1_7 IS NULL THEN e'VL0>\x04':::STRING ELSE e'oFp>\x145tb+':::STRING END), col1_10, (col1_5 + 0.72886702383967:::FLOAT8) ASC, col1_5 ASC, col1_17, col1_8 ASC, col1_13 DESC, col1_2 DESC, col1_0 ASC) WHERE (((((((((((((table1.col1_4 != '24:00:00':::TIME) AND (table1.col1_5 >= 'NaN':::FLOAT8)) AND (table1.col1_15 = e'\U00002603':::STRING)) OR (table1.col1_13 != 1.0:::FLOAT8)) AND (table1.col1_10 = e'\x00':::STRING)) OR (table1.col1_14 > e'\x00':::STRING)) AND (table1.col1_11 != '':::STRING)) AND (table1.col1_17 <= e'\x00':::STRING)) OR (table1.col1_18 = 0.0:::FLOAT8)) AND (table1.col1_8 <= '-2000-01-01 00:00:00+00:00':::TIMESTAMPTZ)) AND (table1.col1_16 != e'\'':::STRING)) OR (table1.col1_12 >= 1.7976931348623157e+308:::FLOAT8)) AND (table1.col1_3 < '\x':::BYTES)) OR (table1.col1_7 >= 'infinity':::DATE))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=9385927d-e084-4360-b9c7-448e518c4f7c for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (150.13s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ e503f18b84ee4ddc9fea9f46f69596a7d62ec757:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 00ed5143845ec05797d16e6ab61d179cf51775f2:

        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         NULL::rand_typ_3 AS col_29166, tab_18333.col_29164 AS col_29167
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (NULL::DECIMAL, NULL::rand_typ_3),
        test_1        |                                 (COALESCE(1::DECIMAL::DECIMAL, 0::DECIMAL::DECIMAL), NULL::rand_typ_3),
        test_1        |                                 (8::DECIMAL::DECIMAL, NULL::rand_typ_3),
        test_1        |                                 (6::DECIMAL::DECIMAL, NULL::rand_typ_3),
        test_1        |                                 (1::DECIMAL::DECIMAL, NULL::rand_typ_3),
        test_1        |                                 (
        test_1        |                                     (5::DECIMAL::DECIMAL::DECIMAL ^ (NULL::INT8::INT8 - 5::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::DECIMAL,
        test_1        |                                     NULL::rand_typ_3
        test_1        |                                 )
        test_1        |                         )
        test_1        |                             AS tab_18333 (col_29164, col_29165)
        test_1        |                     WHERE
        test_1        |                         true::BOOL
        test_1        |                     ORDER BY
        test_1        |                         tab_18333.col_29165 ASC, tab_18333.col_29164 NULLS FIRST
        test_1        |                 )
        test_1        |                     AS tab_18334
        test_1        |             ORDER BY
        test_1        |                 col_29166 NULLS FIRST, col_29167;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.58s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: cockroach2
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 FLOAT8 NOT NULL, col1_1 REGPROCEDURE NULL, col1_2 FLOAT8 NOT NULL AS (col1_0 + 1.1888026001099783:::FLOAT8) STORED, INDEX (col1_0 DESC) STORING (col1_1) WHERE table1.col1_2 <= 1.0:::FLOAT8, FAMILY (col1_2), FAMILY (col1_1), FAMILY (col1_0));
        test_1        |             ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 22, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 542, "histo_buckets": [{"distinct_range": 0, "num_eq": 1793605465347921640, "num_range": 0, "upper_bound": "-0.22759418364696204"}, {"distinct_range": 91214.45099906833, "num_eq": 5000000000, "num_range": 100000, "upper_bound": "1.540550290579894"}, {"distinct_range": 0, "num_eq": 3985726514713552758, "num_range": 2761400643934224369, "upper_bound": "1.6105303613483049"}], "histo_col_type": "FLOAT8", "name": "__auto__", "null_count": 0, "row_count": 1000}, {"avg_size": 9, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 886, "histo_col_type": "", "name": "__auto__", "null_count": 988, "row_count": 1000}, {"avg_size": 2, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 931, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1000}]':::JSONB;
        test_1        |             ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 15, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 550132068855811547, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1961270030378598362}, {"avg_size": 13, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 38950732120416753, "histo_col_type": "", "name": "__auto__", "null_count": 511456842425213485, "row_count": 1961270030378598362}, {"avg_size": 20, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1291024430277936700, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1961270030378598362}]':::JSONB;
        test_1        |             
        test_1        |         compare_test.go:160: cockroach2: exec: ERROR: cannot inject statistics in an explicit transaction (SQLSTATE XXUUU)
        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_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (56.86s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ cce52c9eab1210c6cd508f6b99b2bad0ba3e1e56:

Slow failing tests:
TestComposeCompare - 295.10s

Slow passing tests:
<none>

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #82867 compose: TestComposeCompare failed [C-test-failure O-robot T-sql-sessions branch-master] - #78068 compose: TestComposeCompare failed [C-test-failure O-robot T-sql-sessions branch-release-22.1 sync-me-8] - #73421 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.2 sync-me-8]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ cce52c9eab1210c6cd508f6b99b2bad0ba3e1e56:

        postgres_1    | 
        postgres_1    | 2023-01-08 06:16:48.505 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2023-01-08 06:16:48.505 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2023-01-08 06:16:48.505 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2023-01-08 06:16:48.509 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2023-01-08 06:16:48.513 UTC [69] LOG:  database system was shut down at 2023-01-08 06:16:48 UTC
        postgres_1    | 2023-01-08 06:16:48.518 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-01-08 06:16:49.711 UTC [79] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2023-01-08 06:16:49.711 UTC [79] STATEMENT:  CREATE TABLE table1 (col1_0 BOX2D NOT NULL, col1_1 REGPROC, col1_2 TEXT, col1_3 BOOL NOT NULL, col1_4 TIMESTAMPTZ NOT NULL, col1_5 TEXT NOT NULL, col1_6 BYTEA NOT NULL, col1_7 INT2 NULL, col1_8 TIMESTAMP NOT NULL, col1_9 DATE NOT NULL, col1_10 INTERVAL NOT NULL, col1_11 VARCHAR NOT NULL, col1_12 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_10 IS NULL THEN e'\x00'::TEXT ELSE e'(TyXF\x04``'::TEXT END) STORED, col1_13 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_10 IS NULL THEN '&*{?'::TEXT ELSE 'T'::TEXT END) STORED, col1_14 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_6 IS NULL THEN e'2_xK\x11'::TEXT ELSE e'~6\x07]|e\t7Q'::TEXT END) STORED, col1_15 TEXT NOT NULL GENERATED ALWAYS AS (lower(col1_5)) STORED);
        postgres_1    |     CREATE INDEX ON table1 (col1_4, lower(col1_5) DESC, col1_13 DESC, col1_7, col1_3 DESC, col1_1 DESC, col1_6 DESC, col1_2, col1_15 DESC, col1_10 DESC);
        postgres_1    |     CREATE UNIQUE INDEX ON table1 (col1_9 ASC, (CASE WHEN col1_1 IS NULL THEN '&z'::TEXT ELSE e'pZB\x05ZY\x1c.'::TEXT END) DESC, col1_8 ASC, col1_15) INCLUDE (col1_0, col1_1, col1_2, col1_3, col1_4, col1_10);
        postgres_1    |     CREATE UNIQUE INDEX ON table1 (col1_4 DESC, col1_6) INCLUDE (col1_0, col1_1, col1_2, col1_3, col1_5, col1_9);
        postgres_1    |     CREATE INDEX ON table1 (col1_8 ASC, col1_3 DESC, col1_7 ASC, col1_10 DESC, col1_2 DESC, lower(col1_2) DESC, col1_12 ASC);
        postgres_1    |     CREATE INDEX ON table1 (col1_12 DESC, col1_1 ASC, col1_5 ASC, col1_9, (CASE WHEN col1_9 IS NULL THEN e'g\x1f-c``l^'::TEXT ELSE e'\x15'::TEXT END) ASC);
        postgres_1    |     CREATE INDEX ON table1 (col1_8 ASC, col1_2 DESC, col1_1 ASC) INCLUDE (col1_4, col1_6, col1_7);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (4.09s)
        test_1        |     compare_test.go:119: Checking connection to: postgres
        test_1        |     compare_test.go:119: Checking connection to: cockroach1
        test_1        |     compare_test.go:119: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/mutators (0.14s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 REGCLASS, col1_1 INT4 NULL, col1_2 TIME NULL, col1_3 CHAR, col1_4 GEOMETRY NOT NULL, col1_5 GEOGRAPHY[] NOT NULL, col1_6 INET NOT NULL, col1_7 STRING NOT NULL AS (lower(CAST(col1_4 AS STRING))) VIRTUAL, col1_8 STRING NOT NULL AS (lower(CAST(col1_4 AS STRING))) VIRTUAL, col1_9 STRING NOT NULL AS (lower(CAST(col1_6 AS STRING))) STORED, col1_10 STRING NOT NULL AS (CASE WHEN col1_5 IS NULL THEN '7N':::STRING ELSE e'\x1c\x0e:-<':::STRING END) STORED, UNIQUE (col1_1 ASC) PARTITION BY LIST (col1_1) (PARTITION table1_part_0 VALUES IN ((1:::INT8,), (1456324698:::INT8,), ((-1201231710):::INT8,), ((-2119267831):::INT8,), ((-1):::INT8,), ((-1557466909):::INT8,), ((-161601971):::INT8,), (0:::INT8,)), PARTITION table1_part_1 VALUES IN (((-384923941):::INT8,), ((-1634807641):::INT8,), ((-1104740298):::INT8,), ((-1616463770):::INT8,), ((-236915763):::INT8,), ((-1535932214):::INT8,), ((-953751161):::INT8,), ((-1456869385):::INT8,)), PARTITION table1_part_2 VALUES IN (((-474445216):::INT8,), ((-629288821):::INT8,), ((-1037639004):::INT8,), (18986204:::INT8,), ((-373113589):::INT8,), ((-889508051):::INT8,), (567845838:::INT8,), (1831748718:::INT8,)), PARTITION table1_part_3 VALUES IN (((-336702220):::INT8,), ((-563050260):::INT8,), (1824452342:::INT8,), (1414786971:::INT8,), (355894906:::INT8,), (187306762:::INT8,), (1068722174:::INT8,)), PARTITION table1_part_4 VALUES IN (((-1438012058):::INT8,), (1285483425:::INT8,), ((-1785869140):::INT8,), (986204412:::INT8,), ((-310546792):::INT8,), ((-995995622):::INT8,), (913459723:::INT8,), ((-504160555):::INT8,)), PARTITION table1_part_5 VALUES IN (((-1202326342):::INT8,), (546361007:::INT8,), (2147483647:::INT8,), (1071867936:::INT8,), ((-1253398433):::INT8,), (1025957265:::INT8,), (230210027:::INT8,), (850247097:::INT8,)), PARTITION table1_part_6 VALUES IN ((2087508397:::INT8,), ((-1352418460):::INT8,), (1987896333:::INT8,), (1133628361:::INT8,), (1366693699:::INT8,), (127:::INT8,), ((-373881107):::INT8,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))) WHERE ((((table1.col1_10 >= e'\x00':::STRING) OR (table1.col1_2 = '24:00:00':::TIME)) AND (table1.col1_1 < 2147483647:::INT8)) OR (table1.col1_8 < e'\x00':::STRING)) AND (table1.col1_9 < 'X':::STRING), UNIQUE (col1_2), INDEX (col1_3 DESC) STORING (col1_0, col1_1, col1_4, col1_6) WHERE (((table1.col1_2 > '24:00:00':::TIME) AND (table1.col1_1 >= 2147483647:::INT8)) OR (table1.col1_10 = '"':::STRING)) OR (table1.col1_7 >= '':::STRING), INVERTED INDEX (col1_6 DESC, col1_4 ASC) WHERE ((((((table1.col1_9 >= e'\U00002603':::STRING) OR (table1.col1_10 < e'\x00':::STRING)) OR (table1.col1_1 < 1:::INT8)) AND (table1.col1_3 != 'X':::STRING)) AND (table1.col1_7 > e'\x00':::STRING)) AND (table1.col1_2 != '24:00:00':::TIME)) AND (table1.col1_8 < e'\U00002603':::STRING), INVERTED INDEX (col1_7, col1_5) WHERE ((((((table1.col1_8 = e'\U00002603':::STRING) AND (table1.col1_7 != e'\'':::STRING)) AND (table1.col1_1 != (-1):::INT8)) OR (table1.col1_10 != e'\U00002603':::STRING)) AND (table1.col1_3 = e'\U00002603':::STRING)) AND (table1.col1_9 > e'\x00':::STRING)) AND (table1.col1_2 < '00:00:00':::TIME) NOT VISIBLE, FAMILY (col1_3), FAMILY (col1_9), FAMILY (col1_4), FAMILY (col1_0, col1_1, col1_6), FAMILY (col1_5, col1_2, col1_10))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=a4bfc5d2-e91f-460b-8712-fd8203e183dc for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        |     --- FAIL: TestCompare/postgres (0.82s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: postgres
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 BOX2D NOT NULL, col1_1 REGPROC, col1_2 TEXT, col1_3 BOOL NOT NULL, col1_4 TIMESTAMPTZ NOT NULL, col1_5 TEXT NOT NULL, col1_6 BYTEA NOT NULL, col1_7 INT2 NULL, col1_8 TIMESTAMP NOT NULL, col1_9 DATE NOT NULL, col1_10 INTERVAL NOT NULL, col1_11 VARCHAR NOT NULL, col1_12 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_10 IS NULL THEN e'\x00'::TEXT ELSE e'(TyXF\x04``'::TEXT END) STORED, col1_13 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_10 IS NULL THEN '&*{?'::TEXT ELSE 'T'::TEXT END) STORED, col1_14 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_6 IS NULL THEN e'2_xK\x11'::TEXT ELSE e'~6\x07]|e\t7Q'::TEXT END) STORED, col1_15 TEXT NOT NULL GENERATED ALWAYS AS (lower(col1_5)) STORED);
        test_1        |             CREATE INDEX ON table1 (col1_4, lower(col1_5) DESC, col1_13 DESC, col1_7, col1_3 DESC, col1_1 DESC, col1_6 DESC, col1_2, col1_15 DESC, col1_10 DESC);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_9 ASC, (CASE WHEN col1_1 IS NULL THEN '&z'::TEXT ELSE e'pZB\x05ZY\x1c.'::TEXT END) DESC, col1_8 ASC, col1_15) INCLUDE (col1_0, col1_1, col1_2, col1_3, col1_4, col1_10);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_4 DESC, col1_6) INCLUDE (col1_0, col1_1, col1_2, col1_3, col1_5, col1_9);
        test_1        |             CREATE INDEX ON table1 (col1_8 ASC, col1_3 DESC, col1_7 ASC, col1_10 DESC, col1_2 DESC, lower(col1_2) DESC, col1_12 ASC);
        test_1        |             CREATE INDEX ON table1 (col1_12 DESC, col1_1 ASC, col1_5 ASC, col1_9, (CASE WHEN col1_9 IS NULL THEN e'g\x1f-c``l^'::TEXT ELSE e'\x15'::TEXT END) ASC);
        test_1        |             CREATE INDEX ON table1 (col1_8 ASC, col1_2 DESC, col1_1 ASC) INCLUDE (col1_4, col1_6, col1_7);
        test_1        |             
        test_1        |         compare_test.go:160: 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_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (18.34s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ cce52c9eab1210c6cd508f6b99b2bad0ba3e1e56:

        test_1        |                                 ('C':::STRING::"char"),
        test_1        |                                 ('I':::STRING::"char"),
        test_1        |                                 ('F':::STRING::"char")
        test_1        |                         )
        test_1        |                             AS tab_92841 (col_174910)
        test_1        |                 )
        test_1        |                     AS tab_92842
        test_1        |             ORDER BY
        test_1        |                 col_174911 ASC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_92841.col_174910 AS col_174911
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 ('H'::TEXT::"char"),
        test_1        |                                 (NULL::"char"),
        test_1        |                                 ('H'::TEXT::"char"),
        test_1        |                                 ('C'::TEXT::"char"),
        test_1        |                                 ('I'::TEXT::"char"),
        test_1        |                                 ('F'::TEXT::"char")
        test_1        |                         )
        test_1        |                             AS tab_92841 (col_174910)
        test_1        |                 )
        test_1        |                     AS tab_92842
        test_1        |             ORDER BY
        test_1        |                 col_174911 ASC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.26s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table2 (col2_0 INT4 NULL, col2_1 BOOL NOT NULL, col2_2 TIME NOT NULL, col2_3 BOOL NOT NULL, col2_4 "char" NOT NULL, PRIMARY KEY (col2_3 ASC, col2_2), INDEX (col2_3, col2_4, col2_0, lower(CAST(col2_1 AS STRING)), col2_1 ASC) WHERE ((table2.col2_1 AND (table2.col2_4 <= '"':::STRING)) AND (table2.col2_2 >= '24:00:00':::TIME)) AND (table2.col2_0 <= 1:::INT8) NOT VISIBLE, UNIQUE (col2_2 DESC, col2_1, col2_4 DESC, col2_0 DESC, col2_3 DESC) PARTITION BY LIST (col2_2, col2_1, col2_4, col2_0) (PARTITION table2_part_0 VALUES IN (('24:00:00':::TIME, false, 'O':::STRING, 1501513638:::INT8), ('05:14:03.137151':::TIME, true, e'\x1c':::STRING, (-928760590):::INT8), ('13:09:18.802154':::TIME, false, 'W':::STRING, 2144095532:::INT8), ('10:39:10.669069':::TIME, true, '8':::STRING, 1530985182:::INT8)), PARTITION "DEFAULT" VALUES IN ((DEFAULT, DEFAULT, DEFAULT, DEFAULT))) WHERE ((table2.col2_4 >= '"':::STRING) AND (table2.col2_2 = '00:00:00':::TIME)) OR (table2.col2_0 < (-128):::INT8), FAMILY (col2_4, col2_1, col2_3, col2_2), FAMILY (col2_0))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=63192eaa-2da1-4c0b-83e6-a4135962861b for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (199.07s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 3e9689a013e7cb70d49ebc0fe3781e272f427b03:

        test_1        |         compare_test.go:190: compare postgres to cockroach1: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   string("A"),
        test_1        |             +   nil,
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_16918.col_26789 AS col_26790
        test_1        |                     FROM
        test_1        |                         (VALUES ('J'::TEXT::CHAR), (NULL::CHAR), ('A'::TEXT::CHAR), (NULL::CHAR)) AS tab_16918 (col_26789)
        test_1        |                 )
        test_1        |                     AS tab_16919
        test_1        |             ORDER BY
        test_1        |                 col_26790;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_16918.col_26789 AS col_26790
        test_1        |                     FROM
        test_1        |                         (VALUES ('J':::STRING::CHAR), (NULL::CHAR), ('A':::STRING::CHAR), (NULL::CHAR)) AS tab_16918 (col_26789)
        test_1        |                 )
        test_1        |                     AS tab_16919
        test_1        |             ORDER BY
        test_1        |                 col_26790;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.31s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 BIT(2) NOT NULL, col1_1 REGCLASS NOT NULL, col1_2 REGTYPE NOT NULL, col1_3 FLOAT8 NOT NULL, col1_4 REGNAMESPACE NOT NULL, col1_5 TIMETZ NOT NULL, col1_6 STRING NOT NULL AS (CASE WHEN col1_1 IS NULL THEN 'cDT':::STRING ELSE 'rx;64':::STRING END) VIRTUAL, PRIMARY KEY (col1_0, col1_2 DESC, col1_6 ASC, col1_3, col1_5 DESC, col1_4, col1_1 ASC), INDEX (col1_4 ASC) PARTITION BY LIST (col1_4) (PARTITION table1_part_0 VALUES IN ((1429996825:::OID,))), INDEX (col1_1, col1_3 ASC, col1_2, col1_5 DESC, col1_6 DESC, col1_4 ASC) WHERE ((table1.col1_5 >= '24:00:00-15:59:00':::TIMETZ) AND (table1.col1_3 < 'NaN':::FLOAT8)) AND (table1.col1_6 >= '"':::STRING), UNIQUE (col1_5 ASC, col1_6 DESC, col1_3, col1_2, lower(CAST(col1_0 AS STRING)) DESC, col1_1), UNIQUE (col1_4 ASC) WHERE ((table1.col1_6 < 'X':::STRING) AND (table1.col1_3 = '-Inf':::FLOAT8)) AND (table1.col1_5 > '00:00:00+15:59:00':::TIMETZ), UNIQUE (col1_1 ASC, col1_5 DESC, col1_3 DESC, col1_0, col1_2, (CASE WHEN col1_2 IS NULL THEN e'vDKh\x17U.':::STRING ELSE e'G@\x1c\x06A':::STRING END) DESC, lower(CAST(col1_5 AS STRING)) ASC) WHERE ((table1.col1_3 > (-1.0):::FLOAT8) AND (table1.col1_6 > e'\U00002603':::STRING)) AND (table1.col1_5 != '24:00:00-15:59:00':::TIMETZ), INDEX (col1_2 ASC, col1_3, col1_1 ASC, col1_0 DESC) WHERE ((table1.col1_5 <= '00:00:00+15:59:00':::TIMETZ) OR (table1.col1_6 > e'\x00':::STRING)) AND (table1.col1_3 >= 5e-324:::FLOAT8), UNIQUE (col1_4 ASC, (CASE WHEN col1_2 IS NULL THEN e'F\x06|0':::STRING ELSE e'\x0e;e':::STRING END) ASC, col1_6 ASC, col1_2, col1_1) PARTITION BY LIST (col1_4) (PARTITION table1_part_0 VALUES IN ((3987485251:::OID,), (0:::OID,), (1565828341:::OID,), (3711609331:::OID,), (3905223741:::OID,), (698146725:::OID,), (37579508:::OID,), (476634791:::OID,), (3996585831:::OID,)), PARTITION table1_part_1 VALUES IN ((1996246682:::OID,), (2651915752:::OID,), (1220408497:::OID,), (3038942443:::OID,), (557996248:::OID,), (708862602:::OID,), (1949161482:::OID,), (4036077009:::OID,), (858539795:::OID,)), PARTITION table1_part_2 VALUES IN ((942644040:::OID,), (4088494381:::OID,), (3783382578:::OID,), (4020665988:::OID,), (2335807657:::OID,), (1408897622:::OID,), (4022778648:::OID,), (4233529459:::OID,)), PARTITION table1_part_3 VALUES IN ((1294095297:::OID,), (2053227689:::OID,), (2346375410:::OID,), (716429241:::OID,), (2416645609:::OID,), (3257242244:::OID,), (959547736:::OID,), (3551438689:::OID,)), PARTITION table1_part_4 VALUES IN ((4070245708:::OID,), (2982143663:::OID,), (3325386115:::OID,), (2096094096:::OID,)), PARTITION table1_part_5 VALUES IN ((3987511528:::OID,), (1625939762:::OID,), (262692616:::OID,), (940798278:::OID,), (1781384545:::OID,), (1426808922:::OID,), (507689808:::OID,)), PARTITION table1_part_6 VALUES IN ((4089605238:::OID,), (1204747188:::OID,), (3642005395:::OID,), (3053142239:::OID,), (357249981:::OID,), (338712536:::OID,), (1822879243:::OID,), (2484026318:::OID,)), PARTITION table1_part_7 VALUES IN ((2799683977:::OID,), (1252490675:::OID,), (3928397445:::OID,), (1088935504:::OID,), (1084830299:::OID,), (3608059507:::OID,), (2974870938:::OID,), (2297623756:::OID,)), PARTITION table1_part_8 VALUES IN ((3927004539:::OID,), (908049194:::OID,), (3512781500:::OID,), (1576898747:::OID,), (2504175617:::OID,), (4017387057:::OID,), (1365994962:::OID,), (3188808365:::OID,)), PARTITION table1_part_9 VALUES IN ((3910205826:::OID,), (134674659:::OID,), (3029599022:::OID,), (3322425397:::OID,), (3426659394:::OID,), (1563427103:::OID,), (1267316608:::OID,), (332164889:::OID,), (3994992924:::OID,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))) WHERE ((table1.col1_3 > (-1.0):::FLOAT8) OR (table1.col1_5 < '24:00:00-15:59:00':::TIMETZ)) OR (table1.col1_6 < e'\x00':::STRING))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=a44164cd-6a28-4713-a55c-b95cc6c56a9d for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (50.16s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-22.2 @ 70abf3f409be04bb8b1f1a1644f5ba49f433af6a:

        test_1        |                         tab_20746.col_28172 NULLS LAST, tab_20746.col_28172 NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_20747
        test_1        |             ORDER BY
        test_1        |                 col_28173 DESC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_20746.col_28172 AS col_28173
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (6::DECIMAL::DECIMAL),
        test_1        |                                 ((3::DECIMAL::DECIMAL::DECIMAL / NULL::INT8::INT8)::DECIMAL),
        test_1        |                                 (7::DECIMAL::DECIMAL),
        test_1        |                                 (9::DECIMAL::DECIMAL)
        test_1        |                         )
        test_1        |                             AS tab_20746 (col_28172)
        test_1        |                     ORDER BY
        test_1        |                         tab_20746.col_28172 NULLS LAST, tab_20746.col_28172 NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_20747
        test_1        |             ORDER BY
        test_1        |                 col_28173 DESC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.36s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: cockroach2
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 BOOL NOT NULL, col1_1 INET NOT NULL, col1_2 DECIMAL NOT NULL, col1_3 FLOAT4 NOT NULL, col1_4 STRING NOT NULL AS (lower(CAST(col1_0 AS STRING))) VIRTUAL, col1_5 STRING NOT NULL AS (lower(CAST(col1_1 AS STRING))) STORED, PRIMARY KEY (col1_3, col1_1), INDEX (col1_3, col1_2 DESC, col1_0) STORING (col1_5) WHERE table1.col1_3 != '+Inf':::FLOAT8, UNIQUE (col1_0, col1_4 DESC, col1_5 ASC, col1_2, col1_3), FAMILY (col1_0), FAMILY (col1_1, col1_3), FAMILY (col1_5, col1_2));
        test_1        |             ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 19, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2191394, "histo_buckets": [{"distinct_range": 0, "num_eq": 3099303723899348153, "num_range": 0, "upper_bound": "false"}, {"distinct_range": 10000000, "num_eq": 4000, "num_range": 10000000, "upper_bound": "true"}], "histo_col_type": "BOOL", "name": "__auto__", "null_count": 0, "row_count": 3000000}, {"avg_size": 20, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1999054, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3000000}, {"avg_size": 11, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2182776, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3000000}, {"avg_size": 21, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 10753, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3000000}, {"avg_size": 17, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1508312, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3000000}, {"avg_size": 18, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1432889, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3000000}]':::JSONB;
        test_1        |             ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 12, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 967972409908052737, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1893013980519813046}, {"avg_size": 21, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 428422077284567412, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1893013980519813046}, {"avg_size": 9, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 661065707238917582, "histo_buckets": [{"distinct_range": 0, "num_eq": 168881536012485631, "num_range": 0, "upper_bound": "false"}, {"distinct_range": 878703536778919600, "num_eq": 1883711039038915014, "num_range": 878703536778919573, "upper_bound": "true"}], "histo_col_type": "BOOL", "name": "__auto__", "null_count": 0, "row_count": 1893013980519813046}, {"avg_size": 23, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 615531688239852864, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1893013980519813046}, {"avg_size": 21, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 727974273684497583, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1893013980519813046}, {"avg_size": 2, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1764880045936174253, "histo_buckets": [{"distinct_range": 0, "num_eq": 9094930597951471575, "num_range": 0, "upper_bound": "-1.086777925491333"}, {"distinct_range": 90000000, "num_eq": 5586156934734553287, "num_range": 90000000, "upper_bound": "-0.9809216260910034"}, {"distinct_range": 0, "num_eq": 20000, "num_range": 0, "upper_bound": "-0.8192903995513916"}], "histo_col_type": "FLOAT4", "name": "__auto__", "null_count": 0, "row_count": 1893013980519813046}]':::JSONB;
        test_1        |             
        test_1        |         compare_test.go:160: cockroach2: exec: ERROR: cannot inject statistics in an explicit transaction (SQLSTATE XXUUU)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (43.24s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

Previous Next