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.88k stars 3.77k forks source link

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

Open cockroach-teamcity opened 2 weeks ago

cockroach-teamcity commented 2 weeks ago

Note: This build has runtime assertions enabled. If the same failure was hit in a run without assertions enabled, there should be a similar issue without the B-runtime-assertions-enabled label. If there isn't one, then this failure is likely due to an assertion violation or (assertion) timeout.

roachtest.unoptimized-query-oracle/disable-rules=all/rand-tables failed with artifacts on master @ 8551145a0c99c4c95a28ec470e699d0c20ca97ab:

(query_comparison_util.go:419).runOneRoundQueryComparison: internal error while running optimized statement. 2242 statements run: pq: internal error: left-join-apply RelExpr children have intersecting columns: (20)
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

This test on roachdash | Improve this report!

Jira issue: CRDB-41826

cockroach-teamcity commented 1 week ago

Note: This build has runtime assertions enabled. If the same failure was hit in a run without assertions enabled, there should be a similar issue without the B-runtime-assertions-enabled label. If there isn't one, then this failure is likely due to an assertion violation or (assertion) timeout.

roachtest.unoptimized-query-oracle/disable-rules=all/rand-tables failed with artifacts on master @ fa9c0528fc0d06be1b4cfc534ec0501448111fbe:

(query_comparison_util.go:419).runOneRoundQueryComparison: internal error while running optimized statement. 1405 statements run: pq: internal error: left-join-apply RelExpr children have intersecting columns: (28)
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

This test on roachdash | Improve this report!

michae2 commented 1 week ago

Looks like a dupe of #129467, but I'll leave this open until we fix it, since I expect this to keep failing and re-opening daily.

michae2 commented 6 days ago

P-2 since this is somewhat frequent.

cockroach-teamcity commented 5 days ago

Note: This build has runtime assertions enabled. If the same failure was hit in a run without assertions enabled, there should be a similar issue without the B-runtime-assertions-enabled label. If there isn't one, then this failure is likely due to an assertion violation or (assertion) timeout.

roachtest.unoptimized-query-oracle/disable-rules=all/rand-tables failed with artifacts on master @ 1b0a374fd2a101cebcfb24cff4b3b57795ad1df6:

(query_comparison_util.go:419).runOneRoundQueryComparison: internal error while running optimized statement. 1733 statements run: pq: internal error: left-join-apply RelExpr children have intersecting columns: (65)
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

This test on roachdash | Improve this report!

cockroach-teamcity commented 2 days ago

Note: This build has runtime assertions enabled. If the same failure was hit in a run without assertions enabled, there should be a similar issue without the B-runtime-assertions-enabled label. If there isn't one, then this failure is likely due to an assertion violation or (assertion) timeout.

roachtest.unoptimized-query-oracle/disable-rules=all/rand-tables failed with artifacts on master @ 5cc8013ada42f9ea03eda661a4f178c141f4f24d:

(query_comparison_util.go:419).runOneRoundQueryComparison: . 1193 statements run: expected unoptimized and optimized results to be equal
  []string{
    ... // 47 identical elements
    "1",
    "1",
-   "1",
  }
sql: SELECT
    count(*) AS col_1225
FROM
    defaultdb.public."ta ble_1" AS tab_402
WHERE
    st_coveredby('0103000020E6100000020000000500000000000000000000000000000000000000000000000000F03F0000000000000000000000000000F03F000000000000F03F0000000000000000000000000000F03F00000000000000000000000000000000050000009A9999999999C93F9A9999999999C93F9A9999999999C93F9A9999999999D93F9A9999999999D93F9A9999999999D93F9A9999999999D93F9A9999999999C93F9A9999999999C93F9A9999999999C93F':::GEOGRAPHY::GEOGRAPHY, tab_402.col1_5::GEOGRAPHY)::BOOL
GROUP BY
    tab_402."col,1_3", tab_402.col1_7, tab_402.col1_8
ORDER BY
    col_1225 DESC NULLS FIRST, tab_402."col,1_3", tab_402.col1_8, tab_402.col1_7 ASC NULLS FIRST
LIMIT
    74:::INT8
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)

Grafana is not yet available for azure clusters

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 day ago

Note: This build has runtime assertions enabled. If the same failure was hit in a run without assertions enabled, there should be a similar issue without the B-runtime-assertions-enabled label. If there isn't one, then this failure is likely due to an assertion violation or (assertion) timeout.

roachtest.unoptimized-query-oracle/disable-rules=all/rand-tables failed with artifacts on master @ 3f8226eb7f09eb93c26dda4cd47e023a8f56ea23:

(query_comparison_util.go:419).runOneRoundQueryComparison: internal error while running optimized statement. 2409 statements run: pq: internal error: left-join-apply RelExpr children have intersecting columns: (22)
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

This test on roachdash | Improve this report!