[SENTRY-850] Fix dbprovider test failures when run on a real cluster or setMetastoreListener = true, when db/tab gets recreated their associated privileges will be deleted.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.5.0, 1.5.1
• Fix Version/s: 1.6.0
• Assignee: Anne Yu
• Reporter: Anne Yu
• Created: 13/Aug/15 23:10
• Updated: 20/Aug/15 00:06
• Resolved: 18/Aug/15 20:39

Description

There are a couple of tests fail because they create db(table) /grant privileges, then drop/recreate db(table), when run on real clusters or setMetastoreListener = true, these privileges will be deleted. These tests are located in:

org.apache.sentry.tests.e2e.dbprovider.TestDbUriPermissions.testAlterTableLocationPrivileges
org.apache.sentry.tests.e2e.dbprovider.TestColumnEndToEnd.testBasic
org.apache.sentry.tests.e2e.dbprovider.TestDbPrivilegesAtDatabaseScope.testUseDbPrivilege
org.apache.sentry.tests.e2e.dbprovider.TestDbRuntimeMetadataRetrieval.testShowTables3
org.apache.sentry.tests.e2e.dbprovider.TestDbRuntimeMetadataRetrieval.testShowTablesExtended
org.apache.sentry.tests.e2e.dbprovider.TestDbRuntimeMetadataRetrieval.testShowTables1
org.apache.sentry.tests.e2e.dbprovider.TestDbSandboxOps.testNegativeUserDMLPrivileges
org.apache.sentry.tests.e2e.dbprovider.TestDbSandboxOps.testNegUserPrivilegesAll
org.apache.sentry.tests.e2e.dbprovider.TestDbSandboxOps.testSandboxOpt13
org.apache.sentry.tests.e2e.dbprovider.TestDbSandboxOps.testSandboxOpt10
org.apache.sentry.tests.e2e.dbprovider.TestDbUriPermissions.testLoadPrivileges

Issue Links

• is duplicated by: SENTRY-830 Enable setMetastoreListener in the tests so that we can debug flaky test failures from local testing enviroment