roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.

https://www.cockroachlabs.com

Other

29.99k stars 3.79k forks source link

roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed #126802

Closed cockroach-teamcity closed 1 month ago

cockroach-teamcity commented 3 months ago

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on release-23.1 @ 85196c163d18d7396e6c7f38bcfb9f5b9acf9f61:

    string{
        ... // 174 identical bytes
        0x05, 0x67, 0x22, 0x5b, 0x6c, 0x05, 0x67, 0x22, 0x5b, 0x6c, 0x05, 0x67, 0x22, 0x5b, 0x6c, 0x05, //  |.g"[l.g"[l.g"[l.|
        0x67, 0x22, 0x5b, 0x6c, 0x05, 0x67, 0x22, 0x5b, 0x6c, 0x05, 0x67, 0x22, 0x5b, 0x6c, 0x05, 0x2c, //  |g"[l.g"[l.g"[l.,|
-       0x65, 0x27, 0x65, 0x5c, 0x27, 0x74, 0x61, 0x62, 0x5c, 0x5c, 0x5c, 0x5c, 0x5c, 0x5c, 0x5c, 0x5c, // -|e'e\'tab\\\\\\\\|
-       0x55, 0x30, 0x30, 0x31, 0x30, 0x33, 0x45, 0x46, 0x45, 0x6c, 0x65, 0x31, 0x5c, 0x27, 0x27,       // -|U00103EFEle1\''|
+       0x31, 0x30, 0x34,                                                                               // +|104|
    },
    string{
        ... // 424 identical bytes
        0x05, 0x67, 0x22, 0x5b, 0x6c, 0x05, 0x67, 0x22, 0x5b, 0x6c, 0x05, 0x67, 0x22, 0x5b, 0x6c, 0x05, //  |.g"[l.g"[l.g"[l.|
        0x67, 0x22, 0x5b, 0x6c, 0x05, 0x67, 0x22, 0x5b, 0x6c, 0x05, 0x67, 0x22, 0x5b, 0x6c, 0x05, 0x2c, //  |g"[l.g"[l.g"[l.,|
-       0x65, 0x27, 0x65, 0x5c, 0x27, 0x74, 0x61, 0x62, 0x5c, 0x5c, 0x5c, 0x5c, 0x5c, 0x5c, 0x5c, 0x5c, // -|e'e\'tab\\\\\\\\|
-       0x55, 0x30, 0x30, 0x31, 0x30, 0x33, 0x45, 0x46, 0x45, 0x6c, 0x65, 0x31, 0x5c, 0x27, 0x27,       // -|U00103EFEle1\''|
+       0x31, 0x30, 0x34,                                                                               // +|104|
    },
    string{
        ... // 1124 identical bytes
        0x05, 0x67, 0x22, 0x5b, 0x6c, 0x05, 0x67, 0x22, 0x5b, 0x6c, 0x05, 0x67, 0x22, 0x5b, 0x6c, 0x05, //  |.g"[l.g"[l.g"[l.|
        0x67, 0x22, 0x5b, 0x6c, 0x05, 0x67, 0x22, 0x5b, 0x6c, 0x05, 0x67, 0x22, 0x5b, 0x6c, 0x05, 0x2c, //  |g"[l.g"[l.g"[l.,|
-       0x65, 0x27, 0x65, 0x5c, 0x27, 0x74, 0x61, 0x62, 0x5c, 0x5c, 0x5c, 0x5c, 0x5c, 0x5c, 0x5c, 0x5c, // -|e'e\'tab\\\\\\\\|
-       0x55, 0x30, 0x30, 0x31, 0x30, 0x33, 0x45, 0x46, 0x45, 0x6c, 0x65, 0x31, 0x5c, 0x27, 0x27,       // -|U00103EFEle1\''|
+       0x31, 0x30, 0x34,                                                                               // +|104|
    },
  }
sql: SELECT
    string_agg(tab_1748."cO̓l1_5"::STRING, tab_1748."cO̓l1_5"::STRING ORDER BY tab_1748."cO̓l1_5"::STRING DESC, tab_1748."cO̓l1_5"::STRING NULLS FIRST)::STRING
        AS col_5536,
    (
        SELECT
            tab_1749.col1_̹1 AS col_5537
        FROM
            defaultdb.public."tab\\U00103EFEle1"@[0] AS tab_1749
        WHERE
            tab_1749.col1_4
        ORDER BY
            col_5537 DESC NULLS LAST
        LIMIT
            1:::INT8
    )
        AS col_5538
