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

Closed
cockroach-teamcity opened this issue Oct 5, 2022 · 439 comments
Closed

compose: TestComposeCompare failed #89361

cockroach-teamcity opened this issue Oct 5, 2022 · 439 comments
Labels
branch-release-22.2 Used to mark release blockers and technical advisories for 22.2 O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
SQL Sessions - Deprecated
Milestone
22.2

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Oct 5, 2022 •
edited by jlinder
Loading

compose.TestComposeCompare failed with artifacts on release-22.2 @ 18da6141d87f76c04f74ad6f9685fa619b97738a:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>
Help

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

Same failure on other branches

/cc @cockroachdb/sql-experience

This test on roachdash | Improve this report!

Jira issue: CRDB-20216
@cockroach-teamcity cockroach-teamcity added branch-release-22.2 Used to mark release blockers and technical advisories for 22.2 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. labels Oct 5, 2022
@cockroach-teamcity cockroach-teamcity added this to the 22.2 milestone Oct 5, 2022
@blathers-crl blathers-crl bot added the T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) label Oct 5, 2022
This was referenced Oct 5, 2022
Closed
Closed
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-22.2 @ 78e7ab8398a655b612cf7c9f8f31d904da5caa84:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>
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-22.2 @ c018f1a48d6854969a295632977ef62e2cb20226:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>
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-22.2 @ 64049e4b9210de3af4a1d814a9af0123b59a055f:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>
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-22.2 @ fbe8fde57907a776a9ac6f1cfe0c2596b36982bc:

        test_1        |         compare_test.go:137: initializing connection: postgres
        test_1        |         compare_test.go:188: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare2282814352/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:190: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             - 	string("2.0000000000000000000E"),
        test_1        |             + 	string("2.0000000000000000E"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			((2:::DECIMAL::DECIMAL::DECIMAL / 1:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || 'E':::STRING::STRING::STRING)::STRING
        test_1        |             				AS col_76450
        test_1        |             	)
        test_1        |             		AS tab_61147
        test_1        |             ORDER BY
        test_1        |             	col_76450 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			((2::DECIMAL::DECIMAL::DECIMAL / 1::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || 'E'::TEXT::TEXT::TEXT)::TEXT
        test_1        |             				AS col_76450
        test_1        |             	)
        test_1        |             		AS tab_61147
        test_1        |             ORDER BY
        test_1        |             	col_76450 NULLS FIRST;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.26s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table2 (col2_0 INT2 NOT NULL, col2_1 GEOGRAPHY NULL, col2_2 INT4 NOT NULL, col2_3 INT8 NOT NULL AS (col2_0 + col2_2) STORED, col2_4 INT8 NOT NULL AS (col2_2 + col2_0) STORED, PRIMARY KEY (col2_3), UNIQUE (col2_3 ASC, col2_4 ASC) PARTITION BY LIST (col2_3) (PARTITION table2_part_0 VALUES IN ((127:::INT8,), (6304186628843270709:::INT8,), ((-5750093512232944307):::INT8,), (5172635567358001108:::INT8,)), PARTITION table2_part_1 VALUES IN (((-2491734020105355826):::INT8,), (4478392630127269134:::INT8,), ((-8346823044894857190):::INT8,), (9223372036854775807:::INT8,)), PARTITION table2_part_2 VALUES IN (((-4360019729656583414):::INT8,), (7542287118514554001:::INT8,), ((-8002634173773963339):::INT8,), ((-8470871364079167076):::INT8,)), PARTITION table2_part_3 VALUES IN (((-6122786618050045606):::INT8,), ((-1264279645926269892):::INT8,), ((-3226800429182613328):::INT8,), ((-8005741950015047594):::INT8,)), PARTITION table2_part_4 VALUES IN (((-128):::INT8,), (7896098836593960555:::INT8,), ((-4305234484210727974):::INT8,)), PARTITION table2_part_5 VALUES IN (((-781307289568798375):::INT8,), (2245215459643767373:::INT8,), (92051188834833506:::INT8,), ((-8213852763664793043):::INT8,))) WHERE ((table2.col2_4 = (-128):::INT8) AND (table2.col2_3 != 9223372036854775807:::INT8)) OR (table2.col2_2 >= 2147483647:::INT8), INVERTED INDEX (col2_4, col2_3 ASC, col2_2, col2_0, col2_1 ASC) PARTITION BY LIST (col2_4, col2_3, col2_2, col2_0) (PARTITION table2_part_0 VALUES IN (((-3849244688697959832):::INT8, (-5042405554913312639):::INT8, (-263613817):::INT8, (-31417):::INT8), ((-9223372036854775807):::INT8, 3704214080058254725:::INT8, (-1591191362):::INT8, 15851:::INT8), ((-2285093363139523229):::INT8, (-210608142509011580):::INT8, (-1):::INT8, 24180:::INT8)), PARTITION table2_part_1 VALUES IN (((-8023957261430546873):::INT8, 7856079611908782097:::INT8, (-2032638797):::INT8, 8363:::INT8), (1:::INT8, (-3106326720003074753):::INT8, (-19221166):::INT8, (-31238):::INT8), ((-8073208242146279342):::INT8, 0:::INT8, 789753631:::INT8, (-16119):::INT8)), PARTITION table2_part_2 VALUES IN ((7547262172410418753:::INT8, (-5741874623296956856):::INT8, 794224941:::INT8, 15011:::INT8), ((-8475193176040400542):::INT8, (-175687236439832656):::INT8, (-1117761686):::INT8, 28900:::INT8), (1368126386282829609:::INT8, (-5667831868454138177):::INT8, (-1628941561):::INT8, (-16310):::INT8)), PARTITION table2_part_3 VALUES IN ((8835087437159207947:::INT8, 9223372036854775807:::INT8, (-1962278239):::INT8, 28985:::INT8), (1945259102225168554:::INT8, (-2199834763041781744):::INT8, (-559102553):::INT8, 21997:::INT8), ((-2854026122840475328):::INT8, 7380366400813950680:::INT8, 1583456977:::INT8, 1:::INT8)), PARTITION table2_part_4 VALUES IN ((7799437070165617786:::INT8, 3282444188379759499:::INT8, 831170683:::INT8, 6741:::INT8), ((-6654799593048684150):::INT8, 5949631249524683729:::INT8, (-49532426):::INT8, (-21766):::INT8), ((-4824951107503438423):::INT8, (-1234833750292311379):::INT8, (-595200569):::INT8, 1:::INT8)), PARTITION table2_part_5 VALUES IN ((8052209192629776549:::INT8, (-7592480553086419603):::INT8, (-1268295073):::INT8, 28106:::INT8), ((-5984807993119135230):::INT8, (-2147483648):::INT8, (-1020207313):::INT8, 3314:::INT8), ((-1160327277113257100):::INT8, (-4089558106101089967):::INT8, (-1521481881):::INT8, (-23711):::INT8)), PARTITION table2_part_6 VALUES IN (((-4281316593130045138):::INT8, (-2091993032382780586):::INT8, (-1979329437):::INT8, (-1):::INT8), ((-6049154071978776947):::INT8, 7172545180984178841:::INT8, 2032452876:::INT8, (-1):::INT8), (8442851415502074156:::INT8, 6384117194931721338:::INT8, 2120232499:::INT8, 19190:::INT8)), PARTITION table2_part_7 VALUES IN (((-8622868234759143927):::INT8, (-6491310350443164412):::INT8, 153119124:::INT8, (-30183):::INT8), ((-8573054144403994692):::INT8, (-2004329917578706565):::INT8, (-119901776):::INT8, 17999:::INT8), ((-951499659388992037):::INT8, (-8165542877513117591):::INT8, (-1478878761):::INT8, 17820:::INT8)), PARTITION "DEFAULT" VALUES IN ((DEFAULT, DEFAULT, DEFAULT, DEFAULT))), INDEX (lower(CAST(col2_1 AS STRING)) DESC, col2_0 ASC, col2_4 DESC, col2_2 DESC))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=670e6ce3-aee9-46a0-ae84-070ee2652269 for details on how to enable enterprise features (SQLSTATE XXC02)
        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:120: exit status 1
--- FAIL: TestComposeCompare (108.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-22.2 @ 6ee69b5e1c6d1bee95545b388179897cfca73291:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>
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-22.2 @ 2c1f4db5d31e18a718b974f992701dfee9a8cdd8:

        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | waiting for server to shut down...2022-10-11 05:18:56.044 UTC [49] LOG:  received fast shutdown request
        postgres_1    | .2022-10-11 05:18:56.046 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2022-10-11 05:18:56.048 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2022-10-11 05:18:56.050 UTC [51] LOG:  shutting down
        postgres_1    | 2022-10-11 05:18:56.173 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    | 2022-10-11 05:18:56.267 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    | 2022-10-11 05:18:56.267 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2022-10-11 05:18:56.267 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2022-10-11 05:18:56.271 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2022-10-11 05:18:56.277 UTC [68] LOG:  database system was shut down at 2022-10-11 05:18:56 UTC
        postgres_1    | 2022-10-11 05:18:56.282 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2022-10-11 05:18:58.272 UTC [78] ERROR:  syntax error at or near "ASC" at character 640
        postgres_1    | 2022-10-11 05:18:58.272 UTC [78] STATEMENT:  CREATE TABLE table4 (col4_0 REGTYPE, col4_1 CHAR NULL, col4_2 INT4 NULL, col4_3 BIT(48), col4_4 REGNAMESPACE NULL, col4_5 FLOAT4 NULL, col4_6 GEOGRAPHY NULL, col4_7 OID[] NOT NULL, col4_8 INT2 NOT NULL, col4_9 JSONB NULL, col4_10 REGPROCEDURE, col4_11 BIT(32) NOT NULL, col4_12 REGROLE NULL, col4_13 TIMETZ, col4_14 VARCHAR NOT NULL, col4_15 INT8 NULL GENERATED ALWAYS AS (col4_2 + col4_8) STORED, col4_16 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col4_9 AS TEXT))) STORED, col4_17 INT8 NULL GENERATED ALWAYS AS (col4_2 + col4_8) STORED, col4_18 INT8 NULL GENERATED ALWAYS AS (col4_2 + (-1171616901)::INT8) STORED, INVERTED INDEX (col4_17 ASC, col4_18 ASC, col4_1 gin_trgm_ops ASC) WHERE (((((table4.col4_1 != ''::TEXT) AND (table4.col4_2 < (-32768)::INT8)) OR (table4.col4_15 = 127::INT8)) AND (table4.col4_14 = e'\x00'::TEXT)) AND (table4.col4_5 >= '+Inf'::FLOAT8)) AND (table4.col4_13 < '00:00:00+15:59:00'::TIMETZ) NOT VISIBLE);
        postgres_1    | 	
        test_1        | --- FAIL: TestCompare (5.47s)
        test_1        |     compare_test.go:119: Checking connection to: cockroach2
        test_1        |     compare_test.go:119: Checking connection to: postgres
        test_1        |     compare_test.go:119: Checking connection to: cockroach1
        test_1        |     --- FAIL: TestCompare/postgres (1.11s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: postgres
        test_1        |         compare_test.go:159: CREATE TABLE table4 (col4_0 REGTYPE, col4_1 CHAR NULL, col4_2 INT4 NULL, col4_3 BIT(48), col4_4 REGNAMESPACE NULL, col4_5 FLOAT4 NULL, col4_6 GEOGRAPHY NULL, col4_7 OID[] NOT NULL, col4_8 INT2 NOT NULL, col4_9 JSONB NULL, col4_10 REGPROCEDURE, col4_11 BIT(32) NOT NULL, col4_12 REGROLE NULL, col4_13 TIMETZ, col4_14 VARCHAR NOT NULL, col4_15 INT8 NULL GENERATED ALWAYS AS (col4_2 + col4_8) STORED, col4_16 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col4_9 AS TEXT))) STORED, col4_17 INT8 NULL GENERATED ALWAYS AS (col4_2 + col4_8) STORED, col4_18 INT8 NULL GENERATED ALWAYS AS (col4_2 + (-1171616901)::INT8) STORED, INVERTED INDEX (col4_17 ASC, col4_18 ASC, col4_1 gin_trgm_ops ASC) WHERE (((((table4.col4_1 != ''::TEXT) AND (table4.col4_2 < (-32768)::INT8)) OR (table4.col4_15 = 127::INT8)) AND (table4.col4_14 = e'\x00'::TEXT)) AND (table4.col4_5 >= '+Inf'::FLOAT8)) AND (table4.col4_13 < '00:00:00+15:59:00'::TIMETZ) NOT VISIBLE);
        test_1        |             
        test_1        |         compare_test.go:160: postgres: exec: ERROR: syntax error at or near "ASC" (SQLSTATE 42601)
        test_1        |     --- FAIL: TestCompare/mutators (0.49s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table3 (col3_0 REGTYPE NULL, col3_1 INT4 NOT NULL, col3_2 INTERVAL, col3_3 INT4 NOT NULL, col3_4 DATE NOT NULL, col3_5 BIT(6) NOT NULL, col3_6 TIMESTAMP NOT NULL, col3_7 INTERVAL NOT NULL, col3_8 INT8 AS (col3_3 + col3_1) STORED, PRIMARY KEY (col3_1 DESC, col3_6 ASC, col3_3 DESC, col3_4 DESC, col3_7 ASC), UNIQUE (col3_1 ASC, col3_2 ASC, col3_0, col3_5 ASC, col3_7 DESC) WHERE (((table3.col3_3 != 127:::INT8) OR (table3.col3_4 > 'infinity':::DATE)) OR (table3.col3_1 >= 0:::INT8)) AND (table3.col3_8 >= 127:::INT8), UNIQUE (col3_1, (CASE WHEN col3_4 IS NULL THEN ' y':::STRING ELSE e'Vs\x19\\{\x15\\N\n':::STRING END) ASC, col3_7 DESC, col3_5 ASC) PARTITION BY LIST (col3_1) (PARTITION table3_part_0 VALUES IN ((228901861:::INT8,), (394628457:::INT8,), ((-72409718):::INT8,), (1068217303:::INT8,), ((-1861298291):::INT8,)), PARTITION table3_part_1 VALUES IN ((1797404859:::INT8,), (1397923259:::INT8,), ((-1113935170):::INT8,), ((-2025066467):::INT8,), (1260339682:::INT8,)), PARTITION table3_part_2 VALUES IN ((1131609437:::INT8,), (1:::INT8,), (1819305328:::INT8,), ((-1993322479):::INT8,), ((-1020467287):::INT8,)), PARTITION table3_part_3 VALUES IN (((-105379840):::INT8,), ((-570152063):::INT8,), ((-918129549):::INT8,), ((-1161604635):::INT8,), (1861719030:::INT8,)), PARTITION table3_part_4 VALUES IN (((-1119590053):::INT8,), (456106176:::INT8,), ((-1071461692):::INT8,), (1307079905:::INT8,), (2046735348:::INT8,)), PARTITION table3_part_5 VALUES IN (((-1):::INT8,), (405670099:::INT8,), (711928713:::INT8,), (1803056032:::INT8,), ((-1698324949):::INT8,)), PARTITION table3_part_6 VALUES IN ((1994848987:::INT8,), (1506357224:::INT8,), (729249892:::INT8,), ((-2147483648):::INT8,)), PARTITION table3_part_7 VALUES IN ((182702154:::INT8,), ((-248662664):::INT8,), (2080967648:::INT8,), ((-1815383943):::INT8,)), PARTITION table3_part_8 VALUES IN ((1479866738:::INT8,), ((-1565679364):::INT8,), (1878561370:::INT8,), ((-1494194513):::INT8,), (1870798104:::INT8,))), INDEX (col3_6 DESC, col3_1 ASC) WHERE (((table3.col3_8 >= 0:::INT8) AND (table3.col3_3 >= (-32768):::INT8)) AND (table3.col3_6 < '0001-01-01 00:00:00':::TIMESTAMP)) AND (table3.col3_4 < '5874897-12-31':::DATE), FAMILY (col3_3), FAMILY (col3_4, col3_5, col3_7, col3_1, col3_0, col3_2), FAMILY (col3_6), FAMILY (col3_8))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=1ac137c8-b645-4d47-9171-25d39a71dc2c for details on how to enable enterprise features (SQLSTATE XXC02)
        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:120: exit status 1
--- FAIL: TestComposeCompare (23.69s)
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-22.2 @ eb33c872e9f50c64bfd2426a011faca342bd3511:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>
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-22.2 @ 3531c6f4c69659c929170bef29ca05dafddae2b2:

        postgres_1    | 2022-10-14 05:17:29.407 UTC [51] LOG:  shutting down
        postgres_1    | 2022-10-14 05:17:29.518 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    | 2022-10-14 05:17:29.624 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    | 2022-10-14 05:17:29.624 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2022-10-14 05:17:29.624 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2022-10-14 05:17:29.627 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2022-10-14 05:17:29.631 UTC [68] LOG:  database system was shut down at 2022-10-14 05:17:29 UTC
        postgres_1    | 2022-10-14 05:17:29.636 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2022-10-14 05:17:30.925 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2022-10-14 05:17:30.925 UTC [78] STATEMENT:  CREATE TABLE table1 (col1_0 TIMESTAMP NULL, col1_1 "char" NOT NULL, col1_2 BOOL NOT NULL, col1_3 INT2 NOT NULL, col1_4 BOX2D NOT NULL, col1_5 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_0 IS NULL THEN e'\x00'::TEXT ELSE 'p'::TEXT END) STORED, col1_6 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_4 AS TEXT))) STORED, col1_7 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_4 AS TEXT))) STORED, col1_8 INT8 NOT NULL GENERATED ALWAYS AS (col1_3 + (-1)::INT8) STORED, PRIMARY KEY (col1_5, col1_3, col1_2, col1_7, col1_1, col1_6));
        postgres_1    | 	CREATE INDEX ON table1 (col1_3 DESC, col1_6, col1_1, col1_5 ASC);
        postgres_1    | 	CREATE UNIQUE INDEX ON table1 (col1_6 ASC, col1_7 ASC, col1_5, col1_1 ASC);
        postgres_1    | 	CREATE INDEX ON table1 (col1_0 DESC, col1_2 DESC, col1_7, col1_1 ASC);
        postgres_1    | 	
        test_1        | --- FAIL: TestCompare (4.09s)
        test_1        |     compare_test.go:119: Checking connection to: postgres
        test_1        |     compare_test.go:119: Checking connection to: cockroach1
        test_1        |     compare_test.go:119: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/mutators (0.12s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 REGTYPE NULL, col1_1 JSONB NULL, col1_2 INT8 NOT NULL, col1_3 TIMETZ NOT NULL, col1_4 INT8 NOT NULL, UNIQUE (col1_3 DESC) STORING (col1_2, col1_4), INDEX (col1_0 ASC) PARTITION BY LIST (col1_0) (PARTITION table1_part_0 VALUES IN ((512706284:::OID,), (NULL,), (520084139:::OID,), (3013346282:::OID,), (0:::OID,), (2337525113:::OID,), (2504201086:::OID,), (1665529896:::OID,))) WHERE ((table1.col1_4 > (-32768):::INT8) AND (table1.col1_3 >= '24:00:00-15:59:00':::TIMETZ)) AND (table1.col1_2 > (-9223372036854775807):::INT8), FAMILY (col1_0, col1_3), FAMILY (col1_1), FAMILY (col1_4), FAMILY (col1_2))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=4e3d63f5-4b50-417e-820f-379c0063ad2b for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        |     --- FAIL: TestCompare/postgres (0.84s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: postgres
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 TIMESTAMP NULL, col1_1 "char" NOT NULL, col1_2 BOOL NOT NULL, col1_3 INT2 NOT NULL, col1_4 BOX2D NOT NULL, col1_5 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_0 IS NULL THEN e'\x00'::TEXT ELSE 'p'::TEXT END) STORED, col1_6 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_4 AS TEXT))) STORED, col1_7 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_4 AS TEXT))) STORED, col1_8 INT8 NOT NULL GENERATED ALWAYS AS (col1_3 + (-1)::INT8) STORED, PRIMARY KEY (col1_5, col1_3, col1_2, col1_7, col1_1, col1_6));
        test_1        |             CREATE INDEX ON table1 (col1_3 DESC, col1_6, col1_1, col1_5 ASC);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_6 ASC, col1_7 ASC, col1_5, col1_1 ASC);
        test_1        |             CREATE INDEX ON table1 (col1_0 DESC, col1_2 DESC, col1_7, col1_1 ASC);
        test_1        |             
        test_1        |         compare_test.go:160: postgres: exec: ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:120: exit status 1
