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

Assertion `anc_page->org_size == anc_page->size' failed in d_search upon query with EXCEPT

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0
    • 10.5, 10.6, 10.11
    • Optimizer
    • None

    Description

      reproducible on 10.5-10.7, with Myisam/InnoDB.
      maybe exists also on earlier version, but dependent on dataset/..

      10.5 a8ded395578ccab9c256b9be

      Version: '10.5.13-MariaDB-debug-log'  
      mariadbd: /10.5/src/storage/maria/ma_delete.c:507: d_search: Assertion `anc_page->org_size == anc_page->size' failed.
      211104 16:26:02 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.5.13-MariaDB-debug-log
       
      ??:0(__assert_fail)[0x7f327e738f36]
      maria/ma_delete.c:509(d_search)[0x5577eb6cc0cf]
      maria/ma_delete.c:422(d_search)[0x5577eb6cb579]
      maria/ma_delete.c:235(_ma_ck_real_delete)[0x5577eb6c952d]
      maria/ma_delete.c:184(_ma_ck_delete)[0x5577eb6c89af]
      maria/ma_delete.c:88(maria_delete)[0x5577eb6c7306]
      maria/ha_maria.cc:2411(ha_maria::delete_row(unsigned char const*))[0x5577eb5583cd]
      sql/sql_class.h:7065(handler::ha_delete_tmp_row(unsigned char*))[0x5577ea9a2a83]
      sql/sql_union.cc:516(select_unit::delete_record())[0x5577ea98a179]
      sql/sql_union.cc:169(select_unit::send_data(List<Item>&))[0x5577ea987191]
      sql/sql_class.h:5341(select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long))[0x5577ea83b613]
      sql/sql_select.cc:22085(end_send(JOIN*, st_join_table*, bool))[0x5577ea7f63a6]
      sql/sql_select.cc:21103(evaluate_join_record(JOIN*, st_join_table*, int))[0x5577ea7ee691]
      sql/sql_select.cc:29246(AGGR_OP::end_send())[0x5577ea82cf24]
      sql/sql_select.cc:20583(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x5577ea7ebd8e]
      sql/sql_select.cc:20818(sub_select(JOIN*, st_join_table*, bool))[0x5577ea7ec741]
      sql/sql_select.cc:20409(do_select(JOIN*, Procedure*))[0x5577ea7eb162]
      sql/sql_select.cc:4516(JOIN::exec_inner())[0x5577ea776e87]
      sql/sql_select.cc:4297(JOIN::exec())[0x5577ea774496]
      sql/sql_union.cc:2238(st_select_lex_unit::exec())[0x5577ea99b0f9]
      sql/sql_union.cc:42(mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*, unsigned long))[0x5577ea985cf0]
      sql/sql_select.cc:434(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5577ea749af9]
      sql/sql_parse.cc:6314(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5577ea6b2149]
      sql/sql_parse.cc:4005(mysql_execute_command(THD*))[0x5577ea6a10ea]
      sql/sql_parse.cc:8100(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5577ea6bd4a2]
      sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5577ea693363]
      sql/sql_parse.cc:1370(do_command(THD*))[0x5577ea68fca2]
      sql/sql_connect.cc:1418(do_handle_one_connection(CONNECT*, bool))[0x5577eaada1a3]
      sql/sql_connect.cc:1314(handle_one_connection)[0x5577eaad99bc]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5577eb7f3b95]
      nptl/pthread_create.c:478(start_thread)[0x7f327ec51609]
      ??:0(clone)[0x7f327e824293]
       
      Query (0x62b0000852a8): (SELECT a1 FROM t1 GROUP BY pk) EXCEPT (SELECT a1 FROM t1 GROUP BY pk)
      

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.