sql: TestTrackOnlyUserOpenTransactionsAndActiveStatements failed

[cockroach-teamcity]

sql.TestTrackOnlyUserOpenTransactionsAndActiveStatements failed with artifacts on release-23.2.3-rc @ f4c2eb53ede2622071ec05ce72de77da7b4e5a7b:

=== RUN   TestTrackOnlyUserOpenTransactionsAndActiveStatements
    test_log_scope.go:170: test logs captured to: /artifacts/tmp/_tmp/d07d02991d5ddeff08ff06650d30220a/logTestTrackOnlyUserOpenTransactionsAndActiveStatements2859412533
    test_log_scope.go:81: use -show-logs to present logs inline
    test_server_shim.go:146: cluster virtualization disabled in global scope due to issue: #76378 (expected label: C-bug)
    conditional_wrap.go:190: 
        pkg/sql_test/pkg/sql/conn_executor_test.go:1685: (TestTrackOnlyUserOpenTransactionsAndActiveStatements)
        	NOTICE: .SQLServer() called via implicit interface ApplicationLayerInterface;
        HINT: consider using .ApplicationLayer().SQLServer() instead.
    conditional_wrap.go:194: TIP: consider replacing the test server initialization from:
            ts, ... := serverutils.StartServer(t, ...)
            defer ts.Stopper().Stop(...)
        to:
            srv, ... := serverutils.StartServer(t, ...)
            defer srv.Stopper().Stop(...)
            ts := srv.ApplicationLayer()
        
        See also: https://go.crdb.dev/p/testserver-and-cluster-virtualization
    conn_executor_test.go:1738: condition failed to evaluate within 45s: from conn_executor_test.go:1753: Wrong InternalSQLActiveStatements value. Expected: 2. Actual: 0
    panic.go:523: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d07d02991d5ddeff08ff06650d30220a/logTestTrackOnlyUserOpenTransactionsAndActiveStatements2859412533
--- FAIL: TestTrackOnlyUserOpenTransactionsAndActiveStatements (46.43s)

Help

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

Same failure on other branches

• sql: TestTrackOnlyUserOpenTransactionsAndActiveStatements failed #120042 sql: TestTrackOnlyUserOpenTransactionsAndActiveStatements failed [C-test-failure O-robot P-2 T-sql-foundations branch-release-23.1]
• sql: TestTrackOnlyUserOpenTransactionsAndActiveStatements failed #119829 sql: TestTrackOnlyUserOpenTransactionsAndActiveStatements failed [C-test-failure O-robot P-2 T-sql-foundations branch-release-23.2]
• sql: TestTrackOnlyUserOpenTransactionsAndActiveStatements failed #119494 sql: TestTrackOnlyUserOpenTransactionsAndActiveStatements failed [C-test-failure O-robot P-2 T-sql-foundations branch-master]

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-36563

[rafiss]

re-opening until backport is done

[rafiss]

This branch is no longer active