Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
1.2.4
-
None
Description
Customer experienced columnstore crash, which left table locks behind.
Version: 10.3.15-MariaDB-log Columnstore 1.2.4-1
Details of crash:
/usr/local/mariadb/columnstore/mysql/lib/plugin/libcalmysql.so(_ZNSt6vectorIN5boost10shared_ptrIN8execplan9ParseTreeEEESaIS4_EEC1ERKS6_+0x18)[0x7ff95ea87ff8]
|
bits/stl_vector.h:646(std::vector<boost::shared_ptr<execplan::ParseTree>, std::allocator<boost::shared_ptr<execplan::ParseTree> > >::size() const)[0x7ff95ea72ef7]
|
mysql/ha_calpont_execplan.cpp:8033(cal_impl_if::getSelectPlan(cal_impl_if::gp_walk_info&, st_select_lex&, boost::shared_ptr<execplan::CalpontSelectExecutionPlan>&, bool))[0x7ff95ea6796d]
|
mysql/ha_from_sub.cpp:342(cal_impl_if::FromSubQuery::transform())[0x7ff95ea97e0c]
|
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))[0x7ff95ea670e2]
|
mysql/ha_calpont_execplan.cpp:8068(cal_impl_if::cp_get_plan(THD*, boost::shared_ptr<execplan::CalpontSelectExecutionPlan>&))[0x7ff95ea75ca0]
|
mysql/ha_calpont_impl.cpp:3150(ha_calpont_impl_rnd_init(TABLE*))[0x7ff95ea184dd]
|
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_ZN4JOIN13exec_infinidbEv+0x233)[0x559818d62513]
|
sql/handler.h:3098(handler::ha_rnd_init(bool))[0x559818d8a2fe]
|
sql/sql_select.cc:4097(JOIN::exec_inner())[0x559818d8af39]
|
sql/sql_select.cc:3876(JOIN::exec())[0x559818d8b14e]
|
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*))[0x559818d8bcfb]
|
sql/sql_select.cc:385(handle_select(THD*, LEX*, select_result*, unsigned long))[0x559818d3afab]
|
sql/sql_parse.cc:4336(mysql_execute_command(THD*))[0x559818d3b6c2]
|
sql/sql_class.h:2885(THD::set_row_count_func(long long))[0x559818d3c167]
|
sql/sql_parse.cc:10942(idb_vtable_process(THD*, unsigned long long, Statement*))[0x559818d3db08]
|
sql/sql_parse.cc:1875(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x559818d40562]
|
sql/sql_parse.cc:1458(do_command(THD*))[0x559818d41fb8]
|
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x559818e089e4]
|
sql/sql_connect.cc:1310(handle_one_connection)[0x559818e08aa4]
|
pthread_create.c:0(start_thread)[0x7ff962e71dd5]
|
and
Oct 01 07:05:41 PROD-UM1 ExeMgr[14138]: 41.976436 |166011|492663|0| D 16 CAL0041: Start SQL statement: SELECT DATE, NB_SIGNATURES_CTR, DATE_CREATION, DATE_MAJ FROM schema.table WHERE ( ( DATE = '2016-01-10 10:00:00' ) ); |schema|
|
Oct 01 07:05:41 PROD-UM1 kernel: show_signal_msg: 180 callbacks suppressed
|
Oct 01 07:05:41 PROD-UM1 kernel: mysqld[13872]: segfault at 350 ip 00007ff95ea87ff8 sp 00007ff8fb64d650 error 4 in libcalmysql.so.1.0.0[7ff95e9b2000+128000]
|
Oct 01 07:05:42 PROD-UM1 ExeMgr[14138]: 42.380627 |166011|492663|0| D 16 CAL0042: End SQL statement
|
Oct 01 07:05:42 PROD-UM1 ExeMgr[14138]: 42.383018 |166011|492663|0| C 16 CAL0055: ERROR: ExeMgr has caught an exception. InetStreamSocket::readToMagic(): I/O error2.1: err = -1 e = 104: Connection reset by peer
|