FROM
    defaultdb.public."tab\\U00103EFEle1"@[0] AS tab_1748
GROUP BY
    tab_1748."cO̓l1_5", tab_1748.col1_̹1
ORDER BY
    col_5536 DESC NULLS LAST, tab_1748."cO̓l1_5" DESC, col_5538 ASC NULLS FIRST, tab_1748.col1_̹1 DESC
LIMIT
    54:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #126786 roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed [C-test-failure O-roachtest O-robot T-sql-queries branch-release-23.1.24-rc release-blocker]

This test on roachdash | Improve this report!

Jira issue: CRDB-40139

cockroach-teamcity commented 3 months ago

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on release-23.1 @ 4dc8d0460d0f5241b0897d722621e558dcda90d7:

    strings.Join({
        ... // 879 identical bytes
        ``9-09-23 00:00:00+00"},b294:e6ab:54f9:63a2:8fd3:6efe:15d:b6f6/127``,
        ",5248012492544212733,1.234567926047155e-30,0\x16\x0e]``6\x05\x19\x18,\x9e\xe0G\xa2\x02\xc8\xe5ך,1",
+       ".401298464324817",
        "e-45,104,!'d' | !'skbgaz' | 'uo' <-> 'natfn'",
    }, ""),
    strings.Join({
        ... // 286 identical bytes
        `` 14:13:34.000844+00"},b294:e6ab:54f9:63a2:8fd3:6efe:15d:b6f6/127``,
        ",5248012492544212733,1.234567926047155e-30,0\x16\x0e]``6\x05\x19\x18,\x9e\xe0G\xa2\x02\xc8\xe5ך,1",
+       ".401298464324817",
        "e-45,104,!'d' | !'skbgaz' | 'uo' <-> 'natfn'",
    }, ""),
    strings.Join({
        ... // 349 identical bytes
        ``1-01-01 00:00:00+00"},b294:e6ab:54f9:63a2:8fd3:6efe:15d:b6f6/127``,
        ",5248012492544212733,1.234567926047155e-30,0\x16\x0e]``6\x05\x19\x18,\x9e\xe0G\xa2\x02\xc8\xe5ך,1",
+       ".401298464324817",
        "e-45,104,!'d' | !'skbgaz' | 'uo' <-> 'natfn'",
    }, ""),
    "\x19\x7f!\x01,0,Aa,aa1986-11-16 23:10:49.000509+00,-1279518265,aab,0000-0"...,
    "\x19\x7f!\x01,0,Aa,aa1986-11-16 23:10:49.000509+00,-1279518265,aab,0000-0"...,
    ... // 4 identical elements
  }
sql: SELECT
    e'\x19\x7f!\x01':::STRING AS col_2345,
    0:::OID AS col_2346,
    'Aa':::STRING AS col_2347,
    ('aa':::STRING::STRING || '1986-11-16 23:10:49.000509+00':::TIMESTAMPTZ::TIMESTAMPTZ)::STRING AS col_2348,
    (-1279518265):::INT8 AS col_2349,
    'aab':::STRING AS col_2350,
    tab_827.co😰l1_6 AS col_2351,
    tab_827.col1_2 AS col_2352,
    tab_827.colͥ1_7 AS col_2353,
    1.0945600271224976:::FLOAT8 AS col_2354,
    tab_827."col\\U00109A5A1_0" AS col_2355,
    '''ZPAWU'' <-> ''LpirfWV''':::TSQUERY AS col_2356,
    tab_827.col1_5 AS col_2357,
    'b294:e6ab:54f9:63a2:8fd3:6efe:15d:b6f6/127':::INET AS col_2358,
    text(5248012492544212733:::INT8::INT8)::STRING AS col_2359,
    1.234567926047155e-30:::FLOAT8 AS col_2360,
    tab_827."col1%d7_ 18" AS col_2361,
    '\x9ee047a202c8e5d79a':::BYTES AS col_2362,
    tab_827.col1_15 AS col_2363,
    tab_827.tableoid AS col_2364,
    tab_827."coL1_12" AS col_2365
