cockroachdb / cockroachdb/cockroach
pkg/sql/unsafesql/unsafesql_test: [timeout] TestViewOverSystemTable failed
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
pkg/sql/unsafesql/unsafesql_test.TestViewOverSystemTable [failed](https://mesolite.cluster.engflow.com/invocations/default/2ae95962-ebbc-441f-a517-0d12760b3cbd?testReportRun=1&testReportShard=1&testReportAttempt=1#targets-Ly9wa2cvc3FsL3Vuc2FmZXNxbDp1bnNhZmVzcWxfdGVzdA==) on master @ [61e8d82a116c6abe7d91e47e27b8cd874c60184f](https://github.com/cockroachdb/cockroach/commits/61e8d82a116c6abe7d91e47e27b8cd874c60184f):
```
=== RUN TestViewOverSystemTable
test_log_scope.go:172: test logs captured to: outputs.zip/logTestViewOverSystemTable123672796
test_log_scope.go:82: use -show-logs to present logs inline
test_server_shim.go:168: automatically injected an external process virtual cluster under test; see comment at top of test_server_shim.go for details.
unsafesql_test.go:392: -- test log scope end --
test logs left over in: outputs.zip/logTestViewOverSystemTable123672796
--- FAIL: TestViewOverSystemTable (200.14s)
=== RUN TestViewOverSystemTable/testuser
unsafesql_test.go:365: error executing query="SELECT * FROM pg_catalog.pg_description LIMIT 1" args=[]: pq: internal error while retrieving user account memberships: operation "get-user-session" timed out after 10s (given timeout 10s): interrupted during singleflight load-value:/global/-1: context deadline exceeded
--- FAIL: TestViewOverSystemTable/testuser (10.82s)
```
Parameters:
- attempt=1
- race=true
- run=1
- shard=1
Help
See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)
[Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)
Jira issue: CRDB-67440
Contributor guide
Research direction
Start by reading pkg/sql/unsafesql/unsafesql_test.go around TestViewOverSystemTable, especially the testuser case near lines 365-392. Reproduce the failure with the race-enabled test and inspect the test_server_shim.go guidance and captured logs. Done means TestViewOverSystemTable completes without the get-user-session timeout.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, sql
- Domain
- databases, testing
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Active
- Clarity
- Needs clarification
- Newbie friendliness
- 45/100