cockroachdb / cockroachdb/cockroach
pkg/sql/sqlstats/insights/integration/integration_test: TestFailedInsights failed
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
pkg/sql/sqlstats/insights/integration/integration_test.TestFailedInsights [failed](https://mesolite.cluster.engflow.com/invocations/default/4191afe3-a742-4f74-b800-acd2f3812927?testReportRun=2&testReportShard=1&testReportAttempt=1#targets-Ly9wa2cvc3FsL3NxbHN0YXRzL2luc2lnaHRzL2ludGVncmF0aW9uOmludGVncmF0aW9uX3Rlc3Q=) on master @ [a96c513d8e167b3b9311d5e414a310b622b61cd2](https://github.com/cockroachdb/cockroach/commits/a96c513d8e167b3b9311d5e414a310b622b61cd2):
```
=== RUN TestFailedInsights
test_log_scope.go:172: test logs captured to: outputs.zip/logTestFailedInsights3562607524
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.
insights_test.go:576: -- test log scope end --
test logs left over in: outputs.zip/logTestFailedInsights3562607524
--- FAIL: TestFailedInsights (132.50s)
=== RUN TestFailedInsights/with_redaction=true
insights_test.go:466:
Error Trace: pkg/sql/sqlstats/insights/integration/insights_test.go:466
pkg/testutils/subtest.go:23
Error: Received unexpected error:
pq: internal error while retrieving user account memberships: operation "get-user-session" timed out after 10s (given timeout 10s): interrupted during singleflight lookup role membership:refreshMembershipCache-2: context deadline exceeded
Test: TestFailedInsights/with_redaction=true
--- FAIL: TestFailedInsights/with_redaction=true (83.22s)
```
Parameters:
- attempt=1
- race=true
- run=2
- shard=1
Help
See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)
/cc @cockroachlabs/obs-prs
[Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)
Jira issue: CRDB-68368
Contributor guide
Research direction
Start with pkg/sql/sqlstats/insights/integration/insights_test.go, especially TestFailedInsights and the failure at line 466, then rerun the test with the reported race and shard parameters. Inspect the linked invocation and captured TestFailedInsights logs, including the test_server_shim.go guidance. Done means the integration test completes without the get-user-session membership timeout.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, sql
- Domain
- database, testing
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100