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

Open

#175,689 opened on Sep 20, 2026 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

branch-release-25.2 C-test-failure O-roachtest O-robot O-rsg release-blocker T-sql-queries

Dominant language: Go
Stars: 32.5k
Forks: 4.1k
PR merge metrics: PR metrics pending

Description

roachtest.unoptimized-query-oracle/disable-rules=half/rand-multi-region failed with artifacts on release-25.2 @ 93f8bc11a6d27f53075496a4a9e72d5fca7de124:

(query_comparison_util.go:419).runOneRoundQueryComparison: internal error while running optimized statement. 131 statements run: pq: internal error: @1 IS DISTINCT FROM NULL: could not identify a comparison function for family "RefCursorFamily"
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-multi-region/run_1

Parameters:

arch=amd64
cloud=gce
coverageBuild=false
cpu=4
diskCount=0
encrypted=false
metamorphicBufferedSender=false
runtimeAssertionsBuild=false

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

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

Jira issue: CRDB-68575

Contributor guide

Open the contributing guide

First steps

Read the whole issue, then the project's contributing guide.
Comment on the issue to say you are picking it up — it saves two people doing the same work.
Fork the repository and make your change on a branch.
Open a pull request that references the issue number.

Research direction

Start at query_comparison_util.go:419 and inspect the linked test artifacts and logs for the optimized statement that produces the RefCursorFamily comparison error. The work is done when the underlying cause is fixed and unoptimized-query-oracle/disable-rules=half/rand-multi-region passes again.

Written by the indexing model from the issue text.

Assessment

Tech stack: go, sql
Domain: databases, testing-qa
Issue type: Bug
Difficulty: 4/5
Estimated time: 3-5 days
Activity status: Active
Clarity: Needs clarification
Newbie friendliness: 35/100

A short digest of beginner-friendly GitHub issues.