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

Assertion `thd->killed != 0' failed in ha_maria::enable_indexes upon bootstrap with aria-encrypt-tables=1 without encryption plugin

    XMLWordPrintable

Details

    Description

      rm -rf data; mkdir data; scripts/mysql_install_db --aria-encrypt-tables=1
      

      10.4 77e44282

      mysqld: /data/src/10.4/storage/maria/ha_maria.cc:2009: virtual int ha_maria::enable_indexes(uint): Assertion `thd->killed != 0' failed.
      190827 21:54:29 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f3598ab6f12 in __GI___assert_fail (assertion=0x55f4287cd107 "thd->killed != 0", file=0x55f4287cc910 "/data/src/10.4/storage/maria/ha_maria.cc", line=2009, function=0x55f4287cdbe0 <ha_maria::enable_indexes(unsigned int)::__PRETTY_FUNCTION__> "virtual int ha_maria::enable_indexes(uint)") at assert.c:101
      #8  0x000055f4281b7399 in ha_maria::enable_indexes (this=0x55f42ab68b38, mode=2) at /data/src/10.4/storage/maria/ha_maria.cc:2009
      #9  0x000055f4281b7af2 in ha_maria::end_bulk_insert (this=0x55f42ab68b38) at /data/src/10.4/storage/maria/ha_maria.cc:2212
      #10 0x000055f42783fb41 in handler::ha_end_bulk_insert (this=0x55f42ab68b38) at /data/src/10.4/sql/handler.h:3278
      #11 0x000055f42783cd35 in select_insert::abort_result_set (this=0x55f42ab34870) at /data/src/10.4/sql/sql_insert.cc:4084
      #12 0x000055f4278bda1f in handle_select (thd=0x55f429ccce80, lex=0x55f429cd0ce8, result=0x55f42ab34870, setup_tables_done_option=1073741824) at /data/src/10.4/sql/sql_select.cc:431
      #13 0x000055f42787f744 in mysql_execute_command (thd=0x55f429ccce80) at /data/src/10.4/sql/sql_parse.cc:4642
      #14 0x000055f42788ad59 in mysql_parse (thd=0x55f429ccce80, rawbuf=0x55f42ab32738 "INSERT INTO proxies_priv SELECT * FROM tmp_proxies_priv WHERE @had_proxies_priv_table=0;", length=88, parser_state=0x7ffd59227de0, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7908
      #15 0x000055f427874b16 in bootstrap (file=0x55f429991a40 <instrumented_stdin>) at /data/src/10.4/sql/sql_parse.cc:1093
      #16 0x000055f42774d7dd in mysqld_main (argc=14, argv=0x55f429bbca38) at /data/src/10.4/sql/mysqld.cc:5814
      #17 0x000055f427741d70 in main (argc=13, argv=0x7ffd5922d2f8) at /data/src/10.4/sql/main.cc:25
      

      Also reproducible 10.5.
      Not reproducible on 10.1-10.3.

      Non-debug build doesn't crash, only produces scary-looking corruption-like errors:

      2019-08-27 21:58:21 6 [ERROR] mysqld: Unknown key id 1. Can't continue!
      2019-08-27 21:58:21 6 [ERROR] mysql.proxies_priv: 126 when fixing table
      2019-08-27 21:58:21 6 [ERROR] mysql.proxies_priv: Key 2 - Found too many records; Can't continue
      2019-08-27 21:58:21 6 [ERROR] mysql.proxies_priv: Create index by sort failed
      2019-08-27 21:58:21 6 [Warning] Warning: Enabling keys got errno 126 on mysql.proxies_priv, retrying
      2019-08-27 21:58:21 6 [ERROR] mysqld: Unknown key id 1. Can't continue!
      2019-08-27 21:58:21 6 [ERROR] mysqld: Unknown key id 1. Can't continue!
      2019-08-27 21:58:21 6 [ERROR] mysql.proxies_priv: 126 when trying to write buffers
      ERROR: 192  Unknown key id 1. Can't continue!
      2019-08-27 21:58:21 0 [ERROR] Aborting
      

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.