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

Crash with dump file in best_access_path()

    XMLWordPrintable

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11.10
    • None
    • None
    • Windows 11 Pro x64 / 23H2

    Description

      Crash as log reported.
      The minidump uploaded in the ftp/private.

      Server version: 10.11.10-MariaDB-log source revision: 3d0fb150289716ca75cd64d62823cf715ee47646
      key_buffer_size=16777216
      read_buffer_size=67108864
      max_used_connections=66
      max_threads=103
      thread_count=48
      It is possible that mysqld could use up to 
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 13519083 K  bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.
       
      Thread pointer: 0x1422d000f18
      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...
      server.dll!best_access_path()[sql_select.cc:9031]
      server.dll!get_costs_for_tables()[sql_select.cc:10667]
      server.dll!best_extension_by_limited_search()[sql_select.cc:11250]
      server.dll!greedy_search()[sql_select.cc:9914]
      server.dll!choose_plan()[sql_select.cc:9467]
      server.dll!st_join_table::choose_best_splitting()[opt_split.cc:1083]
      server.dll!best_access_path()[sql_select.cc:8249]
      server.dll!get_costs_for_tables()[sql_select.cc:10667]
      server.dll!best_extension_by_limited_search()[sql_select.cc:11250]
      server.dll!best_extension_by_limited_search()[sql_select.cc:11449]
      server.dll!greedy_search()[sql_select.cc:9914]
      server.dll!choose_plan()[sql_select.cc:9467]
      server.dll!make_join_statistics()[sql_select.cc:6175]
      server.dll!JOIN::optimize_inner()[sql_select.cc:2641]
      server.dll!JOIN::optimize()[sql_select.cc:1956]
      server.dll!mysql_derived_optimize()[sql_derived.cc:1045]
      server.dll!mysql_handle_single_derived()[sql_derived.cc:200]
      server.dll!TABLE_LIST::handle_derived()[table.cc:9686]
      server.dll!st_select_lex::handle_derived()[sql_lex.cc:5066]
      server.dll!TABLE_LIST::handle_derived()[table.cc:9683]
      server.dll!st_select_lex::handle_derived()[sql_lex.cc:5066]
      server.dll!JOIN::optimize_inner()[sql_select.cc:2464]
      server.dll!mysql_select()[sql_select.cc:5208]
      server.dll!handle_select()[sql_select.cc:600]
      server.dll!execute_sqlcom_select()[sql_parse.cc:6412]
      server.dll!mysql_execute_command()[sql_parse.cc:3999]
      server.dll!sp_instr_stmt::exec_core()[sp_head.cc:3926]
      server.dll!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:3646]
      server.dll!sp_instr_stmt::execute()[sp_head.cc:3827]
      server.dll!sp_head::execute()[sp_head.cc:1463]
      server.dll!sp_head::execute_procedure()[sp_head.cc:2479]
      server.dll!do_execute_sp()[sql_parse.cc:3079]
      server.dll!Sql_cmd_call::execute()[sql_parse.cc:3321]
      server.dll!mysql_execute_command()[sql_parse.cc:6165]
      server.dll!sp_instr_stmt::exec_core()[sp_head.cc:3926]
      server.dll!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:3646]
      server.dll!sp_instr_stmt::execute()[sp_head.cc:3827]
      server.dll!sp_head::execute()[sp_head.cc:1463]
      server.dll!sp_head::execute_trigger()[sp_head.cc:1973]
      server.dll!Table_triggers_list::process_triggers()[sql_trigger.cc:2486]
      server.dll!write_record()[sql_insert.cc:2147]
      server.dll!mysql_insert()[sql_insert.cc:1174]
      server.dll!mysql_execute_command()[sql_parse.cc:4619]
      server.dll!sp_instr_stmt::exec_core()[sp_head.cc:3926]
      server.dll!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:3646]
      server.dll!sp_instr_stmt::execute()[sp_head.cc:3827]
      server.dll!sp_head::execute()[sp_head.cc:1463]
      server.dll!sp_head::execute_procedure()[sp_head.cc:2479]
      server.dll!do_execute_sp()[sql_parse.cc:3079]
      server.dll!Sql_cmd_call::execute()[sql_parse.cc:3321]
      server.dll!mysql_execute_command()[sql_parse.cc:6165]
      server.dll!mysql_parse()[sql_parse.cc:8178]
      server.dll!dispatch_command()[sql_parse.cc:1908]
      server.dll!do_command()[sql_parse.cc:1419]
      server.dll!do_handle_one_connection()[sql_connect.cc:1407]
      server.dll!handle_one_connection()[sql_connect.cc:1325]
      server.dll!pfs_spawn_thread()[pfs.cc:2204]
      server.dll!pthread_start()[my_winthread.c:62]
      ucrtbase.dll!_recalloc()
      KERNEL32.DLL!BaseThreadInitThunk()
      ntdll.dll!RtlUserThreadStart()
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            npdmailing@gmail.com Mitchell Lee
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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