FROM
    defaultdb.public.table1@[0] AS tab_827
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #126786 roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed [C-test-failure O-roachtest O-robot T-sql-queries branch-release-23.1.24-rc release-blocker]

This test on roachdash | Improve this report!

cockroach-teamcity commented 2 months ago

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on release-23.1 @ 4dc8d0460d0f5241b0897d722621e558dcda90d7:

-       "440010100000000000000000044400000000000003E400101000000000000000",
-       "0003440000000000000344001010000000000000000003E40000000000000244",
-       "0",
+       ".8688009977340698,0,01030000000100000006000000DA65568AFED9FBC1F0",
+       "819A7B7EEBD3C1CCE7C5F477C6F6C14E421490CAA0EDC1094A4296642BF0C132",
+       "8B3A2DEEC4FCC10059AB00758AE84140F11FEDA83BCC41E3D5CF34B174FCC108",
+       "3F4490DC66FF41DA65568AFED9FBC1F0819A7B7EEBD3C1",
    }, ""),
    strings.Join({
        "1.2345679020032e+13,1",
-       "e-45,0,010500000008000000010200000002000000E96509420103F2C1505E5",
-       "F7EEB86C2413087BB704F17C8418000A76CA0DDDB41010200000004000000908",
-       "09BBAF48AE541F8F88467729AEC41F09183D0A3DAF2417C34A098E2030042021",
-       "621465EFC01C2B84D2B77FEA2FD414039A45A9105FFC14E8AE8953157F141010",
-       "200000004000000142248FDE8E700C2E6AAC7A7478FFAC1A439F120C468FFC18",
-       "AD27DCB31F8FBC1F0E9E00B985CFA41BD0A67EC42E301C29CD751661D30F5414",
-       "0246D3E13DCA0C101020000000600000004C9C169362DE441B8813C7178D2E9C",
-       "1ECAC1316D847FD41F9D6BFC66318F0C158B1A2CAD8690042E08851DE8BF8C8C",
-       "18AFC08BE5C83F741606E2F2BA899C041E039117EB9F4EE41701E37092901D54",
-       "1003891F73247C54100CA03F0DFC689410102000000040000009442495B8A33F",
-       "4C1559387E1601400C2D08B88AF673FDB41F21C5998393DE2C16C8D7A2E67A7F",
-       "D41C6DB3474AA4CF2C1A0431BA50133F84184DC87DD1F6FE2410102000000020",
-       "000006C84D8FD6EF0EAC1DC17FE3AFF5EF1C190576B80F4D6E4414EEBCE6DF72",
-       "B02C201020000000600000084A2893DB6F9FC417805193E7294EE41D8FB4CB73",
-       "0AAFA41804CAD19AB38FB415C3A5879AA85F5411654AEA7D845004220A93E4A0",
-       "C4ED3C110C9C52EF4730142D4A14AFC04B7E9C1BA0FD7A5D938F0412FDC32B72",
-       "CB001C2A8BEC6670D60D441010200000002000000971B96E0156CF4C1914B272",
-       "B02EE00C2A65F109B4A42E1C12C70DA9F8FBCFB",
+       "234.56787109375,0,01010000C00CCCF0F43782E141A8BC6F48FB2F024284BE",
+       "ADF8166BEBC1D3B54BC0DB36FF",
        ... // 2 identical bytes
    }, ""),
    strings.Join({
        "1.2345679020032e+13,3.4913692",
+       "474365234",
        ",0,010500000000000000",
    }, ""),
    ... // 1 identical element
  }
sql: SELECT
    1.2345679020032e+13:::FLOAT8 AS col_1090,
    tab_370."col
1_5" AS col_1091,
    0:::OID AS col_1092,
    tab_370.col1_1 AS col_1093
FROM
    defaultdb.public."tab""le1"@[0] AS tab_370
WHERE
    (NOT tab_370.col1_0)
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #126786 roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed [C-test-failure O-roachtest O-robot T-sql-queries branch-release-23.1.24-rc release-blocker]

This test on roachdash | Improve this report!

cockroach-teamcity commented 2 months ago

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on release-23.1 @ 196a7779b601980f2932619af5d42832bbf39a63:

        "1997-05-21 00:00:00 +0000 +0000,NaN,$igB,àá,1.",
+       "2611686178923",
        "3",