--- FAIL: TestComposeCompare (21.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-22.2 @ cffe9bc440988894abe9a598ea6b2f15e1b7df93:

        test_1        |             - 	nil,
        test_1        |             + 	string("010100000000000000008036400000000000E050C0"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			NULL::OID AS col_21654,
        test_1        |             			st_pointfromgeohash('H':::STRING::STRING::STRING, NULL::INT4::INT4)::GEOMETRY AS col_21655
        test_1        |             	)
        test_1        |             		AS tab_10378
        test_1        |             ORDER BY
        test_1        |             	col_21654 NULLS FIRST, col_21655 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			NULL::OID AS col_21654,
        test_1        |             			st_pointfromgeohash('H'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::GEOMETRY AS col_21655
        test_1        |             	)
        test_1        |             		AS tab_10378
        test_1        |             ORDER BY
        test_1        |             	col_21654 NULLS FIRST, col_21655 NULLS FIRST;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.59s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: cockroach2
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 BOOL NOT NULL, col1_1 DATE NOT NULL, col1_2 FLOAT8 NOT NULL, col1_3 INT4 NOT NULL, col1_4 INT8 NOT NULL, col1_5 TIMESTAMP NOT NULL, col1_6 BIT(16) NOT NULL, col1_7 BIT(16) NOT NULL, col1_8 UUID NOT NULL, col1_9 INT8 NOT NULL AS (col1_4 + col1_3) STORED, col1_10 INT8 NOT NULL AS (col1_4 + col1_3) VIRTUAL, PRIMARY KEY (col1_6 DESC, col1_4 DESC, col1_1, col1_5 DESC, col1_8 ASC, col1_9 DESC), INDEX (col1_8, col1_9, col1_0 ASC, col1_2 DESC, col1_3 DESC, col1_6 DESC, col1_1 DESC, col1_5) WHERE (((((((NOT table1.col1_0) OR (table1.col1_9 <= (-1):::INT8)) AND (table1.col1_10 != 32767:::INT8)) OR (table1.col1_1 <= '1970-01-01':::DATE)) OR (table1.col1_4 >= 0:::INT8)) AND (table1.col1_5 = '-2000-01-01 00:00:00':::TIMESTAMP)) AND (table1.col1_2 >= 5e-324:::FLOAT8)) OR (table1.col1_3 = 32767:::INT8), INDEX (col1_6 DESC, col1_3 ASC, col1_1 DESC, col1_10 DESC, (col1_4 + col1_3) ASC, col1_2 DESC) WHERE (((((((table1.col1_5 != '-2000-01-01 00:00:00':::TIMESTAMP) OR (table1.col1_1 = '-infinity':::DATE)) OR (table1.col1_2 != 1.0:::FLOAT8)) OR (table1.col1_9 < 1:::INT8)) AND (table1.col1_4 < (-128):::INT8)) OR table1.col1_0) OR (table1.col1_10 <= (-2147483648):::INT8)) OR (table1.col1_3 <= 0:::INT8), UNIQUE (col1_6 DESC, col1_5, col1_8 ASC, col1_3 DESC, col1_7 DESC, col1_1 DESC, col1_9 DESC, col1_2 DESC, col1_0 ASC) WHERE (((((((table1.col1_2 != '-Inf':::FLOAT8) AND (table1.col1_4 >= 9223372036854775807:::INT8)) AND (table1.col1_9 >= (-1):::INT8)) OR (table1.col1_1 > '1970-01-01':::DATE)) OR (table1.col1_3 >= 127:::INT8)) AND (table1.col1_5 < '-4713-11-24 00:00:00':::TIMESTAMP)) AND (NOT table1.col1_0)) OR (table1.col1_10 >= (-9223372036854775807):::INT8), INDEX (col1_5, col1_1, col1_8 ASC, col1_9, col1_3 DESC, col1_10 DESC, col1_0) STORING (col1_7), INDEX (col1_10, col1_3, col1_7 DESC, col1_9 ASC), UNIQUE (col1_1 ASC, col1_2 ASC, col1_9, col1_7 DESC, (col1_3 + col1_4) ASC, col1_8 ASC, col1_0 DESC), FAMILY (col1_9, col1_2, col1_1, col1_7, col1_6), FAMILY (col1_4, col1_0), FAMILY (col1_3, col1_8), FAMILY (col1_5));
        test_1        |             ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 4, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6515, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 9000}, {"avg_size": 23, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3724, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 9000}, {"avg_size": 9, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2959, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 9000}, {"avg_size": 27, "columns": ["col1_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3396, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 9000}, {"avg_size": 10, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5154, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 9000}, {"avg_size": 19, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6618, "histo_buckets": [{"distinct_range": 0, "num_eq": 6526979798641905520, "num_range": 0, "upper_bound": "0001-01-01 00:00:00"}, {"distinct_range": 5000, "num_eq": 2142581268927621798, "num_range": 5000, "upper_bound": "1970-08-13 15:10:38.000958"}, {"distinct_range": 0, "num_eq": 2673827853758663811, "num_range": 61078550975939077, "upper_bound": "1988-08-03 17:02:19.000057"}, {"distinct_range": 1054179200073289500, "num_eq": 5737132359557275836, "num_range": 4671529547404082988, "upper_bound": "2000-04-24 23:14:09.000087"}, {"distinct_range": 4501442539835306000, "num_eq": 4320528997904375062, "num_range": 5821318696607734627, "upper_bound": "2016-08-29 01:53:59.00052"}, {"distinct_range": 0, "num_eq": 10000000, "num_range": 9000000000, "upper_bound": "2032-03-21 03:40:01.000796"}, {"distinct_range": 500000, "num_eq": 4284614649266924960, "num_range": 500000, "upper_bound": "2032-10-26 13:11:42.000318"}, {"distinct_range": 0, "num_eq": 8000000000, "num_range": 60, "upper_bound": "294276-12-31 23:59:59.999999"}], "histo_col_type": "TIMESTAMP", "name": "__auto__", "null_count": 0, "row_count": 9000}, {"avg_size": 28, "columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 8462, "histo_buckets": [{"distinct_range": 0, "num_eq": 7247157834847057776, "num_range": 0, "upper_bound": "0001100110000101"}, {"distinct_range": 58880530038.06025, "num_eq": 30000000000, "num_range": 60000000000, "upper_bound": "0100100110001000"}, {"distinct_range": 0, "num_eq": 50000000, "num_range": 5106246384817149586, "upper_bound": "0100110100101000"}, {"distinct_range": 0, "num_eq": 5123547183074417643, "num_range": 0, "upper_bound": "0101100110111110"}, {"distinct_range": 0, "num_eq": 1889401258787919311, "num_range": 1758385919766171711, "upper_bound": "1001100000000100"}, {"distinct_range": 1007459568355284700, "num_eq": 80000, "num_range": 1571600667088172543, "upper_bound": "1100010010010101"}, {"distinct_range": 944880499809415000, "num_eq": 6071541624538681181, "num_range": 1218841196820503226, "upper_bound": "1110010000100010"}], "histo_col_type": "BIT(16)", "name": "__auto__", "null_count": 0, "row_count": 9000}, {"avg_size": 9, "columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 395, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 9000}, {"avg_size": 25, "columns": ["col1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2736, "histo_buckets": [{"distinct_range": 0, "num_eq": 90000000, "num_range": 0, "upper_bound": "00000000-0000-0000-0000-000000000000"}, {"distinct_range": 0, "num_eq": 4589221756496748658, "num_range": 8000000000, "upper_bound": "24faca2e-84eb-47a8-8416-913029027f8c"}, {"distinct_range": 0, "num_eq": 20000000, "num_range": 60000000000, "upper_bound": "2710fc25-fe10-43b6-b2eb-0a15be6d6e3b"}, {"distinct_range": 4321463929.562959, "num_eq": 100, "num_range": 8000000000, "upper_bound": "3e645ddc-5e61-45d3-aaf2-b87bf8f7bf1c"}, {"distinct_range": 9182588249689269000, "num_eq": 5000000, "num_range": 9182588249689269298, "upper_bound": "73659710-3990-44c5-a769-6a6312fc73ac"}, {"distinct_range": 0, "num_eq": 400000, "num_range": 2000000000, "upper_bound": "7f31ab92-78a2-4d16-8b89-f2ab59aa6b20"}, {"distinct_range": 9000000000, "num_eq": 2422125659900896943, "num_range": 9000000000, "upper_bound": "dd70acb0-49ed-4901-8cb4-a042bad9350c"}, {"distinct_range": 300, "num_eq": 30000000000, "num_range": 300, "upper_bound": "e2c3d606-a21d-409b-a058-53f85dcc97fc"}], "histo_col_type": "UUID", "name": "__auto__", "null_count": 0, "row_count": 9000}, {"avg_size": 4, "columns": ["col1_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 8560, "histo_buckets": [{"distinct_range": 0, "num_eq": 200000, "num_range": 0, "upper_bound": "-8860582553491704218"}, {"distinct_range": 6788518105027737000, "num_eq": 800, "num_range": 6788518105027736964, "upper_bound": "-7162915391986989024"}, {"distinct_range": 0, "num_eq": 7707030026462856028, "num_range": 8062647239034071204, "upper_bound": "-5236415331115819627"}, {"distinct_range": 0, "num_eq": 6988569403092815101, "num_range": 90, "upper_bound": "-5047821030580213091"}, {"distinct_range": 0, "num_eq": 90000000, "num_range": 5717867976416065844, "upper_bound": "-4094352518439600396"}, {"distinct_range": 882373336878953700, "num_eq": 7412466237876157614, "num_range": 2008426419420283449, "upper_bound": "8540391441128232251"}, {"distinct_range": 1752943915439920400, "num_eq": 30, "num_range": 8493638204345284001, "upper_bound": "9170475394561980619"}], "histo_col_type": "INT8", "name": "__auto__", "null_count": 0, "row_count": 9000}, {"avg_size": 20, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3000, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 9000}]':::JSONB;
        test_1        |             ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 9, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 922697021338953524, "histo_buckets": [{"distinct_range": 0, "num_eq": 216940211498386604, "num_range": 0, "upper_bound": "1971-11-16"}, {"distinct_range": 0, "num_eq": 0, "num_range": 7867393828310073018, "upper_bound": "1976-01-06"}, {"distinct_range": 0, "num_eq": 5000, "num_range": 0, "upper_bound": "1982-12-02"}, {"distinct_range": 0, "num_eq": 80000000000, "num_range": 0, "upper_bound": "1985-10-29"}, {"distinct_range": 0, "num_eq": 0, "num_range": 3581129448859809603, "upper_bound": "1986-06-28"}, {"distinct_range": 4000000000, "num_eq": 0, "num_range": 4000000000, "upper_bound": "1986-10-31"}, {"distinct_range": 415.23074646489425, "num_eq": 8000000, "num_range": 700, "upper_bound": "1992-10-23"}, {"distinct_range": 583706863904216800, "num_eq": 300000, "num_range": 583706863904216827, "upper_bound": "1993-05-27"}, {"distinct_range": 0, "num_eq": 7000000000, "num_range": 0, "upper_bound": "1993-06-29"}], "histo_col_type": "DATE", "name": "__auto__", "null_count": 0, "row_count": 2975702892473938211}, {"avg_size": 30, "columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1806397630290808592, "histo_buckets": [{"distinct_range": 0, "num_eq": 6698957115586154237, "num_range": 0, "upper_bound": "0000000000000000"}, {"distinct_range": 5000, "num_eq": 6910025715654087082, "num_range": 5000, "upper_bound": "0011011110111010"}, {"distinct_range": 0, "num_eq": 1000000000, "num_range": 20000, "upper_bound": "0011101001011011"}, {"distinct_range": 3000000, "num_eq": 2000, "num_range": 3000000, "upper_bound": "0110010011010001"}, {"distinct_range": 416841330.6590088, "num_eq": 0, "num_range": 4000000000, "upper_bound": "0111001100010100"}, {"distinct_range": 2855121415.5005984, "num_eq": 10000000, "num_range": 10000000000, "upper_bound": "0111010110101101"}, {"distinct_range": 0, "num_eq": 388978416049083247, "num_range": 4266146066923788488, "upper_bound": "0111111111111111"}, {"distinct_range": 5715715188215507000, "num_eq": 900, "num_range": 5715715188215507322, "upper_bound": "1000101110101011"}, {"distinct_range": 0, "num_eq": 900, "num_range": 4389856381177921979, "upper_bound": "1110001100000101"}], "histo_col_type": "BIT(16)", "name": "__auto__", "null_count": 0, "row_count": 2975702892473938211}, {"avg_size": 4, "columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1095554403123457831, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 2975702892473938211}, {"avg_size": 25, "columns": ["col1_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2342259291722710490, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 2975702892473938211}, {"avg_size": 27, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 611546556458039152, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 2975702892473938211}, {"avg_size": 27, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1129991356989626797, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 2975702892473938211}, {"avg_size": 0, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2392778856648202905, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 2975702892473938211}, {"avg_size": 19, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2064174066394457492, "histo_buckets": [{"distinct_range": 0, "num_eq": 700000000, "num_range": 0, "upper_bound": "-4713-11-24 00:00:00"}, {"distinct_range": 43127809082487544, "num_eq": 1789022591580927095, "num_range": 43127809082487547, "upper_bound": "1983-04-25 13:49:13.000737"}, {"distinct_range": 0, "num_eq": 10000, "num_range": 7649141735404944517, "upper_bound": "1985-02-21 04:09:52.000217"}], "histo_col_type": "TIMESTAMP", "name": "__auto__", "null_count": 0, "row_count": 2975702892473938211}, {"avg_size": 9, "columns": ["col1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 146930694950986622, "histo_buckets": [{"distinct_range": 0, "num_eq": 800, "num_range": 0, "upper_bound": "55bfa032-ae54-4eb1-9b6f-52b462f3fce5"}, {"distinct_range": 177348660738089500, "num_eq": 10000, "num_range": 647081723313190896, "upper_bound": "69065e92-56ab-42ac-8bd3-b61b173e9ac0"}, {"distinct_range": 1951254297368208100, "num_eq": 800, "num_range": 8522255280181398125, "upper_bound": "a65550c0-e283-43d8-83c3-b37cc2efb837"}, {"distinct_range": 6946793765455232000, "num_eq": 1392866255618266429, "num_range": 8511549951131652019, "upper_bound": "bfcc1063-3863-4e20-a91e-8f53ea855283"}, {"distinct_range": 8957501774947763000, "num_eq": 3000000, "num_range": 8957501774947762904, "upper_bound": "de0896e6-4884-46d6-8075-e0afebf92b5c"}, {"distinct_range": 0, "num_eq": 2833627151101048364, "num_range": 20000000, "upper_bound": "ffffffff-ffff-ffff-ffff-ffffffffffff"}], "histo_col_type": "UUID", "name": "__auto__", "null_count": 0, "row_count": 2975702892473938211}, {"avg_size": 27, "columns": ["col1_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2195736910320129989, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 2975702892473938211}, {"avg_size": 11, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 964163239071818265, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 2975702892473938211}]':::JSONB;
        test_1        |             
        test_1        |         compare_test.go:160: cockroach2: exec: ERROR: cannot inject statistics in an explicit transaction (SQLSTATE XXUUU)
        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:120: exit status 1
--- FAIL: TestComposeCompare (43.60s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-22.2 @ cffe9bc440988894abe9a598ea6b2f15e1b7df93:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>
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-22.2 @ 5bbbb4fefe2cca87aa8dd34c007702bb2faa20ef:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>
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-22.2 @ a3ac132c4210f3f1202adedb344df222726e8e1b:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>
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-22.2 @ 51fb4393c8aee99c366ce3b87de3b9eded8642d3:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>
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-22.2 @ ed1d8f5fc1ca192c32760db860656d1c9133135e:

        test_1        |         compare_test.go:137: initializing connection: postgres
        test_1        |         compare_test.go:188: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare4138060356/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:190: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             - 	string("2000-01-01 09:00:02+00:00G"),
        test_1        |             + 	string("2000-01-01 09:00:02+00G"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			(('2000-01-01 09:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ::TIMESTAMPTZ + '00:00:02':::INTERVAL::INTERVAL::INTERVAL)::TIMESTAMPTZ::TIMESTAMPTZ || 'G':::STRING::STRING::STRING)::STRING
        test_1        |             				AS col_39918
        test_1        |             	)
        test_1        |             		AS tab_27971
        test_1        |             ORDER BY
        test_1        |             	col_39918 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 09:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ::TIMESTAMPTZ + '00:00:02'::INTERVAL::INTERVAL::INTERVAL)::TIMESTAMPTZ::TIMESTAMPTZ || 'G'::TEXT::TEXT::TEXT)::TEXT
        test_1        |             				AS col_39918
        test_1        |             	)
        test_1        |             		AS tab_27971
        test_1        |             ORDER BY
        test_1        |             	col_39918 NULLS FIRST;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.17s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:159: CREATE TABLE table2 (col2_0 TIMESTAMPTZ NOT NULL, col2_1 FLOAT8 NOT NULL, col2_2 DATE NOT NULL, col2_3 STRING NOT NULL AS (CASE WHEN col2_0 IS NULL THEN e'``\x03Hhgq':::STRING ELSE e'\x13Yn2':::STRING END) STORED, PRIMARY KEY (col2_1, col2_0 DESC, col2_3), INDEX (col2_1) WHERE (table2.col2_0 != '-4713-11-24 00:00:00+00:00':::TIMESTAMPTZ) AND (table2.col2_3 <= '':::STRING), INDEX (col2_0 DESC, col2_2 ASC, col2_3 DESC, col2_1) WHERE (table2.col2_3 >= '"':::STRING) OR (table2.col2_2 != '-infinity':::DATE), INDEX (col2_1 ASC, col2_0, col2_3 ASC, col2_2), UNIQUE (col2_1, col2_0, col2_3 ASC) STORING (col2_2) PARTITION BY LIST (col2_1) (PARTITION table2_part_0 VALUES IN ((0.5340552071278184:::FLOAT8,), (1.5782647963710987:::FLOAT8,), ((-1.2782935505240833):::FLOAT8,), (0.3477066544897811:::FLOAT8,), (0.056196785489971646:::FLOAT8,), (0.21114467480673937:::FLOAT8,), ((-1.3252754655425143):::FLOAT8,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))))
        test_1        |         compare_test.go:160: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=789b6a8c-6053-4165-a18c-c681e2e88872 for details on how to enable enterprise features (SQLSTATE XXC02)
        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:120: exit status 1
--- FAIL: TestComposeCompare (62.98s)
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-22.2 @ 8579361117ff18a4255855a43114ddeb3e3b80c9:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>
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-22.2 @ fc582bd2d43c1dc141077f2fae6da0ca9c23e449:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>
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-22.2 @ c0e9c25661d53e893210a7bfe79257f1c9468f52:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>
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-22.2 @ 794fcfa793016e98a6ebadaaa29444e4661592ba:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>
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-22.2 @ 6df4e8666ccb902b333195bdded59d69307b6050:

        postgres_1    | waiting for server to shut down....2022-10-25 05:17:12.913 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2022-10-25 05:17:12.915 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2022-10-25 05:17:12.917 UTC [51] LOG:  shutting down
        postgres_1    | 2022-10-25 05:17:13.030 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    | 2022-10-25 05:17:13.133 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    | 2022-10-25 05:17:13.133 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2022-10-25 05:17:13.133 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2022-10-25 05:17:13.136 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2022-10-25 05:17:13.141 UTC [68] LOG:  database system was shut down at 2022-10-25 05:17:13 UTC
        postgres_1    | 2022-10-25 05:17:13.146 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2022-10-25 05:17:14.254 UTC [78] ERROR:  syntax error at or near "VISIBLE" at character 145
        postgres_1    | 2022-10-25 05:17:14.254 UTC [78] STATEMENT:  CREATE TABLE table2 (col2_0 OID NOT NULL, col2_1 JSONB NOT NULL, PRIMARY KEY (col2_0), INVERTED INDEX (lower(CAST(col2_1 AS TEXT)), col2_1) NOT VISIBLE);
        postgres_1    | 	
        test_1        | --- FAIL: TestCompare (4.49s)
        test_1        |     compare_test.go:119: Checking connection to: postgres
        test_1        |     compare_test.go:119: Checking connection to: cockroach1
        test_1        |     compare_test.go:119: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.84s)
        test_1        |         compare_test.go:128: starting test: postgres
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: postgres
        test_1        |         compare_test.go:159: CREATE TABLE table2 (col2_0 OID NOT NULL, col2_1 JSONB NOT NULL, PRIMARY KEY (col2_0), INVERTED INDEX (lower(CAST(col2_1 AS TEXT)), col2_1) NOT VISIBLE);
        test_1        |             
        test_1        |         compare_test.go:160: postgres: exec: ERROR: syntax error at or near "VISIBLE" (SQLSTATE 42601)
        test_1        |     --- FAIL: TestCompare/mutators (0.52s)
        test_1        |         compare_test.go:128: starting test: mutators
        test_1        |         compare_test.go:137: initializing connection: cockroach1
        test_1        |         compare_test.go:137: initializing connection: cockroach2
        test_1        |         compare_test.go:159: CREATE TABLE table1 (col1_0 OID NULL, col1_1 GEOGRAPHY NOT NULL, col1_2 STRING NULL AS (lower(CAST(col1_0 AS STRING))) VIRTUAL, INDEX (col1_2) STORING (col1_0, col1_1) WHERE table1.col1_2 > e'\'':::STRING, INDEX (col1_0 ASC) STORING (col1_1) WHERE table1.col1_2 = e'\'':::STRING, INVERTED INDEX (col1_1 ASC) WHERE table1.col1_2 < '':::STRING, FAMILY (col1_1), FAMILY (col1_0));
        test_1        |             ALTER TABLE table1 INJECT STATISTICS e'[{"avg_size": 18, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4988845710618718282, "histo_buckets": [{"distinct_range": 0, "num_eq": 6323216086254980243, "num_range": 0, "upper_bound": "283791798"}, {"distinct_range": 8826521610984692000, "num_eq": 9015456475183048, "num_range": 8826521610984691613, "upper_bound": "783359207"}, {"distinct_range": 0, "num_eq": 0, "num_range": 70000000, "upper_bound": "1563348159"}, {"distinct_range": 2712645461437736000, "num_eq": 7014891989519267479, "num_range": 2712645461437735884, "upper_bound": "2298119625"}], "histo_col_type": "OID", "name": "__auto__", "null_count": 650390077002372997, "row_count": 6323467509464423895}, {"avg_size": 9, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3933296219712835578, "histo_buckets": [{"distinct_range": 0, "num_eq": 8849500671360230410, "num_range": 0, "upper_bound": "\\\\x42fd100000000000000000c00921fb54442d18bff690330c120119400921fb54442d183ff8013c43bf7f95"}, {"distinct_range": 54538.8068025259, "num_eq": 5008607845494295320, "num_range": 80000, "upper_bound": "\\\\x42fd100000000000000000c00921fb54442d18bff82bdbf75c5391400921fb54442d183ff8affa2cc29b63"}, {"distinct_range": 0, "num_eq": 40000000, "num_range": 8787737604427311067, "upper_bound": "\\\\x42fd100000000000000000c00921fb54442d18bff8e68636ca8436400921fb54442d183ff868b485f71868"}, {"distinct_range": 0, "num_eq": 4924918620100461382, "num_range": 7474911418037544753, "upper_bound": "\\\\x42fd1400000000000000003fc657184ae744863fb657184ae744673fe921fb54442d173fe921fb54442d1c"}, {"distinct_range": 0, "num_eq": 3325971150317058308, "num_range": 1000000, "upper_bound": "\\\\x42fd300000000000000000c00921fb54442d18bff690330c120119400921fb54442d183ff8013c43bf7f95"}, {"distinct_range": 0, "num_eq": 50000, "num_range": 8561987969691865303, "upper_bound": "\\\\x42fd300000000000000000c00921fb54442d18bff82bdbf75c5391400921fb54442d183ff8affa2cc29b63"}, {"distinct_range": 3000, "num_eq": 20000, "num_range": 3000, "upper_bound": "\\\\x42fd300000000000000000c00921fb54442d18bff8e68636ca8436400921fb54442d183ff868b485f71868"}, {"distinct_range": 837977488518166800, "num_eq": 8846804201779208577, "num_range": 6231157474445745699, "upper_bound": "\\\\x42fd3e1e01d89df61d7d003fc657184ae744863fb657184ae744673fe921fb54442d173fe921fb54442d1c"}, {"distinct_range": 2734647876877665300, "num_eq": 2978034010669476033, "num_range": 3517155603500864498, "upper_bound": "\\\\x42fd3fdf7df8a77df80b003fc657184ae744863fb657184ae744673fe921fb54442d173fe921fb54442d1c"}, {"distinct_range": 40000000000, "num_eq": 2000000, "num_range": 40000000000, "upper_bound": "\\\\x42fd4100000000000000003fc657184ae744863fb657184ae744673fe921fb54442d173fe921fb54442d1c"}, {"distinct_range": 4646571532557645000, "num_eq": 8208226712539507027, "num_range": 4646571532557644316, "upper_bound": "\\\\x42fd4750000000000000003fc657184ae744863fb657184ae744673fe921fb54442d173fe921fb54442d1c"}, {"distinct_range": 10, "num_eq": 3687050114285806533, "num_range": 10, "upper_bound": "\\\\x42fd500000000000000000c00921fb54442d18bff690330c120119400921fb54442d183ff8013c43bf7f95"}, {"distinct_range": 0, "num_eq": 60000000000, "num_range": 3922551905604763222, "upper_bound": "\\\\x42fd500000000000000000c00921fb54442d18bff82bdbf75c5391400921fb54442d183ff8affa2cc29b63"}, {"distinct_range": 90000, "num_eq": 7160384133515859263, "num_range": 90000, "upper_bound": "\\\\x42fd500000000000000000c00921fb54442d18bff8e68636ca8436400921fb54442d183ff868b485f71868"}, {"distinct_range": 0, "num_eq": 3698147823358829022, "num_range": 0, "upper_bound": "\\\\x42fd5cb539d45ea831a9013ff9364df8611d633ff13e732d75cadc"}, {"distinct_range": 358035306.2242157, "num_eq": 30000, "num_range": 1000000000, "upper_bound": "\\\\x42fd6ac162af3a215455004003bc244b1327d2bff2d70478ced66bbfefcf88bc3e13f9bfe2fb4bcea426c7"}, {"distinct_range": 0, "num_eq": 184542042993338790, "num_range": 2660801293909043269, "upper_bound": "\\\\x42fd700000000000000000c00921fb54442d18bff82bdbf75c5391400921fb54442d183ff8affa2cc29b63"}, {"distinct_range": 0, "num_eq": 10, "num_range": 40000000000, "upper_bound": "\\\\x42fd700000000000000000c00921fb54442d18bff8e68636ca8436400921fb54442d183ff868b485f71868"}, {"distinct_range": 80000000, "num_eq": 1000000, "num_range": 80000000, "upper_bound": "\\\\x42fd742bacf8db4f480901c0046e823cacc01cbfd626ac80ba366e"}, {"distinct_range": 696135429847369500, "num_eq": 1564264588782006341, "num_range": 696135429847369527, "upper_bound": "\\\\x42fd900000000000000000c00921fb54442d18bff690330c120119400921fb54442d183ff8013c43bf7f95"}, {"distinct_range": 0, "num_eq": 30000, "num_range": 0, "upper_bound": "\\\\x42fd900000000000000000c00921fb54442d18bff82bdbf75c5391400921fb54442d183ff8affa2cc29b63"}, {"distinct_range": 460938502.0714532, "num_eq": 300000, "num_range": 800000000, "upper_bound": "\\\\x42fd900000000000000000c00921fb54442d18bff8e68636ca8436400921fb54442d183ff868b485f71868"}, {"distinct_range": 2728142591176579600, "num_eq": 1101038296082656914, "num_range": 2728142591176579804, "upper_bound": "\\\\x42fdb00000000000000000c00921fb54442d18bff690330c120119400921fb54442d183ff8013c43bf7f95"}, {"distinct_range": 612861658272551800, "num_eq": 8298270378442741565, "num_range": 1069465499098346405, "upper_bound": "\\\\x42fdb00000000000000000c00921fb54442d18bff82bdbf75c5391400921fb54442d183ff8affa2cc29b63"}, {"distinct_range": 1024772266805432400, "num_eq": 7763015403076429364, "num_range": 2174643466185075957, "upper_bound": "\\\\x42fdb00000000000000000c00921fb54442d18bff8e68636ca8436400921fb54442d183ff868b485f71868"}, {"distinct_range": 3223983667666109000, "num_eq": 8000000, "num_range": 3223983667666108936, "upper_bound": "\\\\x42fdbb9b1f7acda44431004003bc244b1327d2bff2d70478ced66bbfefcf88bc3e13f9bfe2fb4bcea426c7"}, {"distinct_range": 0, "num_eq": 1032838502609082390, "num_range": 341464074370535972, "upper_bound": "\\\\x42fdbc24b9ab3d05e8db004003bc244b1327d2bff2d70478ced66bbfefcf88bc3e13f9bfe2fb4bcea426c7"}], "histo_col_type": "BYTES", "name": "__auto__", "null_count": 0, "row_count": 6323467509464423895}, {"avg_size": 26, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3738316792384584980, "histo_buckets": [{"distinct_range": 0, "num_eq": 20000000, "num_range": 0, "upper_bound": "l\\u001c"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 1321266452801195430, "row_count": 6323467509464423895}]':::JSONB;
        test_1        |             ALTER TABLE table1 INJECT STATISTICS e'[{"avg_size": 7, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 176117081, "histo_buckets": [{"distinct_range": 0, "num_eq": 80000000, "num_range": 0, "upper_bound": "1009724162"}, {"distinct_range": 3817654373962441700, "num_eq": 6522689465801476082, "num_range": 5119035495235207410, "upper_bound": "3033164357"}], "histo_col_type": "OID", "name": "__auto__", "null_count": 179839848, "row_count": 200000000}, {"avg_size": 28, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 56703003, "histo_buckets": [{"distinct_range": 0, "num_eq": 300, "num_range": 0, "upper_bound": "\\\\x42fd0555555555555555000000000000000000bcc8359da74dbfe43f91df46a2529d393f91df7339a0de24"}, {"distinct_range": 5000000000, "num_eq": 2293836147172498154, "num_range": 5000000000, "upper_bound": "\\\\x42fd0fff000000000000000000000000000000bcc8359da74dbfe43f91df46a2529d393f91df7339a0de24"}, {"distinct_range": 0, "num_eq": 1000, "num_range": 8162611689774976435, "upper_bound": "\\\\x42fd100000000000000000bfeed436c860206ebff329ec5195c0b4400532414a6c28083ff45d324dca41a3"}, {"distinct_range": 0, "num_eq": 3388028763889402532, "num_range": 0, "upper_bound": "\\\\x42fd100000000000000000c0054efe1939a036bff8ef5069117d653ff4a31d8e019e643ff53f17d05e8053"}, {"distinct_range": 783335307294400900, "num_eq": 6914580523649987055, "num_range": 825085711369315347, "upper_bound": "\\\\x42fd100000000000000000c00921fb54442d18bff91d57e2e5ed40400921fb54442d183ff8d10d3badeca9"}, {"distinct_range": 431592.8067258296, "num_eq": 2968479095616535221, "num_range": 700000, "upper_bound": "\\\\x42fd1001000000000000000000000000000000bcc8359da74dbfe43f91df46a2529d393f91df7339a0de24"}, {"distinct_range": 617947658306373000, "num_eq": 10000000000, "num_range": 7182400615700065913, "upper_bound": "\\\\x42fd1aab000000000000000000000000000000bcc8359da74dbfe43f91df46a2529d393f91df7339a0de24"}, {"distinct_range": 0, "num_eq": 20000, "num_range": 200, "upper_bound": "\\\\x42fd300000000000000000bfeed436c860206ebff329ec5195c0b4400532414a6c28083ff45d324dca41a3"}, {"distinct_range": 0, "num_eq": 600000000, "num_range": 90, "upper_bound": "\\\\x42fd300000000000000000c00921fb54442d18bff91d57e2e5ed40400921fb54442d183ff8d10d3badeca9"}, {"distinct_range": 0, "num_eq": 0, "num_range": 0, "upper_bound": "\\\\x42fd4c0000000000000000bfeed436c860206ebff329ec5195c0b4400532414a6c28083ff45d324dca41a3"}, {"distinct_range": 146043599746322050, "num_eq": 80000000, "num_range": 785470435894219203, "upper_bound": "\\\\x42fd500000000000000000c0054efe1939a036bff8ef5069117d653ff4a31d8e019e643ff53f17d05e8053"}, {"distinct_range": 3486438368468645000, "num_eq": 100000000, "num_range": 3486438368468644769, "upper_bound": "\\\\x42fd500000000000000000c00921fb54442d18bff91d57e2e5ed40400921fb54442d183ff8d10d3badeca9"}, {"distinct_range": 0, "num_eq": 90, "num_range": 3659972917628145281, "upper_bound": "\\\\x42fd700000000000000000c0054efe1939a036bff8ef5069117d653ff4a31d8e019e643ff53f17d05e8053"}, {"distinct_range": 0, "num_eq": 3838367349695233089, "num_range": 7136157729173640067, "upper_bound": "\\\\x42fd700000000000000000c00921fb54442d18bff91d57e2e5ed40400921fb54442d183ff8d10d3badeca9"}, {"distinct_range": 9000000000, "num_eq": 5000000, "num_range": 9000000000, "upper_bound": "\\\\x42fd900000000000000000c0054efe1939a036bff8ef5069117d653ff4a31d8e019e643ff53f17d05e8053"}, {"distinct_range": 0, "num_eq": 700000, "num_range": 630282566744123545, "upper_bound": "\\\\x42fd900000000000000000c00921fb54442d18bff91d57e2e5ed40400921fb54442d183ff8d10d3badeca9"}, {"distinct_range": 0, "num_eq": 1421670174522599767, "num_range": 8000000, "upper_bound": "\\\\x42fdac0000000000000000bfeed436c860206ebff329ec5195c0b4400532414a6c28083ff45d324dca41a3"}, {"distinct_range": 22128061.97900788, "num_eq": 2836330319224767104, "num_range": 40000000, "upper_bound": "\\\\x42fdb00000000000000000c0054efe1939a036bff8ef5069117d653ff4a31d8e019e643ff53f17d05e8053"}, {"distinct_range": 4836733775326835000, "num_eq": 381040478051094250, "num_range": 5677404118611210604, "upper_bound": "\\\\x42fdb00000000000000000c00921fb54442d18bff91d57e2e5ed40400921fb54442d183ff8d10d3badeca9"}], "histo_col_type": "BYTES", "name": "__auto__", "null_count": 0, "row_count": 200000000}, {"avg_size": 31, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 148143733, "histo_buckets": [{"distinct_range": 0, "num_eq": 7000, "num_range": 0, "upper_bound": "\\u0003Xy"}, {"distinct_range": 5506458923224524000, "num_eq": 80, "num_range": 5506458923224523967, "upper_bound": "\\rSf(F"}, {"distinct_range": 404053961.9838877, "num_eq": 4256139894194539100, "num_range": 500000000, "upper_bound": "\\u000ft\\\\bZb\\u0007A("}, {"distinct_range": 6563040369055718000, "num_eq": 4716354359418553919, "num_range": 7267846107055410857, "upper_bound": "4\\u0006"}, {"distinct_range": 1989645559981065000, "num_eq": 100000000, "num_range": 1989645559981064848, "upper_bound": "8K\\u0018)]Dw"}, {"distinct_range": 197105.3113096628, "num_eq": 7630197031983079319, "num_range": 500000, "upper_bound": "9U\\"{DH"}, {"distinct_range": 82621.42363346164, "num_eq": 5755556028042344899, "num_range": 90000, "upper_bound": "K\\u0014)<\\u0003f"}, {"distinct_range": 8000, "num_eq": 3225568172458834379, "num_range": 8000, "upper_bound": "V\\u0016EG"}, {"distinct_range": 375742766184227140, "num_eq": 2000000000, "num_range": 2606285293837591245, "upper_bound": "q-H"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 175400968, "row_count": 200000000}]':::JSONB;
        test_1        |             
        test_1        |         compare_test.go:160: cockroach2: exec: ERROR: cannot inject statistics in an explicit transaction (SQLSTATE XXUUU)
        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:120: exit status 1
--- FAIL: TestComposeCompare (21.71s)
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-22.2 @ 890b681dd5bb2c5ebabb06d89aed131af0b50fe8:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>
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-22.2 @ 4816df3a9d76d179ed135a2b1efb53babb5611a0:

Slow failing tests:
TestComposeCompare - 295.00s

Slow passing tests:
<none>
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 Feb 2, 2024
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-22.2 @ 3e2fa482345754749d3a51a612f7a482699ca1b3:

        test_1        |             - 	nil,
        test_1        |             + 	s"4",
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_73132.col_122654 AS col_122655
        test_1        |             		FROM
        test_1        |             			(VALUES (NULL::INT8), (4:::INT8::INT8), (NULL::INT8), (5:::INT8::INT8), (8:::INT8::INT8))
        test_1        |             				AS tab_73132 (col_122654)
        test_1        |             	)
        test_1        |             		AS tab_73133
        test_1        |             ORDER BY
        test_1        |             	col_122655;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_73132.col_122654 AS col_122655
        test_1        |             		FROM
        test_1        |             			(VALUES (NULL::INT8), (4::INT8::INT8), (NULL::INT8), (5::INT8::INT8), (8::INT8::INT8))
        test_1        |             				AS tab_73132 (col_122654)
        test_1        |             	)
        test_1        |             		AS tab_73133
        test_1        |             ORDER BY
        test_1        |             	col_122655;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.26s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table3 (col3_0 UUID NOT NULL, col3_1 STRING COLLATE da_DK NOT NULL, col3_2 VARCHAR NOT NULL, col3_3 STRING COLLATE de_DE NOT NULL, col3_4 BIT(22) NOT NULL, col3_5 STRING NOT NULL, col3_6 VARCHAR NOT NULL, col3_7 INT8 NOT NULL, col3_8 REGTYPE NOT NULL, col3_9 STRING NOT NULL AS (lower(col3_2)) VIRTUAL, col3_10 STRING NOT NULL AS (lower(CAST(col3_1 AS STRING))) STORED, col3_11 STRING NOT NULL AS (lower(CAST(col3_4 AS STRING))) VIRTUAL, col3_12 STRING AS (CASE WHEN col3_8 IS NULL THEN e'\fG\x04+9IU?':::STRING ELSE e'\'':::STRING END) STORED, PRIMARY KEY (col3_5, col3_6, col3_7, col3_4, col3_8 ASC, col3_9, col3_3, col3_10 ASC, col3_1 DESC, col3_2 DESC), INDEX (col3_7, col3_5 ASC, col3_8 DESC, col3_1 ASC, col3_10 DESC, col3_6 ASC, col3_2 ASC, col3_11, col3_9, col3_3 DESC, col3_4, col3_0) STORING (col3_12) PARTITION BY LIST (col3_7, col3_5, col3_8, col3_1) (PARTITION table3_part_0 VALUES IN (((-2833561688026232747):::INT8, e'\x17':::STRING, 3905097738:::OID, e'\U0004D47F\U00092FE8' COLLATE da_DK)), PARTITION table3_part_1 VALUES IN ((7465278338114626794:::INT8, e'1\f7':::STRING, 0:::OID, e'\U00055062\U0005DFD6\U00099850' COLLATE da_DK)), PARTITION table3_part_2 VALUES IN ((1066682965893028303:::INT8, e'wT\x188pW\x0b':::STRING, 3905367722:::OID, '' COLLATE da_DK)), PARTITION table3_part_3 VALUES IN ((1074611602728843496:::INT8, e'Oo\f/\x1f\x0b':::STRING, 3115899796:::OID, e'\U000DD9FC\U000ADDB1\U0000B76C\U000572A7\U000270C2' COLLATE da_DK)), PARTITION table3_part_4 VALUES IN (((-9223372036854775807):::INT8, e'v\x06(':::STRING, 0:::OID, e'\U00057AFC\U0005EFDA\U000A6CD5\U000ED66A' COLLATE da_DK)), PARTITION table3_part_5 VALUES IN (((-2147483648):::INT8, '':::STRING, 2456537739:::OID, e'\U00098A19' COLLATE da_DK)), PARTITION table3_part_6 VALUES IN (((-2409387885769605888):::INT8, e'P\x05!q-\x1dls':::STRING, 2238924387:::OID, e'\U000917DF\U000A5B91\U00030778\U00023E1D' COLLATE da_DK)), PARTITION table3_part_7 VALUES IN (((-5727645477197746746):::INT8, e'>\x0f\x1fVk ':::STRING, 3594179796:::OID, '' COLLATE da_DK)), PARTITION table3_part_8 VALUES IN (((-32768):::INT8, ']5':::STRING, 4144575513:::OID, e'\U000727B0\U00068345\U00033F25' COLLATE da_DK)), PARTITION table3_part_9 VALUES IN (((-4051027958833543225):::INT8, e'^}9\r<vC\x19':::STRING, 4257347521:::OID, e'\U000B5A0A\U000E0A6C\U000BD9C2\U00010C15\U00076FD6\U0005650C' COLLATE da_DK))) NOT VISIBLE, UNIQUE (col3_11 ASC, col3_8 DESC, lower(CAST(col3_0 AS STRING)) ASC, col3_0, col3_2, col3_5 ASC) WHERE (((((((table3.col3_6 > e'\x00':::STRING) OR (table3.col3_7 <= (-32768):::INT8)) AND (table3.col3_10 != e'\U00002603':::STRING)) OR (table3.col3_9 = 'X':::STRING)) AND (table3.col3_11 > '':::STRING)) OR (table3.col3_2 < 'X':::STRING)) OR (table3.col3_5 > '':::STRING)) AND (table3.col3_12 > e'\x00':::STRING), UNIQUE (col3_11, col3_12 ASC, col3_1 DESC, col3_10 ASC, col3_7 DESC, col3_3) WHERE (((((((table3.col3_11 > 'X':::STRING) OR (table3.col3_7 < 9223372036854775807:::INT8)) OR (table3.col3_12 <= e'\'':::STRING)) OR (table3.col3_5 >= '"':::STRING)) AND (table3.col3_10 <= '"':::STRING)) OR (table3.col3_2 <= 'X':::STRING)) AND (table3.col3_6 <= '':::STRING)) OR (table3.col3_9 != '':::STRING), FAMILY (col3_0, col3_8, col3_1), FAMILY (col3_3, col3_12, col3_5, col3_2, col3_6), FAMILY (col3_10, col3_7, col3_4))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=0f6b817f-2780-4570-a471-c764fad00189 for details on how to enable enterprise features (SQLSTATE XXC02)
        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:122: exit status 1
--- FAIL: TestComposeCompare (163.47s)
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-22.2 @ 55d7e937898823f6d15cd51be86c6483a1a8e347:

        test_1        |             					(NULL::TIMESTAMPTZ),
        test_1        |             					('2000-01-01 09:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ),
        test_1        |             					('2000-01-01 08:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ),
        test_1        |             					('2000-01-01 05:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ),
        test_1        |             					('2000-01-01 08:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ)
        test_1        |             			)
        test_1        |             				AS tab_18560 (col_33844)
        test_1        |             		ORDER BY
        test_1        |             			tab_18560.col_33844 DESC NULLS LAST
        test_1        |             	)
        test_1        |             		AS tab_18561
        test_1        |             ORDER BY
        test_1        |             	col_33845;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_18560.col_33844 AS col_33845
        test_1        |             		FROM
        test_1        |             			(
        test_1        |             				VALUES
        test_1        |             					(NULL::TIMESTAMPTZ),
        test_1        |             					('2000-01-01 09:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ),
        test_1        |             					('2000-01-01 08:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ),
        test_1        |             					('2000-01-01 05:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ),
        test_1        |             					('2000-01-01 08:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ)
        test_1        |             			)
        test_1        |             				AS tab_18560 (col_33844)
        test_1        |             		ORDER BY
        test_1        |             			tab_18560.col_33844 DESC NULLS LAST
        test_1        |             	)
        test_1        |             		AS tab_18561
        test_1        |             ORDER BY
        test_1        |             	col_33845;
        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:122: exit status 1
--- FAIL: TestComposeCompare (651.42s)
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-22.2 @ ec8169c3e001f6eac1c67f7fe43bfbf09c3f3234:

        test_1        |             ORDER BY
        test_1        |             	col_87526 ASC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_71267.col_87525 AS col_87526
        test_1        |             		FROM
        test_1        |             			(
        test_1        |             				VALUES
        test_1        |             					(
        test_1        |             						trunc(9::DECIMAL::DECIMAL::DECIMAL, CASE WHEN st_crosses(NULL::GEOMETRY::GEOMETRY, NULL::GEOMETRY::GEOMETRY)::BOOL THEN 9::INT8::INT4 ELSE 3::INT8::INT4 END::INT4)::DECIMAL
        test_1        |             					),
        test_1        |             					(NULL::DECIMAL),
        test_1        |             					(6::DECIMAL::DECIMAL),
        test_1        |             					(7::DECIMAL::DECIMAL)
        test_1        |             			)
        test_1        |             				AS tab_71267 (col_87525)
        test_1        |             		WHERE
        test_1        |             			true::BOOL
        test_1        |             		ORDER BY
        test_1        |             			tab_71267.col_87525 ASC NULLS LAST,
        test_1        |             			tab_71267.col_87525 ASC NULLS FIRST,
        test_1        |             			tab_71267.col_87525 NULLS FIRST,
        test_1        |             			tab_71267.col_87525 ASC
        test_1        |             	)
        test_1        |             		AS tab_71268
        test_1        |             ORDER BY
        test_1        |             	col_87526 ASC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.17s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table1 (col1_0 "char" NOT NULL, col1_1 REGCLASS NULL, col1_2 DATE NOT NULL, col1_3 TIMETZ NOT NULL, col1_4 INT4 NOT NULL, col1_5 FLOAT8 NOT NULL, col1_6 FLOAT8 NOT NULL AS (col1_5 + (-1.0931499381463174):::FLOAT8) VIRTUAL, PRIMARY KEY (col1_4 DESC, col1_0 DESC, col1_5 DESC, col1_6 ASC), UNIQUE (col1_6 DESC, col1_2, col1_4 ASC, col1_5) PARTITION BY LIST (col1_6, col1_2) (PARTITION table1_part_0 VALUES IN (((-0.2359306242054537):::FLOAT8, '1989-08-02':::DATE), ((-1.7981750943718848):::FLOAT8, '1993-09-11':::DATE), (5e-324:::FLOAT8, '1974-05-15':::DATE), (0.18474240312433782:::FLOAT8, '1982-05-10':::DATE)), PARTITION table1_part_1 VALUES IN ((1.1198176673330609:::FLOAT8, '1990-01-25':::DATE), (1.8378498767677351:::FLOAT8, '1993-01-07':::DATE), ((-0.7491775039899053):::FLOAT8, '1976-10-19':::DATE), (1.7736112709387968:::FLOAT8, '1993-09-23':::DATE)), PARTITION table1_part_2 VALUES IN ((1.0893289326929771:::FLOAT8, '1994-06-07':::DATE), ((-1.6586985520112505):::FLOAT8, '1980-10-05':::DATE), ((-0.19836486537545095):::FLOAT8, '1987-05-05':::DATE), ((-1.1218077163089628):::FLOAT8, '1980-01-26':::DATE)), PARTITION table1_part_3 VALUES IN (((-0.24924233563294285):::FLOAT8, '1973-11-07':::DATE), ((-0.9054414812013523):::FLOAT8, '1985-04-28':::DATE), (1.104357905151347:::FLOAT8, '1991-02-22':::DATE), (1.9834501288655826:::FLOAT8, '1996-08-24':::DATE)), PARTITION table1_part_4 VALUES IN (((-0.6900292123716141):::FLOAT8, '1995-12-10':::DATE), ((-1.5520144761440486):::FLOAT8, '1971-11-23':::DATE), (0.21104730392791748:::FLOAT8, '1971-01-10':::DATE), (0.03902964920865032:::FLOAT8, '1977-04-16':::DATE)), PARTITION table1_part_5 VALUES IN ((0.7772858085567829:::FLOAT8, '1987-05-06':::DATE), ((-0.0061679436809067845):::FLOAT8, '1970-04-18':::DATE), ((-2.108704962472503):::FLOAT8, '1994-02-01':::DATE), ((-1.0406869374631638):::FLOAT8, '1992-01-13':::DATE))) WHERE ((((table1.col1_6 >= '+Inf':::FLOAT8) OR (table1.col1_5 < '-Inf':::FLOAT8)) OR (table1.col1_2 <= '-infinity':::DATE)) OR (table1.col1_4 != 32767:::INT8)) OR (table1.col1_0 != 'X':::STRING), FAMILY (col1_3, col1_4), FAMILY (col1_1), FAMILY (col1_2, col1_0), FAMILY (col1_5))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=1dadcbea-6287-4769-a35c-a57a5bcad2d0 for details on how to enable enterprise features (SQLSTATE XXC02)
        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:122: exit status 1
--- FAIL: TestComposeCompare (106.02s)
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 Feb 8, 2024
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-22.2 @ 8b369aa6cdea1338a743d96ee53fc112c21be5e5:

        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:135: initializing connection: postgres
        test_1        |         compare_test.go:186: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare4141526991/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:188: compare postgres to cockroach1: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             - 	nil,
        test_1        |             + 	int32(8),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_13941.col_24143 AS col_24144
        test_1        |             		FROM
        test_1        |             			(VALUES (8::INT8::INT4), (0::INT8::INT4), (NULL::INT4), (8::INT8::INT4), (6::INT8::INT4))
        test_1        |             				AS tab_13941 (col_24143)
        test_1        |             	)
        test_1        |             		AS tab_13942
        test_1        |             ORDER BY
        test_1        |             	col_24144 DESC;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_13941.col_24143 AS col_24144
        test_1        |             		FROM
        test_1        |             			(VALUES (8:::INT8::INT4), (0:::INT8::INT4), (NULL::INT4), (8:::INT8::INT4), (6:::INT8::INT4))
        test_1        |             				AS tab_13941 (col_24143)
        test_1        |             	)
        test_1        |             		AS tab_13942
        test_1        |             ORDER BY
        test_1        |             	col_24144 DESC;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (694.21s)
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-22.2 @ d54cf31eda0d78aa3617e076c7b69a97e6b2b294:

        test_1        |             			(
        test_1        |             				VALUES
        test_1        |             					(('\x49'::BYTEA::BYTEA::BYTEA || '\x42'::BYTEA::BYTEA::BYTEA)::BYTEA),
        test_1        |             					('\x45'::BYTEA::BYTEA),
        test_1        |             					('\x43'::BYTEA::BYTEA),
        test_1        |             					(NULL::BYTEA),
        test_1        |             					('\x46'::BYTEA::BYTEA),
        test_1        |             					(NULL::BYTEA)
        test_1        |             			)
        test_1        |             				AS tab_23042 (col_39594)
        test_1        |             	)
        test_1        |             		AS tab_23043
        test_1        |             ORDER BY
        test_1        |             	col_39595 ASC;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_23042.col_39594 AS col_39595
        test_1        |             		FROM
        test_1        |             			(
        test_1        |             				VALUES
        test_1        |             					(('\x49':::BYTES::BYTES::BYTES || '\x42':::BYTES::BYTES::BYTES)::BYTES),
        test_1        |             					('\x45':::BYTES::BYTES),
        test_1        |             					('\x43':::BYTES::BYTES),
        test_1        |             					(NULL::BYTES),
        test_1        |             					('\x46':::BYTES::BYTES),
        test_1        |             					(NULL::BYTES)
        test_1        |             			)
        test_1        |             				AS tab_23042 (col_39594)
        test_1        |             	)
        test_1        |             		AS tab_23043
        test_1        |             ORDER BY
        test_1        |             	col_39595 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:122: exit status 1
--- FAIL: TestComposeCompare (657.63s)
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-22.2 @ 44a4515086b9f08c6880f3c7e62ea839c1070395:

        test_1        |             		SELECT
        test_1        |             			tab_87865.col_147114 AS col_147116, '2000-01-05':::DATE::DATE AS col_147117
        test_1        |             		FROM
        test_1        |             			(
        test_1        |             				VALUES
        test_1        |             					((7:::INT8::INT4::INT4 + NULL::DATE::DATE)::DATE, 8.0:::FLOAT8::FLOAT4),
        test_1        |             					(('2000-01-02':::DATE::DATE::DATE - 6:::INT8::INT4::INT4)::DATE, NULL::FLOAT4),
        test_1        |             					(NULL::DATE, 8.0:::FLOAT8::FLOAT4),
        test_1        |             					('2000-01-04':::DATE::DATE, 7.0:::FLOAT8::FLOAT4),
        test_1        |             					('2000-01-06':::DATE::DATE, 9.0:::FLOAT8::FLOAT4)
        test_1        |             			)
        test_1        |             				AS tab_87865 (col_147113, col_147114)
        test_1        |             		WHERE
        test_1        |             			8:::INT8::INT8::INT8
        test_1        |             			NOT IN (
        test_1        |             					SELECT
        test_1        |             						1:::INT8::INT8::INT8 AS col_147115
        test_1        |             					FROM
        test_1        |             						postgres.public.table3@[0] AS tab_87866
        test_1        |             						JOIN postgres.public.table2@[0] AS tab_87867 ON
        test_1        |             								(tab_87866.tableoid) = (tab_87867.tableoid)
        test_1        |             								AND (tab_87866.col3_1) = (tab_87867.col2_0)
        test_1        |             								AND (tab_87866.tableoid) = (tab_87867.col2_2)
        test_1        |             					ORDER BY
        test_1        |             						tab_87866.col3_1 DESC NULLS FIRST,
        test_1        |             						tab_87866.tableoid ASC NULLS FIRST,
        test_1        |             						tab_87867.col2_0 ASC NULLS FIRST
        test_1        |             				)
        test_1        |             		ORDER BY
        test_1        |             			tab_87865.col_147114 DESC,
        test_1        |             			tab_87865.col_147114 NULLS FIRST,
        test_1        |             			tab_87865.col_147114 NULLS LAST,
        test_1        |             			tab_87865.col_147114 ASC
        test_1        |             	)
        test_1        |             		AS tab_87868
        test_1        |             ORDER BY
        test_1        |             	col_147116, col_147117 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:122: exit status 1
--- FAIL: TestComposeCompare (766.55s)
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-22.2 @ dfdc33280ccd64e77522a6335817a579b5b871b5:

        test_1        |             		FROM
        test_1        |             			(
        test_1        |             				VALUES
        test_1        |             					(st_box2dfromgeohash('H':::STRING::STRING::STRING)::BOX2D),
        test_1        |             					(CASE WHEN true::BOOL THEN NULL::BOX2D ELSE NULL::BOX2D END),
        test_1        |             					(NULL::BOX2D)
        test_1        |             			)
        test_1        |             				AS tab_39089 (col_64274)
        test_1        |             	)
        test_1        |             		AS tab_39090
        test_1        |             ORDER BY
        test_1        |             	CAST(col_64275 AS STRING) DESC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_39089.col_64274 AS col_64275
        test_1        |             		FROM
        test_1        |             			(
        test_1        |             				VALUES
        test_1        |             					(st_box2dfromgeohash('H'::TEXT::TEXT::TEXT)::BOX2D),
        test_1        |             					(CASE WHEN true::BOOL THEN NULL::BOX2D ELSE NULL::BOX2D END),
        test_1        |             					(NULL::BOX2D)
        test_1        |             			)
        test_1        |             				AS tab_39089 (col_64274)
        test_1        |             	)
        test_1        |             		AS tab_39090
        test_1        |             ORDER BY
        test_1        |             	CAST(col_64275 AS TEXT) DESC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.24s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table5 (col5_0 GEOMETRY NOT NULL, col5_1 DECIMAL NOT NULL, col5_2 INT2[], col5_3 REGROLE NULL, col5_4 GEOGRAPHY NOT NULL, col5_5 FLOAT4 NOT NULL, col5_6 INT4[] NOT NULL, col5_7 REGTYPE, col5_8 JSONB NOT NULL, col5_9 STRING NOT NULL, col5_10 STRING NOT NULL AS (lower(CAST(col5_8 AS STRING))) STORED, col5_11 STRING NOT NULL AS (lower(CAST(col5_4 AS STRING))) VIRTUAL, col5_12 STRING NOT NULL AS (lower(col5_9)) STORED, col5_13 FLOAT8 NOT NULL AS (col5_5 + 0.47769400477409363:::FLOAT8) VIRTUAL, UNIQUE (col5_7 DESC) STORING (col5_6, col5_8, col5_12), INDEX (col5_5 ASC) WHERE ((((((table5.col5_11 != e'\'':::STRING) AND (table5.col5_12 != '"':::STRING)) AND (table5.col5_13 = '-Inf':::FLOAT8)) OR (table5.col5_10 <= e'\x00':::STRING)) AND (table5.col5_5 < 'NaN':::FLOAT8)) AND (table5.col5_9 > 'X':::STRING)) AND (table5.col5_1 < 0:::DECIMAL) NOT VISIBLE, UNIQUE (col5_7) PARTITION BY LIST (col5_7) (PARTITION table5_part_0 VALUES IN ((0:::OID,), (257638391:::OID,), (2388715972:::OID,), (2882056122:::OID,), (186037520:::OID,), (1724365438:::OID,), (4015216260:::OID,)), PARTITION table5_part_1 VALUES IN ((118052794:::OID,), (336583765:::OID,), (2023550120:::OID,), (580998874:::OID,), (1728142755:::OID,), (818470638:::OID,), (2209640230:::OID,), (3537847292:::OID,)), PARTITION table5_part_2 VALUES IN ((3178960617:::OID,), (1443756176:::OID,), (1331434472:::OID,), (2680962898:::OID,), (4075479772:::OID,), (1000670316:::OID,), (568638097:::OID,)), PARTITION table5_part_3 VALUES IN ((585771489:::OID,), (3961202809:::OID,), (3614118427:::OID,), (1480529995:::OID,), (281954866:::OID,), (1418152763:::OID,)), PARTITION table5_part_4 VALUES IN ((930796759:::OID,), (1533324258:::OID,), (1012984980:::OID,), (3412649137:::OID,), (487579219:::OID,), (2268520933:::OID,), (1363708249:::OID,)), PARTITION table5_part_5 VALUES IN ((1819644880:::OID,), (2278610772:::OID,), (3762318465:::OID,), (617325437:::OID,), (1858308106:::OID,), (1503006542:::OID,), (2440612700:::OID,)), PARTITION table5_part_6 VALUES IN ((1450919802:::OID,), (3805639806:::OID,), (3718137940:::OID,), (496509059:::OID,), (706610859:::OID,), (3417898734:::OID,)), PARTITION table5_part_7 VALUES IN ((3962160601:::OID,), (3208699064:::OID,), (1261985302:::OID,), (1203826219:::OID,), (838929537:::OID,), (1525468713:::OID,), (3500534285:::OID,)), PARTITION table5_part_8 VALUES IN ((1819671359:::OID,), (2000070929:::OID,), (2274143042:::OID,), (579562525:::OID,), (43713900:::OID,), (2264959573:::OID,), (3370343875:::OID,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))) WHERE ((((((table5.col5_13 > 5e-324:::FLOAT8) OR (table5.col5_10 < '':::STRING)) AND (table5.col5_9 < e'\x00':::STRING)) AND (table5.col5_5 <= 0.0:::FLOAT8)) OR (table5.col5_12 >= 'X':::STRING)) OR (table5.col5_11 >= e'\x00':::STRING)) OR (table5.col5_1 = '-Infinity':::DECIMAL), FAMILY (col5_6, col5_8), FAMILY (col5_9, col5_4, col5_0), FAMILY (col5_7, col5_12, col5_1), FAMILY (col5_3), FAMILY (col5_5), FAMILY (col5_2, col5_10))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=83dbf2a3-3c25-45a1-8207-549a9f24f495 for details on how to enable enterprise features (SQLSTATE XXC02)
        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:122: exit status 1
