[IMPALA-11396] test_low_mem_limit_orderby_all failed with Couldn't skip rows in column 'l_comment'

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Backend
• Labels: broken-build
• Epic Color: ghx-label-4
• Assignee: Zoltán Borók-Nagy
• Reporter: Zoltán Borók-Nagy
• Created: 27/Jun/22 15:29
• Updated: 12/Mar/24 07:30

Description

Error Message

query_test/test_mem_usage_scaling.py:285: in test_low_mem_limit_orderby_all     self.run_primitive_query(vector, 'primitive_orderby_all') query_test/test_mem_usage_scaling.py:273: in run_primitive_query     self.low_memory_limit_test(vector, query_name, self.MIN_MEM[query_name]) query_test/test_mem_usage_scaling.py:123: in low_memory_limit_test     assert found_expected_error, str(e) E   AssertionError: ImpalaBeeswaxException: E      Query aborted:Couldn't skip rows in column 'l_comment' in file 'hdfs://localhost:20500/test-warehouse/tpch.lineitem_parquet/f945f1c7c70575f9-1248a6b300000002_1158168046_data.0.parq'. E      E      E   assert False

Stacktrace

query_test/test_mem_usage_scaling.py:285: in test_low_mem_limit_orderby_all
    self.run_primitive_query(vector, 'primitive_orderby_all')
query_test/test_mem_usage_scaling.py:273: in run_primitive_query
    self.low_memory_limit_test(vector, query_name, self.MIN_MEM[query_name])
query_test/test_mem_usage_scaling.py:123: in low_memory_limit_test
    assert found_expected_error, str(e)
E   AssertionError: ImpalaBeeswaxException:
E      Query aborted:Couldn't skip rows in column 'l_comment' in file 'hdfs://localhost:20500/test-warehouse/tpch.lineitem_parquet/f945f1c7c70575f9-1248a6b300000002_1158168046_data.0.parq'.
E     
E     
E   assert False

Standard Error

SET client_identifier=query_test/test_mem_usage_scaling.py::TestTpchPrimitivesMemLimitError::()::test_low_mem_limit_orderby_all[mem_limit:120|protocol:beeswax|exec_option:{'test_replan':1;'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disable_codegen':False;';
-- executing against localhost:21000

use tpch_parquet;

-- 2022-06-26 19:11:11,832 INFO     MainThread: Started query a24ee409167fc20e:11fb7f1a00000000
SET client_identifier=query_test/test_mem_usage_scaling.py::TestTpchPrimitivesMemLimitError::()::test_low_mem_limit_orderby_all[mem_limit:120|protocol:beeswax|exec_option:{'test_replan':1;'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disable_codegen':False;';
SET test_replan=1;
SET batch_size=0;
SET num_nodes=0;
SET disable_codegen_rows_threshold=0;
SET disable_codegen=False;
SET abort_on_error=1;
SET default_spillable_buffer_size=256k;
SET mem_limit=120m;
SET exec_single_node_rows_threshold=0;
-- 2022-06-26 19:11:11,833 INFO     MainThread: Loading query test file: /data/jenkins/workspace/impala-cdw-master-staging-exhaustive/repos/Impala/testdata/workloads/targeted-perf/queries/primitive_orderby_all.test
-- 2022-06-26 19:11:13,848 INFO     MainThread: Query Name: 
primitive_orderby_all

-- executing against localhost:21000

-- Description : Scan a fact table and sort 50Million rows.
-- Target test case : Order by all columns in the table without returning all
--   rows to the client.
SELECT *
FROM (
  SELECT Rank() OVER (
      ORDER BY l_extendedprice
        ,l_orderkey
        ,l_partkey
        ,l_suppkey
        ,l_linenumber
        ,l_quantity
        ,l_discount
        ,l_tax
        ,l_returnflag
        ,l_linestatus
        ,l_shipdate
        ,l_commitdate
        ,l_receiptdate
        ,l_shipinstruct
        ,l_shipmode
        ,l_comment
      ) AS rank
  FROM lineitem
  WHERE l_shipdate < '1992-05-09'
  ) a
WHERE rank < 10 or rank > 99999999999;

-- 2022-06-26 19:11:13,857 INFO     MainThread: Started query a942221768a7861f:9bf0d77200000000