+       "54",
        "e-44,0",
    }, ""),
    strings.Join({
        "1997-05-29 00:00:00 +0000 +0000,NaN,$igB,àá,1.234567",
-       "9",
+       "8616041472",
        "e+31,0",
    }, ""),
    strings.Join({
        "1997-06-08 00:00:00 +0000 +0000,NaN,$igB,àá,1.2345679",
+       "092739038",
        "e-38,0",
    }, ""),
    strings.Join({
        "1997-06-18 00:00:00 +0000 +0000,NaN,$igB,àá,1.7746559",
+       "381484985",
        ",0",
    }, ""),
    ... // 1 identical and 8 modified elements
  }
sql: SELECT
    tab_9.c😳ol3_2 AS col_16,
    'NaN':::FLOAT8 AS col_17,
    '$igB':::STRING AS col_18,
    e'\u00E0\u00E1':::STRING AS col_19,
    tab_9.col3__3 AS col_20,
    0:::OID AS col_21
FROM
    defaultdb.public."t able3"@[0] AS tab_9
ORDER BY
    tab_9.crdb_internal_mvcc_timestamp ASC NULLS FIRST,
    tab_9.c😳ol3_2 DESC NULLS FIRST,
    col_21 ASC,
    tab_9.col3__3 NULLS FIRST,
    col_16 DESC NULLS FIRST,
    col_19 ASC NULLS LAST,
    col_17 DESC NULLS FIRST,
    tab_9.col3_1 ASC NULLS LAST,
    tab_9.col3_4 ASC NULLS FIRST,
    col_18 ASC,
    tab_9.col3_0 ASC,
    tab_9.tableoid,
    col_20 NULLS FIRST
LIMIT
    39:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #126786 roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed [C-test-failure O-roachtest O-robot T-sql-queries branch-release-23.1.24-rc release-blocker]

This test on roachdash | Improve this report!

cockroach-teamcity commented 2 months ago

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on release-23.1 @ b0ba3c9b33adb4404a2840b66a0ef04c57a1f82f:

(query_comparison_util.go:257).runOneRoundQueryComparison: . 2113 statements run: expected unoptimized and optimized results to be equal
  []string{
    strings.Join({
        "\x01mG\x10H\x1f\n,BOX(-1 -9.99,9.00000001 90.010001),0.30840215",
+       "08693695",
        ",U6u\x16",
    }, ""),
    strings.Join({
        "\x01mG\x10H\x1f\n,BOX(-1 -9.99,99899999999 88799999990.01),1.23456",
-       "8",
+       "79395506094",
        "e+18,U6u\x16",
    }, ""),
    strings.Join({
        "\x01mG\x10H\x1f\n,BOX(0.44 -9.99,0.4400000001234 -9.9899999990766),12.3456",
        "79",
+       "28314209",
        ",U6u\x16",
    }, ""),
    "\x01mG\x10H\x1f\n,NULL,+Inf,U6u\x16",
    "\x01mG\x10H\x1f\n,NULL,0,U6u\x16",
-   "\x01mG\x10H\x1f\n,NULL,1.2345678e-19,U6u\x16",
+   "\x01mG\x10H\x1f\n,NULL,1.234567839717218e-19,U6u\x16",
  }
sql: SELECT
    tab_1794."col%p5_9" AS col_5677,
    tab_1794.col5_3 AS col_5678,
    tab_1794."\\U00096210col5(_14" AS col_5679,
    e'U6u\x16':::STRING AS col_5680
FROM
    defaultdb.public.table5@[0] AS tab_1794
ORDER BY
    tab_1794.co😉l5_16 DESC, tab_1794.crdb_internal_mvcc_timestamp ASC NULLS FIRST, tab_1794.col5_4 DESC
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_fs=ext4
ROACHTEST_localSSD=true
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #126786 roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed [C-test-failure O-roachtest O-robot T-sql-queries branch-release-23.1.24-rc release-blocker]

This test on roachdash | Improve this report!

cockroach-teamcity commented 2 months ago

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on release-23.1 @ 3314a3e81d78361ba4ac45fc52a84efdfb3466ed:

(query_comparison_util.go:257).runOneRoundQueryComparison: . 2718 statements run: expected unoptimized and optimized results to be equal
  []string{
    strings.Join({
        "0000-01-01 00:42:02.019275 +0000 UTC,",
-       "-",
+       "0",
    }, ""),
  }
