compose: TestComposeCompare failed

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ e6d0a5283b82a9d5485101bf3508c16b1597f085:

        test_1        |             +               Int:              s"10000000000000000",
        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        |                         ((4:::INT8::INT8::INT8 ^ 0:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || NULL::DECIMAL[]::DECIMAL[])::DECIMAL[]
        test_1        |                             AS col88986
        test_1        |                 )
        test_1        |                     AS tab50457
        test_1        |             ORDER BY
        test_1        |                 col88986 ASC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         ((4::INT8::INT8::INT8 ^ 0::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || NULL::DECIMAL[]::DECIMAL[])::DECIMAL[]
        test_1        |                             AS col88986
        test_1        |                 )
        test_1        |                     AS tab50457
        test_1        |             ORDER BY
        test_1        |                 col88986 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:124: exit status 1
--- FAIL: TestComposeCompare (693.50s)

Help

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

Same failure on other branches

- #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-30902

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ b151af8ea747b3dcd7aebfc1aa0c6d5ed2bc5708:

        test_1        |             +               Int:              s"7290000000000000000",
        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        |                         (NULL::DECIMAL[]::DECIMAL[] || power(9:::DECIMAL::DECIMAL::DECIMAL, 3:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::DECIMAL[]
        test_1        |                             AS col439904
        test_1        |                 )
        test_1        |                     AS "%q😥Ta\\uEFDDb͢239838"
        test_1        |             ORDER BY
        test_1        |                 col439904 DESC NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (NULL::DECIMAL[]::DECIMAL[] || power(9::DECIMAL::DECIMAL::DECIMAL, 3::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::DECIMAL[]
        test_1        |                             AS col439904
        test_1        |                 )
        test_1        |                     AS "%q😥Ta\\uEFDDb͢239838"
        test_1        |             ORDER BY
        test_1        |                 col439904 DESC 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:124: exit status 1
--- FAIL: TestComposeCompare (1066.80s)

Help

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

Same failure on other branches

- #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ e9a99ca5edea2d3f838467323355be76d9d3ec92:

        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.41s)
        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/TestComposeCompare3888100230/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("010300000001000000050000000000000000001840000000000000F0BF00000000000018400000000000002240FDD54F962789EE3F0000000000002240FDD54F962789EE3F000000000000F0BF0000000000001840000000000000F0BF"),
        test_1        |             +   string("010300000000000000"),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makeenvelope(6.0::FLOAT8::FLOAT8::FLOAT8, (4.0::FLOAT8::FLOAT8::FLOAT8 - 5.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, log(9.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, 9.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS col372921
        test_1        |                 )
        test_1        |                     AS tab189820
        test_1        |             ORDER BY
        test_1        |                 col372921 ASC NULLS LAST;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makeenvelope(6.0:::FLOAT8::FLOAT8::FLOAT8, (4.0:::FLOAT8::FLOAT8::FLOAT8 - 5.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, log(9.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, 9.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS col372921
        test_1        |                 )
        test_1        |                     AS tab189820
        test_1        |             ORDER BY
        test_1        |                 col372921 ASC NULLS LAST;
        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:124: exit status 1
--- FAIL: TestComposeCompare (870.25s)

Help

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

Same failure on other branches

- #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ e9a99ca5edea2d3f838467323355be76d9d3ec92:

        test_1        |         compare_test.go:203: compare postgres to cockroach1: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |                 []uint8{
        test_1        |                     0x21,
        test_1        |                     0x08,
        test_1        |             -       0x1a,
        test_1        |             +       0x02,
        test_1        |                     0x28,
        test_1        |                     0x50,
        test_1        |                     0x08,
        test_1        |                 },
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_astwkb(st_makepointm(2.0::FLOAT8::FLOAT8::FLOAT8, 4.0::FLOAT8::FLOAT8::FLOAT8, 4.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY, 1::INT8::INT4::INT4, 6::INT8::INT4::INT4)::BYTEA
        test_1        |                             AS "%d2col315058"
        test_1        |                 )
        test_1        |                     AS tab212238
        test_1        |             ORDER BY
        test_1        |                 "%d2col315058" DESC;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_astwkb(st_makepointm(2.0:::FLOAT8::FLOAT8::FLOAT8, 4.0:::FLOAT8::FLOAT8::FLOAT8, 4.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY, 1:::INT8::INT4::INT4, 6:::INT8::INT4::INT4)::BYTES
        test_1        |                             AS "%d2col315058"
        test_1        |                 )
        test_1        |                     AS tab212238
        test_1        |             ORDER BY
        test_1        |                 "%d2col315058" DESC;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (916.83s)

Help

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

Same failure on other branches

- #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ b05ca5cee319a3c0778fb5e50309e5f30507cd2b:

        cockroach1_1  | status:              initialized new cluster
        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    | waiting for server to shut down...2023-08-29 05:17:27.559 UTC [49] LOG:  received fast shutdown request
        postgres_1    | .2023-08-29 05:17:27.561 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2023-08-29 05:17:27.563 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2023-08-29 05:17:27.565 UTC [51] LOG:  shutting down
        postgres_1    | 2023-08-29 05:17:27.658 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-08-29 05:17:27.680 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-08-29 05:17:27.681 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2023-08-29 05:17:27.681 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2023-08-29 05:17:27.683 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2023-08-29 05:17:27.688 UTC [68] LOG:  database system was shut down at 2023-08-29 05:17:27 UTC
        postgres_1    | 2023-08-29 05:17:27.693 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-08-29 05:17:29.916 UTC [78] ERROR:  foreign key constraint "t͞able\\u62FD3_col3_6_co😾l3_0_fkey" cannot be implemented
        postgres_1    | 2023-08-29 05:17:29.916 UTC [78] DETAIL:  Key columns "co😾l3_0" and "col�1_0" are of incompatible types: "char" and name.
        postgres_1    | 2023-08-29 05:17:29.916 UTC [78] STATEMENT:  ALTER TABLE "t͞able\\u62FD3" ADD FOREIGN KEY (col3_6, co😾l3_0) REFERENCES "%pta'ble1" (col1_8, "col�1_0")
        test_1        | --- FAIL: TestCompare (606.47s)
        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 (1.39s)
        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: ALTER TABLE "t͞able\\u62FD3" ADD FOREIGN KEY (col3_6, co😾l3_0) REFERENCES "%pta'ble1" (col1_8, "col�1_0")
        test_1        |         compare_test.go:173: postgres: exec: ERROR: foreign key constraint "t͞able\\u62FD3_col3_6_co😾l3_0_fkey" cannot be implemented (SQLSTATE 42804)
        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:124: exit status 1
--- FAIL: TestComposeCompare (630.22s)

Help

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

Same failure on other branches

- #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 58ac87a9b24e1cfb446143dafe04808ea186637f:

        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (229.32s)
        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/TestComposeCompare89666344/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("0"),
        test_1        |             -   nil,
        test_1        |             +   string("01010000000000000000B063C00000000000E05040"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         bpchar('00:04:00':::TIME::TIME::TIME)::CHAR AS col271409,
        test_1        |                         st_pointfromgeohash('B':::STRING::STRING::STRING, NULL::INT4::INT4)::GEOMETRY AS col271410
        test_1        |                 )
        test_1        |                     AS tab181043
        test_1        |             ORDER BY
        test_1        |                 col271409 ASC, col271410 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         bpchar('00:04:00'::TIME::TIME::TIME)::CHAR AS col271409,
        test_1        |                         st_pointfromgeohash('B'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::GEOMETRY AS col271410
        test_1        |                 )
        test_1        |                     AS tab181043
        test_1        |             ORDER BY
        test_1        |                 col271409 ASC, col271410 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:124: exit status 1
--- FAIL: TestComposeCompare (857.59s)

Help

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

Same failure on other branches

- #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.9-rc.FROZEN] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ fde98bbb2423906a7e3bfd9cd7956bc3f29918ad:

        postgres_1    |             WHERE
        postgres_1    |                 NULL::BOOL
        postgres_1    |             ORDER BY
        postgres_1    |                 "t\\u5446ab59923"."c,ol3_̀6" ASC NULLS LAST
        postgres_1    |         )
        postgres_1    |             AS tab59925
        postgres_1    |     ORDER BY
        postgres_1    |         "c ol114126" DESC NULLS LAST
        test_1        | --- FAIL: TestCompare (696.56s)
        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 (91.42s)
        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/TestComposeCompare2604141028/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        |             -   int16(0),
        test_1        |             +   int16(1),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT int2(tanh(2.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT2 AS "col}114206") AS tab59991
        test_1        |             ORDER BY
        test_1        |                 "col}114206" ASC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT int2(tanh(2.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT2 AS "col}114206") AS tab59991
        test_1        |             ORDER BY
        test_1        |                 "col}114206" ASC 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_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (720.80s)

Help

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

Same failure on other branches

- #109969 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.10-rc] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.9-rc.FROZEN] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 6db39099511584d8b41094237f5b26333fb4c7be:

        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/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 830657 [running]:
        test_1        | testing.tRunner.func1.2({0x22a4680, 0xc002814640})
        test_1        |     GOROOT/src/testing/testing.go:1396 +0x24e
        test_1        | testing.tRunner.func1()
        test_1        |     GOROOT/src/testing/testing.go:1399 +0x39f
        test_1        | panic({0x22a4680, 0xc002814640})
        test_1        |     GOROOT/src/runtime/panic.go:884 +0x212
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x45b13a0?, {0x31c4cc8?, 0xc0027987b0?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:377 +0x445
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x3188760?, 0x45b13a0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:310 +0x13c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc000c5c300)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:227 +0x96
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc001e59b90, {0xc0045a4230?, 0x5, 0xc001e59b90?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:260 +0x71f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0xc000096968?, 0x24a728b?, {0xc0045a4230?, 0x20df9a0?, 0x1?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:98 +0x2e
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0x20df9a0?, {0x24a728b, 0x5}, 0x5, 0x0?, {0xc00134fa48, 0x3, 0xc0009b6690?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/schema.go:93 +0x16a
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTablesN(0x1?, 0x60a9c0?, {0x0, 0x0})
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:104 +0x194
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc00296d1e0?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:84 +0x37
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.wrapCommonSetup.func1(0x26831a0?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:51 +0x22
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc00296d1e0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:143 +0xed
        test_1        | testing.tRunner(0xc00296d1e0, 0xc001e59b30)
        test_1        |     GOROOT/src/testing/testing.go:1446 +0x10b
        test_1        | created by testing.(*T).Run
        test_1        |     GOROOT/src/testing/testing.go:1493 +0x35f
        compare_test_1 exited with code 2
        Stopping compare_postgres_1   ... 
        Stopping compare_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:124: exit status 2
--- FAIL: TestComposeCompare (630.22s)

Help

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

Same failure on other branches

- #109969 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.10-rc] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.9-rc.FROZEN] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 50c96a6208c5a211a6174654ac3dd6487a046006:

        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2023-09-10 05:17:49.079 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-09-10 05:17:49.079 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2023-09-10 05:17:49.079 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2023-09-10 05:17:49.082 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2023-09-10 05:17:49.087 UTC [67] LOG:  database system was shut down at 2023-09-10 05:17:49 UTC
        postgres_1    | 2023-09-10 05:17:49.091 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-09-10 05:17:50.495 UTC [77] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2023-09-10 05:17:50.495 UTC [77] STATEMENT:  CREATE TABLE table5 ("co\\x51l5_0" INT4 NOT NULL, col5_1 BIT(38) NOT NULL, col5_2 CHAR NOT NULL, col5̽_3 TEXT NOT NULL, col5_4 REGTYPE NOT NULL, col5_5 BYTEA NOT NULL, col5_6 CHAR, "co\gl5_7" REGTYPE, "col'5_8" INT8 NOT NULL, col5_9 TEXT NOT NULL, col5_10 UUID NOT NULL, c̅ol5_11 VARCHAR NOT NULL, "cͮol5_\\xaa12" DATE, "co l5_13" TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col5_5 IS NULL THEN e'\x00'::TEXT ELSE ']'::TEXT END) STORED, co̽l5_14 INT8 NOT NULL GENERATED ALWAYS AS ("co\\x51l5_0" + "col'5_8") STORED, col5_15 INT8 NOT NULL GENERATED ALWAYS AS ("col'5_8" + (-5602317532961290773)::INT8) STORED, "'col5_16" TEXT NULL GENERATED ALWAYS AS (CASE WHEN col5_4 IS NULL THEN e'[ o;Cu\f'::TEXT ELSE e'\U00002603'::TEXT END) STORED, "c%qo̯l5_%q17" INT8 NOT NULL GENERATED ALWAYS AS ("co\\x51l5_0" + "col'5_8") STORED, PRIMARY KEY (col5_9, col5_4, col5_10, c̅ol5_11, "co\\x51l5_0", col5_5, "col'5_8", col5_15));
        postgres_1    |     CREATE UNIQUE INDEX ON table5 ("'col5_16", ("co\\x51l5_0" + "col'5_8"), col5̽_3 ASC, col5_4 DESC, col5_9 ASC) INCLUDE (col5_1, "co l5_13");
        postgres_1    |     CREATE UNIQUE INDEX ON table5 (c̅ol5_11 ASC, col5_10 ASC, col5_2, col5_4 DESC, col5̽_3 ASC, "'col5_16", col5_15 DESC, co̽l5_14 ASC, "c%qo̯l5_%q17" ASC, ("co\\x51l5_0" + (-1560331512)::INT8) ASC, col5_1 ASC, col5_9, col5_6 ASC);
        postgres_1    |     CREATE UNIQUE INDEX ON table5 (col5_5 DESC, col5_10, "cͮol5_\\xaa12", col5_9, "col'5_8", "'col5_16", "c%qo̯l5_%q17" DESC, col5_4, col5̽_3 DESC, c̅ol5_11 DESC, "co l5_13" DESC, col5_15 ASC, lower(col5_2));
        postgres_1    |     CREATE INDEX ON table5 (col5̽_3 ASC, col5_6 DESC, ("co\\x51l5_0" + "col'5_8") ASC, col5_1 DESC, "'col5_16" ASC, "col'5_8" ASC, col5_9 ASC, "co\gl5_7" ASC, lower(CAST(col5_10 AS TEXT)) ASC, "cͮol5_\\xaa12", col5_15 DESC, col5_10 ASC, lower(CAST(col5_1 AS TEXT)) ASC, c̅ol5_11 DESC, co̽l5_14 DESC, "c%qo̯l5_%q17", col5_5 ASC) INCLUDE (col5_2);
        postgres_1    |     CREATE INDEX ON table5 (co̽l5_14 ASC, col5_10 DESC, col5_5 ASC, "'col5_16", col5_9 ASC, col5̽_3, col5_4 ASC, col5_1 ASC, "cͮol5_\\xaa12", "c%qo̯l5_%q17" ASC, lower(CAST(col5_1 AS TEXT)) ASC, "col'5_8" DESC, "co l5_13", c̅ol5_11 ASC);
        postgres_1    |     CREATE UNIQUE INDEX ON table5 ("co\\x51l5_0", col5_10);
        postgres_1    |     CREATE UNIQUE INDEX ON table5 ("co\\x51l5_0");
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (606.35s)
        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.33s)
        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 table5 ("co\\x51l5_0" INT4 NOT NULL, col5_1 BIT(38) NOT NULL, col5_2 CHAR NOT NULL, col5̽_3 TEXT NOT NULL, col5_4 REGTYPE NOT NULL, col5_5 BYTEA NOT NULL, col5_6 CHAR, "co\gl5_7" REGTYPE, "col'5_8" INT8 NOT NULL, col5_9 TEXT NOT NULL, col5_10 UUID NOT NULL, c̅ol5_11 VARCHAR NOT NULL, "cͮol5_\\xaa12" DATE, "co l5_13" TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col5_5 IS NULL THEN e'\x00'::TEXT ELSE ']'::TEXT END) STORED, co̽l5_14 INT8 NOT NULL GENERATED ALWAYS AS ("co\\x51l5_0" + "col'5_8") STORED, col5_15 INT8 NOT NULL GENERATED ALWAYS AS ("col'5_8" + (-5602317532961290773)::INT8) STORED, "'col5_16" TEXT NULL GENERATED ALWAYS AS (CASE WHEN col5_4 IS NULL THEN e'[ o;Cu\f'::TEXT ELSE e'\U00002603'::TEXT END) STORED, "c%qo̯l5_%q17" INT8 NOT NULL GENERATED ALWAYS AS ("co\\x51l5_0" + "col'5_8") STORED, PRIMARY KEY (col5_9, col5_4, col5_10, c̅ol5_11, "co\\x51l5_0", col5_5, "col'5_8", col5_15));
        test_1        |             CREATE UNIQUE INDEX ON table5 ("'col5_16", ("co\\x51l5_0" + "col'5_8"), col5̽_3 ASC, col5_4 DESC, col5_9 ASC) INCLUDE (col5_1, "co l5_13");
        test_1        |             CREATE UNIQUE INDEX ON table5 (c̅ol5_11 ASC, col5_10 ASC, col5_2, col5_4 DESC, col5̽_3 ASC, "'col5_16", col5_15 DESC, co̽l5_14 ASC, "c%qo̯l5_%q17" ASC, ("co\\x51l5_0" + (-1560331512)::INT8) ASC, col5_1 ASC, col5_9, col5_6 ASC);
        test_1        |             CREATE UNIQUE INDEX ON table5 (col5_5 DESC, col5_10, "cͮol5_\\xaa12", col5_9, "col'5_8", "'col5_16", "c%qo̯l5_%q17" DESC, col5_4, col5̽_3 DESC, c̅ol5_11 DESC, "co l5_13" DESC, col5_15 ASC, lower(col5_2));
        test_1        |             CREATE INDEX ON table5 (col5̽_3 ASC, col5_6 DESC, ("co\\x51l5_0" + "col'5_8") ASC, col5_1 DESC, "'col5_16" ASC, "col'5_8" ASC, col5_9 ASC, "co\gl5_7" ASC, lower(CAST(col5_10 AS TEXT)) ASC, "cͮol5_\\xaa12", col5_15 DESC, col5_10 ASC, lower(CAST(col5_1 AS TEXT)) ASC, c̅ol5_11 DESC, co̽l5_14 DESC, "c%qo̯l5_%q17", col5_5 ASC) INCLUDE (col5_2);
        test_1        |             CREATE INDEX ON table5 (co̽l5_14 ASC, col5_10 DESC, col5_5 ASC, "'col5_16", col5_9 ASC, col5̽_3, col5_4 ASC, col5_1 ASC, "cͮol5_\\xaa12", "c%qo̯l5_%q17" ASC, lower(CAST(col5_1 AS TEXT)) ASC, "col'5_8" DESC, "co l5_13", c̅ol5_11 ASC);
        test_1        |             CREATE UNIQUE INDEX ON table5 ("co\\x51l5_0", col5_10);
        test_1        |             CREATE UNIQUE INDEX ON table5 ("co\\x51l5_0");
        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:124: exit status 1
--- FAIL: TestComposeCompare (629.85s)

Help

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

Same failure on other branches

- #109969 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.10-rc] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.9-rc.FROZEN] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ a3573e6b39530731621f90717649feac2c5dd47e:

        postgres_1    |             ORDER BY
        postgres_1    |                 tab326794.tableoid ASC NULLS LAST
        postgres_1    |         )
        postgres_1    |             AS tab326796
        postgres_1    |     ORDER BY
        postgres_1    |         "col,590707" DESC, "c!o%89l590708" ASC NULLS FIRST
        test_1        | --- FAIL: TestCompare (1094.53s)
        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 (489.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/TestComposeCompare277502422/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(0),
        test_1        |             +   int32(1),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT int4((5.0:::FLOAT8::FLOAT8::FLOAT8 / 7.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT4 AS col590766)
        test_1        |                     AS "tab�326822"
        test_1        |             ORDER BY
        test_1        |                 col590766 ASC NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT int4((5.0::FLOAT8::FLOAT8::FLOAT8 / 7.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT4 AS col590766)
        test_1        |                     AS "tab�326822"
        test_1        |             ORDER BY
        test_1        |                 col590766 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:124: exit status 1
--- FAIL: TestComposeCompare (1118.92s)

Help

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

Same failure on other branches

- #109969 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.10-rc] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.9-rc.FROZEN] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 3224fa603020b8226d4ecbe4d520a2651b6b97d5:

        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 (409.33s)
        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/TestComposeCompare2659823521/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("010300000000000000"),
        test_1        |             +   string("010300000001000000050000000000000000002240000000000000144000000000000022400000000000001C4000000000000010400000000000001C400000000000001040000000000000144000000000000022400000000000001440"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makeenvelope(9.0:::FLOAT8::FLOAT8::FLOAT8, 5.0:::FLOAT8::FLOAT8::FLOAT8, 4.0:::FLOAT8::FLOAT8::FLOAT8, 7.0:::FLOAT8::FLOAT8::FLOAT8, 0:::INT8::INT4::INT4)::GEOMETRY
        test_1        |                             AS col542405
        test_1        |                 )
        test_1        |                     AS tab308231
        test_1        |             ORDER BY
        test_1        |                 col542405 NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makeenvelope(9.0::FLOAT8::FLOAT8::FLOAT8, 5.0::FLOAT8::FLOAT8::FLOAT8, 4.0::FLOAT8::FLOAT8::FLOAT8, 7.0::FLOAT8::FLOAT8::FLOAT8, 0::INT8::INT4::INT4)::GEOMETRY
        test_1        |                             AS col542405
        test_1        |                 )
        test_1        |                     AS tab308231
        test_1        |             ORDER BY
        test_1        |                 col542405 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:124: exit status 1
--- FAIL: TestComposeCompare (1039.33s)

Help

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

Same failure on other branches

- #109969 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.11-rc] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.9-rc.FROZEN] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 12a0fdf76785787a3a7e83198f1adfd7184ea910:

        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 (479.77s)
        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/TestComposeCompare332584496/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("010300000000000000"),
        test_1        |             +   string("010300000001000000050000000000000000002240AA4C58E87AB6FB3F000000000000224000000000000014400000000000001C4000000000000014400000000000001C40AA4C58E87AB6FB3F0000000000002240AA4C58E87AB6FB3F"),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makeenvelope(9.0::FLOAT8::FLOAT8::FLOAT8, sqrt(3.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, 7.0::FLOAT8::FLOAT8::FLOAT8, 5.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS col885471
        test_1        |                 )
        test_1        |                     AS "%f9tab457850"
        test_1        |             ORDER BY
        test_1        |                 col885471 ASC NULLS LAST;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makeenvelope(9.0:::FLOAT8::FLOAT8::FLOAT8, sqrt(3.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, 7.0:::FLOAT8::FLOAT8::FLOAT8, 5.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS col885471
        test_1        |                 )
        test_1        |                     AS "%f9tab457850"
        test_1        |             ORDER BY
        test_1        |                 col885471 ASC NULLS LAST;
        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:124: exit status 1
--- FAIL: TestComposeCompare (1107.94s)

Help

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

Same failure on other branches

- #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.9-rc.FROZEN] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 12a0fdf76785787a3a7e83198f1adfd7184ea910:

        test_1        |                             Int:              s"0",
        test_1        |             -               Exp:              0,
        test_1        |             +               Exp:              -20,
        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        |                         (CASE WHEN false::BOOL THEN (6:::DECIMAL::DECIMAL::DECIMAL || NULL::DECIMAL[]::DECIMAL[])::DECIMAL[] ELSE NULL::DECIMAL[] END::DECIMAL[] || (0:::DECIMAL::DECIMAL::DECIMAL / 5:::INT8::INT8::INT8)::DECIMAL::DECIMAL)::DECIMAL[]
        test_1        |                             AS "%qcol437327"
        test_1        |                 )
        test_1        |                     AS tab274531
        test_1        |             ORDER BY
        test_1        |                 "%qcol437327";
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (CASE WHEN false::BOOL THEN (6::DECIMAL::DECIMAL::DECIMAL || NULL::DECIMAL[]::DECIMAL[])::DECIMAL[] ELSE NULL::DECIMAL[] END::DECIMAL[] || (0::DECIMAL::DECIMAL::DECIMAL / 5::INT8::INT8::INT8)::DECIMAL::DECIMAL)::DECIMAL[]
        test_1        |                             AS "%qcol437327"
        test_1        |                 )
        test_1        |                     AS tab274531
        test_1        |             ORDER BY
        test_1        |                 "%qcol437327";
        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:124: exit status 1
--- FAIL: TestComposeCompare (1081.60s)

Help

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

Same failure on other branches

- #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.9-rc.FROZEN] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ ef0a46c415ad61024743b3724e0243c8d9188cbb:

        test_1        | --- FAIL: TestCompare (989.18s)
        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 (384.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/TestComposeCompare3456258790/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("1"),
        test_1        |             +   string("1.0000000000000000"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         text((1:::DECIMAL::DECIMAL::DECIMAL ^ 1:::INT8::INT8::INT8)::DECIMAL::DECIMAL)::STRING AS "\\u78CCcol526444"
        test_1        |                 )
        test_1        |                     AS "'tab309625"
        test_1        |             ORDER BY
        test_1        |                 "\\u78CCcol526444";
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         text((1::DECIMAL::DECIMAL::DECIMAL ^ 1::INT8::INT8::INT8)::DECIMAL::DECIMAL)::TEXT AS "\\u78CCcol526444"
        test_1        |                 )
        test_1        |                     AS "'tab309625"
        test_1        |             ORDER BY
        test_1        |                 "\\u78CCcol526444";
        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:124: exit status 1
--- FAIL: TestComposeCompare (1013.66s)

Help

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

Same failure on other branches

- #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.9-rc.FROZEN] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ ffb4d004abe8c60fe256255550fe980d41f4e170:

        test_1        |     --- FAIL: TestCompare/postgres (281.70s)
        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/TestComposeCompare2354476104/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("BOX(3 0,5 8)"),
        test_1        |             +   nil,
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_combinebbox(NULL::BOX2D::BOX2D, st_makeenvelope(3.0:::FLOAT8::FLOAT8::FLOAT8, 8.0:::FLOAT8::FLOAT8::FLOAT8, 5.0:::FLOAT8::FLOAT8::FLOAT8, 0.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY)::BOX2D
        test_1        |                             AS col382164
        test_1        |                 )
        test_1        |                     AS "t\\u661Ba'b
        test_1        |             222982"
        test_1        |             ORDER BY
        test_1        |                 CAST(col382164 AS STRING) DESC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_combinebbox(NULL::BOX2D::BOX2D, st_makeenvelope(3.0::FLOAT8::FLOAT8::FLOAT8, 8.0::FLOAT8::FLOAT8::FLOAT8, 5.0::FLOAT8::FLOAT8::FLOAT8, 0.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY)::BOX2D
        test_1        |                             AS col382164
        test_1        |                 )
        test_1        |                     AS "t\\u661Ba'b
        test_1        |             222982"
        test_1        |             ORDER BY
        test_1        |                 CAST(col382164 AS TEXT) DESC 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:124: exit status 1
--- FAIL: TestComposeCompare (910.44s)

Help

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

Same failure on other branches

- #111157 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.11-rc] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ b08ec859debd7530b48f71405a700961596b3563:

        postgres_1    |         col688669 NULLS FIRST,
        postgres_1    |         col688670 DESC NULLS FIRST,
        postgres_1    |         col688671 NULLS LAST,
        postgres_1    |         col688672 DESC NULLS FIRST,
        postgres_1    |         "col%q688673",
        postgres_1    |         "C""ol688674" ASC NULLS FIRST
        test_1        | --- FAIL: TestCompare (1101.19s)
        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 (496.70s)
        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/TestComposeCompare3884827821/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("G0.863691154450617"),
        test_1        |             +   string("G0.8636911544506167"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT ('G':::STRING::STRING::STRING || cot(4.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::STRING AS col688687)
        test_1        |                     AS "tab\\x24414855"
        test_1        |             ORDER BY
        test_1        |                 col688687 DESC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT ('G'::TEXT::TEXT::TEXT || cot(4.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::TEXT AS col688687)
        test_1        |                     AS "tab\\x24414855"
        test_1        |             ORDER BY
        test_1        |                 col688687 DESC 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:124: exit status 1
--- FAIL: TestComposeCompare (1125.72s)

Help

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

Same failure on other branches

- #111157 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.11-rc] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ b08ec859debd7530b48f71405a700961596b3563:

        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         B'0111'::BIT(26) AS "c%3eol830062", tab459888.co̵l830061 AS col830063
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (B'0011'::BIT(26), NULL::GEOMETRY),
        test_1        |                                 (B'0101'::BIT(26), NULL::GEOMETRY),
        test_1        |                                 (
        test_1        |                                     B'0000'::BIT(26),
        test_1        |                                     st_makeenvelope(4.0::FLOAT8::FLOAT8::FLOAT8, (5.0::FLOAT8::FLOAT8::FLOAT8 * 7.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, 8.0::FLOAT8::FLOAT8::FLOAT8, 5.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                                 )
        test_1        |                         )
        test_1        |                             AS tab459888 (col830060, co̵l830061)
        test_1        |                     ORDER BY
        test_1        |                         tab459888.co̵l830061 NULLS FIRST
        test_1        |                 )
        test_1        |                     AS tab459889
        test_1        |             ORDER BY
        test_1        |                 "c%3eol830062" ASC, col830063 ASC NULLS FIRST;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (37.62s)
        test_1        |         compare_test.go:141: starting test: mutators
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: cockroach2
        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare678405014/002/mutators.log: no such file or directory
        test_1        |         compare_test.go:203: compare cockroach2 to cockroach1: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   string("127"),
        test_1        |             +   string(``e'e\'tabl\\U0001F602e5\''``),
        test_1        |               }))
        test_1        |             cockroach2:
        test_1        |             SELECT * FROM (SELECT regclass(127:::INT8::INT8)::REGCLASS AS col35184) AS tab22083 ORDER BY col35184 ASC NULLS LAST;
        test_1        |             
        test_1        |             cockroach1: [same as previous]
        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:124: exit status 1
--- FAIL: TestComposeCompare (639.40s)

Help

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

Same failure on other branches

- #111157 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.11-rc] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 83c13d4a3847b9341e5d00a4936fdc99cbf27b57:

        test_1        |             ORDER BY
        test_1        |                 col65787;
        test_1        |             
        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 116485 [running]:
        test_1        | testing.tRunner.func1.2({0x22a89c0, 0xc001623c80})
        test_1        |     GOROOT/src/testing/testing.go:1396 +0x24e
        test_1        | testing.tRunner.func1()
        test_1        |     GOROOT/src/testing/testing.go:1399 +0x39f
        test_1        | panic({0x22a89c0, 0xc001623c80})
        test_1        |     GOROOT/src/runtime/panic.go:884 +0x212
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x45c53a0?, {0x31d7a48?, 0xc0020b0e10?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:377 +0x445
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x319b520?, 0x45c53a0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:310 +0x13c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc0002cf680)
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:227 +0x96
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc00127df50, {0xc00127df80?, 0x3, 0xc00127df50?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:260 +0x71f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0xc001a81968?, 0x24ab82b?, {0xc00127df80?, 0x20e3840?, 0x1?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:98 +0x2e
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0x20e3840?, {0x24ab82b, 0x5}, 0x3, 0x0?, {0xc001677a48, 0x3, 0xc000e8ca50?})
        test_1        |     github.com/cockroachdb/cockroach/pkg/sql/randgen/schema.go:93 +0x16a
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTablesN(0x1?, 0x60a9c0?, {0x0, 0x0})
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:104 +0x194
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc00197bba0?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:84 +0x37
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.wrapCommonSetup.func1(0x2687cb8?)
        test_1        |     github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:51 +0x22
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc00197bba0)
        test_1        |     github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:143 +0xed
        test_1        | testing.tRunner(0xc00197bba0, 0xc00127def0)
        test_1        |     GOROOT/src/testing/testing.go:1446 +0x10b
        test_1        | created by testing.(*T).Run
        test_1        |     GOROOT/src/testing/testing.go:1493 +0x35f
        compare_test_1 exited with code 2
        Stopping compare_cockroach1_1 ... 
        Stopping compare_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:124: exit status 2
--- FAIL: TestComposeCompare (98.05s)

Help

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

Same failure on other branches

- #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 0deb53feff42298da826b13a0370d81eb9203e99:

        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | waiting for server to shut down...2023-09-30 05:17:02.388 UTC [49] LOG:  received fast shutdown request
        postgres_1    | .2023-09-30 05:17:02.390 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2023-09-30 05:17:02.391 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2023-09-30 05:17:02.394 UTC [51] LOG:  shutting down
        postgres_1    | 2023-09-30 05:17:02.489 UTC [49] LOG:  database system is shut down
        test_1        | I230930 05:17:02.536747 24 testutils/soon.go:41  [-] 1  SucceedsSoon: 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    | 2023-09-30 05:17:02.611 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-09-30 05:17:02.612 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2023-09-30 05:17:02.612 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2023-09-30 05:17:02.615 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2023-09-30 05:17:02.620 UTC [68] LOG:  database system was shut down at 2023-09-30 05:17:02 UTC
        postgres_1    | 2023-09-30 05:17:02.625 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-09-30 05:17:04.639 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2023-09-30 05:17:04.639 UTC [78] STATEMENT:  CREATE TABLE "tab{\\U00106225le2" (col2_0 TSVECTOR NOT NULL, col2_1 TEXT NOT NULL, col2_2 "char" NOT NULL, "col�2\\x89_%bc3" TIMESTAMP NOT NULL, "co!l2_4" INTERVAL NOT NULL, "col 2_""5" FLOAT4 NOT NULL, cő😟l2_6 DATE NULL, col2_7 DECIMAL[] NOT NULL, col2_8 BIT(15) NOT NULL, col2͍_9 TEXT GENERATED ALWAYS AS (lower(CAST(col2_1 AS TEXT))) STORED, col2_10 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "co!l2_4" IS NULL THEN e'\x15E~'::TEXT ELSE e'\x11Z'::TEXT END) STORED, col2_11 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col2_1 AS TEXT))) STORED, col2_12 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col�2\\x89_%bc3" IS NULL THEN e'\x00'::TEXT ELSE ''::TEXT END) STORED, col2_13 TEXT NOT NULL GENERATED ALWAYS AS (lower(col2_2)) STORED, col2_14 TEXT GENERATED ALWAYS AS (lower(CAST(col2_8 AS TEXT))) STORED, col2_15 FLOAT8 NOT NULL GENERATED ALWAYS AS ("col 2_""5" + (-0.2320139855146408)::FLOAT8) STORED, "co
        postgres_1    |     l2_16" TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col2_0 AS TEXT))) STORED, PRIMARY KEY ("co!l2_4", "col�2\\x89_%bc3", col2_1, col2_7, col2_10, col2_8, col2_11, col2_12, col2_2, "col 2_""5"));
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (606.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 (1.09s)
        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{\\U00106225le2" (col2_0 TSVECTOR NOT NULL, col2_1 TEXT NOT NULL, col2_2 "char" NOT NULL, "col�2\\x89_%bc3" TIMESTAMP NOT NULL, "co!l2_4" INTERVAL NOT NULL, "col 2_""5" FLOAT4 NOT NULL, cő😟l2_6 DATE NULL, col2_7 DECIMAL[] NOT NULL, col2_8 BIT(15) NOT NULL, col2͍_9 TEXT GENERATED ALWAYS AS (lower(CAST(col2_1 AS TEXT))) STORED, col2_10 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "co!l2_4" IS NULL THEN e'\x15E~'::TEXT ELSE e'\x11Z'::TEXT END) STORED, col2_11 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col2_1 AS TEXT))) STORED, col2_12 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col�2\\x89_%bc3" IS NULL THEN e'\x00'::TEXT ELSE ''::TEXT END) STORED, col2_13 TEXT NOT NULL GENERATED ALWAYS AS (lower(col2_2)) STORED, col2_14 TEXT GENERATED ALWAYS AS (lower(CAST(col2_8 AS TEXT))) STORED, col2_15 FLOAT8 NOT NULL GENERATED ALWAYS AS ("col 2_""5" + (-0.2320139855146408)::FLOAT8) STORED, "co
        test_1        |             l2_16" TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col2_0 AS TEXT))) STORED, PRIMARY KEY ("co!l2_4", "col�2\\x89_%bc3", col2_1, col2_7, col2_10, col2_8, col2_11, col2_12, col2_2, "col 2_""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_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (630.17s)

Help

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

Same failure on other branches

- #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 0deb53feff42298da826b13a0370d81eb9203e99:

        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/TestComposeCompare1625023031/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("010300000000000000"),
        test_1        |             +   string("010300000001000000050000000000000000000840000000000000184000000000000008400000000000000840000000000000000000000000000008400000000000000000000000000000184000000000000008400000000000001840"),
        test_1        |                 s"2000-01-07 00:00:00 +0000 UTC",
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makeenvelope(3.0:::FLOAT8::FLOAT8::FLOAT8, 6.0:::FLOAT8::FLOAT8::FLOAT8, 0.0:::FLOAT8::FLOAT8::FLOAT8, 3.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS col255767,
        test_1        |                         '2000-01-07':::DATE::DATE AS col255768
        test_1        |                 )
        test_1        |                     AS tab147536
        test_1        |             ORDER BY
        test_1        |                 col255767 DESC NULLS FIRST, col255768 DESC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makeenvelope(3.0::FLOAT8::FLOAT8::FLOAT8, 6.0::FLOAT8::FLOAT8::FLOAT8, 0.0::FLOAT8::FLOAT8::FLOAT8, 3.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS col255767,
        test_1        |                         '2000-01-07'::DATE::DATE AS col255768
        test_1        |                 )
        test_1        |                     AS tab147536
        test_1        |             ORDER BY
        test_1        |                 col255767 DESC NULLS FIRST, col255768 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:124: exit status 1
--- FAIL: TestComposeCompare (843.32s)

Help

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

Same failure on other branches

- #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 1bf58a144bf53b0480cdd108d269fc7724875cf1:

        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare2030486832/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("C0.69314718055994530942"),
        test_1        |             +   string("C0.6931471805599453"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         COALESCE(
        test_1        |                             st_ashexewkb(NULL::GEOMETRY::GEOMETRY)::STRING,
        test_1        |                             ('C':::STRING::STRING::STRING || ln(2:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::STRING
        test_1        |                         )
        test_1        |                             AS col846563
        test_1        |                 )
        test_1        |                     AS tab507002
        test_1        |             ORDER BY
        test_1        |                 col846563;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         COALESCE(
        test_1        |                             st_ashexewkb(NULL::GEOMETRY::GEOMETRY)::TEXT,
        test_1        |                             ('C'::TEXT::TEXT::TEXT || ln(2::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::TEXT
        test_1        |                         )
        test_1        |                             AS col846563
        test_1        |                 )
        test_1        |                     AS tab507002
        test_1        |             ORDER BY
        test_1        |                 col846563;
        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:124: exit status 1
--- FAIL: TestComposeCompare (1123.44s)

Help

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

Same failure on other branches

- #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 85b8891c39752799b28e0b8eb9e805422ab5b427:

        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/TestComposeCompare2039952195/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        |             -   nil,
        test_1        |             +   string("01010000000000000000A976400000000000706440"),
        test_1        |                 nil,
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_affine(st_pointfromgeohash('G':::STRING::STRING::STRING, NULL::INT4::INT4)::GEOMETRY::GEOMETRY, 8.0:::FLOAT8::FLOAT8::FLOAT8, (((7.0:::FLOAT8::FLOAT8::FLOAT8 * 1.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8 * 9.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8 / 8.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, 8.0:::FLOAT8::FLOAT8::FLOAT8, 5.0:::FLOAT8::FLOAT8::FLOAT8, (8.0:::FLOAT8::FLOAT8::FLOAT8 + 3.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, (COALESCE(1.0:::FLOAT8::FLOAT8, 7.0:::FLOAT8::FLOAT8)::FLOAT8 * 6.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS "col
309879",
        test_1        |                         NULL::TIME[] AS col309880
        test_1        |                 )
        test_1        |                     AS tab170183
        test_1        |             ORDER BY
        test_1        |                 "col
309879" NULLS LAST, col309880 DESC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_affine(st_pointfromgeohash('G'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::GEOMETRY::GEOMETRY, 8.0::FLOAT8::FLOAT8::FLOAT8, (((7.0::FLOAT8::FLOAT8::FLOAT8 * 1.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8 * 9.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8 / 8.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, 8.0::FLOAT8::FLOAT8::FLOAT8, 5.0::FLOAT8::FLOAT8::FLOAT8, (8.0::FLOAT8::FLOAT8::FLOAT8 + 3.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, (COALESCE(1.0::FLOAT8::FLOAT8, 7.0::FLOAT8::FLOAT8)::FLOAT8 * 6.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS "col
309879",
        test_1        |                         NULL::TIME[] AS col309880
        test_1        |                 )
        test_1        |                     AS tab170183
        test_1        |             ORDER BY
        test_1        |                 "col
309879" NULLS LAST, col309880 DESC;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (841.77s)

Help

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

Same failure on other branches

- #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ cfadb904a838f5bc6a402b034501a0d7cee38cd8:

        cockroach1_1  | status:              initialized new cluster
        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    | waiting for server to shut down...2023-10-07 05:17:37.101 UTC [49] LOG:  received fast shutdown request
        postgres_1    | .2023-10-07 05:17:37.103 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2023-10-07 05:17:37.105 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2023-10-07 05:17:37.107 UTC [51] LOG:  shutting down
        postgres_1    | 2023-10-07 05:17:37.197 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-10-07 05:17:37.222 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-10-07 05:17:37.222 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2023-10-07 05:17:37.222 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2023-10-07 05:17:37.225 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2023-10-07 05:17:37.230 UTC [68] LOG:  database system was shut down at 2023-10-07 05:17:37 UTC
        postgres_1    | 2023-10-07 05:17:37.235 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-10-07 05:17:39.360 UTC [78] ERROR:  foreign key constraint "t%qable1_col1_7_fkey" cannot be implemented
        postgres_1    | 2023-10-07 05:17:39.360 UTC [78] DETAIL:  Key columns "col1_7" and "col2_1" are of incompatible types: character varying and "char".
        postgres_1    | 2023-10-07 05:17:39.360 UTC [78] STATEMENT:  ALTER TABLE "t%qable1" ADD FOREIGN KEY (col1_7) REFERENCES "taBle2" (col2_1) ON DELETE CASCADE ON UPDATE RESTRICT
        test_1        | --- FAIL: TestCompare (606.03s)
        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 (1.22s)
        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: ALTER TABLE "t%qable1" ADD FOREIGN KEY (col1_7) REFERENCES "taBle2" (col2_1) ON DELETE CASCADE ON UPDATE RESTRICT
        test_1        |         compare_test.go:173: postgres: exec: ERROR: foreign key constraint "t%qable1_col1_7_fkey" cannot be implemented (SQLSTATE 42804)
        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:124: exit status 1
--- FAIL: TestComposeCompare (629.86s)

Help

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

Same failure on other branches

- #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 30cd7fc605e1d05f4a37750806052625d7b9fae1:

        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare1323643892/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("POINT Z (0 2 0)"),
        test_1        |             +   string("POINT(0 2 0)"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         CASE
        test_1        |                         WHEN false::BOOL THEN 'C':::STRING::STRING
        test_1        |                         ELSE st_asewkt(st_force3dz(COALESCE(st_point(0.0:::FLOAT8::FLOAT8::FLOAT8, 2.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY, NULL::GEOMETRY)::GEOMETRY)::GEOMETRY::GEOMETRY)::STRING
        test_1        |                         END
        test_1        |                             AS "col%p109792"
        test_1        |                 )
        test_1        |                     AS " tab125848"
        test_1        |             ORDER BY
        test_1        |                 "col%p109792" NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         CASE
        test_1        |                         WHEN false::BOOL THEN 'C'::TEXT::TEXT
        test_1        |                         ELSE st_asewkt(st_force3dz(COALESCE(st_point(0.0::FLOAT8::FLOAT8::FLOAT8, 2.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY, NULL::GEOMETRY)::GEOMETRY)::GEOMETRY::GEOMETRY)::TEXT
        test_1        |                         END
        test_1        |                             AS "col%p109792"
        test_1        |                 )
        test_1        |                     AS " tab125848"
        test_1        |             ORDER BY
        test_1        |                 "col%p109792" 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:124: exit status 1
--- FAIL: TestComposeCompare (761.45s)

Help

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

Same failure on other branches

- #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 1d5f07d043035d14735c328a59384cd96cb47b09:

        postgres_1    | 2023-10-12 05:17:13.334 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-10-12 05:17:13.334 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2023-10-12 05:17:13.334 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2023-10-12 05:17:13.338 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2023-10-12 05:17:13.343 UTC [68] LOG:  database system was shut down at 2023-10-12 05:17:13 UTC
        postgres_1    | 2023-10-12 05:17:13.349 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-10-12 05:27:16.489 UTC [98] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2023-10-12 05:27:16.489 UTC [98] STATEMENT:  CREATE TABLE "t ab😍le
        postgres_1    |     2" (col2_0 FLOAT4[] NOT NULL, col2_1 GEOGRAPHY NOT NULL, col2_2 TIMESTAMP NOT NULL, "c͡\\x9aol2_3" INT8 NOT NULL, "co l2_4" DATE, col2_5 TEXT NOT NULL, "col�2_6" TIMESTAMP NOT NULL, col2_7 BOOL NOT NULL, "col2_%p8" DATE NOT NULL, col2_9 TEXT NOT NULL, "col2 _10" TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_0 IS NULL THEN 't15~$x)'::TEXT ELSE ''::TEXT END) STORED, col2_11 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_0 IS NULL THEN e'U\x0e\x0f\x13=hz'::TEXT ELSE e'\x07'::TEXT END) STORED, col2_12 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_0 IS NULL THEN e'\x00'::TEXT ELSE ''::TEXT END) STORED, "c
        postgres_1    |     ol2_13" TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_2 IS NULL THEN e'+BX76<9\x05K'::TEXT ELSE e'\'\''::TEXT END) STORED, col2_14 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_2 IS NULL THEN e'\x1aE^F)k\x054A'::TEXT ELSE NULL END) STORED, col2_15 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col2_%p8" IS NULL THEN e'\x10%'::TEXT ELSE e'~&\x02iX'::TEXT END) STORED, "-col2_16" TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col2_%p8" IS NULL THEN e'``\t\x14\ff.f F'::TEXT ELSE 'exo'::TEXT END) STORED, col2_17 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col2_7 AS TEXT))) STORED, PRIMARY KEY (col2_11, "c
        postgres_1    |     ol2_13", "col�2_6", col2_14, col2_15, "-col2_16", col2_0, col2_12, col2_9, col2_7, "col2_%p8", "col2 _10", col2_2, col2_5));
        postgres_1    |     CREATE UNIQUE INDEX ON "t ab😍le
        postgres_1    |     2" (col2_5, "col�2_6" ASC, col2_12 ASC) INCLUDE ("c͡\\x9aol2_3", "co l2_4");
        postgres_1    |     CREATE UNIQUE INDEX ON "t ab😍le
        postgres_1    |     2" (col2_12 DESC, col2_15 ASC, (CASE WHEN col2_0 IS NULL THEN e'{\x17>dq%'::TEXT ELSE e'\x19'::TEXT END), "-col2_16" ASC, col2_11 DESC, col2_7 ASC, "co l2_4" ASC, col2_17);
        postgres_1    |     CREATE INDEX ON "t ab😍le
        postgres_1    |     2" (col2_11, "-col2_16" ASC, col2_9, col2_0 DESC, col2_12 DESC, "col�2_6" ASC);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (606.46s)
        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.55s)
        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 ab😍le
        test_1        |             2" (col2_0 FLOAT4[] NOT NULL, col2_1 GEOGRAPHY NOT NULL, col2_2 TIMESTAMP NOT NULL, "c͡\\x9aol2_3" INT8 NOT NULL, "co l2_4" DATE, col2_5 TEXT NOT NULL, "col�2_6" TIMESTAMP NOT NULL, col2_7 BOOL NOT NULL, "col2_%p8" DATE NOT NULL, col2_9 TEXT NOT NULL, "col2 _10" TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_0 IS NULL THEN 't15~$x)'::TEXT ELSE ''::TEXT END) STORED, col2_11 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_0 IS NULL THEN e'U\x0e\x0f\x13=hz'::TEXT ELSE e'\x07'::TEXT END) STORED, col2_12 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_0 IS NULL THEN e'\x00'::TEXT ELSE ''::TEXT END) STORED, "c
        test_1        |             ol2_13" TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_2 IS NULL THEN e'+BX76<9\x05K'::TEXT ELSE e'\'\''::TEXT END) STORED, col2_14 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_2 IS NULL THEN e'\x1aE^F)k\x054A'::TEXT ELSE NULL END) STORED, col2_15 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col2_%p8" IS NULL THEN e'\x10%'::TEXT ELSE e'~&\x02iX'::TEXT END) STORED, "-col2_16" TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col2_%p8" IS NULL THEN e'``\t\x14\ff.f F'::TEXT ELSE 'exo'::TEXT END) STORED, col2_17 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col2_7 AS TEXT))) STORED, PRIMARY KEY (col2_11, "c
        test_1        |             ol2_13", "col�2_6", col2_14, col2_15, "-col2_16", col2_0, col2_12, col2_9, col2_7, "col2_%p8", "col2 _10", col2_2, col2_5));
        test_1        |             CREATE UNIQUE INDEX ON "t ab😍le
        test_1        |             2" (col2_5, "col�2_6" ASC, col2_12 ASC) INCLUDE ("c͡\\x9aol2_3", "co l2_4");
        test_1        |             CREATE UNIQUE INDEX ON "t ab😍le
        test_1        |             2" (col2_12 DESC, col2_15 ASC, (CASE WHEN col2_0 IS NULL THEN e'{\x17>dq%'::TEXT ELSE e'\x19'::TEXT END), "-col2_16" ASC, col2_11 DESC, col2_7 ASC, "co l2_4" ASC, col2_17);
        test_1        |             CREATE INDEX ON "t ab😍le
        test_1        |             2" (col2_11, "-col2_16" ASC, col2_9, col2_0 DESC, col2_12 DESC, "col�2_6" ASC);
        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:124: exit status 1
--- FAIL: TestComposeCompare (630.65s)

Help

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

Same failure on other branches

- #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 1d5f07d043035d14735c328a59384cd96cb47b09:

        postgres_1    |                             "t""a.%pb102390".col1_4 ASC
        postgres_1    |                     )
        postgres_1    |         )
        postgres_1    |             AS "ta&b102391"
        postgres_1    |     ORDER BY
        postgres_1    |         col190217 DESC NULLS FIRST, col190218 DESC NULLS FIRST
        test_1        | --- FAIL: TestCompare (714.61s)
        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 (110.70s)
        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/TestComposeCompare963730227/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("0.0699268119435104G"),
        test_1        |             +   string("0.06992681194351043G"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT (tand(4.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8 || 'G':::STRING::STRING::STRING)::STRING AS "Col190232")
        test_1        |                     AS tab102394
        test_1        |             ORDER BY
        test_1        |                 "Col190232" ASC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT (tand(4.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8 || 'G'::TEXT::TEXT::TEXT)::TEXT AS "Col190232")
        test_1        |                     AS tab102394
        test_1        |             ORDER BY
        test_1        |                 "Col190232" ASC NULLS LAST;
        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:124: exit status 1
--- FAIL: TestComposeCompare (738.49s)

Help

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

Same failure on other branches

- #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 366fe013b4b63bef98c953d03b302dc5e0b13ee7:

        postgres_1    |             FROM
        postgres_1    |                 postgres.public.table4 AS tab436450
        postgres_1    |             WHERE
        postgres_1    |                 NULL::BOOL
        postgres_1    |         )
        postgres_1    |             AS tab436451
        postgres_1    |     ORDER BY
        postgres_1    |         "c%7fol}805376" DESC, col805377 DESC NULLS LAST, " c ol805378" DESC NULLS LAST
        test_1        | --- FAIL: TestCompare (1167.89s)
        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 (562.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:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare1898697998/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        |             -   nil,
        test_1        |             +   string("0103000000010000000500000000000000008046C0000000000080464000000000008046C00000000000805640000000000000000000000000008056400000000000000000000000000080464000000000008046C00000000000804640"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT st_geomfromgeohash('G':::STRING::STRING::STRING, NULL::INT4::INT4)::GEOMETRY AS "co l805379") AS tab436452
        test_1        |             ORDER BY
        test_1        |                 "co l805379" ASC NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT st_geomfromgeohash('G'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::GEOMETRY AS "co l805379") AS tab436452
        test_1        |             ORDER BY
        test_1        |                 "co l805379" 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:124: exit status 1
--- FAIL: TestComposeCompare (1192.72s)

Help

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

Same failure on other branches

- #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 67bb386635d1dde8095e1c62f95aceb875616d49:

        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/TestComposeCompare3393269208/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        |                 nil,
        test_1        |             -   string("00:00:09e"),
        test_1        |             +   string("00:00:09E"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         NULL::rand_typ_4 AS col83876,
        test_1        |                         initcap(('00:00:09':::INTERVAL::INTERVAL::INTERVAL || 'E':::STRING::STRING::STRING)::STRING::STRING)::STRING
        test_1        |                             AS col83877
        test_1        |                 )
        test_1        |                     AS tab49094
        test_1        |             ORDER BY
        test_1        |                 col83876 DESC NULLS FIRST, col83877 DESC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         NULL::rand_typ_4 AS col83876,
        test_1        |                         initcap(('00:00:09'::INTERVAL::INTERVAL::INTERVAL || 'E'::TEXT::TEXT::TEXT)::TEXT::TEXT)::TEXT
        test_1        |                             AS col83877
        test_1        |                 )
        test_1        |                     AS tab49094
        test_1        |             ORDER BY
        test_1        |                 col83876 DESC NULLS FIRST, col83877 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_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (691.96s)

Help

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

Same failure on other branches

- #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ c04478348d7a7e11fb05b434264fe533bdad0881:

        postgres_1    |                 "tab|162163"."\gcol4_0",
        postgres_1    |                 "tab|162163"."co%l4/_6"
        postgres_1    |             HAVING
        postgres_1    |                 every(true::BOOL::BOOL)::BOOL
        postgres_1    |         )
        postgres_1    |             AS tab162164
        postgres_1    |     ORDER BY
        postgres_1    |         col300182 ASC NULLS LAST, col300183 NULLS LAST
        test_1        | --- FAIL: TestCompare (791.10s)
        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 (186.82s)
        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/TestComposeCompare185980318/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        |             -   int32(79),
        test_1        |             +   int32(78),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT int4(atand(5.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT4 AS col300276) AS "ta😱b""162223"
        test_1        |             ORDER BY
        test_1        |                 col300276 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT int4(atand(5.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT4 AS col300276) AS "ta😱b""162223"
        test_1        |             ORDER BY
        test_1        |                 col300276 NULLS FIRST;
        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:124: exit status 1
--- FAIL: TestComposeCompare (815.19s)

Help

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

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ ff444373b429926c6686eae90ad2fcc9551c4dff:

        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | 2023-10-20 05:16:48.981 UTC [49] LOG:  received fast shutdown request
        postgres_1    | waiting for server to shut down....2023-10-20 05:16:48.983 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2023-10-20 05:16:48.984 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2023-10-20 05:16:48.986 UTC [51] LOG:  shutting down
        postgres_1    | 2023-10-20 05:16:49.077 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-10-20 05:16:49.102 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-10-20 05:16:49.102 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2023-10-20 05:16:49.102 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2023-10-20 05:16:49.105 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2023-10-20 05:16:49.110 UTC [68] LOG:  database system was shut down at 2023-10-20 05:16:49 UTC
        postgres_1    | 2023-10-20 05:16:49.114 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-10-20 05:16:50.105 UTC [78] ERROR:  invalid input syntax for type numeric: "-Infinity" at character 666
        postgres_1    | 2023-10-20 05:16:50.105 UTC [78] STATEMENT:  CREATE TABLE "\vtable4" (col4_0 TEXT NOT NULL, col4_1 DECIMAL NOT NULL, col4_2 INET NULL, "col4(""_3" VARCHAR NOT NULL, _col4_4 TIMESTAMP NOT NULL, col4_5 REGTYPE NOT NULL, "col4_́'6" TEXT NOT NULL GENERATED ALWAYS AS (lower(col4_0)) STORED, "Col4_""7" TEXT NOT NULL GENERATED ALWAYS AS (lower(col4_0)) STORED, "col 4_8" DECIMAL NOT NULL GENERATED ALWAYS AS (col4_1 + (-20.3673765570856152)::DECIMAL) STORED, "�c̝ol4_9" TEXT NULL GENERATED ALWAYS AS (lower(CAST(col4_2 AS TEXT))) STORED, PRIMARY KEY (col4_5, "col4(""_3", _col4_4));
        postgres_1    |     CREATE INDEX ON "\vtable4" ("col 4_8" ASC, "col4(""_3", col4_5 ASC, col4_2, _col4_4 DESC, "�c̝ol4_9", "col4_́'6", col4_0, (col4_1 + '-Infinity'::DECIMAL), "Col4_""7");
        postgres_1    |     CREATE INDEX ON "\vtable4" ("�c̝ol4_9" DESC, "col4(""_3" DESC, col4_5 ASC, "Col4_""7" DESC, "col4_́'6", col4_0, _col4_4 ASC, col4_2 ASC) INCLUDE (col4_1);
        postgres_1    |     CREATE UNIQUE INDEX ON "\vtable4" ("�c̝ol4_9" ASC);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (605.02s)
        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.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 "\vtable4" (col4_0 TEXT NOT NULL, col4_1 DECIMAL NOT NULL, col4_2 INET NULL, "col4(""_3" VARCHAR NOT NULL, _col4_4 TIMESTAMP NOT NULL, col4_5 REGTYPE NOT NULL, "col4_́'6" TEXT NOT NULL GENERATED ALWAYS AS (lower(col4_0)) STORED, "Col4_""7" TEXT NOT NULL GENERATED ALWAYS AS (lower(col4_0)) STORED, "col 4_8" DECIMAL NOT NULL GENERATED ALWAYS AS (col4_1 + (-20.3673765570856152)::DECIMAL) STORED, "�c̝ol4_9" TEXT NULL GENERATED ALWAYS AS (lower(CAST(col4_2 AS TEXT))) STORED, PRIMARY KEY (col4_5, "col4(""_3", _col4_4));
        test_1        |             CREATE INDEX ON "\vtable4" ("col 4_8" ASC, "col4(""_3", col4_5 ASC, col4_2, _col4_4 DESC, "�c̝ol4_9", "col4_́'6", col4_0, (col4_1 + '-Infinity'::DECIMAL), "Col4_""7");
        test_1        |             CREATE INDEX ON "\vtable4" ("�c̝ol4_9" DESC, "col4(""_3" DESC, col4_5 ASC, "Col4_""7" DESC, "col4_́'6", col4_0, _col4_4 ASC, col4_2 ASC) INCLUDE (col4_1);
        test_1        |             CREATE UNIQUE INDEX ON "\vtable4" ("�c̝ol4_9" 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_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:124: exit status 1
--- FAIL: TestComposeCompare (628.93s)

Help

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

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ caaad29e5f92d11d926d2d9d8eb78b150e795e4d:

        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 (570.90s)
        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/TestComposeCompare3555020300/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("010300000000000000"),
        test_1        |             +   string("010300000001000000050000000000000000001040000000000000224000000000000010400000000000000000000000000000104000000000000000000000000000001040000000000000224000000000000010400000000000002240"),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makeenvelope(4.0::FLOAT8::FLOAT8::FLOAT8, 9.0::FLOAT8::FLOAT8::FLOAT8, 4.0::FLOAT8::FLOAT8::FLOAT8, 0.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS "col 740313"
        test_1        |                 )
        test_1        |                     AS " tab429722"
        test_1        |             ORDER BY
        test_1        |                 "col 740313" ASC NULLS LAST;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makeenvelope(4.0:::FLOAT8::FLOAT8::FLOAT8, 9.0:::FLOAT8::FLOAT8::FLOAT8, 4.0:::FLOAT8::FLOAT8::FLOAT8, 0.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS "col 740313"
        test_1        |                 )
        test_1        |                     AS " tab429722"
        test_1        |             ORDER BY
        test_1        |                 "col 740313" ASC 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:124: exit status 1
--- FAIL: TestComposeCompare (1200.64s)

Help

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

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ caaad29e5f92d11d926d2d9d8eb78b150e795e4d:

        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 (84.53s)
        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/TestComposeCompare443998404/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.714285714285714"),
        test_1        |             +   string("E0.7142857142857143"),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         ('E'::TEXT::TEXT::TEXT || (5.0::FLOAT8::FLOAT8::FLOAT8 / 7.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::TEXT
        test_1        |                             AS "cOl{133491"
        test_1        |                 )
        test_1        |                     AS tab68598
        test_1        |             ORDER BY
        test_1        |                 "cOl{133491" NULLS FIRST;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         ('E':::STRING::STRING::STRING || (5.0:::FLOAT8::FLOAT8::FLOAT8 / 7.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::STRING
        test_1        |                             AS "cOl{133491"
        test_1        |                 )
        test_1        |                     AS tab68598
        test_1        |             ORDER BY
        test_1        |                 "cOl{133491" 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:124: exit status 1
--- FAIL: TestComposeCompare (713.41s)

Help

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

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 942772ece66949001713bf1f41aaa97bba057cba:

        postgres_1    |         "col 593273" NULLS FIRST,
        postgres_1    |         "cOl593274" DESC NULLS LAST,
        postgres_1    |         col593275 ASC,
        postgres_1    |         col593276 DESC NULLS FIRST
        postgres_1    | 2023-10-24 05:24:11.066 UTC [78] ERROR:  collation "de_de" for encoding "UTF8" does not exist at character 34
        postgres_1    | 2023-10-24 05:24:11.066 UTC [78] STATEMENT:  SELECT * FROM (SELECT NULL::TEXT COLLATE de_DE AS col593285) AS "ta b290696" ORDER BY col593285 DESC
        test_1        | --- FAIL: TestCompare (1009.14s)
        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 (403.47s)
        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/TestComposeCompare1270075951/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("1C"),
        test_1        |             +   string("1.0000000000000000C"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT (exp(0:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || 'C':::STRING::STRING::STRING)::STRING AS col593375)
        test_1        |                     AS "%vtaB290728"
        test_1        |             ORDER BY
        test_1        |                 col593375 NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT (exp(0::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || 'C'::TEXT::TEXT::TEXT)::TEXT AS col593375)
        test_1        |                     AS "%vtaB290728"
        test_1        |             ORDER BY
        test_1        |                 col593375 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:124: exit status 1
--- FAIL: TestComposeCompare (1033.41s)

Help

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

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 7d70ac8dccaf3035ecf8c6f351b43d54fe6a4e26:

        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 (346.30s)
        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/TestComposeCompare3687848719/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("010300000000000000"),
        test_1        |             +   string("01030000000100000005000000000000000000004000000000000000400000000000000040000000000000F03F0000000000001C40000000000000F03F0000000000001C40000000000000004000000000000000400000000000000040"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makeenvelope(2.0:::FLOAT8::FLOAT8::FLOAT8, 2.0:::FLOAT8::FLOAT8::FLOAT8, 7.0:::FLOAT8::FLOAT8::FLOAT8, 1.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS col356665
        test_1        |                 )
        test_1        |                     AS tab209852
        test_1        |             ORDER BY
        test_1        |                 col356665 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makeenvelope(2.0::FLOAT8::FLOAT8::FLOAT8, 2.0::FLOAT8::FLOAT8::FLOAT8, 7.0::FLOAT8::FLOAT8::FLOAT8, 1.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS col356665
        test_1        |                 )
        test_1        |                     AS tab209852
        test_1        |             ORDER BY
        test_1        |                 col356665 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_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (975.89s)

Help

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

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 310f003cc3a1970ca5390bac408ed72e6e7ad996:

        postgres_1    |             FROM
        postgres_1    |                 postgres.public.table1 AS tab368462
        postgres_1    |             ORDER BY
        postgres_1    |                 tab368462.tableoid NULLS FIRST, tab368462.col1_0 DESC
        postgres_1    |         )
        postgres_1    |             AS tab368463
        postgres_1    |     ORDER BY
        postgres_1    |         col321715 NULLS FIRST, "co%pl321716" NULLS FIRST
        test_1        | --- FAIL: TestCompare (1024.06s)
        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 (419.38s)
        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/TestComposeCompare351092592/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        |             -   int32(202),
        test_1        |             +   int32(201),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT int4(sinh(6.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT4 AS 😭col321721) AS "t
ab368468"
        test_1        |             ORDER BY
        test_1        |                 😭col321721 ASC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT int4(sinh(6.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT4 AS 😭col321721) AS "t
ab368468"
        test_1        |             ORDER BY
        test_1        |                 😭col321721 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:124: exit status 1
--- FAIL: TestComposeCompare (1048.55s)

Help

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

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 7eb95880d348e5e65b1cb133b9d7d505a035b078:

        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 (167.43s)
        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/TestComposeCompare3521436613/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("G2.5000000000000000000"),
        test_1        |             +   string("G2.5000000000000000"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         ('G':::STRING::STRING::STRING || (5:::INT8::INT8::INT8 / 2:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::STRING
        test_1        |                             AS col214078
        test_1        |                 )
        test_1        |                     AS "taB136710"
        test_1        |             ORDER BY
        test_1        |                 col214078 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         ('G'::TEXT::TEXT::TEXT || (5::INT8::INT8::INT8 / 2::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::TEXT
        test_1        |                             AS col214078
        test_1        |                 )
        test_1        |                     AS "taB136710"
        test_1        |             ORDER BY
        test_1        |                 col214078 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:124: exit status 1
--- FAIL: TestComposeCompare (796.59s)

Help

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

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ bd8bf50082a06dc4c1e8defbcd4a7357f7e5d1f7:

        postgres_1    | 2023-10-28 05:16:35.344 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-10-28 05:16:35.368 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-10-28 05:16:35.368 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2023-10-28 05:16:35.368 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2023-10-28 05:16:35.371 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2023-10-28 05:16:35.376 UTC [68] LOG:  database system was shut down at 2023-10-28 05:16:35 UTC
        postgres_1    | 2023-10-28 05:16:35.380 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-10-28 05:16:36.353 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2023-10-28 05:16:36.353 UTC [78] STATEMENT:  CREATE TABLE table1 ("col1 _0" INET NOT NULL, "col1!_1" TEXT NOT NULL, col1_2 TEXT NOT NULL, "col1'_3" INET NOT NULL, "co�l_1%v_4" REGCLASS NOT NULL, col1_5 REGCLASS NOT NULL, "col1%56_6" INT2 NOT NULL, col1__7 REGCLASS NOT NULL, col1_8 INTERVAL NOT NULL, col1_9 BOOL NOT NULL, col1_10 UUID NOT NULL, col1_11 TEXT NOT NULL GENERATED ALWAYS AS (lower("col1!_1")) STORED, "col1 _12" TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST("col1 _0" AS TEXT))) STORED, PRIMARY KEY (col1_2, "col1 _12", col1_11, col1_8, "co�l_1%v_4", "col1 _0", col1__7, col1_9, col1_5, "col1'_3", "col1!_1", "col1%56_6", col1_10));
        postgres_1    |     CREATE INDEX ON table1 ("col1%56_6" DESC, col1__7, col1_5 ASC);
        postgres_1    |     CREATE UNIQUE INDEX ON table1 (col1_11, "col1'_3" DESC, col1_2, col1_10 ASC, (CASE WHEN "co�l_1%v_4" IS NULL THEN e'8\x15b\f'::TEXT ELSE 'e'::TEXT END) DESC, "col1!_1", "col1 _12");
        postgres_1    |     CREATE INDEX ON table1 (col1_8 DESC, "col1 _12" DESC, col1_5 ASC, col1_2, col1_11);
        postgres_1    |     CREATE INDEX ON table1 (col1_10, "col1 _0" DESC, (CASE WHEN "co�l_1%v_4" IS NULL THEN e'\x00'::TEXT ELSE ''::TEXT END) DESC, col1_2 ASC, "co�l_1%v_4" ASC, lower(CAST("col1 _0" AS TEXT)) DESC, col1_8, "col1 _12", col1__7 DESC, col1_5 ASC, "col1%56_6", col1_9);
        postgres_1    |     CREATE UNIQUE INDEX ON table1 (col1_5 ASC);
        postgres_1    |     CREATE UNIQUE INDEX ON table1 (col1_10, "col1 _12" DESC, "col1%56_6" ASC, col1_8);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (605.40s)
        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.87s)
        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 table1 ("col1 _0" INET NOT NULL, "col1!_1" TEXT NOT NULL, col1_2 TEXT NOT NULL, "col1'_3" INET NOT NULL, "co�l_1%v_4" REGCLASS NOT NULL, col1_5 REGCLASS NOT NULL, "col1%56_6" INT2 NOT NULL, col1__7 REGCLASS NOT NULL, col1_8 INTERVAL NOT NULL, col1_9 BOOL NOT NULL, col1_10 UUID NOT NULL, col1_11 TEXT NOT NULL GENERATED ALWAYS AS (lower("col1!_1")) STORED, "col1 _12" TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST("col1 _0" AS TEXT))) STORED, PRIMARY KEY (col1_2, "col1 _12", col1_11, col1_8, "co�l_1%v_4", "col1 _0", col1__7, col1_9, col1_5, "col1'_3", "col1!_1", "col1%56_6", col1_10));
        test_1        |             CREATE INDEX ON table1 ("col1%56_6" DESC, col1__7, col1_5 ASC);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_11, "col1'_3" DESC, col1_2, col1_10 ASC, (CASE WHEN "co�l_1%v_4" IS NULL THEN e'8\x15b\f'::TEXT ELSE 'e'::TEXT END) DESC, "col1!_1", "col1 _12");
        test_1        |             CREATE INDEX ON table1 (col1_8 DESC, "col1 _12" DESC, col1_5 ASC, col1_2, col1_11);
        test_1        |             CREATE INDEX ON table1 (col1_10, "col1 _0" DESC, (CASE WHEN "co�l_1%v_4" IS NULL THEN e'\x00'::TEXT ELSE ''::TEXT END) DESC, col1_2 ASC, "co�l_1%v_4" ASC, lower(CAST("col1 _0" AS TEXT)) DESC, col1_8, "col1 _12", col1__7 DESC, col1_5 ASC, "col1%56_6", col1_9);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_5 ASC);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_10, "col1 _12" DESC, "col1%56_6" ASC, col1_8);
        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:124: exit status 1
--- FAIL: TestComposeCompare (629.09s)

Help

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

Same failure on other branches

- #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] - #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 0a04f59b9d15987525620fb047fc0c3d65854738:

        test_1        |         compare_test.go:203: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |                 []uint8{
        test_1        |                     0x81,
        test_1        |                     0x08,
        test_1        |             -       0x09,
        test_1        |             +       0x69,
        test_1        |                     0x00,
        test_1        |                     0x80,
        test_1        |                     ... // 4 identical elements
        test_1        |                 },
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_astwkb(st_makepoint(0.0:::FLOAT8::FLOAT8::FLOAT8, 4.0:::FLOAT8::FLOAT8::FLOAT8, 3.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY, 4:::INT8::INT4::INT4, 2:::INT8::INT4::INT4, 3:::INT8::INT4::INT4)::BYTES
        test_1        |                             AS "col'159347"
        test_1        |                 )
        test_1        |                     AS "t̯a,b110256"
        test_1        |             ORDER BY
        test_1        |                 "col'159347";
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_astwkb(st_makepoint(0.0::FLOAT8::FLOAT8::FLOAT8, 4.0::FLOAT8::FLOAT8::FLOAT8, 3.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY, 4::INT8::INT4::INT4, 2::INT8::INT4::INT4, 3::INT8::INT4::INT4)::BYTEA
        test_1        |                             AS "col'159347"
        test_1        |                 )
        test_1        |                     AS "t̯a,b110256"
        test_1        |             ORDER BY
        test_1        |                 "col'159347";
        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:124: exit status 1
--- FAIL: TestComposeCompare (783.73s)

Help

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

Same failure on other branches

- #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] - #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 year ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 239099ef36e3f729d52ff1b5690d1452e07299c6:

        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 (556.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:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare1890274590/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("::7/0I"),
        test_1        |             +   string("::7/0i"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         initcap(('::7/0':::INET::INET::INET || 'I':::STRING::STRING::STRING)::STRING::STRING)::STRING
        test_1        |                             AS "col\g733207"
        test_1        |                 )
        test_1        |                     AS tab413432
        test_1        |             ORDER BY
        test_1        |                 "col\g733207" NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         initcap(('::7/0'::INET::INET::INET || 'I'::TEXT::TEXT::TEXT)::TEXT::TEXT)::TEXT
        test_1        |                             AS "col\g733207"
        test_1        |                 )
        test_1        |                     AS tab413432
        test_1        |             ORDER BY
        test_1        |                 "col\g733207" NULLS FIRST;
        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:124: exit status 1
--- FAIL: TestComposeCompare (1187.24s)

Help

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

Same failure on other branches

- #113814 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2.17-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] - #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 12 months ago

compose.TestComposeCompare failed with artifacts on release-23.1 @ 2f6bd0a1dec77b7a4c947ec7dc1bf250b7038d05:

        postgres_1    |     ORDER BY
        postgres_1    |         col646016,
        postgres_1    |         col646017 ASC NULLS LAST,
        postgres_1    |         c😗ol646018 ASC NULLS LAST,
        postgres_1    |         "col%q646019" ASC NULLS LAST,
        postgres_1    |         "c\\U001095A9ol646020"
        test_1        | --- FAIL: TestCompare (1036.30s)
        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 (431.26s)
        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/TestComposeCompare4001203848/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        |             -   nil,
        test_1        |             +   string("010300000001000000050000000000000000E060C000000000008046400000000000E060C0000000000080564000000000008056C0000000000080564000000000008056C000000000008046400000000000E060C00000000000804640"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT st_geomfromgeohash('C':::STRING::STRING::STRING, NULL::INT4::INT4)::GEOMETRY AS "{col646026")
        test_1        |                     AS "t-ab368720"
        test_1        |             ORDER BY
        test_1        |                 "{col646026" ASC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT st_geomfromgeohash('C'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::GEOMETRY AS "{col646026")
        test_1        |                     AS "t-ab368720"
        test_1        |             ORDER BY
        test_1        |                 "{col646026" ASC 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:124: exit status 1
--- FAIL: TestComposeCompare (1061.25s)

Help

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

Same failure on other branches

- #113814 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2.17-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] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #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 release-23.1 @ a612b60e1ee2ac0b38fc7735b01715be0cbb790e:

        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/TestComposeCompare4038060239/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("00:02:00B1.2857142857142858"),
        test_1        |             +   string("00:02:00B1.28571428571429"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (('00:02:00':::TIME::TIME::TIME || 'B':::STRING::STRING::STRING)::STRING::STRING || (9.0:::FLOAT8::FLOAT8::FLOAT8 / 7.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::STRING
        test_1        |                             AS "col
        test_1        |             104802"
        test_1        |                 )
        test_1        |                     AS " tab58524"
        test_1        |             ORDER BY
        test_1        |                 "col
        test_1        |             104802" NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (('00:02:00'::TIME::TIME::TIME || 'B'::TEXT::TEXT::TEXT)::TEXT::TEXT || (9.0::FLOAT8::FLOAT8::FLOAT8 / 7.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::TEXT
        test_1        |                             AS "col
        test_1        |             104802"
        test_1        |                 )
        test_1        |                     AS " tab58524"
        test_1        |             ORDER BY
        test_1        |                 "col
        test_1        |             104802" 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:124: exit status 1
--- FAIL: TestComposeCompare (712.94s)

Help

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

Same failure on other branches

- #113814 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2.17-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] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #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 release-23.1 @ 1700413c09ff1cc391e1fb0560f8f6d8e5258d19:

        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare1031714871/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        |             -   int16(2),
        test_1        |             +   int16(3),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         CASE
        test_1        |                         WHEN false::BOOL THEN NULL::INT2
        test_1        |                         ELSE int2(sqrt(7.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT2
        test_1        |                         END
        test_1        |                             AS "%vcol'598333"
        test_1        |                 )
        test_1        |                     AS tab397979
        test_1        |             ORDER BY
        test_1        |                 "%vcol'598333" DESC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         CASE
        test_1        |                         WHEN false::BOOL THEN NULL::INT2
        test_1        |                         ELSE int2(sqrt(7.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT2
        test_1        |                         END
        test_1        |                             AS "%vcol'598333"
        test_1        |                 )
        test_1        |                     AS tab397979
        test_1        |             ORDER BY
        test_1        |                 "%vcol'598333" DESC 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:124: exit status 1
--- FAIL: TestComposeCompare (1170.18s)

Help

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

Same failure on other branches

- #113814 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2.17-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] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #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 release-23.1 @ 0c43ef7d21f6fa375b8a7f6088884f2fdf10952d:

        postgres_1    |             AS tab231779
        postgres_1    |     ORDER BY
        postgres_1    |         "col(361408" DESC NULLS FIRST,
        postgres_1    |         col361409 DESC NULLS FIRST,
        postgres_1    |         col361410 ASC,
        postgres_1    |         col361411 DESC NULLS LAST,
        postgres_1    |         "co\\u2E40l361412" ASC,
        postgres_1    |         CAST(😡col361413 AS TEXT) ASC NULLS FIRST
        test_1        | --- FAIL: TestCompare (878.45s)
        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 (274.55s)
        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/TestComposeCompare3532596115/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(2),
        test_1        |             +   int32(3),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT int4(asinh(9.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT4 AS "\\xf3co̧l361594") AS tab231876
        test_1        |             ORDER BY
        test_1        |                 "\\xf3co̧l361594" ASC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT int4(asinh(9.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT4 AS "\\xf3co̧l361594") AS tab231876
        test_1        |             ORDER BY
        test_1        |                 "\\xf3co̧l361594" ASC;
        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_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (902.86s)

Help

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

Same failure on other branches

- #113814 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2.17-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] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #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 release-23.1 @ 85392ec3a02bf344ab55b8e8154b27f5ab3f9a45:

        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 (8.09s)
        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/TestComposeCompare3679753943/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("A2097152"),
        test_1        |             +   string("A2097152.0000000000000000"),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         ('A'::TEXT::TEXT::TEXT || (8::INT8::INT8::INT8 ^ 7::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::TEXT
        test_1        |                             AS "col\\u103B6278"
        test_1        |                 )
        test_1        |                     AS tab3341
        test_1        |             ORDER BY
        test_1        |                 "col\\u103B6278" NULLS FIRST;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         ('A':::STRING::STRING::STRING || (8:::INT8::INT8::INT8 ^ 7:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::STRING
        test_1        |                             AS "col\\u103B6278"
        test_1        |                 )
        test_1        |                     AS tab3341
        test_1        |             ORDER BY
        test_1        |                 "col\\u103B6278" 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_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (636.43s)

Help

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

Same failure on other branches

- #113814 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2.17-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] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #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 release-23.1 @ 3e8713f9ffd60e20cc58d2df27da17f60ffad24a:

        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (374.05s)
        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/TestComposeCompare230154412/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        |                 nil,
        test_1        |             -   string("D3.7621956910836314"),
        test_1        |             +   string("D3.76219569108363"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         NULL::rand_typ_2 AS col560577,
        test_1        |                         ('D':::STRING::STRING::STRING || cosh(2.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::STRING AS "'col560578"
        test_1        |                 )
        test_1        |                     AS tab311842
        test_1        |             ORDER BY
        test_1        |                 col560577 DESC, "'col560578";
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         NULL::rand_typ_2 AS col560577,
        test_1        |                         ('D'::TEXT::TEXT::TEXT || cosh(2.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::TEXT AS "'col560578"
        test_1        |                 )
        test_1        |                     AS tab311842
        test_1        |             ORDER BY
        test_1        |                 col560577 DESC, "'col560578";
        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:124: exit status 1
--- FAIL: TestComposeCompare (1002.85s)

Help

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

Same failure on other branches

- #113814 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2.17-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] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #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 release-23.1 @ e268b992676d69661540d196be7248a9369c7396:

        postgres_1    | 
        postgres_1    | waiting for server to shut down...2023-11-21 06:17:18.178 UTC [49] LOG:  received fast shutdown request
        postgres_1    | .2023-11-21 06:17:18.181 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2023-11-21 06:17:18.182 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2023-11-21 06:17:18.184 UTC [51] LOG:  shutting down
        test_1        | I231121 06:17:18.233341 38 testutils/soon.go:41  [-] 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    | 2023-11-21 06:17:18.292 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-11-21 06:17:18.401 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-11-21 06:17:18.401 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2023-11-21 06:17:18.401 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2023-11-21 06:17:18.405 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2023-11-21 06:17:18.410 UTC [68] LOG:  database system was shut down at 2023-11-21 06:17:18 UTC
        postgres_1    | 2023-11-21 06:17:18.415 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-11-21 06:17:20.325 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2023-11-21 06:17:20.325 UTC [78] STATEMENT:  CREATE TABLE table1 (col1_0 INTERVAL NOT NULL, "col1_'1" INT2 NOT NULL, "col1_*2" INTERVAL NOT NULL, col1_3 REGTYPE NOT NULL, "'col1_4" DATE NOT NULL, "col1\\u5324_5" INTERVAL NOT NULL, col1_6 FLOAT8 NOT NULL, "col1    _7" TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col1\\u5324_5" IS NULL THEN e'\U00002603'::TEXT ELSE e'\x0f,h30\x1cD(.'::TEXT END) STORED, col1_8 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_0 IS NULL THEN ''::TEXT ELSE e'\x04\x1dHh\x1b\x10\x18\x18\x1e'::TEXT END) STORED, col1_9 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_0 IS NULL THEN ' W '::TEXT ELSE e'-{>\x05]"P'::TEXT END) STORED, 😥col1_10 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_3 IS NULL THEN e'5Y\x11%bS.G='::TEXT ELSE 'G^'::TEXT END) STORED, col1_11 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "'col1_4" IS NULL THEN e'\''::TEXT ELSE e'g_\x16>\x142'::TEXT END) STORED);
        postgres_1    |     CREATE UNIQUE INDEX ON table1 (col1_3, col1_11 ASC, "col1_'1" DESC, "col1_*2" ASC) INCLUDE ("'col1_4");
        postgres_1    |     CREATE UNIQUE INDEX ON table1 (col1_6 DESC) INCLUDE (col1_3, "'col1_4", "col1\\u5324_5");
        postgres_1    |     CREATE INDEX ON table1 (col1_3 DESC, "col1  _7" DESC, col1_0 ASC, (CASE WHEN col1_0 IS NULL THEN e'\x00'::TEXT ELSE e'7>\x1d\x05Fjf7\r'::TEXT END) DESC, 😥col1_10, col1_9, "col1\\u5324_5" DESC, (CASE WHEN "col1_*2" IS NULL THEN e'K\x02ybS;'::TEXT ELSE e'\''::TEXT END), col1_8 DESC) INCLUDE ("col1_*2", "'col1_4");
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (606.35s)
        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.08s)
        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 table1 (col1_0 INTERVAL NOT NULL, "col1_'1" INT2 NOT NULL, "col1_*2" INTERVAL NOT NULL, col1_3 REGTYPE NOT NULL, "'col1_4" DATE NOT NULL, "col1\\u5324_5" INTERVAL NOT NULL, col1_6 FLOAT8 NOT NULL, "col1    _7" TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col1\\u5324_5" IS NULL THEN e'\U00002603'::TEXT ELSE e'\x0f,h30\x1cD(.'::TEXT END) STORED, col1_8 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_0 IS NULL THEN ''::TEXT ELSE e'\x04\x1dHh\x1b\x10\x18\x18\x1e'::TEXT END) STORED, col1_9 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_0 IS NULL THEN ' W '::TEXT ELSE e'-{>\x05]"P'::TEXT END) STORED, 😥col1_10 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_3 IS NULL THEN e'5Y\x11%bS.G='::TEXT ELSE 'G^'::TEXT END) STORED, col1_11 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "'col1_4" IS NULL THEN e'\''::TEXT ELSE e'g_\x16>\x142'::TEXT END) STORED);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_3, col1_11 ASC, "col1_'1" DESC, "col1_*2" ASC) INCLUDE ("'col1_4");
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_6 DESC) INCLUDE (col1_3, "'col1_4", "col1\\u5324_5");
        test_1        |             CREATE INDEX ON table1 (col1_3 DESC, "col1  _7" DESC, col1_0 ASC, (CASE WHEN col1_0 IS NULL THEN e'\x00'::TEXT ELSE e'7>\x1d\x05Fjf7\r'::TEXT END) DESC, 😥col1_10, col1_9, "col1\\u5324_5" DESC, (CASE WHEN "col1_*2" IS NULL THEN e'K\x02ybS;'::TEXT ELSE e'\''::TEXT END), col1_8 DESC) INCLUDE ("col1_*2", "'col1_4");
        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_cockroach2_1 ... 
        Stopping compare_postgres_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:124: exit status 1
--- FAIL: TestComposeCompare (630.48s)

Help

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

Same failure on other branches

- #113814 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2.17-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] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #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 release-23.1 @ a591a687999f6b73f5489628b49ae768ce6a425e:

        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        |                 nil,
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (power(2::DECIMAL::DECIMAL::DECIMAL, 7::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || NULL::DECIMAL[]::DECIMAL[])::DECIMAL[]
        test_1        |                             AS col448601,
        test_1        |                         NULL::OIDVECTOR AS col448602
        test_1        |                 )
        test_1        |                     AS "tab'316981"
        test_1        |             ORDER BY
        test_1        |                 col448601 ASC NULLS FIRST, col448602 ASC;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (power(2:::DECIMAL::DECIMAL::DECIMAL, 7:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || NULL::DECIMAL[]::DECIMAL[])::DECIMAL[]
        test_1        |                             AS col448601,
        test_1        |                         NULL::OIDVECTOR AS col448602
        test_1        |                 )
        test_1        |                     AS "tab'316981"
        test_1        |             ORDER BY
        test_1        |                 col448601 ASC NULLS FIRST, col448602 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:124: exit status 1
--- FAIL: TestComposeCompare (942.53s)

Help

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

Same failure on other branches

- #113814 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2.17-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] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #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 release-23.1 @ 0f97132ad066321e6f65a83fe2098788162445ae:

        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/TestComposeCompare29346291/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        |                 strings.Join({
        test_1        |                     "BOX(-90 0,-89.99995708465576 0.000042915344238",
        test_1        |             -       "28125",
        test_1        |                     ")",
        test_1        |                 }, ""),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_box2dfromgeohash(('D':::STRING::STRING::STRING || '00000000-0000-0000-0000-000000000005':::UUID::UUID::UUID)::STRING::STRING, 9:::INT8::INT4::INT4)::BOX2D
        test_1        |                             AS "co l697537"
        test_1        |                 )
        test_1        |                     AS tab408632
        test_1        |             ORDER BY
        test_1        |                 CAST("co l697537" AS STRING) DESC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_box2dfromgeohash(('D'::TEXT::TEXT::TEXT || '00000000-0000-0000-0000-000000000005'::UUID::UUID::UUID)::TEXT::TEXT, 9::INT8::INT4::INT4)::BOX2D
        test_1        |                             AS "co l697537"
        test_1        |                 )
        test_1        |                     AS tab408632
        test_1        |             ORDER BY
        test_1        |                 CAST("co l697537" AS TEXT) DESC;
        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:124: exit status 1
--- FAIL: TestComposeCompare (1213.17s)

Help

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

Same failure on other branches

- #113814 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2.17-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] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #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 release-23.1 @ 3f356b85b529262b2bdda605c4b8e56598e29fae:

        postgres_1    |         col148030 NULLS LAST,
        postgres_1    |         col148031 ASC NULLS LAST,
        postgres_1    |         col148032 NULLS FIRST,
        postgres_1    |         "col'148033" NULLS LAST,
        postgres_1    |         col148034 ASC NULLS FIRST,
        postgres_1    |         col148035 DESC NULLS FIRST,
        postgres_1    |         col148036 DESC NULLS FIRST,
        postgres_1    |         "c ol148037" DESC
        test_1        | --- FAIL: TestCompare (703.27s)
        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 (97.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/TestComposeCompare337989723/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        |             -   int16(0),
        test_1        |             +   int16(1),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT int2(cosd(8.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT2 AS "Col148054") AS "t\\u0E12🙃ab74682"
        test_1        |             ORDER BY
        test_1        |                 "Col148054" DESC NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (SELECT int2(cosd(8.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT2 AS "Col148054") AS "t\\u0E12🙃ab74682"
        test_1        |             ORDER BY
        test_1        |                 "Col148054" DESC 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:124: exit status 1
--- FAIL: TestComposeCompare (727.55s)

Help

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

Same failure on other branches

- #113814 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2.17-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] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #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 release-23.1 @ 1cc63e4605a447c4920c35c3f0197bd9bd9558df:

        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/TestComposeCompare2437642602/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("2097152E"),
        test_1        |             +   string("2097152.0000000000000000E"),
        test_1        |                 int32(8),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (pow(8:::DECIMAL::DECIMAL::DECIMAL, 7:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || 'E':::STRING::STRING::STRING)::STRING
        test_1        |                             AS "cOl481016",
        test_1        |                         int4(8.0:::FLOAT8::FLOAT8::FLOAT8)::INT4 AS col481017
        test_1        |                 )
        test_1        |                     AS tab259576
        test_1        |             ORDER BY
        test_1        |                 "cOl481016" NULLS LAST, col481017 NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         (pow(8::DECIMAL::DECIMAL::DECIMAL, 7::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || 'E'::TEXT::TEXT::TEXT)::TEXT
        test_1        |                             AS "cOl481016",
        test_1        |                         int4(8.0::FLOAT8::FLOAT8::FLOAT8)::INT4 AS col481017
        test_1        |                 )
        test_1        |                     AS tab259576
        test_1        |             ORDER BY
        test_1        |                 "cOl481016" NULLS LAST, col481017 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:124: exit status 1
--- FAIL: TestComposeCompare (1008.22s)

Help

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

Same failure on other branches

- #113814 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2.17-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] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #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 release-23.1 @ 5643a5e33f67fb93f9fccaa3cbe8e8deddaeafe7:

        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 (36.16s)
        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/TestComposeCompare1126638583/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("010300000000000000"),
        test_1        |             +   string("010300000001000000050000000000000000000840000000000000F03F00000000000008400000000000000840000000000000000000000000000008400000000000000000000000000000F03F0000000000000840000000000000F03F"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makeenvelope(3.0:::FLOAT8::FLOAT8::FLOAT8, 1.0:::FLOAT8::FLOAT8::FLOAT8, 0.0:::FLOAT8::FLOAT8::FLOAT8, 3.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS col53165
        test_1        |                 )
        test_1        |                     AS "tab%p31956"
        test_1        |             ORDER BY
        test_1        |                 col53165 NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makeenvelope(3.0::FLOAT8::FLOAT8::FLOAT8, 1.0::FLOAT8::FLOAT8::FLOAT8, 0.0::FLOAT8::FLOAT8::FLOAT8, 3.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS col53165
        test_1        |                 )
        test_1        |                     AS "tab%p31956"
        test_1        |             ORDER BY
        test_1        |                 col53165 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:124: exit status 1
--- FAIL: TestComposeCompare (664.97s)

Help

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

Same failure on other branches

- #113814 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2.17-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] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroachdb / cockroach

compose: TestComposeCompare failed #109400