sql/tests: stress: TestMonotonicInserts failed due to contention #92540
Description
sql/tests.TestMonotonicInserts failed with artifacts on release-22.2 @ fd133ba3af3954c93584a501cf68dfa3131e586c:
=== RUN TestMonotonicInserts
--- FAIL: TestMonotonicInserts (18.79s)
=== RUN TestMonotonicInserts/distsql=off
test_log_scope.go:161: test logs captured to: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestMonotonicInserts_distsql=off2833529335
test_log_scope.go:79: use -show-logs to present logs inline
monotonic_insert_test.go:186: *crdb.MaxRetriesExceededError: retrying txn failed after 50 attempts. original error: pq: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): "sql txn" meta={id=baa48bd2 key=/Table/106/1/817509944182505475/0 pri=0.04263162 epo=0 ts=1669554635.892981882,1 min=1669554635.857152263,0 seq=1} lock=true stat=PENDING rts=1669554635.857152263,0 wto=false gul=1669554636.357152263,0.
monotonic_insert_test.go:239: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestMonotonicInserts_distsql=off2833529335
--- FAIL: TestMonotonicInserts/distsql=off (9.35s)
Parameters: TAGS=bazel,gss
Same failure on other branches
- sql/tests: TestMonotonicInserts failed #92461 sql/tests: TestMonotonicInserts failed [C-test-failure O-robot T-sql-queries branch-master]
This test on roachdash | Improve this report!
Jira issue: CRDB-21847