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

Query from I_S.INNODB_SYS_INDEXES exceeding LIMIT ROWS EXAMINED causes ER_UNKNOWN_ERROR and LeakSanitizer errors in rec_copy_prefix_to_buf_old

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      --error 0,ER_UNKNOWN_ERROR
      SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES LIMIT ROWS EXAMINED 5;
       
      --source include/restart_mysqld.inc
      

      10.3 3e564d46

      ==3364408==ERROR: LeakSanitizer: detected memory leaks
       
      Direct leak of 24 byte(s) in 1 object(s) allocated from:
          #0 0x7f2ad8cd7e8f in __interceptor_malloc ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:145
          #1 0x55cf43204ab8 in rec_copy_prefix_to_buf_old /data/src/10.3/storage/innobase/rem/rem0rec.cc:1854
          #2 0x55cf43204ab8 in rec_copy_prefix_to_buf(unsigned char const*, dict_index_t const*, unsigned long, unsigned char**, unsigned long*) /data/src/10.3/stor
      age/innobase/rem/rem0rec.cc:1888
          #3 0x55cf4344da99 in btr_pcur_store_position(btr_pcur_t*, mtr_t*) /data/src/10.3/storage/innobase/btr/btr0pcur.cc:200
          #4 0x55cf43518ff2 in dict_getnext_system_low /data/src/10.3/storage/innobase/dict/dict0load.cc:313
          #5 0x55cf430ea9d4 in i_s_sys_indexes_fill_table /data/src/10.3/storage/innobase/handler/i_s.cc:5595
          #6 0x55cf425b90bd in get_schema_tables_result(JOIN*, enum_schema_table_state) /data/src/10.3/sql/sql_show.cc:9031
          #7 0x55cf4255cf3b in JOIN::exec_inner() /data/src/10.3/sql/sql_select.cc:4114
          #8 0x55cf4255f839 in JOIN::exec() /data/src/10.3/sql/sql_select.cc:3945
          #9 0x55cf4255fc54 in 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*) /data/src/10.3/sql/sql_select.cc:4354
          #10 0x55cf425624ff in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.3/sql/sql_select.cc:372
          #11 0x55cf423f2eff in execute_sqlcom_select /data/src/10.3/sql/sql_parse.cc:6339
          #12 0x55cf42418068 in mysql_execute_command(THD*) /data/src/10.3/sql/sql_parse.cc:3870
          #13 0x55cf42420507 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.3/sql/sql_parse.cc:7870
          #14 0x55cf42425049 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.3/sql/sql_parse.cc:1852
          #15 0x55cf4242aded in do_command(THD*) /data/src/10.3/sql/sql_parse.cc:1398
          #16 0x55cf42748cd6 in do_handle_one_connection(CONNECT*) /data/src/10.3/sql/sql_connect.cc:1403
          #17 0x55cf4274953a in handle_one_connection /data/src/10.3/sql/sql_connect.cc:1308
          #18 0x55cf4398f074 in pfs_spawn_thread /data/src/10.3/storage/perfschema/pfs.cc:1869
          #19 0x7f2ad8435ea6 in start_thread nptl/pthread_create.c:477
      

      The query ends with an error:

      mysqltest: At line 3: query 'SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES LIMIT ROWS EXAMINED 5' failed: 1105: Unknown error
      

      Normally when a query exceeds the given LIMIT ROWS EXAMINED value, it succeeds with an incomplete result and a warning:

      SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS LIMIT ROWS EXAMINED 5;
      TABLE_ID	NAME	POS	MTYPE	PRTYPE	LEN
      Warnings:
      Warning	1931	Query execution was interrupted. The query examined at least 7 rows, which exceeds LIMIT ROWS EXAMINED (5). The query result may be incomplete
      

      Reproducible on 10.3-10.9. Not reproducible on 10.2.

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              elenst Elena Stepanova
              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.