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

Assertion `share->error' failed in discover_handlerton upon executing statement with max_session_mem_used = 8192

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1(EOL), 10.2(EOL)
    • 10.1.25, 10.2.7
    • Server
    • None

    Description

      See also MDEV-13011, this one can be a duplicate of it.

      set max_session_mem_used = 8192;
      select * from seq_1_to_1000;
      

      10.1 112b21da37da

      mysqld: /data/src/10.1/sql/handler.cc:4860: my_bool discover_handlerton(THD*, plugin_ref, void*): Assertion `share->error' failed.
      170606 21:07:38 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fed171daee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x0000559036d10de6 in discover_handlerton (thd=0x7fecf376d070, plugin=0x7fed194a6bf8, arg=0x7fece9dd3688) at /data/src/10.1/sql/handler.cc:4860
      #9  0x0000559036ae6b21 in plugin_foreach_with_mask (thd=0x7fecf376d070, func=0x559036d10d26 <discover_handlerton(THD*, plugin_ref, void*)>, type=1, state_mask=4294967287, arg=0x7fece9dd3688) at /data/src/10.1/sql/sql_plugin.cc:2362
      #10 0x0000559036d10f8c in ha_discover_table (thd=0x7fecf376d070, share=0x7fece9dd3688) at /data/src/10.1/sql/handler.cc:4894
      #11 0x0000559036bb64f6 in open_table_def (thd=0x7fecf376d070, share=0x7fece9dd3688, flags=11) at /data/src/10.1/sql/table.cc:584
      #12 0x0000559036c8e2a3 in tdc_acquire_share (thd=0x7fecf376d070, db=0x7fece9c22870 "test", table_name=0x7fece9c22238 "seq_1_to_1000", key=0x7fece9c226d1 "test", key_length=19, hash_value=1239472518, flags=3, out_table=0x7fed194a70a8) at /data/src/10.1/sql/table_cache.cc:639
      #13 0x0000559036a64a3b in open_table (thd=0x7fecf376d070, table_list=0x7fece9c22280, ot_ctx=0x7fed194a74e0) at /data/src/10.1/sql/sql_base.cc:2413
      #14 0x0000559036a67758 in open_and_process_table (thd=0x7fecf376d070, lex=0x7fecf37709f0, tables=0x7fece9c22280, counter=0x7fed194a7574, flags=0, prelocking_strategy=0x7fed194a75f0, has_prelocking_list=false, ot_ctx=0x7fed194a74e0) at /data/src/10.1/sql/sql_base.cc:4067
      #15 0x0000559036a687d3 in open_tables (thd=0x7fecf376d070, options=..., start=0x7fed194a7558, counter=0x7fed194a7574, flags=0, prelocking_strategy=0x7fed194a75f0) at /data/src/10.1/sql/sql_base.cc:4578
      #16 0x0000559036a69b0c in open_and_lock_tables (thd=0x7fecf376d070, options=..., tables=0x7fece9c22280, derived=true, flags=0, prelocking_strategy=0x7fed194a75f0) at /data/src/10.1/sql/sql_base.cc:5258
      #17 0x0000559036a5d593 in open_and_lock_tables (thd=0x7fecf376d070, tables=0x7fece9c22280, derived=true, flags=0) at /data/src/10.1/sql/sql_base.h:534
      #18 0x0000559036ad63fb in execute_sqlcom_select (thd=0x7fecf376d070, all_tables=0x7fece9c22280) at /data/src/10.1/sql/sql_parse.cc:5843
      #19 0x0000559036accd99 in mysql_execute_command (thd=0x7fecf376d070) at /data/src/10.1/sql/sql_parse.cc:2979
      #20 0x0000559036ad9fbb in mysql_parse (thd=0x7fecf376d070, rawbuf=0x7fece9c22088 "select * from seq_1_to_1000", length=27, parser_state=0x7fed194a8630) at /data/src/10.1/sql/sql_parse.cc:7339
      #21 0x0000559036ac8fa8 in dispatch_command (command=COM_QUERY, thd=0x7fecf376d070, packet=0x7fecf36d2071 "select * from seq_1_to_1000", packet_length=27) at /data/src/10.1/sql/sql_parse.cc:1490
      #22 0x0000559036ac7d07 in do_command (thd=0x7fecf376d070) at /data/src/10.1/sql/sql_parse.cc:1109
      #23 0x0000559036bff19d in do_handle_one_connection (thd_arg=0x7fecf376d070) at /data/src/10.1/sql/sql_connect.cc:1349
      #24 0x0000559036bfef01 in handle_one_connection (arg=0x7fecf376d070) at /data/src/10.1/sql/sql_connect.cc:1261
      #25 0x00007fed1914c494 in start_thread (arg=0x7fed194a9b00) at pthread_create.c:333
      #26 0x00007fed1729793f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.