Uploaded image for project: 'Hue (READ ONLY)'
  1. Hue (READ ONLY)
  2. HUE-2912 [core] Stop skipping the Live tests
  3. HUE-2900

[metastore] test_has_write_access_backend is failing on live cluster

    Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.9.0
    • Fix Version/s: 3.10.0
    • Component/s: app.catalog
    • Labels:
      None

      Description

      This test passes locally but is failing. Needs debugging to see if it's coming from HUE-2897.

      ======================================================================
      FAIL: metastore.tests.TestMetastoreWithHadoop.test_has_write_access_backend
      ----------------------------------------------------------------------
      Traceback (most recent call last):
        File "/var/lib/jenkins/workspace/Hue-Systest-Create-And-Run/build/env/local/lib/python2.7/site-packages/nose-0.11.3-py2.7.egg/nose/case.py", line 186, in runTest
          self.test(*self.arg)
        File "/var/lib/jenkins/workspace/Hue-Systest-Create-And-Run/apps/metastore/src/metastore/tests.py", line 260, in test_has_write_access_backend
          resp = _make_query(client, 'CREATE TABLE test_perm_1 (a int);', database=self.db_name) # Only fails if we were using Sentry and won't allow SELECT to user
        File "/var/lib/jenkins/workspace/Hue-Systest-Create-And-Run/apps/metastore/src/metastore/tests.py", line 56, in _make_query
          verify_history(client, fragment=fragment)
        File "/var/lib/jenkins/workspace/Hue-Systest-Create-And-Run/apps/beeswax/src/beeswax/test_base.py", line 314, in verify_history
          my_assert(fragment in resp.content)
      AssertionError: False is not true
      -------------------- >> begin captured logging << --------------------
      beeswax.server.dbms: DEBUG: Query Server: {'server_name': 'beeswax', 'transport_mode': 'socket', 'server_host': 'erickt-2.vpc.cloudera.com', 'server_port': 10000, 'http_url': 'http://erickt-2.vpc.cloudera.com:10001/cliservice', 'principal': None}
      desktop.middleware: INFO: Unloading AuditLoggingMiddleware
      desktop.middleware: INFO: Unloading SpnegoMiddleware
      desktop.middleware: INFO: Unloading HueRemoteUserMiddleware
      access: INFO: 127.0.0.1 write_access_backend - "POST /beeswax/api/query/execute/ HTTP/1.1"
      beeswax.server.dbms: DEBUG: Query Server: {'server_name': 'beeswax', 'transport_mode': 'socket', 'server_host': 'erickt-2.vpc.cloudera.com', 'server_port': 10000, 'http_url': 'http://erickt-2.vpc.cloudera.com:10001/cliservice', 'principal': None}
      beeswax.server.dbms: DEBUG: Query Server: {'server_name': 'beeswax', 'transport_mode': 'socket', 'server_host': 'erickt-2.vpc.cloudera.com', 'server_port': 10000, 'http_url': 'http://erickt-2.vpc.cloudera.com:10001/cliservice', 'principal': None}
      beeswax.server.hive_server2_lib: INFO: use_sasl=True, mechanism=PLAIN, kerberos_principal_short_name=None, impersonation_enabled=False
      root: DEBUG: Thrift call: <class 'TCLIService.TCLIService.Client'>.OpenSession(args=(TOpenSessionReq(username=u'write_access_backend', password=None, client_protocol=6, configuration={'hive.server2.proxy.user': u'write_access_backend'}),), kwargs={})
      root: DEBUG: Thrift call <class 'TCLIService.TCLIService.Client'>.OpenSession returned in 50ms: TOpenSessionResp(status=TStatus(errorCode=None, errorMessage=None, sqlState=None, infoMessages=None, statusCode=0), sessionHandle=TSessionHandle(sessionId=THandleIdentifier(secret='E\xe2\xa2\xc3\xef\xd2C\x06\xb9\x1bdT,\x06(\xf7', guid='G\xe8\xd9\x16\xc3"C\xe3\xbd\x9e\xceM\x9c\xca\x16\x10')), configuration={}, serverProtocolVersion=6)
      beeswax.server.hive_server2_lib: INFO: Opening session THandleIdentifier(secret='E\xe2\xa2\xc3\xef\xd2C\x06\xb9\x1bdT,\x06(\xf7', guid='G\xe8\xd9\x16\xc3"C\xe3\xbd\x9e\xceM\x9c\xca\x16\x10')
      root: DEBUG: Thrift call: <class 'TCLIService.TCLIService.Client'>.GetSchemas(args=(TGetSchemasReq(schemaName=None, sessionHandle=TSessionHandle(sessionId=THandleIdentifier(secret='E\xe2\xa2\xc3\xef\xd2C\x06\xb9\x1bdT,\x06(\xf7', guid='G\xe8\xd9\x16\xc3"C\xe3\xbd\x9e\xceM\x9c\xca\x16\x10')), catalogName=None),), kwargs={})
      root: DEBUG: Thrift call <class 'TCLIService.TCLIService.Client'>.GetSchemas returned in 7ms: TGetSchemasResp(status=TStatus(errorCode=None, errorMessage=None, sqlState=None, infoMessages=None, statusCode=0), operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=3, operationId=THandleIdentifier(secret='!k\xbaVd\x94Gs\xb87u\xec\xfc\xdac8', guid='\xb5\xfb\xcdG\x18\x94H]\xb8|6\x90\x9f+Lh')))
      root: DEBUG: Thrift call: <class 'TCLIService.TCLIService.Client'>.FetchResults(args=(TFetchResultsReq(fetchType=0, operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=3, operationId=THandleIdentifier(secret='!k\xbaVd\x94Gs\xb87u\xec\xfc\xdac8', guid='\xb5\xfb\xcdG\x18\x94H]\xb8|6\x90\x9f+Lh')), orientation=0, maxRows=5000),), kwargs={})
      root: DEBUG: Thrift call <class 'TCLIService.TCLIService.Client'>.FetchResults returned in 2ms: TFetchResultsResp(status=TStatus(errorCode=None, errorMessage=None, sqlState=None, infoMessages=None, statusCode=0), results=TRowSet(rows=[], columns=[TColumn(i32Val=None, byteVal=None, i16Val=None, i64Val=None, stringVal=TStringColumn(nulls='\x00', values=['default', 'hue_test_hive_143761794052', 'hue_test_hive_143761794052_other', 'hue_test_hive_143761808042', 'hue_test_hive_143761808042_other', 'hue_test_hive_143767106311', 'hue_test_hive_143767106311_other', 'hue_test_hive_143767119833', 'hue_test_hive_143767119833_other', 'hue_test_hive_143768374846', 'hue_test_hive_143768374846_other', 'hue_test_hive_143768388944', 'hue_test_hive_143768388944_other', 'hue_test_hive_143768470236', 'hue_test_hive_143768470236_other', 'hue_test_hive_143768499324', 'hue_test_hive_143768499324_other', 'hue_test_hive_143769999848', 'hue_test_hive_143769999848_other', 'hue_test_hive_143770029307', 'hue_test_hive_143770029307_other', 'hue_test_hive_143770320365', 'hue_test_hive_143770320365_other', 'hue_...
      root: DEBUG: Thrift call: <class 'TCLIService.TCLIService.Client'>.GetResultSetMetadata(args=(TGetResultSetMetadataReq(operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=3, operationId=THandleIdentifier(secret='!k\xbaVd\x94Gs\xb87u\xec\xfc\xdac8', guid='\xb5\xfb\xcdG\x18\x94H]\xb8|6\x90\x9f+Lh'))),), kwargs={})
      root: DEBUG: Thrift call <class 'TCLIService.TCLIService.Client'>.GetResultSetMetadata returned in 1ms: TGetResultSetMetadataResp(status=TStatus(errorCode=None, errorMessage=None, sqlState=None, infoMessages=None, statusCode=0), schema=TTableSchema(columns=[TColumnDesc(comment='Schema name.', columnName='TABLE_SCHEM', typeDesc=TTypeDesc(types=[TTypeEntry(mapEntry=None, unionEntry=None, arrayEntry=None, userDefinedTypeEntry=None, structEntry=None, primitiveEntry=TPrimitiveTypeEntry(typeQualifiers=None, type=7))]), position=1), TColumnDesc(comment='Catalog name.', columnName='TABLE_CATALOG', typeDesc=TTypeDesc(types=[TTypeEntry(mapEntry=None, unionEntry=None, arrayEntry=None, userDefinedTypeEntry=None, structEntry=None, primitiveEntry=TPrimitiveTypeEntry(typeQualifiers=None, type=7))]), position=2)]))
      root: DEBUG: Thrift call: <class 'TCLIService.TCLIService.Client'>.CloseOperation(args=(TCloseOperationReq(operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=3, operationId=THandleIdentifier(secret='!k\xbaVd\x94Gs\xb87u\xec\xfc\xdac8', guid='\xb5\xfb\xcdG\x18\x94H]\xb8|6\x90\x9f+Lh'))),), kwargs={})
      root: DEBUG: Thrift call <class 'TCLIService.TCLIService.Client'>.CloseOperation returned in 1ms: TCloseOperationResp(status=TStatus(errorCode=None, errorMessage=None, sqlState=None, infoMessages=None, statusCode=0))
      desktop.lib.django_forms: ERROR: <ul class="errorlist"><li>database<ul class="errorlist"><li>Select a valid choice. hue_test_hive_143931267532 is not one of the available choices.</li></ul></li></ul>
      access: INFO: 127.0.0.1 write_access_backend - "GET /beeswax/query_history HTTP/1.1"
      --------------------- >> end captured logging << ---------------------
      

        Attachments

          Activity

            People

            • Assignee:
              jennykim Jenny Kim
              Reporter:
              erickt Erick Tryzelaar
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: