pkg/sql/logictest/tests/3node-tenant/3node-tenant_test: TestLogic_crdb_internal_tenant failed

pkg/sql/logictest/tests/3node-tenant/3node-tenant_test.TestLogic_crdb_internal_tenant failed with artifacts on master @ 6ca2bac2989e7c037f7853a7a69333097c769372:

[06:42:55] SELECT * FROM crdb_internal.node_sessions WHERE node_id < 0;
[06:42:55] 	-- OK;
[06:42:55] SELECT * FROM crdb_internal.cluster_sessions WHERE node_id < 0;
[06:42:55] 	-- OK;
[06:42:55] SELECT * FROM crdb_internal.node_contention_events WHERE table_id < 0;
[06:42:55] 	-- OK;
[06:42:55] SELECT * FROM crdb_internal.cluster_contention_events WHERE table_id < 0;
[06:42:55] 	-- OK;
[06:42:55] SELECT * FROM crdb_internal.builtin_functions WHERE function = '';
[06:42:55] 	-- OK;
[06:42:55] SELECT * FROM crdb_internal.create_statements WHERE database_name = '';
[06:42:55] 	-- OK;
[06:42:55] SELECT * FROM crdb_internal.table_columns WHERE descriptor_name = '';
[06:42:55] 	-- OK;
[06:42:55] SELECT * FROM crdb_internal.table_indexes WHERE descriptor_name = '';
[06:42:55] 	-- OK;
[06:42:55] SELECT * FROM crdb_internal.index_columns WHERE descriptor_name = '';
[06:42:55] 	-- OK;
[06:42:55] SELECT * FROM crdb_internal.backward_dependencies WHERE descriptor_name = '';
[06:42:55] 	-- OK;
[06:42:55] SELECT * FROM crdb_internal.forward_dependencies WHERE descriptor_name = '';
[06:42:55] 	-- OK;
[06:42:55] SELECT * FROM crdb_internal.zones WHERE false;
[06:42:55] 	-- OK;
[06:42:55] SELECT * FROM crdb_internal.node_inflight_trace_spans WHERE span_id < 0;
[06:42:55] 	-- OK;
[06:42:55] SELECT * FROM crdb_internal.cluster_execution_insights WHERE query = '';
[06:42:55] 	-- OK;
[06:42:55] SELECT * FROM crdb_internal.node_execution_insights WHERE query = '';
[06:42:55] 	-- OK;
[06:42:55] SELECT * FROM crdb_internal.cluster_txn_execution_insights WHERE query = '';
[06:42:55] 	-- FAIL
    logic.go:3491: 
         
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3719/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/3node-tenant/3node-tenant_test_/3node-tenant_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/crdb_internal_tenant:241: SELECT * FROM crdb_internal.cluster_txn_execution_insights WHERE query = ''
        expected:
            txn_id  txn_fingerprint_id  query  implicit_txn  session_id  start_time  end_time  user_name  app_name  rows_read  rows_written  priority  retries  last_retry_reason  contention  problems  causes  stmt_execution_ids  cpu_sql_nanos  last_error_code  last_error_redactable status
            
        but found (query options: "colnames") :
            txn_id                                txn_fingerprint_id               query  implicit_txn  session_id                        start_time                            end_time                                user_name  app_name  rows_read  rows_written  priority  retries  last_retry_reason  contention  problems         causes               stmt_execution_ids                  cpu_sql_nanos  last_error_code  last_error_redactable  status
            d2d797b9-ad9e-4caa-90fb-b3abc0a8f195  [72 124 247 196 107 102 61 215]  ·      true          18d6a5c6959feee70000000000000001  2026-09-19 06:42:54.8317 +0000 +0000  2026-09-19 06:42:55.086791 +0000 +0000  root       ·         0          0             normal    0        NULL               00:00:00    {SlowExecution}  {HighCommitLatency}  {18d6a5c6b7c748110000000000000001}  24914310       NULL             ·                      Completed
            
[06:42:55] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3719/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/3node-tenant/3node-tenant_test_/3node-tenant_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/crdb_internal_tenant with config 3node-tenant: 44 tests, 1 failures

    logic.go:4953: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3719/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/3node-tenant/3node-tenant_test_/3node-tenant_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/crdb_internal_tenant:246: error while processing
    logic.go:4953: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3719/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/3node-tenant/3node-tenant_test_/3node-tenant_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/crdb_internal_tenant:246: too many errors encountered, skipping the rest of the input
    panic.go:694: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/210896a19478658c9daca7b553b0282a/logTestLogic_crdb_internal_tenant471162408
--- FAIL: TestLogic_crdb_internal_tenant (9.28s)

Jira issue: CRDB-68558

Start with pkg/sql/logictest/tests/3node-tenant/3node-tenant_test and the testdata/logic_test/crdb_internal_tenant input, especially the query around line 241. Run TestLogic_crdb_internal_tenant and compare the expected empty result with the returned cluster_txn_execution_insights row; done means the test passes consistently and the failure cause is addressed.