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

Integration job failed in TestDdlStatements.test_functions_ddl - one extra function in actual output

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: Impala 2.10.0
    • Fix Version/s: Impala 2.11.0
    • Component/s: Frontend
    • Labels:

      Description

      TestDdlStatements.test_functions_ddl failed.

      What's weird is that the following function was already deleted and seems to have re-appeared:

      'INT','fn()','NATIVE','true'
      

      Relevant Jenkins snippet below:

      15:35:55.450 =================================== FAILURES ===================================
      15:35:55.450  TestDdlStatements.test_functions_ddl[exec_option: {'sync_ddl': 1, 'batch_size': 0, 'num_nodes': 0, 'disable_codegen_rows_threshold': 0, 'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0} | table_format: text/none-unique_database0] 
      15:35:55.450 [gw3] linux2 -- Python 2.6.6 /data/jenkins/workspace/impala-asf-master-exhaustive-integration/repos/Impala/bin/../infra/python/env/bin/python
      15:35:55.450 metadata/test_ddl.py:324: in test_functions_ddl
      15:35:55.450     multiple_impalad=self._use_multiple_impalad(vector))
      15:35:55.450 common/impala_test_suite.py:420: in run_test_case
      15:35:55.450     self.__verify_results_and_errors(vector, test_section, result, use_db)
      15:35:55.450 common/impala_test_suite.py:293: in __verify_results_and_errors
      15:35:55.450     replace_filenames_with_placeholder)
      15:35:55.450 common/test_result_verifier.py:404: in verify_raw_results
      15:35:55.450     VERIFIER_MAP[verifier](expected, actual)
      15:35:55.450 common/test_result_verifier.py:231: in verify_query_result_is_equal
      15:35:55.450     assert expected_results == actual_results
      15:35:55.450 E   assert Comparing QueryTestResults (expected vs actual):
      15:35:55.450 E     'DOUBLE','fn(INT)','NATIVE','true' == 'DOUBLE','fn(INT)','NATIVE','true'
      15:35:55.450 E     'INT','fn(INT, STRING)','NATIVE','true' != 'INT','fn()','NATIVE','true'
      15:35:55.450 E     'INT','fn(STRING, INT)','NATIVE','true' != 'INT','fn(INT, STRING)','NATIVE','true'
      15:35:55.450 E     'INT','fn2(INT)','NATIVE','true' != 'INT','fn(STRING, INT)','NATIVE','true'
      15:35:55.450 E     None != 'INT','fn2(INT)','NATIVE','true'
      15:35:55.450 E     Number of rows returned (expected vs actual): 4 != 5
      15:35:55.450 ---------------------------- Captured stderr setup -----------------------------
      15:35:55.450 SET sync_ddl=True;
      15:35:55.450 -- executing against localhost:21000
      15:35:55.450 DROP DATABASE IF EXISTS `test_functions_ddl_baf0bb91` CASCADE;
      15:35:55.450 
      15:35:55.450 SET sync_ddl=True;
      15:35:55.450 -- executing against localhost:21000
      15:35:55.450 CREATE DATABASE `test_functions_ddl_baf0bb91`;
      15:35:55.450 
      15:35:55.450 MainThread: Created database "test_functions_ddl_baf0bb91" for test ID "metadata/test_ddl.py::TestDdlStatements::()::test_functions_ddl[exec_option: {'sync_ddl': 1, 'batch_size': 0, 'num_nodes': 0, 'disable_codegen_rows_threshold': 0, 'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0} | table_format: text/none-unique_database0]"
      15:35:55.450 ----------------------------- Captured stderr call -----------------------------
      15:35:55.450 -- connecting to: localhost:21000
      15:35:55.450 -- connecting to: localhost:21001
      15:35:55.450 -- connecting to: localhost:21002
      15:35:55.450 -- executing against localhost:21000
      15:35:55.450 use test_functions_ddl_baf0bb91;
      15:35:55.450 
      15:35:55.450 SET sync_ddl=1;
      15:35:55.450 SET batch_size=0;
      15:35:55.450 SET num_nodes=0;
      15:35:55.450 SET disable_codegen_rows_threshold=0;
      15:35:55.450 SET disable_codegen=False;
      15:35:55.450 SET abort_on_error=1;
      15:35:55.450 SET exec_single_node_rows_threshold=0;
      15:35:55.450 -- executing against localhost:21001
      15:35:55.450 use test_functions_ddl_baf0bb91;
      15:35:55.450 
      15:35:55.450 SET sync_ddl=1;
      15:35:55.450 SET batch_size=0;
      15:35:55.450 SET num_nodes=0;
      15:35:55.450 SET disable_codegen_rows_threshold=0;
      15:35:55.450 SET disable_codegen=False;
      15:35:55.450 SET abort_on_error=1;
      15:35:55.450 SET exec_single_node_rows_threshold=0;
      15:35:55.450 -- executing against localhost:21002
      15:35:55.450 use test_functions_ddl_baf0bb91;
      15:35:55.450 
      15:35:55.450 SET sync_ddl=1;
      15:35:55.450 SET batch_size=0;
      15:35:55.450 SET num_nodes=0;
      15:35:55.450 SET disable_codegen_rows_threshold=0;
      15:35:55.450 SET disable_codegen=False;
      15:35:55.450 SET abort_on_error=1;
      15:35:55.450 SET exec_single_node_rows_threshold=0;
      15:35:55.450 -- executing against localhost:21000
      15:35:55.450 create function test_functions_ddl_baf0bb91.fn() RETURNS int
      15:35:55.450 LOCATION '/test-warehouse/libTestUdfs.so' SYMBOL='Fn';
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21002
      15:35:55.450 create function test_functions_ddl_baf0bb91.fn(int) RETURNS double
      15:35:55.450 LOCATION '/test-warehouse/libTestUdfs.so' SYMBOL='Fn';
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21002
      15:35:55.450 create function test_functions_ddl_baf0bb91.fn(int, string) RETURNS int
      15:35:55.450 LOCATION '/test-warehouse/libTestUdfs.so' SYMBOL='Fn';
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21001
      15:35:55.450 create function test_functions_ddl_baf0bb91.fn(string, int) RETURNS int
      15:35:55.450 LOCATION '/test-warehouse/libTestUdfs.so' SYMBOL='Fn';
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21000
      15:35:55.450 create function test_functions_ddl_baf0bb91.fn2(int) RETURNS int
      15:35:55.450 LOCATION '/test-warehouse/libTestUdfs.so' SYMBOL='Fn2';
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21002
      15:35:55.450 create function test_functions_ddl_baf0bb91.fn2(int, string) RETURNS int
      15:35:55.450 LOCATION '/test-warehouse/libTestUdfs.so' SYMBOL='Fn2';
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21002
      15:35:55.450 create function test_functions_ddl_baf0bb91.fn_var_arg(int...) RETURNS int
      15:35:55.450 LOCATION '/test-warehouse/libTestUdfs.so' SYMBOL='VarSum';
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21001
      15:35:55.450 create aggregate function test_functions_ddl_baf0bb91.agg_fn(int) RETURNS bigint
      15:35:55.450 LOCATION '/test-warehouse/libudasample.so' UPDATE_FN='CountUpdate';
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21001
      15:35:55.450 create aggregate function test_functions_ddl_baf0bb91.agg_fn(int, string) RETURNS int
      15:35:55.450 LOCATION '/test-warehouse/libTestUdas.so' UPDATE_FN='TwoArgUpdate';
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21002
      15:35:55.450 show functions in test_functions_ddl_baf0bb91;
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21000
      15:35:55.450 show aggregate functions in test_functions_ddl_baf0bb91;
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21002
      15:35:55.450 show analytic functions in test_functions_ddl_baf0bb91;
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21002
      15:35:55.450 show create function test_functions_ddl_baf0bb91.fn_var_arg;
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21000
      15:35:55.450 show create aggregate function test_functions_ddl_baf0bb91.agg_fn;
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21002
      15:35:55.450 show create function _impala_builtins.sin;
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21002
      15:35:55.450 show create aggregate function _impala_builtins.avg;
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21002
      15:35:55.450 drop function test_functions_ddl_baf0bb91.fn2(int, string);
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21000
      15:35:55.450 show functions;
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21002
      15:35:55.450 drop function if exists test_functions_ddl_baf0bb91.fn2(int, string);
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21000
      15:35:55.450 show functions in test_functions_ddl_baf0bb91;
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21000
      15:35:55.450 show functions in test_functions_ddl_baf0bb91;
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21000
      15:35:55.450 drop function fn();
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21000
      15:35:55.450 show functions;
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21001
      15:35:55.450 drop function fn_var_arg(INT...);
      15:35:55.450 
      15:35:55.450 -- executing against localhost:21001
      15:35:55.450 show functions;
      15:35:55.450 
      15:35:55.450 MainThread: Comparing QueryTestResults (expected vs actual):
      15:35:55.450 'DOUBLE','fn(INT)','NATIVE','true' == 'DOUBLE','fn(INT)','NATIVE','true'
      15:35:55.450 'INT','fn(INT, STRING)','NATIVE','true' != 'INT','fn()','NATIVE','true'
      15:35:55.450 'INT','fn(STRING, INT)','NATIVE','true' != 'INT','fn(INT, STRING)','NATIVE','true'
      15:35:55.450 'INT','fn2(INT)','NATIVE','true' != 'INT','fn(STRING, INT)','NATIVE','true'
      15:35:55.450 None != 'INT','fn2(INT)','NATIVE','true'
      15:35:55.450 Number of rows returned (expected vs actual): 4 != 5
      15:35:55.450 ===== 1 failed, 11076 passed, 187 skipped, 304 xfailed in 31819.49 seconds =====
      15:35:55.494 ============================= test session starts ==============================
      

        Attachments

          Activity

            People

            • Assignee:
              dtsirogiannis Dimitris Tsirogiannis
              Reporter:
              alex.behm Alexander Behm
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: