Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sql: TestCancelQueryPermissions failed #53584

Closed
cockroach-teamcity opened this issue Aug 28, 2020 · 2 comments
Closed

sql: TestCancelQueryPermissions failed #53584

cockroach-teamcity opened this issue Aug 28, 2020 · 2 comments
Assignees
@solongordon
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot.
Milestone
20.2

Comments

@cockroach-teamcity
Copy link
Member

(sql).TestCancelQueryPermissions failed on master@e43acc9b020fa117d5ca10249f6108602061e346:

  github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:116 +0xe5e
  github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execPortal()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:205 +0x3d4
  github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1504 +0x1646
  github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1377 +0x486
  github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).initConnEx.func1()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/internal.go:175 +0x8e

Goroutine 1094 (running) created at:
  google.golang.org/grpc.(*Server).serveStreams.func1()
      /go/src/github.com/cockroachdb/cockroach/vendor/google.golang.org/grpc/server.go:744 +0xb8
  google.golang.org/grpc/internal/transport.(*http2Server).operateHeaders()
      /go/src/github.com/cockroachdb/cockroach/vendor/google.golang.org/grpc/internal/transport/http2_server.go:442 +0x16a6
  google.golang.org/grpc/internal/transport.(*http2Server).HandleStreams()
      /go/src/github.com/cockroachdb/cockroach/vendor/google.golang.org/grpc/internal/transport/http2_server.go:483 +0x459
  google.golang.org/grpc.(*Server).serveStreams()
      /go/src/github.com/cockroachdb/cockroach/vendor/google.golang.org/grpc/server.go:742 +0x19a
  google.golang.org/grpc.(*Server).handleRawConn.func1()
      /go/src/github.com/cockroachdb/cockroach/vendor/google.golang.org/grpc/server.go:703 +0x4c

Goroutine 3841 (running) created at:
  github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).initConnEx()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/internal.go:174 +0x595
  github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).execInternal()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/internal.go:446 +0x7ee
  github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).queryInternal()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/internal.go:241 +0x14f
  github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).QueryEx()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/internal.go:216 +0x14f
  github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).QueryRowEx()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/internal.go:271 +0x14f
  github.com/cockroachdb/cockroach/pkg/sql.retrieveUserAndPassword.func3()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/user.go:114 +0x1ce
  github.com/cockroachdb/cockroach/pkg/util/contextutil.RunWithTimeout()
      /go/src/github.com/cockroachdb/cockroach/pkg/util/contextutil/context.go:135 +0xdd
  github.com/cockroachdb/cockroach/pkg/sql.retrieveUserAndPassword.func2()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/user.go:106 +0x76
  github.com/cockroachdb/cockroach/pkg/sql.retrieveUserAndPassword()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/user.go:111 +0x39d
  github.com/cockroachdb/cockroach/pkg/sql.GetUserHashedPassword()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/user.go:84 +0x21b
  github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).handleAuthentication()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/auth.go:86 +0xd5
  github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync.func1()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:560 +0x21e
==================
FAIL	github.com/cockroachdb/cockroach/pkg/sql	1020.165s
More

Parameters:

  • GOFLAGS=-json
make stressrace TESTS=TestCancelQueryPermissions PKG=./pkg/sql TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

See this test on roachdash
powered by pkg/cmd/internal/issues
@cockroach-teamcity cockroach-teamcity added branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. labels Aug 28, 2020
@cockroach-teamcity cockroach-teamcity added this to the 20.2 milestone Aug 28, 2020
rytaft added a commit to rytaft/cockroach that referenced this issue Aug 28, 2020
@rytaft
sql: skip TestCancelQueryPermissions
2196971 
Refs: cockroachdb#53584

Reason: flaky test

Generated by bin/skip-test.

Release justification: non-production code changes

Release note: None
@rytaft rytaft mentioned this issue Aug 28, 2020
Merged
craig bot pushed a commit that referenced this issue Aug 28, 2020
@rafiss @rytaft
Merge #53582 #53587
123ca07 
53582: roachtest: add expected passes to PGJDBC tests r=rafiss a=rafiss

Release justification: test-only change
Release note: None

53587: sql: skip TestCancelQueryPermissions r=rytaft a=rytaft

Refs: #53584

Reason: flaky test

Generated by bin/skip-test.

Release justification: non-production code changes

Release note: None

Co-authored-by: Rafi Shamim <rafi@cockroachlabs.com>
Co-authored-by: Rebecca Taft <becca@cockroachlabs.com>
@cockroach-teamcity
Copy link
Member Author

(sql).TestCancelQueryPermissions failed on master@60e3bb6a06b307fbab0aea3dd69f9778da9666d7:

  github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:116 +0xe5e
  github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execPortal()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:205 +0x3d4
  github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1504 +0x1646
  github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1377 +0x486
  github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).initConnEx.func1()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/internal.go:175 +0x8e

Goroutine 1440 (running) created at:
  google.golang.org/grpc.(*Server).serveStreams.func1()
      /go/src/github.com/cockroachdb/cockroach/vendor/google.golang.org/grpc/server.go:744 +0xb8
  google.golang.org/grpc/internal/transport.(*http2Server).operateHeaders()
      /go/src/github.com/cockroachdb/cockroach/vendor/google.golang.org/grpc/internal/transport/http2_server.go:442 +0x16a6
  google.golang.org/grpc/internal/transport.(*http2Server).HandleStreams()
      /go/src/github.com/cockroachdb/cockroach/vendor/google.golang.org/grpc/internal/transport/http2_server.go:483 +0x459
  google.golang.org/grpc.(*Server).serveStreams()
      /go/src/github.com/cockroachdb/cockroach/vendor/google.golang.org/grpc/server.go:742 +0x19a
  google.golang.org/grpc.(*Server).handleRawConn.func1()
      /go/src/github.com/cockroachdb/cockroach/vendor/google.golang.org/grpc/server.go:703 +0x4c

Goroutine 1045 (running) created at:
  github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).initConnEx()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/internal.go:174 +0x595
  github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).execInternal()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/internal.go:446 +0x7ee
  github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).queryInternal()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/internal.go:241 +0x14f
  github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).QueryEx()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/internal.go:216 +0x14f
  github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).QueryRowEx()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/internal.go:271 +0x14f
  github.com/cockroachdb/cockroach/pkg/sql.retrieveUserAndPassword.func3()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/user.go:114 +0x1ce
  github.com/cockroachdb/cockroach/pkg/util/contextutil.RunWithTimeout()
      /go/src/github.com/cockroachdb/cockroach/pkg/util/contextutil/context.go:135 +0xdd
  github.com/cockroachdb/cockroach/pkg/sql.retrieveUserAndPassword.func2()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/user.go:106 +0x76
  github.com/cockroachdb/cockroach/pkg/sql.retrieveUserAndPassword()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/user.go:111 +0x39d
  github.com/cockroachdb/cockroach/pkg/sql.GetUserHashedPassword()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/user.go:84 +0x21b
  github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).handleAuthentication()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/auth.go:86 +0xd5
  github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync.func1()
      /go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:560 +0x21e
==================
FAIL	github.com/cockroachdb/cockroach/pkg/sql	1324.755s
More

Parameters:

  • GOFLAGS=-json
make stressrace TESTS=TestCancelQueryPermissions PKG=./pkg/sql TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

See this test on roachdash
powered by pkg/cmd/internal/issues

@solongordon
Copy link
Contributor

Fixed by #53574

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@solongordon solongordon

Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot.
Projects
None yet
Milestone
20.2
Development

No branches or pull requests
2 participants
@solongordon @cockroach-teamcity