configprofiles: TestProfilesValidSQL failed

[cockroach-teamcity]

configprofiles.TestProfilesValidSQL failed with artifacts on release-23.2 @ 5ea15dd5013f703712ba26ccbd5542884cfc4e0b:

	GOROOT/src/sync/once.go:65
github.com/cockroachdb/cockroach/pkg/server.startListenRPCAndSQL.func5()
	github.com/cockroachdb/cockroach/pkg/server/start_listen.go:150 +0x79
github.com/cockroachdb/cockroach/pkg/util/stop.CloserFn.Close(0xc013235f78?)
	github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:102 +0x12
github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).AddCloser(0xc00e7e6630, {0x7b1f5c0?, 0xc012f3db00})
	github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:263 +0xcc
github.com/cockroachdb/cockroach/pkg/server.startListenRPCAndSQL({_, _}, {_, _}, {0xc00cb46000, 0xc014e03540, 0xc01d49b200, 0xc01e514d20, 0xc010e8a180, 0xc00b2db050, ...}, ...)
	github.com/cockroachdb/cockroach/pkg/server/start_listen.go:165 +0xada
github.com/cockroachdb/cockroach/pkg/server.(*SQLServerWrapper).PreStart(0xc019bb8200, {0x7b6fb90?, 0xc012f3d8f0})
	github.com/cockroachdb/cockroach/pkg/server/tenant.go:576 +0x276
github.com/cockroachdb/cockroach/pkg/server.(*tenantServerWrapper).preStart(0x0?, {0x7b6fb90?, 0xc012f3d8f0?})
	github.com/cockroachdb/cockroach/pkg/server/server_controller.go:169 +0x25
github.com/cockroachdb/cockroach/pkg/server.(*channelOrchestrator).startControlledServer.func5.2(0xc0171c8390, 0xc0074bf440, 0xc01e63d8b0?, 0xc01681bc90, {0x7b6fb90, 0xc001b54180}, 0x3fc3333333333333?, 0xc0073e5e60?)
	github.com/cockroachdb/cockroach/pkg/server/server_controller_channel_orchestrator.go:377 +0x11f
github.com/cockroachdb/cockroach/pkg/server.(*channelOrchestrator).startControlledServer.func5({0xc006563000?, 0xc00e1dc840?})
	github.com/cockroachdb/cockroach/pkg/server/server_controller_channel_orchestrator.go:390 +0x5eb
github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx.func2()
	github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:479 +0x13a
created by github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx in goroutine 8753348
	github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:470 +0x415
Other goroutines holding locks:
goroutine 55 lock 0xc0173869e0
github.com/cockroachdb/cockroach/pkg/util/admission/grant_coordinator.go:734 admission.(*GrantCoordinator).CPULoad ??? <<<<<
github.com/cockroachdb/cockroach/pkg/util/admission/grant_coordinator.go:733 admission.(*GrantCoordinator).CPULoad ???
github.com/cockroachdb/cockroach/pkg/util/goschedstats/runnable.go:236 goschedstats.(*schedStatsTicker).getStatsOnTick ???
github.com/cockroachdb/cockroach/pkg/util/goschedstats/runnable.go:166 goschedstats.init.0.func1 ???



=== RUN   TestProfilesValidSQL/virtual+app+sharedservice+repl/2/create_virtual_cluster_template
    profiles_test.go:56: txn statement: CREATE VIRTUAL CLUSTER template
    profiles_test.go:56: txn statement: ALTER VIRTUAL CLUSTER template GRANT ALL CAPABILITIES
    profiles_test.go:56: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_scatter.enabled = true
    profiles_test.go:56: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_split.enabled = true
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice/1/initial_cluster_config
    profiles_test.go:47: non-txn statement: SET CLUSTER SETTING trace.redact_at_virtual_cluster_boundary.enabled = false
    profiles_test.go:47: non-txn statement: SET CLUSTER SETTING sql.virtual_cluster.feature_access.zone_configs.enabled = true
    profiles_test.go:47: non-txn statement: SET CLUSTER SETTING sql.virtual_cluster.feature_access.zone_configs_unrestricted.enabled = true
    profiles_test.go:47: non-txn statement: SET CLUSTER SETTING sql.virtual_cluster.feature_access.multiregion.enabled = true
    profiles_test.go:47: non-txn statement: SET CLUSTER SETTING spanconfig.range_coalescing.system.enabled = false
    profiles_test.go:47: non-txn statement: SET CLUSTER SETTING spanconfig.range_coalescing.application.enabled = false
    profiles_test.go:47: non-txn statement: SET CLUSTER SETTING sql.drop_virtual_cluster.enabled = false
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice/2/create_virtual_cluster_template
    profiles_test.go:56: txn statement: CREATE VIRTUAL CLUSTER template
    profiles_test.go:56: txn statement: ALTER VIRTUAL CLUSTER template GRANT ALL CAPABILITIES
    profiles_test.go:56: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_scatter.enabled = true
    profiles_test.go:56: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_split.enabled = true
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice/3/use_the_application_virtual_cluster_template_by_default_in_CREATE_VIRTUAL_CLUSTER
    profiles_test.go:47: non-txn statement: SET CLUSTER SETTING sql.create_virtual_cluster.default_template = 'template'

Parameters:

• TAGS=bazel,gss,deadlock
• stress=true

Help

See also: How To Investigate a Go Test Failure (internal)

/cc @cockroachdb/server

This test on roachdash | Improve this report!

Jira issue: CRDB-45799