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 #119903

Closed
cockroach-teamcity opened this issue Mar 5, 2024 · 10 comments
Closed

compose: TestComposeCompare failed #119903

cockroach-teamcity opened this issue Mar 5, 2024 · 10 comments
Assignees
@rafiss
Labels
branch-release-23.1.17-rc 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 Mar 5, 2024 •
edited by cockroach-jira-scripts

compose.TestComposeCompare failed with artifacts on release-23.1.17-rc @ 52968eab6105ddcba8ff09df6f579cb24847a2ac:

        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (349.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/TestComposeCompare247732674/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        |               	s"2000-01-01 06:00:00 +0000 UTC",
        test_1        |             - 	string("010100000000000000008036C00000000000803640"),
        test_1        |             + 	nil,
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			'2000-01-01 06:00:00+00':::TIMESTAMPTZ::TIMESTAMPTZ AS col452151,
        test_1        |             			st_pointfromgeohash('E':::STRING::STRING::STRING, NULL::INT4::INT4)::GEOMETRY AS """col452152"
        test_1        |             	)
        test_1        |             		AS "t%qaB,253406"
        test_1        |             ORDER BY
        test_1        |             	col452151 ASC, """col452152" ASC NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			'2000-01-01 06:00:00+00'::TIMESTAMPTZ::TIMESTAMPTZ AS col452151,
        test_1        |             			st_pointfromgeohash('E'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::GEOMETRY AS """col452152"
        test_1        |             	)
        test_1        |             		AS "t%qaB,253406"
        test_1        |             ORDER BY
        test_1        |             	col452151 ASC, """col452152" 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 (979.45s)
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-36376
@cockroach-teamcity cockroach-teamcity added branch-release-23.1.17-rc O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels Mar 5, 2024
@cockroach-teamcity cockroach-teamcity added this to the 23.1 milestone Mar 5, 2024
This was referenced Mar 5, 2024
Closed
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-23.1.17-rc @ 52968eab6105ddcba8ff09df6f579cb24847a2ac:

        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 (144.10s)
        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/TestComposeCompare524813289/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("010300000001000000050000000000000000002040000000000000104000000000000020400000000000002240000000000000000000000000000022400000000000000000000000000000104000000000000020400000000000001040"),
        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(8.0:::FLOAT8::FLOAT8::FLOAT8, 4.0:::FLOAT8::FLOAT8::FLOAT8, 0.0:::FLOAT8::FLOAT8::FLOAT8, 9.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS col201048
        test_1        |             	)
        test_1        |             		AS "|tab113162"
        test_1        |             ORDER BY
        test_1        |             	col201048 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_makeenvelope(8.0::FLOAT8::FLOAT8::FLOAT8, 4.0::FLOAT8::FLOAT8::FLOAT8, 0.0::FLOAT8::FLOAT8::FLOAT8, 9.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS col201048
        test_1        |             	)
        test_1        |             		AS "|tab113162"
        test_1        |             ORDER BY
        test_1        |             	col201048 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (772.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 cockroach-teamcity mentioned this issue Mar 6, 2024
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-23.1.17-rc @ cc68ca88d04a7ca8e92beb51f3dbef6493fe175c:

        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare4243891004/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:203: compare postgres to cockroach1: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |               	nil,
        test_1        |               	nil,
        test_1        |             - 	string("0103000000010000000500000000000000008046C0000000000000000000000000008046C00000000000804640000000000000000000000000008046400000000000000000000000000000000000000000008046C00000000000000000"),
        test_1        |             + 	nil,
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			NULL::BOX2D AS col677500,
        test_1        |             			st_dwithin(NULL::GEOGRAPHY::GEOGRAPHY, NULL::GEOGRAPHY::GEOGRAPHY, 0.0:::FLOAT8::FLOAT8::FLOAT8)::BOOL
        test_1        |             				AS coͩl677501,
        test_1        |             			st_geomfromgeohash('E':::STRING::STRING::STRING, NULL::INT4::INT4)::GEOMETRY AS col͑677502
        test_1        |             	)
        test_1        |             		AS tab378756
        test_1        |             ORDER BY
        test_1        |             	CAST(col677500 AS STRING) DESC NULLS FIRST, coͩl677501 DESC NULLS LAST, col͑677502 ASC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			NULL::BOX2D AS col677500,
        test_1        |             			st_dwithin(NULL::GEOGRAPHY::GEOGRAPHY, NULL::GEOGRAPHY::GEOGRAPHY, 0.0::FLOAT8::FLOAT8::FLOAT8)::BOOL
        test_1        |             				AS coͩl677501,
        test_1        |             			st_geomfromgeohash('E'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::GEOMETRY AS col͑677502
        test_1        |             	)
        test_1        |             		AS tab378756
        test_1        |             ORDER BY
        test_1        |             	CAST(col677500 AS TEXT) DESC NULLS FIRST, coͩl677501 DESC NULLS LAST, col͑677502 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 (1140.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 Mar 8, 2024
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-23.1.17-rc @ cc68ca88d04a7ca8e92beb51f3dbef6493fe175c:

        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 (349.57s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare2327219746/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("0103000000010000000500000000000000000010400000000000001C40000000000000104000000000000020400000000000000840000000000000204000000000000008400000000000001C4000000000000010400000000000001C40"),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_makeenvelope(4.0::FLOAT8::FLOAT8::FLOAT8, 7.0::FLOAT8::FLOAT8::FLOAT8, 3.0::FLOAT8::FLOAT8::FLOAT8, 8.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS col477720
        test_1        |             	)
        test_1        |             		AS "ta B302285"
        test_1        |             ORDER BY
        test_1        |             	col477720;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_makeenvelope(4.0:::FLOAT8::FLOAT8::FLOAT8, 7.0:::FLOAT8::FLOAT8::FLOAT8, 3.0:::FLOAT8::FLOAT8::FLOAT8, 8.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS col477720
        test_1        |             	)
        test_1        |             		AS "ta B302285"
        test_1        |             ORDER BY
        test_1        |             	col477720;
        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 (978.35s)
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 Mar 13, 2024
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-23.1.17-rc @ d50ccb5a52cdf5a1f41cbb2fa61ef971c65e1346:

        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare3721710308/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("H"),
        test_1        |               	[16]uint8{0x00, 0x00, 0x00, 0x00, ...},
        test_1        |             - 	string("010300000000000000"),
        test_1        |             + 	string("010300000001000000050000000000000000002040000000000000004000000000000020400000000000001840000000000000184000000000000018400000000000001840000000000000004000000000000020400000000000000040"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			'H':::STRING::VARCHAR AS " col515627",
        test_1        |             			'00000000-0000-0000-0000-000000000003':::UUID::UUID AS col515628,
        test_1        |             			st_makeenvelope(8.0:::FLOAT8::FLOAT8::FLOAT8, 2.0:::FLOAT8::FLOAT8::FLOAT8, 6.0:::FLOAT8::FLOAT8::FLOAT8, 6.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS col515629
        test_1        |             	)
        test_1        |             		AS "tAb342369"
        test_1        |             ORDER BY
        test_1        |             	" col515627" NULLS FIRST, col515628 NULLS LAST, col515629 ASC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			'H'::TEXT::VARCHAR AS " col515627",
        test_1        |             			'00000000-0000-0000-0000-000000000003'::UUID::UUID AS col515628,
        test_1        |             			st_makeenvelope(8.0::FLOAT8::FLOAT8::FLOAT8, 2.0::FLOAT8::FLOAT8::FLOAT8, 6.0::FLOAT8::FLOAT8::FLOAT8, 6.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS col515629
        test_1        |             	)
        test_1        |             		AS "tAb342369"
        test_1        |             ORDER BY
        test_1        |             	" col515627" NULLS FIRST, col515628 NULLS LAST, col515629 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 (1089.14s)
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.17-rc @ d50ccb5a52cdf5a1f41cbb2fa61ef971c65e1346:

        test_1        |             + 				Exp:              -15,
        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::rand_typ_3 AS "c""ol321019",
        test_1        |             			(sqrt(9:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || NULL::DECIMAL[]::DECIMAL[])::DECIMAL[]
        test_1        |             				AS col321020
        test_1        |             	)
        test_1        |             		AS tab169600
        test_1        |             ORDER BY
        test_1        |             	"c""ol321019" NULLS LAST, col321020 NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			NULL::rand_typ_3 AS "c""ol321019",
        test_1        |             			(sqrt(9::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || NULL::DECIMAL[]::DECIMAL[])::DECIMAL[]
        test_1        |             				AS col321020
        test_1        |             	)
        test_1        |             		AS tab169600
        test_1        |             ORDER BY
        test_1        |             	"c""ol321019" NULLS LAST, col321020 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 (839.79s)
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.17-rc @ d50ccb5a52cdf5a1f41cbb2fa61ef971c65e1346:

        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 (210.52s)
        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/TestComposeCompare976442436/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("010300000001000000050000000000000000000840000000000000224000000000000008400000000000002040000000000000104000000000000020400000000000001040000000000000224000000000000008400000000000002240"),
        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, 9.0:::FLOAT8::FLOAT8::FLOAT8, 4.0:::FLOAT8::FLOAT8::FLOAT8, 8.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS "c'ol233860"
        test_1        |             	)
        test_1        |             		AS "tab%72137081"
        test_1        |             ORDER BY
        test_1        |             	"c'ol233860" ASC;
        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, 9.0::FLOAT8::FLOAT8::FLOAT8, 4.0::FLOAT8::FLOAT8::FLOAT8, 8.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS "c'ol233860"
        test_1        |             	)
        test_1        |             		AS "tab%72137081"
        test_1        |             ORDER BY
        test_1        |             	"c'ol233860" ASC;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (841.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.17-rc @ d50ccb5a52cdf5a1f41cbb2fa61ef971c65e1346:

        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 (226.91s)
        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/TestComposeCompare3154103284/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        |             + 	[]uint8{0x01, 0x08, 0xa2, 0x12, 0x10, 0xc0, 0x84, 0x3d},
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_astwkb(st_makepointm(9.0:::FLOAT8::FLOAT8::FLOAT8, 8.0:::FLOAT8::FLOAT8::FLOAT8, 5.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY, NULL::INT4::INT4, int4(B'0101'::BIT::BIT)::INT4::INT4, 5:::INT8::INT4::INT4)::BYTES
        test_1        |             				AS "cOl302246"
        test_1        |             	)
        test_1        |             		AS " tab168199"
        test_1        |             ORDER BY
        test_1        |             	"cOl302246" NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_astwkb(st_makepointm(9.0::FLOAT8::FLOAT8::FLOAT8, 8.0::FLOAT8::FLOAT8::FLOAT8, 5.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY, NULL::INT4::INT4, int4(B'0101'::BIT::BIT)::INT4::INT4, 5::INT8::INT4::INT4)::BYTEA
        test_1        |             				AS "cOl302246"
        test_1        |             	)
        test_1        |             		AS " tab168199"
        test_1        |             ORDER BY
        test_1        |             	"cOl302246" 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 (856.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.17-rc @ d50ccb5a52cdf5a1f41cbb2fa61ef971c65e1346:

        test_1        |               	string("A"),
        test_1        |               	nil,
        test_1        |             - 	string("16B"),
        test_1        |             + 	string("16.0000000000000000B"),
        test_1        |               	string("G"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			'A':::STRING::CHAR AS col845567,
        test_1        |             			NULL::rand_typ_3 AS col845568,
        test_1        |             			((2:::DECIMAL::DECIMAL::DECIMAL ^ 4:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || 'B':::STRING::STRING::STRING)::STRING
        test_1        |             				AS col845569,
        test_1        |             			'G':::STRING::STRING AS col😦845570
        test_1        |             	)
        test_1        |             		AS tab503329
        test_1        |             ORDER BY
        test_1        |             	col845567 DESC NULLS FIRST, col845568 ASC, col845569 DESC NULLS FIRST, col😦845570 ASC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			'A'::TEXT::CHAR AS col845567,
        test_1        |             			NULL::rand_typ_3 AS col845568,
        test_1        |             			((2::DECIMAL::DECIMAL::DECIMAL ^ 4::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || 'B'::TEXT::TEXT::TEXT)::TEXT
        test_1        |             				AS col845569,
        test_1        |             			'G'::TEXT::TEXT AS col😦845570
        test_1        |             	)
        test_1        |             		AS tab503329
        test_1        |             ORDER BY
        test_1        |             	col845567 DESC NULLS FIRST, col845568 ASC, col845569 DESC NULLS FIRST, col😦845570 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 (1186.57s)
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 Mar 22, 2024
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-23.1.17-rc @ d50ccb5a52cdf5a1f41cbb2fa61ef971c65e1346:

        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/TestComposeCompare2675703521/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("0103000000010000000500000000000000000020400000000000001C40000000000000204000000000000018400000000000009040000000000000184000000000000090400000000000001C4000000000000020400000000000001C40"),
        test_1        |               	float32(2),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_makeenvelope(8.0:::FLOAT8::FLOAT8::FLOAT8, 7.0:::FLOAT8::FLOAT8::FLOAT8, (4.0:::FLOAT8::FLOAT8::FLOAT8 ^ CASE WHEN false::BOOL THEN st_azimuth(NULL::GEOGRAPHY::GEOGRAPHY, NULL::GEOGRAPHY::GEOGRAPHY)::FLOAT8 ELSE 5.0:::FLOAT8::FLOAT8 END::FLOAT8)::FLOAT8::FLOAT8, 6.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS c͜ol202318,
        test_1        |             			2.0:::FLOAT8::FLOAT4 AS col202319
        test_1        |             	)
        test_1        |             		AS tab120766
        test_1        |             ORDER BY
        test_1        |             	c͜ol202318 NULLS FIRST, col202319 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_makeenvelope(8.0::FLOAT8::FLOAT8::FLOAT8, 7.0::FLOAT8::FLOAT8::FLOAT8, (4.0::FLOAT8::FLOAT8::FLOAT8 ^ CASE WHEN false::BOOL THEN st_azimuth(NULL::GEOGRAPHY::GEOGRAPHY, NULL::GEOGRAPHY::GEOGRAPHY)::FLOAT8 ELSE 5.0::FLOAT8::FLOAT8 END::FLOAT8)::FLOAT8::FLOAT8, 6.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS c͜ol202318,
        test_1        |             			2.0::FLOAT8::FLOAT4 AS col202319
        test_1        |             	)
        test_1        |             		AS tab120766
        test_1        |             ORDER BY
        test_1        |             	c͜ol202318 NULLS FIRST, col202319 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (791.53s)
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 22, 2024
Closed
Closed
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-23.1.17-rc @ d50ccb5a52cdf5a1f41cbb2fa61ef971c65e1346:

        postgres_1    | 			GROUP BY
        postgres_1    | 				tab352202.col3_4
        postgres_1    | 		)
        postgres_1    | 			AS ta̢b352203
        postgres_1    | 	ORDER BY
        postgres_1    | 		col626885 ASC
        test_1        | --- FAIL: TestCompare (1023.70s)
        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 (418.50s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare2485716759/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.37340076694502B"),
        test_1        |             + 	string("1.373400766945016B"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT (atan(5.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8 || 'B':::STRING::STRING::STRING)::STRING AS col626899)
        test_1        |             		AS "ta}b352211"
        test_1        |             ORDER BY
        test_1        |             	col626899 ASC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT (atan(5.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8 || 'B'::TEXT::TEXT::TEXT)::TEXT AS col626899)
        test_1        |             		AS "ta}b352211"
        test_1        |             ORDER BY
        test_1        |             	col626899 ASC;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (1048.14s)
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 27, 2024
Closed
Closed
Closed
Closed
@cockroach-teamcity cockroach-teamcity mentioned this issue Apr 10, 2024
Closed
@cockroach-teamcity cockroach-teamcity mentioned this issue Apr 14, 2024
Closed
@cockroach-teamcity cockroach-teamcity mentioned this issue Apr 29, 2024
Closed
@cockroach-teamcity cockroach-teamcity mentioned this issue May 13, 2024
Closed
@rafiss rafiss closed this as completed May 15, 2024
SQL Foundations automation moved this from Triage to Done May 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@rafiss rafiss

Labels
branch-release-23.1.17-rc 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

No branches or pull requests
2 participants
@rafiss @cockroach-teamcity