Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-2219

S3: Unknown error 255 when reading file

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: Impala 2.3.0
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      See http://sandbox.jenkins.cloudera.com/job/impala-s3/191

      query_test.test_tpch_queries.TestTpchQuery.test_tpch_q15[exec_option: {'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0, 'batch_size': 0, 'num_nodes': 0} | table_format: text/gzip/block] (from pytest)
      
      Failing for the past 1 build (Since Failed#191 )
      Took 2 min 43 sec.
      add description
      Error Message
      
      query_test/test_tpch_queries.py:69: in test_tpch_q15     self.run_test_case('tpch-q15', vector) common/impala_test_suite.py:228: in run_test_case     result = self.__execute_query(target_impalad_client, query, user=user) common/impala_test_suite.py:414: in __execute_query     return impalad_client.execute(query, user=user) common/impala_connection.py:158: in execute     return self.__beeswax_client.execute(sql_stmt, user=user) beeswax/impala_beeswax.py:161: in execute     handle = self.__execute_query(query_string.strip(), user=user) beeswax/impala_beeswax.py:327: in __execute_query     self.wait_for_completion(handle) beeswax/impala_beeswax.py:347: in wait_for_completion     raise ImpalaBeeswaxException("Query aborted:" + error_log, None) E   ImpalaBeeswaxException: ImpalaBeeswaxException: E    Query aborted: E   Error reading from HDFS file: s3a://ishaan-impala/test-warehouse/tpch.lineitem_text_gzip/000001_0.gz E   Error(255): Unknown error 255 E    E    E    E   Error reading from HDFS file: s3a://ishaan-impala/test-warehouse/tpch.lineitem_text_gzip/000001_0.gz E   Error(255): Unknown error 255
      Stacktrace
      
      query_test/test_tpch_queries.py:69: in test_tpch_q15
          self.run_test_case('tpch-q15', vector)
      common/impala_test_suite.py:228: in run_test_case
          result = self.__execute_query(target_impalad_client, query, user=user)
      common/impala_test_suite.py:414: in __execute_query
          return impalad_client.execute(query, user=user)
      common/impala_connection.py:158: in execute
          return self.__beeswax_client.execute(sql_stmt, user=user)
      beeswax/impala_beeswax.py:161: in execute
          handle = self.__execute_query(query_string.strip(), user=user)
      beeswax/impala_beeswax.py:327: in __execute_query
          self.wait_for_completion(handle)
      beeswax/impala_beeswax.py:347: in wait_for_completion
          raise ImpalaBeeswaxException("Query aborted:" + error_log, None)
      E   ImpalaBeeswaxException: ImpalaBeeswaxException:
      E    Query aborted:
      E   Error reading from HDFS file: s3a://ishaan-impala/test-warehouse/tpch.lineitem_text_gzip/000001_0.gz
      E   Error(255): Unknown error 255
      E   
      E   
      E   
      E   Error reading from HDFS file: s3a://ishaan-impala/test-warehouse/tpch.lineitem_text_gzip/000001_0.gz
      E   Error(255): Unknown error 255
      Standard Error
      
      -- executing against localhost:21000
      use tpch_text_gzip;
      
      SET disable_codegen=False;
      SET abort_on_error=1;
      SET exec_single_node_rows_threshold=0;
      SET batch_size=0;
      SET num_nodes=0;
      MainThread: Query Name: 
      TPCH-Q15
      
      -- executing against localhost:21000
      with revenue_view as (
        select
          l_suppkey as supplier_no,
          sum(l_extendedprice * (1 - l_discount)) as total_revenue
        from
          lineitem
        where
          l_shipdate >= '1996-01-01'
          and l_shipdate < '1996-04-01'
        group by
          l_suppkey)
      select
        s_suppkey,
        s_name,
        s_address,
        s_phone,
        total_revenue
      from
        supplier,
        revenue_view
      where
        s_suppkey = supplier_no
        and total_revenue = (
          select
            max(total_revenue)
          from
            revenue_view
          )
      order by
        s_suppkey;
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                dhecht Daniel Hecht
                Reporter:
                henryr Henry Robinson
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: