bench: BenchmarkOrderBy fails with liveness session expired #96336
Description
BenchmarkOrderBy/SharedProcessTenantCockroach/count=100000/limit=10
BenchmarkOrderBy/SharedProcessTenantCockroach/count=100000/limit=10/distinct=false
bench_test.go:849: error executing 'DROP TABLE IF EXISTS bench.sort': pq: liveness session expired 1m48.770406s before transaction
--- FAIL: BenchmarkOrderBy/SharedProcessTenantCockroach/count=100000/limit=10/distinct=false
BenchmarkOrderBy/SharedProcessTenantCockroach/count=100000/limit=10/distinct=true
bench_test.go:852: error executing 'CREATE TABLE bench.sort (k INT PRIMARY KEY, v INT, w INT)': pq: liveness session expired 1m48.814375s before transaction
bench_test.go:849: error executing 'DROP TABLE IF EXISTS bench.sort': pq: liveness session expired 1m48.81459s before transaction
--- FAIL: BenchmarkOrderBy/SharedProcessTenantCockroach/count=100000/limit=10/distinct=true
--- FAIL: BenchmarkOrderBy/SharedProcessTenantCockroach/count=100000/limit=10
--- FAIL: BenchmarkOrderBy/SharedProcessTenantCockroach/count=100000
--- FAIL: BenchmarkOrderBy/SharedProcessTenantCockroach
Error:
bench_test.go:849: error executing 'DROP TABLE IF EXISTS bench.sort': pq: liveness session expired 1m48.81459s before transaction
Notes:
The benchmark only fails when running with a low cpu count (or I presume on a slow machine as well), I set it to -test.cpu 1.
To Reproduce:
./dev bench pkg/bench -f=BenchmarkOrderBy --ignore-cache --bench-time=1s --verbose --stream-output --timeout 10m --test-args="-test.failfast -test.cpu 1"
Jira issue: CRDB-24075