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

Closed
cockroach-teamcity opened this issue Mar 22, 2024 · 14 comments
Closed

compose: TestComposeCompare failed #120868

cockroach-teamcity opened this issue Mar 22, 2024 · 14 comments
Labels
branch-release-23.1.18-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 22, 2024 •
edited by cockroach-jira-scripts

compose.TestComposeCompare failed with artifacts on release-23.1.18-rc @ e49c1e59c270ee6cb3aeed67488dcf8148a43c92:

        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2024-03-22 05:19:33.959 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-22 05:19:33.959 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2024-03-22 05:19:33.959 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2024-03-22 05:19:33.963 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2024-03-22 05:19:33.969 UTC [68] LOG:  database system was shut down at 2024-03-22 05:19:33 UTC
        postgres_1    | 2024-03-22 05:19:33.975 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2024-03-22 05:29:37.341 UTC [98] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2024-03-22 05:29:37.341 UTC [98] STATEMENT:  CREATE TABLE table͖1 (col1_0 REGCLASS NOT NULL, PRIMARY KEY (col1_0));
        postgres_1    | 	CREATE UNIQUE INDEX ON table͖1 (col1_0);
        postgres_1    | 	CREATE INDEX ON table͖1 (col1_0 ASC);
        postgres_1    | 	CREATE UNIQUE INDEX ON table͖1 (col1_0);
        postgres_1    | 	CREATE UNIQUE INDEX ON table͖1 (col1_0 DESC);
        postgres_1    | 	CREATE INDEX ON table͖1 ((CASE WHEN col1_0 IS NULL THEN e'\x00'::TEXT ELSE '8'::TEXT END) ASC);
        postgres_1    | 	CREATE INDEX ON table͖1 (col1_0 DESC);
        postgres_1    | 	CREATE UNIQUE INDEX ON table͖1 (col1_0 DESC);
        postgres_1    | 	
        test_1        | --- FAIL: TestCompare (607.00s)
        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.69s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:172: CREATE TABLE table͖1 (col1_0 REGCLASS NOT NULL, PRIMARY KEY (col1_0));
        test_1        |             CREATE UNIQUE INDEX ON table͖1 (col1_0);
        test_1        |             CREATE INDEX ON table͖1 (col1_0 ASC);
        test_1        |             CREATE UNIQUE INDEX ON table͖1 (col1_0);
        test_1        |             CREATE UNIQUE INDEX ON table͖1 (col1_0 DESC);
        test_1        |             CREATE INDEX ON table͖1 ((CASE WHEN col1_0 IS NULL THEN e'\x00'::TEXT ELSE '8'::TEXT END) ASC);
        test_1        |             CREATE INDEX ON table͖1 (col1_0 DESC);
        test_1        |             CREATE UNIQUE INDEX ON table͖1 (col1_0 DESC);
        test_1        |             
        test_1        |         compare_test.go:173: postgres: exec: ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_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 (632.23s)
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-36915
@cockroach-teamcity cockroach-teamcity added branch-release-23.1.18-rc O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels Mar 22, 2024
@cockroach-teamcity cockroach-teamcity added this to the 23.1 milestone Mar 22, 2024
This was referenced Mar 22, 2024
Closed
Closed
Closed
Closed
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-23.1.18-rc @ e49c1e59c270ee6cb3aeed67488dcf8148a43c92:

        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | waiting for server to shut down...2024-03-23 05:17:35.940 UTC [49] LOG:  received fast shutdown request
        postgres_1    | .2024-03-23 05:17:35.941 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2024-03-23 05:17:35.943 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2024-03-23 05:17:35.945 UTC [51] LOG:  shutting down
        postgres_1    | 2024-03-23 05:17:36.044 UTC [49] LOG:  database system is shut down
        test_1        | I240323 05:17:36.073490 22 testutils/soon.go:41  [-] 1  SucceedsSoon: failed to connect to ``host=postgres user=postgres database=postgres``: dial error (dial tcp 172.18.0.2:5432: connect: connection refused)
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2024-03-23 05:17:36.161 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-23 05:17:36.161 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2024-03-23 05:17:36.161 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2024-03-23 05:17:36.165 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2024-03-23 05:17:36.169 UTC [68] LOG:  database system was shut down at 2024-03-23 05:17:36 UTC
        postgres_1    | 2024-03-23 05:17:36.174 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2024-03-23 05:17:38.086 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2024-03-23 05:17:38.086 UTC [78] STATEMENT:  CREATE TABLE table4 (col4_0 JSONB NOT NULL, col4_1 REGCLASS NOT NULL, col4_2 JSONB NOT NULL, col4_3 VARCHAR NOT NULL, col4_4 BOOL NOT NULL, "co\\u6887l�4_5" TIMESTAMPTZ, "col4 _6" INTERVAL NOT NULL, "col4_""7" TIMESTAMP NOT NULL, col4_8 REGCLASS NULL, co😮l4_9 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col4 _6" IS NULL THEN e'\x0f'::TEXT ELSE e'\x15:-V>\f\x19C4'::TEXT END) STORED, col4_10 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col4 _6" IS NULL THEN e'\x03z6\b\x06\t\x1f,'::TEXT ELSE e'\x0ewKKy$-'::TEXT END) STORED, "col�4_11" TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col4_0 AS TEXT))) STORED, "cOl4_12" TEXT GENERATED ALWAYS AS (CASE WHEN "co\\u6887l�4_5" IS NULL THEN e'\x00'::TEXT ELSE e'HEn\x0f\x10\r1s\x15'::TEXT END) STORED, "c""ol4\\u6DB0_13" TEXT NULL GENERATED ALWAYS AS (CASE WHEN col4_8 IS NULL THEN e'\x00'::TEXT ELSE 'fmu'::TEXT END) STORED, col4_14 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col4 _6" IS NULL THEN ''::TEXT ELSE e'\x7fI\x0e\f<\b'::TEXT END) STORED, PRIMARY KEY (col4_1, col4_14, col4_10));
        postgres_1    | 	CREATE UNIQUE INDEX ON table4 (co😮l4_9 DESC, col4_14, col4_1 DESC) INCLUDE (col4_3, "co\\u6887l�4_5", "col4 _6", "col4_""7");
        postgres_1    | 	CREATE INDEX ON table4 (co😮l4_9, (CASE WHEN col4_1 IS NULL THEN e' \tPxQ'::TEXT ELSE ''::TEXT END) DESC, "co\\u6887l�4_5" DESC, col4_3 ASC, "c""ol4\\u6DB0_13" ASC, "col4 _6", col4_1 ASC, col4_10 DESC, "cOl4_12" ASC, "col4_""7", col4_14 ASC, col4_8, "col�4_11" ASC) INCLUDE (col4_0, col4_2, col4_4);
        postgres_1    | 	
        test_1        | --- FAIL: TestCompare (606.20s)
        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.00s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:172: CREATE TABLE table4 (col4_0 JSONB NOT NULL, col4_1 REGCLASS NOT NULL, col4_2 JSONB NOT NULL, col4_3 VARCHAR NOT NULL, col4_4 BOOL NOT NULL, "co\\u6887l�4_5" TIMESTAMPTZ, "col4 _6" INTERVAL NOT NULL, "col4_""7" TIMESTAMP NOT NULL, col4_8 REGCLASS NULL, co😮l4_9 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col4 _6" IS NULL THEN e'\x0f'::TEXT ELSE e'\x15:-V>\f\x19C4'::TEXT END) STORED, col4_10 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col4 _6" IS NULL THEN e'\x03z6\b\x06\t\x1f,'::TEXT ELSE e'\x0ewKKy$-'::TEXT END) STORED, "col�4_11" TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col4_0 AS TEXT))) STORED, "cOl4_12" TEXT GENERATED ALWAYS AS (CASE WHEN "co\\u6887l�4_5" IS NULL THEN e'\x00'::TEXT ELSE e'HEn\x0f\x10\r1s\x15'::TEXT END) STORED, "c""ol4\\u6DB0_13" TEXT NULL GENERATED ALWAYS AS (CASE WHEN col4_8 IS NULL THEN e'\x00'::TEXT ELSE 'fmu'::TEXT END) STORED, col4_14 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "col4 _6" IS NULL THEN ''::TEXT ELSE e'\x7fI\x0e\f<\b'::TEXT END) STORED, PRIMARY KEY (col4_1, col4_14, col4_10));
        test_1        |             CREATE UNIQUE INDEX ON table4 (co😮l4_9 DESC, col4_14, col4_1 DESC) INCLUDE (col4_3, "co\\u6887l�4_5", "col4 _6", "col4_""7");
        test_1        |             CREATE INDEX ON table4 (co😮l4_9, (CASE WHEN col4_1 IS NULL THEN e' \tPxQ'::TEXT ELSE ''::TEXT END) DESC, "co\\u6887l�4_5" DESC, col4_3 ASC, "c""ol4\\u6DB0_13" ASC, "col4 _6", col4_1 ASC, col4_10 DESC, "cOl4_12" ASC, "col4_""7", col4_14 ASC, col4_8, "col�4_11" ASC) INCLUDE (col4_0, col4_2, col4_4);
        test_1        |             
        test_1        |         compare_test.go:173: postgres: exec: ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_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.08s)
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 23, 2024
Closed
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-23.1.18-rc @ e49c1e59c270ee6cb3aeed67488dcf8148a43c92:

        test_1        |               	nil,
        test_1        |               	nil,
        test_1        |             - 	s"2000-01-08 23:59:53 +0000 UTC",
        test_1        |             + 	s"2000-01-09 23:59:53 +0000 UTC",
        test_1        |               	nil,
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			NULL::rand_typ_0 AS col418933,
        test_1        |             			NULL::GEOMETRY AS col418934,
        test_1        |             			(('2000-01-10':::DATE::DATE::DATE - int4(log(4.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT4::INT4)::DATE::DATE - '00:00:07':::INTERVAL::INTERVAL::INTERVAL)::TIMESTAMP
        test_1        |             				AS col418935,
        test_1        |             			NULL::DECIMAL[] AS col418936
        test_1        |             	)
        test_1        |             		AS tab245246
        test_1        |             ORDER BY
        test_1        |             	col418933 ASC NULLS FIRST, col418934 NULLS LAST, col418935, col418936 DESC 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_0 AS col418933,
        test_1        |             			NULL::GEOMETRY AS col418934,
        test_1        |             			(('2000-01-10'::DATE::DATE::DATE - int4(log(4.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT4::INT4)::DATE::DATE - '00:00:07'::INTERVAL::INTERVAL::INTERVAL)::TIMESTAMP
        test_1        |             				AS col418935,
        test_1        |             			NULL::DECIMAL[] AS col418936
        test_1        |             	)
        test_1        |             		AS tab245246
        test_1        |             ORDER BY
        test_1        |             	col418933 ASC NULLS FIRST, col418934 NULLS LAST, col418935, col418936 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 (975.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 cockroach-teamcity mentioned this issue Mar 24, 2024
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-23.1.18-rc @ e49c1e59c270ee6cb3aeed67488dcf8148a43c92:

        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (434.58s)
        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/TestComposeCompare1250374494/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        |             - 	int32(2),
        test_1        |             + 	int32(3),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			COALESCE(NULL::TIME[], NULL::TIME[]) AS col609413,
        test_1        |             			int4(acosh(8.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT4 AS col͠609414
        test_1        |             	)
        test_1        |             		AS tab391115
        test_1        |             ORDER BY
        test_1        |             	col609413, col͠609414 ASC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			COALESCE(NULL::TIME[], NULL::TIME[]) AS col609413,
        test_1        |             			int4(acosh(8.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::INT4 AS col͠609414
        test_1        |             	)
        test_1        |             		AS tab391115
        test_1        |             ORDER BY
        test_1        |             	col609413, col͠609414 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_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (1062.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 cockroach-teamcity mentioned this issue Mar 27, 2024
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-23.1.18-rc @ 9d3d9d15ec822606e78ca93613f18ce5f09ef55f:

        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.00s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        | panic: geos: no locations to init GEOS [recovered]
        test_1        | 	panic: geos: no locations to init GEOS
        test_1        | 
        test_1        | goroutine 8 [running]:
        test_1        | testing.tRunner.func1.2({0x22bb5e0, 0xc001491400})
        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({0x22bb5e0, 0xc001491400})
        test_1        | 	GOROOT/src/runtime/panic.go:884 +0x212
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x45f7440?, {0x31ffa08?, 0xc0014ec7e0?})
        test_1        | 	github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:375 +0x436
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x31c3320?, 0x45f7440)
        test_1        | 	github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:308 +0x13c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc0013f8d80)
        test_1        | 	github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:225 +0x96
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc0011f1560, {0xc001387200?, 0x4, 0x8?})
        test_1        | 	github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:258 +0x71f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0xc000090968?, 0x24bfee9?, {0xc001387200?, 0x20f5100?, 0x1?})
        test_1        | 	github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:96 +0x2e
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0x20f5100?, {0x24bfee9, 0x5}, 0x4, 0x0?, {0xc00176da48, 0x3, 0xc0010545a0?})
        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(0xc000288000?)
        test_1        | 	github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:84 +0x37
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.wrapCommonSetup.func1(0x269d540?)
        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(0xc0010d5ba0)
        test_1        | 	github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:143 +0xed
        test_1        | testing.tRunner(0xc0010d5ba0, 0xc0011f14d0)
        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_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:124: exit status 2
