sql: tests in the package time out under race

[yuzefovich]

Build

=== RUN   TestVisibilityDuringPrimaryKeyChange
    test_log_scope.go:161: test logs captured to: /artifacts/tmp/_tmp/b287de7194e17a0386ee1775f0d198ba/logTestVisibilityDuringPrimaryKeyChange1273361120
    test_log_scope.go:79: use -show-logs to present logs inline
panic: test timed out after 59m55s

Jira issue: CRDB-19264

[Xiang-Gu]

@yuzefovich Hi Yahor, do you know how I might be able reproduce this issue?

I ran this test on Master with --stress --race for over an hour and over 3000 runs but still didn't catch it.

[yuzefovich]

Interesting. Maybe the problem is that it takes longer than an hour to run all tests in sql package together? It seems likely given that there are only two goroutines that have been running for more than minute in the dump.

[yuzefovich]

Indeed, I think it's the sql package timing out under race - I saw another timeout here, and it stopped on a different test, after TestVisibilityDuringPrimaryKeyChange completed.

[yuzefovich]

It seems like it's the time to break up at least the tests in sql package, but in the mean time I asked whether we can increase the timeout.

[yuzefovich]

Should be fixed by #87474.