sql/pgwire: TestAuthenticationAndHBARules failed

[cockroach-teamcity]

sql/pgwire.TestAuthenticationAndHBARules failed with artifacts on master @ bca0e6cc184be2838468d52733ac3adfbe451a36:

=== RUN   TestAuthenticationAndHBARules
--- FAIL: TestAuthenticationAndHBARules (56.96s)
=== RUN   TestAuthenticationAndHBARules/insecure=false/special_cases
    test_log_scope.go:170: test logs captured to: /artifacts/tmp/_tmp/9df7e2b43c6703c48b37b40add1a12cd/logTestAuthenticationAndHBARules_insecure=false_special_cases1543205887
    test_server_shim.go:93: cluster virtualization disabled due to issue: #107310 (expected label: C-bug)
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/11562/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/special_cases:3:
        config [1 args]
        <no input to command>
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/11562/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/special_cases:6:
        sql [0 args]
        CREATE USER passworduser WITH PASSWORD 'pass'
        ----
        ok
    panic.go:626: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/9df7e2b43c6703c48b37b40add1a12cd/logTestAuthenticationAndHBARules_insecure=false_special_cases1543205887
        --- FAIL: TestAuthenticationAndHBARules/insecure=false/special_cases (1.84s)
=== RUN   TestAuthenticationAndHBARules/insecure=false/special_cases/root_user_cannot_use_password
    datadriven.go:259: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/11562/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/special_cases:17:
        set_hba [0 args]
        host all root 0.0.0.0/0 password
        ----
        # Active authentication configuration on this node:
        # Original configuration:
        # loopback all all all trust       # built-in CockroachDB default
        # host  all root all cert-password # CockroachDB mandatory rule
        # host all root 0.0.0.0/0 password
        #
        # Interpreted configuration:
        # TYPE   DATABASE USER ADDRESS   METHOD        OPTIONS
        loopback all      all  all       trust
        host     all      root all       cert-password
        host     all      root 0.0.0.0/0 password
    datadriven.go:259: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/11562/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/special_cases:32:
         
        expected:
        ERROR: password authentication failed for user root (SQLSTATE 28P01)
        
        found:
        ERROR: pq: SSL is not enabled on the server
            --- FAIL: TestAuthenticationAndHBARules/insecure=false/special_cases/root_user_cannot_use_password (0.04s)
=== RUN   TestAuthenticationAndHBARules/insecure=false
I240801 15:01:34.789224 1 (gostd) rand.go:250  [-] 1  random seed: 5134983495895765796
    --- FAIL: TestAuthenticationAndHBARules/insecure=false (41.06s)

Help

See also: How To Investigate a Go Test Failure (internal)

Same failure on other branches

• sql/pgwire: TestAuthenticationAndHBARules failed #127745 sql/pgwire: TestAuthenticationAndHBARules failed [C-test-failure O-robot T-sql-foundations branch-release-23.1 release-blocker]
• sql/pgwire: TestAuthenticationAndHBARules failed #126758 sql/pgwire: TestAuthenticationAndHBARules failed [C-test-failure O-robot P-2 T-sql-foundations branch-release-23.1.24-rc]
• sql/pgwire: TestAuthenticationAndHBARules failed #126239 sql/pgwire: TestAuthenticationAndHBARules failed [C-test-failure O-robot P-2 T-sql-foundations branch-release-23.2]
• sql/pgwire: TestAuthenticationAndHBARules failed #126063 sql/pgwire: TestAuthenticationAndHBARules failed [C-test-failure O-robot P-2 T-sql-foundations branch-release-23.2.7-rc no-test-failure-activity]

/cc @cockroachdb/sql-foundations @cockroachdb/server

This test on roachdash | Improve this report!

Jira issue: CRDB-40798

[github-actions]

We have marked this test failure issue as stale because it has been
inactive for 1 month. If this failure is still relevant, removing the
stale label or adding a comment will keep it active. Otherwise,
we'll close it in 5 days to keep the test failure queue tidy.