pkg/sql/logictest/tests/local-mixed-25.3/local-mixed-25_3_test.TestLogic_external_connection_privileges: TestLogic_external_connection_privileges failed

[cockroach-teamcity]

pkg/sql/logictest/tests/local-mixed-25.3/local-mixed-25_3_test.TestLogic_external_connection_privileges.TestLogic_external_connection_privileges failed with artifacts on master @ c6539d4f2519f6d24214b4d9f284b64743345b8c:

=== RUN   TestLogic_external_connection_privileges
    test_log_scope.go:171: test logs captured to: /artifacts/tmp/_tmp/620ef523e497b0802aef747365826324/logTestLogic_external_connection_privileges3618077320
    test_log_scope.go:82: use -show-logs to present logs inline
    test_server_shim.go:141: cluster virtualization disabled in global scope due to issue: #76378 (expected label: C-bug)
[17:05:17] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/16937/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/logictest/tests/local-mixed-25.3/local-mixed-25_3_test_/local-mixed-25_3_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/external_connection_privileges with config local-mixed-25.3: 13 tests, 0 failures
    logic.go:4491: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/16937/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/logictest/tests/local-mixed-25.3/local-mixed-25_3_test_/local-mixed-25_3_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/external_connection_privileges:62: error while processing
    logic.go:4491: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/16937/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/logictest/tests/local-mixed-25.3/local-mixed-25_3_test_/local-mixed-25_3_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/external_connection_privileges:62: 
        expected success, but found
        (01007) user testuser missing WITH GRANT OPTION privilege on one or more of USAGE, DROP, UPDATE
        authorization.go:312: in MustCheckGrantOptionsForUser()
    panic.go:615: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/620ef523e497b0802aef747365826324/logTestLogic_external_connection_privileges3618077320
--- FAIL: TestLogic_external_connection_privileges (1.18s)

Help

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

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-55981

[fqazi]

Looks similar to #155822

[cockroach-teamcity]

pkg/sql/logictest/tests/local-mixed-25.3/local-mixed-25_3_test.TestLogic_external_connection_privileges.TestLogic_external_connection_privileges failed with artifacts on master @ 8e56ad9c46e544c2ef368e02322d949a03723891:

=== RUN   TestLogic_external_connection_privileges
    test_log_scope.go:171: test logs captured to: /artifacts/tmp/_tmp/4867d3c53bcb21023c3c8811dfe252b2/logTestLogic_external_connection_privileges728266750
    test_log_scope.go:82: use -show-logs to present logs inline
    test_server_shim.go:141: cluster virtualization disabled in global scope due to issue: #76378 (expected label: C-bug)
[08:24:19] setting distsql_workmem='37597B';
[08:24:19] --- queries start here (file: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3720/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/local-mixed-25.3/local-mixed-25_3_test_/local-mixed-25_3_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/external_connection_privileges)
[08:24:19] SELECT username, path, privileges, grant_options FROM system.privileges;
[08:24:19] 	-- OK;
[08:24:19] GRANT USAGE ON EXTERNAL CONNECTION foo TO testuser;
[08:24:19] GRANT DROP ON EXTERNAL CONNECTION foo TO testuser;
[08:24:19] GRANT UPDATE ON EXTERNAL CONNECTION foo TO testuser;
[08:24:19] CREATE EXTERNAL CONNECTION foo AS 'nodelocal://1/foo';
[08:24:19] GRANT USAGE,DROP,UPDATE ON EXTERNAL CONNECTION foo TO testuser;
[08:24:20] SELECT username, path, privileges, grant_options FROM system.privileges ORDER by username;
[08:24:20] 	-- OK;
[08:24:20] REVOKE USAGE,DROP,UPDATE ON EXTERNAL CONNECTION foo FROM testuser;
[08:24:20] SELECT username, path, privileges, grant_options FROM system.privileges ORDER by username;
[08:24:20] 	-- OK;
[08:24:20] GRANT USAGE,DROP,UPDATE ON EXTERNAL CONNECTION foo TO testuser;
[08:24:20] CREATE USER bar;
[08:24:20] GRANT USAGE,DROP,UPDATE ON EXTERNAL CONNECTION foo TO bar;
[08:24:20] GRANT USAGE,DROP,UPDATE ON EXTERNAL CONNECTION foo TO testuser WITH GRANT OPTION;
[08:24:20] GRANT USAGE,DROP,UPDATE ON EXTERNAL CONNECTION foo TO bar;
[08:24:20] 	-- OK;
[08:24:20] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3720/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/local-mixed-25.3/local-mixed-25_3_test_/local-mixed-25_3_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/external_connection_privileges with config local-mixed-25.3: 13 tests, 0 failures

    logic.go:4503: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3720/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/local-mixed-25.3/local-mixed-25_3_test_/local-mixed-25_3_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/external_connection_privileges:62: error while processing
    logic.go:4503: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3720/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/local-mixed-25.3/local-mixed-25_3_test_/local-mixed-25_3_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/external_connection_privileges:62: 
        expected success, but found
        (01007) user testuser missing WITH GRANT OPTION privilege on one or more of USAGE, DROP, UPDATE
        authorization.go:312: in MustCheckGrantOptionsForUser()
    panic.go:615: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/4867d3c53bcb21023c3c8811dfe252b2/logTestLogic_external_connection_privileges728266750
--- FAIL: TestLogic_external_connection_privileges (4.31s)

Help

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

This test on roachdash | Improve this report!