Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.4(EOL), 10.5
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
- relates to
-
MDEV-24640 ALTER on Aria table with aria_encrypt_tables=ON without encryption plugin corrupts table
- Confirmed