sql: SELECT
    '00:42:02.019275':::TIME AS col_10228,
    (
        SELECT
            tab_3176."col1_\\u909A5" AS col_10229
        FROM
            defaultdb.public."tab le1"@[0] AS tab_3176
        GROUP BY
            tab_3176.col1_9, tab_3176."col""1_2", tab_3176."col1_\\u909A5", tab_3176.col1_0
        ORDER BY
            col_10229 ASC NULLS LAST
        LIMIT
            1:::INT8
    )
        AS col_10230
ORDER BY
    col_10228 DESC, col_10230 DESC NULLS LAST
LIMIT
    98:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity commented 2 months ago

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on release-23.1 @ 2217d879e7c0687dc6f611cbdd1358e9ff9fc9a3:

    0:::OID AS col_251,
    tab_73.tableoid AS col_252,
    tab_73."c ol2|_4" AS col_253,
    tab_73.col2_8 AS col_254,
    '2002-11-09':::DATE AS col_255,
    tab_73."col \\x362_5" AS col_256,
    tab_73.col2_11 AS col_257,
    tab_73.col2_0 AS col_258,
    e'I\fQ7\x13':::STRING AS col_259,
    tab_73.col2_14 AS col_260,
    tab_73.col2_😣13 AS col_261,
    'Aa':::STRING AS col_262,
    e'l6\x16t_':::STRING AS col_263
FROM
    defaultdb.public.table2@[0] AS tab_73
ORDER BY
    tab_73.col2_10 ASC NULLS LAST,
    col_260 DESC NULLS LAST,
    tab_73."col2_'9" NULLS LAST,
    col_256 DESC NULLS FIRST,
    col_259 DESC NULLS FIRST,
    col_253 DESC,
    col_262 DESC,
    tab_73."col😞2- _3" DESC,
    col_252 ASC NULLS LAST,
    tab_73.col2_11 ASC NULLS FIRST,
    col_254,
    tab_73.col2_6 DESC,
    col_255 DESC,
    tab_73.col2_14 DESC NULLS LAST,
    tab_73.col2_0 DESC NULLS LAST,
    tab_73."c ol2|_4" DESC,
    tab_73.tableoid ASC,
    col_258 ASC,
    tab_73."col2
_2" NULLS LAST,
    tab_73."col \\x362_5" ASC,
    col_263 DESC NULLS FIRST,
    tab_73.col2_😣13 NULLS FIRST,
    tab_73."col\\U000B59122'_1" ASC,
    tab_73."col2\n_̋12" NULLS FIRST,
    tab_73.col2_8 DESC NULLS LAST,
    tab_73.crdb_internal_mvcc_timestamp NULLS LAST,
    col_261 ASC NULLS LAST,
    tab_73.col2_7 DESC NULLS FIRST,
    col_257 DESC NULLS FIRST,
    col_251 ASC NULLS LAST
LIMIT
    75:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity commented 2 months ago

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on release-23.1 @ 2217d879e7c0687dc6f611cbdd1358e9ff9fc9a3:

    }, ""),
    strings.Join({
        "0,\x0e\x16#.y1.,0,2024-05-17 02:34:04.000626 +0000 UTC,-0.599275469779",
        "9683,1.",
-       "9430442",
+       "774192452430725",
    }, ""),
    strings.Join({
        "0,\x0e\x16#.y1.,0,2024-05-17 02:34:04.000626 +0000 UTC,-0.599275469779",
        "9683,1",
-       "23456.79",
+       ".9430441856384277",
    }, ""),
    strings.Join({
        "0,\x0e\x16#.y1.,0,2024-05-17 02:34:04.000626 +0000 UTC,-0.599275469779",
        "9683,1",
-       "e-4",
+       "23456.789062",
        "5",
    }, ""),
    ... // 1 identical element
  }
sql: SELECT
    0:::OID AS col_242,
    tab_90."col'1_3" AS col_243,
    0:::OID AS col_244,
    '2024-05-17 02:34:04.000626+00':::TIMESTAMPTZ AS col_245,
    (-0.5992754697799683):::FLOAT8 AS col_246,
    tab_90."col1_'4" AS col_247
