cockroach-teamcity
commented
2 years ago compose.TestComposeCompare failed with artifacts on master @ aadbaf97b4e6092ad6978a28e2735715d64d9f10:
postgres_1 | col_845810 NULLS FIRST,
postgres_1 | col_845811 NULLS FIRST,
postgres_1 | col_845812 NULLS FIRST,
postgres_1 | col_845813 NULLS FIRST,
postgres_1 | col_845814 NULLS FIRST
postgres_1 | 2022-06-15 05:28:45.269 UTC [78] ERROR: function st_geogfromgeojson(jsonb) does not exist at character 95
postgres_1 | 2022-06-15 05:28:45.269 UTC [78] HINT: No function matches the given name and argument types. You might need to add explicit type casts.
postgres_1 | 2022-06-15 05:28:45.269 UTC [78] STATEMENT: SELECT
postgres_1 | *
postgres_1 | FROM
postgres_1 | (
postgres_1 | SELECT
postgres_1 | tab_482559.col1_6 AS col_846352,
postgres_1 | COALESCE(tab_482559.col1_3, st_geogfromgeojson('null'::JSONB::JSONB::JSONB)::GEOGRAPHY) AS col_846353,
postgres_1 | NULL::GEOGRAPHY AS col_846354
postgres_1 | FROM
postgres_1 | postgres.public.table1 AS tab_482559
postgres_1 | WHERE
postgres_1 | true::BOOL
postgres_1 | ORDER BY
postgres_1 | tab_482559.col1_2 DESC, tab_482559.col1_0 ASC
postgres_1 | )
postgres_1 | AS tab_482560
postgres_1 | ORDER BY
postgres_1 | col_846352 NULLS FIRST, col_846353 NULLS FIRST, col_846354 NULLS FIRST
test_1 | --- FAIL: TestCompare (604.96s)
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/mutators (0.35s)
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 CHAR NULL, col1_1 INT8[], col1_2 INT2 NOT NULL, col1_3 "char" NOT NULL, col1_4 FLOAT8 NULL, col1_5 BIT(23) NULL, col1_6 STRING NOT NULL AS (lower(col1_3)) STORED, col1_7 STRING AS (CASE WHEN col1_1 IS NULL THEN '':::STRING ELSE e'\r':::STRING END) STORED, col1_8 STRING NULL AS (lower(CAST(col1_5 AS STRING))) VIRTUAL, col1_9 INT2 NOT NULL AS (col1_2 + 5736:::INT8) VIRTUAL, col1_10 INT2 NOT NULL AS (col1_2 + 25643:::INT8) VIRTUAL, INDEX (col1_0 ASC, col1_8 DESC), INDEX (col1_4, lower(col1_0), (CASE WHEN col1_1 IS NULL THEN e'K\x06\x0e8':::STRING ELSE e'Op?;4\'s\x01M':::STRING END)) WHERE ((table1.col1_0 >= e'\x00':::STRING) AND (table1.col1_8 > '':::STRING)) AND (table1.col1_9 = 1:::INT8), INVERTED INDEX (col1_1), INDEX (lower(CAST(col1_5 AS STRING)) ASC) STORING (col1_0, col1_1, col1_2, col1_3, col1_4, col1_5, col1_7) WHERE (((((((table1.col1_10 > 0:::INT8) AND (table1.col1_8 = '"':::STRING)) AND (table1.col1_9 != (-1):::INT8)) OR (table1.col1_4 != 1.401298464324817e-45:::FLOAT8)) OR (table1.col1_0 = '':::STRING)) OR (table1.col1_2 < (-32768):::INT8)) OR (table1.col1_6 = e'\'':::STRING)) AND (table1.col1_7 != e'\'':::STRING), INVERTED INDEX (col1_10, col1_0, col1_7 DESC, col1_8, col1_3 ASC, col1_9 ASC, col1_6 ASC, col1_2 DESC, col1_5 DESC, col1_1 ASC) WHERE ((((((table1.col1_8 = '':::STRING) AND (table1.col1_9 != 1:::INT8)) AND (table1.col1_0 != e'\'':::STRING)) OR (table1.col1_10 >= 0:::INT8)) OR (table1.col1_3 < e'\x00':::STRING)) AND (table1.col1_4 = (-1.0):::FLOAT8)) AND (table1.col1_6 >= '':::STRING), FAMILY (col1_1), FAMILY (col1_0, col1_2, col1_7), FAMILY (col1_4, col1_5), FAMILY (col1_6, col1_3));
test_1 | ALTER TABLE table1 INJECT STATISTICS e'[{"avg_size": 0, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 39495893, "histo_buckets": [{"distinct_range": 0, "num_eq": 1424553467740240230, "num_range": 0, "upper_bound": "-1.6402189281976707"}, {"distinct_range": 70000, "num_eq": 5753833549081315169, "num_range": 70000, "upper_bound": "-1.5299245011626006"}, {"distinct_range": 412684546910471230, "num_eq": 8297537923616132323, "num_range": 3409200632208684759, "upper_bound": "-0.580160218161228"}, {"distinct_range": 0, "num_eq": 1383650233280404421, "num_range": 500000000, "upper_bound": "-0.5564662088633598"}, {"distinct_range": 2867504460972334600, "num_eq": 3000, "num_range": 3459166442014626223, "upper_bound": "0.5891400221514833"}, {"distinct_range": 0, "num_eq": 1968641834762575304, "num_range": 60000000, "upper_bound": "1.3383457747167575"}, {"distinct_range": 90000000000, "num_eq": 60000000000, "num_range": 90000000000, "upper_bound": "1.6136973675048965"}], "histo_col_type": "FLOAT8", "name": "__auto__", "null_count": 69854546, "row_count": 200000000}, {"avg_size": 0, "columns": ["col1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 114549698, "histo_col_type": "", "name": "__auto__", "null_count": 23179216, "row_count": 200000000}, {"avg_size": 0, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 187677562, "histo_buckets": [{"distinct_range": 0, "num_eq": 3529258188424664999, "num_range": 0, "upper_bound": "\\u0004"}, {"distinct_range": 4214692725477423000, "num_eq": 6105756622681669932, "num_range": 4214692725477423358, "upper_bound": "\\u001d"}, {"distinct_range": 700000000, "num_eq": 7414450090263040657, "num_range": 700000000, "upper_bound": "-"}, {"distinct_range": 7927642188103115000, "num_eq": 0, "num_range": 7927642188103115083, "upper_bound": "~"}], "histo_col_type": "CHAR", "name": "__auto__", "null_count": 148887205, "row_count": 200000000}, {"avg_size": 0, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 154070138, "histo_col_type": "", "name": "__auto__", "null_count": 67656144, "row_count": 200000000}, {"avg_size": 0, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 40200918, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 200000000}, {"avg_size": 0, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 143576311, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 200000000}, {"avg_size": 0, "columns": ["col1_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 167706536, "histo_buckets": [{"distinct_range": 0, "num_eq": 2000, "num_range": 0, "upper_bound": "-29922"}, {"distinct_range": 0, "num_eq": 500000000, "num_range": 200000, "upper_bound": "-13663"}, {"distinct_range": 0, "num_eq": 9000000000, "num_range": 1000000, "upper_bound": "6556"}, {"distinct_range": 0, "num_eq": 8000000000, "num_range": 90000000000, "upper_bound": "9419"}, {"distinct_range": 100000000000, "num_eq": 70000, "num_range": 100000000000, "upper_bound": "13933"}], "histo_col_type": "INT2", "name": "__auto__", "null_count": 0, "row_count": 200000000}, {"avg_size": 0, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 67489460, "histo_col_type": "", "name": "__auto__", "null_count": 123738412, "row_count": 200000000}, {"avg_size": 0, "columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 136079090, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 200000000}, {"avg_size": 0, "columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 92040790, "histo_col_type": "", "name": "__auto__", "null_count": 156023612, "row_count": 200000000}, {"avg_size": 0, "columns": ["col1_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 186046465, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 200000000}]':::JSONB;
test_1 | ALTER TABLE table1 INJECT STATISTICS e'[{"avg_size": 0, "columns": ["col1_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 514309695932811758, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 582270947598272610}, {"avg_size": 0, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 396939696686035392, "histo_buckets": [{"distinct_range": 0, "num_eq": 8000000, "num_range": 0, "upper_bound": "\\\\x43"}, {"distinct_range": 48634005.51828572, "num_eq": 600, "num_range": 50000000, "upper_bound": "\\\\x809b329ccc24870f12"}, {"distinct_range": 6410494896422032000, "num_eq": 9000000, "num_range": 6410494896422032009, "upper_bound": "\\\\x80b400447e685a3a65"}, {"distinct_range": 3581556500492977000, "num_eq": 0, "num_range": 5928006972997490881, "upper_bound": "\\\\x80d95ac4ef4d600bed"}, {"distinct_range": 0, "num_eq": 695809468838543330, "num_range": 0, "upper_bound": "\\\\x80d95fcd13fa456a42"}, {"distinct_range": 0, "num_eq": 7101655867429141497, "num_range": 90000000000, "upper_bound": "\\\\x868000"}, {"distinct_range": 0, "num_eq": 431818602842518842, "num_range": 5067588741391159647, "upper_bound": "\\\\xfd13173c10e16e6042"}, {"distinct_range": 0, "num_eq": 80, "num_range": 5525263451248042249, "upper_bound": "\\\\xfd5b7f5fd1809738f5"}], "histo_col_type": "BYTES", "name": "__auto__", "null_count": 53447671388295447, "row_count": 582270947598272610}, {"avg_size": 0, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 529270042029071244, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 582270947598272610}, {"avg_size": 0, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 494877775011671539, "histo_col_type": "", "name": "__auto__", "null_count": 213170086090212853, "row_count": 582270947598272610}, {"avg_size": 0, "columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 59648386882371080, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 582270947598272610}, {"avg_size": 0, "columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 504654954596150223, "histo_col_type": "", "name": "__auto__", "null_count": 52630413012969812, "row_count": 582270947598272610}, {"avg_size": 0, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 312350643174551449, "histo_buckets": [{"distinct_range": 0, "num_eq": 1217422781014878269, "num_range": 0, "upper_bound": "9"}, {"distinct_range": 5695105975942524000, "num_eq": 3670719126238849842, "num_range": 8109573223507896168, "upper_bound": "g"}, {"distinct_range": 17421628215.93851, "num_eq": 70000, "num_range": 40000000000, "upper_bound": "r"}], "histo_col_type": "CHAR", "name": "__auto__", "null_count": 272092514134144149, "row_count": 582270947598272610}, {"avg_size": 0, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 453267435583102035, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 582270947598272610}, {"avg_size": 0, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 147653333367627970, "histo_buckets": [{"distinct_range": 0, "num_eq": 400000, "num_range": 0, "upper_bound": "-0.8035459360336241"}], "histo_col_type": "FLOAT8", "name": "__auto__", "null_count": 126284976877035831, "row_count": 582270947598272610}, {"avg_size": 0, "columns": ["col1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 261753268096740963, "histo_col_type": "", "name": "__auto__", "null_count": 558995517413874583, "row_count": 582270947598272610}, {"avg_size": 0, "columns": ["col1_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 329893171676972624, "histo_buckets": [{"distinct_range": 0, "num_eq": 0, "num_range": 0, "upper_bound": "1"}, {"distinct_range": 2793954907971643000, "num_eq": 4198316694632235569, "num_range": 8270903236956817152, "upper_bound": "13360"}, {"distinct_range": 137.18540544509054, "num_eq": 0, "num_range": 300, "upper_bound": "15161"}, {"distinct_range": 8108463750087784000, "num_eq": 50000, "num_range": 8108463750087784722, "upper_bound": "23393"}], "histo_col_type": "INT2", "name": "__auto__", "null_count": 0, "row_count": 582270947598272610}]':::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_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 (638.21s)Help
See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)
Same failure on other branches
- #78068 compose: TestComposeCompare failed [C-test-failure O-robot T-sql-experience branch-release-22.1 sync-me-8] - #73421 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.2 sync-me-8]
compose.TestComposeCompare failed with artifacts on master @ b0a8d28feb8befa417933d0a2ee99511b16414a1:
Help
See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)
Same failure on other branches
- #78068 compose: TestComposeCompare failed [C-test-failure O-robot T-sql-experience branch-release-22.1 sync-me-8] - #73421 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.2 sync-me-8]
/cc @cockroachdb/sql-experience
This test on roachdash | Improve this report!
Jira issue: CRDB-16697