Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

compose: TestComposeCompare failed #109400

Closed
cockroach-teamcity opened this issue Aug 24, 2023 · 103 comments · Fixed by #120857
Closed

compose: TestComposeCompare failed #109400

cockroach-teamcity opened this issue Aug 24, 2023 · 103 comments · Fixed by #120857
Labels
branch-release-23.1 Used to mark GA and release blockers and technical advisories for 23.1 O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
SQL Foundations
Milestone
23.1

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Aug 24, 2023 •
edited by jlinder
Loading

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)

Same failure on other branches

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-30902
@cockroach-teamcity cockroach-teamcity added branch-release-23.1 Used to mark GA and release blockers and technical advisories for 23.1 O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels Aug 24, 2023
@cockroach-teamcity cockroach-teamcity added this to the 23.1 milestone Aug 24, 2023
This was referenced Aug 25, 2023
Closed
Closed
@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity cockroach-teamcity mentioned this issue Aug 28, 2023
Closed
@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity cockroach-teamcity mentioned this issue Sep 3, 2023
Closed
@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity cockroach-teamcity mentioned this issue Sep 23, 2023
Closed
@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

        test_1        |         compare_test.go:172: CREATE TABLE table4 ("col4_̞\\u16F50" INTERVAL NOT NULL, col4_1 INT2 NOT NULL, col😊4_2 TIMESTAMP NOT NULL, col4̞_3 FLOAT4, col4_4 TSQUERY NOT NULL, col4_5 NAME, "col4_'6" OID, col_4_7 REGCLASS NULL, col4_8 TIMESTAMPTZ, col4_9 INT8 NOT NULL, col4_10 TEXT NULL GENERATED ALWAYS AS (CASE WHEN col_4_7 IS NULL THEN e'\x00'::TEXT ELSE '"'::TEXT END) STORED, col4_11 INT8 NOT NULL GENERATED ALWAYS AS (col4_9 + col4_1) STORED, "\\U000482A2col4_12" INT8 NOT NULL GENERATED ALWAYS AS (col4_9 + col4_1) STORED, col4_13 TEXT GENERATED ALWAYS AS (lower(CAST("col4_'6" AS TEXT))) STORED, col4_14 INT8 NOT NULL GENERATED ALWAYS AS (col4_9 + col4_1) STORED, col4😺_😂15 TEXT GENERATED ALWAYS AS (CASE WHEN col4_8 IS NULL THEN e'?"\x10'::TEXT ELSE NULL END) STORED);
        test_1        |             
        test_1        |         compare_test.go:173: postgres: exec: ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
        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 52 [running]:
        test_1        | testing.tRunner.func1.2({0x22b9e40, 0xc0015132e0})
        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({0x22b9e40, 0xc0015132e0})
        test_1        | 	GOROOT/src/runtime/panic.go:884 +0x212
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x45f5400?, {0x31fe508?, 0xc000f276b0?})
        test_1        | 	github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:375 +0x436
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x31c1e20?, 0x45f5400)
        test_1        | 	github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:308 +0x13c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc000ec1080)
        test_1        | 	github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:225 +0x96
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc0005357a0, {0xc000b67ac0?, 0x4, 0xc0005357a0?})
        test_1        | 	github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:258 +0x71f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0xc000093968?, 0x24be6e9?, {0xc000b67ac0?, 0x20f39c0?, 0x1?})
        test_1        | 	github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:96 +0x2e
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0x20f39c0?, {0x24be6e9, 0x5}, 0x4, 0x0?, {0xc000d91a48, 0x3, 0xc000057270?})
        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(0xc000515380?)
        test_1        | 	github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:84 +0x37
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.wrapCommonSetup.func1(0x269bb78?)
        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(0xc000515380)
        test_1        | 	github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:143 +0xed
        test_1        | testing.tRunner(0xc000515380, 0xc000535740)
        test_1        | 	GOROOT/src/testing/testing.go:1446 +0x10b
        test_1        | created by testing.(*T).Run
        test_1        | 	GOROOT/src/testing/testing.go:1493 +0x35f
        compare_test_1 exited with code 2
        Stopping compare_cockroach2_1 ... 
        Stopping compare_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 2