FROM
    defaultdb.public."table\f1"@[0] AS tab_90
WHERE
    st_isclosed('01010000C0C4305538C7B6FDC16EB03729FB6EE8C1007A4B27DF0996C1C8C566A077C700C2':::GEOMETRY::GEOMETRY)::BOOL
ORDER BY
    tab_90.crdb_internal_mvcc_timestamp DESC NULLS FIRST,
    col_245 DESC NULLS FIRST,
    tab_90."co""l1_1" NULLS FIRST,
    col_242 NULLS FIRST,
    tab_90."col'1_3" NULLS FIRST,
    col_244 NULLS LAST,
    tab_90."col1_'4",
    col_247 DESC NULLS LAST,
    tab_90.col1_2 DESC NULLS FIRST,
    tab_90."col""1_0" DESC,
    col_243 ASC NULLS FIRST,
    col_246 ASC NULLS FIRST,
    tab_90.tableoid ASC
LIMIT
    24:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity commented 2 months ago

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on release-23.1 @ 939ce95e6005a82206c7c6c3923a221f82af1e16:

-   "-",
+   "0",
-   "-",
+   "0",
-   "-",
+   "0",
-   "-",
+   "0",
-   "-",
+   "0",
-   "-",
+   "0",
-   "-",
+   "0",
-   "-",
+   "0",
-   "-",
+   "0",
-   "-",
+   "0",
  }
sql: SELECT
    (
        SELECT
            tab_2544.col2_7 AS col_7567
        FROM
            defaultdb.public.table2@[0] AS tab_2544
        ORDER BY
            col_7567 NULLS FIRST
        LIMIT
            1:::INT8
    )
        AS col_7568
FROM
    defaultdb.public.table4@[0] AS tab_2543
WHERE
    (0:::OID IS NOT DISTINCT FROM 0:::OID)
ORDER BY
    col_7568 DESC,
    tab_2543.col4_0 ASC NULLS FIRST,
    tab_2543.col4_3 ASC NULLS FIRST,
    tab_2543.tableoid DESC,
    tab_2543.col4_1 DESC NULLS FIRST,
    tab_2543."c'ol4%_2" NULLS LAST,
    tab_2543.crdb_internal_mvcc_timestamp,
    tab_2543.",'col4_5" DESC,
    tab_2543.col4_4 NULLS FIRST
LIMIT
    80:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_fs=ext4
ROACHTEST_localSSD=true
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity commented 2 months ago

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on release-23.1 @ 7748ab2d671c6e8d021af1ca577d2de4578751db:

    strings.Join({
        "\x04,0,1972-09-27 00:00:00 +0000 +0000,0.4450835,,0104000020E610000",
        "000000000,0.445083",
+       "4989547729",
        "5,2032-01-14 21:23:32.000068 +0000 +0000,[,0",
    }, ""),
    strings.Join({
        "\x04,0,1972-09-27 00:00:00 +0000 +0000,0.44917658,,0104000020E61000",
        "0000000000,0.4491765",
+       "79713",
        "8",
+       "214",
        ",NULL,\x1d,0",
    }, ""),
    strings.Join({
        "\x04,0,1972-09-27 00:00:00 +0000 +0000,0.4614312,,0104000020E610000",
        "000000000,0.4614312",
+       "0527267456",
        ",NULL,L,0",
    }, ""),
    strings.Join({
        "\x04,0,1972-09-27 00:00:00 +0000 +0000,0.4951765,,0104000020E610000",
        "000000000,0.495176",
+       "494121551",
        "5,3000-01-01 00:00:00 +0000 +0000,\x1d,0",
    }, ""),
    strings.Join({
        "\x04,0,1972-09-27 00:00:00 +0000 +0000,0.68460774,,0104000020E61000",
        "0000000000,0.68460774",
+       "4216919",
        ",NULL,a,0",
    }, ""),
    ... // 86 identical and 18 modified elements
  }
sql: SELECT
    e'\x04':::STRING AS col_438,
    0:::OID AS col_439,
    tab_183.col3_6 AS col_440,
    tab_183."co'l3'_0" AS col_441,
    '':::STRING:::NAME AS col_442,
    '0104000020E610000000000000':::GEOGRAPHY AS col_443,
    tab_183.col3_8 AS col_444,
    tab_183.col3_7 AS col_445,
    tab_183.col3_1 AS col_446,
    0:::OID AS col_447