--- FAIL: TestComposeCompare (82.03s)
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-22.2 @ a1c9bf9e2236a23ccb886afa8ce7d91bae4c671d:

        postgres_1    | 		col_432 NULLS FIRST,
        postgres_1    | 		col_433 ASC NULLS FIRST,
        postgres_1    | 		col_434 ASC NULLS LAST
        test_1        | --- FAIL: TestCompare (605.33s)
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     --- FAIL: TestCompare/postgres (1.58s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:135: initializing connection: postgres
        test_1        |         compare_test.go:186: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare1502895231/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:188: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |               	strings.Join({
        test_1        |               		"ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff",
        test_1        |             + 		"/128",
        test_1        |               		"A",
        test_1        |               	}, ""),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT (hostmask('::/0'::INET::INET::INET)::INET::INET || 'A'::TEXT::TEXT::TEXT)::TEXT AS col_481)
        test_1        |             		AS tab_266
        test_1        |             ORDER BY
        test_1        |             	col_481 ASC NULLS LAST;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT (hostmask('::/0':::INET::INET::INET)::INET::INET || 'A':::STRING::STRING::STRING)::STRING AS col_481)
        test_1        |             		AS tab_266
        test_1        |             ORDER BY
        test_1        |             	col_481 ASC NULLS LAST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (629.90s)
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 5, 2024
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-22.2 @ bc68323e0ec7a335b0ee6986e6cf7747e45b6193:

        test_1        |             			tab_18585.col_16364 AS col_16365
        test_1        |             		FROM
        test_1        |             			(
        test_1        |             				VALUES
        test_1        |             					('F':::STRING::VARCHAR),
        test_1        |             					(NULL::VARCHAR),
        test_1        |             					('D':::STRING::VARCHAR),
        test_1        |             					('F':::STRING::VARCHAR),
        test_1        |             					('E':::STRING::VARCHAR)
        test_1        |             			)
        test_1        |             				AS tab_18585 (col_16364)
        test_1        |             	)
        test_1        |             		AS tab_18586
        test_1        |             ORDER BY
        test_1        |             	col_16365;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_18585.col_16364 AS col_16365
        test_1        |             		FROM
        test_1        |             			(
        test_1        |             				VALUES
        test_1        |             					('F'::TEXT::VARCHAR),
        test_1        |             					(NULL::VARCHAR),
        test_1        |             					('D'::TEXT::VARCHAR),
        test_1        |             					('F'::TEXT::VARCHAR),
        test_1        |             					('E'::TEXT::VARCHAR)
        test_1        |             			)
        test_1        |             				AS tab_18585 (col_16364)
        test_1        |             	)
        test_1        |             		AS tab_18586
        test_1        |             ORDER BY
        test_1        |             	col_16365;
        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:122: exit status 1
