Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3376

mysqld crash - with inp as query

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.1.4
    • Icebox
    • MariaDB Server
    • 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]

      Attachments

        Activity

          People

            Unassigned Unassigned
            hill David Hill (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.