cockroachdb / cockroachdb/cockroach

pkg/sql/logictest/tests/fakedist/fakedist_test: TestLogic_row_level_security failed

Open
#173,864 2 comments 0 reactions 0 assignees View on GitHub
branch-master C-test-failure O-robot T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

pkg/sql/logictest/tests/fakedist/fakedist_test.TestLogic_row_level_security [failed](https://mesolite.cluster.engflow.com/invocations/default/ed47ea57-3af7-461d-9332-bd61fe08af53?testReportRun=2&testReportShard=32&testReportAttempt=1#targets-Ly9wa2cvc3FsL2xvZ2ljdGVzdC90ZXN0cy9mYWtlZGlzdDpmYWtlZGlzdF90ZXN0) on master @ [889c09024fa5aea5b9c994899ac2fc0da6f3a62d](https://github.com/cockroachdb/cockroach/commits/889c09024fa5aea5b9c994899ac2fc0da6f3a62d):

```
=== RUN TestLogic_row_level_security
test_log_scope.go:172: test logs captured to: outputs.zip/logTestLogic_row_level_security3482649986
test_log_scope.go:82: use -show-logs to present logs inline
test_server_shim.go:146: using test tenant configuration from testserver factory defaults
test_server_shim.go:150: cluster virtualization disabled due to issue: #156124 (expected label: C-bug)
[12:00:18] setting distsql_workmem='35234B';
[12:58:53] --- done: /mnt/engflow/worker/work/0/exec/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/fakedist/fakedist_test_/fakedist_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/row_level_security with config fakedist: 1390 tests, 1 failures
[13:00:07] --- total progress: 1390 statements
--- total: 1390 tests, 1 failures
logic.go:5123: -- test log scope end --
test logs left over in: outputs.zip/logTestLogic_row_level_security3482649986
--- FAIL: TestLogic_row_level_security (3602.50s)
=== RUN TestLogic_row_level_security/createdb_pg_roles_pg_authid
[12:58:14] --- progress: /mnt/engflow/worker/work/0/exec/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/fakedist/fakedist_test_/fakedist_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/row_level_security: 1389 statements
[12:58:25] --- progress: /mnt/engflow/worker/work/0/exec/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/fakedist/fakedist_test_/fakedist_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/row_level_security: 1390 statements
logic.go:2590:

/mnt/engflow/worker/work/0/exec/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/fakedist/fakedist_test_/fakedist_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/row_level_security:6046:
expected success, but found
(XXUUU) count-sessions-holding-stale-descriptor: context canceled
internal.go:1287: in 1()
--- FAIL: TestLogic_row_level_security/createdb_pg_roles_pg_authid (59.60s)
```

Parameters:
- attempt=1
- race=true
- run=2
- shard=32
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-67160

Contributor guide

Open the contributing guide

Research direction

Start with pkg/sql/logictest/tests/fakedist/fakedist_test and the row_level_security logic testdata, rerunning TestLogic_row_level_security with the reported race configuration. Inspect the captured logs around row_level_security:6046 and the count-sessions-holding-stale-descriptor error; done means the createdb_pg_roles_pg_authid case passes without the context-canceled failure.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sql
Domain
databases, distributed-systems, testing
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.