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

test_null_data failures in exhaustive runs

    Details

      Description

      15:44:15.331 [gw0] FAILED query_test/test_queries.py::TestQueries::test_null_data[exec_option: {'disable_codegen': True, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0, 'batch_size': 0, 'num_nodes': 0} | table_format: kudu/none] 
      15:44:15.331 query_test/test_queries.py::TestQueries::test_null_data[exec_option: {'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0, 'batch_size': 0, 'num_nodes': 0} | table_format: kudu/none] 
      15:44:15.331 [gw0] FAILED query_test/test_queries.py::TestQueries::test_null_data[exec_option: {'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0, 'batch_size': 0, 'num_nodes': 0} | table_format: kudu/none] 
      15:44:15.331 query_test/test_queries.py::TestQueries::test_null_data[exec_option: {'disable_codegen': True, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 100, 'batch_size': 0, 'num_nodes': 0} | table_format: kudu/none] 
      15:44:15.331 [gw0] FAILED query_test/test_queries.py::TestQueries::test_null_data[exec_option: {'disable_codegen': True, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 100, 'batch_size': 0, 'num_nodes': 0} | table_format: kudu/none] 
      15:44:15.331 query_test/test_queries.py::TestQueries::test_null_data[exec_option: {'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 100, 'batch_size': 0, 'num_nodes': 0} | table_format: kudu/none] 
      15:44:15.331 [gw0] FAILED query_test/test_queries.py::TestQueries::test_null_data[exec_option: {'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 100, 'batch_size': 0, 'num_nodes': 0} | table_format: kudu/none] 
      
      15:44:15.382 =================================== FAILURES ===================================
      15:44:15.382  TestQueries.test_null_data[exec_option: {'disable_codegen': True, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0, 'batch_size': 0, 'num_nodes': 0} | table_format: kudu/none] 
      15:44:15.382 [gw0] linux2 -- Python 2.6.6 /data/jenkins/workspace/impala-umbrella-build-and-test/repos/Impala/bin/../infra/python/env/bin/python
      15:44:15.382 query_test/test_queries.py:129: in test_null_data
      15:44:15.382     self.run_test_case('QueryTest/null_data', vector)
      15:44:15.382 common/impala_test_suite.py:346: in run_test_case
      15:44:15.382     self.__verify_results_and_errors(vector, test_section, result, use_db)
      15:44:15.382 common/impala_test_suite.py:235: in __verify_results_and_errors
      15:44:15.382     replace_filenames_with_placeholder)
      15:44:15.382 common/test_result_verifier.py:404: in verify_raw_results
      15:44:15.382     VERIFIER_MAP[verifier](expected, actual)
      15:44:15.382 common/test_result_verifier.py:231: in verify_query_result_is_equal
      15:44:15.382     assert expected_results == actual_results
      15:44:15.382 E   assert Comparing QueryTestResults (expected vs actual):
      15:44:15.382 E     'a','','NULL',NULL,NULL,'a\x00b','\x00' != None
      15:44:15.382 E     Number of rows returned (expected vs actual): 1 != 0
      15:44:15.382 ----------------------------- Captured stderr call -----------------------------
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 use functional_kudu;
      15:44:15.382 
      15:44:15.382 SET disable_codegen=True;
      15:44:15.382 SET abort_on_error=1;
      15:44:15.382 SET exec_single_node_rows_threshold=0;
      15:44:15.382 SET batch_size=0;
      15:44:15.382 SET num_nodes=0;
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 select * from nulltable;
      15:44:15.382 
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 select count(*),count(a),count(b),count(c),count(d),count(e),count(f),count(g)
      15:44:15.382 from nulltable;
      15:44:15.382 
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 select length(f),length(g)
      15:44:15.382 from nulltable;
      15:44:15.382 
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 select * from nullescapedtable;
      15:44:15.382 
      15:44:15.382 MainThread: Comparing QueryTestResults (expected vs actual):
      15:44:15.382 'a','','NULL',NULL,NULL,'a\x00b','\x00' != None
      15:44:15.382 Number of rows returned (expected vs actual): 1 != 0
      15:44:15.382  TestQueries.test_null_data[exec_option: {'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0, 'batch_size': 0, 'num_nodes': 0} | table_format: kudu/none] 
      15:44:15.382 [gw0] linux2 -- Python 2.6.6 /data/jenkins/workspace/impala-umbrella-build-and-test/repos/Impala/bin/../infra/python/env/bin/python
      15:44:15.382 query_test/test_queries.py:129: in test_null_data
      15:44:15.382     self.run_test_case('QueryTest/null_data', vector)
      15:44:15.382 common/impala_test_suite.py:346: in run_test_case
      15:44:15.382     self.__verify_results_and_errors(vector, test_section, result, use_db)
      15:44:15.382 common/impala_test_suite.py:235: in __verify_results_and_errors
      15:44:15.382     replace_filenames_with_placeholder)
      15:44:15.382 common/test_result_verifier.py:404: in verify_raw_results
      15:44:15.382     VERIFIER_MAP[verifier](expected, actual)
      15:44:15.382 common/test_result_verifier.py:231: in verify_query_result_is_equal
      15:44:15.382     assert expected_results == actual_results
      15:44:15.382 E   assert Comparing QueryTestResults (expected vs actual):
      15:44:15.382 E     'a','','NULL',NULL,NULL,'a\x00b','\x00' != None
      15:44:15.382 E     Number of rows returned (expected vs actual): 1 != 0
      15:44:15.382 ----------------------------- Captured stderr call -----------------------------
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 use functional_kudu;
      15:44:15.382 
      15:44:15.382 SET disable_codegen=False;
      15:44:15.382 SET abort_on_error=1;
      15:44:15.382 SET exec_single_node_rows_threshold=0;
      15:44:15.382 SET batch_size=0;
      15:44:15.382 SET num_nodes=0;
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 select * from nulltable;
      15:44:15.382 
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 select count(*),count(a),count(b),count(c),count(d),count(e),count(f),count(g)
      15:44:15.382 from nulltable;
      15:44:15.382 
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 select length(f),length(g)
      15:44:15.382 from nulltable;
      15:44:15.382 
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 select * from nullescapedtable;
      15:44:15.382 
      15:44:15.382 MainThread: Comparing QueryTestResults (expected vs actual):
      15:44:15.382 'a','','NULL',NULL,NULL,'a\x00b','\x00' != None
      15:44:15.382 Number of rows returned (expected vs actual): 1 != 0
      15:44:15.382  TestQueries.test_null_data[exec_option: {'disable_codegen': True, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 100, 'batch_size': 0, 'num_nodes': 0} | table_format: kudu/none] 
      15:44:15.382 [gw0] linux2 -- Python 2.6.6 /data/jenkins/workspace/impala-umbrella-build-and-test/repos/Impala/bin/../infra/python/env/bin/python
      15:44:15.382 query_test/test_queries.py:129: in test_null_data
      15:44:15.382     self.run_test_case('QueryTest/null_data', vector)
      15:44:15.382 common/impala_test_suite.py:346: in run_test_case
      15:44:15.382     self.__verify_results_and_errors(vector, test_section, result, use_db)
      15:44:15.382 common/impala_test_suite.py:235: in __verify_results_and_errors
      15:44:15.382     replace_filenames_with_placeholder)
      15:44:15.382 common/test_result_verifier.py:404: in verify_raw_results
      15:44:15.382     VERIFIER_MAP[verifier](expected, actual)
      15:44:15.382 common/test_result_verifier.py:231: in verify_query_result_is_equal
      15:44:15.382     assert expected_results == actual_results
      15:44:15.382 E   assert Comparing QueryTestResults (expected vs actual):
      15:44:15.382 E     'a','','NULL',NULL,NULL,'a\x00b','\x00' != None
      15:44:15.382 E     Number of rows returned (expected vs actual): 1 != 0
      15:44:15.382 ----------------------------- Captured stderr call -----------------------------
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 use functional_kudu;
      15:44:15.382 
      15:44:15.382 SET disable_codegen=True;
      15:44:15.382 SET abort_on_error=1;
      15:44:15.382 SET exec_single_node_rows_threshold=100;
      15:44:15.382 SET batch_size=0;
      15:44:15.382 SET num_nodes=0;
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 select * from nulltable;
      15:44:15.382 
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 select count(*),count(a),count(b),count(c),count(d),count(e),count(f),count(g)
      15:44:15.382 from nulltable;
      15:44:15.382 
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 select length(f),length(g)
      15:44:15.382 from nulltable;
      15:44:15.382 
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 select * from nullescapedtable;
      15:44:15.382 
      15:44:15.382 MainThread: Comparing QueryTestResults (expected vs actual):
      15:44:15.382 'a','','NULL',NULL,NULL,'a\x00b','\x00' != None
      15:44:15.382 Number of rows returned (expected vs actual): 1 != 0
      15:44:15.382  TestQueries.test_null_data[exec_option: {'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 100, 'batch_size': 0, 'num_nodes': 0} | table_format: kudu/none] 
      15:44:15.382 [gw0] linux2 -- Python 2.6.6 /data/jenkins/workspace/impala-umbrella-build-and-test/repos/Impala/bin/../infra/python/env/bin/python
      15:44:15.382 query_test/test_queries.py:129: in test_null_data
      15:44:15.382     self.run_test_case('QueryTest/null_data', vector)
      15:44:15.382 common/impala_test_suite.py:346: in run_test_case
      15:44:15.382     self.__verify_results_and_errors(vector, test_section, result, use_db)
      15:44:15.382 common/impala_test_suite.py:235: in __verify_results_and_errors
      15:44:15.382     replace_filenames_with_placeholder)
      15:44:15.382 common/test_result_verifier.py:404: in verify_raw_results
      15:44:15.382     VERIFIER_MAP[verifier](expected, actual)
      15:44:15.382 common/test_result_verifier.py:231: in verify_query_result_is_equal
      15:44:15.382     assert expected_results == actual_results
      15:44:15.382 E   assert Comparing QueryTestResults (expected vs actual):
      15:44:15.382 E     'a','','NULL',NULL,NULL,'a\x00b','\x00' != None
      15:44:15.382 E     Number of rows returned (expected vs actual): 1 != 0
      15:44:15.382 ----------------------------- Captured stderr call -----------------------------
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 use functional_kudu;
      15:44:15.382 
      15:44:15.382 SET disable_codegen=False;
      15:44:15.382 SET abort_on_error=1;
      15:44:15.382 SET exec_single_node_rows_threshold=100;
      15:44:15.382 SET batch_size=0;
      15:44:15.382 SET num_nodes=0;
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 select * from nulltable;
      15:44:15.382 
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 select count(*),count(a),count(b),count(c),count(d),count(e),count(f),count(g)
      15:44:15.382 from nulltable;
      15:44:15.382 
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 select length(f),length(g)
      15:44:15.382 from nulltable;
      15:44:15.382 
      15:44:15.382 -- executing against localhost:21000
      15:44:15.382 select * from nullescapedtable;
      15:44:15.382 
      15:44:15.382 MainThread: Comparing QueryTestResults (expected vs actual):
      15:44:15.382 'a','','NULL',NULL,NULL,'a\x00b','\x00' != None
      15:44:15.382 Number of rows returned (expected vs actual): 1 != 0
      15:44:15.3
      

        Activity

        Show
        twmarshall Thomas Tauber-Marshall added a comment - This showed up in several Jenkins builds: http://sandbox.jenkins.cloudera.com/view/Impala/view/Evergreen-asf-master/job/impala-asf-master-exhaustive/133/ http://sandbox.jenkins.cloudera.com/view/Impala/view/Evergreen-asf-master/job/impala-asf-master-exhaustive-release/138/
        Hide
        dtsirogiannis Dimitris Tsirogiannis added a comment -

        A fix is currently in gvo.

        Show
        dtsirogiannis Dimitris Tsirogiannis added a comment - A fix is currently in gvo.
        Hide
        dtsirogiannis Dimitris Tsirogiannis added a comment -

        Change-Id: Ib6f4b4c88ef18b1731b7c9789aad602880e18035
        Reviewed-on: http://gerrit.cloudera.org:8080/5157
        Reviewed-by: Alex Behm <alex.behm@cloudera.com>
        Tested-by: Internal Jenkins

        Show
        dtsirogiannis Dimitris Tsirogiannis added a comment - Change-Id: Ib6f4b4c88ef18b1731b7c9789aad602880e18035 Reviewed-on: http://gerrit.cloudera.org:8080/5157 Reviewed-by: Alex Behm <alex.behm@cloudera.com> Tested-by: Internal Jenkins

          People

          • Assignee:
            dtsirogiannis Dimitris Tsirogiannis
            Reporter:
            bharathv bharath v
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development