search

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.13k stars 3.81k forks source link

compose: TestComposeCompare failed #116150

Closed cockroach-teamcity closed 7 months ago

cockroach-teamcity commented 11 months ago

compose.TestComposeCompare failed with artifacts on master @ c10199436fe510962ea623d7e1233d71ee8c4a5e:

        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare1672557440/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:203: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |                 s"1",
        test_1        |                 string("H"),
        test_1        |             -   s"2",
        test_1        |             +   s"3",
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         1:::DECIMAL::DECIMAL AS col͟140490,
        test_1        |                         'H':::STRING::STRING AS col140491,
        test_1        |                         difference(md5('F':::STRING::STRING::STRING)::STRING::STRING, 'A':::STRING::STRING::STRING)::INT8
        test_1        |                             AS col140492
        test_1        |                 )
        test_1        |                     AS tab74075
        test_1        |             ORDER BY
        test_1        |                 col͟140490, col140491 ASC NULLS FIRST, col140492 ASC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         1::DECIMAL::DECIMAL AS col͟140490,
        test_1        |                         'H'::TEXT::TEXT AS col140491,
        test_1        |                         difference(md5('F'::TEXT::TEXT::TEXT)::TEXT::TEXT, 'A'::TEXT::TEXT::TEXT)::INT8
        test_1        |                             AS col140492
        test_1        |                 )
        test_1        |                     AS tab74075
        test_1        |             ORDER BY
        test_1        |                 col͟140490, col140491 ASC NULLS FIRST, col140492 ASC;
        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_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:125: exit status 1
--- FAIL: TestComposeCompare (907.35s)
Help

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

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-34446

cockroach-teamcity commented 11 months ago

compose.TestComposeCompare failed with artifacts on master @ d7d6901db6e322fbbb57ce2407e9e1ce42d9360c:

        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare363908829/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:203: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |                 string("0110000000000000000000"),
        test_1        |                 string("0000000000"),
        test_1        |             -   s"-0288-09-29 04:20:43.145224 +0000 UTC",
        test_1        |             +   s"0005-01-08 04:08:00 +0000 UTC",
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         COALESCE(B'0110'::BIT(22), NULL::BIT(22)) AS "col""129616",
        test_1        |                         B'0000'::BIT(10) AS "c ol129617",
        test_1        |                         make_timestamp(5:::INT8::INT4::INT4, 1:::INT8::INT4::INT4, 8:::INT8::INT4::INT4, 4:::INT8::INT4::INT4, 8:::INT8::INT4::INT4, 0.0:::FLOAT8::FLOAT8::FLOAT8)::TIMESTAMP
        test_1        |                             AS """col129618"
        test_1        |                 )
        test_1        |                     AS tab69848
        test_1        |             ORDER BY
        test_1        |                 "col""129616" ASC NULLS LAST, "c ol129617" NULLS FIRST, """col129618";
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         COALESCE(B'0110'::BIT(22), NULL::BIT(22)) AS "col""129616",
        test_1        |                         B'0000'::BIT(10) AS "c ol129617",
        test_1        |                         make_timestamp(5::INT8::INT4::INT4, 1::INT8::INT4::INT4, 8::INT8::INT4::INT4, 4::INT8::INT4::INT4, 8::INT8::INT4::INT4, 0.0::FLOAT8::FLOAT8::FLOAT8)::TIMESTAMP
        test_1        |                             AS """col129618"
        test_1        |                 )
        test_1        |                     AS tab69848
        test_1        |             ORDER BY
        test_1        |                 "col""129616" ASC NULLS LAST, "c ol129617" NULLS FIRST, """col129618";
        test_1        |             
        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:125: exit status 1
--- FAIL: TestComposeCompare (726.30s)
Help

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

Same failure on other branches

- #116303 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1-merge-v23.1.13] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 11 months ago

compose.TestComposeCompare failed with artifacts on master @ c062817fc875e192ba82f69422ffb9d9342b7f6d:

        test_1        |                             Int:              s"0",
        test_1        |             -               Exp:              0,
        test_1        |             +               Exp:              -16,
        test_1        |                             Status:           2,
        test_1        |                             NaN:              false,
        test_1        |                             InfinityModifier: s"none",
        test_1        |                         },
        test_1        |                     },
        test_1        |                     Dimensions: {{Length: 1, LowerBound: 1}},
        test_1        |                     Status:     2,
        test_1        |                 },
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (pow(0:::DECIMAL::DECIMAL::DECIMAL, 4:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || NULL::DECIMAL[]::DECIMAL[])::DECIMAL[]
        test_1        |                             AS "c%q ol31596"
        test_1        |                 )
        test_1        |                     AS tab16876
        test_1        |             ORDER BY
        test_1        |                 "c%q    ol31596" ASC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (pow(0::DECIMAL::DECIMAL::DECIMAL, 4::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || NULL::DECIMAL[]::DECIMAL[])::DECIMAL[]
        test_1        |                             AS "c%q ol31596"
        test_1        |                 )
        test_1        |                     AS tab16876
        test_1        |             ORDER BY
        test_1        |                 "c%q    ol31596" ASC;
        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_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:125: exit status 1
--- FAIL: TestComposeCompare (663.00s)
Help

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

Same failure on other branches

- #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 11 months ago

compose.TestComposeCompare failed with artifacts on master @ 01c28b7dbc3177361e302525703fb73bd0d6fc8b:

        postgres_1    | 2023-12-18 06:21:11.019 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2023-12-18 06:21:11.021 UTC [51] LOG:  shutting down
        postgres_1    | 2023-12-18 06:21:11.120 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    | 2023-12-18 06:21:11.238 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-12-18 06:21:11.238 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2023-12-18 06:21:11.238 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2023-12-18 06:21:11.241 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2023-12-18 06:21:11.247 UTC [68] LOG:  database system was shut down at 2023-12-18 06:21:11 UTC
        postgres_1    | 2023-12-18 06:21:11.252 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-12-18 06:21:12.746 UTC [78] ERROR:  invalid input syntax for type numeric: "-Infinity" at character 393
        postgres_1    | 2023-12-18 06:21:12.746 UTC [78] STATEMENT:  CREATE TABLE table2 (col2_0 TEXT NOT NULL, col2_1 "char" NULL, col2_2 REGCLASS NOT NULL, col2_3 DATE NOT NULL, "col2_ 4" DECIMAL, "col2_)5" FLOAT8 NOT NULL, col2_6 REGROLE, col2_7 INT2 NOT NULL, col2_8 OID NULL, PRIMARY KEY (col2_2, col2_0));
        postgres_1    |     CREATE UNIQUE INDEX ON table2 (col2_3, col2_2, col2_7 ASC) INCLUDE (col2_1, "col2_)5", col2_6, col2_8);
        postgres_1    |     CREATE INDEX ON table2 (col2_1, ("col2_ 4" + '-Infinity'::DECIMAL)) INCLUDE ("col2_ 4", "col2_)5", col2_6, col2_7, col2_8);
        postgres_1    |     CREATE UNIQUE INDEX ON table2 (col2_3 DESC);
        postgres_1    |     CREATE UNIQUE INDEX ON table2 (col2_1);
        postgres_1    |     CREATE UNIQUE INDEX ON table2 (col2_8 ASC, col2_3 ASC) INCLUDE (col2_1);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (606.02s)
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     --- FAIL: TestCompare/postgres (0.93s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:172: CREATE TABLE table2 (col2_0 TEXT NOT NULL, col2_1 "char" NULL, col2_2 REGCLASS NOT NULL, col2_3 DATE NOT NULL, "col2_ 4" DECIMAL, "col2_)5" FLOAT8 NOT NULL, col2_6 REGROLE, col2_7 INT2 NOT NULL, col2_8 OID NULL, PRIMARY KEY (col2_2, col2_0));
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_3, col2_2, col2_7 ASC) INCLUDE (col2_1, "col2_)5", col2_6, col2_8);
        test_1        |             CREATE INDEX ON table2 (col2_1, ("col2_ 4" + '-Infinity'::DECIMAL)) INCLUDE ("col2_ 4", "col2_)5", col2_6, col2_7, col2_8);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_3 DESC);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_1);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_8 ASC, col2_3 ASC) INCLUDE (col2_1);
        test_1        |             
        test_1        |         compare_test.go:173: postgres: exec: ERROR: invalid input syntax for type numeric: "-Infinity" (SQLSTATE 22P02)
        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:125: exit status 1
--- FAIL: TestComposeCompare (630.41s)
Help

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

Same failure on other branches

- #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 11 months ago

