Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15184

mysqld crashes with Signal 11 (Is it because of semijoin_nests ??)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.0.17
    • N/A
    • Optimizer
    • Database server -- CentOS release 6.8 (Final)
      Server version: 10.0.17-MariaDB-wsrep-log MariaDB Server, wsrep_25.10.r4144

    Description

      mysqld is crashing multiple times with Signal 11. The log.error file did not capture any SQL statement at the time of the crash. The same following entries are seen for every crash:

      Thread pointer: 0x0x7fe6f8f93008
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0x7fe6dc7fedd8 thread_stack 0x40000
      mysys/stacktrace.c:247(my_print_stacktrace)[0xbe8ede]
      sql/signal_handler.cc:153(handle_fatal_signal)[0x738a7c]
      /lib64/libpthread.so.0(+0xf7e0)[0x7fe92ad2e7e0]
      sql/opt_subselect.cc:2203(optimize_semijoin_nests(JOIN*, unsigned long long))[0x6b54ad]
      sql/sql_select.cc:4030(make_join_statistics)[0x5f06d5]
      sql/sql_select.cc:1339(JOIN::optimize_inner())[0x5f160a]
      sql/sql_select.cc:1037(JOIN::optimize())[0x5f4592]
      sql/sql_select.cc:373(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5f835d]
      sql/sql_parse.cc:5740(execute_sqlcom_select)[0x59b501]
      sql/sql_parse.cc:2851(mysql_execute_command(THD*))[0x59e47f]
      sql/sql_parse.cc:7122(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5a63ba]
      sql/sql_parse.cc:6946(wsrep_mysql_parse)[0x5a642a]
      sql/sql_parse.cc:1479(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x5a8db7]
      sql/sql_parse.cc:1077(do_command(THD*))[0x5a9737]
      sql/sql_connect.cc:1392(do_handle_one_connection(THD*))[0x673b50]
      sql/sql_connect.cc:1305(handle_one_connection)[0x673d72]
      perfschema/pfs.cc:1863(pfs_spawn_thread)[0xaa2ab9]
      /lib64/libpthread.so.0(+0x7aa1)[0x7fe92ad26aa1]
      /lib64/libc.so.6(clone+0x6d)[0x7fe929ca5bcd]

      Attachments

        Activity

          People

            alice Alice Sherepa
            Vijay C. Vijay Chenji
            Votes:
            0 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.