search

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=all/rand-tables failed #129855

Open cockroach-teamcity opened 1 month ago

cockroach-teamcity commented 1 month ago

roachtest.unoptimized-query-oracle/disable-rules=all/rand-tables failed with artifacts on release-23.2.10-rc @ 456de6170f2bc7af940df456a4470a665624c4b3:

+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
+   "\"ztczenqsc\",2244,NULL,\x01,2023-09-01 01:46:40.000111 +0000 +0000,-106,51 years 8 mons 257 days 19:56:47.924919",
    ... // 137094 identical, 5582 removed, 5551 inserted, and 2201 modified elements
  }
sql: SELECT
    tab_41."col\\U000167C02_12" AS col_104,
    regprocedure(tab_40.col1_4::INT8)::REGPROCEDURE AS col_105,
    tab_40.col1_2 AS col_106,
    e'\x01':::STRING AS col_107,
    (tab_41.col2_7::INTERVAL + '1990-12-21':::DATE::DATE)::TIMESTAMP AS col_108,
    (-106):::INT8 AS col_109,
    '51 years 8 mons 257 days 19:56:47.924919':::INTERVAL AS col_110
FROM
    defaultdb.public.table4 AS tab_38
    JOIN defaultdb.public.table3 AS tab_39 ON (tab_38."c'ol4_1") = (tab_39."cOl3_0")
    JOIN defaultdb.public.table1@[0] AS tab_40 ON
            (tab_38."c'ol4_1") = (tab_40."col1_'5") AND (tab_39."cOl3_0") = (tab_40."col1_'5")
    JOIN defaultdb.public."t'abl%35e2"@[0] AS tab_41 ON (tab_40."col1_'5") = (tab_41.col2_5)
ORDER BY
    tab_40."""
col1'_6" 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

- #129463 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]

This test on roachdash | Improve this report!

Jira issue: CRDB-41736

mw5h commented 6 days ago

Reduction finished in a couple of days, but it's still 220K.

reduce-129855.zip