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-multi-region failed #129467

Open cockroach-teamcity opened 3 weeks ago

cockroach-teamcity commented 3 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-multi-region failed with artifacts on master @ 18c4e23306bb99cc28c83bb3e5726f6f4279b798:

(query_comparison_util.go:419).runOneRoundQueryComparison: internal error while running optimized statement. 444 statements run: pq: internal error: left-join-apply RelExpr children have intersecting columns: (55)
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/rand-multi-region/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

Jira issue: CRDB-41656

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-multi-region failed with artifacts on master @ 3ab493e264e790d18ee80a3ae013eca00a023fa4:

(query_comparison_util.go:419).runOneRoundQueryComparison: internal error while running unoptimized statement. 242 statements run: pq: internal error: error decoding 9 bytes: unable to decode table key: RECORD
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/rand-multi-region/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

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-multi-region failed with artifacts on master @ dafb6dd507b38fb3d6eb8b7e2493c7b8abed34d2:

(query_comparison_util.go:419).runOneRoundQueryComparison: internal error while running optimized statement. 418 statements run: pq: internal error: left-join-apply RelExpr children have intersecting columns: (43)
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/rand-multi-region/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

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-multi-region failed with artifacts on master @ fa9c0528fc0d06be1b4cfc534ec0501448111fbe:

(query_comparison_util.go:419).runOneRoundQueryComparison: internal error while running optimized statement. 223 statements run: pq: internal error: left-join-apply RelExpr children have intersecting columns: (29)
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/rand-multi-region/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

michae2 commented 5 days ago

If we can't find a repro from these failures, there might be an easy one from #129956 or #129992.

michae2 commented 4 days ago

P-2 since this is somewhat frequent.