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

Crash on information_schema.PROCESSLIST tmp_sctx->host_or_ip

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.11.12
    • N/A
    • Events, Information Schema
    • None
    • Windows 11 64bit AMD

    Description

      Still the crash over there that rise 8 hours after the upgrading.

      250509  6:33:28 [ERROR] xxxxxxxxxxxxxxxxxxxxxx\mysqld.exe got exception 0xc0000005 ;
      Sorry, we probably made a mistake, and this is a bug.
       
      Your assistance in bug reporting will enable us to fix this for the next release.
      To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report
      a bug on https://jira.mariadb.org/.
       
      Please include the information from the server start above, to the end of the
      information below.
       
      Server version: 10.11.12-MariaDB-log source revision: cafd22db7970ce081bafd887359aa0a77cfb769d
       
      The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
      contains instructions to obtain a better version of the backtrace below.
      Following these instructions will help MariaDB developers provide a fix quicker.
       
      Attempting backtrace. Include this in the bug report.
      (note: Retrieving this information may fail)
       
      Thread pointer: 0x1f9759de2d8
      server.dll!processlist_callback()[sql_show.cc:3338]
      server.dll!fill_schema_processlist()[sql_show.cc:3437]
      server.dll!get_schema_tables_result()[sql_show.cc:9275]
      server.dll!JOIN::exec_inner()[sql_select.cc:4930]
      server.dll!mysql_select()[sql_select.cc:5232]
      server.dll!mysql_derived_fill()[sql_derived.cc:1291]
      server.dll!mysql_handle_single_derived()[sql_derived.cc:200]
      server.dll!st_join_table::preread_init()[sql_select.cc:15645]
      server.dll!sub_select()[sql_select.cc:22964]
      server.dll!do_select()[sql_select.cc:22529]
      server.dll!JOIN::exec_inner()[sql_select.cc:4974]
      server.dll!JOIN::exec()[sql_select.cc:4753]
      server.dll!subselect_single_select_engine::exec()[item_subselect.cc:4149]
      server.dll!Item_subselect::exec()[item_subselect.cc:816]
      server.dll!Item_exists_subselect::val_bool()[item_subselect.cc:1878]
      server.dll!Item_func_not::val_bool()[item_cmpfunc.cc:204]
      server.dll!sp_instr_jump_if_not::exec_core()[sp_head.cc:4247]
      server.dll!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:3657]
      server.dll!sp_instr_jump_if_not::execute()[sp_head.cc:4230]
      server.dll!sp_head::execute()[sp_head.cc:1464]
      server.dll!sp_head::execute_procedure()[sp_head.cc:2480]
      server.dll!do_execute_sp()[sql_parse.cc:3092]
      server.dll!Sql_cmd_call::execute()[sql_parse.cc:3334]
      server.dll!mysql_execute_command()[sql_parse.cc:6179]
      server.dll!sp_instr_stmt::exec_core()[sp_head.cc:3948]
      server.dll!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:3657]
      server.dll!sp_instr_stmt::execute()[sp_head.cc:3849]
      server.dll!sp_head::execute()[sp_head.cc:1464]
      server.dll!sp_head::execute_procedure()[sp_head.cc:2480]
      server.dll!do_execute_sp()[sql_parse.cc:3092]
      server.dll!Sql_cmd_call::execute()[sql_parse.cc:3334]
      server.dll!mysql_execute_command()[sql_parse.cc:6179]
      server.dll!sp_instr_stmt::exec_core()[sp_head.cc:3948]
      server.dll!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:3657]
      server.dll!sp_instr_stmt::execute()[sp_head.cc:3849]
      server.dll!sp_head::execute()[sp_head.cc:1464]
      server.dll!sp_head::execute_procedure()[sp_head.cc:2480]
      server.dll!Event_job_data::execute()[event_data_objects.cc:1482]
      server.dll!event_worker_thread()[event_scheduler.cc:266]
      server.dll!pfs_spawn_thread()[pfs.cc:2204]
      server.dll!pthread_start()[my_winthread.c:62]
      ucrtbase.dll!wcsrchr()
      KERNEL32.DLL!BaseThreadInitThunk()
      ntdll.dll!RtlUserThreadStart()
       
      Connection ID (thread ID): 295001
      Status: NOT_KILLED
      Query (0x1f964a63330): call xxxxxxxxxxx( NAME_CONST('lock_name',_utf8mb4'yyyyyyyyyyyyyyyyyyyyyyyy' COLLATE 'utf8mb4_unicode_ci'), 0, 'proceed')
      Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=off,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=off,split_materialized=off,condition_pushdown_for_subquery=off,rowid_filter=on,condition_pushdown_from_having=off,not_null_range_scan=off,hash_join_cardinality=off,cset_narrowing=off
      

      Attachments

        1. crashlog.txt
          161 kB
        2. mysqld.dmp
          637 kB

        Activity

          People

            Unassigned Unassigned
            npdmailing@gmail.com Mitchell Lee
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.