[IMPALA-2219] S3: Unknown error 255 when reading file

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: Impala 2.3.0
• Target Version: Impala 2.3.0
• Assignee: Daniel Hecht
• Reporter: Henry Robinson
• Created: 18/Aug/15 17:22
• Updated: 18/Aug/15 17:51
• Resolved: 18/Aug/15 17:51

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;

Issue Links

• duplicates: IMPALA-2021 S3: Flaky tests: impala-s3 job sometimes encounters I/O error 255