FROM
    defaultdb.public."tabl\\xefe3"@[0] AS tab_183
ORDER BY
    tab_183.tableoid ASC
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_fs=ext4
ROACHTEST_localSSD=true
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity commented 2 months ago

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on release-23.1 @ 7748ab2d671c6e8d021af1ca577d2de4578751db:

+   "0,0,0,0",
-   "-,0,0,0",
+   "0,0,0,0",
-   "-,0,0,0",
+   "0,0,0,0",
-   "-,0,0,0",
+   "0,0,0,0",
-   "-,0,0,0",
+   "0,0,0,0",
-   "-,0,0,0",
+   "0,0,0,0",
-   "-,0,0,0",
+   "0,0,0,0",
-   "-,0,0,0",
+   "0,0,0,0",
-   "-,0,0,0",
+   "0,0,0,0",
-   "-,0,0,0",
+   "0,0,0,0",
  }
sql: SELECT
    (
        SELECT
            tab_1080.col1_0 AS col_2446
        FROM
            defaultdb.public.table1@[0] AS tab_1080
        ORDER BY
            col_2446 ASC
        LIMIT
            1:::INT8
    )
        AS col_2447,
    tab_1078.col1_0 AS col_2448,
    0:::OID AS col_2449,
    tab_1078.col1_0 AS col_2450
FROM
    defaultdb.public.table1 AS tab_1078
    JOIN defaultdb.public.table1 AS tab_1079 ON (tab_1078.col1_1) = (tab_1079.col1_1)
ORDER BY
    tab_1078.col1_0 ASC,
    col_2448 ASC,
    col_2447,
    tab_1079.col1_0 ASC,
    col_2449 NULLS LAST,
    col_2450 NULLS FIRST,
    tab_1078.col1_0 ASC NULLS LAST,
    tab_1079.col1_0 DESC NULLS FIRST
LIMIT
    64:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_fs=ext4
ROACHTEST_localSSD=true
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity commented 2 months ago

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on release-23.1 @ 626804941459fa154cb91e206ae6ccecdbd1ec5a:

+       "41062927",
        ",BOX(10.999 1.1,20.999000010000003 101.10000099999999),125.4.5.7",
        "2/22",
    }, ""),
    strings.Join({
        "!'gUWHRmS' | 'VUjRdI' <-> 'sHAtex',1.234567",
-       "9",
+       "8605116651",
        "e+38,BOX(10.999 1.1,20.999000010000003 101.10000099999999),125.4",
        ".5.72/22",
    }, ""),
    strings.Join({
        "!'hyFMb',1.23456",
-       "8",
+       "7936",
        "e+09,BOX(10.999 1.1,20.999000010000003 101.10000099999999),125.4",
        ".5.72/22",
    }, ""),
    strings.Join({
        "!'i' <-> 'E' <-> !'JEHUG',1.2345679",
+       "0528",
        "e+11,BOX(10.999 1.1,20.999000010000003 101.10000099999999),125.4",
        ".5.72/22",
    }, ""),
    strings.Join({
        "!'jv',1.2345679",
+       "154391251",
        "e+28,BOX(10.999 1.1,20.999000010000003 101.10000099999999),125.4",
        ".5.72/22",
    }, ""),
    strings.Join({
        "!'lqojmH' | !'zS' <-> 'KiycPm' <-> 'azcZZ' & 'dk',1.234567",
+       "87",
        "9",
+       "027381",
        "e-31,BOX(10.999 1.1,20.999000010000003 101.10000099999999),125.4",
        ".5.72/22",
    }, ""),
    ... // 18 identical and 89 modified elements
  }
sql: SELECT
    tab_235."c%ol\\u7AE11\\U00017B90_0" AS col_746,
    tab_235."c o""l1_15" AS col_747,
    'BOX(10.999 1.1,20.999000010000003 101.10000099999999)':::BOX2D AS col_748,
    '125.4.5.72/22':::INET AS col_749
FROM
    defaultdb.public.table1@[0] AS tab_235
