roachtest: schemachange/mixed-versions failed

[cockroach-teamcity]

roachtest.schemachange/mixed-versions failed with artifacts on release-23.2.5-rc @ 7619662fe855e6d266329de1c6ac6b4473e20805:

(mixedversion.go:592).Run: mixed-version test failure while running step 8 (run "run schemachange workload and validation in mixed version"): full command output in run_062058.107787833_n4_COCKROACHRANDOMSEED4.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

• ROACHTEST_arch=amd64
• ROACHTEST_cloud=gce
• ROACHTEST_coverageBuild=false
• ROACHTEST_cpu=4
• ROACHTEST_encrypted=false
• ROACHTEST_metamorphicBuild=false
• ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

• roachtest: schemachange/mixed-versions failed [debug doctor validation failed with "job not found"] #122956 roachtest: schemachange/mixed-versions failed [debug doctor validation failed with "job not found"] [C-test-failure O-roachtest O-robot T-sql-foundations branch-master]
• roachtest: schemachange/mixed-versions failed [descriptor ID generator unavailable, migration in progress] #122350 roachtest: schemachange/mixed-versions failed [descriptor ID generator unavailable, migration in progress] [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.1]
• roachtest: schemachange/mixed-versions failed [enum removal not yet in 23.2 release] #121411 roachtest: schemachange/mixed-versions failed [enum removal not yet in 23.2 release] [C-test-failure O-roachtest O-robot P-1 T-sql-foundations branch-release-24.1]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-38309

[rafiss]

 "message": "***UNEXPECTED ERROR; Failed to generate a random operation: Collect: CollectRows: \"WITH \\\"descriptors\\\" AS (SELECT\\n\\t\\tdescriptor.id,\\n\\t\\t\\\"parentSchemaID\\\" AS schema_id,\\n\\t\\tnamespace.name AS name,\\n\\t\\tcrdb_internal.pb_to_json('desc', descriptor) AS descriptor\\n\\tFROM system.descriptor\\n\\tJOIN system.namespace ON namespace.id = descriptor.id\\n\\tWHERE \\\"parentID\\\" = (SELECT id FROM system.namespace WHERE name = current_database() AND \\\"parentID\\\" = 0)\\n\\t),\\n\\\"enums\\\" AS (SELECT id, schema_id, name, descriptor-\u003e'type' AS descriptor FROM descriptors WHERE descriptor ? 'type'),\\n\\\"enum_members\\\" AS (SELECT *, jsonb_array_elements(descriptor-\u003e'enumMembers') AS member FROM enums)\\nSELECT\\n\\t\\t\\t\\tquote_ident(schema_id::REGNAMESPACE::TEXT) || '.' || quote_ident(name) AS name,\\n\\t\\t\\t\\tquote_literal(member-\u003e\u003e'logicalRepresentation') AS value,\\n\\t\\t\\t\\tCOALESCE(member-\u003e\u003e'direction' = 'REMOVE', false) AS dropping,\\n\\t\\t\\t\\tCOALESCE(json_array_length(descriptor-\u003e'referencingDescriptorIds') \u003e 0, false) AS has_references\\n\\t\\t\\tFROM enum_members\\n\\t\" []: ERROR: internal error: attempting to append refresh spans after the tracked timestamp has moved forward. batchTimestamp: 1714544468.436209178,0 refreshedTimestamp: 1714544468.503653156,1 (SQLSTATE XX000)",

dupe of #122274