Resource allocation failures in 'CREATE/DROP COMPRESSION_DICTIONARY' result in server crashes (debug mode) | handle_fatal_signal (sig=6) in innobase_create_zip_dict

[Roel Van de Paar]

This testcase;

DROP DATABASE test;
SET DEBUG='+d,ib_create_table_fail_too_many_trx';
CREATE COMPRESSION_DICTIONARY d0('abcd_third');

Crashes 5.7.17 debug;

(gdb) bt
#0 0x00007ff35cc4c741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x000000000185027e in my_write_core (sig=6) at /git/PS-5.7.17_dbg/mysys/stacktrace.c:249
#2 0x0000000000e81bc1 in handle_fatal_signal (sig=6) at /git/PS-5.7.17_dbg/sql/signal_handler.cc:223
#3 <signal handler called>
#4 0x00007ff35afe01d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007ff35afe18c8 in __GI_abort () at abort.c:90
#6 0x0000000001bcb3d2 in ut_dbg_assertion_failed (expr=0x21c6ddd "0", file=0x21c8320 "/git/PS-5.7.17_dbg/storage/innobase/handler/ha_innodb.cc", line=4529)
    at /git/PS-5.7.17_dbg/storage/innobase/ut/ut0dbg.cc:67
#7 0x0000000001984715 in innobase_create_zip_dict (hton=0x7ff35038f3a0, thd=0x7ff316c19000, name=0x7ff316c2b9b8 "d0", name_len=0x7ff35d237230, data=0x7ff316c2b9c0 "abcd_third",
    data_len=0x7ff35d237228) at /git/PS-5.7.17_dbg/storage/innobase/handler/ha_innodb.cc:4529
#8 0x00000000015e4da9 in mysql_create_zip_dict (thd=0x7ff316c19000, name=0x7ff316c2b9b8 "d0", name_len=2, data=0x7ff316c2b9c0 "abcd_third", data_len=10, if_not_exists=false)
    at /git/PS-5.7.17_dbg/sql/sql_zip_dict.cc:66
#9 0x000000000151fd73 in mysql_execute_command (thd=0x7ff316c19000, first_level=true) at /git/PS-5.7.17_dbg/sql/sql_parse.cc:4035
#10 0x0000000001524fed in mysql_parse (thd=0x7ff316c19000, parser_state=0x7ff35d2384e0) at /git/PS-5.7.17_dbg/sql/sql_parse.cc:5929
#11 0x0000000001519a03 in dispatch_command (thd=0x7ff316c19000, com_data=0x7ff35d238c90, command=COM_QUERY) at /git/PS-5.7.17_dbg/sql/sql_parse.cc:1495
#12 0x0000000001518849 in do_command (thd=0x7ff316c19000) at /git/PS-5.7.17_dbg/sql/sql_parse.cc:1023
#13 0x0000000001656dfe in handle_connection (arg=0x7ff32f7ff6a0) at /git/PS-5.7.17_dbg/sql/conn_handler/connection_handler_per_thread.cc:312
#14 0x000000000187ee4d in pfs_spawn_thread (arg=0x7ff350f91420) at /git/PS-5.7.17_dbg/storage/perfschema/pfs.cc:2188
#15 0x00007ff35cc47dc5 in start_thread (arg=0x7ff35d239700) at pthread_create.c:308
#16 0x00007ff35b0a273d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

[Yura Sorokin (yura-sorokin)]

https://github.com/percona/percona-server/pull/1412
https://github.com/percona/percona-server/pull/1413

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1781