--- FAIL: TestComposeCompare (649.86s)
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-22.2 @ fe88d4e539e183e79a597cf2cba8fb4ffef9a65a:

        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_13944.col_25648 AS col_25649
        test_1        |             		FROM
        test_1        |             			(VALUES (NULL::DATE), ('2000-01-09'::DATE::DATE), ('2000-01-04'::DATE::DATE)) AS tab_13944 (col_25648)
        test_1        |             		ORDER BY
        test_1        |             			tab_13944.col_25648 ASC
        test_1        |             	)
        test_1        |             		AS tab_13945
        test_1        |             ORDER BY
        test_1        |             	col_25649;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_13944.col_25648 AS col_25649
        test_1        |             		FROM
        test_1        |             			(VALUES (NULL::DATE), ('2000-01-09':::DATE::DATE), ('2000-01-04':::DATE::DATE)) AS tab_13944 (col_25648)
        test_1        |             		ORDER BY
        test_1        |             			tab_13944.col_25648 ASC
        test_1        |             	)
        test_1        |             		AS tab_13945
        test_1        |             ORDER BY
        test_1        |             	col_25649;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.39s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table2 (col2_0 TIME NOT NULL, col2_1 INET NOT NULL, col2_2 REGCLASS NOT NULL, col2_3 BYTES NOT NULL, col2_4 REGTYPE, col2_5 DATE NOT NULL, col2_6 VARCHAR NOT NULL, col2_7 STRING NULL, col2_8 STRING AS (CASE WHEN col2_4 IS NULL THEN e'\x1c':::STRING ELSE e'\x15\x1bjR':::STRING END) VIRTUAL, col2_9 STRING NOT NULL AS (lower(CAST(col2_1 AS STRING))) STORED, col2_10 STRING NULL AS (lower(CAST(col2_0 AS STRING))) STORED, PRIMARY KEY (col2_5 DESC, col2_2 DESC, col2_0 ASC, col2_9 DESC), UNIQUE (col2_2) STORING (col2_6, col2_7) PARTITION BY LIST (col2_2) (PARTITION table2_part_0 VALUES IN ((2165306884:::OID,), (2166288310:::OID,), (3537178490:::OID,), (2435415778:::OID,), (1579208128:::OID,), (2761911642:::OID,), (2974713219:::OID,)), PARTITION table2_part_1 VALUES IN ((275962439:::OID,), (3512035033:::OID,), (12453829:::OID,), (283905615:::OID,), (2346648543:::OID,), (2740764351:::OID,), (527261180:::OID,)), PARTITION table2_part_2 VALUES IN ((2526926543:::OID,), (2515758998:::OID,), (4264988805:::OID,), (3600284660:::OID,), (4272274413:::OID,), (0:::OID,), (1878505500:::OID,)), PARTITION table2_part_3 VALUES IN ((3445579689:::OID,), (286330806:::OID,), (2034000822:::OID,), (440999428:::OID,), (230069435:::OID,), (3550607974:::OID,), (2803080928:::OID,)), PARTITION table2_part_4 VALUES IN ((2973221776:::OID,), (3841672479:::OID,), (1676628005:::OID,), (2776163123:::OID,), (1960140382:::OID,), (1138857605:::OID,)), PARTITION table2_part_5 VALUES IN ((2562427899:::OID,), (1350530816:::OID,), (13887967:::OID,), (2745669246:::OID,), (3119820744:::OID,), (4252991013:::OID,), (3133950228:::OID,)), PARTITION table2_part_6 VALUES IN ((271026626:::OID,), (3309452842:::OID,), (1899919582:::OID,), (642242328:::OID,), (3733154588:::OID,), (1847246670:::OID,), (2530177227:::OID,)), PARTITION table2_part_7 VALUES IN ((2135255628:::OID,), (4099098505:::OID,), (3379903049:::OID,), (4150735388:::OID,), (2069113123:::OID,)), PARTITION table2_part_8 VALUES IN ((3543974855:::OID,), (2285533370:::OID,), (2197908364:::OID,), (4061002280:::OID,), (3712284612:::OID,), (1166267773:::OID,), (3059387799:::OID,)), PARTITION table2_part_9 VALUES IN ((2857289643:::OID,), (1863933256:::OID,), (2694500545:::OID,), (1020696724:::OID,), (435381319:::OID,), (3498067830:::OID,))) WHERE ((((table2.col2_5 < '5874897-12-31':::DATE) OR (table2.col2_0 > '24:00:00':::TIME)) OR (table2.col2_8 = e'\x00':::STRING)) OR (table2.col2_7 = e'\'':::STRING)) AND (table2.col2_6 > e'\'':::STRING), INDEX (col2_5, col2_0 ASC, col2_2, col2_1 ASC, col2_8 ASC, col2_6 DESC, col2_4 DESC, col2_7 ASC, lower(col2_7) DESC, col2_3 DESC, col2_10 DESC) WHERE (((((((table2.col2_3 >= '\xe29883':::BYTES) AND (table2.col2_0 >= '24:00:00':::TIME)) OR (table2.col2_6 >= 'X':::STRING)) AND (table2.col2_10 = e'\'':::STRING)) AND (table2.col2_5 != 'infinity':::DATE)) OR (table2.col2_7 <= e'\U00002603':::STRING)) OR (table2.col2_8 != '':::STRING)) OR (table2.col2_9 <= '':::STRING), FAMILY (col2_3), FAMILY (col2_0), FAMILY (col2_10), FAMILY (col2_4, col2_2, col2_5, col2_1), FAMILY (col2_7, col2_6), FAMILY (col2_9))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=2f07eeb2-6e29-4a67-bcf7-d487e700408e for details on how to enable enterprise features (SQLSTATE XXC02)
        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:122: exit status 1
