roachtest: schemachange/mixed-versions failed [debug doctor using wrong jobs table]

[cockroach-teamcity]

roachtest.schemachange/mixed-versions failed with artifacts on release-24.1 @ 26d7bea76ca80f98b8aa20ac25266256735e366f:

(mixedversion.go:592).Run: mixed-version test failure while running step 6 (run "run schemachange workload and validation in mixed version"): full command output in run_062808.826061842_n4_COCKROACHRANDOMSEED3.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 P-1 T-sql-foundations branch-master]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-38648

[cockroach-teamcity]

roachtest.schemachange/mixed-versions failed with artifacts on release-24.1 @ 26d7bea76ca80f98b8aa20ac25266256735e366f:

(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_062348.264857792_n4_COCKROACHRANDOMSEED2.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 P-1 T-sql-foundations branch-master]

This test on roachdash | Improve this report!

[cockroach-teamcity]

roachtest.schemachange/mixed-versions failed with artifacts on release-24.1 @ 0cf3fc716870f66ea00844f88a030e6242afa8cf:

(mixedversion.go:594).Run: mixed-version test failure while running step 27 (run "run schemachange workload and validation after upgrade has finalized"): full command output in run_063602.950404454_n4_cockroach-debug-doct.log: COMMAND_PROBLEM: exit status 125
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 [functions cannot have more than 100 arguments] #124390 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-master release-blocker]

This test on roachdash | Improve this report!

[rafiss]

run_063602.950404454_n4_cockroach-debug-doct: 06:36:02 cluster.go:2370: > ./cockroach debug doctor examine cluster --url {pgurl:1}
Examining 513 descriptors and 353 namespace entries...
  ParentID 183, ParentSchemaID 619: relation "table_w4_460" (879): mutation job 970597778631163908: job 970597778631163908 not found
Examining 1149 jobs...
ERROR: validation failed
Failed running "debug docto

this should be fixed by #124424 (cc @annrpom )

[annrpom]

closing this failure on release-24.1 since #124302 merged