--- FAIL: TestComposeCompare (22.00s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

        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/TestComposeCompare3802305229/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(8),
        test_1        |             - 	nil,
        test_1        |             + 	string("01010000000000000000E050C00000000000803640"),
        test_1        |               	string("0011000000000000000000000000000000"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			8:::INT8::INT4 AS col87494,
        test_1        |             			st_pointfromgeohash('D':::STRING::STRING::STRING, NULL::INT4::INT4)::GEOMETRY AS " col87495",
        test_1        |             			B'0011'::BIT(34) AS col87496
        test_1        |             	)
        test_1        |             		AS tͤab55983
        test_1        |             ORDER BY
        test_1        |             	col87494 DESC NULLS LAST, " col87495", col87496 ASC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			8::INT8::INT4 AS col87494,
        test_1        |             			st_pointfromgeohash('D'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::GEOMETRY AS " col87495",
        test_1        |             			B'0011'::BIT(34) AS col87496
        test_1        |             	)
        test_1        |             		AS tͤab55983
        test_1        |             ORDER BY
        test_1        |             	col87494 DESC NULLS LAST, " col87495", col87496 ASC;
        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 (699.20s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

        postgres_1    | 					AS col180170,
        postgres_1    | 				NULL::VOID AS "co""�l180171"
        postgres_1    | 			FROM
        postgres_1    | 				postgres.public."ta\\u4E6Cble1" AS tab105217
        postgres_1    | 		)
        postgres_1    | 			AS tab105218
        postgres_1    | 	ORDER BY
        postgres_1    | 		col180170 DESC NULLS FIRST, "co""�l180171" ASC NULLS LAST
        test_1        | --- FAIL: TestCompare (732.31s)
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (128.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/TestComposeCompare520597402/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("010100000000000000008036C00000000000803640"),
        test_1        |             + 	nil,
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT st_pointfromgeohash('E'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::GEOMETRY AS col180189) AS "tab'105233"
        test_1        |             ORDER BY
        test_1        |             	col180189 NULLS FIRST;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT st_pointfromgeohash('E':::STRING::STRING::STRING, NULL::INT4::INT4)::GEOMETRY AS col180189) AS "tab'105233"
        test_1        |             ORDER BY
        test_1        |             	col180189 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 (756.59s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

This was referenced Mar 5, 2024
Closed
Closed
@cockroach-teamcity
Copy link
Member Author

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

        postgres_1    | 		" col534113" NULLS FIRST,
        postgres_1    | 		"%qco\\u3FA7l534114" NULLS FIRST
        postgres_1    | 2024-03-05 06:25:40.110 UTC [78] ERROR:  collation "da_dk" for encoding "UTF8" does not exist at character 34
        postgres_1    | 2024-03-05 06:25:40.110 UTC [78] STATEMENT:  SELECT * FROM (SELECT NULL::TEXT COLLATE da_DK AS col534157) AS "\\u0649tab358908" ORDER BY col534157 DESC NULLS LAST
        postgres_1    | 2024-03-05 06:25:40.224 UTC [78] ERROR:  collation "en_us" for encoding "UTF8" does not exist at character 34
        postgres_1    | 2024-03-05 06:25:40.224 UTC [78] STATEMENT:  SELECT * FROM (SELECT NULL::TEXT COLLATE en_US AS "col �534281") AS tab359000 ORDER BY "col �534281" ASC NULLS LAST
        test_1        | --- FAIL: TestCompare (1086.35s)
        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 (481.20s)
        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/TestComposeCompare120400919/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        |             	(SELECT int2(acosh(COALESCE(NULL::FLOAT8, 9.0:::FLOAT8::FLOAT8)::FLOAT8)::FLOAT8::FLOAT8)::INT2 AS col534329)
        test_1        |             		AS "tab\\uC17E359041"
        test_1        |             ORDER BY
        test_1        |             	col534329 DESC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT int2(acosh(COALESCE(NULL::FLOAT8, 9.0::FLOAT8::FLOAT8)::FLOAT8)::FLOAT8::FLOAT8)::INT2 AS col534329)
        test_1        |             		AS "tab\\uC17E359041"
        test_1        |             ORDER BY
        test_1        |             	col534329 DESC 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 (1111.25s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

        postgres_1    | waiting for server to shut down...2024-03-09 06:17:05.726 UTC [49] LOG:  received fast shutdown request
        postgres_1    | .2024-03-09 06:17:05.728 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2024-03-09 06:17:05.730 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2024-03-09 06:17:05.731 UTC [51] LOG:  shutting down
        postgres_1    | 2024-03-09 06:17:05.826 UTC [49] LOG:  database system is shut down
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2024-03-09 06:17:05.848 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2024-03-09 06:17:05.848 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2024-03-09 06:17:05.848 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2024-03-09 06:17:05.851 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2024-03-09 06:17:05.856 UTC [68] LOG:  database system was shut down at 2024-03-09 06:17:05 UTC
        postgres_1    | 2024-03-09 06:17:05.861 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2024-03-09 06:17:06.820 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2024-03-09 06:17:06.820 UTC [78] STATEMENT:  CREATE TABLE "
table2" (col2__0 INET NOT NULL, col2_1 UUID[] NOT NULL, " col2_2" VARCHAR NOT NULL, col2_3 BOOL, "	col2_4" TEXT NOT NULL, "c
🙀ol2_5" TIME NOT NULL, "'col2_6" REGROLE, col2_7 TIMESTAMPTZ NOT NULL, col2_8 REGCLASS, col2_9 NAME NULL, "*col2_😢10" TIMETZ NOT NULL, col2_11 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col2_3 AS TEXT))) STORED, PRIMARY KEY ("	col2_4", col2_11, col2_1, col2__0));
        postgres_1    | 	CREATE INDEX ON "
table2" (col2_7 ASC);
        postgres_1    | 	CREATE UNIQUE INDEX ON "
table2" (col2_1 ASC, " col2_2" ASC, "'col2_6", col2_9 ASC, "	col2_4", "*col2_😢10", (CASE WHEN "'col2_6" IS NULL THEN e'\nO'::TEXT ELSE e'\x00'::TEXT END), col2__0) INCLUDE (col2_3, col2_8);
        postgres_1    | 	CREATE UNIQUE INDEX ON "
table2" (col2__0, "*col2_😢10" DESC, lower(col2_9), col2_7 ASC, lower(CAST(col2_3 AS TEXT)), lower("	col2_4") DESC, "c
🙀ol2_5", " col2_2" ASC, col2_11, col2_3, "	col2_4" ASC, "'col2_6") INCLUDE (col2_8, col2_9);
        postgres_1    | 	CREATE UNIQUE INDEX ON "
table2" (col2_9, lower(" col2_2"), col2_11, col2_8);
        postgres_1    | 	
        test_1        | --- FAIL: TestCompare (604.71s)
        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.89s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:172: CREATE TABLE "
table2" (col2__0 INET NOT NULL, col2_1 UUID[] NOT NULL, " col2_2" VARCHAR NOT NULL, col2_3 BOOL, "	col2_4" TEXT NOT NULL, "c
🙀ol2_5" TIME NOT NULL, "'col2_6" REGROLE, col2_7 TIMESTAMPTZ NOT NULL, col2_8 REGCLASS, col2_9 NAME NULL, "*col2_😢10" TIMETZ NOT NULL, col2_11 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col2_3 AS TEXT))) STORED, PRIMARY KEY ("	col2_4", col2_11, col2_1, col2__0));
        test_1        |             CREATE INDEX ON "
table2" (col2_7 ASC);
        test_1        |             CREATE UNIQUE INDEX ON "
table2" (col2_1 ASC, " col2_2" ASC, "'col2_6", col2_9 ASC, "	col2_4", "*col2_😢10", (CASE WHEN "'col2_6" IS NULL THEN e'\nO'::TEXT ELSE e'\x00'::TEXT END), col2__0) INCLUDE (col2_3, col2_8);
        test_1        |             CREATE UNIQUE INDEX ON "
table2" (col2__0, "*col2_😢10" DESC, lower(col2_9), col2_7 ASC, lower(CAST(col2_3 AS TEXT)), lower("	col2_4") DESC, "c
🙀ol2_5", " col2_2" ASC, col2_11, col2_3, "	col2_4" ASC, "'col2_6") INCLUDE (col2_8, col2_9);
        test_1        |             CREATE UNIQUE INDEX ON "
table2" (col2_9, lower(" col2_2"), col2_11, col2_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_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 (628.64s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

        postgres_1    | 		"%vcol205245" ASC NULLS FIRST,
        postgres_1    | 		"ĉol%p205246" DESC NULLS LAST,
        postgres_1    | 		col205247 DESC NULLS LAST,
        postgres_1    | 		co͜l205248 DESC NULLS FIRST,
        postgres_1    | 		col205249 ASC NULLS FIRST,
        postgres_1    | 		col205250 ASC NULLS FIRST
        test_1        | --- FAIL: TestCompare (753.97s)
        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 (149.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/TestComposeCompare3566802910/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.84509804001425683071"),
        test_1        |             + 	string("E0.8450980400142568"),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT ('E'::TEXT::TEXT::TEXT || log(7::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::TEXT AS col205273)
        test_1        |             		AS "😘tab%112304"
        test_1        |             ORDER BY
        test_1        |             	col205273 DESC;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT ('E':::STRING::STRING::STRING || log(7:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::STRING AS col205273)
        test_1        |             		AS "😘tab%112304"
        test_1        |             ORDER BY
        test_1        |             	col205273 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 (778.64s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

        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 (292.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/TestComposeCompare835955247/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("010300000001000000050000000000000000000040000000000000204000000000000000400000000000000000000000000000224000000000000000000000000000002240000000000000204000000000000000400000000000002040"),
        test_1        |             + 	string("010300000000000000"),
        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, 8.0:::FLOAT8::FLOAT8::FLOAT8, 9.0:::FLOAT8::FLOAT8::FLOAT8, 0.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS col353867
        test_1        |             	)
        test_1        |             		AS tab183415
        test_1        |             ORDER BY
        test_1        |             	col353867 NULLS LAST;
        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, 8.0::FLOAT8::FLOAT8::FLOAT8, 9.0::FLOAT8::FLOAT8::FLOAT8, 0.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS col353867
        test_1        |             	)
        test_1        |             		AS tab183415
        test_1        |             ORDER BY
        test_1        |             	col353867 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_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (922.33s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2024-03-12 05:18:06.237 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2024-03-12 05:18:06.237 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2024-03-12 05:18:06.237 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2024-03-12 05:18:06.240 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2024-03-12 05:18:06.245 UTC [68] LOG:  database system was shut down at 2024-03-12 05:18:06 UTC
        postgres_1    | 2024-03-12 05:18:06.250 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2024-03-12 05:18:07.936 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2024-03-12 05:18:07.936 UTC [78] STATEMENT:  CREATE TABLE "ta'ble1" (col1_0 BIT(32), col1_1 BOOL NOT NULL, "col.1_2" BYTEA NULL, "col%v1_3" REGCLASS NULL, col1_4 BIT(10), col1_5 INT2, "col 1_6" TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_1 AS TEXT))) STORED, "cOl1_7" INT8 GENERATED ALWAYS AS (col1_5 + (-24324)::INT8) STORED, "\\xdec o%eel1,_8" TEXT GENERATED ALWAYS AS (lower(CAST(col1_4 AS TEXT))) STORED, col1_9 TEXT GENERATED ALWAYS AS (lower(CAST(col1_0 AS TEXT))) STORED, "co\\u1BB9l1_10" TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_1 AS TEXT))) STORED);
        postgres_1    | 	CREATE UNIQUE INDEX ON "ta'ble1" ("co\\u1BB9l1_10" ASC, "\\xdec o%eel1,_8" ASC, col1_5 DESC, "col 1_6", "cOl1_7") INCLUDE (col1_1, "col.1_2", col1_9);
        postgres_1    | 	CREATE UNIQUE INDEX ON "ta'ble1" ("co\\u1BB9l1_10" DESC, "cOl1_7", col1_0 ASC, "col%v1_3" ASC, col1_9 DESC, col1_1, "\\xdec o%eel1,_8", lower(CAST(col1_4 AS TEXT)) DESC, lower(CAST(col1_1 AS TEXT))) INCLUDE (col1_4, col1_5);
        postgres_1    | 	CREATE INDEX ON "ta'ble1" (lower(CAST(col1_4 AS TEXT)) ASC, col1_9 ASC, col1_1, "cOl1_7", "col%v1_3" DESC) INCLUDE (col1_0, col1_5);
        postgres_1    | 	CREATE INDEX ON "ta'ble1" ("col 1_6" ASC, col1_5, col1_4, "co\\u1BB9l1_10", (CASE WHEN "col.1_2" IS NULL THEN e'hMP\x03Ke\x16'::TEXT ELSE ''::TEXT END) ASC, col1_9 DESC, (CASE WHEN "col%v1_3" IS NULL THEN e'\x00'::TEXT ELSE '``'::TEXT END) ASC, col1_0, col1_1, "col%v1_3" ASC, "cOl1_7" DESC);
        postgres_1    | 	CREATE INDEX ON "ta'ble1" ("co\\u1BB9l1_10" DESC, "cOl1_7", col1_4, col1_9, "col 1_6" ASC, col1_0 ASC, col1_5 DESC, col1_1 DESC, (CASE WHEN "col%v1_3" IS NULL THEN e'L\x1cy\t\x16I'::TEXT ELSE '3%dgKZc'::TEXT END) DESC, "col.1_2") INCLUDE ("col%v1_3");
        postgres_1    | 	CREATE INDEX ON "ta'ble1" ("col.1_2" DESC, col1_4, "col%v1_3" DESC, col1_5 ASC);
        postgres_1    | 	CREATE INDEX ON "ta'ble1" (col1_9 ASC, col1_1, col1_5, "col%v1_3", "cOl1_7", col1_4 DESC) INCLUDE (col1_0);
        postgres_1    | 	CREATE INDEX ON "ta'ble1" (col1_4 ASC, col1_5, col1_1 ASC, "col 1_6" DESC, col1_0, (CASE WHEN "col%v1_3" IS NULL THEN ']'::TEXT ELSE e',,! /B\r'::TEXT END), lower(CAST(col1_0 AS TEXT)) DESC, "col.1_2" DESC, col1_9, "\\xdec o%eel1,_8", "co\\u1BB9l1_10" ASC);
        postgres_1    | 	
        test_1        | --- FAIL: TestCompare (605.72s)
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     --- FAIL: TestCompare/postgres (0.89s)
        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 "ta'ble1" (col1_0 BIT(32), col1_1 BOOL NOT NULL, "col.1_2" BYTEA NULL, "col%v1_3" REGCLASS NULL, col1_4 BIT(10), col1_5 INT2, "col 1_6" TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_1 AS TEXT))) STORED, "cOl1_7" INT8 GENERATED ALWAYS AS (col1_5 + (-24324)::INT8) STORED, "\\xdec o%eel1,_8" TEXT GENERATED ALWAYS AS (lower(CAST(col1_4 AS TEXT))) STORED, col1_9 TEXT GENERATED ALWAYS AS (lower(CAST(col1_0 AS TEXT))) STORED, "co\\u1BB9l1_10" TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_1 AS TEXT))) STORED);
        test_1        |             CREATE UNIQUE INDEX ON "ta'ble1" ("co\\u1BB9l1_10" ASC, "\\xdec o%eel1,_8" ASC, col1_5 DESC, "col 1_6", "cOl1_7") INCLUDE (col1_1, "col.1_2", col1_9);
        test_1        |             CREATE UNIQUE INDEX ON "ta'ble1" ("co\\u1BB9l1_10" DESC, "cOl1_7", col1_0 ASC, "col%v1_3" ASC, col1_9 DESC, col1_1, "\\xdec o%eel1,_8", lower(CAST(col1_4 AS TEXT)) DESC, lower(CAST(col1_1 AS TEXT))) INCLUDE (col1_4, col1_5);
        test_1        |             CREATE INDEX ON "ta'ble1" (lower(CAST(col1_4 AS TEXT)) ASC, col1_9 ASC, col1_1, "cOl1_7", "col%v1_3" DESC) INCLUDE (col1_0, col1_5);
        test_1        |             CREATE INDEX ON "ta'ble1" ("col 1_6" ASC, col1_5, col1_4, "co\\u1BB9l1_10", (CASE WHEN "col.1_2" IS NULL THEN e'hMP\x03Ke\x16'::TEXT ELSE ''::TEXT END) ASC, col1_9 DESC, (CASE WHEN "col%v1_3" IS NULL THEN e'\x00'::TEXT ELSE '``'::TEXT END) ASC, col1_0, col1_1, "col%v1_3" ASC, "cOl1_7" DESC);
        test_1        |             CREATE INDEX ON "ta'ble1" ("co\\u1BB9l1_10" DESC, "cOl1_7", col1_4, col1_9, "col 1_6" ASC, col1_0 ASC, col1_5 DESC, col1_1 DESC, (CASE WHEN "col%v1_3" IS NULL THEN e'L\x1cy\t\x16I'::TEXT ELSE '3%dgKZc'::TEXT END) DESC, "col.1_2") INCLUDE ("col%v1_3");
        test_1        |             CREATE INDEX ON "ta'ble1" ("col.1_2" DESC, col1_4, "col%v1_3" DESC, col1_5 ASC);
        test_1        |             CREATE INDEX ON "ta'ble1" (col1_9 ASC, col1_1, col1_5, "col%v1_3", "cOl1_7", col1_4 DESC) INCLUDE (col1_0);
        test_1        |             CREATE INDEX ON "ta'ble1" (col1_4 ASC, col1_5, col1_1 ASC, "col 1_6" DESC, col1_0, (CASE WHEN "col%v1_3" IS NULL THEN ']'::TEXT ELSE e',,! /B\r'::TEXT END), lower(CAST(col1_0 AS TEXT)) DESC, "col.1_2" DESC, col1_9, "\\xdec o%eel1,_8", "co\\u1BB9l1_10" 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_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (630.04s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

        postgres_1    | 2024-03-13 05:17:47.920 UTC [68] LOG:  database system was shut down at 2024-03-13 05:17:47 UTC
        postgres_1    | 2024-03-13 05:17:47.925 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2024-03-13 05:27:51.510 UTC [98] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2024-03-13 05:27:51.510 UTC [98] STATEMENT:  CREATE TABLE "tabLe3" (col3_0 INT8 NOT NULL, col3_1 BOX2D, col3_2 INT4 NULL, "co""l3_3" VARCHAR NULL, col3_4 REGROLE NULL, col3_5 FLOAT8 NOT NULL, " %vcol3_6" REGTYPE NULL, col3_7 TEXT NOT NULL, "col	3_8" OID NULL, col3_9 TIMETZ NOT NULL, "c�ol3_10" TIMESTAMPTZ NOT NULL, "/col 3_11" REGCLASS, col3_12 INT8 NULL GENERATED ALWAYS AS (col3_2 + col3_0) STORED, "col
        postgres_1    | 	3_13" TEXT NULL GENERATED ALWAYS AS (lower("co""l3_3")) STORED, "col*""3_14" INT8 NULL GENERATED ALWAYS AS (col3_2 + col3_0) STORED, col3_15 INT8 NOT NULL GENERATED ALWAYS AS (col3_0 + (-5145320716356222592)::INT8) STORED, col3_16 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "c�ol3_10" IS NULL THEN ''::TEXT ELSE e'|\x01G\x18rW'::TEXT END) STORED, col3̩_17 INT8 NULL GENERATED ALWAYS AS (col3_0 + col3_2) STORED, col3_18 INT8 NULL GENERATED ALWAYS AS (col3_2 + col3_0) STORED);
        postgres_1    | 	CREATE INDEX ON "tabLe3" (col3̩_17 ASC, " %vcol3_6" ASC, "col
        postgres_1    | 	3_13" ASC, "co""l3_3" ASC, col3_2, col3_5, col3_12 ASC) INCLUDE (col3_0, col3_1, col3_7, "col	3_8", col3_9, "/col 3_11", col3_16);
        postgres_1    | 	CREATE INDEX ON "tabLe3" (col3_15, "/col 3_11" DESC, (CASE WHEN "c�ol3_10" IS NULL THEN '"'::TEXT ELSE e'[\x024ii'::TEXT END) ASC, col3_2, col3_16 DESC, col3̩_17 ASC, "col	3_8", col3_7 DESC, (col3_0 + col3_2) DESC, col3_5, "c�ol3_10", col3_4 ASC, col3_18);
        postgres_1    | 	CREATE UNIQUE INDEX ON "tabLe3" (col3̩_17, col3_4, "c�ol3_10" ASC);
        postgres_1    | 	CREATE UNIQUE INDEX ON "tabLe3" ((col3_5 + (-0.0)::FLOAT8) ASC, lower("co""l3_3") ASC);
        postgres_1    | 	CREATE UNIQUE INDEX ON "tabLe3" (col3_12, col3_7, " %vcol3_6", col3_2 ASC, (col3_0 + col3_2) ASC, col3_5 DESC, "/col 3_11" DESC, "c�ol3_10" DESC, col3̩_17, "co""l3_3" DESC, lower(CAST("col	3_8" AS TEXT)) ASC, "col
        postgres_1    | 	3_13", col3_4, lower("co""l3_3"), col3_16 DESC) INCLUDE (col3_1, "col	3_8", col3_9);
        postgres_1    | 	CREATE INDEX ON "tabLe3" (col3_9 DESC, col3_12 DESC, col3̩_17 DESC, col3_15 DESC, col3_7, col3_5 ASC, (CASE WHEN " %vcol3_6" IS NULL THEN e'\x00'::TEXT ELSE ''::TEXT END) DESC, col3_18 ASC, col3_0 ASC, "col	3_8" ASC, "co""l3_3" DESC) INCLUDE (col3_2, col3_4, "c�ol3_10", "col
        postgres_1    | 	3_13");
        postgres_1    | 	CREATE UNIQUE INDEX ON "tabLe3" (col3_16 ASC, "col	3_8" DESC, " %vcol3_6" ASC, col3_9 DESC) INCLUDE (col3_0, col3_1, col3_2, "co""l3_3", col3_12, col3_18);
        postgres_1    | 	
        test_1        | --- FAIL: TestCompare (606.83s)
        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.74s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:172: CREATE TABLE "tabLe3" (col3_0 INT8 NOT NULL, col3_1 BOX2D, col3_2 INT4 NULL, "co""l3_3" VARCHAR NULL, col3_4 REGROLE NULL, col3_5 FLOAT8 NOT NULL, " %vcol3_6" REGTYPE NULL, col3_7 TEXT NOT NULL, "col	3_8" OID NULL, col3_9 TIMETZ NOT NULL, "c�ol3_10" TIMESTAMPTZ NOT NULL, "/col 3_11" REGCLASS, col3_12 INT8 NULL GENERATED ALWAYS AS (col3_2 + col3_0) STORED, "col
        test_1        |             3_13" TEXT NULL GENERATED ALWAYS AS (lower("co""l3_3")) STORED, "col*""3_14" INT8 NULL GENERATED ALWAYS AS (col3_2 + col3_0) STORED, col3_15 INT8 NOT NULL GENERATED ALWAYS AS (col3_0 + (-5145320716356222592)::INT8) STORED, col3_16 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "c�ol3_10" IS NULL THEN ''::TEXT ELSE e'|\x01G\x18rW'::TEXT END) STORED, col3̩_17 INT8 NULL GENERATED ALWAYS AS (col3_0 + col3_2) STORED, col3_18 INT8 NULL GENERATED ALWAYS AS (col3_2 + col3_0) STORED);
        test_1        |             CREATE INDEX ON "tabLe3" (col3̩_17 ASC, " %vcol3_6" ASC, "col
        test_1        |             3_13" ASC, "co""l3_3" ASC, col3_2, col3_5, col3_12 ASC) INCLUDE (col3_0, col3_1, col3_7, "col	3_8", col3_9, "/col 3_11", col3_16);
        test_1        |             CREATE INDEX ON "tabLe3" (col3_15, "/col 3_11" DESC, (CASE WHEN "c�ol3_10" IS NULL THEN '"'::TEXT ELSE e'[\x024ii'::TEXT END) ASC, col3_2, col3_16 DESC, col3̩_17 ASC, "col	3_8", col3_7 DESC, (col3_0 + col3_2) DESC, col3_5, "c�ol3_10", col3_4 ASC, col3_18);
        test_1        |             CREATE UNIQUE INDEX ON "tabLe3" (col3̩_17, col3_4, "c�ol3_10" ASC);
        test_1        |             CREATE UNIQUE INDEX ON "tabLe3" ((col3_5 + (-0.0)::FLOAT8) ASC, lower("co""l3_3") ASC);
        test_1        |             CREATE UNIQUE INDEX ON "tabLe3" (col3_12, col3_7, " %vcol3_6", col3_2 ASC, (col3_0 + col3_2) ASC, col3_5 DESC, "/col 3_11" DESC, "c�ol3_10" DESC, col3̩_17, "co""l3_3" DESC, lower(CAST("col	3_8" AS TEXT)) ASC, "col
        test_1        |             3_13", col3_4, lower("co""l3_3"), col3_16 DESC) INCLUDE (col3_1, "col	3_8", col3_9);
        test_1        |             CREATE INDEX ON "tabLe3" (col3_9 DESC, col3_12 DESC, col3̩_17 DESC, col3_15 DESC, col3_7, col3_5 ASC, (CASE WHEN " %vcol3_6" IS NULL THEN e'\x00'::TEXT ELSE ''::TEXT END) DESC, col3_18 ASC, col3_0 ASC, "col	3_8" ASC, "co""l3_3" DESC) INCLUDE (col3_2, col3_4, "c�ol3_10", "col
        test_1        |             3_13");
        test_1        |             CREATE UNIQUE INDEX ON "tabLe3" (col3_16 ASC, "col	3_8" DESC, " %vcol3_6" ASC, col3_9 DESC) INCLUDE (col3_0, col3_1, col3_2, "co""l3_3", col3_12, col3_18);
        test_1        |             
        test_1        |         compare_test.go:173: postgres: exec: ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (630.72s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

        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/TestComposeCompare1417167074/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        |               	strings.Join({
        test_1        |               		"01010000400000000000004C40000000000000F03FE",
        test_1        |             - 		"4",
        test_1        |             + 		"3",
        test_1        |               		"A1498FE7321BC0",
        test_1        |               	}, ""),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_makepointm((8.0::FLOAT8::FLOAT8::FLOAT8 * 7.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, 1.0::FLOAT8::FLOAT8::FLOAT8, tan(8.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS "�col😙615332"
        test_1        |             	)
        test_1        |             		AS "t%vab300962"
        test_1        |             ORDER BY
        test_1        |             	"�col😙615332" DESC;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_makepointm((8.0:::FLOAT8::FLOAT8::FLOAT8 * 7.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, 1.0:::FLOAT8::FLOAT8::FLOAT8, tan(8.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS "�col😙615332"
        test_1        |             	)
        test_1        |             		AS "t%vab300962"
        test_1        |             ORDER BY
        test_1        |             	"�col😙615332" DESC;
        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 (1064.41s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

        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 (51.13s)
        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/TestComposeCompare3404696928/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:203: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             - 	s"0",
        test_1        |             + 	s"5",
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_npoints(st_makeenvelope(7.0:::FLOAT8::FLOAT8::FLOAT8, 2.0:::FLOAT8::FLOAT8::FLOAT8, 3.0:::FLOAT8::FLOAT8::FLOAT8, 6.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY)::INT8
        test_1        |             				AS col51365
        test_1        |             	)
        test_1        |             		AS "	t ab25754"
        test_1        |             ORDER BY
        test_1        |             	col51365 DESC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_npoints(st_makeenvelope(7.0::FLOAT8::FLOAT8::FLOAT8, 2.0::FLOAT8::FLOAT8::FLOAT8, 3.0::FLOAT8::FLOAT8::FLOAT8, 6.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY)::INT8
        test_1        |             				AS col51365
        test_1        |             	)
        test_1        |             		AS "	t ab25754"
        test_1        |             ORDER BY
        test_1        |             	col51365 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 (681.08s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

        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 (36.83s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare1699624035/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("BOX(0 -90,45 -45)"),
        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_geomfromgeohash('H':::STRING::STRING::STRING, NULL::INT4::INT4)::GEOMETRY::GEOMETRY)::BOX2D
        test_1        |             				AS col36192
        test_1        |             	)
        test_1        |             		AS 🙁tab22810
        test_1        |             ORDER BY
        test_1        |             	CAST(col36192 AS STRING);
        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_geomfromgeohash('H'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::GEOMETRY::GEOMETRY)::BOX2D
        test_1        |             				AS col36192
        test_1        |             	)
        test_1        |             		AS 🙁tab22810
        test_1        |             ORDER BY
        test_1        |             	CAST(col36192 AS TEXT);
        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 (666.75s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

        postgres_1    | 		col266786 NULLS LAST,
        postgres_1    | 		"cOl266787" ASC NULLS FIRST,
        postgres_1    | 		"coL266788" NULLS FIRST,
        postgres_1    | 		"col\\U0000CF54266789" ASC,
        postgres_1    | 		col266790 ASC NULLS FIRST,
        postgres_1    | 		"c{ol266791" ASC,
        postgres_1    | 		"'col266792",
        postgres_1    | 		col266793 ASC
        test_1        | --- FAIL: TestCompare (823.39s)
        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 (219.19s)
        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/TestComposeCompare884432761/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 colͭ266881) AS t̝ab179509
        test_1        |             ORDER BY
        test_1        |             	colͭ266881 NULLS LAST;
        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 colͭ266881) AS t̝ab179509
        test_1        |             ORDER BY
        test_1        |             	colͭ266881 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 (847.49s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

        test_1        |             + 				Int:              s"12163594037787468",
        test_1        |             - 				Exp:              -19,
        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[] || (9:::INT8::INT8::INT8 % ln(7:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::DECIMAL[]
        test_1        |             				AS col112587
        test_1        |             	)
        test_1        |             		AS "tab�69141"
        test_1        |             ORDER BY
        test_1        |             	col112587 DESC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			(NULL::DECIMAL[]::DECIMAL[] || (9::INT8::INT8::INT8 % ln(7::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::DECIMAL[]
        test_1        |             				AS col112587
        test_1        |             	)
        test_1        |             		AS "tab�69141"
        test_1        |             ORDER BY
        test_1        |             	col112587 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 (718.24s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2024-03-21 05:17:09.619 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2024-03-21 05:17:09.619 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2024-03-21 05:17:09.619 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2024-03-21 05:17:09.622 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2024-03-21 05:17:09.626 UTC [68] LOG:  database system was shut down at 2024-03-21 05:17:09 UTC
        postgres_1    | 2024-03-21 05:17:09.630 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2024-03-21 05:17:10.796 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2024-03-21 05:17:10.796 UTC [78] STATEMENT:  CREATE TABLE "%qtable1" ("col1_""0" INTERVAL NOT NULL, "col1_ �1" INTERVAL NOT NULL, col1_2 INT2 NOT NULL, col1_3 REGCLASS, "col1""_4" INT4 NOT NULL, "c'ol1_5" REGROLE NULL, col1_6 TEXT NOT NULL, col1_7 TIMESTAMP[] NOT NULL, col1_8 "char" NOT NULL, col1_9 INET NOT NULL, col1_10 TEXT NOT NULL, col1_11 FLOAT4 NOT NULL, col1_12 TSVECTOR, "%3fcol1_13" INT8 NOT NULL GENERATED ALWAYS AS ("col1""_4" + col1_2) STORED, "col1_\n14" TEXT NOT NULL GENERATED ALWAYS AS (lower(col1_8)) STORED, col1_15 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_10 AS TEXT))) STORED, col1_16 INT8 NOT NULL GENERATED ALWAYS AS (col1_2 + "col1""_4") STORED, col1_17 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_9 AS TEXT))) STORED, " col1_18" INT8 NOT NULL GENERATED ALWAYS AS (col1_2 + "col1""_4") STORED);
        postgres_1    | 	CREATE INDEX ON "%qtable1" ("c'ol1_5", "col1_""0" DESC, col1_6 DESC, col1_8, col1_3 ASC, col1_11 DESC, col1_16, "%3fcol1_13" ASC, col1_10, "col1_\n14", col1_2 ASC, " col1_18" DESC, col1_15 DESC, col1_7 ASC) INCLUDE (col1_17);
        postgres_1    | 	CREATE INDEX ON "%qtable1" (col1_15 ASC, "col1_""0" DESC, " col1_18", col1_7, "col1_\n14" DESC, col1_8 DESC, col1_2, "col1_ �1" ASC);
        postgres_1    | 	CREATE INDEX ON "%qtable1" (col1_2 DESC, col1_15 DESC, col1_8 ASC, lower(col1_6) ASC, col1_7, "c'ol1_5") INCLUDE (col1_6, col1_10, col1_12, col1_17, " col1_18");
        postgres_1    | 	CREATE UNIQUE INDEX ON "%qtable1" (col1_11 ASC, (CASE WHEN "c'ol1_5" IS NULL THEN '55('::TEXT ELSE e'\x00'::TEXT END) DESC, "c'ol1_5", col1_2, col1_17 DESC, "col1_\n14" DESC, col1_7 ASC, col1_10 ASC, col1_16, col1_3 ASC, (CASE WHEN col1_3 IS NULL THEN e'\U00002603'::TEXT ELSE 'nerf'::TEXT END), col1_8 DESC) INCLUDE (col1_6, col1_9, "%3fcol1_13");
        postgres_1    | 	CREATE INDEX ON "%qtable1" (col1_8 ASC, col1_10, "col1_\n14", " col1_18", "col1""_4" DESC) INCLUDE (col1_2, col1_3, "c'ol1_5", col1_6, "%3fcol1_13", col1_17);
        postgres_1    | 	CREATE INDEX ON "%qtable1" ("%3fcol1_13" ASC, "col1""_4" ASC, "col1_ �1" DESC, " col1_18" ASC, "col1_""0" DESC);
        postgres_1    | 	CREATE INDEX ON "%qtable1" (col1_16 DESC, col1_3 ASC, col1_9, col1_10 DESC, col1_17 DESC, col1_8, ("col1""_4" + col1_2) DESC, "col1_ �1", "col1_""0") INCLUDE (col1_2, col1_6, col1_12, "%3fcol1_13");
        postgres_1    | 	
        test_1        | --- FAIL: TestCompare (605.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 (1.02s)
        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 "%qtable1" ("col1_""0" INTERVAL NOT NULL, "col1_ �1" INTERVAL NOT NULL, col1_2 INT2 NOT NULL, col1_3 REGCLASS, "col1""_4" INT4 NOT NULL, "c'ol1_5" REGROLE NULL, col1_6 TEXT NOT NULL, col1_7 TIMESTAMP[] NOT NULL, col1_8 "char" NOT NULL, col1_9 INET NOT NULL, col1_10 TEXT NOT NULL, col1_11 FLOAT4 NOT NULL, col1_12 TSVECTOR, "%3fcol1_13" INT8 NOT NULL GENERATED ALWAYS AS ("col1""_4" + col1_2) STORED, "col1_\n14" TEXT NOT NULL GENERATED ALWAYS AS (lower(col1_8)) STORED, col1_15 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_10 AS TEXT))) STORED, col1_16 INT8 NOT NULL GENERATED ALWAYS AS (col1_2 + "col1""_4") STORED, col1_17 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_9 AS TEXT))) STORED, " col1_18" INT8 NOT NULL GENERATED ALWAYS AS (col1_2 + "col1""_4") STORED);
        test_1        |             CREATE INDEX ON "%qtable1" ("c'ol1_5", "col1_""0" DESC, col1_6 DESC, col1_8, col1_3 ASC, col1_11 DESC, col1_16, "%3fcol1_13" ASC, col1_10, "col1_\n14", col1_2 ASC, " col1_18" DESC, col1_15 DESC, col1_7 ASC) INCLUDE (col1_17);
        test_1        |             CREATE INDEX ON "%qtable1" (col1_15 ASC, "col1_""0" DESC, " col1_18", col1_7, "col1_\n14" DESC, col1_8 DESC, col1_2, "col1_ �1" ASC);
        test_1        |             CREATE INDEX ON "%qtable1" (col1_2 DESC, col1_15 DESC, col1_8 ASC, lower(col1_6) ASC, col1_7, "c'ol1_5") INCLUDE (col1_6, col1_10, col1_12, col1_17, " col1_18");
        test_1        |             CREATE UNIQUE INDEX ON "%qtable1" (col1_11 ASC, (CASE WHEN "c'ol1_5" IS NULL THEN '55('::TEXT ELSE e'\x00'::TEXT END) DESC, "c'ol1_5", col1_2, col1_17 DESC, "col1_\n14" DESC, col1_7 ASC, col1_10 ASC, col1_16, col1_3 ASC, (CASE WHEN col1_3 IS NULL THEN e'\U00002603'::TEXT ELSE 'nerf'::TEXT END), col1_8 DESC) INCLUDE (col1_6, col1_9, "%3fcol1_13");
        test_1        |             CREATE INDEX ON "%qtable1" (col1_8 ASC, col1_10, "col1_\n14", " col1_18", "col1""_4" DESC) INCLUDE (col1_2, col1_3, "c'ol1_5", col1_6, "%3fcol1_13", col1_17);
        test_1        |             CREATE INDEX ON "%qtable1" ("%3fcol1_13" ASC, "col1""_4" ASC, "col1_ �1" DESC, " col1_18" ASC, "col1_""0" DESC);
        test_1        |             CREATE INDEX ON "%qtable1" (col1_16 DESC, col1_3 ASC, col1_9, col1_10 DESC, col1_17 DESC, col1_8, ("col1""_4" + col1_2) DESC, "col1_ �1", "col1_""0") INCLUDE (col1_2, col1_6, col1_12, "%3fcol1_13");
        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.40s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@rafiss rafiss mentioned this issue Mar 21, 2024
Merged
This was referenced Mar 22, 2024
Closed
Closed
Closed
Closed
@cockroach-teamcity
Copy link
Member Author

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

        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/TestComposeCompare1539451633/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("010300000001000000050000000000000000001440000000000000224000000000000014400000000000000840000000000000184000000000000008400000000000001840000000000000224000000000000014400000000000002240"),
        test_1        |               	nil,
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_makeenvelope(5.0:::FLOAT8::FLOAT8::FLOAT8, 9.0:::FLOAT8::FLOAT8::FLOAT8, 6.0:::FLOAT8::FLOAT8::FLOAT8, 3.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS col653892,
        test_1        |             			NULL::GEOGRAPHY AS "c""ol653893"
        test_1        |             	)
        test_1        |             		AS tab345861
        test_1        |             ORDER BY
        test_1        |             	col653892 ASC NULLS LAST, "c""ol653893" ASC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_makeenvelope(5.0::FLOAT8::FLOAT8::FLOAT8, 9.0::FLOAT8::FLOAT8::FLOAT8, 6.0::FLOAT8::FLOAT8::FLOAT8, 3.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS col653892,
        test_1        |             			NULL::GEOGRAPHY AS "c""ol653893"
        test_1        |             	)
        test_1        |             		AS tab345861
        test_1        |             ORDER BY
        test_1        |             	col653892 ASC NULLS LAST, "c""ol653893" 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 (986.22s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@craig craig bot closed this as completed in #120857 Mar 26, 2024
@craig craig bot closed this as completed in 393aa0c Mar 26, 2024
SQL Foundations automation moved this from Triage to Done Mar 26, 2024
This was referenced Mar 26, 2024
Merged
Merged
@blathers-crl blathers-crl bot mentioned this issue Apr 9, 2024
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
branch-release-23.1 Used to mark GA and release blockers and technical advisories for 23.1 O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
SQL Foundations
  
Done
Milestone
23.1
Development

Successfully merging a pull request may close this issue.

compose: remove PG ComposeCompare test rafiss/cockroach
1 participant
@cockroach-teamcity