--- FAIL: TestComposeCompare (19.01s)
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.18-rc @ 8813244dbffd3a2305efc4fa114be78354d66b03:

        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/TestComposeCompare2608547093/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:203: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |               	strings.Join({
        test_1        |               		"01010000400000000000001040F",
        test_1        |             - 		"6",
        test_1        |             + 		"5",
        test_1        |               		"227809B7B9EE3F0000000000001040",
        test_1        |               	}, ""),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_makepointm(COALESCE(st_xmax(NULL::BOX2D::BOX2D)::FLOAT8, 4.0:::FLOAT8::FLOAT8)::FLOAT8, cos(6.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, 4.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS col676040
        test_1        |             	)
        test_1        |             		AS tab345474
        test_1        |             ORDER BY
        test_1        |             	col676040 ASC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_makepointm(COALESCE(st_xmax(NULL::BOX2D::BOX2D)::FLOAT8, 4.0::FLOAT8::FLOAT8)::FLOAT8, cos(6.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, 4.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |             				AS col676040
        test_1        |             	)
        test_1        |             		AS tab345474
        test_1        |             ORDER BY
        test_1        |             	col676040 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_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (1031.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
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-23.1.18-rc @ 8813244dbffd3a2305efc4fa114be78354d66b03:

        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 (201.94s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare2595037771/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("010300000001000000050000000000000000002040000000000000224000000000000020400000000000002040000000000000144000000000000020400000000000001440000000000000224000000000000020400000000000002240"),
        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, 9.0:::FLOAT8::FLOAT8::FLOAT8, 5.0:::FLOAT8::FLOAT8::FLOAT8, 8.0:::FLOAT8::FLOAT8::FLOAT8, 0:::INT8::INT4::INT4)::GEOMETRY
        test_1        |             				AS col226511
        test_1        |             	)
        test_1        |             		AS "tA""b145562"
        test_1        |             ORDER BY
        test_1        |             	col226511;
        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, 9.0::FLOAT8::FLOAT8::FLOAT8, 5.0::FLOAT8::FLOAT8::FLOAT8, 8.0::FLOAT8::FLOAT8::FLOAT8, 0::INT8::INT4::INT4)::GEOMETRY
        test_1        |             				AS col226511
        test_1        |             	)
        test_1        |             		AS "tA""b145562"
        test_1        |             ORDER BY
        test_1        |             	col226511;
        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_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (831.01s)
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 Apr 2, 2024
Closed
Closed
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-23.1.18-rc @ 8813244dbffd3a2305efc4fa114be78354d66b03:

        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | waiting for server to shut down...2024-04-03 05:19:49.012 UTC [49] LOG:  received fast shutdown request
        postgres_1    | .2024-04-03 05:19:49.014 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2024-04-03 05:19:49.016 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2024-04-03 05:19:49.019 UTC [51] LOG:  shutting down
        postgres_1    | 2024-04-03 05:19:49.118 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-04-03 05:19:49.235 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-04-03 05:19:49.235 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2024-04-03 05:19:49.235 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2024-04-03 05:19:49.238 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2024-04-03 05:19:49.243 UTC [68] LOG:  database system was shut down at 2024-04-03 05:19:49 UTC
        postgres_1    | 2024-04-03 05:19:49.249 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2024-04-03 05:19:51.103 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2024-04-03 05:19:51.103 UTC [78] STATEMENT:  CREATE TABLE "table 5" (col5_0 TSVECTOR NOT NULL, c😺ol5_1 CHAR NOT NULL, col5_2 INTERVAL NOT NULL, "'
col5_3" BOX2D NULL, "%vcol
        postgres_1    | 	5_4" "char" NOT NULL, "co'l5_5" TEXT NULL, col5_6 INET NOT NULL, "Co l5_7" OID NULL, "coL5_8" TEXT NULL GENERATED ALWAYS AS (lower(CAST("'
col5_3" AS TEXT))) STORED, col5_9 TEXT NULL GENERATED ALWAYS AS (lower(CAST("Co l5_7" AS TEXT))) STORED, col5_10 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col5_2 IS NULL THEN e'\x00'::TEXT ELSE e'h\t\x1c53Ok?'::TEXT END) STORED, col5_11 TEXT NULL GENERATED ALWAYS AS (lower("co'l5_5")) STORED, col5_12 TEXT NULL GENERATED ALWAYS AS (lower(CAST("'
col5_3" AS TEXT))) STORED, col5_̨13 TEXT NOT NULL GENERATED ALWAYS AS (lower(c😺ol5_1)) STORED, col5_14 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col5_6 AS TEXT))) STORED);
        postgres_1    | 	CREATE UNIQUE INDEX ON "table 5" (lower(CAST(col5_6 AS TEXT)), col5_11 DESC);
        postgres_1    | 	CREATE UNIQUE INDEX ON "table 5" ("Co l5_7" ASC);
        postgres_1    | 	
        test_1        | --- FAIL: TestCompare (606.20s)
        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.12s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:172: CREATE TABLE "table 5" (col5_0 TSVECTOR NOT NULL, c😺ol5_1 CHAR NOT NULL, col5_2 INTERVAL NOT NULL, "'
col5_3" BOX2D NULL, "%vcol
        test_1        |             5_4" "char" NOT NULL, "co'l5_5" TEXT NULL, col5_6 INET NOT NULL, "Co l5_7" OID NULL, "coL5_8" TEXT NULL GENERATED ALWAYS AS (lower(CAST("'
col5_3" AS TEXT))) STORED, col5_9 TEXT NULL GENERATED ALWAYS AS (lower(CAST("Co l5_7" AS TEXT))) STORED, col5_10 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col5_2 IS NULL THEN e'\x00'::TEXT ELSE e'h\t\x1c53Ok?'::TEXT END) STORED, col5_11 TEXT NULL GENERATED ALWAYS AS (lower("co'l5_5")) STORED, col5_12 TEXT NULL GENERATED ALWAYS AS (lower(CAST("'
col5_3" AS TEXT))) STORED, col5_̨13 TEXT NOT NULL GENERATED ALWAYS AS (lower(c😺ol5_1)) STORED, col5_14 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col5_6 AS TEXT))) STORED);
        test_1        |             CREATE UNIQUE INDEX ON "table 5" (lower(CAST(col5_6 AS TEXT)), col5_11 DESC);
        test_1        |             CREATE UNIQUE INDEX ON "table 5" ("Co l5_7" 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_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 cockroach-teamcity mentioned this issue Apr 4, 2024
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-23.1.18-rc @ c0700bf24cba1541eb28d71761d94dea18800542:

        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/TestComposeCompare3160124224/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("I00:00:096.0000000000000000"),
        test_1        |             + 	string("I00:00:096"),
        test_1        |               	int32(8),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			(('I':::STRING::STRING::STRING || '00:00:09':::INTERVAL::INTERVAL::INTERVAL)::STRING::STRING || (6:::DECIMAL::DECIMAL::DECIMAL ^ 1:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::STRING
        test_1        |             				AS "😥c'o_l144984",
        test_1        |             			8:::INT8::INT4 AS col144985
        test_1        |             	)
        test_1        |             		AS tab😤100779
        test_1        |             ORDER BY
        test_1        |             	"😥c'o_l144984" DESC NULLS FIRST, col144985 ASC NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			(('I'::TEXT::TEXT::TEXT || '00:00:09'::INTERVAL::INTERVAL::INTERVAL)::TEXT::TEXT || (6::DECIMAL::DECIMAL::DECIMAL ^ 1::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::TEXT
        test_1        |             				AS "😥c'o_l144984",
        test_1        |             			8::INT8::INT4 AS col144985
        test_1        |             	)
        test_1        |             		AS tab😤100779
        test_1        |             ORDER BY
        test_1        |             	"😥c'o_l144984" DESC NULLS FIRST, col144985 ASC NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (745.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.18-rc @ c0700bf24cba1541eb28d71761d94dea18800542:

        test_1        | I240408 05:17:10.419402 23 testutils/soon.go:41  [-] 1  SucceedsSoon: failed to connect to ``host=postgres user=postgres database=postgres``: dial error (dial tcp 172.18.0.3:5432: connect: connection refused)
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2024-04-08 05:17:10.457 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-04-08 05:17:10.457 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2024-04-08 05:17:10.457 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2024-04-08 05:17:10.460 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2024-04-08 05:17:10.464 UTC [68] LOG:  database system was shut down at 2024-04-08 05:17:10 UTC
        postgres_1    | 2024-04-08 05:17:10.469 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2024-04-08 05:17:12.612 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2024-04-08 05:17:12.612 UTC [78] STATEMENT:  CREATE TABLE "tab le3" ("cOl3_0" TIMESTAMPTZ NOT NULL, col3_1 BYTEA NOT NULL, "col3_ 2" UUID NOT NULL, col3_3 INT4 NULL, col3_4 FLOAT8 NOT NULL, "co-l3_5" TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "cOl3_0" IS NULL THEN e'\x00'::TEXT ELSE 'P#;'::TEXT END) STORED, col3_6 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col3_1 IS NULL THEN ')u'::TEXT ELSE '4'::TEXT END) STORED, col3_7 INT8 NULL GENERATED ALWAYS AS (col3_3 + 1819266180::INT8) STORED, "col3 _8" FLOAT8 NOT NULL GENERATED ALWAYS AS (col3_4 + (-0.9755109524934098)::FLOAT8) STORED, PRIMARY KEY (col3_4, "co-l3_5", "cOl3_0"));
        postgres_1    | 	CREATE INDEX ON "tab le3" (col3_4, "cOl3_0" DESC, (CASE WHEN col3_1 IS NULL THEN e'o5\x0b\x14DKAZ'::TEXT ELSE e'$z\x04\x047~Rf'::TEXT END), col3_6 ASC, col3_3 ASC, col3_7 ASC, "col3_ 2" ASC, "col3 _8", "co-l3_5" ASC) INCLUDE (col3_1);
        postgres_1    | 	CREATE UNIQUE INDEX ON "tab le3" (col3_7 DESC, "cOl3_0" DESC, "col3_ 2", col3_1 DESC, col3_4, "col3 _8" DESC, (col3_3 + 297591518::INT8) ASC, col3_3 ASC, col3_6);
        postgres_1    | 	CREATE INDEX ON "tab le3" ("co-l3_5", (col3_4 + 1.4531507285072984::FLOAT8) ASC, col3_3, "cOl3_0" DESC, "col3 _8" DESC, col3_6 ASC);
        postgres_1    | 	CREATE UNIQUE INDEX ON "tab le3" ("cOl3_0" ASC, "co-l3_5", col3_7);
        postgres_1    | 	CREATE INDEX ON "tab le3" ("col3_ 2" DESC, col3_4, "cOl3_0", col3_1, col3_3 ASC, col3_7 DESC, "col3 _8" DESC, lower(CAST("col3_ 2" AS TEXT)) ASC);
        postgres_1    | 	CREATE INDEX ON "tab le3" ("col3 _8" ASC, col3_1 DESC, "cOl3_0" DESC, col3_7, "co-l3_5" DESC, "col3_ 2" ASC, col3_3, col3_4);
        postgres_1    | 	
        test_1        | --- FAIL: TestCompare (606.87s)
        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.18s)
        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 le3" ("cOl3_0" TIMESTAMPTZ NOT NULL, col3_1 BYTEA NOT NULL, "col3_ 2" UUID NOT NULL, col3_3 INT4 NULL, col3_4 FLOAT8 NOT NULL, "co-l3_5" TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN "cOl3_0" IS NULL THEN e'\x00'::TEXT ELSE 'P#;'::TEXT END) STORED, col3_6 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col3_1 IS NULL THEN ')u'::TEXT ELSE '4'::TEXT END) STORED, col3_7 INT8 NULL GENERATED ALWAYS AS (col3_3 + 1819266180::INT8) STORED, "col3 _8" FLOAT8 NOT NULL GENERATED ALWAYS AS (col3_4 + (-0.9755109524934098)::FLOAT8) STORED, PRIMARY KEY (col3_4, "co-l3_5", "cOl3_0"));
        test_1        |             CREATE INDEX ON "tab le3" (col3_4, "cOl3_0" DESC, (CASE WHEN col3_1 IS NULL THEN e'o5\x0b\x14DKAZ'::TEXT ELSE e'$z\x04\x047~Rf'::TEXT END), col3_6 ASC, col3_3 ASC, col3_7 ASC, "col3_ 2" ASC, "col3 _8", "co-l3_5" ASC) INCLUDE (col3_1);
        test_1        |             CREATE UNIQUE INDEX ON "tab le3" (col3_7 DESC, "cOl3_0" DESC, "col3_ 2", col3_1 DESC, col3_4, "col3 _8" DESC, (col3_3 + 297591518::INT8) ASC, col3_3 ASC, col3_6);
        test_1        |             CREATE INDEX ON "tab le3" ("co-l3_5", (col3_4 + 1.4531507285072984::FLOAT8) ASC, col3_3, "cOl3_0" DESC, "col3 _8" DESC, col3_6 ASC);
        test_1        |             CREATE UNIQUE INDEX ON "tab le3" ("cOl3_0" ASC, "co-l3_5", col3_7);
        test_1        |             CREATE INDEX ON "tab le3" ("col3_ 2" DESC, col3_4, "cOl3_0", col3_1, col3_3 ASC, col3_7 DESC, "col3 _8" DESC, lower(CAST("col3_ 2" AS TEXT)) ASC);
        test_1        |             CREATE INDEX ON "tab le3" ("col3 _8" ASC, col3_1 DESC, "cOl3_0" DESC, col3_7, "co-l3_5" DESC, "col3_ 2" ASC, col3_3, col3_4);
        test_1        |             
        test_1        |         compare_test.go:173: postgres: exec: ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_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 (630.76s)
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.18-rc @ 84cf36a2a05dcfcf6dfccf4014aad8f703ff6cef:

        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 (17.62s)
        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/TestComposeCompare401823649/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("0103000000010000000500000000000000008056C0000000000080464000000000008056C0000000000080564000000000008046C0000000000080564000000000008046C0000000000080464000000000008056C00000000000804640"),
        test_1        |             + 	nil,
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_geomfromgeohash('F'::TEXT::TEXT::TEXT, int4(mod(NULL::DECIMAL::DECIMAL, 6::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::INT4::INT4)::GEOMETRY
        test_1        |             				AS co_l17047
        test_1        |             	)
        test_1        |             		AS "ta""b13210"
        test_1        |             ORDER BY
        test_1        |             	co_l17047 ASC NULLS LAST;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			st_geomfromgeohash('F':::STRING::STRING::STRING, int4(mod(NULL::DECIMAL::DECIMAL, 6:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::INT4::INT4)::GEOMETRY
        test_1        |             				AS co_l17047
        test_1        |             	)
        test_1        |             		AS "ta""b13210"
        test_1        |             ORDER BY
        test_1        |             	co_l17047 ASC NULLS LAST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (646.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 cockroach-teamcity mentioned this issue Apr 10, 2024
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-23.1.18-rc @ 84cf36a2a05dcfcf6dfccf4014aad8f703ff6cef:

        postgres_1    | 			FROM
        postgres_1    | 				postgres.public."tabl%qe2" AS tab324030
        postgres_1    | 			WHERE
        postgres_1    | 				false::BOOL
        postgres_1    | 		)
        postgres_1    | 			AS tab324031
        postgres_1    | 	ORDER BY
        postgres_1    | 		col518691 ASC NULLS LAST, CAST("c\no😵l518692" AS TEXT) ASC NULLS FIRST, col518693 ASC
        test_1        | --- FAIL: TestCompare (1001.12s)
        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 (395.95s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        |         compare_test.go:150: initializing connection: cockroach1
        test_1        |         compare_test.go:150: initializing connection: postgres
        test_1        |         compare_test.go:201: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare4287258788/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("01030000000100000005000000000000000000000000000000008056C0000000000000000000000000008046C0000000000080464000000000008046C0000000000080464000000000008056C0000000000000000000000000008056C0"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT st_geomfromgeohash('H':::STRING::STRING::STRING, NULL::INT4::INT4)::GEOMETRY AS 😇col518700) AS tab324037
        test_1        |             ORDER BY
        test_1        |             	😇col518700 ASC NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT st_geomfromgeohash('H'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::GEOMETRY AS 😇col518700) AS tab324037
        test_1        |             ORDER BY
        test_1        |             	😇col518700 ASC NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (1025.78s)
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.18-rc @ 84cf36a2a05dcfcf6dfccf4014aad8f703ff6cef:

        test_1        |             + 				Int:              s"31699250014423124",
        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[] || log(2:::DECIMAL::DECIMAL::DECIMAL, 9:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::DECIMAL[]
        test_1        |             				AS col346588
        test_1        |             	)
        test_1        |             		AS t̰ab191542
        test_1        |             ORDER BY
        test_1        |             	col346588 ASC 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[] || log(2::DECIMAL::DECIMAL::DECIMAL, 9::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::DECIMAL[]
        test_1        |             				AS col346588
        test_1        |             	)
        test_1        |             		AS t̰ab191542
        test_1        |             ORDER BY
        test_1        |             	col346588 ASC NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:124: exit status 1
--- FAIL: TestComposeCompare (885.11s)
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.18-rc @ 84cf36a2a05dcfcf6dfccf4014aad8f703ff6cef:

        test_1        |     compare_test.go:132: Checking connection to: postgres
        test_1        |     compare_test.go:132: Checking connection to: cockroach1
        test_1        |     compare_test.go:132: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.00s)
        test_1        |         compare_test.go:141: starting test: postgres
        test_1        | panic: geos: no locations to init GEOS [recovered]
        test_1        | 	panic: geos: no locations to init GEOS
        test_1        | 
        test_1        | goroutine 23 [running]:
        test_1        | testing.tRunner.func1.2({0x22bb6a0, 0xc002302aa0})
        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({0x22bb6a0, 0xc002302aa0})
        test_1        | 	GOROOT/src/runtime/panic.go:884 +0x212
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x45f7440?, {0x31ffb08?, 0xc001df4e40?})
        test_1        | 	github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:375 +0x436
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0x31c3420?, 0x45f7440)
        test_1        | 	github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:308 +0x13c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc001cf3380)
        test_1        | 	github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:225 +0x96
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc001f869c0, {0xc001f9a050?, 0x5, 0xc001f869c0?})
        test_1        | 	github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:258 +0x71f
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0xc001fb2968?, 0x24bff69?, {0xc001f9a050?, 0x20f51c0?, 0x1?})
        test_1        | 	github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:96 +0x2e
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0x20f51c0?, {0x24bff69, 0x5}, 0x5, 0x0?, {0xc000d7da48, 0x3, 0xc001fb4000?})
        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(0xc000296000?)
        test_1        | 	github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:84 +0x37
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.wrapCommonSetup.func1(0x269d620?)
        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(0xc001cff520)
        test_1        | 	github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:143 +0xed
        test_1        | testing.tRunner(0xc001cff520, 0xc001f86930)
        test_1        | 	GOROOT/src/testing/testing.go:1446 +0x10b
        test_1        | created by testing.(*T).Run
        test_1        | 	GOROOT/src/testing/testing.go:1493 +0x35f
        compare_test_1 exited with code 2
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:124: exit status 2
--- FAIL: TestComposeCompare (17.61s)
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 Apr 14, 2024
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-23.1.18-rc @ 84cf36a2a05dcfcf6dfccf4014aad8f703ff6cef:

        postgres_1    | 			FROM
        postgres_1    | 				postgres.public."Ta}ble2" AS t͘ab169277
        postgres_1    | 			WHERE
        postgres_1    | 				true::BOOL
        postgres_1    | 		)
        postgres_1    | 			AS tab169278
        postgres_1    | 	ORDER BY
        postgres_1    | 		col249994 NULLS FIRST, "%qcol249995" ASC NULLS FIRST
        test_1        | --- FAIL: TestCompare (813.54s)
        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 (209.63s)
        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/TestComposeCompare2259079151/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("0103000000010000000500000000000000008046C0000000000000000000000000008046C00000000000804640000000000000000000000000008046400000000000000000000000000000000000000000008046C00000000000000000"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT st_geomfromgeohash('E':::STRING::STRING::STRING, NULL::INT4::INT4)::GEOMETRY AS col͛250016) AS tab169296
        test_1        |             ORDER BY
        test_1        |             	col͛250016 ASC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT st_geomfromgeohash('E'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::GEOMETRY AS col͛250016) AS tab169296
        test_1        |             ORDER BY
        test_1        |             	col͛250016 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 (838.12s)
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 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
No one assigned
Labels
branch-release-23.1.18-rc O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
SQL Foundations
Status: Done
SQL Foundations
  
Done
Milestone
23.1
Development

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