--- FAIL: TestComposeCompare (55.28s)
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
Closed
Closed
Closed
This was referenced Apr 2, 2024
Closed
Closed
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-22.2 @ 4cf9a3774fdf18ebba88bc9a7a40c171e3762769:

        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table3 (col3_0 GEOGRAPHY NULL, col3_1 BOX2D NOT NULL, col3_2 REGCLASS NULL, col3_3 BIT(43) NOT NULL, col3_4 TIMESTAMP NOT NULL, col3_5 INT4 NULL, col3_6 INTERVAL NULL, col3_7 UUID NOT NULL, col3_8 BIT(5), col3_9 NAME NULL, col3_10 OID NULL, col3_11 STRING NOT NULL AS (lower(CAST(col3_8 AS STRING))) VIRTUAL, PRIMARY KEY (col3_11, col3_7 ASC), INDEX (col3_9 ASC, col3_5, col3_8 ASC) PARTITION BY LIST (col3_9, col3_5, col3_8) (PARTITION table3_part_0 VALUES IN ((e'\x1cQqeb\x07pQ{':::STRING:::NAME, (-1782187758):::INT8, B'11000'), ('1-':::STRING:::NAME, 2062135606:::INT8, B'11001'), (e'\x0e\x11\x1ft\ti!F':::STRING:::NAME, (-339969268):::INT8, B'00000')), PARTITION table3_part_1 VALUES IN (('':::STRING:::NAME, (-359270181):::INT8, B'01000'), ('':::STRING:::NAME, (-1944118749):::INT8, B'11101'), ('':::STRING:::NAME, (-118587784):::INT8, B'00000'))), INVERTED INDEX (col3_5, col3_0 ASC), UNIQUE (col3_6 ASC, col3_7, col3_10 DESC, col3_3, col3_11 DESC, col3_4 DESC, col3_9, col3_5, col3_8 ASC, col3_2 DESC), UNIQUE (col3_6 ASC) STORING (col3_0, col3_1, col3_3, col3_4, col3_8, col3_9) WHERE (table3.col3_9 != '"':::STRING:::NAME) AND (table3.col3_11 != '"':::STRING), UNIQUE ((CASE WHEN col3_4 IS NULL THEN 'J':::STRING ELSE e'@\x18':::STRING END) ASC, lower(CAST(col3_7 AS STRING)) ASC, col3_5, (CASE WHEN col3_6 IS NULL THEN e'\x16IR<A!':::STRING ELSE '{k:HEw**6':::STRING END) ASC, col3_3 DESC, col3_1, lower(CAST(col3_10 AS STRING)), col3_11, lower(CAST(col3_8 AS STRING)) DESC, col3_2 ASC) WHERE (((table3.col3_5 >= 1:::INT8) AND (table3.col3_4 <= '3000-01-01 00:00:00':::TIMESTAMP)) AND (table3.col3_9 < '"':::STRING:::NAME)) OR (table3.col3_11 < e'\U00002603':::STRING), INDEX (lower(CAST(col3_10 AS STRING)) ASC) STORING (col3_0, col3_1, col3_2, col3_4, col3_5, col3_8, col3_10), FAMILY (col3_1, col3_8), FAMILY (col3_3, col3_10, col3_5), FAMILY (col3_6, col3_0), FAMILY (col3_2), FAMILY (col3_7), FAMILY (col3_9, col3_4))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=8f247d1f-6f57-4cd4-989b-69b284df9ff0 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        |     --- FAIL: TestCompare/postgres (5.11s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:135: initializing connection: postgres
        test_1        |         compare_test.go:186: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare4248987084/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:188: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             - 	nil,
        test_1        |             + 	bool(false),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_3215.col_6700 AS col_6701
        test_1        |             		FROM
        test_1        |             			(
        test_1        |             				VALUES
        test_1        |             					(false::BOOL),
        test_1        |             					(false::BOOL),
        test_1        |             					(B'0011'::BIT(32)::BIT(32) IN (B'0110'::BIT(32), B'0000'::BIT(32))),
        test_1        |             					(false::BOOL),
        test_1        |             					(NULL::BOOL),
        test_1        |             					(false::BOOL)
        test_1        |             			)
        test_1        |             				AS tab_3215 (col_6700)
        test_1        |             	)
        test_1        |             		AS tab_3216
        test_1        |             ORDER BY
        test_1        |             	col_6701 ASC;
        test_1        |             
        test_1        |             postgres: [same as previous]
        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:122: exit status 1
