multitenant: investigate which tests fail when running a shared process virtual cluster #112857
Description
This PR introduces a change that probabilistically decides between running a shared process virtual cluster or an external process virtual cluster if the test virtual cluster is running. Several of the tests that currently work with an external process virtual cluster do not work with a shared process virtual cluster. This issue tracks all of these cases so that they can be investigated.
Remaining tests that disable a shared process test virtual cluster as a probabilistic mode:
- pkg/ccl/changefeedccl
- pkg/ccl/sqlproxyccl
- pkg/ccl/testccl/authccl
- pkg/ccl/testccl/sqlccl
- pkg/cli
- pkg/server/application_api
- pkg/server/debug
- pkg/server/storage_api
- pkg/sql/catalog/lease
- pkg/sql/pgwire
Jira issue: CRDB-32645