WHERE
    EXISTS(SELECT ARRAY[1352:::INT8,16696:::INT8,4:::INT8] AS col_745 FROM defaultdb.public."t able2"@[0] AS tab_236)
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity commented 2 months ago

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on release-23.1 @ 626804941459fa154cb91e206ae6ccecdbd1ec5a:

        "2:11.442338",
    }, ""),
    strings.Join({
        "0.8543465",
+       "13748169",
        ",\x1a,64,216.48.169.189/10,aab,\x1eZKY\x11Z(qs,\x1c[n\b,-41 years -10 mons -6",
        "5 days -21:52:11.442338",
    }, ""),
    strings.Join({
        "0.8664537",
-       "7",
+       "668228149",
        ",\x1a,64,708a:8e9c:4f45:e926:1db6:94a6:1799:b202/105,aab,\x1eZKY\x11Z(qs,",
        "NULL,-41 years -10 mons -65 days -21:52:11.442338",
    }, ""),
    strings.Join({
        "0.8999168",
+       "276786804",
        ",\x1a,64,1:ef:ef:1:ef:1:1:ef/0,aab,\x16,ci%*0axnb,-41 years -10 mons -",
        "65 days -21:52:11.442338",
    }, ""),
    strings.Join({
        "0.919003",
-       "5",
+       "4866333008",
        ",\x1a,64,a:ef:ef:a:ef:a:a:ef/0,aab,\x1eZKY\x11Z(qs,NULL,-41 years -10 mon",
        "s -65 days -21:52:11.442338",
    }, ""),
    strings.Join({
        "0.9972757",
+       "69",
        "7",
+       "105408",
        ",\x1a,64,87.26.94.94/29,aab,\x16,NULL,-41 years -10 mons -65 days -21:",
        "52:11.442338",
    }, ""),
    ... // 1 identical and 38 modified elements
  }
sql: SELECT
    tab_14.col1_9 AS col_53,
    e'\x1a':::STRING:::NAME AS col_54,
    64:::INT8 AS col_55,
    tab_14."col1 _0" AS col_56,
    'aab':::STRING AS col_57,
    tab_14.col1_10 AS col_58,
    tab_14.co͏l1_🙃12 AS col_59,
    '-41 years -10 mons -65 days -21:52:11.442338':::INTERVAL AS col_60
FROM
    defaultdb.public.table1@[0] AS tab_14
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity commented 1 month ago

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on release-23.1 @ 728b77ac299edb18515c606e945d96945c1d4ce8:

    strings.Join({
        "P,\x17f,0,0.835169",
+       "37",
        "4",
+       "9427795",
        ",f682:8c85:19a1:1914:84a5:5236:cbe2:817a/83,aaaaaa",
    }, ""),
    strings.Join({
        "P,\x17f,0,0.8375904",
+       "5",
        "6",
+       "0089111",
        ",d2c1:4623:30be:eeee:4ce2:5632:f086:b857/46,aaaaaa",
    }, ""),
    strings.Join({
        "P,\x17f,0,0.866871",
-       "2",
+       "178150177",
        ",1:4d:4d:1:4d:1:1:4d/0,aaaaaa",
    }, ""),
    strings.Join({
        "P,\x17f,0,0.9399654",
+       "269218445",
        ",37.32.163.180/7,aaaaaa",
    }, ""),
    strings.Join({
        "P,\x17f,0,0.974274",
-       "3",
+       "2776870728",
        ",502c:27d9:dae2:e90e:d9c:313e:bada:87a2/48,aaaaaa",
    }, ""),
    strings.Join({
        "P,\x17f,0,0.984883",
+       "7",
        "8",
+       "52478027",
        ",b1e0:8a5e:dc19:6fec:6b6a:606a:bcf1:4be6/24,aaaaaa",
    }, ""),
    ... // 4 identical and 123 modified elements
  }
sql: SELECT
    tab_1518."co""l3_%v11" AS col_4595,
    e'\x17f':::STRING AS col_4596,
    0:::OID AS col_4597,
    tab_1518."çOl3_10" AS col_4598,
    tab_1518.col3_7 AS col_4599,
    'aaaaaa':::STRING AS col_4600
FROM
    defaultdb.public.table3@[0] AS tab_1518
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

mgartner commented 1 month ago

I hid a bunch of comments above that were duplicates of #128296 and #118273. I'll check out the remaining two failures.

mgartner commented 1 month ago

The artifacts from the first failure are no longer available.

This failure above is a duplicate of #128296, so I'll close this issue.