```
[07:38:23] CREATE TENANT othertenant LIKE system;
[07:38:23] CREATE TENANT tmpl;
ALTER TENANT tmpl GRANT CAPABILITY can_view_node_info; -- will be copied
ALTER TENANT tmpl SET CLUSTER SETTING trace.debug.enable = true; -- will be copied
-- Simulate resource limits. Will be copied.
-- Note: we cannot use the update_tenant_resource_limits() builtin
-- directly here because it can only be used from a CCL binary.
INSERT INTO system.tenant_usage(
tenant_id, instance_id, next_instance_id, last_update,
ru_burst_limit, ru_refill_rate, ru_current, current_share_sum, total_consumption)
VALUES ((SELECT id FROM system.tenants WHERE name = 'tmpl'), 0, 0, now(),
11, 22, 33, 44, ''::BYTES);
ALTER TENANT tmpl START SERVICE SHARED; -- will not be copied.;
[07:38:23] CREATE TENANT othertenant LIKE tmpl;
[07:38:23] SHOW TENANT othertenant;
[07:38:23] -- OK;
[07:38:23] SELECT capability_name, capability_value FROM [SHOW TENANT tmpl WITH CAPABILITIES]
EXCEPT SELECT capability_name, capability_value FROM [SHOW TENANT othertenant WITH CAPABILITIES];;
[07:38:23] -- OK;
[07:38:23] SELECT variable, value, type, origin FROM [SHOW CLUSTER SETTINGS FOR TENANT othertenant]
WHERE origin != 'no-override';
[07:38:23] -- OK;
[07:38:23] SELECT instance_id, next_instance_id,
ru_burst_limit, ru_refill_rate, ru_current,
current_share_sum, length(total_consumption)
FROM system.tenant_usage WHERE tenant_id = (SELECT id FROM system.tenants WHERE name = 'othertenant');
[07:38:23] -- OK;
[07:38:23] DROP TENANT othertenant;
[07:38:24] SET CLUSTER SETTING sql.create_tenant.default_template = 'nonexistent';;
[07:38:24] CREATE TENANT othertenant;
[07:38:24] SET CLUSTER SETTING sql.create_tenant.default_template = 'tmpl';;
[07:38:24] CREATE TENANT othertenant;
[07:38:24] SHOW TENANT othertenant;
[07:38:24] -- OK;
[07:38:24] SELECT capability_name, capability_value FROM [SHOW TENANT tmpl WITH CAPABILITIES]
EXCEPT SELECT capability_name, capability_value FROM [SHOW TENANT othertenant WITH CAPABILITIES];;
[07:38:24] -- OK;
[07:38:24] SELECT variable, value, type, origin FROM [SHOW CLUSTER SETTINGS FOR TENANT othertenant]
WHERE origin != 'no-override';
[07:38:24] -- OK;
[07:38:24] SELECT instance_id, next_instance_id,
ru_burst_limit, ru_refill_rate, ru_current,
current_share_sum, length(total_consumption)
FROM system.tenant_usage WHERE tenant_id = (SELECT id FROM system.tenants WHERE name = 'othertenant');
[07:38:24] -- OK;
[07:38:24] DROP TENANT othertenant;
ALTER TENANT tmpl STOP SERVICE;
DROP TENANT tmpl;
[07:38:25] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/4232/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/fakedist/fakedist_test_/fakedist_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/tenant: 94 statements
[07:38:25] RESET CLUSTER SETTING sql.create_tenant.default_template;
```
Help
See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)
pkg/sql/logictest/tests/fakedist/fakedist_test.TestLogic_tenant failed with artifacts on master @ 678cfd4cbebbf3cced16747baf42a4c54cb2a92d:
Fatal error:
Stack:
Log preceding fatal error
``` [07:38:23] CREATE TENANT othertenant LIKE system; [07:38:23] CREATE TENANT tmpl; ALTER TENANT tmpl GRANT CAPABILITY can_view_node_info; -- will be copied ALTER TENANT tmpl SET CLUSTER SETTING trace.debug.enable = true; -- will be copied -- Simulate resource limits. Will be copied. -- Note: we cannot use the update_tenant_resource_limits() builtin -- directly here because it can only be used from a CCL binary. INSERT INTO system.tenant_usage( tenant_id, instance_id, next_instance_id, last_update, ru_burst_limit, ru_refill_rate, ru_current, current_share_sum, total_consumption) VALUES ((SELECT id FROM system.tenants WHERE name = 'tmpl'), 0, 0, now(), 11, 22, 33, 44, ''::BYTES); ALTER TENANT tmpl START SERVICE SHARED; -- will not be copied.; [07:38:23] CREATE TENANT othertenant LIKE tmpl; [07:38:23] SHOW TENANT othertenant; [07:38:23] -- OK; [07:38:23] SELECT capability_name, capability_value FROM [SHOW TENANT tmpl WITH CAPABILITIES] EXCEPT SELECT capability_name, capability_value FROM [SHOW TENANT othertenant WITH CAPABILITIES];; [07:38:23] -- OK; [07:38:23] SELECT variable, value, type, origin FROM [SHOW CLUSTER SETTINGS FOR TENANT othertenant] WHERE origin != 'no-override'; [07:38:23] -- OK; [07:38:23] SELECT instance_id, next_instance_id, ru_burst_limit, ru_refill_rate, ru_current, current_share_sum, length(total_consumption) FROM system.tenant_usage WHERE tenant_id = (SELECT id FROM system.tenants WHERE name = 'othertenant'); [07:38:23] -- OK; [07:38:23] DROP TENANT othertenant; [07:38:24] SET CLUSTER SETTING sql.create_tenant.default_template = 'nonexistent';; [07:38:24] CREATE TENANT othertenant; [07:38:24] SET CLUSTER SETTING sql.create_tenant.default_template = 'tmpl';; [07:38:24] CREATE TENANT othertenant; [07:38:24] SHOW TENANT othertenant; [07:38:24] -- OK; [07:38:24] SELECT capability_name, capability_value FROM [SHOW TENANT tmpl WITH CAPABILITIES] EXCEPT SELECT capability_name, capability_value FROM [SHOW TENANT othertenant WITH CAPABILITIES];; [07:38:24] -- OK; [07:38:24] SELECT variable, value, type, origin FROM [SHOW CLUSTER SETTINGS FOR TENANT othertenant] WHERE origin != 'no-override'; [07:38:24] -- OK; [07:38:24] SELECT instance_id, next_instance_id, ru_burst_limit, ru_refill_rate, ru_current, current_share_sum, length(total_consumption) FROM system.tenant_usage WHERE tenant_id = (SELECT id FROM system.tenants WHERE name = 'othertenant'); [07:38:24] -- OK; [07:38:24] DROP TENANT othertenant; ALTER TENANT tmpl STOP SERVICE; DROP TENANT tmpl; [07:38:25] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/4232/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/fakedist/fakedist_test_/fakedist_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/tenant: 94 statements [07:38:25] RESET CLUSTER SETTING sql.create_tenant.default_template; ```
Help
See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)
/cc @cockroachdb/sql-queries
This test on roachdash | Improve this report!
Jira issue: CRDB-26942