roachtest: tpchvec/direct_scans failed

[cockroach-teamcity]

roachtest.tpchvec/direct_scans failed with artifacts on master @ 559994e230ac3776dd1188e66678cce9205ab345:

(tpchvec.go:527).runTPCHVec: pq: internal error: restoring 8 TableDescriptors from 0 databases: restoring table desc and namespace entries: relation "region" (106): constraint ID was missing for constraint "primary"
test artifacts and logs in: /artifacts/tpchvec/direct_scans/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

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-36497

[mgartner]

@rafiss Do you think #119947 could have cause these failures—at a glace it seems related to RESTORE which this error message points to:

pq: internal error: restoring 8 TableDescriptors from 0 databases:
  restoring table desc and namespace entries:
    relation "region" (106):
      constraint ID was missing for constraint "primary"

[rafiss]

This one was actually caused by #120008

@stevendanna realized that some tests are using backups that are multiple years old, which is something that CRDB no longer officially supports.

[mgartner]

Should we revert #120008 until we can fix those tests to silence these errors?

[rafiss]

See the discussion here: https://cockroachlabs.slack.com/archives/C023S0V4YEB/p1709912020888919?thread_ts=1709896031.584779&cid=C023S0V4YEB