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

Server crashes in optimize_schema_tables_memory_usage after select from information_schema.innodb_sys_columns

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
      create table t1 ( name varchar(64) character set utf8, len int);
      insert into t1 values ('a',8),('b',9);
       
      select * from t1 where (name, len) in 
       ( select  name, len from information_schema.innodb_sys_columns having len = 8);
      

      Reproducible on 10.3-10.5, debug/nondebug builds, does not matter what storage engine table t1 uses. No crash on 10.2

      10.3 da88e1ec12b0ba39552bf543

      Version: '10.3.28-MariaDB-debug-log' 
      210215 14:27:45 [ERROR] mysqld got signal 11 ;
       
      Server version: 10.3.28-MariaDB-debug-log
       
      sql/sql_show.cc:8667(optimize_schema_tables_memory_usage(List<TABLE_LIST>&))[0x56440c3f5cc2]
      sql/sql_select.cc:1627(JOIN::optimize_inner())[0x56440c2ad608]
      sql/sql_select.cc:1501(JOIN::optimize())[0x56440c2ac41f]
      sql/sql_select.cc:4309(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x56440c2c958f]
      sql/sql_select.cc:370(handle_select(THD*, LEX*, select_result*, unsigned long))[0x56440c2a0270]
      sql/sql_parse.cc:6316(execute_sqlcom_select(THD*, TABLE_LIST*))[0x56440c20c6b0]
      sql/sql_parse.cc:3847(mysql_execute_command(THD*))[0x56440c1fa1f0]
      sql/sql_parse.cc:7840(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x56440c2167a7]
      sql/sql_parse.cc:1855(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x56440c1ece7c]
      sql/sql_parse.cc:1398(do_command(THD*))[0x56440c1e95b7]
      sql/sql_connect.cc:1403(do_handle_one_connection(CONNECT*))[0x56440c5da3d0]
      sql/sql_connect.cc:1309(handle_one_connection)[0x56440c5d9c88]
      perfschema/pfs.cc:1871(pfs_spawn_thread)[0x56440dd3fc8f]
      nptl/pthread_create.c:487(start_thread)[0x7f4265453fa3]
      x86_64/clone.S:97(clone)[0x7f4264dd74cf]
       
      Query (0x62b000000290): select * from t1 where (name, len) in ( select  name, len from information_schema.innodb_sys_columns having len = 8)
      
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.