compose.TestComposeCompare failed with artifacts on master @ 5f76d93b2ad8d29c14c9b176753ec33cbf81e3fe:

        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.00s)
        test_1        |         compare_test.go:141: 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 112 [running]:
        test_1        | testing.tRunner.func1.2({0x229a4e0, 0xc000e9e4c0})
        test_1        |     GOROOT/src/testing/testing.go:1545 +0x238
        test_1        | testing.tRunner.func1()
        test_1        |     GOROOT/src/testing/testing.go:1548 +0x397
        test_1        | panic({0x229a4e0?, 0xc000e9e4c0?})
        test_1        |     GOROOT/src/runtime/panic.go:914 +0x21f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x47708c0?, {0x3286338?, 0xc000e77080?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:377 +0x436
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x3244920?, 0x47708c0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:310 +0x12c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc000d66a80)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:227 +0x7f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc000d186c0, {0xc000d1f220?, 0x5, 0xc000d186c0?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:260 +0x89d
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0x2099520?, 0x249fea2?, {0xc000d1f220?, 0x4aa4ec8?, 0x2?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:98 +0x28
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0xc0004ef7c0?, {0x249fea2, 0x5}, 0x5, 0x20?, {0xc000cd7a40, 0x3, 0x7f28029053c8?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/schema.go:93 +0x131
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTablesN(0xc000aefcc8?, 0x1?, {0x0, 0x0})
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:118 +0x15e
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc0000faa00?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:98 +0x2f
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.init.wrapCommonSetup.func28(0x26c26e8?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:51 +0x1b
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc000d1a340)
        test_1        |     github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:143 +0xe2
        test_1        | testing.tRunner(0xc000d1a340, 0xc000d18630)
        test_1        |     GOROOT/src/testing/testing.go:1595 +0xff
        test_1        | created by testing.(*T).Run in goroutine 22
        test_1        |     GOROOT/src/testing/testing.go:1648 +0x3ad
        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:125: exit status 2
--- FAIL: TestComposeCompare (19.69s)
Help

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

Same failure on other branches

- #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 11 months ago

compose.TestComposeCompare failed with artifacts on master @ 097880977a1f5bfb8377afd2a407cdf7ca4fe377:

        postgres_1    | 2023-12-20 06:20:29.703 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-12-20 06:20:29.703 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2023-12-20 06:20:29.703 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2023-12-20 06:20:29.706 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2023-12-20 06:20:29.711 UTC [68] LOG:  database system was shut down at 2023-12-20 06:20:29 UTC
        postgres_1    | 2023-12-20 06:20:29.716 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-12-20 06:20:30.932 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2023-12-20 06:20:30.932 UTC [78] STATEMENT:  CREATE TABLE table3 ("col3\\x20_0" DATE NOT NULL, "col\v3_1" TIMESTAMP NOT NULL, "c ol3_2" OID, col3_3 BIT(19) NOT NULL, col3_̈4 REGROLE, "co%74l3_5" TIMESTAMPTZ NOT NULL, col3_6 INET NOT NULL, "-col3_*'7" TEXT NOT NULL, col3_😃8 CHAR, "col3_ %v9" REGTYPE NULL, col3_10 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col3\\x20_0" IS NULL THEN 'wB'::TEXT ELSE e'\x18Mf_'::TEXT END) STORED, PRIMARY KEY ("-col3_*'7"));
        postgres_1    |     CREATE UNIQUE INDEX ON table3 (col3_̈4 ASC, "co%74l3_5" DESC);
        postgres_1    |     CREATE UNIQUE INDEX ON table3 ("c ol3_2" ASC, "col3\\x20_0");
        postgres_1    |     CREATE UNIQUE INDEX ON table3 ("co%74l3_5", col3_3 ASC);
        postgres_1    |     CREATE UNIQUE INDEX ON table3 (col3_6 DESC, lower(CAST("c ol3_2" AS TEXT)), (CASE WHEN col3_̈4 IS NULL THEN e'\x00'::TEXT ELSE e'\x00'::TEXT END) ASC);
        postgres_1    |     CREATE INDEX ON table3 ((CASE WHEN "co%74l3_5" IS NULL THEN e'\x04:e\x16\x06'::TEXT ELSE ''::TEXT END), col3_̈4 DESC);
        postgres_1    |     CREATE UNIQUE INDEX ON table3 ("col\v3_1", col3_3 ASC, "co%74l3_5" ASC) INCLUDE ("col3\\x20_0", "c ol3_2", col3_̈4);
        postgres_1    |     CREATE UNIQUE INDEX ON table3 (lower(CAST("c ol3_2" AS TEXT)) DESC);
        postgres_1    |     CREATE UNIQUE INDEX ON table3 (col3_̈4 DESC) INCLUDE (col3_3, "co%74l3_5");
        postgres_1    |     CREATE INDEX ON table3 (col3_3 ASC) INCLUDE ("col\v3_1", "c ol3_2", col3_̈4, "co%74l3_5", "col3_ %v9");
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (605.72s)
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (1.14s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:172: CREATE TABLE table3 ("col3\\x20_0" DATE NOT NULL, "col\v3_1" TIMESTAMP NOT NULL, "c ol3_2" OID, col3_3 BIT(19) NOT NULL, col3_̈4 REGROLE, "co%74l3_5" TIMESTAMPTZ NOT NULL, col3_6 INET NOT NULL, "-col3_*'7" TEXT NOT NULL, col3_😃8 CHAR, "col3_ %v9" REGTYPE NULL, col3_10 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col3\\x20_0" IS NULL THEN 'wB'::TEXT ELSE e'\x18Mf_'::TEXT END) STORED, PRIMARY KEY ("-col3_*'7"));
        test_1        |             CREATE UNIQUE INDEX ON table3 (col3_̈4 ASC, "co%74l3_5" DESC);
        test_1        |             CREATE UNIQUE INDEX ON table3 ("c ol3_2" ASC, "col3\\x20_0");
        test_1        |             CREATE UNIQUE INDEX ON table3 ("co%74l3_5", col3_3 ASC);
        test_1        |             CREATE UNIQUE INDEX ON table3 (col3_6 DESC, lower(CAST("c ol3_2" AS TEXT)), (CASE WHEN col3_̈4 IS NULL THEN e'\x00'::TEXT ELSE e'\x00'::TEXT END) ASC);
        test_1        |             CREATE INDEX ON table3 ((CASE WHEN "co%74l3_5" IS NULL THEN e'\x04:e\x16\x06'::TEXT ELSE ''::TEXT END), col3_̈4 DESC);
        test_1        |             CREATE UNIQUE INDEX ON table3 ("col\v3_1", col3_3 ASC, "co%74l3_5" ASC) INCLUDE ("col3\\x20_0", "c ol3_2", col3_̈4);
        test_1        |             CREATE UNIQUE INDEX ON table3 (lower(CAST("c ol3_2" AS TEXT)) DESC);
        test_1        |             CREATE UNIQUE INDEX ON table3 (col3_̈4 DESC) INCLUDE (col3_3, "co%74l3_5");
        test_1        |             CREATE INDEX ON table3 (col3_3 ASC) INCLUDE ("col\v3_1", "c ol3_2", col3_̈4, "co%74l3_5", "col3_ %v9");
        test_1        |             
        test_1        |         compare_test.go:173: 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:125: exit status 1
--- FAIL: TestComposeCompare (630.61s)
Help

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

Same failure on other branches

- #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 11 months ago

compose.TestComposeCompare failed with artifacts on master @ ff291e3ee70eedac50b985860502d2f0b0867003:

        test_1        |                                             (
        test_1        |                                                 '{"11T": "NCViqDdS", "1jjH": {"b": null, "foobar": 0.08567440783095134}, "3xRBk": {"5WNw": null, "CkizuYr": 0.45340669898522473, "gIk": 1.2272672663973108}, "c": true, "c7Ppus": 0.24786061940844883}':::JSONB
        test_1        |                                             ),
        test_1        |                                             ('{"b": false, "foobar": [null], "nlSdBfLF": false}':::JSONB)
        test_1        |                                     )
        test_1        |                                         AS tab116769 (col190635)
        test_1        |                                 EXCEPT ALL
        test_1        |                                     SELECT
        test_1        |                                         *
        test_1        |                                     FROM
        test_1        |                                         (
        test_1        |                                             VALUES
        test_1        |                                                 (
        test_1        |                                                     '[[null], {"FsBV6CNzl": true, "xMNrCKov": "bar"}, 2.436960780889299, {"W5t7": null}, [false], "foobar"]':::JSONB
        test_1        |                                                 )
        test_1        |                                         )
        test_1        |                                             AS tab116770 (col190636)
        test_1        |                             ),
        test_1        |                         with31187 ("\\U0001762Bcol190637")
        test_1        |                             AS (
        test_1        |                                 SELECT
        test_1        |                                     "'cte_ref8994".col190635 AS "\\U0001762Bcol190637"
        test_1        |                                 FROM
        test_1        |                                     with31186 AS "'cte_ref8994", with31186 AS "cte_r\fef8995", with31186 AS "cte_r\gef8996"
        test_1        |                             )
        test_1        |                     SELECT
        test_1        |                         cte_ref8997."\\U0001762Bcol190637" AS col190638,
        test_1        |                         NULL AS col190639,
        test_1        |                         cte_ref8997."\\U0001762Bcol190637" AS col190640
        test_1        |                     FROM
        test_1        |                         with31187 AS cte_ref8997, with31187 AS "cte_ref%q8998", with31187 AS cte_ref8999
        test_1        |                     WHERE
        test_1        |                         true
        test_1        |                 )
        test_1        |                     AS """tab116771"
        test_1        |             ORDER BY
        test_1        |                 col190638 ASC, col190639 NULLS FIRST, col190640
        test_1        |         compare_test.go:213: cockroach1: ping: conn closed
        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:125: exit status 1
--- FAIL: TestComposeCompare (870.49s)
Help

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

Same failure on other branches

- #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 11 months ago

compose.TestComposeCompare failed with artifacts on master @ d2d974202781321ddb4fb1115c68fe7566ab9d06:

Fatal error:

panic: test timed out after 29m57s
running tests:
    TestComposeCompare (29m57s)

Stack: 

goroutine 9 [running]:
testing.(*M).startAlarm.func1()
    GOROOT/src/testing/testing.go:2259 +0x3b9
created by time.goFunc
    GOROOT/src/time/sleep.go:176 +0x2d
Log preceding fatal error

``` === RUN TestComposeCompare ```

Help

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

Same failure on other branches

- #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ 53e4efd389167110d687e5dea8bf915fe2582a25:

        postgres_1    |                 tab143453."c""
        postgres_1    |     ol2_0",
        postgres_1    |                 tab143453.tableoid DESC,
        postgres_1    |                 tab143453.col2_10 DESC NULLS LAST,
        postgres_1    |                 tab143453."col'2_6" ASC
        postgres_1    |         )
        postgres_1    |             AS "ta{b143454"
        postgres_1    |     ORDER BY
        postgres_1    |         col234794 ASC NULLS FIRST,
        postgres_1    |         còl234795 ASC,
        postgres_1    |         "col 234796" ASC NULLS LAST,
        postgres_1    |         col234797 DESC NULLS LAST,
        postgres_1    |         coͅl234798 ASC NULLS FIRST,
        postgres_1    |         col234799 DESC NULLS FIRST,
        postgres_1    |         col234800 ASC NULLS LAST,
        postgres_1    |         "col'234801" NULLS FIRST,
        postgres_1    |         "Col234802" ASC NULLS LAST
        test_1        | --- FAIL: TestCompare (1356.47s)
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (749.96s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:212: SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         '{"C": "D", "D": {"B": {"C": {"A": false, "H": {"B": {"B": {"E": 9}, "D": null, "E": true}, "I": true}}}, "I": {"C": [null, "E", {"F": {"A": [null, null], "D": true, "F": {"H": [[{"J": 8}, "E"]], "I": [{"I": {"F": {"G": {"A": {"B": false, "E": "A"}, "B": {"G": "E", "H": {"F": {"A": {"H": "E", "I": false}, "C": {"D": {"J": {"F": {"D": null, "G": false, "J": {"D": {"C": null, "D": {"D": true, "J": {"F": {"A": {"G": [{"H": [{"A": [{"I": null}, {"E": true}]}]}, "A", [{"A": {"C": [{"D": true, "E": [{"C": null, "E": ["J", {"A": [true, "F"], "B": 0}, "G"], "F": {"D": {"F": 7, "H": [{"A": false}, {"G": {"B": false, "G": null, "J": "C"}, "I": [null, {"B": {"D": {"B": null, "C": {"G": {"D": {"E": 9, "G": [{"H": [{"A": {"I": true}, "B": null, "F": {"B": false, "D": 8}}]}, true], "I": false}, "H": {"G": "J"}, "I": [{"A": true}, {"A": [{"B": {"E": "D", "G": {"B": true, "H": true, "I": false}, "H": {"B": {"H": {"F": "D", "H": [6, {"C": true, "E": {"A": true, "C": "I", "J": {"A": "F", "D": null}}}]}}, "E": false, "F": {"A": {"A": false, "F": null, "H": "I"}, "E": null, "I": {"J": 8}}}}, "D": [{"B": "H"}, [{"A": {"B": null, "E": null}, "H": false}], {"E": {"E": "J", "H": null}, "G": null, "I": [{"H": {"G": [[{"D": {"D": 4, "E": "D", "I": 0}, "J": {"I": false}}, {"F": null}], {"H": "C", "I": true}], "J": {"C": "G", "E": 4, "J": {"C": {"B": null, "F": {"G": true, "I": 5}, "H": {"D": {"F": 2, "I": true}, "E": {"A": {"C": {"F": {"G": {"C": false, "F": {"E": {"E": null}}}}, "G": null}, "I": {"F": {"E": [[[{"B": 4, "D": {"C": false, "E": {"A": {"J": false}, "E": {"B": [{"G": [[{"D": "B", "E": {"D": [[null]], "E": [{"A": null, "H": false}], "H": {"C": {"A": {"D": false}, "H": "C"}, "F": {"A": {"A": "I"}, "C": false, "D": false}}}}, 8]], "J": {"I": 6}}], "G": {"D": 7, "E": {"E": [null], "F": false}, "G": "D"}, "H": "C"}, "I": false}, "G": true}, "J": null}, true], {"A": null, "B": {"J": 7}, "G": false}, false], {"A": null, "H": {"A": {"G": true}, "C": {"B": true, "D": 7}}}, {"E": 4}], "G": {"C": false, "D": {"A": [true, "H"], "C": 4, "E": null}, "F": {"B": "F", "C": {"F": {"J": {"B": {"A": {"A": {"B": false, "H": {"D": null, "E": 1, "G": {"E": true, "H": false}}}}, "B": {"D": [{"A": true, "B": {"D": {"G": "B", "H": {"C": {"E": {"B": false, "E": true}, "H": "H", "J": {"C": 8, "G": {"D": {"A": {"C": null, "G": null}}, "H": false}, "J": {"D": [{"I": {"F": {"D": "I", "G": {"E": {"H": null}, "G": true}}, "G": null, "H": null}}, 5]}}}, "D": true}}}, "C": false}], "E": true, "J": false}, "J": null}, "F": 3, "G": [{"B": [null, {"A": [[["D", false, 7], [0, {"D": {"C": {"C": {"C": 6, "F": {"A": {"F": true, "G": [[6, {"C": null, "E": false, "G": [[null], null, {"C": 8}]}, {"J": 7}], {"C": false, "H": {"D": false}}]}, "G": {"C": {"F": 7, "H": {"C": [false]}}}}}, "E": true, "G": 9}, "F": {"A": "A", "B": null}}}]], "H"], "C": [false, {"E": [null, true]}]}], "G": false}, {"B": "F", "C": true, "D": false}]}}}}}}, "H": {"F": {"D": false}, "G": false}}}}}}}}}, "I": null, "J": {"B": "E", "E": 1, "H": false}}, null, {"H": {"J": {"A": {"C": 7}, "D": {"F": null, "H": [true, 8, null], "I": null}, "J": {"B": {"G": {"B": 2, "C": false}, "H": "G", "I": {"F": false}}, "G": [null, {"J": "D"}, {"A": {"G": null, "H": false, "I": {"E": true, "H": {"E": true}}}, "G": {"C": {"B": {"A": {"H": 2, "I": [{"A": [true], "F": [false, "C", "C"]}, {"E": {"E": true, "F": {"B": {"D": {"D": {"E": true}, "E": 9, "H": "D"}, "G": "J"}, "I": "E"}}}], "J": 0}, "I": 0}, "D": {"F": {"B": {"G": true}, "H": null, "I": null}, "I": false}, "F": [{"B": null, "C": {"G": {"D": 4, "F": true, "H": "J"}, "I": {"A": {"D": "F", "I": {"C": false, "E": null}}, "I": [false]}, "J": [{"B": null, "F": true}]}}, false]}, "H": [["G", true], [[null, "G"], false, false]]}, "I": false}]}}}, "I": 7}]}]}], "E": null}, false]}}}, "F": false, "J": false}, "I": {"F": [{"E": {"D": {"F": {"G": {"F": [{"D": 5, "J": false}, "E", false]}}, "H": true}, "H": null}, "H": "A"}, null, {"D": false, "I": [{"B": {"A": {"B": true}, "B": false, "E": false}, "H": {"B": false}, "I": {"C": false, "I": null}}], "J": ["A", {"G": {"H": {"B": {"C": null, "E": 2}, "D": {"G": 7}}}, "I": null, "J": {"B": "J", "E": {"F": null, "I": 1}}}, null]}], "H": [{"B": [{"D": {"G": 2}, "H": [false], "I": "E"}], "C": {"G": true}}]}}, {"F": {"H": "D"}}]}, {"E": false}], "J": null}}}, [{"B": true, "D": true, "I": "H"}, 4, {"E": "J", "I": false}]]}, "C"], "E": false, "I": 7}, "F": null, "J": "D"}, true]], "I": {"I": {"I": [{"E": [{"D": {"C": [{"D": "D", "I": {"G": false, "I": [null, {"D": {"F": false}, "G": "D"}, false], "J": "H"}}, true], "I": {"E": {"H": [true]}}}, "E": [[{"B": {"A": true, "I": {"D": true}}, "D": {"E": {"J": 0}, "G": false}}, {"G": false}, "I"], {"A": {"J": 8}}, "A"], "I": {"F": {"G": "H", "J": "F"}, "G": {"H": 6}, "H": {"E": {"F": {"A": [{"A": {"C": {"A": true, "C": true, "I": {"E": {"F": false}, "J": {"A": [true], "G": false}}}, "D": 5}, "D": "I"}, [{"J": true}], {"E": {"F": {"C": true, "E": false, "H": false}}}], "D": false, "H": {"E": {"A": {"B": 8, "C": [{"D": "D", "F": true, "G": [null, {"E": {"A": {"E": null}, "H": null, "J": {"C": {"C": true}, "D": false, "F": {"E": null}}}, "G": {"D": ["D", {"A": null, "C": {"H": [[{"E": ["H"], "G": {"D": false, "H": true}}, {"J": {"J": null}}], {"C": false}]}}], "F": {"H": null, "I": {"G": [{"D": {"C": false, "I": {"F": true}}}, {"D": {"A": {"A": {"G": false}, "C": false, "G": 0}, "C": "J", "D": 1}, "H": {"B": false}}]}, "J": {"E": true}}}, "I": [false, {"H": {"B": {"E": {"H": [{"B": 9}, {"F": true, "J": {"I": {"B": [{"A": true, "E": {"D": "C", "G": false}}, [{"F": false, "J": false}]], "F": "H"}}}, 1], "I": true}, "F": {"A": null}, "G": {"E": "A"}}}}]}, [{"B": null, "C": false, "D": {"B": true, "C": false, "G": {"H": false}}}, 1, {"A": true, "B": {"F": {"F": {"D": [{"I": {"B": "G", "C": "H"}}, false], "F": null}, "I": {"E": [{"B": true, "E": null}, null], "G": {"C": [{"B": "A"}, [6, [[{"E": {"E": "I"}, "G": {"G": 0, "J": null}, "H": {"I": {"B": false}, "J": 5}}, {"A": 4}, 3], {"G": [false, {"E": [{"B": 9, "C": 9, "G": [false, {"G": 7}]}, {"A": {"I": {"G": "D", "I": {"I": true}}}, "D": null, "F": [{"G": {"C": null}}, {"B": {"F": {"E": true}}, "I": {"B": [[8, [[6, "D"], {"E": 6, "H": false, "I": [true]}]]], "C": false, "E": 8}}]}, false], "J": {"B": false, "C": "G", "F": {"A": {"A": {"I": {"D": true, "G": "A", "H": "H"}}, "F": {"C": {"A": {"F": "J", "J": {"A": {"A": [false, {"A": false, "H": 9, "I": {"A": "G", "B": {"H": {"B": null, "E": false, "H": [false]}, "I": null}, "J": {"E": true, "J": 0}}}], "C": [true, {"D": null, "G": 0, "I": false}, [false, null]], "F": [{"D": {"A": true, "J": {"F": {"F": false}}}, "I": true}]}, "B": {"D": {"A": {"J": "C"}, "C": "I", "G": null}}, "I": false}}, "H": null}}, "H": {"A": [{"F": {"H": null, "I": ["F"]}, "I": null}, {"F": "H"}], "I": {"C": null, "H": {"G": "C"}, "I": null}}}, "C": [[{"E": true}, [3, [false, "C", {"H": true, "I": {"A": false, "B": {"C": {"D": true, "F": "E"}}}, "J": true}], [true, true, {"A": {"A": {"G": [9, [{"H": "J"}]], "I": false}, "E": 2}, "B": [{"A": false, "B": {"J": {"H": "C"}}, "H": null}], "G": null}]]], {"C": false, "E": {"E": {"A": null, "I": null}, "J": {"B": {"A": [8, false]}, "E": {"G": {"A": [false, {"E": {"B": {"I": 5}, "D": [{"A": true, "B": true}]}}], "E": {"B": false}, "J": [[{"A": {"J": false}, "F": 2, "I": "C"}]]}, "J": {"E": false, "F": 0}}, "J": {"I": "E", "J": {"B": {"H": [{"C": [{"D": true}, null], "E": [{"E": true, "F": false}, {"B": {"B": true, "F": {"B": 7}, "H": [[{"A": {"A": {"F": true, "H": {"I": {"A": {"C": false}, "D": null, "J": 3}}, "J": {"H": true}}, "B": {"D": {"A": "H"}, "J": {"D": {"C": [null, {"B": [{"J": [null, "G", {"F": "F", "J": false}]}, {"F": false, "J": false}], "F": {"E": {"F": 8, "I": {"F": 5, "I": [false, {"A": false, "D": {"C": 7, "F": {"B": {"E": {"H": null}, "G": {"D": {"H": null}, "F": false}, "J": false}, "E": [true], "H": {"H": false, "J": 1}}}, "I": "C"}]}}}, "J": "G"}, null], "G": {"A": false, "G": {"F": null}}}}}, "G": false}, "H": {"A": 5, "G": false, "J": {"F": [{"C": {"E": {"H": true, "J": null}}}]}}}, {"A": true}, false], 4]}}]}, [false, null, [null, {"H": {"E": "H", "F": true, "H": [{"B": "A", "F": {"I": {"A": {"B": true}, "B": {"E": false, "I": true}, "J": "H"}, "J": null}}, true, [4, {"H": 6, "J": {"I": [{"B": {"B": null, "H": false}, "D": {"E": false}}, {"D": true}]}}]]}, "J": {"D": {"C": null, "G": 6}, "I": {"B": 7, "C": null}}}, 7]], [5, ["D", {"D": null}, {"A": false, "I": null}]]]}, "G": {"A": "C", "G": {"F": [{"C": false, "H": {"B": {"H": {"G": {"B": {"J": {"D": 3}}, "F": "I"}}}, "C": false, "I": {"B": 8, "F": {"F": 8}, "J": [null]}}}]}}}}}}}], "E": {"D": false, "I": false}}}}, {"D": {"I": {"B": 3}}, "H": [false], "I": false}], "I": {"C": true, "H": true}}, 0], {"E": false}], {"G": true, "H": true}], "D": [true, {"G": {"G": {"C": {"A": false, "E": null}}}}, null]}}}, "I": 0}}]]}, [false, {"A": {"B": {"A": false}, "D": false, "J": true}, "E": {"F": {"C": "F", "F": [{"B": true, "E": false, "H": null}]}, "H": [{"A": {"B": 6, "C": false, "F": {"F": null}}}]}, "G": false}]]}, "F": {"I": {"C": true, "D": {"A": {"A": "D", "C": false, "J": {"H": {"B": true, "F": {"A": "C", "B": "E", "G": {"B": {"B": {"A": {"F": {"C": {"F": ["A", {"D": {"C": false, "D": {"F": {"A": "C", "G": "J"}}, "J": ["A"]}, "J": "J"}], "G": 8}, "E": 4, "G": {"I": false}}, "J": true}, "B": {"D": [{"J": null}]}, "J": {"D": {"G": true, "H": [{"C": {"A": {"H": {"C": {"B": {"A": "A"}, "E": {"B": 0, "I": {"B": {"A": 0, "G": [false]}, "F": 1}, "J": 3}}, "G": {"D": {"F": false}, "E": {"B": {"C": 3, "I": {"A": {"G": {"A": [{"D": "J", "H": {"B": null, "G": {"A": null, "F": 4}}}, {"D": {"C": null}, "J": {"C": true, "I": true}}, false], "G": {"D": true, "H": {"E": 3}, "J": {"I": false}}, "H": null}, "H": false, "I": null}, "C": true, "G": null}}, "C": true}}}}, "E": "F"}}]}, "E": {"B": {"G": "C"}, "J": 0}, "H": 8}}}, "D": 9}}, "G": {"B": {"G": {"A": [false, false, {"C": false}], "D": {"C": {"E": null, "H": false, "I": 9}, "D": null}, "I": null}}, "F": true, "J": [[null, "I"], false]}}, "J": "J"}}, "E": {"F": {"C": null, "D": null}}}}}}, "J": {"E": {"A": {"B": {"B": null, "F": {"B": "B", "J": {"C": {"J": {"D": null, "J": false}}, "F": {"F": {"A": [{"C": {"G": [{"B": [null, true, null], "I": 3}, {"A": {"B": "J", "D": 9, "E": null}, "J": true}, false], "J": null}, "E": {"F": null}, "F": true}], "C": {"B": {"B": "A", "F": "I", "J": {"C": null, "I": true, "J": {"E": true, "J": "G"}}}, "H": 9, "J": {"A": true, "C": {"H": false}, "F": 5}}, "I": null}}}}, "H": "B"}, "I": {"C": {"G": null, "I": {"E": {"E": {"A": true, "E": 6}, "G": {"A": "H", "D": [[{"A": {"E": [{"A": {"G": {"A": "I"}}, "H": {"B": {"B": [[null], {"G": "G"}, {"D": {"A": {"A": {"E": {"B": null}}, "H": true}, "C": {"D": {"G": false}, "G": "A"}, "E": {"B": 1, "D": [{"E": "B"}, {"C": false, "D": [{"F": true, "G": {"A": {"G": 9}}}], "F": {"F": {"H": false}}}], "G": 0}}, "F": [null, {"E": "J", "G": 6}], "G": true}], "C": 3, "F": [[true, {"E": true}, true]]}, "H": [{"H": {"E": false, "J": 0}}, {"B": {"B": {"D": "E", "F": null}, "C": false, "F": true}, "J": 3}], "I": {"I": null}}, "I": {"F": false}}, {"D": {"J": true}, "F": [{"C": "J", "F": true}, false], "G": {"D": {"A": {"A": [{"D": {"A": null, "H": true, "J": {"D": false, "I": true}}, "J": {"A": "B", "C": "A"}}, "H"], "C": null, "H": 6}, "B": false, "G": false}, "H": null}}, {"J": null}], "F": false}, "G": {"B": {"A": false, "G": {"I": [3]}}, "E": true, "J": false}}, false, 5], 9, null]}, "J": false}}}, "I": [8], "J": 2}, "J": false}, "I": [{"F": [{"A": 5, "I": "A"}, 5]}]}}}}}, "F": null, "H": {"F": [6], "H": 1, "J": {"A": [{"D": {"E": {"B": false, "H": 9}}, "J": true}, {"E": {"E": null}, "G": {"A": 7, "I": 0}, "J": null}, true], "G": "A"}}}}}], "H": false, "J": [5]}]}}}}}}}, "G": 0, "J": "F"}}}}, "G": {"F": true, "G": "E"}}}, "I": true}}}, "I": {"C": [{"B": null, "D": [{"D": true, "E": false}, true, [{"D": "F", "J": {"D": {"J": {"D": false, "G": {"A": {"E": 4, "H": {"I": false, "J": 9}, "J": true}, "E": "F"}}}, "E": {"A": [[6, {"B": 4}], true, 0], "D": false}}}]]}]}}, "H": {"D": {"B": {"B": {"A": null, "I": 1, "J": 4}, "C": {"E": {"B": false, "I": {"B": [{"F": {"D": {"A": {"E": [{"F": null, "H": false}, false], "J": true}, "C": {"C": true, "E": false}, "H": {"B": 5, "G": [true]}}, "F": {"A": {"D": true}, "G": "I"}, "H": false}}]}}}, "I": {"C": 5}}, "E": {"B": false}, "H": [{"E": {"E": {"H": null}, "G": ["H", "H", {"A": [null], "G": true, "J": true}], "I": false}, "H": true}, {"E": {"D": false, "J": false}, "H": true, "I": 6}]}}, "I": false}}, "I"], "J": 4}}, "H": {"A": "A", "G": [[false, "H", {"D": {"B": {"C": null, "G": true, "I": 1}, "F": "I", "G": {"A": "A", "C": true}}, "H": false, "I": [["G"], false, {"B": 0, "F": {"A": "C", "G": {"C": {"D": {"H": null, "I": false}, "E": {"I": {"B": [{"A": null, "F": {"B": {"B": [4, {"H": {"D": ["F", null, true], "G": "G", "H": "A"}}, {"J": true}]}, "G": true}, "H": "G"}], "G": {"I": 8}}}}, "D": {"C": {"D": {"B": {"G": {"C": {"C": {"B": {"D": false, "E": false}}}, "I": [{"D": true, "I": false}, null], "J": "A"}}, "D": "I", "J": {"C": null}}, "J": {"I": {"A": [null, false], "B": null, "I": 7}}}, "F": 8, "J": {"A": {"H": 5}}}}}}]}]], "J": {"C": {"C": [[false, {"D": true}], {"E": {"G": true}, "J": {"B": [{"J": true}, true, {"E": null, "F": "H", "G": [{"H": {"A": [true, 1], "J": true}, "I": {"D": {"G": [false, {"C": {"A": {"H": false, "J": [2, true, null]}, "D": "J", "J": {"E": {"B": {"A": null, "G": {"F": {"E": {"G": null, "I": {"A": 0, "B": null, "H": {"A": [{"F": [false, false, 7]}]}}}}}}}, "I": {"D": {"D": "H", "I": [{"H": false}]}, "H": {"E": {"F": true}, "J": null}, "J": "J"}}}, "H": {"G": {"D": [{"C": null, "D": "A"}, {"G": "A"}, 9], "F": false}}}, {"C": false, "F": false}], "H": {"H": 7}}}}, {"C": null, "E": null}, {"C": {"B": true, "J": {"C": "A", "H": {"C": {"A": [{"D": {"C": "I", "F": true, "I": {"A": {"I": {"G": [{"A": {"C": null, "G": true}, "H": {"F": "I"}}, true, {"A": null, "C": {"D": {"B": 8}, "G": [2, true]}}]}}, "H": [false, true], "I": 5}}, "G": true}, false, false], "B": {"I": {"C": "H"}}, "J": {"G": "F", "H": {"G": false}}}, "G": null, "I": {"E": true}}}}, "I": {"D": true}}]}]}}], "E": [null, "F"]}}}, "I": 0}], "G": true, "H": null}}, "H": {"D": {"B": 7, "E": {"B": true, "J": {"D": true}}, "J": {"G": true}}, "J": false}}':::JSONB::JSONB
        test_1        |                             AS "c ol%q234803",
        test_1        |                         COALESCE('I':::STRING::"char", 'H':::STRING::"char") AS col234804
        test_1        |                 )
        test_1        |                     AS tab143455
        test_1        |             ORDER BY
        test_1        |                 "c ol%q234803" DESC NULLS LAST, col234804 DESC
        test_1        |         compare_test.go:213: postgres: ping: conn closed
        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:125: exit status 1
--- FAIL: TestComposeCompare (1382.68s)
Help

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

Same failure on other branches

- #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ 57bd0a92676b1c58ee7e29979ce3dceb5837abdb:

        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (72.98s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare2825224787/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:203: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   s"-0289-04-29 00:18:43.145224 +0000 UTC",
        test_1        |             +   s"0003-08-08 00:06:00 +0000 UTC",
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         make_timestamp(3:::INT8::INT4::INT4, 8:::INT8::INT4::INT4, 8:::INT8::INT4::INT4, 0:::INT8::INT4::INT4, int4(6:::INT8::INT4::INT4)::INT4::INT4, 0.0:::FLOAT8::FLOAT8::FLOAT8)::TIMESTAMP
        test_1        |                             AS col95357
        test_1        |                 )
        test_1        |                     AS "ta%q😔b59094"
        test_1        |             ORDER BY
        test_1        |                 col95357 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         make_timestamp(3::INT8::INT4::INT4, 8::INT8::INT4::INT4, 8::INT8::INT4::INT4, 0::INT8::INT4::INT4, int4(6::INT8::INT4::INT4)::INT4::INT4, 0.0::FLOAT8::FLOAT8::FLOAT8)::TIMESTAMP
        test_1        |                             AS col95357
        test_1        |                 )
        test_1        |                     AS "ta%q😔b59094"
        test_1        |             ORDER BY
        test_1        |                 col95357 NULLS FIRST;
        test_1        |             
        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:125: exit status 1
--- FAIL: TestComposeCompare (701.14s)
Help

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

Same failure on other branches

- #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ c316d6a615fa02a05357a20bf03b8a197ab27810:

        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.01s)
        test_1        |         compare_test.go:141: 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 915117 [running]:
        test_1        | testing.tRunner.func1.2({0x229df00, 0xc000f58620})
        test_1        |     GOROOT/src/testing/testing.go:1545 +0x238
        test_1        | testing.tRunner.func1()
        test_1        |     GOROOT/src/testing/testing.go:1548 +0x397
        test_1        | panic({0x229df00?, 0xc000f58620?})
        test_1        |     GOROOT/src/runtime/panic.go:914 +0x21f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x47768a0?, {0x328ab18?, 0xc0012651a0?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:377 +0x436
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x3248f40?, 0x47768a0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:310 +0x12c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc001cf6f00)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:227 +0x7f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc002a99b00, {0xc000f4b0e0?, 0x5, 0xc002a99b00?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:260 +0x89d
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0x209cf80?, 0x24a3ea2?, {0xc000f4b0e0?, 0x4aaaee8?, 0x2?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:98 +0x28
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0xc000b07660?, {0x24a3ea2, 0x5}, 0x5, 0x80?, {0xc00204ba40, 0x3, 0x7ff1ba416d28?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/schema.go:93 +0x131
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTablesN(0xc00252ccc8?, 0x1?, {0x0, 0x0})
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:118 +0x15e
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc002351500?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:98 +0x2f
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.init.wrapCommonSetup.func28(0x26c6940?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:51 +0x1b
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc000eefa00)
        test_1        |     github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:143 +0xe2
        test_1        | testing.tRunner(0xc000eefa00, 0xc002a99a70)
        test_1        |     GOROOT/src/testing/testing.go:1595 +0xff
        test_1        | created by testing.(*T).Run in goroutine 35
        test_1        |     GOROOT/src/testing/testing.go:1648 +0x3ad
        compare_test_1 exited with code 2
        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:125: exit status 2
--- FAIL: TestComposeCompare (627.46s)
Help

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

Same failure on other branches

- #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ c316d6a615fa02a05357a20bf03b8a197ab27810:

        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.00s)
        test_1        |         compare_test.go:141: 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 158 [running]:
        test_1        | testing.tRunner.func1.2({0x229df00, 0xc002305bc0})
        test_1        |     GOROOT/src/testing/testing.go:1545 +0x238
        test_1        | testing.tRunner.func1()
        test_1        |     GOROOT/src/testing/testing.go:1548 +0x397
        test_1        | panic({0x229df00?, 0xc002305bc0?})
        test_1        |     GOROOT/src/runtime/panic.go:914 +0x21f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x47768a0?, {0x328ab18?, 0xc002282750?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:377 +0x436
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x3248f40?, 0x47768a0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:310 +0x12c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc00045f200)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:227 +0x7f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc002210840, {0xc0022203c0?, 0x4, 0xc002210840?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:260 +0x89d
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0x209cf80?, 0x24a3ea2?, {0xc0022203c0?, 0x4aaaee8?, 0x2?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:98 +0x28
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0xc0007100e0?, {0x24a3ea2, 0x5}, 0x4, 0x80?, {0xc001f4ba40, 0x3, 0x7f826e24e108?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/schema.go:93 +0x131
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTablesN(0xc000090cc8?, 0x1?, {0x0, 0x0})
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:118 +0x15e
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc00002aa00?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:98 +0x2f
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.init.wrapCommonSetup.func28(0x26c6940?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:51 +0x1b
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc002114000)
        test_1        |     github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:143 +0xe2
        test_1        | testing.tRunner(0xc002114000, 0xc0022107b0)
        test_1        |     GOROOT/src/testing/testing.go:1595 +0xff
        test_1        | created by testing.(*T).Run in goroutine 40
        test_1        |     GOROOT/src/testing/testing.go:1648 +0x3ad
        compare_test_1 exited with code 2
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:125: exit status 2
--- FAIL: TestComposeCompare (18.81s)
Help

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

Same failure on other branches

- #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ c316d6a615fa02a05357a20bf03b8a197ab27810:

        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.00s)
        test_1        |         compare_test.go:141: 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 168 [running]:
        test_1        | testing.tRunner.func1.2({0x229df00, 0xc00206d220})
        test_1        |     GOROOT/src/testing/testing.go:1545 +0x238
        test_1        | testing.tRunner.func1()
        test_1        |     GOROOT/src/testing/testing.go:1548 +0x397
        test_1        | panic({0x229df00?, 0xc00206d220?})
        test_1        |     GOROOT/src/runtime/panic.go:914 +0x21f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x47768a0?, {0x328ab18?, 0xc0021c6300?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:377 +0x436
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x3248f40?, 0x47768a0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:310 +0x12c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc002222900)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:227 +0x7f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc002079d10, {0xc002202870?, 0x5, 0xc002079d10?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:260 +0x89d
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0x209cf80?, 0x24a3ea2?, {0xc002202870?, 0x4aaaee8?, 0x2?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:98 +0x28
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0xc0007a2160?, {0x24a3ea2, 0x5}, 0x5, 0x80?, {0xc002283a40, 0x3, 0x7f30cbf865b8?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/schema.go:93 +0x131
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTablesN(0xc000093cc8?, 0x1?, {0x0, 0x0})
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:118 +0x15e
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc00055ca00?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:98 +0x2f
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.init.wrapCommonSetup.func28(0x26c6940?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:51 +0x1b
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc0020391e0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:143 +0xe2
        test_1        | testing.tRunner(0xc0020391e0, 0xc002079c80)
        test_1        |     GOROOT/src/testing/testing.go:1595 +0xff
        test_1        | created by testing.(*T).Run in goroutine 25
        test_1        |     GOROOT/src/testing/testing.go:1648 +0x3ad
        compare_test_1 exited with code 2
        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:125: exit status 2
--- FAIL: TestComposeCompare (19.19s)
Help

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

Same failure on other branches

- #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ c316d6a615fa02a05357a20bf03b8a197ab27810:

        test_1        |                                 (NULL::INT8[]),
        test_1        |                                 ((NULL::INT8::INT8 || (NULL::INT8[]::INT8[] || NULL::INT8[]::INT8[])::INT8[]::INT8[])::INT8[]),
        test_1        |                                 (NULL::INT8[]),
        test_1        |                                 ((9:::INT8::INT8::INT8 || NULL::INT8[]::INT8[])::INT8[]),
        test_1        |                                 (NULL::INT8[])
        test_1        |                         )
        test_1        |                             AS tab235513 (col395700)
        test_1        |                     ORDER BY
        test_1        |                         tab235513.col395700 ASC NULLS FIRST
        test_1        |                 )
        test_1        |                     AS "tab\\xd8235514"
        test_1        |             ORDER BY
        test_1        |                 col395701 ASC NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab235513.col395700 AS col395701
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (NULL::INT8[]),
        test_1        |                                 ((NULL::INT8::INT8 || (NULL::INT8[]::INT8[] || NULL::INT8[]::INT8[])::INT8[]::INT8[])::INT8[]),
        test_1        |                                 (NULL::INT8[]),
        test_1        |                                 ((9::INT8::INT8::INT8 || NULL::INT8[]::INT8[])::INT8[]),
        test_1        |                                 (NULL::INT8[])
        test_1        |                         )
        test_1        |                             AS tab235513 (col395700)
        test_1        |                     ORDER BY
        test_1        |                         tab235513.col395700 ASC NULLS FIRST
        test_1        |                 )
        test_1        |                     AS "tab\\xd8235514"
        test_1        |             ORDER BY
        test_1        |                 col395701 ASC NULLS FIRST;
        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:125: exit status 1
--- FAIL: TestComposeCompare (857.06s)
Help

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

Same failure on other branches

- #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ c316d6a615fa02a05357a20bf03b8a197ab27810:

Fatal error:

panic: test timed out after 29m57s
running tests:
    TestComposeCompare (29m57s)

Stack: 

goroutine 8 [running]:
testing.(*M).startAlarm.func1()
    GOROOT/src/testing/testing.go:2259 +0x3b9
created by time.goFunc
    GOROOT/src/time/sleep.go:176 +0x2d
Log preceding fatal error

``` === RUN TestComposeCompare ```

Help

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

Same failure on other branches

- #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ f2917d82b235db6fda145a932050e5a58f957b9f:

        cockroach1_1  | nodeID:              1
        postgres_1    | CREATE EXTENSION
        postgres_1    | Loading PostGIS extensions into postgres
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | 2024-01-04 06:21:11.917 UTC [49] LOG:  received fast shutdown request
        postgres_1    | waiting for server to shut down....2024-01-04 06:21:11.918 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2024-01-04 06:21:11.920 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2024-01-04 06:21:11.922 UTC [51] LOG:  shutting down
        postgres_1    | 2024-01-04 06:21:12.017 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    | 2024-01-04 06:21:12.038 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    | 2024-01-04 06:21:12.039 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2024-01-04 06:21:12.039 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2024-01-04 06:21:12.041 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2024-01-04 06:21:12.045 UTC [68] LOG:  database system was shut down at 2024-01-04 06:21:11 UTC
        postgres_1    | 2024-01-04 06:21:12.050 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2024-01-04 06:21:13.028 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2024-01-04 06:21:13.028 UTC [78] STATEMENT:  CREATE TABLE "\\x5fta%pble2" (col2_0 INT2[] NOT NULL, c😫ol2_1 TIMETZ NOT NULL, col2_2 DECIMAL NULL, "col2
_3" JSONB NOT NULL, "co-l2_4" REFCURSOR NULL, col2_5 UUID NULL, col2_6 JSONB, col2_7 DATE NULL, "col%q
2_8" REGROLE NOT NULL, "co%l2_9" TEXT NULL GENERATED ALWAYS AS (CASE WHEN "col%q
2_8" IS NULL THEN 'I<!/'::TEXT ELSE e'\tt'::TEXT END) STORED, col2😮_10 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_0 IS NULL THEN e'})\x17\x10``\\qi'::TEXT ELSE e'\x00'::TEXT END) STORED, col2_11 DECIMAL NULL GENERATED ALWAYS AS (col2_2 + 2269.747822124061726::DECIMAL) STORED);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (605.12s)
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.92s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:172: CREATE TABLE "\\x5fta%pble2" (col2_0 INT2[] NOT NULL, c😫ol2_1 TIMETZ NOT NULL, col2_2 DECIMAL NULL, "col2
_3" JSONB NOT NULL, "co-l2_4" REFCURSOR NULL, col2_5 UUID NULL, col2_6 JSONB, col2_7 DATE NULL, "col%q
2_8" REGROLE NOT NULL, "co%l2_9" TEXT NULL GENERATED ALWAYS AS (CASE WHEN "col%q
2_8" IS NULL THEN 'I<!/'::TEXT ELSE e'\tt'::TEXT END) STORED, col2😮_10 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_0 IS NULL THEN e'})\x17\x10``\\qi'::TEXT ELSE e'\x00'::TEXT END) STORED, col2_11 DECIMAL NULL GENERATED ALWAYS AS (col2_2 + 2269.747822124061726::DECIMAL) STORED);
        test_1        |             
        test_1        |         compare_test.go:173: 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_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:125: exit status 1
--- FAIL: TestComposeCompare (630.04s)
Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ ba84e57f38d31b85758b6c9ff305bf7d07752f25:

Fatal error:

panic: test timed out after 29m57s
running tests:
    TestComposeCompare (29m57s)

Stack: 

goroutine 36 [running]:
testing.(*M).startAlarm.func1()
    GOROOT/src/testing/testing.go:2259 +0x3b9
created by time.goFunc
    GOROOT/src/time/sleep.go:176 +0x2d
Log preceding fatal error

``` === RUN TestComposeCompare ```

Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ 0039f06034104aeafa19d4f2e1e020e433663e1b:

        postgres_1    | waiting for server to shut down...2024-01-06 06:20:40.158 UTC [49] LOG:  received fast shutdown request
        postgres_1    | .2024-01-06 06:20:40.159 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2024-01-06 06:20:40.161 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2024-01-06 06:20:40.164 UTC [51] LOG:  shutting down
        postgres_1    | 2024-01-06 06:20:40.251 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    | 2024-01-06 06:20:40.280 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    | 2024-01-06 06:20:40.280 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2024-01-06 06:20:40.280 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2024-01-06 06:20:40.283 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2024-01-06 06:20:40.287 UTC [68] LOG:  database system was shut down at 2024-01-06 06:20:40 UTC
        postgres_1    | 2024-01-06 06:20:40.291 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2024-01-06 06:20:41.257 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2024-01-06 06:20:41.257 UTC [78] STATEMENT:  CREATE TABLE "table    2" ("coL2\r_    0" DECIMAL NOT NULL, "col""2_1" REFCURSOR NOT NULL, "%pco'l2_2" TSQUERY, col2_͐3 UUID NOT NULL, col2_4 INET[] NOT NULL, col2_5 TSVECTOR, "co(l2_6" TEXT NOT NULL, "col%p2_ 7" TIMESTAMPTZ, "Col2_̒8" REGTYPE, col2😒_9 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_4 IS NULL THEN e'\x00'::TEXT ELSE e'I\x19'::TEXT END) STORED, col2_10 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col2_͐3 AS TEXT))) STORED, "co
        postgres_1    |     l2_11" TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST("col""2_1" AS TEXT))) STORED, PRIMARY KEY ("co
        postgres_1    |     l2_11"));
        postgres_1    |     CREATE UNIQUE INDEX ON "table   2" (col2_10 DESC) INCLUDE ("%pco'l2_2", col2_͐3, col2_5, "co(l2_6", "col%p2_ 7", "Col2_̒8", col2😒_9);
        postgres_1    |     CREATE UNIQUE INDEX ON "table   2" (col2_10) INCLUDE ("%pco'l2_2", col2_4, "co(l2_6", "col%p2_ 7");
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (605.14s)
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.95s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:172: CREATE TABLE "table    2" ("coL2\r_    0" DECIMAL NOT NULL, "col""2_1" REFCURSOR NOT NULL, "%pco'l2_2" TSQUERY, col2_͐3 UUID NOT NULL, col2_4 INET[] NOT NULL, col2_5 TSVECTOR, "co(l2_6" TEXT NOT NULL, "col%p2_ 7" TIMESTAMPTZ, "Col2_̒8" REGTYPE, col2😒_9 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_4 IS NULL THEN e'\x00'::TEXT ELSE e'I\x19'::TEXT END) STORED, col2_10 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col2_͐3 AS TEXT))) STORED, "co
        test_1        |             l2_11" TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST("col""2_1" AS TEXT))) STORED, PRIMARY KEY ("co
        test_1        |             l2_11"));
        test_1        |             CREATE UNIQUE INDEX ON "table   2" (col2_10 DESC) INCLUDE ("%pco'l2_2", col2_͐3, col2_5, "co(l2_6", "col%p2_ 7", "Col2_̒8", col2😒_9);
        test_1        |             CREATE UNIQUE INDEX ON "table   2" (col2_10) INCLUDE ("%pco'l2_2", col2_4, "co(l2_6", "col%p2_ 7");
        test_1        |             
        test_1        |         compare_test.go:173: 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_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:125: exit status 1
--- FAIL: TestComposeCompare (629.78s)
Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ 677cd7db760cc1a0793064da7c2e6c03b14e33a6:

        test_1        |             ORDER BY
        test_1        |                 col38838 NULLS LAST, col38839 DESC NULLS FIRST
        test_1        |         compare_test.go:213: cockroach1: ping: conn closed
        test_1        |     --- FAIL: TestCompare/mutators (0.00s)
        test_1        |         compare_test.go:141: starting test: mutators
        test_1        | panic: geos: no locations to init GEOS [recovered]
        test_1        |     panic: geos: no locations to init GEOS
        test_1        | 
        test_1        | goroutine 56467 [running]:
        test_1        | testing.tRunner.func1.2({0x229e000, 0xc001b9e4a0})
        test_1        |     GOROOT/src/testing/testing.go:1545 +0x238
        test_1        | testing.tRunner.func1()
        test_1        |     GOROOT/src/testing/testing.go:1548 +0x397
        test_1        | panic({0x229e000?, 0xc001b9e4a0?})
        test_1        |     GOROOT/src/runtime/panic.go:914 +0x21f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x47768a0?, {0x328abb8?, 0xc000ca0300?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:377 +0x436
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x3248fe0?, 0x47768a0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:310 +0x12c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc000671c80)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:227 +0x7f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc000bd6b70, {0xc000679420?, 0x2, 0xc000bd6b70?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:260 +0x89d
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0x209d000?, 0x24a4042?, {0xc000679420?, 0x4aaa4a8?, 0x2?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:98 +0x28
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0xc000be45b0?, {0x24a4042, 0x5}, 0x2, 0x0?, {0xc00132fa40, 0x3, 0x7f9846385108?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/schema.go:93 +0x131
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTablesN(0xc001407cc8?, 0x1?, {0x0, 0x0})
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:118 +0x15e
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc001776a00?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:98 +0x2f
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.init.wrapCommonSetup.func28(0x26c6b80?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:51 +0x1b
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc000e401a0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:143 +0xe2
        test_1        | testing.tRunner(0xc000e401a0, 0xc000bd6ae0)
        test_1        |     GOROOT/src/testing/testing.go:1595 +0xff
        test_1        | created by testing.(*T).Run in goroutine 42
        test_1        |     GOROOT/src/testing/testing.go:1648 +0x3ad
        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:125: exit status 2
--- FAIL: TestComposeCompare (155.61s)
Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ 58502d1125b70dafeea34b96733967a387f9ef0d:

        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     --- FAIL: TestCompare/mutators (0.00s)
        test_1        |         compare_test.go:141: starting test: mutators
        test_1        | panic: geos: no locations to init GEOS [recovered]
        test_1        |     panic: geos: no locations to init GEOS
        test_1        | 
        test_1        | goroutine 246 [running]:
        test_1        | testing.tRunner.func1.2({0x229e000, 0xc0005d34e0})
        test_1        |     GOROOT/src/testing/testing.go:1545 +0x238
        test_1        | testing.tRunner.func1()
        test_1        |     GOROOT/src/testing/testing.go:1548 +0x397
        test_1        | panic({0x229e000?, 0xc0005d34e0?})
        test_1        |     GOROOT/src/runtime/panic.go:914 +0x21f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x47768a0?, {0x328abb8?, 0xc0020efa10?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:377 +0x436
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x3248fe0?, 0x47768a0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:310 +0x12c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc000a1c000)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:227 +0x7f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc0020ee660, {0xc000a070c0?, 0x2, 0xc0020ee660?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:260 +0x89d
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0x209d000?, 0x24a4042?, {0xc000a070c0?, 0x4aaa4a8?, 0x2?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:98 +0x28
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0xc0006791d0?, {0x24a4042, 0x5}, 0x2, 0x0?, {0xc000c0ba40, 0x3, 0x7f2686a28108?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/schema.go:93 +0x131
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTablesN(0xc000a0bcc8?, 0x1?, {0x0, 0x0})
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:118 +0x15e
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc000186a00?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:98 +0x2f
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.init.wrapCommonSetup.func28(0x26c6b80?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:51 +0x1b
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc000a10000)
        test_1        |     github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:143 +0xe2
        test_1        | testing.tRunner(0xc000a10000, 0xc0020ee5d0)
        test_1        |     GOROOT/src/testing/testing.go:1595 +0xff
        test_1        | created by testing.(*T).Run in goroutine 10
        test_1        |     GOROOT/src/testing/testing.go:1648 +0x3ad
        compare_test_1 exited with code 2
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:125: exit status 2
--- FAIL: TestComposeCompare (18.91s)
Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ c80a1612455593a443a1049f2198305caf9e04fd:

        postgres_1    | 2024-01-09 06:24:44.247 UTC [78] ERROR:  function parse_time(text) does not exist at character 31
        postgres_1    | 2024-01-09 06:24:44.247 UTC [78] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
        postgres_1    | 2024-01-09 06:24:44.247 UTC [78] STATEMENT:  SELECT
        postgres_1    |         *
        postgres_1    |     FROM
        postgres_1    |         (
        postgres_1    |             SELECT
        postgres_1    |                 parse_time(tab31890.col2_3::TEXT)::TIME AS col56870
        postgres_1    |             FROM
        postgres_1    |                 postgres.public."tab�le2" AS tab31890
        postgres_1    |             WHERE
        postgres_1    |                 true::BOOL
        postgres_1    |             ORDER BY
        postgres_1    |                 tab31890."col2,\\x2b_4" DESC, tab31890.tableoid DESC
        postgres_1    |         )
        postgres_1    |             AS "{tab31891"
        postgres_1    |     ORDER BY
        postgres_1    |         col56870 ASC NULLS FIRST
        test_1        | --- FAIL: TestCompare (1655.44s)
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (1049.93s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:212: SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         '{"B": {"E": 3, "G": [{"B": {"F": [{"A": false, "F": {"F": null, "G": "H", "J": 2}}, {"F": [{"A": true, "B": "I", "E": {"B": {"B": 7}, "E": {"B": true, "C": [{"A": null, "H": false}, null, {"A": null, "J": {"A": {"A": {"B": {"C": {"D": {"H": true}, "F": {"G": 1, "I": 8}, "G": {"F": {"D": {"C": {"B": null}}, "E": "D", "G": {"C": null, "D": ["H", false]}}, "H": {"D": false, "I": false}, "I": {"B": false, "D": {"H": [{"D": {"C": {"E": "G", "H": {"B": null, "G": [null], "H": {"D": {"C": {"A": null}, "F": "G", "J": true}, "E": {"A": {"E": {"A": {"G": true}, "H": {"F": {"I": 5}, "G": "G"}}}}}}}, "J": false}, "E": [true, {"C": {"C": {"F": {"C": null}, "G": {"D": true, "F": [null, false]}}, "G": [{"F": false, "H": {"A": {"B": "C", "E": "J"}, "G": [false, {"G": true}]}, "J": [{"D": true, "H": [false, 6, {"B": "H", "E": {"F": null, "G": false, "J": {"G": 7, "I": true, "J": {"D": 9, "E": true}}}, "F": {"B": true, "H": null}}], "I": false}]}, false]}}]}, {"B": "G", "D": "D", "G": 6}, {"C": {"D": false}, "E": 8, "I": [{"D": [{"D": {"E": {"A": {"A": true, "F": false}, "C": true}, "F": {"B": [2, {"F": 6, "G": 7, "H": null}, true], "I": null}, "J": {"C": null, "J": true}}, "F": {"H": true}}], "F": "E", "H": 7}, true, {"D": {"B": 7}, "E": "J", "J": true}]}]}, "E": "F"}}}, "F": null, "J": false}, "G": {"A": true, "D": 2}, "H": {"A": "I", "C": false, "J": true}}, "C": {"D": "A", "I": false}, "G": false}, "D": {"F": [null, false], "G": {"C": [{"F": true, "I": {"A": {"A": {"I": [{"C": false, "E": [3, false], "H": "D"}, null, [4, 2, null]], "J": {"A": {"H": false}, "B": [{"G": true}, {"B": null, "D": {"A": ["F", {"B": 8, "D": [6]}, 6], "F": false}}, null], "J": {"J": "B"}}}}, "C": {"A": null}}}, {"A": {"C": [null, {"D": [{"B": {"A": {"B": {"B": {"D": {"B": null, "C": {"D": [null, false], "I": {"E": {"A": {"D": true, "E": true, "J": null}}}}, "G": {"D": {"D": {"E": {"D": [true, {"F": true}]}}, "G": {"H": {"A": false, "H": "I"}, "J": false}}, "J": 7}}, "J": {"H": true}}, "C": {"A": null, "B": [true], "D": {"F": [{"B": {"B": {"J": false}, "G": {"A": {"A": {"J": {"D": {"B": {"E": {"F": true}, "J": {"C": null, "D": null}}, "J": {"J": null}}, "H": true}}, "H": false}, "B": null, "I": null}, "J": {"F": {"E": [{"D": {"D": true, "E": true}}]}, "J": {"B": {"E": {"C": {"H": [false], "J": {"B": true, "E": {"B": "I", "G": [{"D": "G", "F": false, "J": {"E": "D", "G": "G", "J": {"I": "B"}}}, null]}, "F": false}}}}, "J": {"A": {"B": {"A": "A", "C": 1}, "C": null, "J": {"C": {"D": {"G": [{"G": {"F": {"E": [{"E": "D"}], "G": [3, true], "H": false}}, "I": null}, {"F": false}, true], "H": {"F": 8, "G": false, "H": {"G": "F"}}}}}}, "H": "J", "J": ["G", [{"A": {"D": {"A": false, "I": {"G": null}}, "F": {"C": {"D": {"C": null, "F": true, "G": {"B": {"C": {"B": null, "I": {"G": {"B": [true], "J": {"B": [[true, {"D": [true], "H": [{"D": {"B": null}}]}]], "C": false, "G": [{"F": [false, {"D": {"I": {"A": {"C": "B", "E": 9}, "I": true}}, "J": {"D": false, "J": {"H": {"B": 3, "I": null}}}}], "J": 3}, false]}}, "J": {"I": false}}}, "H": {"A": [1], "J": {"B": "G"}}, "J": [{"F": {"F": false, "H": true}, "G": [null, {"C": {"C": true, "G": true}, "F": {"A": {"A": true, "C": {"B": {"G": {"G": true, "I": "B"}, "I": false}, "I": {"C": false, "I": {"A": {"B": {"G": {"D": false}}, "C": {"F": {"A": [{"H": [{"F": true, "H": {"G": 5}, "J": {"I": false}}], "I": "I", "J": "A"}, {"C": false, "D": true, "G": 8}]}}, "F": 7}}}}}, "D": {"A": null, "G": [null], "H": true}, "F": {"D": 1, "H": [5, 7]}}}, 5], "I": "H"}, {"G": {"B": {"J": {"F": false, "J": false}}, "J": {"I": false, "J": 0}}, "H": true}]}, "H": {"A": {"C": {"D": false, "H": null}}}}}, "E": {"F": [{"A": 3, "D": [{"F": [{"H": {"I": {"H": 5}, "J": {"D": {"G": {"B": true}, "H": false, "J": {"E": true}}, "F": true}}, "J": false}, true, {"A": false, "C": {"E": false}, "G": {"F": [{"C": [{"A": {"C": {"B": {"G": {"F": [{"D": {"B": 2}, "G": null}], "J": {"C": {"E": null, "F": ["F", "H"], "J": {"I": {"B": {"D": 4, "F": {"A": "H", "E": {"A": {"H": {"C": {"B": false}, "J": 5}, "J": {"F": {"D": {"E": null, "J": {"C": false, "D": {"E": {"J": false}, "F": [{"D": {"J": "G"}, "J": null}, false, null]}, "I": {"A": true, "B": null, "J": true}}}}, "H": {"A": {"G": null}, "H": false}}}, "C": [0], "J": {"A": true, "D": false}}, "J": [7]}, "I": {"F": {"E": {"H": true, "J": true}, "G": {"D": "C", "I": {"B": false}}}, "G": {"A": false, "B": null, "G": {"D": false, "E": {"A": 4, "F": [[6, false], 0], "I": {"D": {"C": "G", "E": [{"H": [false, null], "I": 8}, {"C": {"A": {"C": true, "H": {"D": false, "H": [false, false]}, "I": true}, "G": {"A": null, "B": [{"A": "G", "E": null, "G": true}], "C": {"A": {"I": {"E": false}, "J": {"G": {"C": {"C": true, "I": {"A": {"B": {"C": null, "F": [null, false, null], "I": {"D": false, "I": {"B": false, "D": {"C": {"A": {"B": false, "H": {"I": {"D": false, "J": {"A": null, "J": "C"}}}}}}, "I": {"D": false, "F": [null]}}}}}, "C": {"H": true, "I": "F"}}}, "D": {"C": null, "F": {"E": {"G": {"G": {"H": {"B": false, "G": true}}, "H": {"A": null}}}, "G": {"E": 0}}}, "E": true}, "I": {"B": null, "C": {"F": {"B": 7, "G": {"D": true, "E": true}, "I": "J"}}}}}}}, "H": {"C": {"A": "J"}, "E": 3, "H": "C"}}, "F": "D", "J": ["H"]}, {"I": {"A": [{"D": {"H": "D", "I": "A"}, "E": {"H": {"G": ["B", 6, true], "I": true, "J": {"H": true}}}, "I": {"E": false}}, "A"], "H": "B", "J": ["G", {"F": false}]}}]}, "G": {"C": true, "F": false}}}}}}}}}}}}}, "C": true}}, "J": 0}, {"G": {"I": true, "J": true}, "H": {"D": {"I": null}, "G": {"B": {"B": {"C": [{"F": {"C": 8, "G": {"B": {"C": {"A": 5}, "J": {"E": ["G", true, false], "F": null, "H": {"B": [{"A": {"I": null, "J": false}, "E": true, "J": {"B": null, "C": {"E": {"E": {"B": false, "J": false}}, "G": {"B": {"I": false}, "G": {"D": {"B": false}}}, "I": {"D": false}}}}, null], "F": "E", "J": {"A": {"B": [{"E": false}], "E": null, "F": {"D": "A", "I": true}}}}}}, "E": {"I": false}, "H": null}}}], "D": {"D": {"D": false, "J": {"C": null, "G": [true]}}, "E": {"D": {"A": "G", "G": {"B": 0, "J": {"H": "F"}}}, "G": null, "H": 3}, "H": {"I": {"I": [0, {"A": [{"E": {"E": {"C": {"F": {"A": null, "D": true, "J": [{"A": false, "G": 8, "I": false}, [7], [false, [true, [false, 8]]]]}}, "J": {"A": "B", "F": 7, "I": {"A": {"H": "I"}, "F": {"I": {"G": null, "I": true}}, "G": {"C": false, "F": false}}}}, "G": {"F": {"A": {"I": {"B": 6, "D": false, "G": [{"G": {"A": false}, "H": {"I": true}}, 5, {"A": 9, "C": {"B": null}}]}}, "D": null, "F": [1, {"A": 6, "G": false}]}}, "J": {"A": null, "E": false}}}, 4, null], "F": [{"I": false}, {"A": 4, "B": {"F": {"J": true}, "H": {"F": 4}}, "G": [true, "F"]}]}]}}}, "F": "C"}}, "J": {"E": null}}}}, {"C": {"I": {"H": false}}, "E": null, "G": 1}], "J": {"C": {"J": null}, "E": "I", "F": 1}}, {"E": {"B": "E", "J": 3}, "H": {"B": "A", "D": [[{"B": false}, "F", false], true, false], "F": null}, "J": {"A": [{"D": [{"B": 3, "D": 6}, {"J": {"D": false, "I": 5}}, 8], "F": {"A": "B", "D": [false], "F": false}, "I": {"A": {"J": null}, "B": {"E": {"A": 3}, "I": [{"J": true}, true]}, "I": {"A": null, "C": true, "H": "I"}}}, "C"], "I": false}}, {"F": true}]}}], "J": "H"}, {"J": true}], "J": true}, "A", {"B": {"C": null}, "H": false}]}, "J": false}}, "I": true}, "E": false, "I": "G"}, 6], {"D": "I", "F": {"D": {"B": {"E": "C", "I": null}, "H": {"E": 0, "G": {"D": true, "H": {"A": "C"}}, "H": 9}, "I": null}, "F": {"C": [false]}, "G": false}, "G": null}]}}}}, "E": {"A": 8, "B": 6, "F": {"E": null, "H": [[{"C": {"B": ["E", {"F": {"C": {"J": {"J": {"D": "H"}}}, "I": {"E": null, "J": {"C": "H", "H": null, "I": "G"}}}, "G": [{"D": 2}]}, [null]], "E": 2}, "J": [0]}, ["D"]], [{"A": {"A": {"D": "C"}, "F": {"J": {"C": [{"C": 0, "G": {"A": false, "E": {"D": null}, "F": null}, "I": false}, "B", false]}}, "I": {"H": true}}, "D": true, "E": {"D": {"A": {"D": false, "J": {"D": {"E": [{"D": {"A": {"G": false}, "D": {"F": [true, null, null], "G": {"B": "D"}}, "E": "C"}}, {"E": {"F": true}, "J": {"C": {"D": false, "J": true}}}, "I"]}, "E": "J", "J": {"F": [0, "H"]}}}, "E": [{"F": {"E": {"E": false, "F": {"H": [{"A": {"E": true, "G": null}, "G": "H"}, "I"]}}}}, [null, true]], "F": {"A": true, "B": "J", "H": {"C": {"B": {"E": {"D": {"D": [{"A": {"B": "F", "H": {"D": false}}}]}}, "H": false}}}}}}}, "H", [{"B": true, "I": {"C": {"B": {"A": "J", "J": [true]}}, "H": false}, "J": 1}, {"D": {"D": 3, "F": {"F": {"G": null, "I": {"D": null, "H": {"D": {"H": 4}}}, "J": {"A": false}}}, "G": [[{"A": "J"}, true, 1], {"A": {"C": {"B": {"E": {"C": {"H": {"B": "I"}, "J": {"F": null}}, "E": {"C": {"A": [[{"D": [{"B": {"B": {"C": null, "D": true}, "J": 7}}, false, [false, {"E": 2, "J": {"I": [true]}}, {"F": true, "G": 9}]]}]], "B": false, "C": null}, "E": {"I": [false, {"E": null, "J": null}, {"B": 8}]}}, "H": null}}}, "F": 0}, "B": false, "C": [[{"B": {"D": false}, "G": null}], 1, 0]}, false]}}]]], "I": {"A": true, "D": null}}}, "H": {"B": {"J": "J"}, "D": {"G": "G", "H": 7}, "G": {"B": [["A"], {"F": {"C": {"A": "B", "G": 9}, "J": null}, "I": {"C": true, "D": null, "I": true}, "J": {"D": {"E": null, "H": {"B": null}, "J": "H"}, "J": "F"}}, {"D": {"H": {"E": 1}, "J": {"B": null, "C": [null, {"A": "H", "J": null}, {"C": [{"B": {"B": {"F": "G", "G": {"D": {"B": {"D": "A", "E": {"E": 0, "I": null}}}}, "J": {"D": "F"}}, "C": [true, {"G": 5, "H": {"C": "C", "E": 4}}, [{"B": {"C": false, "J": {"A": {"A": [{"A": false, "C": true, "F": {"B": {"B": {"F": [{"A": {"I": {"B": false, "E": [[false], {"C": {"B": "H", "G": [["D", {"C": true}], {"C": "I", "J": null}, true], "I": [[false]]}}, false], "G": true}}}]}, "H": {"G": {"G": {"B": false, "D": {"C": {"A": 3, "D": {"C": "C"}}, "D": true, "G": "F"}}, "H": null}, "H": {"B": "C"}, "J": false}}, "J": {"H": true, "I": {"I": [[null, null]]}, "J": {"E": {"F": false}, "I": null}}}}], "C": [{"B": {"E": {"D": {"D": "C", "F": {"A": {"J": {"G": {"D": [{"A": false}], "E": true, "H": {"H": {"B": [{"A": {"J": false}, "H": false}, true], "H": {"E": true, "G": "I"}, "J": null}, "J": {"J": 2}}}}}, "C": [{"H": "E"}, {"F": {"J": {"D": {"E": "I"}, "F": false, "G": "G"}}, "G": [{"F": 2, "H": {"H": {"A": false, "D": true, "I": {"F": "F"}}}}], "J": [{"E": true, "H": "C"}, {"A": {"D": false, "F": {"E": 9, "J": {"E": {"G": 9}}}, "J": "H"}, "C": {"E": 3}, "G": {"C": {"C": "A"}}}, 8]}], "G": 6}, "G": "A"}, "F": "G", "J": [false, false]}}, "F": true}], "I": [null, {"C": {"A": {"D": {"A": false, "F": {"A": "D", "F": {"F": {"B": {"D": "E", "E": false, "J": {"A": null}}}}}, "I": {"F": true}}, "F": true}, "D": false}, "G": 1, "I": {"G": {"D": true, "F": {"G": {"I": true}}}}}]}, "E": {"B": {"H": {"E": {"I": {"E": false, "G": false}}, "J": {"D": false}}}}}}, "J": {"A": {"J": null}}}]], "D": [false, {"E": [{"C": {"G": true}}], "G": {"B": false, "E": {"B": 3}, "F": null}, "J": 9}]}}, 9]}]}}}], "C": "E"}}}, false]}}}, "E": [null, false], "G": null}}, "C": [true]}, {"B": ["J", null]}], "I": "E"}]}, "D": {"B": {"C": {"I": true}, "E": null, "G": "C"}, "F": [null], "J": {"D": "B", "F": false}}, "J": false}], "F": false}}, "G": 4}}], "J": {"A": {"B": true, "J": "E"}, "B": {"C": null, "I": null}, "J": [{"G": [true, {"A": false, "D": true}, {"D": 1, "G": {"C": [{"A": {"G": null}, "B": {"E": [{"A": 2, "C": {"C": null, "D": {"A": [true], "F": {"C": null}}, "G": 7}, "F": [false]}, {"H": {"A": true, "D": {"A": null}}, "I": {"B": {"F": [{"B": null, "G": [true, {"A": {"D": {"E": {"J": [null]}, "H": {"E": {"E": {"A": "G", "B": false, "F": true}}}}, "J": false}, "B": 3, "J": "B"}, {"B": {"D": {"G": {"E": {"A": {"A": "F", "I": {"B": 9}}, "B": true, "D": true}}, "H": 9, "J": "C"}, "F": false}, "F": {"C": "I", "F": false, "J": true}, "H": {"F": {"C": {"B": true}, "H": {"A": {"C": null, "J": {"B": false, "G": {"D": {"D": false, "J": {"J": null}}}, "J": {"A": false, "F": true, "H": {"E": null}}}}, "D": false, "J": null}, "I": {"G": {"C": {"B": "E", "J": null}, "G": {"B": {"E": [6, false], "F": {"B": false, "E": false}}}}}}, "I": 2}}], "I": {"E": false, "J": {"E": true, "F": true, "I": {"B": true, "D": [false, [{"B": {"C": false, "F": 2}}, [{"B": {"E": {"E": {"A": {"G": "H"}, "E": {"H": {"B": true, "C": null}}}}, "G": {"F": {"A": 3, "E": {"D": {"C": null}, "E": null}, "H": {"A": {"D": 0, "E": ["C", {"C": {"B": "H"}, "F": 1, "I": {"G": false, "I": {"H": false, "J": {"A": true, "E": {"A": "G", "F": "E"}, "G": [{"A": [[1]]}, {"D": null, "F": {"F": {"B": true, "D": 4, "E": [{"E": {"C": {"B": true, "F": 5, "J": false}, "H": "C", "J": [{"J": {"F": false}}]}, "G": null}]}, "I": {"B": {"A": 8, "C": 7, "H": [{"F": {"D": {"A": false, "F": [null, {"A": {"G": 3}, "D": false, "I": {"F": {"F": {"A": [{"B": null}, {"G": true, "J": [{"B": [{"C": [null, "B", "G"], "E": {"C": {"H": {"A": {"B": {"D": true, "H": true}, "C": {"I": false, "J": [{"B": true, "H": false}, {"E": {"B": {"I": "G"}, "E": {"C": "F", "H": false}, "G": "G"}}]}, "G": {"E": true, "F": "I", "G": 7}}}, "I": "G"}}, "J": true}, {"G": 6, "I": null}]}]}]}, "J": true}, "G": {"C": {"F": null, "J": false}, "J": true}, "J": 4}}]}}, "I": {"J": {"C": true, "I": true, "J": {"G": {"F": 5}}}}}]}, "J": {"J": {"A": null, "E": null, "G": "D"}}}, "J": true}, "H": [false, ["G", false, {"H": {"D": true, "G": 2, "I": [false, "I", true]}}]]}, "H"]}}, "J": {"B": {"A": null, "B": 3, "G": {"C": 8, "F": false, "H": {"B": "C", "D": {"I": false}}}}, "F": [{"H": null}, {"B": {"E": false, "J": false}, "E": {"F": false, "H": [{"G": [8]}]}, "H": {"D": null, "F": {"D": {"E": {"D": {"E": {"F": {"I": 4}}}, "H": {"I": 1}}, "H": true, "I": {"A": {"A": [{"H": 5}], "D": 5}, "B": {"E": [{"D": {"A": true, "C": 1}, "F": {"C": {"I": "E", "J": {"A": false, "G": [{"A": true, "I": {"D": {"A": true, "G": null}, "J": false}, "J": 3}, {"E": {"D": {"A": {"A": {"G": "G"}}, "D": [{"D": {"G": {"C": [null, {"A": {"A": null, "B": true, "D": false}, "D": {"C": {"D": {"F": {"C": false, "E": null, "F": true}, "I": false}, "G": "I"}, "D": {"C": {"A": 2, "E": true}, "D": "F", "F": {"D": 6, "G": {"A": {"A": null, "E": false, "J": {"C": {"I": false}}}, "E": {"C": [true, {"B": 9}], "J": "I"}}, "J": false}}, "J": {"A": {"A": "H"}}}, "H": [{"I": {"F": null, "I": true, "J": null}}, true]}, null]}, "J": null}, "G": {"J": true}, "H": false}], "J": [3, null]}}, "J": "G"}], "I": null}}, "J": false}, "G": {"C": "A"}}, true], "G": null, "H": {"A": {"A": null, "I": ["C"]}, "B": 1, "H": {"B": {"G": {"G": {"B": 5, "C": {"G": {"B": {"A": {"B": false, "E": {"I": true}}}, "E": null, "F": false}, "J": {"C": null}}, "J": {"C": true}}}}, "E": {"B": 8, "C": "E", "I": false}}}}, "E": {"A": {"A": {"D": true, "H": null}, "H": "B"}, "I": {"A": {"E": ["H"], "G": null}, "C": {"B": null, "D": true, "F": null}}}}}, "G": {"D": false}}, "G": true}}]}}}]}, "E": {"B": 5, "D": false, "H": ["H", {"B": "F", "H": null, "J": {"B": {"C": "J", "E": {"J": "B"}, "I": null}, "F": {"A": "H", "C": true, "G": [{"F": {"B": {"B": true, "H": null}, "D": false, "I": false}, "I": null}, null, [[true, {"A": null, "B": {"F": true}}]]]}}}, "E"]}}}, "I": {"A": {"B": [{"B": {"A": [null, {"G": {"C": false, "F": "I"}}], "F": {"I": false}}, "G": {"E": "J", "H": {"D": {"D": true, "E": {"B": null, "C": {"D": [null], "J": {"C": {"J": "C"}, "F": false}}, "H": {"E": {"F": [null]}}}, "J": {"A": false, "H": {"A": {"H": {"A": true, "H": [[true, true, false], [false]]}}}}}, "G": false}}, "H": "I"}, false], "J": {"C": {"A": false, "H": "E", "I": false}, "G": "G"}}, "J": {"A": {"G": [{"H": {"E": null}, "I": 9}], "I": [{"D": false, "I": 4, "J": [[1, {"G": true}]]}, "D", {"E": {"I": null}, "H": [true, {"F": true, "I": true}]}]}, "H": {"F": 7}}}, "J": null}}, "G": {"A": "C", "B": null, "E": {"F": {"C": {"H": true}}, "H": 1}}, "I": {"G": {"I": "J"}, "H": null}}, true, {"G": {"A": true, "F": {"D": [{"F": false}, {"B": 8, "D": {"C": false}}, [false]]}, "I": "J"}}]]], "H": true}}}}, 1, true], "H": {"E": false, "G": true}}, "G": "A"}}]}, "G": {"C": {"E": true, "F": {"G": [null], "H": true}, "H": {"A": true}}, "G": {"B": {"C": "C", "D": {"H": "E", "J": [{"I": true}, true]}, "I": {"D": {"A": false}, "G": "C"}}, "F": 7, "I": {"A": [{"F": "J"}, null, {"I": {"A": {"E": false}, "H": false}}], "D": [false, {"G": false}, {"H": {"A": null, "B": {"A": {"B": {"B": [true, 7], "E": {"I": {"B": false, "D": true, "H": {"B": [[{"G": "D"}]]}}, "J": true}, "H": true}}, "B": 7}}}]}}}}, null, null], "F": true}, "J": false}], "H": {"D": 2, "J": {"E": {"F": 9}}}}]}}, "I": {"E": {"B": false, "G": false}, "F": null, "I": {"F": {"C": {"B": {"A": {"I": false}, "J": "B"}, "C": [4], "G": [{"C": {"H": 3, "I": {"B": true, "E": "J", "J": {"C": true, "H": 9}}}, "F": {"D": false, "I": false}}, {"B": {"E": true, "J": {"B": {"B": {"B": {"G": {"C": null, "G": "D"}, "J": {"A": "I", "G": "C", "H": {"B": 5, "D": {"H": "E"}, "E": true}}}, "H": false}, "C": true, "H": null}}}, "D": {"F": {"H": {"E": {"E": {"A": {"A": ["A", {"E": null}], "C": {"D": null, "F": "I"}, "E": {"D": false, "E": "H", "J": [{"E": false, "J": null}, 1, {"B": 3, "C": null, "F": {"B": {"F": {"A": {"H": true}}, "H": {"A": {"D": {"A": null, "H": {"B": false, "D": "D", "F": [null, {"E": null}]}, "J": false}, "F": {"B": {"E": false, "I": {"C": "G", "H": 0}}}}, "G": [true, "A"], "H": {"I": "E", "J": {"B": "G", "D": {"A": {"A": [null, {"B": {"C": {"F": true, "H": [false, 6], "I": true}, "H": {"E": [{"C": true, "G": false}, {"G": {"J": "J"}}]}}}, 8], "I": "E"}}, "H": {"C": true, "D": {"B": true}, "H": "H"}}}}}}}]}}}, "J": {"F": false, "I": {"A": {"D": null, "I": [null, 0]}, "B": {"A": false}, "D": "F"}}}, "J": true}, "J": true}}}]}, "I": [false]}, "I": {"I": {"D": {"D": [null, {"A": false, "E": {"D": false, "J": 0}, "H": {"E": true}}], "I": null, "J": null}, "H": null}}}}}}]}, {"J": null}]}}, [null, [{"F": {"E": true}}, true, false], null], {"A": {"D": "B", "H": {"A": {"A": false, "J": [null]}, "C": null, "E": 0}}}]}, "J": 9}':::JSONB::JSONB
        test_1        |                             AS col56952
        test_1        |                 )
        test_1        |                     AS tab31937
        test_1        |             ORDER BY
        test_1        |                 col56952 DESC NULLS LAST
        test_1        |         compare_test.go:213: cockroach1: ping: conn closed
        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:125: exit status 1
--- FAIL: TestComposeCompare (1679.35s)
Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ dab086d9d1d3355ad381ec493c73cabfa8d6b046:

        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (369.57s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare2473143674/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:203: compare postgres to cockroach1: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   string("2.645751311064591G"),
        test_1        |             +   string("2.6457513110645905905G"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (sqrt(COALESCE(7:::DECIMAL::DECIMAL, 5:::DECIMAL::DECIMAL)::DECIMAL)::DECIMAL::DECIMAL || 'G':::STRING::STRING::STRING)::STRING
        test_1        |                             AS "c%vol352193"
        test_1        |                 )
        test_1        |                     AS tab196197
        test_1        |             ORDER BY
        test_1        |                 "c%vol352193";
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (sqrt(COALESCE(7::DECIMAL::DECIMAL, 5::DECIMAL::DECIMAL)::DECIMAL)::DECIMAL::DECIMAL || 'G'::TEXT::TEXT::TEXT)::TEXT
        test_1        |                             AS "c%vol352193"
        test_1        |                 )
        test_1        |                     AS tab196197
        test_1        |             ORDER BY
        test_1        |                 "c%vol352193";
        test_1        |             
        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:125: exit status 1
--- FAIL: TestComposeCompare (997.62s)
Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ f2744bbbcd88ccfb09a6a0af0a8b2342302627ef:

        postgres_1    |         )
        postgres_1    |             AS "t ab171171"
        postgres_1    |     ORDER BY
        postgres_1    |         col250180,
        postgres_1    |         col250181 DESC NULLS LAST,
        postgres_1    |         "\gcol250182",
        postgres_1    |         "co l250183",
        postgres_1    |         col250184 ASC,
        postgres_1    |         col250185 DESC NULLS FIRST,
        postgres_1    |         "Col250186" DESC,
        postgres_1    |         "coL250187" DESC NULLS LAST,
        postgres_1    |         col250188 ASC,
        postgres_1    |         co̢l250189 ASC NULLS FIRST,
        postgres_1    |         col😍250190 ASC NULLS FIRST,
        postgres_1    |         col250191 ASC
        test_1        | --- FAIL: TestCompare (1022.47s)
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (417.21s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:212: SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         COALESCE(
        test_1        |                             '{"B": {"E": false, "G": {"H": {"E": {"A": "A", "E": {"A": [{"B": true}, [false, [{"C": {"H": {"D": "H", "G": {"B": [{"C": null, "G": {"D": {"F": {"C": {"C": 8, "J": true}, "E": {"B": false, "E": {"D": {"A": {"A": {"J": null}}, "H": 1}, "E": [3, {"C": {"H": {"A": true}}, "G": {"H": "C", "I": {"A": {"B": {"B": "E", "F": {"I": false}, "G": ["J", true, {"A": {"A": {"E": {"F": {"G": true, "I": "B", "J": {"B": {"B": {"B": "J"}, "C": {"G": null, "I": {"D": true}}, "D": [2, false, false]}, "J": "I"}}, "G": false, "J": {"B": {"A": {"D": [{"B": "B", "E": false}], "H": "G", "I": [[true, "H", {"A": "A", "F": "J"}], "H"]}, "F": {"F": {"C": {"C": {"C": "C", "E": "G"}, "H": false}, "F": null, "H": [{"F": {"C": "C"}, "G": "I"}, {"F": null, "G": {"B": [{"B": false, "C": null}, "C", [null, {"D": true, "H": true}, "D"]], "C": {"A": null, "D": 2, "F": 2}}}]}}, "H": [false, true, "D"]}}}}, "G": "F"}, "E": {"C": {"B": "D", "I": null}}, "J": false}]}, "J": "E"}, "C": "B"}}, "H": {"D": 4, "J": [{"C": {"G": "B", "J": {"B": 7, "C": [{"E": true, "G": {"E": false, "F": {"A": "I", "E": {"D": {"D": {"B": {"B": {"E": "E"}, "J": 0}, "H": {"D": 9}, "J": {"A": {"B": {"A": true, "F": {"F": false, "G": true}}, "D": {"I": {"G": {"A": true}, "H": null}}, "G": {"H": "D"}}, "I": {"G": {"D": false}}, "J": {"C": {"D": {"B": true, "D": {"C": true, "J": null}, "E": false}}}}}}, "E": {"B": false, "C": {"B": {"G": {"B": {"H": true}, "C": {"B": {"A": [{"F": 9, "I": {"D": [true, null, null], "G": {"A": null}, "I": {"C": true, "E": "D", "F": {"I": false, "J": 9}}}, "J": "G"}], "E": true}, "F": {"G": null, "H": {"D": {"I": false}, "H": {"C": null, "D": [[null], {"A": {"D": null, "H": true, "I": {"F": true}}}], "I": false}}, "J": false}}}}, "D": {"D": {"B": null, "I": null}, "E": false, "H": 6}, "E": [{"H": true}]}, "I": {"J": {"A": 1}}}}, "I": null}, "J": {"D": {"A": {"E": 8, "H": [{"B": {"D": {"D": "C"}}, "F": false, "I": {"F": {"C": {"C": {"E": "C"}}, "H": {"D": true, "J": [{"C": {"B": false, "G": 0}, "D": 0, "G": "J"}, null]}}, "G": true}}, {"G": false, "H": {"C": false}, "J": {"B": {"A": null, "H": false}, "H": [{"C": true, "E": {"F": false, "I": [{"A": {"F": {"A": null, "E": [{"B": {"A": false}, "D": "D", "J": null}]}, "I": "D", "J": 9}, "B": false, "E": [7, 7, "B"]}, {"B": "F", "I": 6}]}, "G": [null, [{"C": false, "D": ["F", true]}, false]]}], "J": {"H": [{"C": [{"C": {"B": 2, "F": "H", "H": {"H": false, "I": {"B": {"C": [false]}, "C": {"C": {"J": {"A": {"F": true}, "C": {"E": {"A": 0, "C": null, "I": false}, "J": {"C": {"A": {"H": 2}, "C": [{"G": {"B": 0}}, {"D": {"D": "C", "G": {"H": [null, null, false]}}}, {"B": {"H": {"A": {"C": {"A": "A", "F": {"E": null, "F": [null], "J": [{"D": false}, 3]}, "G": {"C": {"D": {"F": true, "H": false, "I": false}, "I": {"J": {"B": {"G": {"G": 0}, "H": true}, "D": [{"A": 3, "J": {"A": {"C": {"A": {"G": {"D": {"C": {"G": {"E": 2}}}}}, "C": {"G": "B", "H": {"A": 2, "F": {"I": {"B": {"C": {"A": {"B": {"C": null, "D": 8, "I": {"D": {"J": {"A": "J", "I": [{"D": false, "I": true, "J": {"A": null}}, [[null, true, 0]], true]}}, "G": 7, "J": false}}, "E": false}, "D": 1}, "H": "G"}, "F": {"F": {"D": [true, {"A": true}, "E"]}}}}}}, "H": {"H": {"C": {"H": "D"}, "J": {"A": {"B": "D"}}}}}}}}, "J", [{"D": null}, false]]}}}, "E": 9, "G": false}}}, "C": [null], "G": [{"E": [9]}, 6]}}, "I": {"D": [true, "I"], "F": {"C": {"C": {"A": ["D", {"A": {"E": {"H": false}, "H": {"B": 0, "J": {"A": {"B": true, "D": {"B": "G", "C": {"C": null}, "F": null}}}}}}], "I": false}, "G": {"B": true, "F": null}}, "E": false}, "J": {"F": {"C": {"A": [{"D": null}], "C": {"G": {"D": 1, "E": false}, "J": "A"}}, "D": [false], "J": false}}}}], "I": null}}}, "I": {"B": ["G"]}}}, "D": {"B": [{"A": null, "C": {"C": {"B": {"H": {"F": {"F": {"B": "G"}, "I": {"A": 8, "H": "B"}}, "G": {"G": "A"}}, "J": {"E": 0, "H": {"B": true, "D": false, "J": 3}, "I": {"B": 6, "G": {"I": 6}}}}, "C": [false, false], "H": 1}, "F": true, "J": {"D": {"B": {"C": {"F": {"G": 1}, "I": {"E": {"A": false, "C": {"J": null}}}}, "I": true}}}}, "D": "J"}, null, {"B": true}]}}, "H": 9}}}, "J": "H"}, true, "D"], "J": 2}, {"C": 5, "E": "J"}]}}}]}, "H": {"A": {"C": 4}}}, "E": "C", "I": null}}}, "A", {"D": true, "G": null}], "I": {"E": 0, "I": {"B": [{"C": {"H": {"A": {"I": {"H": {"B": null}}}}, "I": ["A", null]}}, true, {"C": {"C": [{"E": true, "I": null}, false], "F": [0, {"B": {"C": {"H": {"H": true, "J": [{"G": {"B": {"B": true, "C": [true, {"A": true, "B": {"A": {"A": false, "H": "G", "I": "C"}}, "E": {"C": "D"}}, null], "E": {"C": 5}}, "C": null}}, false, {"I": null}]}, "J": "J"}, "D": {"A": {"A": {"I": "J"}, "F": true, "I": true}, "B": null, "E": "C"}, "E": 3}}, false]}, "D": false, "J": true}]}}}}, "H": false}, true, null]}}, false]}}, "F": [4, "D"]}, "J": {"A": "D", "B": [{"E": {"C": {"A": {"G": {"G": true}, "I": false}, "B": "B", "E": false}, "E": {"C": {"H": "G", "J": 4}, "E": null, "F": true}, "I": {"C": {"F": {"C": true, "D": 7, "F": true}}, "J": true}}, "G": false, "J": false}], "I": false}}}}, 2]}}}, "E": ["A", {"G": {"C": {"I": 0}, "F": {"B": {"H": {"A": false}}}, "H": [true]}, "J": false}], "J": {"A": {"A": {"G": 3}, "E": false}, "B": "A", "D": false}}, 0, null], {"G": true, "H": 8}]], "B": {"G": {"I": {"D": "E", "F": null, "J": {"E": {"D": {"F": [null, null], "H": {"G": false}, "I": {"F": {"J": {"E": true, "G": {"B": {"E": 9, "F": {"C": 3, "D": null}, "I": false}, "C": 7, "F": false}}}, "J": {"F": {"C": 1, "D": "A"}, "H": {"H": null, "J": [[{"D": "B", "H": {"A": "E"}}, {"A": null, "C": {"D": false, "H": {"F": {"A": "F", "J": {"B": {"F": 4, "G": {"E": "J", "G": "E"}, "I": {"A": {"D": "G", "F": {"E": false, "F": 1, "I": "J"}}, "H": {"D": false, "E": false}, "J": null}}, "F": 9}}}, "I": {"F": {"F": [true], "G": null}}}, "J": {"B": true, "D": {"H": "A"}}}]]}}}}}, "J": {"A": {"D": null, "G": false, "I": null}}}}}, "H": {"G": {"C": {"B": "F", "D": "J", "I": {"C": {"F": [{"G": {"H": {"C": {"D": [{"A": {"D": [0, {"A": {"D": false}}, true], "E": [{"H": {"C": {"D": [{"A": null, "E": {"B": true}}, {"B": {"H": false}, "C": 7}, false], "E": [true, 4]}, "E": 5}}], "G": {"A": false, "E": true}}}, 2, {"A": {"G": null, "H": {"A": {"F": null, "H": false}, "I": null}, "I": "A"}, "B": {"F": {"A": [{"A": {"J": {"B": {"F": [true, {"G": null, "I": {"H": true}}]}, "H": true, "J": {"H": [{"B": true, "G": {"J": {"A": {"D": "G", "H": 0}}}, "J": [null, 9, [true, true]]}, {"C": {"F": {"B": true, "D": {"F": {"G": {"C": ["C", "B", null], "D": [{"C": 9, "G": 4, "H": false}, null]}, "H": [{"H": {"H": [{"A": true, "I": true}, [null]]}}], "J": 4}, "G": {"A": [[{"B": {"E": false, "G": 0, "I": 8}, "C": ["E", {"A": true}]}, 2, {"A": true, "J": [{"C": null}, true, "E"]}], ["E", {"C": null, "I": null}]], "F": {"B": 4, "F": null}, "J": {"B": true, "D": {"D": [true], "G": [[{"C": true}]]}, "F": 9}}, "J": [{"E": {"D": null, "G": {"C": "I"}, "H": {"I": false}}, "I": true}]}, "J": "J"}, "H": null}}], "I": {"B": [{"I": true}, true, {"B": {"I": {"G": false}}, "D": {"I": {"E": 1}}}]}}}}}], "C": {"D": null, "F": {"A": {"D": true}}}, "I": null}, "I": "A"}}], "H": "I", "I": {"A": [{"D": {"A": null, "G": {"A": {"E": {"D": null, "G": {"C": 0, "D": false, "E": 9}}, "F": true, "I": 0}, "E": {"A": [false, true], "B": {"E": true, "G": "G"}}, "H": {"D": [[false, {"C": {"B": false}, "G": true, "J": {"F": null, "G": 4, "J": null}}, null]], "E": {"I": {"E": 2, "F": true, "J": [{"B": {"B": {"D": [false, true]}, "D": 1}, "H": "D", "I": {"A": {"E": false}, "F": false, "I": 4}}, 7]}}}}, "J": true}, "H": true}, {"I": "H"}, false]}}, "G": null, "J": "J"}}}, false]}, "F": 3, "J": {"B": {"G": null, "I": {"A": "H"}}}}}, "G": {"A": false, "H": true, "J": "J"}}, "H": {"B": {"A": true, "B": true, "H": false}, "C": {"C": "G", "D": true}, "D": {"E": 9, "F": 7}}}, "J": {"B": {"A": true, "D": {"H": {"H": [{"D": {"C": {"C": {"D": null, "J": [{"A": "I"}, {"E": {"B": 6, "H": {"G": 5, "I": [{"I": {"D": {"A": {"B": {"G": false}, "C": false, "H": [{"C": {"B": null, "F": null}}, [false, null]]}, "G": true, "H": {"I": true}}}}, false, ["C", {"B": {"D": {"G": 2, "H": false}, "I": {"C": [null, [[null, 5, 0]]], "E": 9, "F": {"F": {"A": {"C": false}, "E": {"E": {"J": [{"A": false, "I": {"B": "F", "I": {"D": 9}}}]}, "J": {"E": true, "H": {"G": "G", "J": {"C": true, "E": {"A": [{"C": {"D": {"C": true, "E": "J", "F": null}, "J": {"E": false, "H": false}}, "E": {"F": 7}}], "B": {"C": [[{"C": {"E": {"E": "J", "G": null}, "H": {"A": "G", "C": {"I": {"A": null, "C": ["A", [false, false, {"F": {"C": 9, "E": [{"H": [false, {"C": {"H": {"C": 0, "E": {"A": "E"}, "I": {"G": false, "J": {"A": {"B": {"H": false}, "D": false, "J": {"H": false}}, "F": null, "I": {"A": 8, "E": {"A": [[{"A": [null], "C": {"D": {"F": null, "G": 1}, "J": {"I": {"B": {"A": 0, "B": {"B": false, "F": "F"}, "C": {"C": true, "F": 9}}, "D": {"E": "F"}, "H": "H"}, "J": null}}, "F": [{"J": true}]}], [{"B": {"E": false, "F": null, "I": {"E": [{"E": "H", "J": {"E": "C"}}, {"C": {"B": false}, "J": [null, false]}], "I": 1}}, "D": {"A": [7, {"C": true, "G": [false], "H": "D"}]}}, 6, 5]], "E": {"A": {"G": {"A": {"E": true}}, "I": false}, "I": true}, "G": {"H": {"E": {"H": true}}}}, "H": {"D": "I", "E": 4}}}}}}, "I": "C"}]}, {"C": {"D": {"D": {"B": [false, {"D": {"A": "D", "F": "G", "J": "D"}}, null], "E": {"E": "G", "F": true}, "G": {"I": {"A": {"C": "G"}, "B": {"C": [{"B": {"B": ["A"], "F": {"A": {"E": {"D": {"E": false, "F": null, "I": {"J": "D"}}}}, "G": 0, "J": false}, "J": "E"}}], "F": null, "G": {"A": {"A": true, "B": {"H": 3, "I": [8, {"A": {"B": {"B": {"B": true, "H": true}}}, "G": {"F": {"A": [true, "D", {"F": "A", "H": {"F": {"J": [{"B": false, "G": null, "I": {"H": ["J", {"G": [true, true]}, false]}}, {"D": {"D": {"G": true, "J": null}, "G": {"C": false}}}]}}}], "D": {"E": false, "G": false, "J": "A"}}}}, true]}, "G": {"F": {"B": null, "C": {"C": {"F": 4}, "H": ["J", "G"]}, "E": [true, [{"D": {"A": null, "F": {"B": "C", "C": null, "J": 4}}, "E": null, "I": {"B": true, "G": {"C": {"A": [{"D": false, "G": true, "I": {"G": [3], "I": true}}, "B"], "B": {"A": null, "H": null, "I": {"D": "H", "G": null}}, "F": [{"I": false}, [["F", false], [{"A": {"C": [{"C": null, "D": [true], "E": {"H": 6}}], "G": false}, "J": [[[4, null, "J"]]]}, "E", true], {"F": 8, "G": null}], "F"]}, "G": [{"H": {"G": {"A": true}}}, 3, {"E": {"E": [true, true], "H": [{"I": "G", "J": {"C": 3, "E": {"A": false, "G": [{"J": {"B": {"B": "D", "C": 0}, "C": [[{"A": null}, null, {"B": {"G": null, "H": {"F": {"A": {"D": {"D": 3}}, "B": "E", "G": null}}}, "D": {"H": {"C": {"F": [true]}, "F": null, "J": true}}}], 3, [false, 7, null]], "H": {"C": {"D": {"E": null, "G": null}}, "E": "A", "G": [true, "A", "G"]}}}, null], "J": {"A": true, "D": "H", "H": {"E": {"D": {"A": {"J": [false, {"G": {"F": "A", "G": 5}}, {"A": {"A": false, "G": null, "J": {"I": [{"C": false, "H": {"A": "E", "D": 8, "G": {"B": true, "D": {"A": true, "E": false, "H": null}}}}, {"D": {"D": {"A": true}, "I": {"D": null, "F": 4, "I": {"D": {"C": [{"F": null, "H": "F"}, null], "E": {"D": {"G": 2}, "G": {"A": {"B": false}}, "H": {"D": "C", "H": null, "J": true}}}, "H": [null, [true, {"C": {"E": {"J": {"C": {"F": {"J": {"A": [0, {"C": {"B": {"B": [3], "G": [["A", true, {"A": {"E": true}}], null]}}, "E": "B"}], "C": 7, "I": {"B": {"F": 4, "I": {"A": {"A": true, "B": 5, "E": [{"H": "C"}]}, "E": "B"}}}}}, "I": false}, "J": false}}}}, true]], "J": null}}}, "E": true}]}}, "H": 0, "I": {"B": null}}]}, "D": [null, {"F": null}]}, "G": {"C": {"C": 8, "G": [true, {"D": null}, 7], "H": true}, "I": false}}, "I": {"D": false}}}}, "J": null}}, 8, {"B": 5, "E": false}]}, "G": true}]}}}]]}}}, "H": "H", "J": {"A": {"D": ["G", {"H": {"A": ["D", {"A": 7, "I": [{"D": false}, {"J": true}]}], "B": [[false]], "I": [true, {"I": {"D": [null, {"A": 5, "I": false, "J": {"E": {"A": 9, "D": {"E": {"E": {"C": false, "F": [true, {"C": {"C": {"B": false, "G": "B", "I": 9}, "J": "H"}}]}}, "G": 1}, "I": 3}, "I": {"E": false}}}, true], "G": {"B": true}, "I": true}}, {"I": {"D": "J"}}]}}, {"E": ["A"], "F": false, "H": {"F": {"E": {"B": null, "C": 4, "E": {"A": 4, "I": "F"}}, "F": {"A": 4, "D": {"A": {"B": {"F": 9, "H": true}, "H": [{"A": true}, null]}, "F": null, "G": 8}, "I": true}, "I": {"E": {"A": {"D": true, "F": {"B": null, "H": {"E": false}}}, "B": true}, "G": [2]}}}}], "I": {"E": {"E": null, "F": false, "I": {"A": {"A": {"H": null, "J": true}, "B": "E"}, "G": {"D": "E", "E": null}}}, "G": {"F": "D"}}, "J": {"H": {"H": [[false, [false, true, 1], {"I": {"A": 0, "B": {"F": null}, "C": false}}], true], "J": {"B": 8}}, "I": [null, true]}}, "C": "E"}}}}}}}}}], "F": null}}], null], "J": {"D": false, "E": {"G": {"F": "I", "J": {"B": [["F", [false, null], 0]], "F": {"E": true}}}, "H": false, "J": null}}}, "J": {"D": "I", "H": "D"}}}}, "D": {"A": 7, "E": false, "F": false}, "I": {"D": [null, {"G": null}, 0], "H": null}}, "B"], true, "C"]}, "F": [1]}}}}}, "J": {"D": {"A": {"B": {"H": false}, "D": {"B": {"I": {"G": {"C": 5, "F": {"B": null, "I": {"G": {"C": {"H": false, "I": {"J": {"E": true, "F": {"F": null}, "J": {"D": {"E": {"D": {"D": "E", "G": {"C": {"G": {"B": true, "C": {"A": {"A": "A", "D": true, "E": null}, "D": {"C": "J", "D": {"F": true}, "I": false}}, "E": true}, "I": null}, "H": null, "J": "I"}, "J": null}, "I": [null, [false, true]], "J": {"F": null}}, "G": null, "J": {"B": 7, "I": null}}, "H": {"F": true}}}}, "J": true}, "F": [{"E": false, "I": {"D": null, "I": {"A": {"A": 5, "E": {"C": {"C": {"E": true, "F": [true]}, "F": "I", "H": {"H": {"G": {"H": true}, "H": true, "J": null}}}}}}}}]}}}, "I": {"C": {"B": {"D": [null, {"I": null}]}, "D": {"B": true, "C": "F", "G": null}}, "F": true}}}}, "D": {"H": {"A": {"C": null, "J": null}, "I": null}}, "G": null}}, "D": {"B": {"F": {"D": {"B": {"B": false, "C": "G", "J": [5, {"D": ["I", {"C": {"A": {"E": {"J": {"A": false, "C": 5}}}, "G": true, "H": {"I": {"E": true}}}, "J": {"J": true}}, false], "E": {"B": {"I": {"A": 2, "D": {"D": "A", "H": {"F": "B"}}}}, "D": {"E": {"H": {"A": {"B": false}, "E": "D", "J": null}}}}}]}, "I": {"H": 0}}, "E": true, "F": "I"}}}}}}}}}, "H": 7}]]}}}, {"A": {"J": {"F": {"C": {"B": true, "C": false, "I": 1}, "E": "H", "G": null}}}, "B": ["D", false]}]}, "F": "G"}, "F": true, "I": {"E": {"B": {"G": null}, "C": true}, "F": false}}}, [5, {"B": "B", "C": {"A": true, "F": {"I": 2}, "J": null}}, true]]}}}, "F": {"B": "I", "C": false, "I": true}}}, "H": "B"}}}, "J": {"D": true, "E": {"A": {"A": null, "B": [{"J": null}]}, "G": ["B"], "I": 5}}}}, "C": [4, false, false], "D": {"D": true, "H": {"D": true}}}':::JSONB::JSONB,
        test_1        |                             '{"C": 3, "D": 1}':::JSONB::JSONB
        test_1        |                         )
        test_1        |                             AS col250213
        test_1        |                 )
        test_1        |                     AS tab171186
        test_1        |             ORDER BY
        test_1        |                 col250213 ASC
        test_1        |         compare_test.go:213: cockroach1: ping: conn closed
        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:125: exit status 1
--- FAIL: TestComposeCompare (1047.69s)
Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ d43afb2dbde0658d1dabb7b576f0e5afe149a672:

        postgres_1    |             WHERE
        postgres_1    |                 NULL::BOOL
        postgres_1    |         )
        postgres_1    |             AS "tab\\x20377778"
        postgres_1    |     ORDER BY
        postgres_1    |         col613004 DESC NULLS FIRST, col613005 DESC, "col%47613006" NULLS LAST, "col'613007", "coL613008" NULLS LAST
        test_1        | --- FAIL: TestCompare (1097.31s)
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (493.07s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare1692911072/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:203: compare postgres to cockroach1: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   int16(4052),
        test_1        |             +   int16(4051),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT int2(int4(cosh(9.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT4::INT4)::INT2 AS "c%qo'l613056")
        test_1        |                     AS "*tab377799"
        test_1        |             ORDER BY
        test_1        |                 "c%qo'l613056" ASC;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT int2(int4(cosh(9.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT4::INT4)::INT2 AS "c%qo'l613056")
        test_1        |                     AS "*tab377799"
        test_1        |             ORDER BY
        test_1        |                 "c%qo'l613056" ASC;
        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:125: exit status 1
--- FAIL: TestComposeCompare (1123.88s)
Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ ee3495831f15ed85eeb8604c96e48b4f112b4f22:

        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.01s)
        test_1        |         compare_test.go:141: 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 192 [running]:
        test_1        | testing.tRunner.func1.2({0x2299d40, 0xc000d952e0})
        test_1        |     GOROOT/src/testing/testing.go:1545 +0x238
        test_1        | testing.tRunner.func1()
        test_1        |     GOROOT/src/testing/testing.go:1548 +0x397
        test_1        | panic({0x2299d40?, 0xc000d952e0?})
        test_1        |     GOROOT/src/runtime/panic.go:914 +0x21f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x4771900?, {0x3286938?, 0xc001063aa0?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:377 +0x436
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x3244d60?, 0x4771900)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:310 +0x12c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc000d4ef00)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:227 +0x7f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc000d20150, {0xc000d20180?, 0x3, 0xc000d20150?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:260 +0x89d
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0x2099160?, 0x249fe2b?, {0xc000d20180?, 0x4aa4cc8?, 0x2?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:98 +0x28
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0xc0008ecae0?, {0x249fe2b, 0x5}, 0x3, 0x60?, {0xc000b09a40, 0x3, 0x7fb371ce6f18?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/schema.go:93 +0x131
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTablesN(0xc000945cc8?, 0x1?, {0x0, 0x0})
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:118 +0x15e
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc000032a00?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:98 +0x2f
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.init.wrapCommonSetup.func28(0x26c28d8?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:51 +0x1b
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc000b871e0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:143 +0xe2
        test_1        | testing.tRunner(0xc000b871e0, 0xc000d200c0)
        test_1        |     GOROOT/src/testing/testing.go:1595 +0xff
        test_1        | created by testing.(*T).Run in goroutine 8
        test_1        |     GOROOT/src/testing/testing.go:1648 +0x3ad
        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:125: exit status 2
--- FAIL: TestComposeCompare (20.04s)
Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ ee3495831f15ed85eeb8604c96e48b4f112b4f22:

        test_1        |                     "2D77EDF0992C400000000000000000",
        test_1        |                 }, ""),
        test_1        |                 nil,
        test_1        |                 s"7",
        test_1        |                 &net.IPNet{IP: s"::4", Mask: s"00000000000000000000000000000000"},
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makepoint(COALESCE(cotd(4.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8, 6.0:::FLOAT8::FLOAT8)::FLOAT8, float8(int4(B'0111'::BIT::BIT)::INT4::INT4)::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS col545127,
        test_1        |                         st_difference(NULL::GEOMETRY::GEOMETRY, NULL::GEOMETRY::GEOMETRY)::GEOMETRY AS col545128,
        test_1        |                         (8:::DECIMAL::DECIMAL::DECIMAL - 1:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL AS "!col545129",
        test_1        |                         '::4/0':::INET::INET AS col545130
        test_1        |                 )
        test_1        |                     AS tab288887
        test_1        |             ORDER BY
        test_1        |                 col545127 NULLS LAST, col545128 DESC, "!col545129" ASC NULLS LAST, col545130 ASC NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makepoint(COALESCE(cotd(4.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8, 6.0::FLOAT8::FLOAT8)::FLOAT8, float8(int4(B'0111'::BIT::BIT)::INT4::INT4)::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS col545127,
        test_1        |                         st_difference(NULL::GEOMETRY::GEOMETRY, NULL::GEOMETRY::GEOMETRY)::GEOMETRY AS col545128,
        test_1        |                         (8::DECIMAL::DECIMAL::DECIMAL - 1::DECIMAL::DECIMAL::DECIMAL)::DECIMAL AS "!col545129",
        test_1        |                         '::4/0'::INET::INET AS col545130
        test_1        |                 )
        test_1        |                     AS tab288887
        test_1        |             ORDER BY
        test_1        |                 col545127 NULLS LAST, col545128 DESC, "!col545129" ASC NULLS LAST, col545130 ASC NULLS FIRST;
        test_1        |             
        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:125: exit status 1
--- FAIL: TestComposeCompare (1061.35s)
Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ 1898adc059e9b3026fd5a7ed88dc41cbb006abfc:

        test_1        |                             AS "\\U000376BBt%pab165988" (c🙁ol309298)
        test_1        |                     WHERE
        test_1        |                         (true::BOOL AND true::BOOL)
        test_1        |                     ORDER BY
        test_1        |                         "\\U000376BBt%pab165988".c🙁ol309298
        test_1        |                 )
        test_1        |                     AS " t(ab165989"
        test_1        |             ORDER BY
        test_1        |                 col309299 NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         "\\U000376BBt%pab165988".c🙁ol309298 AS col309299
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 ('2000-01-01 01:00:00'::TIMESTAMP::TIMESTAMP),
        test_1        |                                 ('2000-01-01 05:00:00'::TIMESTAMP::TIMESTAMP),
        test_1        |                                 ('2000-01-01 09:00:00'::TIMESTAMP::TIMESTAMP),
        test_1        |                                 (
        test_1        |                                     make_timestamp(9::INT8::INT4::INT4, 9::INT8::INT4::INT4, 1::INT8::INT4::INT4, int4(8::DECIMAL::DECIMAL::DECIMAL)::INT4::INT4, 8::INT8::INT4::INT4, 0.0::FLOAT8::FLOAT8::FLOAT8)::TIMESTAMP
        test_1        |                                 ),
        test_1        |                                 ('2000-01-01 07:00:00'::TIMESTAMP::TIMESTAMP)
        test_1        |                         )
        test_1        |                             AS "\\U000376BBt%pab165988" (c🙁ol309298)
        test_1        |                     WHERE
        test_1        |                         (true::BOOL AND true::BOOL)
        test_1        |                     ORDER BY
        test_1        |                         "\\U000376BBt%pab165988".c🙁ol309298
        test_1        |                 )
        test_1        |                     AS " t(ab165989"
        test_1        |             ORDER BY
        test_1        |                 col309299 NULLS LAST;
        test_1        |             
        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:125: exit status 1
--- FAIL: TestComposeCompare (964.66s)
Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ c24aedd67a89ea14e91b085d37103127d693aa1a:

        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare192320318/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:203: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   int32(1),
        test_1        |             +   int32(2),
        test_1        |                 nil,
        test_1        |                 nil,
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         int4(asinh(3.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT4 AS "c ol%16666057",
        test_1        |                         NULL::rand_typ_1 AS "c  O l666058",
        test_1        |                         NULL::rand_typ_1 AS """col666059"
        test_1        |                 )
        test_1        |                     AS tab431980
        test_1        |             ORDER BY
        test_1        |                 "c ol%16666057" DESC NULLS FIRST, "c    O l666058" DESC NULLS FIRST, """col666059" DESC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         int4(asinh(3.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT4 AS "c ol%16666057",
        test_1        |                         NULL::rand_typ_1 AS "c  O l666058",
        test_1        |                         NULL::rand_typ_1 AS """col666059"
        test_1        |                 )
        test_1        |                     AS tab431980
        test_1        |             ORDER BY
        test_1        |                 "c ol%16666057" DESC NULLS FIRST, "c    O l666058" DESC NULLS FIRST, """col666059" DESC;
        test_1        |             
        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:125: exit status 1
--- FAIL: TestComposeCompare (1166.84s)
Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on master @ 3c837c2a86165188a26e8629b7e21b7ae0fb56ae:

        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (3:::INT8::INT2),
        test_1        |                                 (4:::INT8::INT2),
        test_1        |                                 (9:::INT8::INT2),
        test_1        |                                 (8:::INT8::INT2),
        test_1        |                                 (int2(atand(6.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT2),
        test_1        |                                 (7:::INT8::INT2)
        test_1        |                         )
        test_1        |                             AS tab53956 (col103926)
        test_1        |                 )
        test_1        |                     AS t😪ab53957
        test_1        |             ORDER BY
        test_1        |                 co😃l103927 NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab53956.col103926 AS co😃l103927
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (3::INT8::INT2),
        test_1        |                                 (4::INT8::INT2),
        test_1        |                                 (9::INT8::INT2),
        test_1        |                                 (8::INT8::INT2),
        test_1        |                                 (int2(atand(6.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT2),
        test_1        |                                 (7::INT8::INT2)
        test_1        |                         )
        test_1        |                             AS tab53956 (col103926)
        test_1        |                 )
        test_1        |                     AS t😪ab53957
        test_1        |             ORDER BY
        test_1        |                 co😃l103927 NULLS LAST;
        test_1        |             
        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:125: exit status 1
--- FAIL: TestComposeCompare (711.86s)
Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ 3c837c2a86165188a26e8629b7e21b7ae0fb56ae:

Fatal error:

panic: test timed out after 29m57s
running tests:
    TestComposeCompare (29m57s)

Stack: 

goroutine 37 [running]:
testing.(*M).startAlarm.func1()
    GOROOT/src/testing/testing.go:2259 +0x3b9
created by time.goFunc
    GOROOT/src/time/sleep.go:176 +0x2d
Log preceding fatal error

``` === RUN TestComposeCompare ```

Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ 585ffa0acfa6dd771aad8320d3a9e219acf56656:

Fatal error:

panic: test timed out after 29m57s
running tests:
    TestComposeCompare (29m57s)

Stack: 

goroutine 26 [running]:
testing.(*M).startAlarm.func1()
    GOROOT/src/testing/testing.go:2259 +0x3b9
created by time.goFunc
    GOROOT/src/time/sleep.go:176 +0x2d
Log preceding fatal error

``` === RUN TestComposeCompare ```

Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ e0fbbe4c1334580bf05d6d6fb0d406a327e43944:

Fatal error:

panic: test timed out after 29m57s
running tests:
    TestComposeCompare (29m57s)

Stack: 

goroutine 13 [running]:
testing.(*M).startAlarm.func1()
    GOROOT/src/testing/testing.go:2259 +0x3b9
created by time.goFunc
    GOROOT/src/time/sleep.go:176 +0x2d
Log preceding fatal error

``` === RUN TestComposeCompare ```

Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ e996b2f9587ec45bc2e419603ea95b86b4d1e379:

        postgres_1    | .2024-01-25 06:21:08.558 UTC [50] LOG:  aborting any active transactions
        postgres_1    | 2024-01-25 06:21:08.560 UTC [50] LOG:  background worker "logical replication launcher" (PID 57) exited with exit code 1
        postgres_1    | 2024-01-25 06:21:08.562 UTC [52] LOG:  shutting down
        postgres_1    | 2024-01-25 06:21:08.658 UTC [50] LOG:  database system is shut down
        test_1        | I240125 06:21:08.714756 10 testutils/soon.go:42  [-] 1  SucceedsSoon: failed to connect to ``host=postgres user=postgres database=postgres``: dial error (dial tcp 172.18.0.4:5432: connect: connection refused)
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2024-01-25 06:21:08.778 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    | 2024-01-25 06:21:08.778 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2024-01-25 06:21:08.778 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2024-01-25 06:21:08.781 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2024-01-25 06:21:08.785 UTC [69] LOG:  database system was shut down at 2024-01-25 06:21:08 UTC
        postgres_1    | 2024-01-25 06:21:08.790 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2024-01-25 06:21:10.605 UTC [79] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2024-01-25 06:21:10.605 UTC [79] STATEMENT:  CREATE TABLE "tab_""le1" ("co l\\uBE0A1_0" UUID NULL, "col%p1_1" UUID[] NOT NULL, col1_2 INT4 NOT NULL, col1_3 BOOL NOT NULL, col1_4 INT8 NOT NULL, col1_5 GEOGRAPHY NOT NULL, "col 1_6" INT2 NOT NULL, "col1_,7" GEOMETRY NOT NULL, "c�ol1_8" TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST("col1_,7" AS TEXT))) STORED, "%pcol1_9" INT8 NOT NULL GENERATED ALWAYS AS (("col 1_6" + col1_4) + col1_2) STORED, PRIMARY KEY (col1_2));
        postgres_1    |     CREATE INDEX ON "tab_""le1" ((col1_2 + "col 1_6"), col1_2 ASC);
        postgres_1    |     CREATE UNIQUE INDEX ON "tab_""le1" (col1_2 ASC);
        postgres_1    |     CREATE INDEX ON "tab_""le1" ("col%p1_1" ASC, col1_3 DESC, (CASE WHEN "col%p1_1" IS NULL THEN e'\x12P``_'::TEXT ELSE e'\x00'::TEXT END), "col 1_6" DESC, "%pcol1_9" DESC, "co l\\uBE0A1_0" ASC) INCLUDE (col1_5, "col1_,7", "c�ol1_8");
        postgres_1    |     CREATE INDEX ON "tab_""le1" (col1_3 DESC) INCLUDE ("co l\\uBE0A1_0", "col%p1_1", col1_4, col1_5);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (606.09s)
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.88s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:172: CREATE TABLE "tab_""le1" ("co l\\uBE0A1_0" UUID NULL, "col%p1_1" UUID[] NOT NULL, col1_2 INT4 NOT NULL, col1_3 BOOL NOT NULL, col1_4 INT8 NOT NULL, col1_5 GEOGRAPHY NOT NULL, "col 1_6" INT2 NOT NULL, "col1_,7" GEOMETRY NOT NULL, "c�ol1_8" TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST("col1_,7" AS TEXT))) STORED, "%pcol1_9" INT8 NOT NULL GENERATED ALWAYS AS (("col 1_6" + col1_4) + col1_2) STORED, PRIMARY KEY (col1_2));
        test_1        |             CREATE INDEX ON "tab_""le1" ((col1_2 + "col 1_6"), col1_2 ASC);
        test_1        |             CREATE UNIQUE INDEX ON "tab_""le1" (col1_2 ASC);
        test_1        |             CREATE INDEX ON "tab_""le1" ("col%p1_1" ASC, col1_3 DESC, (CASE WHEN "col%p1_1" IS NULL THEN e'\x12P``_'::TEXT ELSE e'\x00'::TEXT END), "col 1_6" DESC, "%pcol1_9" DESC, "co l\\uBE0A1_0" ASC) INCLUDE (col1_5, "col1_,7", "c�ol1_8");
        test_1        |             CREATE INDEX ON "tab_""le1" (col1_3 DESC) INCLUDE ("co l\\uBE0A1_0", "col%p1_1", col1_4, col1_5);
        test_1        |             
        test_1        |         compare_test.go:173: 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_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:125: exit status 1
--- FAIL: TestComposeCompare (630.71s)
Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ b59a83a1cd31d8e00f39cf32b1cf99b41b96e28e:

Fatal error:

panic: test timed out after 29m57s
running tests:
    TestComposeCompare (29m57s)

Stack: 

goroutine 24 [running]:
testing.(*M).startAlarm.func1()
    GOROOT/src/testing/testing.go:2259 +0x3b9
created by time.goFunc
    GOROOT/src/time/sleep.go:176 +0x2d
Log preceding fatal error

``` === RUN TestComposeCompare ```

Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ 0baf22a03d5f55e2611701bc723e3e0b713ab051:

Fatal error:

panic: test timed out after 29m57s
running tests:
    TestComposeCompare (29m57s)

Stack: 

goroutine 35 [running]:
testing.(*M).startAlarm.func1()
    GOROOT/src/testing/testing.go:2259 +0x3b9
created by time.goFunc
    GOROOT/src/time/sleep.go:176 +0x2d
Log preceding fatal error

``` === RUN TestComposeCompare ```

Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ 0baf22a03d5f55e2611701bc723e3e0b713ab051:

        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (329.50s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare3260169580/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:203: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   string("E0"),
        test_1        |             +   string("E0.000000000000000"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         ('E':::STRING::STRING::STRING || sqrt(0:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::STRING
        test_1        |                             AS "cOl_245703"
        test_1        |                 )
        test_1        |                     AS tab_147004
        test_1        |             ORDER BY
        test_1        |                 "cOl_245703" ASC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         ('E'::TEXT::TEXT::TEXT || sqrt(0::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::TEXT
        test_1        |                             AS "cOl_245703"
        test_1        |                 )
        test_1        |                     AS tab_147004
        test_1        |             ORDER BY
        test_1        |                 "cOl_245703" ASC NULLS LAST;
        test_1        |             
        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:125: exit status 1
--- FAIL: TestComposeCompare (959.67s)
Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ ed3a25e3c9459cede2f80babbfc9d44a836b6c12:

Fatal error:

panic: test timed out after 29m57s
running tests:
    TestComposeCompare (29m57s)

Stack: 

goroutine 35 [running]:
testing.(*M).startAlarm.func1()
    GOROOT/src/testing/testing.go:2259 +0x3b9
created by time.goFunc
    GOROOT/src/time/sleep.go:176 +0x2d
Log preceding fatal error

``` === RUN TestComposeCompare ```

Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ cc4fdffa8532d16544c48ef036689763f737dc6b:

Fatal error:

panic: test timed out after 29m57s
running tests:
    TestComposeCompare (29m57s)

Stack: 

goroutine 23 [running]:
testing.(*M).startAlarm.func1()
    GOROOT/src/testing/testing.go:2259 +0x3b9
created by time.goFunc
    GOROOT/src/time/sleep.go:176 +0x2d
Log preceding fatal error

``` === RUN TestComposeCompare ```

Help

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

Same failure on other branches

- #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ fce4d4723519bc4ca6e9ef5da0ae19960c84752c:

Fatal error:

panic: test timed out after 29m57s
running tests:
    TestComposeCompare (29m57s)

Stack: 

goroutine 37 [running]:
testing.(*M).startAlarm.func1()
    GOROOT/src/testing/testing.go:2259 +0x3b9
created by time.goFunc
    GOROOT/src/time/sleep.go:176 +0x2d
Log preceding fatal error

``` === RUN TestComposeCompare ```

Help

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

Same failure on other branches

- #118616 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.1-rc] - #118615 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.15-rc] - #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ d272e9ef5589deff570efc023db6c70edfde311c:

        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | 2024-02-05 06:19:55.681 UTC [49] LOG:  received fast shutdown request
        postgres_1    | waiting for server to shut down....2024-02-05 06:19:55.683 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2024-02-05 06:19:55.685 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2024-02-05 06:19:55.686 UTC [51] LOG:  shutting down
        postgres_1    | 2024-02-05 06:19:55.775 UTC [49] LOG:  database system is shut down
        test_1        | I240205 06:19:55.780210 11 testutils/soon.go:42  [-] 1  SucceedsSoon: failed to connect to ``host=postgres user=postgres database=postgres``: dial error (dial tcp 172.18.0.3:5432: connect: connection refused)
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2024-02-05 06:19:55.803 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    | 2024-02-05 06:19:55.803 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2024-02-05 06:19:55.803 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2024-02-05 06:19:55.807 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2024-02-05 06:19:55.811 UTC [68] LOG:  database system was shut down at 2024-02-05 06:19:55 UTC
        postgres_1    | 2024-02-05 06:19:55.816 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2024-02-05 06:19:57.766 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2024-02-05 06:19:57.766 UTC [78] STATEMENT:  CREATE TABLE table_2 (col2__0 BOOL NOT NULL, col̅2__1 PG_LSN, "col�2__2" JSONB NOT NULL, col2__3 VARCHAR NOT NULL, col2__4 TEXT NOT NULL, col2__5 GEOGRAPHY NOT NULL, col2__6 "char" NOT NULL, "coL2__7" REGTYPE NULL, col2__8 FLOAT8, col2͏__9 TEXT NOT NULL GENERATED ALWAYS AS (lower(col2__4)) STORED, "col2 __10" TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col2__0 AS TEXT))) STORED, col2__11 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col2__5 AS TEXT))) STORED, PRIMARY KEY (col2͏__9, col2__4, col2__3));
        postgres_1    |     CREATE UNIQUE INDEX ON table_2 ((CASE WHEN "coL2__7" IS NULL THEN e'\x00'::TEXT ELSE '4'::TEXT END) DESC);
        postgres_1    |     CREATE UNIQUE INDEX ON table_2 (lower(CAST("col�2__2" AS TEXT)), lower(col2__3) DESC);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (606.04s)
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.98s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:172: CREATE TABLE table_2 (col2__0 BOOL NOT NULL, col̅2__1 PG_LSN, "col�2__2" JSONB NOT NULL, col2__3 VARCHAR NOT NULL, col2__4 TEXT NOT NULL, col2__5 GEOGRAPHY NOT NULL, col2__6 "char" NOT NULL, "coL2__7" REGTYPE NULL, col2__8 FLOAT8, col2͏__9 TEXT NOT NULL GENERATED ALWAYS AS (lower(col2__4)) STORED, "col2 __10" TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col2__0 AS TEXT))) STORED, col2__11 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col2__5 AS TEXT))) STORED, PRIMARY KEY (col2͏__9, col2__4, col2__3));
        test_1        |             CREATE UNIQUE INDEX ON table_2 ((CASE WHEN "coL2__7" IS NULL THEN e'\x00'::TEXT ELSE '4'::TEXT END) DESC);
        test_1        |             CREATE UNIQUE INDEX ON table_2 (lower(CAST("col�2__2" AS TEXT)), lower(col2__3) DESC);
        test_1        |             
        test_1        |         compare_test.go:173: postgres: exec: ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:125: exit status 1
--- FAIL: TestComposeCompare (630.84s)
Help

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

Same failure on other branches

- #118616 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.1-rc] - #118615 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.15-rc] - #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ 715628abd134abfd2c0d966f9b7220a6715cc299:

        postgres_1    | 2024-02-06 06:19:25.611 UTC [50] LOG:  background worker "logical replication launcher" (PID 57) exited with exit code 1
        postgres_1    | 2024-02-06 06:19:25.613 UTC [52] LOG:  shutting down
        postgres_1    | 2024-02-06 06:19:25.703 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    | 2024-02-06 06:19:25.729 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    | 2024-02-06 06:19:25.729 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2024-02-06 06:19:25.729 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2024-02-06 06:19:25.731 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2024-02-06 06:19:25.736 UTC [69] LOG:  database system was shut down at 2024-02-06 06:19:25 UTC
        postgres_1    | 2024-02-06 06:19:25.740 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2024-02-06 06:19:27.300 UTC [79] ERROR:  invalid input syntax for type numeric: "-Infinity" at character 291
        postgres_1    | 2024-02-06 06:19:27.300 UTC [79] STATEMENT:  CREATE TABLE table_2 ("col2'__0" BIT(33) NOT NULL, col2__1 NAME NOT NULL, col2__2 UUID NOT NULL, col2__3 TSQUERY NULL, col2__4 BIT(37), col2__5 DECIMAL NOT NULL, "col2_""_6" TIMESTAMP NOT NULL, col2__7 BYTEA NOT NULL, col2__8 FLOAT4, col2__9 DECIMAL NOT NULL GENERATED ALWAYS AS (col2__5 + '-Infinity'::DECIMAL) STORED, col2__10 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST("col2'__0" AS TEXT))) STORED, "co%pl2'__11" TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col2_""_6" IS NULL THEN e'y\'Yl'::TEXT ELSE ''::TEXT END) STORED, PRIMARY KEY ("co%pl2'__11"));
        postgres_1    |     CREATE INDEX ON table_2 (col2__1 DESC, col2__9 DESC) INCLUDE (col2__2, col2__3, col2__7, col2__10);
        postgres_1    |     CREATE INDEX ON table_2 ((CASE WHEN col2__7 IS NULL THEN e'\x1eCf gla'::TEXT ELSE 'oY<;Mu0'::TEXT END));
        postgres_1    |     CREATE UNIQUE INDEX ON table_2 ("col2'__0", col2__2 DESC, lower(CAST(col2__4 AS TEXT)));
        postgres_1    |     CREATE INDEX ON table_2 (col2__4, col2__5);
        postgres_1    |     CREATE UNIQUE INDEX ON table_2 (col2__8 ASC, col2__10, col2__7 DESC, "col2'__0" DESC, col2__5 DESC, col2__4 ASC, "co%pl2'__11" ASC, "col2_""_6" ASC, col2__9 DESC, col2__1, col2__2 ASC);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (605.28s)
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     --- FAIL: TestCompare/postgres (0.83s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:172: CREATE TABLE table_2 ("col2'__0" BIT(33) NOT NULL, col2__1 NAME NOT NULL, col2__2 UUID NOT NULL, col2__3 TSQUERY NULL, col2__4 BIT(37), col2__5 DECIMAL NOT NULL, "col2_""_6" TIMESTAMP NOT NULL, col2__7 BYTEA NOT NULL, col2__8 FLOAT4, col2__9 DECIMAL NOT NULL GENERATED ALWAYS AS (col2__5 + '-Infinity'::DECIMAL) STORED, col2__10 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST("col2'__0" AS TEXT))) STORED, "co%pl2'__11" TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col2_""_6" IS NULL THEN e'y\'Yl'::TEXT ELSE ''::TEXT END) STORED, PRIMARY KEY ("co%pl2'__11"));
        test_1        |             CREATE INDEX ON table_2 (col2__1 DESC, col2__9 DESC) INCLUDE (col2__2, col2__3, col2__7, col2__10);
        test_1        |             CREATE INDEX ON table_2 ((CASE WHEN col2__7 IS NULL THEN e'\x1eCf gla'::TEXT ELSE 'oY<;Mu0'::TEXT END));
        test_1        |             CREATE UNIQUE INDEX ON table_2 ("col2'__0", col2__2 DESC, lower(CAST(col2__4 AS TEXT)));
        test_1        |             CREATE INDEX ON table_2 (col2__4, col2__5);
        test_1        |             CREATE UNIQUE INDEX ON table_2 (col2__8 ASC, col2__10, col2__7 DESC, "col2'__0" DESC, col2__5 DESC, col2__4 ASC, "co%pl2'__11" ASC, "col2_""_6" ASC, col2__9 DESC, col2__1, col2__2 ASC);
        test_1        |             
        test_1        |         compare_test.go:173: postgres: exec: ERROR: invalid input syntax for type numeric: "-Infinity" (SQLSTATE 22P02)
        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_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:125: exit status 1
--- FAIL: TestComposeCompare (629.20s)
Help

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

Same failure on other branches

- #118616 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.1-rc] - #118615 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.15-rc] - #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ d7d442e4a3c9dca7e01c4c6f4f00e2f28faa4374:

        postgres_1    |             SELECT
        postgres_1    |                 NULL::REFCURSOR AS "_col._290017",
        postgres_1    |                 NULL::REFCURSOR AS "col�_290018",
        postgres_1    |                 "ta\gb_191080".col_2__1 AS 🙂col_290019,
        postgres_1    |                 "ta\gb_191080"."col2_ _2" AS col_290020
        postgres_1    |             FROM
        postgres_1    |                 postgres.public."Table_2" AS "ta\gb_191080"
        postgres_1    |             WHERE
        postgres_1    |                 false::BOOL
        postgres_1    |             ORDER BY
        postgres_1    |                 "ta\gb_191080"."%vcol2__0" NULLS FIRST
        postgres_1    |         )
        postgres_1    |             AS "ta&b_191081"
        postgres_1    |     ORDER BY
        postgres_1    |         "_col._290017" DESC NULLS FIRST, "col�_290018" DESC, 🙂col_290019 NULLS FIRST, col_290020 DESC NULLS FIRST
        postgres_1    | 2024-02-07 06:27:24.399 UTC [78] ERROR:  could not identify an ordering operator for type void at character 79
        postgres_1    | 2024-02-07 06:27:24.399 UTC [78] HINT:  Use an explicit ordering operator or modify the query.
        postgres_1    | 2024-02-07 06:27:24.399 UTC [78] STATEMENT:  SELECT * FROM (SELECT NULL::VOID AS "co l_290024") AS "t""ab_191085" ORDER BY "co l_290024" ASC
        test_1        | --- FAIL: TestCompare (1671.66s)
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     --- FAIL: TestCompare/postgres (1066.48s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:212: SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         '{"A": {"F": {"D": "E"}, "I": {"C": {"F": null}, "D": true, "J": {"D": null, "G": {"E": {"C": [{"J": [[null, null, {"A": "D", "B": "F"}], [null], {"G": {"A": true, "G": 0}, "J": 3}]}, {"D": {"C": true, "E": true, "G": {"C": [{"D": {"A": null, "D": null, "F": {"F": null, "G": "J"}}, "E": false, "F": false}, {"E": {"D": ["B"], "I": [null, {"B": {"B": {"E": {"A": 6, "C": [[{"B": {"C": {"A": {"C": null, "E": null, "H": 9}, "C": true}, "D": {"C": 3, "D": {"F": {"B": 4, "D": {"F": {"H": [{"H": null}]}}, "H": false}}, "J": false}}}], {"B": "F", "J": {"C": false}}], "H": {"D": {"D": {"D": {"B": {"H": 5}, "C": {"C": {"C": null, "E": "B"}, "E": null}, "J": {"D": ["C", [{"A": null, "E": "E"}, {"C": null}, 3]]}}}, "J": [{"D": {"G": {"C": {"B": {"E": "G", "G": {"F": {"E": {"H": {"A": "B", "G": {"A": 2}}}}}}, "G": null, "I": true}, "H": {"G": {"I": {"D": {"A": [0], "C": {"A": {"C": {"A": true, "D": {"G": null}}, "F": [{"F": false}, {"A": false, "C": {"F": null, "G": {"D": "A"}, "I": 2}, "H": {"B": {"C": {"E": {"B": {"D": false, "F": false}}, "J": [true]}}, "I": null}}, {"J": {"B": {"E": "C", "I": {"J": {"H": null}}}, "C": 4, "D": {"C": false, "G": false}}}], "H": {"H": {"B": 8}}}, "D": null, "G": [[{"I": true}], {"A": null, "H": {"A": false}}, true]}}, "J": true}, "J": 4}, "H": 0, "J": [{"D": false, "F": {"G": {"B": {"B": "I", "I": true, "J": "A"}, "H": true, "I": [{"H": false, "I": "I"}, true, {"A": {"C": true}}]}}}, "D", false]}}}, "G": true}, {"A": false, "B": 3, "E": {"C": {"B": null, "E": null}, "F": {"I": [3, false, null]}, "H": false}}, {"G": {"A": true, "I": null}}]}}}, "G": {"C": [{"B": {"F": {"C": {"A": {"A": true, "D": {"C": {"J": {"E": 4}}, "F": null, "G": 8}}, "F": "H", "I": true}, "H": "J"}, "J": "G"}, "D": 4, "G": false}, [[[{"F": {"G": {"C": false, "E": {"B": {"D": {"D": false, "F": true}, "H": null}, "G": null}}}, "G": {"E": false, "H": "G"}, "H": "G"}, [null, "A", {"F": {"E": {"E": {"F": {"C": {"C": {"G": {"G": true}}, "J": [false, 6, 4]}, "G": {"G": true}, "J": {"I": 2}}, "G": 9, "I": false}, "F": {"A": {"E": 4, "H": 2, "I": 2}, "C": {"E": ["F", {"B": true, "D": {"E": {"A": {"D": {"B": {"C": 8, "H": [9, {"G": {"B": true, "J": 8}}, {"B": {"D": [{"B": null}], "H": {"F": {"D": {"G": {"F": "G", "G": 0}, "I": {"H": true}, "J": {"D": 7, "J": [{"H": [{"H": 7}, "F"], "I": {"A": null}}, [true, false]]}}, "E": [7, {"G": true}, {"F": {"E": {"G": {"E": [true, [{"F": true, "G": [{"D": "F", "G": {"D": {"B": {"E": "C", "F": {"B": {"E": true, "G": {"G": 2}, "H": 4}, "F": "A", "J": [null, true, 5]}}, "I": true}, "H": {"H": "I", "J": {"C": null, "D": "I", "J": "H"}}, "J": 6}, "J": ["I", 4, {"B": {"C": null, "D": 5, "G": {"A": {"F": true, "G": 5}}}}]}, true]}, {"A": {"C": {"C": {"B": [{"D": false, "F": {"F": null, "J": [true, {"G": false, "I": [2, 4]}]}}, false], "E": "A", "J": null}}}, "B": false, "J": {"F": {"C": {"A": {"B": false, "D": false}, "E": "J"}, "E": {"B": {"A": false, "H": {"B": true, "E": 4}, "J": {"E": {"G": null, "H": 0}, "H": {"D": true, "H": {"B": {"B": {"B": true}, "F": 1, "I": {"A": {"B": {"J": [{"C": true, "E": "H", "I": false}, [null, null]]}, "C": "C"}, "F": 5}}, "C": {"C": [{"E": {"A": {"I": null}}}, {"A": {"C": 9, "H": {"B": [null, "F", {"A": null}], "E": null, "H": {"A": true, "F": [{"D": true, "I": {"B": {"B": true, "I": "B"}, "E": {"F": [true], "I": {"E": "J", "I": {"B": [{"E": "B", "H": true}, {"C": true, "F": {"I": true}, "H": {"J": null}}, false], "G": "E"}}}}}]}}}, "F": 0}]}}, "I": {"A": 3, "B": {"G": {"D": {"C": "J", "J": {"B": {"B": {"H": true}, "E": {"E": false, "F": null}, "J": null}, "E": {"E": [null, true, null], "G": {"C": false, "J": true}, "J": false}}}, "I": {"D": "B", "G": 0, "H": [{"C": [[{"A": {"F": {"A": {"J": {"I": "D"}}, "D": {"J": {"D": true, "G": [null, false, 1]}}, "J": {"B": true}}}}, true], 4, "A"], "J": {"B": false, "C": null, "D": [{"H": [[false, 6, "G"]], "J": null}, null, true]}}]}}}}}}}, "H": 8, "I": false}}}}, [{"A": {"A": false, "E": {"A": false, "B": {"E": {"J": {"B": 7, "C": {"C": false}, "D": {"E": {"B": null, "C": {"G": {"E": null, "I": [{"C": {"C": {"C": {"H": 8}, "F": 9, "J": [{"F": {"A": null, "B": {"F": "F", "G": {"B": {"I": [{"B": 7, "D": 6, "E": 8}, {"E": [{"G": {"A": 2, "J": null}}, false], "F": true}, {"D": {"G": {"C": true, "E": {"C": {"B": 3, "J": 9}, "E": false}, "G": 5}}, "F": true}]}, "H": null}}, "J": 4}, "J": {"J": null}}, {"J": null}]}, "E": 3, "J": {"D": {"D": {"D": 9}, "E": true, "I": {"B": 8, "I": {"B": 4, "E": [[9]], "J": {"E": {"D": 7}}}}}, "E": null, "I": [{"E": {"H": "C"}, "J": [{"E": null, "I": {"D": 4, "I": {"D": {"A": {"D": [[[[true], true], false, true], {"H": [null]}, null], "E": false, "H": 1}, "C": {"E": null, "F": {"G": true, "J": 2}, "H": false}, "J": "H"}, "H": "J"}, "J": {"B": {"C": {"A": "J"}, "H": 6}, "J": {"C": null}}}}, true, {"E": null, "J": {"F": {"B": 1, "C": true}}}]}]}}, "I": true}, {"C": {"B": {"F": {"F": {"D": null, "E": false, "I": [{"G": [{"F": true}]}, true, 0]}, "G": {"H": null}}, "I": true}, "G": [{"E": false}, 0]}}, [[{"F": {"C": false, "I": {"A": {"B": {"I": {"E": "C", "I": [[true, "B", {"A": {"H": {"D": false, "F": ["J", true]}}, "B": {"F": true}, "G": 8}]]}}, "H": {"G": [false, null], "H": {"H": {"I": {"A": {"A": null, "D": true, "E": [{"F": true, "H": "H"}, false]}, "B": null, "G": true}}, "J": {"G": [null, 0, [2, "B"]]}}}}, "F": null}, "J": {"D": {"B": {"C": {"I": {"J": true}}, "H": {"B": {"A": ["E"], "F": null}, "E": [2], "G": {"J": true}}}, "C": [true, true], "E": [true, false]}, "F": {"C": "B"}}}, "I": null}, {"D": 3, "I": null}, {"B": false, "D": true, "E": false}]]]}, "I": {"B": {"B": false, "I": true}}}, "H": false}}}}}, "C": false}}}, true, {"A": "B", "F": {"B": null, "E": {"J": "D"}}, "J": {"E": {"B": [0, false]}, "J": {"B": 6, "C": {"G": {"B": 2, "E": 8}}}}}]]], "J": false}}, "H": true}}], "H": {"D": true, "G": {"A": 2, "F": null, "I": null}}}}, "I": {"F": {"B": {"E": true, "J": null}, "G": {"J": {"B": {"C": false}, "J": true}}}}}}]}}, "J": null}, "I": {"C": null}}, "F": {"A": [{"C": {"D": {"G": "B"}, "J": {"D": 9}}, "D": null}, {"E": true, "J": 2}], "B": 1, "E": 0}, "I": true}, "G": {"F": null, "H": {"E": null, "I": false}}}, false], "I": "E", "J": {"A": [{"A": 1, "C": "H"}, {"A": [true, "E"], "I": {"G": {"D": "A", "I": {"B": "D"}}}}], "B": {"D": {"G": {"E": {"B": {"A": true, "B": 3}, "F": null, "H": {"J": [{"B": "H", "D": [{"I": 8}, null], "E": false}, {"E": 3}, true]}}, "G": [null, true]}}}, "D": "A"}}}}, "F": true, "J": "H"}}]], {"D": {"I": true}, "I": "A", "J": 4}], {"F": "F", "H": {"C": false, "F": {"D": false, "J": {"A": null, "G": true, "H": true}}}}, false], true], "F": null}, "H": [null, false, true]}}, "J": 4}, false]}}, 1], "D": {"A": {"C": false, "D": [null, true]}, "C": {"D": {"A": [true]}}, "E": {"A": {"B": null, "G": {"D": "I", "E": ["G", [{"F": false, "I": {"B": [{"I": [["G", false, true], false, {"A": {"F": null, "I": false}, "B": "B"}]}], "I": 1}}, [{"J": {"A": {"B": {"B": {"A": "B"}, "H": {"A": [{"A": {"B": null, "C": [{"B": null}, null], "E": [false, false]}, "B": 2}, "C"], "C": true, "D": {"B": {"D": false, "I": "C"}}}, "J": {"A": {"B": {"G": {"C": null, "E": {"B": [{"A": "E", "D": null, "E": false}, false, null], "G": {"B": false}, "H": [[true], {"A": 8, "E": {"D": {"J": null}, "I": [false]}}, false]}, "I": {"F": "E"}}, "H": [{"A": {"E": "C", "J": true}}, [2]], "I": {"F": true, "G": {"F": {"A": 0, "B": {"A": {"C": [{"B": {"H": {"F": {"I": {"H": false}}}, "J": {"B": null, "F": {"B": {"C": true, "D": "F"}, "G": true}}}}, "C", {"B": 5, "F": false}], "J": "I"}, "D": {"B": "B"}}, "F": 0}, "G": [{"C": true, "D": {"A": {"E": false, "H": true, "J": {"C": true, "I": null}}, "D": 3}, "G": {"F": {"H": {"A": {"F": {"A": {"B": [{"A": true, "G": false, "H": {"E": [[true, "C", {"A": [{"E": null}, null], "E": null, "J": ["B", {"A": {"A": true, "E": "H", "H": "D"}, "C": {"E": true, "G": "B"}}]}], null]}}], "E": false}, "G": true, "J": false}, "G": 8, "H": true}, "G": false, "J": {"B": true, "F": null}}}, "H": {"A": true, "D": "I"}}}, null, 5], "H": 8}, "H": 7}}, "I": [{"F": {"H": false}, "G": "D", "I": {"H": "B", "I": {"B": "G", "D": 8, "G": false}}}, {"B": {"C": "D", "D": ["J", "J"], "E": false}, "J": null}, 0]}, "I": false}}, "E": "D", "J": false}, "I": null}}, false, 9]], [2, [[0], [{"A": {"E": null}, "D": null, "F": {"D": [{"D": {"H": {"J": 9}, "I": {"A": {"C": null, "D": [{"H": false, "J": "I"}, "I", true]}, "E": false, "H": {"E": 0, "F": true, "H": {"A": false, "C": false}}}}, "F": false}], "E": true, "G": "C"}}]]]]}}, "G": {"A": false, "B": [{"A": true, "B": {"E": true, "I": {"C": [{"J": null}]}, "J": [{"J": "I"}, {"G": {"E": false, "I": null}}]}, "H": "D"}], "I": [true, {"F": {"E": true, "I": "G", "J": true}, "H": null, "I": 2}, {"G": {"A": false, "F": {"A": true, "E": {"C": false, "H": {"A": true, "J": ["B", {"A": {"A": {"A": {"I": "D"}, "D": {"B": {"F": {"C": false, "H": true}}, "C": null, "F": {"B": true}}}, "J": [true, [{"H": null}]]}, "B": {"E": true, "J": 2}, "I": {"E": {"I": null}}}, {"G": true}]}}, "H": ["E", "J"]}}, "I": true}]}, "J": 7}}}}, "G": [{"C": {"H": "I", "I": {"D": false}}, "F": {"F": {"C": "B", "D": {"H": 0}}, "H": {"C": false, "D": {"G": true, "J": "D"}}}, "G": false}, {"G": "B"}, {"A": {"F": null, "J": {"B": null}}, "D": true, "J": {"D": null, "H": {"A": false, "C": "F"}, "I": {"E": {"D": {"A": "D", "I": [[{"F": null}, {"B": 1, "E": null, "H": {"H": {"E": {"D": false, "F": null, "G": 8}}}}, null]], "J": {"A": {"A": {"E": false, "G": true}, "E": 0, "H": ["D", {"H": {"D": {"F": {"B": 3}, "H": 7, "I": {"G": {"B": {"C": "I", "J": {"C": true}}, "J": [null]}}}, "J": [{"C": "D", "E": {"C": {"B": {"A": [null, true], "B": 9, "H": "H"}, "G": ["B"]}, "D": null, "J": {"I": false}}}]}}, 5]}, "I": [null]}}, "H": {"H": 9, "I": [null, "B", {"A": false}]}}}}}]}, true]}}, "I": "J"}}, "J": null}, "C": true, "G": {"A": false}}':::JSONB::JSONB
        test_1        |                             AS "c.ol_290028"
        test_1        |                 )
        test_1        |                     AS tab_191092
        test_1        |             ORDER BY
        test_1        |                 "c.ol_290028" ASC NULLS LAST
        test_1        |         compare_test.go:213: cockroach1: ping: conn closed
        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:125: exit status 1
--- FAIL: TestComposeCompare (1697.07s)
Help

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

Same failure on other branches

- #118616 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.1-rc] - #118615 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.15-rc] - #117263 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.14-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ 7042601857042a057b1d4676735576cfbd37f36a:

        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (367.56s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare2790500380/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:203: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   float32(0),
        test_1        |             +   float32(0.01519817765802145),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         ts_rank('''AImHEaq'' ''COUArOKSV'' ''DGC'':225A,565A,768A,928A,987C ''QLmY'':248A,391B,551B ''RNdJaWRXQ'' ''SVshUmqBsV'':491B,701A,967B ''i'' ''rqlGhQlAkB''':::TSVECTOR::TSVECTOR::TSVECTOR, '''RU'' <-> ''cPULysbdH'' | ''i'' & ''R''':::TSQUERY::TSQUERY::TSQUERY)::FLOAT4
        test_1        |                             AS col_600014
        test_1        |                 )
        test_1        |                     AS tab͗_317785
        test_1        |             ORDER BY
        test_1        |                 col_600014 NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         ts_rank('''AImHEaq'' ''COUArOKSV'' ''DGC'':225A,565A,768A,928A,987C ''QLmY'':248A,391B,551B ''RNdJaWRXQ'' ''SVshUmqBsV'':491B,701A,967B ''i'' ''rqlGhQlAkB'''::TSVECTOR::TSVECTOR::TSVECTOR, '''RU'' <-> ''cPULysbdH'' | ''i'' & ''R'''::TSQUERY::TSQUERY::TSQUERY)::FLOAT4
        test_1        |                             AS col_600014
        test_1        |                 )
        test_1        |                     AS tab͗_317785
        test_1        |             ORDER BY
        test_1        |                 col_600014 NULLS LAST;
        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:125: exit status 1
--- FAIL: TestComposeCompare (996.14s)
Help

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

Same failure on other branches

- #118616 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.1-rc] - #118615 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.15-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ 353fded9fe270b3eee4c85480ac1b9ec819f23b0:

        postgres_1    | 2024-02-09 06:31:55.398 UTC [99] STATEMENT:  SELECT
        postgres_1    |         *
        postgres_1    |     FROM
        postgres_1    |         (
        postgres_1    |             SELECT
        postgres_1    |                 7::INT8::INT4 AS col_124862,
        postgres_1    |                 "tAb_67074"."col%p1__0" AS """col_124863",
        postgres_1    |                 "tAb_67074".col1__1 AS "col'_124864",
        postgres_1    |                 "tAb_67074"."   col1__4" AS col_124865
        postgres_1    |             FROM
        postgres_1    |                 postgres.public.table_1 AS "tAb_67074"
        postgres_1    |             ORDER BY
        postgres_1    |                 "tAb_67074"."   col1__4" ASC
        postgres_1    |         )
        postgres_1    |             AS tab_67075
        postgres_1    |     ORDER BY
        postgres_1    |         col_124862 NULLS LAST, """col_124863" ASC, "col'_124864" DESC NULLS FIRST, col_124865 DESC NULLS LAST
        test_1        | --- FAIL: TestCompare (1204.89s)
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (601.00s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:212: SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         '{"H": {"A": 9, "G": [{"F": true, "I": {"D": {"A": {"B": {"C": {"D": true, "F": {"H": {"J": null}}, "I": 3}, "G": 8}, "C": {"E": [[[{"J": 8}], {"I": {"C": {"F": {"A": false}, "G": null}, "G": 1}}, true], false, {"D": {"A": 1, "C": null, "D": ["A", null]}, "J": false}], "F": 8}}, "G": [{"B": {"A": true, "B": {"D": 4, "I": [{"A": false, "C": ["J", {"B": {"H": "G", "I": {"B": {"B": true, "E": null, "G": true}}, "J": [{"H": true}]}}], "E": "H"}, {"H": 4}]}, "I": null}}, {"A": {"E": {"A": "A", "F": [{"A": true, "G": [[{"A": {"E": {"C": 2, "F": {"C": "H"}}}, "I": {"I": null}}], false], "I": "A"}, {"E": 2, "I": {"E": [{"B": {"D": true, "I": {"A": false}}}, {"A": null, "F": {"G": 5, "H": "H", "I": {"A": {"A": false, "F": {"A": true, "D": [{"E": true, "I": [{"B": {"F": {"F": ["A", 5], "J": 0}, "G": {"H": [{"C": {"A": {"A": true, "G": {"J": {"A": {"D": false, "G": [false]}}}, "I": {"I": {"D": {"E": {"G": {"B": "A", "C": [{"B": {"D": {"A": null, "I": [false, null, 8]}, "G": {"D": {"E": null, "H": {"D": 0}}}}}], "F": "F"}, "I": {"A": true, "H": {"F": "D"}}}, "I": false}, "H": [false], "J": {"F": {"A": {"A": true, "E": [{"E": "H", "I": [true]}, {"G": "C", "H": {"G": {"C": 5, "D": {"E": {"B": "B"}}, "I": false}}}]}, "G": false}, "G": "G"}}}}, "B": {"G": {"D": {"B": true}, "E": {"G": {"A": "C", "E": {"F": "A"}}, "H": {"J": 9}}}, "J": {"I": [{"A": true, "G": "A"}, {"F": {"E": {"A": {"F": {"H": null, "I": {"A": true, "J": {"D": {"B": true}, "G": false, "J": 6}}}}, "G": 6, "J": 6}}, "G": {"E": {"D": true, "J": {"E": null, "G": {"I": "J"}, "I": 4}}}, "I": "H"}, {"D": {"C": {"F": {"F": true}}, "J": {"A": {"D": {"B": {"B": true, "E": {"B": {"B": 2}, "G": {"A": {"B": {"F": null}}, "C": {"D": [null, "H"], "G": {"F": {"B": ["J"], "E": "I", "H": true}, "I": 6}}}, "J": false}, "G": "G"}, "F": true, "I": "B"}, "G": true, "J": "E"}, "E": 8, "F": true}}, "F": "D"}]}}, "G": {"D": 6, "F": true}}, "G": {"F": false}, "H": {"B": {"E": {"B": null}}, "C": null}}, {"G": {"A": true, "D": true, "J": {"G": null}}}, null]}, "I": {"G": 7}}, "C": {"C": {"B": {"A": {"A": {"C": true, "E": {"G": "E", "I": null}}, "G": ["D", [5, "D", [true, {"B": {"A": null, "G": false, "J": false}}, null]], [{"G": {"B": {"A": {"C": null, "E": true, "J": {"G": null}}, "F": [{"E": {"A": false}, "H": {"B": {"F": false}, "H": false}}, true], "I": {"D": false, "J": {"A": [{"H": {"C": null, "J": {"C": 4, "G": "C", "H": {"J": {"C": {"A": {"B": {"A": "F", "C": "C", "J": null}}, "I": false, "J": "B"}, "E": {"B": {"I": {"F": {"C": true, "D": false, "G": {"A": {"C": 0, "E": {"B": null, "J": {"B": null, "D": "H", "H": 3}}}, "B": {"C": 2}}}, "H": {"D": "C", "F": "F", "G": {"C": {"E": "F", "I": true, "J": "B"}, "G": false}}}}, "G": null, "J": true}}}}}}, true], "I": {"D": {"J": ["E", [2]]}}, "J": false}}}}, "H": 6}, null]], "I": null}, "G": false}, "G": null}, "I": {"D": [{"H": [{"A": {"I": [[{"E": {"E": [4, {"J": [{"F": [{"B": true}, {"F": {"B": {"C": 0}, "D": [null, {"C": 0, "H": {"A": {"A": [[[false]], false, "B"]}, "D": {"D": {"C": true, "D": null, "G": null}, "E": {"C": null, "E": true}, "I": {"C": {"J": {"D": {"A": false, "B": {"F": {"A": {"J": {"A": "J", "J": {"E": [9, 4], "F": [[[{"A": {"C": 1, "D": {"C": {"C": {"B": [{"I": 3}, {"A": {"E": {"E": {"I": false}, "I": "D"}, "J": {"J": true}}, "E": {"E": null, "G": "E"}, "J": "G"}], "F": "D"}}, "F": {"B": {"E": true, "I": {"I": 9}}, "I": "F", "J": false}, "I": 2}}, "F": {"C": false, "J": [false, "A", null]}}, false], {"J": {"I": false, "J": {"A": {"D": {"J": {"G": {"F": null, "I": null}}}, "I": ["I", true, null]}, "C": 3}}}, {"G": "D", "H": true, "I": [{"F": [{"C": {"J": [false, {"E": {"E": true, "F": "A"}}, 8]}, "J": {"F": "E"}}, 4, null]}, null, {"I": {"D": [{"B": {"E": null, "J": {"C": 9, "D": null, "G": null}}}, {"G": {"D": true}, "J": true}, 9], "F": {"A": null, "G": "J"}, "H": 1}}]}]]}}}, "B": true, "H": null}}, "D": "B"}, "F": null}}, "E": true}}, "I": [true]}}, null], "G": {"G": {"A": {"D": false, "G": "C"}}, "J": {"D": {"D": true}}}}, "G": {"B": "D"}}], "J": false}, {"G": null, "H": false}]}, true], "H": 9}, "I": "F"}, [{"B": true}, {"D": "C", "J": [{"A": true, "E": false}, null, {"C": true, "D": 1}]}, {"F": {"G": true}, "J": {"D": 5, "I": false}}]], {"C": null, "D": [8, {"I": {"B": {"A": [null, {"D": {"G": [{"C": {"F": {"C": true, "G": null, "J": 7}, "I": 4, "J": null}, "I": 4}, {"A": "F", "G": {"C": {"C": {"A": null, "G": "B"}, "I": null}, "D": ["H", {"H": {"B": true, "E": {"D": [{"C": true, "H": {"A": 4, "H": 2}}]}, "F": null}}], "G": [{"E": 0}]}, "H": 6}]}, "J": {"B": ["H"], "H": [false, {"I": [{"E": 1, "J": {"A": {"G": {"A": {"D": {"G": null}, "I": {"C": {"E": null}, "G": false}}, "B": [false, [{"F": "D"}, {"G": {"D": 2, "H": {"B": null, "J": null}}, "H": null}], {"H": null}]}}}}, null]}, true]}}], "E": [{"H": ["I", {"C": true, "I": {"A": {"A": {"C": {"J": true}}, "F": "B"}, "E": 2, "H": "I"}}]}, true]}}, "J": {"C": false, "F": {"B": [{"E": false}, 5, {"A": true, "B": [{"D": {"J": {"D": 2, "H": null}}, "E": "J", "F": {"J": {"A": 6, "D": [[{"D": {"F": true}, "G": {"F": {"A": {"A": "A", "E": 3}, "F": false, "J": true}}, "H": 3}], [{"I": 7}, null, 8]], "G": {"I": {"F": null}}}}}, 6, {"B": null, "D": 8}]}], "I": {"E": {"A": false, "H": [{"D": {"C": {"G": false, "J": false}}, "J": null}, {"A": {"D": {"F": 4}}}, {"F": {"B": {"F": 4, "G": [[1], {"A": {"E": 5, "G": false, "H": 9}, "C": {"B": {"H": {"F": false}, "I": "F", "J": {"D": {"F": true, "G": {"B": {"B": false}}}, "F": false, "H": {"B": "D", "C": {"A": {"C": 3, "E": {"E": null, "I": {"G": {"E": true}, "I": {"C": {"E": {"E": [true, true, {"F": {"C": [{"D": 2, "F": true}, {"E": {"D": {"D": false}}, "F": {"I": null}}, {"E": false}]}, "J": [false]}], "H": {"A": [[{"C": false, "D": {"C": {"A": 1, "C": null}, "H": {"D": {"B": false}}}, "F": {"C": "H", "D": true}}, [9], {"I": {"D": false}}]], "H": "F", "I": false}, "I": [null]}, "I": null}, "D": "F", "H": {"B": [{"D": false}], "E": "A", "F": {"B": {"B": false, "I": true}, "C": true, "D": {"A": {"F": null}}}}}}}}, "C": {"C": {"C": {"B": {"B": "G", "C": true, "G": {"B": 5, "F": "B"}}, "G": {"F": true, "H": {"J": null}}, "J": 0}, "D": {"A": true, "D": {"E": {"E": {"A": {"B": null}, "J": "A"}, "F": [{"E": {"H": 5}, "H": "H"}]}, "F": null}, "E": {"G": null, "H": {"J": true}, "I": [{"C": {"C": {"E": false}, "I": 9}}]}}}}, "H": null}, "E": {"B": {"B": "J", "E": [{"A": {"H": {"G": {"C": false, "G": {"B": true}, "I": [2, {"A": null, "H": {"H": "B"}}]}}}, "J": "I"}, "J"], "H": "G"}}}}}, "G": {"B": {"G": "I"}}, "J": {"F": [8, "A"], "I": false}}, "H": null}, {"A": "B", "H": [5, {"F": {"H": [{"F": null, "H": {"F": {"I": {"A": true, "C": {"B": 0, "H": false}, "J": true}}}, "I": "G"}, {"B": false, "H": ["F", {"D": false, "F": 9}]}], "I": {"B": {"B": 4, "J": {"C": 4, "E": true, "I": {"A": "J", "E": true, "F": 3}}}}}, "J": "F"}], "I": {"F": {"D": {"F": {"C": "E", "D": true, "J": {"A": {"I": true}, "E": {"C": {"B": {"D": false, "J": ["G"]}, "G": {"D": "H"}, "J": false}, "F": {"D": null, "G": false, "I": 1}}, "H": null}}}, "G": {"A": {"A": ["E", {"F": false, "I": true}, [{"B": {"C": {"E": [0, {"A": false, "B": {"B": {"H": {"A": 8, "H": {"E": "E"}, "I": "B"}, "J": false}, "H": false}, "G": [true, [{"D": {"A": null, "F": true, "H": {"C": true, "H": {"B": "F", "C": null}}}, "G": 1}], 6]}, false], "G": {"D": 4, "F": "B"}}}, "C": {"B": false, "D": "B"}}, false]], "H": 6}, "E": false, "H": {"H": {"A": "J", "C": false}}}}, "J": "A"}}]}}, "I": {"C": {"B": "C", "E": [{"A": {"C": {"C": true, "E": 9}, "H": {"G": false}, "I": {"C": "D"}}, "F": false}]}}}], "I": {"D": true, "J": {"F": "H"}}}, "F": "F"}, "J": null}}}, false]}, {"A": true, "B": {"A": false, "G": {"J": 9}, "J": {"B": 2, "H": false}}}]}, "F": ["B"]}, false], "I": {"A": {"D": false}, "H": {"E": 6, "F": {"A": 7, "B": false, "G": null}}}}, false], "G": {"J": {"E": {"C": true, "I": {"I": true, "J": 5}}, "F": {"A": false, "I": {"D": {"D": {"A": 4, "H": [{"D": {"A": {"D": [5, "J", {"D": {"B": "I", "C": false, "J": {"B": {"B": {"B": [[null]], "D": {"B": {"A": {"D": {"C": {"B": [[true, "F", "I"], true, true]}, "G": {"E": 8}, "J": [{"D": "G", "F": {"D": [false, "H", {"G": null}]}, "G": null}]}, "F": {"C": {"E": {"C": {"B": false, "H": null}, "G": {"B": [false, 3, 8], "C": 2, "I": 0}}, "F": {"A": [{"E": {"C": {"G": null}}, "H": {"B": [true], "D": [{"B": {"G": "H"}, "E": {"A": [{"D": "C", "G": "J", "H": false}], "D": 6, "H": "J"}, "F": false}], "I": {"B": {"D": {"B": {"J": "F"}}}, "I": [["B"], true]}}}, false, {"A": null, "D": [[8, true]], "F": {"D": true}}], "B": 3}, "H": 3}}, "G": ["F"]}, "E": "C"}, "F": {"C": {"E": {"A": 6, "G": true}, "I": {"B": [null, null], "F": 0, "J": {"I": false}}, "J": {"G": false, "J": false}}, "E": 3, "H": null}}}, "D": "J"}, "G": {"C": [{"F": false, "G": 7, "H": 9}], "D": 3, "J": {"A": {"C": {"G": {"H": [true], "J": {"E": {"B": true, "D": false}, "J": {"D": 8, "H": [0]}}}}, "D": {"E": true, "G": false, "J": {"B": {"H": "G", "I": false}, "H": false}}, "J": {"D": {"E": null}, "E": {"G": true, "H": "J", "J": {"E": true, "I": 0, "J": "D"}}, "G": null}}}}}}, "F": {"C": [null]}}], "G": {"F": true, "J": [{"C": {"E": {"G": null, "H": false}, "F": 6}, "H": ["F", false]}, false]}, "I": [false, false]}, "B": {"C": null, "E": "E", "F": {"A": 6, "J": "I"}}, "I": {"A": 6}}}, {"E": {"A": true, "B": ["A"], "F": "E"}, "H": {"H": null}}, [null]]}, "J": {"D": true, "E": null}}, "E": {"E": 2, "F": 3}, "H": {"C": {"A": true, "G": "A", "I": {"I": true}}, "D": {"H": null, "I": {"B": {"A": true, "F": false}, "C": {"B": "I", "D": "F", "E": "I"}, "J": "F"}}, "J": {"A": true, "D": false, "I": false}}}}, "H": ["I", false, [true]]}}}}}, false, {"A": {"B": ["H", {"B": null, "G": "F"}, [{"A": true, "G": null}, ["C", 0], {"F": false, "J": "A"}]]}}]}, "C", false]}, "I": false}, "C": "A"}}, "J": 0}, [{"C": true, "I": [{"D": [{"B": 6, "H": 8}, false], "G": {"C": {"D": {"H": {"C": 7, "I": false}, "J": {"I": null}}, "E": null, "J": {"F": true, "H": [{"D": [5]}, false]}}, "G": "H"}, "I": 7}, true]}, "I", {"D": "D", "E": {"A": false, "B": {"J": 3}}}]], "G": {"B": {"C": null, "I": null}, "I": [3], "J": {"B": true, "F": false}}, "H": true}}, {"F": {"E": 3}, "G": true}]}}, "C": {"A": 8, "D": {"C": "D"}, "I": "I"}, "H": [[3]]}]}}, "J": "E"}, null, true], "H": {"C": 8, "F": "C"}}, "I": null}':::JSONB::JSONB
        test_1        |                             AS col_124866
        test_1        |                 )
        test_1        |                     AS "t'\\u1BCAab%89_67076"
        test_1        |             ORDER BY
        test_1        |                 col_124866 NULLS FIRST
        test_1        |         compare_test.go:213: cockroach1: ping: conn closed
        test_1        | FAIL
        postgres_1    | 2024-02-09 06:39:41.299 UTC [99] LOG:  could not receive data from client: Connection reset by peer
        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:125: exit status 1
--- FAIL: TestComposeCompare (1229.41s)
Help

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

Same failure on other branches

- #118616 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.1-rc] - #118615 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.15-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ b2e31876366324c2ebe5c2ad8bbd644997e90864:

        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (242.80s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare4102934507/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:203: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   s"-0291-05-29 08:16:43.145224 +0000 UTC",
        test_1        |             +   s"0001-09-07 08:04:00 +0000 UTC",
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         make_timestamp(1:::INT8::INT4::INT4, 9:::INT8::INT4::INT4, 7:::INT8::INT4::INT4, 8:::INT8::INT4::INT4, COALESCE(4:::INT8::INT4, 3:::INT8::INT4)::INT4, 0.0:::FLOAT8::FLOAT8::FLOAT8)::TIMESTAMP
        test_1        |                             AS col_271062
        test_1        |                 )
        test_1        |                     AS tab_193843
        test_1        |             ORDER BY
        test_1        |                 col_271062;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         make_timestamp(1::INT8::INT4::INT4, 9::INT8::INT4::INT4, 7::INT8::INT4::INT4, 8::INT8::INT4::INT4, COALESCE(4::INT8::INT4, 3::INT8::INT4)::INT4, 0.0::FLOAT8::FLOAT8::FLOAT8)::TIMESTAMP
        test_1        |                             AS col_271062
        test_1        |                 )
        test_1        |                     AS tab_193843
        test_1        |             ORDER BY
        test_1        |                 col_271062;
        test_1        |             
        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:125: exit status 1
--- FAIL: TestComposeCompare (873.31s)
Help

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

Same failure on other branches

- #118616 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.1-rc] - #118615 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.15-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ b2e31876366324c2ebe5c2ad8bbd644997e90864:

Fatal error:

panic: test timed out after 29m57s
running tests:
    TestComposeCompare (29m57s)

Stack: 

goroutine 20 [running]:
testing.(*M).startAlarm.func1()
    GOROOT/src/testing/testing.go:2259 +0x3b9
created by time.goFunc
    GOROOT/src/time/sleep.go:176 +0x2d
Log preceding fatal error

``` === RUN TestComposeCompare ```

Help

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

Same failure on other branches

- #118616 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.1-rc] - #118615 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.15-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ b2e31876366324c2ebe5c2ad8bbd644997e90864:

        postgres_1    |     CREATE INDEX ON "t able_3" ((col3__7 + '-Infinity'::DECIMAL) ASC) INCLUDE (col3__0, "col3_%q_2", col3__3, "col3""__4", "c'o
        postgres_1    |     l3̲__5", 😼col3__6, col3__7);
        postgres_1    |     CREATE INDEX ON "t able_3" (" c😏ol3_%p_12") INCLUDE (col3__0, col3__3, "col3""__4", "c'o
        postgres_1    |     l3̲__5", 😼col3__6, col3__7, col3__8, "😁col😴3_\\xa1_10", "%qcol3__13");
        postgres_1    |     CREATE INDEX ON "t able_3" ("%qcol3__13" DESC, col3__7 ASC);
        postgres_1    |     CREATE INDEX ON "t able_3" ("col3""__4" DESC, "c'o
        postgres_1    |     l3̲__5", "col3_!_11") INCLUDE (col3__0, "col3_%q_2", 😼col3__6, col3__7);
        postgres_1    |     CREATE INDEX ON "t able_3" (lower(CAST(col3__0 AS TEXT)) ASC) INCLUDE (col3__1, "col3_%q_2", "c'o
        postgres_1    |     l3̲__5", col3__7, "😁col😴3_\\xa1_10", "%qcol3__13");
        postgres_1    |     CREATE UNIQUE INDEX ON "t able_3" ("%qcol3__13", "col3""__4" DESC);
        postgres_1    |     CREATE UNIQUE INDEX ON "t able_3" ("col3""__4");
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (605.31s)
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     --- FAIL: TestCompare/postgres (0.94s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:172: CREATE TABLE "t able_3" (col3__0 UUID NOT NULL, col3__1 OID, "col3_%q_2" FLOAT8 NOT NULL, col3__3 REGROLE, "col3""__4" VARCHAR NOT NULL, "c'o
        test_1        |             l3̲__5" REGCLASS, 😼col3__6 FLOAT4 NOT NULL, col3__7 DECIMAL NULL, col3__8 FLOAT8 NOT NULL GENERATED ALWAYS AS (😼col3__6 + "col3_%q_2") STORED, col͞3̬__9 FLOAT8 NOT NULL GENERATED ALWAYS AS ("col3_%q_2" + 😼col3__6) STORED, "😁col😴3_\\xa1_10" TEXT GENERATED ALWAYS AS (CASE WHEN col3__3 IS NULL THEN 's'::TEXT ELSE e'^P\x10Sh]\x07'::TEXT END) STORED, "col3_!_11" TEXT NOT NULL GENERATED ALWAYS AS (lower("col3""__4")) STORED, " c😏ol3_%p_12" FLOAT8 NOT NULL GENERATED ALWAYS AS (😼col3__6 + "col3_%q_2") STORED, "%qcol3__13" FLOAT8 NOT NULL GENERATED ALWAYS AS ("col3_%q_2" + 😼col3__6) STORED, PRIMARY KEY (col͞3̬__9));
        test_1        |             CREATE UNIQUE INDEX ON "t able_3" ("col3""__4" ASC) INCLUDE (col3__1, "col3_%q_2", col3__3, "c'o
        test_1        |             l3̲__5", 😼col3__6, "😁col😴3_\\xa1_10", " c😏ol3_%p_12", "%qcol3__13");
        test_1        |             CREATE INDEX ON "t able_3" (col3__1 DESC) INCLUDE ("col3""__4", "😁col😴3_\\xa1_10", " c😏ol3_%p_12");
        test_1        |             CREATE INDEX ON "t able_3" ((col3__7 + '-Infinity'::DECIMAL) ASC) INCLUDE (col3__0, "col3_%q_2", col3__3, "col3""__4", "c'o
        test_1        |             l3̲__5", 😼col3__6, col3__7);
        test_1        |             CREATE INDEX ON "t able_3" (" c😏ol3_%p_12") INCLUDE (col3__0, col3__3, "col3""__4", "c'o
        test_1        |             l3̲__5", 😼col3__6, col3__7, col3__8, "😁col😴3_\\xa1_10", "%qcol3__13");
        test_1        |             CREATE INDEX ON "t able_3" ("%qcol3__13" DESC, col3__7 ASC);
        test_1        |             CREATE INDEX ON "t able_3" ("col3""__4" DESC, "c'o
        test_1        |             l3̲__5", "col3_!_11") INCLUDE (col3__0, "col3_%q_2", 😼col3__6, col3__7);
        test_1        |             CREATE INDEX ON "t able_3" (lower(CAST(col3__0 AS TEXT)) ASC) INCLUDE (col3__1, "col3_%q_2", "c'o
        test_1        |             l3̲__5", col3__7, "😁col😴3_\\xa1_10", "%qcol3__13");
        test_1        |             CREATE UNIQUE INDEX ON "t able_3" ("%qcol3__13", "col3""__4" DESC);
        test_1        |             CREATE UNIQUE INDEX ON "t able_3" ("col3""__4");
        test_1        |             
        test_1        |         compare_test.go:173: postgres: exec: ERROR: invalid input syntax for type numeric: "-Infinity" (SQLSTATE 22P02)
        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_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:125: exit status 1
--- FAIL: TestComposeCompare (629.18s)
Help

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

Same failure on other branches

- #118616 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.1-rc] - #118615 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.15-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ 814a375d4c0e79d875c42452725f05f6c27294e3:

        test_1        |             ORDER BY
        test_1        |                 col_180374 DESC
        test_1        |         compare_test.go:213: cockroach1: ping: conn closed
        test_1        |     --- FAIL: TestCompare/mutators (0.00s)
        test_1        |         compare_test.go:141: starting test: mutators
        test_1        | panic: geos: no locations to init GEOS [recovered]
        test_1        |     panic: geos: no locations to init GEOS
        test_1        | 
        test_1        | goroutine 218343 [running]:
        test_1        | testing.tRunner.func1.2({0x2282ac0, 0xc0017db1e0})
        test_1        |     GOROOT/src/testing/testing.go:1545 +0x238
        test_1        | testing.tRunner.func1()
        test_1        |     GOROOT/src/testing/testing.go:1548 +0x397
        test_1        | panic({0x2282ac0?, 0xc0017db1e0?})
        test_1        |     GOROOT/src/runtime/panic.go:914 +0x21f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x474c800?, {0x3273958?, 0xc001ef84b0?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:371 +0x465
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x3232280?, 0x474c800)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:304 +0x137
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc000201e00)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:220 +0x76
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc001e90c00, {0xc0017daa20?, 0x2, 0x0?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:253 +0x89d
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0x20839a0?, 0x24879de?, {0xc0017daa20?, 0x4a801a8?, 0x2?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:97 +0x28
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0xc001e8f650?, {0x24879de, 0x5}, 0x2, 0xa0?, {0xc000f7fa40, 0x3, 0x7f7ce1842108?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/schema.go:94 +0x131
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTablesN(0xc00105dcc8?, 0x1?, {0x0, 0x0})
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:118 +0x15e
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc001ec8000?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:98 +0x2f
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.init.wrapCommonSetup.func28(0x26a9878?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:51 +0x1b
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc000431860)
        test_1        |     github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:143 +0xe2
        test_1        | testing.tRunner(0xc000431860, 0xc001e90b70)
        test_1        |     GOROOT/src/testing/testing.go:1595 +0xff
        test_1        | created by testing.(*T).Run in goroutine 9
        test_1        |     GOROOT/src/testing/testing.go:1648 +0x3ad
        compare_test_1 exited with code 2
        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:125: exit status 2
--- FAIL: TestComposeCompare (261.46s)
Help

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

Same failure on other branches

- #118616 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.1-rc] - #118615 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.15-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ 7d0697b632066ee78735fc57e8150222d5576d0d:

Fatal error:

panic: test timed out after 29m57s
running tests:
    TestComposeCompare (29m57s)

Stack: 

goroutine 9 [running]:
testing.(*M).startAlarm.func1()
    GOROOT/src/testing/testing.go:2259 +0x3b9
created by time.goFunc
    GOROOT/src/time/sleep.go:176 +0x2d
Log preceding fatal error

``` === RUN TestComposeCompare ```

Help

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

Same failure on other branches

- #118616 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.1-rc] - #118615 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.15-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ 0b7ae19e2b94b851ed8812914f57032aab699811:

        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare1825398728/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:203: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   s"-0283-01-25 02:17:43.145224 +0000 UTC",
        test_1        |             +   s"0009-05-06 02:05:00 +0000 UTC",
        test_1        |                 int16(2),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         make_timestamp(9:::INT8::INT4::INT4, 5:::INT8::INT4::INT4, int4('6':::JSONB::JSONB::JSONB)::INT4::INT4, 2:::INT8::INT4::INT4, 5:::INT8::INT4::INT4, 0.0:::FLOAT8::FLOAT8::FLOAT8)::TIMESTAMP
        test_1        |                             AS col_84298,
        test_1        |                         2:::INT8::INT2 AS "co\fl_84299"
        test_1        |                 )
        test_1        |                     AS "tab{_42791"
        test_1        |             ORDER BY
        test_1        |                 col_84298 DESC NULLS FIRST, "co\fl_84299" ASC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         make_timestamp(9::INT8::INT4::INT4, 5::INT8::INT4::INT4, int4('6'::JSONB::JSONB::JSONB)::INT4::INT4, 2::INT8::INT4::INT4, 5::INT8::INT4::INT4, 0.0::FLOAT8::FLOAT8::FLOAT8)::TIMESTAMP
        test_1        |                             AS col_84298,
        test_1        |                         2::INT8::INT2 AS "co\fl_84299"
        test_1        |                 )
        test_1        |                     AS "tab{_42791"
        test_1        |             ORDER BY
        test_1        |                 col_84298 DESC NULLS FIRST, "co\fl_84299" ASC NULLS LAST;
        test_1        |             
        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:125: exit status 1
--- FAIL: TestComposeCompare (686.29s)
Help

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

Same failure on other branches

- #118616 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.1-rc] - #118615 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.15-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on master @ e39dafe6d8c153301ff43ed2b3ed3e13af9ec72a:

        test_1        |             +               Int:              s"9030899869919436",
        test_1        |             -               Exp:              -20,
        test_1        |             +               Exp:              -16,
        test_1        |                             Status:           2,
        test_1        |                             NaN:              false,
        test_1        |                             InfinityModifier: s"none",
        test_1        |                         },
        test_1        |                     },
        test_1        |                     Dimensions: {{Length: 1, LowerBound: 1}},
        test_1        |                     Status:     2,
        test_1        |                 },
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (log(8::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || NULL::DECIMAL[]::DECIMAL[])::DECIMAL[]
        test_1        |                             AS col_511571
        test_1        |                 )
        test_1        |                     AS t̯ab_301723
        test_1        |             ORDER BY
        test_1        |                 col_511571 DESC NULLS FIRST;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (log(8:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || NULL::DECIMAL[]::DECIMAL[])::DECIMAL[]
        test_1        |                             AS col_511571
        test_1        |                 )
        test_1        |                     AS t̯ab_301723
        test_1        |             ORDER BY
        test_1        |                 col_511571 DESC NULLS FIRST;
        test_1        |             
        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:125: exit status 1
--- FAIL: TestComposeCompare (1012.21s)
Help

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

Same failure on other branches

- #118616 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.1-rc] - #118615 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.15-rc] - #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!