[MCOL-3538] columnstore crash Created: 2019-10-02  Updated: 2020-08-25  Resolved: 2019-10-31

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.2.4
Fix Version/s: 1.2.5

Type: Bug Priority: Critical
Reporter: Rick Pizzi Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: 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



 Comments   
Comment by Todd Stoffel (Inactive) [ 2019-10-31 ]

Please do not use 1.2.4 - Upgrade to 1.2.5 right away.

Generated at Thu Feb 08 02:43:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.