[IMPALA-7156] Many authorization tests failed with "User 'jenkins' does not have privileges to access"

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 2.13.0
• Fix Version/s: Impala 2.13.0
• Component/s: Infrastructure
• Labels: broken-build flaky
• Target Version: Impala 2.13.0
• Epic Color: ghx-label-8
• Assignee: Fredy Wijaya
• Reporter: Tim Armstrong
• Created: 08/Jun/18 22:14
• Updated: 12/Jun/18 20:43
• Resolved: 12/Jun/18 17:13

Description

Failed tests:

    authorization.test_grant_revoke.TestGrantRevoke.test_role_privilege_case[exec_option: {'batch_size': 0, 'num_nodes': 0, 'disable_codegen_rows_threshold': 0, 'disable_codegen': False, 'abort_on_error': 1, 'debug_action': None, 'exec_single_node_rows_threshold': 0} | table_format: text/none]
    org.apache.impala.analysis.AuthorizationTest.TestServerLevelInsert[1]
    org.apache.impala.analysis.AuthorizationTest.TestFunction[1]
    org.apache.impala.analysis.AuthorizationTest.TestDropDatabase[1]
    org.apache.impala.analysis.AuthorizationTest.TestServerLevelSelect[1]
    org.apache.impala.analysis.AuthorizationTest.TestTruncate[1]
    org.apache.impala.analysis.AuthorizationTest.TestShowCreateTable[1]
    org.apache.impala.analysis.AuthorizationTest.TestShortUsernameUsed[1]
    org.apache.impala.analysis.AuthorizationTest.TestComputeStatsTable[1]
    org.apache.impala.analysis.AuthorizationTest.TestHs2GetColumns[1]
    org.apache.impala.analysis.AuthorizationTest.TestLoad[1]
    org.apache.impala.analysis.AuthorizationTest.TestCreateDatabase[1]
    org.apache.impala.analysis.AuthorizationTest.TestInsert[1]
    org.apache.impala.analysis.AuthorizationTest.TestSelect[1]
    org.apache.impala.analysis.AuthorizationTest.TestCreateView[1]
    org.apache.impala.analysis.AuthorizationTest.TestServerLevelAlter[1]
    org.apache.impala.analysis.AuthorizationTest.TestResetMetadata[1]
    org.apache.impala.analysis.AuthorizationTest.TestExplain[1]
    org.apache.impala.analysis.AuthorizationTest.TestCommentOn[1]
    org.apache.impala.analysis.AuthorizationTest.TestWithClause[1]
    org.apache.impala.analysis.AuthorizationTest.TestAlterView[1]
    org.apache.impala.analysis.AuthorizationTest.TestShowPermissions[1]
    org.apache.impala.analysis.AuthorizationTest.TestServerLevelDrop[1]
    org.apache.impala.analysis.AuthorizationTest.TestDropView[1]
    org.apache.impala.analysis.AuthorizationTest.TestShowDbResultsFiltered[1]
    org.apache.impala.analysis.AuthorizationTest.TestShowTableResultsFiltered[1]
    org.apache.impala.analysis.AuthorizationTest.TestUnion[1]
    org.apache.impala.analysis.AuthorizationTest.TestUseDb[1]
    org.apache.impala.analysis.AuthorizationTest.TestDropStats[1]
    org.apache.impala.analysis.AuthorizationTest.TestDropTable[1]
    org.apache.impala.analysis.AuthorizationTest.TestHs2GetSchema[1]
    org.apache.impala.analysis.AuthorizationTest.TestHs2GetTables[1]
    org.apache.impala.analysis.AuthorizationTest.TestDescribeDb[1]
    org.apache.impala.analysis.AuthorizationTest.TestAlterTable[1]
    org.apache.impala.analysis.AuthorizationTest.TestDescribe[1]
    org.apache.impala.analysis.AuthorizationTest.TestServerLevelCreate[1]
    org.apache.impala.analysis.AuthorizationTest.TestCreateTable[1]

The errors are all along the lines of:

org.apache.impala.catalog.AuthorizationException: User 'jenkins' does not have privileges to execute 'INSERT' on: functional_parquet.alltypes
	at org.apache.impala.authorization.AuthorizationChecker.checkAccess(AuthorizationChecker.java:146)
	at org.apache.impala.analysis.AnalysisContext.authorizePrivilegeRequest(AnalysisContext.java:567)
	at org.apache.impala.analysis.AnalysisContext.authorize(AnalysisContext.java:530)
	at org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:409)
	at org.apache.impala.common.FrontendTestBase.parseAndAnalyze(FrontendTestBase.java:429)
	at org.apache.impala.analysis.AuthorizationTest.AuthzOk(AuthorizationTest.java:2841)
	at org.apache.impala.analysis.AuthorizationTest.AuthzOk(AuthorizationTest.java:2836)
	at org.apache.impala.analysis.AuthorizationTest.AuthzOk(AuthorizationTest.java:2832)
	at org.apache.impala.analysis.AuthorizationTest.TestTruncate(AuthorizationTest.java:1417)

java.lang.AssertionError: expected:<1> but was:<0>
	at org.junit.Assert.fail(Assert.java:88)
	at org.junit.Assert.failNotEquals(Assert.java:834)
	at org.junit.Assert.assertEquals(Assert.java:645)
	at org.junit.Assert.assertEquals(Assert.java:631)
	at org.apache.impala.analysis.AuthorizationTest.TestHs2GetColumns(AuthorizationTest.java:2140)

Seen on commit b8f3d3cc6d8c3aa16e3004433a2f54a94b27a8cc