multitenant: Investigate tests which fail when run using the default test tenant #76378
Description
A change was made with #76582 to enable all tests which leverage testServer/testCluster to run with some probability in multi-tenant mode. In doing so, several tests were found to fail or hang when run under multi-tenant mode.
This issue serves as a meta-issue outlining the current - as of October 2025 - state. Some issues in the list below are about package-level skips, others are test-specific, and all issues are grouped by the owning team.
CDC:
- changefeedccl: investigate why TestSQLSink does not work with a shared process virtual cluster #112863
- package-level skip of
changefeedccl/tablesetpkg/ccl/changefeedccl: investigate enabling secondary test tenants #142799
DB server:
- POTENTIAL BUG pgwire: investigate TestAuthenticationAndHBARules with test tenants #107310
- server/application_api: TestAdminAPINonTableStats does not work with secondary tenants #110012
- authccl: investigate why TestAuthenticationAndHBARules does not work with a shared process virtual cluster #112949
- cli: investigate why TestZipJobTrace does not work with a shared process virtual cluster #112950
- server: investigate why TestStatusVarsTxnMetrics does not work with a shared process virtual cluster #112953
- server: investigate why TestStatusGetFiles does not work with a shared process virtual cluster #112956
- serverutils: specify cluster settings and capabilities for default test tenant #113187
- testserver: propagate settings' overrides into shared-process multi-tenant #113916
- package-level skip server: investigate failures when enabling test tenants #156304
DR:
- backupccl: TestIngest does not work with secondary tenants #107812
- helper-level skip crosscluster/logical: some tests hang when run in a secondary tenant. #127241
- pkg/backup: investigate enabling test tenants in tests #142798
- POTENTIAL BUG kv/bulk: investigate failure on TestSSTBatcherPipelinedFlush with test tenants #156329
- package-level skip jobs: investigate failures when enabling test tenants #156331
Foundations:
- sql: make TestDropFunction work with test tenant #107322
- sql: adjust TestNumRangesInSpanContainedBy to work with test tenant #107376
- ttljob: adjust all tests to work with test tenant #109391
- sql/instancestorage: TestRefreshSession tries to use logic that is not copacetic #109410
- spanconfigmanager: TestReconciliationJobIsIdle fails to work when pointed at a virtual cluster #109457
- sql: investigate why catalog Lease tests do not work with a shared process virtual cluster #112957
- sql: investigate why TestPGTest/large_input does not work with a shared process virtual cluster #112960
- sql: TestCreateObjectConcurrency does not work with secondary tenants #138733
- sql: enable external-mode tenant testing for
TestUnsplitRanges#142388 - helper-level skip schemachanger: investigate enabling test tenants in
SingleNodeTestClusterFactory.Run. #142814 - sql-foundations: investigate skipped tests under test tenant #156127
KV:
- package-level skip kv: investigate failures when enabling test tenants #156327
- sql: investigate occasional failures in
TestReacquireLeaseOnRestartwith test tenants #156333
Observability:
- multi-tenant: Enable tenant testing on admin API #81590
- server:
TestAdminAPIEventstakes too long to run in external-process mode #142381 - observability: investigate skipped tests under test tenant #156145
Security:
- security: HTTP cert tests fail with secondary tenants #109498
- security: TestRotateCerts fails when pointed to a secondary tenant #110007
Queries:
- sql: figure out how to populate range cache in secondary tenants #108763
- package-level skip logictest: decide whether we want test tenant randomization #156124
- sql: investigate why TestPrepareInExplicitTransactionDoesNotDeadlock fails with external-process mode #156146
- multiregionccl: investigate TestMultiRegionDataDriven* with test tenants #156305
- helper-level skip multiregionccl: investigate failures with test tenant when using the cluster creation helper #156308
Upgrades (Foundations?):
- upgrades: exercise TestPauseMigration for secondary tenants #107393
- upgrades: exercise TestConcurrentMigrationAttempts with secondary tenants #107395
- upgrades: exercise TestAlreadyRunningJobsAreHandledProperly with secondary tenants #107396
- upgrades: exercise TestPrecondition with secondary tenants #107397
- package-level skip upgrades: investigate failures when enabling test tenants #156332
Benchmarks:
Jira issue: CRDB-13093