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

Server crashes in get_schema_key_period_usage_record on server without InnoDB

    XMLWordPrintable

Details

    Description

      In MTR the one-line test can be run normally (as MTR already runs without InnoDB by default); upon using the client, start the server with --default-storage-engine=MyISAM --skip-innodb

      SELECT * FROM information_schema.KEY_PERIOD_USAGE;
      

      11.3 e6f224533a56e209930cdb10bf19a475d1cd4fd6

      #3  <signal handler called>
      #4  get_schema_key_period_usage_record (thd=0x7f24a4000dc8, tables=0x7f24a4208360, schema_table=0x7f24a4228750, res=true, db_name=0x7f24a41184d8, table_name=0x7f24a411aa60) at /data/src/preview-11.3-MDEV-22597-period/sql/sql_show.cc:7729
      #5  0x00005643574a58b3 in fill_schema_table_by_open (thd=0x7f24a4000dc8, mem_root=0x7f24b6139830, is_show_fields_or_keys=false, table=0x7f24a4228750, schema_table=0x564359981d20 <schema_tables+1344>, orig_db_name=0x7f24a41184d8, orig_table_name=0x7f24a411aa60, open_tables_state_backup=0x7f24b6139870, can_deadlock=false) at /data/src/preview-11.3-MDEV-22597-period/sql/sql_show.cc:4794
      #6  0x00005643574a8ed3 in get_all_tables (thd=0x7f24a4000dc8, tables=0x7f24a4015f48, cond=0x0) at /data/src/preview-11.3-MDEV-22597-period/sql/sql_show.cc:5472
      #7  0x00005643574ca4c6 in get_schema_tables_result (join=0x7f24a4017388, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/preview-11.3-MDEV-22597-period/sql/sql_show.cc:9294
      #8  0x00005643573e4b1d in JOIN::exec_inner (this=0x7f24a4017388) at /data/src/preview-11.3-MDEV-22597-period/sql/sql_select.cc:4898
      #9  0x00005643573e33c7 in JOIN::exec (this=0x7f24a4017388) at /data/src/preview-11.3-MDEV-22597-period/sql/sql_select.cc:4718
      #10 0x00005643573e6721 in mysql_select (thd=0x7f24a4000dc8, tables=0x7f24a4015f48, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2701396736, result=0x7f24a4017360, unit=0x7f24a4005218, select_lex=0x7f24a40158f0) at /data/src/preview-11.3-MDEV-22597-period/sql/sql_select.cc:5249
      #11 0x00005643573c595b in handle_select (thd=0x7f24a4000dc8, lex=0x7f24a4005138, result=0x7f24a4017360, setup_tables_done_option=0) at /data/src/preview-11.3-MDEV-22597-period/sql/sql_select.cc:628
      #12 0x0000564357316a3f in execute_sqlcom_select (thd=0x7f24a4000dc8, all_tables=0x7f24a4015f48) at /data/src/preview-11.3-MDEV-22597-period/sql/sql_parse.cc:6012
      #13 0x00005643573050b7 in mysql_execute_command (thd=0x7f24a4000dc8, is_called_from_prepared_stmt=false) at /data/src/preview-11.3-MDEV-22597-period/sql/sql_parse.cc:3911
      #14 0x000056435731ffd9 in mysql_parse (thd=0x7f24a4000dc8, rawbuf=0x7f24a4015830 "SELECT * FROM information_schema.KEY_PERIOD_USAGE", length=49, parser_state=0x7f24b613b330) at /data/src/preview-11.3-MDEV-22597-period/sql/sql_parse.cc:7734
      #15 0x00005643572f8344 in dispatch_command (command=COM_QUERY, thd=0x7f24a4000dc8, packet=0x7f24a400bc19 "SELECT * FROM information_schema.KEY_PERIOD_USAGE", packet_length=49, blocking=true) at /data/src/preview-11.3-MDEV-22597-period/sql/sql_parse.cc:1893
      #16 0x00005643572f5465 in do_command (thd=0x7f24a4000dc8, blocking=true) at /data/src/preview-11.3-MDEV-22597-period/sql/sql_parse.cc:1406
      #17 0x000056435769414b in do_handle_one_connection (connect=0x56435c575788, put_in_cache=true) at /data/src/preview-11.3-MDEV-22597-period/sql/sql_connect.cc:1445
      #18 0x0000564357693b76 in handle_one_connection (arg=0x56435c5b59a8) at /data/src/preview-11.3-MDEV-22597-period/sql/sql_connect.cc:1347
      #19 0x0000564357ff55af in pfs_spawn_thread (arg=0x56435c5752f8) at /data/src/preview-11.3-MDEV-22597-period/storage/perfschema/pfs.cc:2201
      #20 0x00007f24bb6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #21 0x00007f24bb7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Attachments

        Issue Links

          Activity

            People

              nikitamalyavin Nikita Malyavin
              elenst Elena Stepanova
              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.