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

Server crashes in get_schema_key_period_usage_record

    XMLWordPrintable

Details

    Description

      CREATE TABLE t (a date) engine=myisam;
      CREATE TABLE  t1 (a int) ENGINE=MERGE UNION = (t) ;
       
      SELECT 1 FROM information_schema.key_period_usage;
      

      230919 18:29:28 [ERROR] mysqld got signal 11 ;
       
      Server version: 11.3.0-MariaDB-debug-log source revision: b09e99ff759f66c29e3f67911ef4c7c0591c8a4e
       
      sql/signal_handler.cc:241(handle_fatal_signal)[0x55d44e8a6546]
      sigaction.c:0(__restore_rt)[0x7f0dd0cbd420]
      sql/sql_show.cc:7730(get_schema_key_period_usage_record(THD*, TABLE_LIST*, TABLE*, bool, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*))[0x55d44e1a3e12]
      sql/sql_show.cc:4795(fill_schema_table_by_open(THD*, st_mem_root*, bool, TABLE*, st_schema_table*, st_mysql_const_lex_string*, st_mysql_const_lex_string*, Open_tables_backup*, bool))[0x55d44e17db5c]
      sql/sql_show.cc:5473(get_all_tables(THD*, TABLE_LIST*, Item*))[0x55d44e18222f]
      sql/sql_show.cc:9295(get_schema_tables_result(JOIN*, enum_schema_table_state))[0x55d44e1b8150]
      sql/sql_select.cc:4897(JOIN::exec_inner())[0x55d44e070829]
      sql/sql_select.cc:4718(JOIN::exec())[0x55d44e06e4c0]
      sql/sql_select.cc:5249(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55d44e072ccb]
      sql/sql_select.cc:628(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x55d44e0422aa]
      sql/sql_parse.cc:6013(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55d44df636a3]
      sql/sql_parse.cc:3912(mysql_execute_command(THD*, bool))[0x55d44df53e16]
      sql/sql_parse.cc:7734(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55d44df6e702]
      sql/sql_parse.cc:1895(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55d44df46357]
      sql/sql_parse.cc:1406(do_command(THD*, bool))[0x55d44df4309c]
      sql/sql_connect.cc:1445(do_handle_one_connection(CONNECT*, bool))[0x55d44e423677]
      sql/sql_connect.cc:1349(handle_one_connection)[0x55d44e422fd4]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55d44f092a64]
      nptl/pthread_create.c:478(start_thread)[0x7f0dd0cb1609]
       
      Query (0x6290001092a8): SELECT 1 FROM information_schema.key_period_usage
      

      Attachments

        Issue Links

          Activity

            People

              nikitamalyavin Nikita Malyavin
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.