--- FAIL: TestComposeCompare (32.66s)
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 10, 2024
Closed
Closed
@cockroach-teamcity cockroach-teamcity mentioned this issue Apr 29, 2024
Closed
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-22.2 @ 256d79f5b4e215007e6764d7227c22b487bcb803:

        test_1        |         compare_test.go:186: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare3172175253/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:188: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             - 	nil,
        test_1        |             + 	s"1",
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_10340.col_18749 AS col_18750
        test_1        |             		FROM
        test_1        |             			(VALUES (NULL::DECIMAL), (1:::DECIMAL::DECIMAL), (8:::DECIMAL::DECIMAL)) AS tab_10340 (col_18749)
        test_1        |             		WHERE
        test_1        |             			true::BOOL
        test_1        |             	)
        test_1        |             		AS tab_10341
        test_1        |             ORDER BY
        test_1        |             	col_18750;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_10340.col_18749 AS col_18750
        test_1        |             		FROM
        test_1        |             			(VALUES (NULL::DECIMAL), (1::DECIMAL::DECIMAL), (8::DECIMAL::DECIMAL)) AS tab_10340 (col_18749)
        test_1        |             		WHERE
        test_1        |             			true::BOOL
        test_1        |             	)
        test_1        |             		AS tab_10341
        test_1        |             ORDER BY
        test_1        |             	col_18750;
        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:122: exit status 1
--- FAIL: TestComposeCompare (44.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 May 18, 2024
Closed
Closed
@rafiss rafiss closed this as completed May 31, 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-22.2 Used to mark release blockers and technical advisories for 22.2 O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
No open projects
SQL Sessions - Deprecated
Test failures
Milestone
22.2
Development

No branches or pull requests
4 participants
@rafiss @chrisseto @cockroach-teamcity @Xiang-Gu