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

crash in ha_sequence during insert in partition

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Sequences
    • None

    Description

      Hio,

      crash during an insert.

      Server version: 10.3.7-MariaDB-log
      key_buffer_size=1073741824
      read_buffer_size=1073741824
      max_used_connections=0
      max_threads=65537
      thread_count=28
      It is possible that mysqld could use up to
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3148659 K  bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.
       
      Thread pointer: 0xa7ffe81fd8
      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...
      mysqld.exe!ha_sequence::table_flags()[ha_sequence.cc:283]
      mysqld.exe!get_new_handler()[handler.cc:268]
      mysqld.exe!ha_partition::create_handlers()[ha_partition.cc:2878]
      mysqld.exe!ha_partition::setup_engine_array()[ha_partition.cc:3121]
      mysqld.exe!ha_partition::get_from_handler_file()[ha_partition.cc:3162]
      mysqld.exe!ha_partition::initialize_partition()[ha_partition.cc:512]
      mysqld.exe!partition_create_handler()[ha_partition.cc:185]
      mysqld.exe!get_new_handler()[handler.cc:267]
      mysqld.exe!TABLE_SHARE::init_from_binary_frm_image()[table.cc:1710]
      mysqld.exe!open_table_def()[table.cc:672]
      mysqld.exe!tdc_acquire_share()[table_cache.cc:841]
      mysqld.exe!open_table()[sql_base.cc:1793]
      mysqld.exe!open_and_process_table()[sql_base.cc:3536]
      mysqld.exe!open_tables()[sql_base.cc:4054]
      mysqld.exe!open_and_lock_tables()[sql_base.cc:4931]
      mysqld.exe!mysql_insert()[sql_insert.cc:766]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:4723]
      mysqld.exe!mysql_parse()[sql_parse.cc:8025]
      mysqld.exe!Query_log_event::do_apply_event()[log_event.cc:5648]
      mysqld.exe!apply_event_and_update_pos_apply()[slave.cc:3917]
      mysqld.exe!apply_event_and_update_pos()[slave.cc:4066]
      mysqld.exe!exec_relay_log_event()[slave.cc:4358]
      mysqld.exe!handle_slave_sql()[slave.cc:5515]
      mysqld.exe!pthread_start()[my_winthread.c:62]
      mysqld.exe!thread_start<unsigned int (__cdecl*)(void * __ptr64)>()[thread.cpp:115]
      KERNEL32.DLL!BaseThreadInitThunk()
      ntdll.dll!RtlUserThreadStart()
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0xa7ffe4bffb): insert into bi_daten (BI_ID,time,I,P,U_diode,U_Endstufe,U_Photo,Status,Durchfluss,Temperatur,Temp_Endstufe,I_Bias)  values(1185188,5536690,1.1909543138E+1,9.782E+1,0E+0,1.1909543138E+1,3.3741264077E+0,'dsp',1.5E+2,2.02E+1,0E+0,0E+0)
      Connection ID (thread ID): 30
      Status: NOT_KILLED
       
      Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,derived_merge=on,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=off,condition_pushdown_for_derived=on,split_materialized=on
       
      The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
      information that should help you find out what is causing the crash.
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            Richard Richard Stracke
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.