dataroaring opened a new issue #8815: URL: https://github.com/apache/incubator-doris/issues/8815
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version dev-1.0.1 ### What's Wrong? #0 tcmalloc::SLL_Next (t=0x61000000163) at ./src/linked_list.h:45 #1 tcmalloc::SLL_TryPop (list=0x9b9d440, rv=<optimized out>) at ./src/linked_list.h:69 #2 tcmalloc::ThreadCache::FreeList::TryPop (this=0x9b9d440, rv=<optimized out>) at ./src/thread_cache.h:220 #3 tcmalloc::ThreadCache::Allocate (this=0x9b9d3c0, size=48, cl=<optimized out>, oom_handler=<optimized out>) at ./src/thread_cache.h:379 #4 malloc_fast_path<&tcmalloc::cpp_throw_oom> (size=<optimized out>) at src/tcmalloc.cc:1898 #5 tc_new (size=<optimized out>) at src/tcmalloc.cc:2019 #6 0x0000000001dccf81 in std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >::_M_construct<char const*> ( this=0x7fddcbd738c0, __beg=0x2a3cc080 "doris::vectorized::IColumn::clone_empty() const", __end=<optimized out>) at /var/local/ldb_toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/basic_string.tcc:219 #7 std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >::_M_construct_aux<char const*> (this=0x7fddcbd738c0, __beg=0x2a3cc080 "doris::vectorized::IColumn::clone_empty() const", __end=<optimized out>) at /var/local/ldb_toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/basic_string.h:247 #8 std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >::_M_construct<char const*> (this=0x7fddcbd738c0, __beg=0x2a3cc080 "doris::vectorized::IColumn::clone_empty() const", __end=<optimized out>) at /var/local/ldb_toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/basic_string.h:266 #9 std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >::basic_string<std::allocator<char> > (this=0x7fddcbd738c0, __s=0x2a3cc080 "doris::vectorized::IColumn::clone_empty() const", __a=...) at /var/local/ldb_toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/basic_string.h:527 #10 boost::core::demangle[abi:cxx11](char const*) (name=<optimized out>) at /root/regression/incubator-doris/thirdparty/installed/include/boost/core/demangle.hpp:99 #11 0x0000000001dccb06 in boost::stacktrace::detail::to_string_impl_base<boost::stacktrace::detail::to_string_using_backtrace>::operator()[abi:cxx11](void const*) (this=this@entry=0x7fddcbd73950, addr=0x1f76451 <doris::vectorized::IColumn::clone_empty() const+17>) at /root/regression/incubator-doris/thirdparty/installed/include/boost/stacktrace/detail/frame_unwind.ipp:41 #12 0x0000000001dcc948 in boost::stacktrace::detail::to_string[abi:cxx11](boost::stacktrace::frame const*, unsigned long) (frames=0x1b031b00, size=18) at /root/regression/incubator-doris/thirdparty/installed/include/boost/stacktrace/detail/frame_unwind.ipp:76 #13 0x0000000001dc95a6 in boost::stacktrace::to_string<std::allocator<boost::stacktrace::frame> > (bt=...) at /root/regression/incubator-doris/thirdparty/installed/include/boost/stacktrace/stacktrace.hpp:402 #14 boost::stacktrace::operator<< <char, std::char_traits<char>, std::allocator<boost::stacktrace::frame> > (bt=..., os=...) at /root/regression/incubator-doris/thirdparty/installed/include/boost/stacktrace/stacktrace.hpp:408 #15 doris::signal::(anonymous namespace)::FailureSignalHandler (signal_number=<optimized out>, signal_info=<optimized out>, ucontext=<optimized out>) at /root/regression/incubator-doris/be/src/common/signal_handler.h:420 #16 <signal handler called> #17 tcmalloc::SLL_Next (t=0x61000000163) at ./src/linked_list.h:45 #18 tcmalloc::SLL_TryPop (list=0x9b9d440, rv=<optimized out>) at ./src/linked_list.h:69 #19 tcmalloc::ThreadCache::FreeList::TryPop (this=0x9b9d440, rv=<optimized out>) at ./src/thread_cache.h:220 #20 tcmalloc::ThreadCache::Allocate (this=0x9b9d3c0, size=48, cl=<optimized out>, oom_handler=<optimized out>) at ./src/thread_cache.h:379 #21 malloc_fast_path<&tcmalloc::cpp_throw_oom> (size=<optimized out>) at src/tcmalloc.cc:1898 #22 tc_new (size=<optimized out>, size@entry=40) at src/tcmalloc.cc:2019 #23 0x0000000002537e42 in COWHelper<doris::vectorized::ColumnVectorHelper, doris::vectorized::ColumnVector<unsigned char> >::create<>() () at /root/regression/incubator-doris/be/src/vec/common/cow.h:413 ### What You Expected? does not core dump ### How to Reproduce? WITH ss AS ( SELECT s_store_sk , sum(ss_ext_sales_price) sales , sum(ss_net_profit) profit FROM store_sales , date_dim , store WHERE (ss_sold_date_sk = d_date_sk) AND (d_date BETWEEN CAST('2000-08-23' AS DATE) AND (CAST('2000-08-23' AS DATE) + INTERVAL '30' DAY) ) AND (ss_store_sk = s_store_sk) GROUP BY s_store_sk ) , sr AS ( SELECT s_store_sk , sum(sr_return_amt) returns , sum(sr_net_loss) profit_loss FROM store_returns , date_dim , store WHERE (sr_returned_date_sk = d_date_sk) AND (d_date BETWEEN CAST('2000-08-23' AS DATE) AND (CAST('2000-08-23' AS DATE) + INTERVAL '30' DAY)) AND (sr_store_sk = s_store_sk) GROUP BY s_store_sk ) , cs AS ( SELECT cs_call_center_sk , sum(cs_ext_sales_price) sales , sum(cs_net_profit) profit FROM catalog_sales , date_dim WHERE (cs_sold_date_sk = d_date_sk) AND (d_date BETWEEN CAST('2000-08-23' AS DATE) AND (CAST('2000-08-23' AS DATE) + INTERVAL '30' DAY)) GROUP BY cs_call_center_sk ) , cr AS ( SELECT cr_call_center_sk , sum(cr_return_amount) returns , sum(cr_net_loss) profit_loss FROM catalog_returns , date_dim WHERE (cr_returned_date_sk = d_date_sk) AND (d_date BETWEEN CAST('200 0-08-23' AS DATE) AND (CAST('2000-08-23' AS DATE) + INTERVAL '30' DAY)) GROUP BY cr_call_center_sk ) , ws AS ( SELECT wp_web_page_sk , sum(ws_ext_sales_price) sales , sum(ws_net_profit) profit FROM web_sales , date_dim , web_page WHERE (ws_sold_date_sk = d_date_sk) AND (d_date BETWEEN CAST('2000-08-23' AS DATE) AND (CAST('2000-08-23' AS DATE) + INTERVAL '30' DAY)) AND (ws_web_page_sk = wp_web_page_sk) GROUP BY wp_web_page_sk ) , wr AS ( SELECT wp_web_page_sk , sum(wr_return_amt) returns , sum(wr_net_loss) profit_loss FROM web_returns , date_dim , web_page WHERE (wr_returned_date_sk = d_date_sk) AND (d_date BETWEEN CAST('2000-08-23' AS DATE) AND (CAST('2000-08-23' AS DATE) + INTERVAL '30' DAY)) AND (wr_web_page_sk = wp_web_page_sk) GROUP BY wp_web_page_sk ) SELECT channel , id , sum(sales) sales , sum(returns) returns , sum(profit) profit FROM ( SELECT 'store channel' channel , ss.s_store_sk id , sales , COALESCE(returns, 0) returns , (profit - COALESCE(profit_loss, 0)) profit FROM ss LEFT JOIN sr ON (ss.s_store_sk = sr.s_store_sk) UNION ALL SELECT 'catalog channel' channel , cs_call_center_sk id , sales , returns , (profit - profit_loss) profit FROM cs , cr UNION ALL SELECT 'web channel' channel , ws.wp_web_page_sk id , sales , COALESCE(returns, 0) returns , (profit - COALESCE(profit_loss, 0)) profit FROM ws LEFT JOIN wr ON (ws.wp_web_page_sk = wr.wp_web_page_sk) ) x GROUP BY ROLLUP (channel, id) ORDER BY channel ASC, id ASC, sales ASC LIMIT 100 ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
