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.96k stars 3.79k forks source link

roachtest: unoptimized-query-oracle/disable-rules=all/rand-tables failed #123123

Closed cockroach-teamcity closed 5 months ago

cockroach-teamcity commented 5 months ago

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

+       "0",
        ",�,1 mon 8 days 277777:46:40.000111,fe5efe5e-fe5e-fe5e-fe5e-fe",
        "5efe5efe5e",
    }, ""),
    strings.Join({
-       "-",
+       "0",
        ",�,1 mon 8 days 277777:46:40.000111,fe5efe5e-fe5e-fe5e-fe5e-fe",
        "5efe5efe5e",
    }, ""),
    strings.Join({
-       "-",
+       "0",
        ",�,1 mon 8 days 277777:46:40.000111,fe5efe5e-fe5e-fe5e-fe5e-fe",
        "5efe5efe5e",
    }, ""),
    strings.Join({
-       "-",
+       "0",
        ",�,1 mon 8 days 277777:46:40.000111,fe5efe5e-fe5e-fe5e-fe5e-fe",
        "5efe5efe5e",
    }, ""),
    strings.Join({
-       "-",
+       "0",
        ",�,1 mon 8 days 277777:46:40.000111,fe5efe5e-fe5e-fe5e-fe5e-fe",
        "5efe5efe5e",
    }, ""),
  }
sql: SELECT
    (
        SELECT
            tab_517."col̾""2_8" AS col_1574
        FROM
            defaultdb.public."t(able2"@[0] AS tab_516
            FULL JOIN defaultdb.public."t(able2"@[0] AS tab_517 ON (tab_516.col2_14) = (tab_517."col""2_16")
        ORDER BY
            col_1574 DESC NULLS LAST
        LIMIT
            1:::INT8
    )
        AS col_1575,
    e'\xef\xbf\xbd':::STRING:::NAME AS col_1576,
    '1 mon 8 days 277777:46:40.000111':::INTERVAL AS col_1577,
    'fe5efe5e-fe5e-fe5e-fe5e-fe5efe5efe5e':::UUID AS col_1578
FROM
    defaultdb.public."tabl'e1"@[0] AS tab_515
ORDER BY
    tab_515."coL1_0" NULLS FIRST
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/rand-tables/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #122817 roachtest: unoptimized-query-oracle/disable-rules=all/rand-tables failed [C-test-failure O-roachtest O-robot O-rsg T-sql-queries branch-master release-blocker] - #122788 roachtest: unoptimized-query-oracle/disable-rules=all/rand-tables failed [C-test-failure O-roachtest O-robot O-rsg T-sql-queries branch-release-23.2]

This test on roachdash | Improve this report!

Jira issue: CRDB-38209

yuzefovich commented 5 months ago

dup of #118273