Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.1.4
-
None
-
2um 2pm with local query Amazon EC2 test system with t2.2xlarge instances on ubuntu 18.04
Description
I had a Ubunutu 18.04 4 server system in Amazon where I do testing from. I setup it up to match customers setup to try to duplicate an issue (29097). When I got to the point of running the query they ran, mysqld would crash.
FYI - this customer doesn't like putting DB info in JIRAs, I will followup and add as development view only
Here is my setup:
1. Set root install like 2um 2pm with local query Amazon EC2 test system with t2.2xlarge instances on ubuntu 18.04
2. Create 5 tables as shown in 29097
3. created source files and ran colxml and cpimport to populate about 100 rows per table.
4. Ran query that state was running by multi users, starts with
with inp as (select
5. Got error from console
ERROR 2013 (HY000): Lost connection to MySQL server during query
6. got BT from mysql log file
stack_bottom = 0x7f0dba4dde78 thread_stack 0x80000
/usr/local/mariadb/columnstore/mysql//bin/mysqld(my_print_stacktrace+0x29)[0x564d7c6532f9]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(handle_fatal_signal+0x4ed)[0x564d7c1a8b0d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x12890)[0x7f0df5bed890]
/usr/local/mariadb/columnstore/mysql/lib/plugin/libcalmysql.so(_ZN11cal_impl_if17buildSimpleColumnEP10Item_fieldRNS_12gp_walk_infoE+0x64)[0x7f0df2e8a744]
mysql/ha_calpont_execplan.cpp:4010(cal_impl_if::buildSimpleColumn(Item_field*, cal_impl_if::gp_walk_info&))[0x7f0df2eb40c8]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_ZN9Item_func13traverse_condEPFvPK4ItemPvES3_NS0_14traverse_orderE+0xb9)[0x564d7c1fb959]
sql/item_func.cc:452(Item_func::traverse_cond(void (Item const*, void*), void*, Item::traverse_order))[0x564d7c1d26a1]
mysql/ha_calpont_execplan.cpp:5978(cal_impl_if::getSelectPlan(cal_impl_if::gp_walk_info&, st_select_lex&, boost::shared_ptr<execplan::CalpontSelectExecutionPlan>&, bool))[0x7f0df2e9c183]
mysql/ha_from_sub.cpp:342(cal_impl_if::FromSubQuery::transform())[0x7f0df2ed322d]
mysql/ha_calpont_execplan.cpp:5816(cal_impl_if::getSelectPlan(cal_impl_if::gp_walk_info&, st_select_lex&, boost::shared_ptr<execplan::CalpontSelectExecutionPlan>&, bool))[0x7f0df2e9b6af]
mysql/ha_from_sub.cpp:342(cal_impl_if::FromSubQuery::transform())[0x7f0df2ed322d]
mysql/ha_calpont_execplan.cpp:5816(cal_impl_if::getSelectPlan(cal_impl_if::gp_walk_info&, st_select_lex&, boost::shared_ptr<execplan::CalpontSelectExecutionPlan>&, bool))[0x7f0df2e9b6af]
mysql/ha_calpont_execplan.cpp:8068(cal_impl_if::cp_get_plan(THD*, boost::shared_ptr<execplan::CalpontSelectExecutionPlan>&))[0x7f0df2ea89b2]
mysql/ha_calpont_impl.cpp:3150(ha_calpont_impl_rnd_init(TABLE*))[0x7f0df2e49a1d]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_ZN4JOIN13exec_infinidbEv+0x259)[0x564d7c026fc9]
sql/handler.h:3098(JOIN::exec_infinidb())[0x564d7c04c29e]
sql/sql_select.cc:4097(JOIN::exec_inner())[0x564d7c04ceb9]
sql/sql_select.cc:3876(JOIN::exec())[0x564d7c04d0ac]
sql/sql_select.cc:4529(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x564d7c04db46]
sql/sql_select.cc:373(handle_select(THD*, LEX*, select_result*, unsigned long))[0x564d7c000045]
sql/sql_parse.cc:4336(mysql_execute_command(THD*))[0x564d7c000759]
sql/sql_class.h:2885(idb_parse_vtable(THD*, String&, THD::infinidb_state))[0x564d7c0010a7]
sql/sql_parse.cc:10942(idb_vtable_process(THD*, unsigned long long, Statement*))[0x564d7c0029d6]
sql/sql_parse.cc:1875(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x564d7c004b58]
sql/sql_parse.cc:1422(do_command(THD*))[0x564d7c00675f]
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x564d7c0ca824]
sql/sql_connect.cc:1310(handle_one_connection)[0x564d7c0ca8f4]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76db)[0x7f0df5be26db]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f0df46e188f]