[IMPALA-310] TPCH-Q21-Q1 causing segfault @ src/exprs/string-functions.cc:53 - impala::StringFunctions::Substring(e=0x52bae70, row=0x4ecc798)

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 1.0
• Fix Version/s: Impala 1.0
• Assignee: Nong Li
• Reporter: Lenni Kuff
• Created: 24/Apr/13 16:55
• Updated: 29/Apr/13 22:54
• Resolved: 29/Apr/13 22:54

Description

Executing TPCH-Q21-Q1 on the 10 node cluster is causing multiple impalad instances to segfault.

query (runs on seq/snap):

insert overwrite table q22_customer_tmp1
select
  round(avg(c_acctbal), 1) avg_acctbal,
  substr(c_name, 1, 1) as cust_name_char
from customer c
where
   c.c_acctbal > 0.00 and
   (substr(c.c_phone, 1, 2) = '13' or
    substr(c.c_phone, 1, 2) = '31' or
    substr(c.c_phone, 1, 2) = '23' or
    substr(c.c_phone, 1, 2) = '29' or
    substr(c.c_phone, 1, 2) = '30' or
    substr(c.c_phone, 1, 2) = '18' or
    substr(c.c_phone, 1, 2) = '17')
group by
  substr(c_name, 1, 1)

#95 0x00000035e5a9cf95 in std::basic_string<char, std::char_traits<char>, std::allocator<char> >::_S_construct<char*> (__beg=0x6d11d58 "16-702-817-2524", 
    __end=<value optimized out>, __a=<value optimized out>)
    at /usr/src/debug/gcc-4.4.6-20120305/obj-x86_64-redhat-linux/x86_64-redhat-linux/libstdc++-v3/include/bits/basic_string.tcc:139
#96 0x00000035e5a9d0f9 in _S_construct_aux<char*> (this=0x7f3abee535e0, 
    __str=<value optimized out>, __pos=<value optimized out>, 
    __n=<value optimized out>)
    at /usr/src/debug/gcc-4.4.6-20120305/obj-x86_64-redhat-linux/x86_64-redhat-linux/libstdc++-v3/include/bits/basic_string.h:1543
#97 _S_construct<char*> (this=0x7f3abee535e0, __str=<value optimized out>, 
    __pos=<value optimized out>, __n=<value optimized out>)
    at /usr/src/debug/gcc-4.4.6-20120305/obj-x86_64-redhat-linux/x86_64-redhat-linux/libstdc++-v3/include/bits/basic_string.h:1559
#98 std::basic_string<char, std::char_traits<char>, std::allocator<char> >::basic_string (this=0x7f3abee535e0, __str=<value optimized out>, 
    __pos=<value optimized out>, __n=<value optimized out>)
    at /usr/src/debug/gcc-4.4.6-20120305/obj-x86_64-redhat-linux/x86_64-redhat-linux/libstdc++-v3/include/bits/basic_string.tcc:190
#99 0x00000035e5a9d132 in std::basic_string<char, std::char_traits<char>, std::allocator<char> >::substr (this=<value optimized out>, 
    __pos=<value optimized out>, __n=<value optimized out>)
    at /usr/src/debug/gcc-4.4.6-20120305/obj-x86_64-redhat-linux/x86_64-redhat-linux/libstdc++-v3/include/bits/basic_string.h:2003
#100 0x0000000000c51995 in impala::StringFunctions::Substring (e=0x52bae70, row=0x4ecc798)
    at /usr/src/debug/impala-1.0-SNAPSHOT/be/src/exprs/string-functions.cc:53

Coredump and logs available on c2308.halxg.cloudera.com:/data/5/coredumps/756