roachtest: schemachange/mixed-versions failed [ltree is not supported]

[cockroach-teamcity]

roachtest.schemachange/mixed-versions failed with artifacts on master @ b02bf5dafd2ab20233511b485fcadff53227819d:

(mixedversion.go:896).Run: mixed-version test failure while running step 12 (run "run schemachange workload and validation in mixed version"): full command output in run_143237.945613578_n4_COCKROACHRANDOMSEED9.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

• arch=amd64
• cloud=gce
• coverageBuild=false
• cpu=4
• encrypted=false
• mvtDeploymentMode=shared-process
• mvtVersions=v25.3.2 → v25.4.0-alpha.2-dev-b02bf5dafd2ab20233511b485fcadff53227819d (master)
• runtimeAssertionsBuild=false
• ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

• roachtest: schemachange/mixed-versions failed ["depends-on relation is dropped" during DROP SCHEMA CASCADE] #154133 roachtest: schemachange/mixed-versions failed [ltree in mixed version state] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-25.4 sync-me]
• roachtest: schemachange/mixed-versions failed [index_key_decoding_error] #153016 roachtest: schemachange/mixed-versions failed [index_key_decoding_error] [B-runtime-assertions-enabled C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-24.3]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-55055

[fqazi]

We need to avoid ltree being used until 25.4

 "message": "***UNEXPECTED ERROR; Received an unexpected execution error.: ERROR: ltree[] not supported until version 25.4 (SQLSTATE 0A000)",

Specifically from: ALTER TABLE public.table_w2_235 ALTER COLUMN col235_w2_236 SET DEFAULT ARRAY[]:::LTREE[]::LTREE[]

[rafiss]

See #151755 and #152170 -- we previously tried to avoid using ltree in a mixed version but it looks like we missed something.