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

Server crashes in maria_status / ha_maria::info upon SELECT with partition pruning

    XMLWordPrintable

Details

    Description

      --source include/have_partition.inc
       
      CREATE TABLE t (a INT, KEY(a)) ENGINE=Aria PARTITION BY KEY(a) PARTITIONS 2;
      SELECT * FROM t PARTITION (p1);
       
      # Cleanup
      DROP TABLE t;
      

      10.3 4dc10ec6

      #3  <signal handler called>
      #4  0x0000555b93ac831d in maria_status (info=0x0, x=0x7f8f3de4f220, flag=8) at /data/src/10.3/storage/maria/ma_info.c:43
      #5  0x0000555b93adf865 in ha_maria::info (this=0x7f8f2c183668, flag=8) at /data/src/10.3/storage/maria/ha_maria.cc:2521
      #6  0x0000555b94033051 in ha_partition::info (this=0x7f8f2c182e08, flag=280) at /data/src/10.3/sql/ha_partition.cc:8315
      #7  0x0000555b94026a41 in ha_partition::open (this=0x7f8f2c182e08, name=0x7f8f2c098660 "./test/t", mode=2, test_if_locked=18) at /data/src/10.3/sql/ha_partition.cc:3653
      #8  0x0000555b938d1863 in handler::ha_open (this=0x7f8f2c182e08, table_arg=0x7f8f2c1821c0, name=0x7f8f2c098660 "./test/t", mode=2, test_if_locked=18, mem_root=0x0, partitions_to_open=0x7f8f2c014ef0) at /data/src/10.3/sql/handler.cc:2733
      #9  0x0000555b936e6533 in open_table_from_share (thd=0x7f8f2c000b00, share=0x7f8f2c098128, alias=0x7f8f2c014f88, db_stat=33, prgflag=8, ha_open_flags=18, outparam=0x7f8f2c1821c0, is_create_table=false, partitions_to_open=0x7f8f2c014ef0) at /data/src/10.3/sql/table.cc:3495
      #10 0x0000555b93540ea3 in open_table (thd=0x7f8f2c000b00, table_list=0x7f8f2c014f40, ot_ctx=0x7f8f3de4fed0) at /data/src/10.3/sql/sql_base.cc:1975
      #11 0x0000555b93543fe0 in open_and_process_table (thd=0x7f8f2c000b00, lex=0x7f8f2c004900, tables=0x7f8f2c014f40, counter=0x7f8f3de4ff64, flags=0, prelocking_strategy=0x7f8f3de4ffe0, has_prelocking_list=false, ot_ctx=0x7f8f3de4fed0) at /data/src/10.3/sql/sql_base.cc:3619
      #12 0x0000555b935451e9 in open_tables (thd=0x7f8f2c000b00, options=..., start=0x7f8f3de4ff48, counter=0x7f8f3de4ff64, flags=0, prelocking_strategy=0x7f8f3de4ffe0) at /data/src/10.3/sql/sql_base.cc:4144
      #13 0x0000555b93546f57 in open_and_lock_tables (thd=0x7f8f2c000b00, options=..., tables=0x7f8f2c014f40, derived=true, flags=0, prelocking_strategy=0x7f8f3de4ffe0) at /data/src/10.3/sql/sql_base.cc:5019
      #14 0x0000555b93507301 in open_and_lock_tables (thd=0x7f8f2c000b00, tables=0x7f8f2c014f40, derived=true, flags=0) at /data/src/10.3/sql/sql_base.h:502
      #15 0x0000555b935db2fa in execute_sqlcom_select (thd=0x7f8f2c000b00, all_tables=0x7f8f2c014f40) at /data/src/10.3/sql/sql_parse.cc:6469
      #16 0x0000555b935d2102 in mysql_execute_command (thd=0x7f8f2c000b00) at /data/src/10.3/sql/sql_parse.cc:3821
      #17 0x0000555b935df781 in mysql_parse (thd=0x7f8f2c000b00, rawbuf=0x7f8f2c014ce8 "SELECT * FROM t PARTITION (p1)", length=30, parser_state=0x7f8f3de515f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8091
      #18 0x0000555b935cca50 in dispatch_command (command=COM_QUERY, thd=0x7f8f2c000b00, packet=0x7f8f2c11ffb1 "SELECT * FROM t PARTITION (p1)", packet_length=30, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1857
      #19 0x0000555b935cb43a in do_command (thd=0x7f8f2c000b00) at /data/src/10.3/sql/sql_parse.cc:1403
      #20 0x0000555b9373403d in do_handle_one_connection (connect=0x555b960325a0) at /data/src/10.3/sql/sql_connect.cc:1402
      #21 0x0000555b93733dc1 in handle_one_connection (arg=0x555b960325a0) at /data/src/10.3/sql/sql_connect.cc:1308
      #22 0x0000555b93bd06a3 in pfs_spawn_thread (arg=0x555b95f77320) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      #23 0x00007f8f45d9f494 in start_thread (arg=0x7f8f3de52700) at pthread_create.c:333
      #24 0x00007f8f43d6793f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      All of debug, non-debug and ASAN builds fail with SIGSEGV.
      Not reproducible on 10.2.
      No crash with MyISAM.

      Attachments

        Activity

          People

            monty Michael Widenius
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.