Bug #78732 InnoDB: Failing assertion: *mbmaxlen < 5 in file ha_innodb.cc line 1803
Submitted: 7 Oct 2015 10:40 Modified: 2 Nov 2015 16:47
Reporter: Roel Van de Paar (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S6 (Debug Builds)
Version:5.7.8 (RC2), 5.7.10, 8.0.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: debug

[7 Oct 2015 10:40] Roel Van de Paar
Description:
Version: '5.7.8-rc-debug'  socket: '/sda/mysql-5.7.8-rc-linux-x86_64-debug/socket.sock'  port: 16775  MySQL Community Server (GPL)
2015-10-07 21:31:05 0x7fc6b3610700  InnoDB: Assertion failure in thread 140491389732608 in file ha_innodb.cc line 1803
InnoDB: Failing assertion: *mbmaxlen < 5

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
SET SESSION big_tables=1;
CREATE TABLE t1(a int)ENGINE=InnoDB;
SET character_set_filesystem=filename;
SET @session_start_value=@@session.character_set_filesystem;
SET @@session.collation_connection=@session_start_value;
select substr(Z.a,-1),Z.a from t1 as Y join t1 as Z on Y.a=Z.a order by 1;
[7 Oct 2015 10:40] Roel Van de Paar
+bt
#0  0x00007fc6b3016771 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1  0x0000000001721318 in my_write_core (sig=6) at /git/mysql-server_dbg/mysys/stacktrace.c:247
#2  0x0000000000dd6008 in handle_fatal_signal (sig=6) at /git/mysql-server_dbg/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007fc6b1c1a5d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5  0x00007fc6b1c1bcc8 in __GI_abort () at abort.c:90
#6  0x0000000001a6f71b in ut_dbg_assertion_failed (expr=0x1fc5acd "*mbmaxlen < 5", file=0x1fc52a0 "/git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc", line=1803) at /git/mysql-server_dbg/storage/innobase/ut/ut0dbg.cc:67
#7  0x000000000184b049 in innobase_get_cset_width (cset=17, mbminlen=0x7fc6b360d048, mbmaxlen=0x7fc6b360d040) at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:1803
#8  0x0000000001b31a04 in dtype_get_mblen (mtype=12, prtype=1114127, mbminlen=0x7fc6b360d048, mbmaxlen=0x7fc6b360d040) at /git/mysql-server_dbg/storage/innobase/include/data0type.ic:94
#9  0x0000000001b33e4b in dict_mem_fill_column_struct (column=0x7fc5e80d8da0, col_pos=0, mtype=12, prtype=1114127, col_len=5) at /git/mysql-server_dbg/storage/innobase/dict/dict0mem.cc:592
#10 0x0000000001b33346 in dict_mem_table_add_col (table=0x7fc5e80906a0, heap=0x7fc5e8039518, name=0x7fc6b360d100 "_substr(Z.a,-1)_0", mtype=12, prtype=1114127, len=5) at /git/mysql-server_dbg/storage/innobase/dict/dict0mem.cc:308
#11 0x000000000186d9a1 in create_table_info_t::create_table_def (this=0x7fc6b360d580) at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:9498
#12 0x000000000185c15c in create_table_info_t::create_table (this=0x7fc6b360d580) at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:11108
#13 0x000000000185ccef in ha_innobase::create (this=0x7fc5e80aa430, name=0x7fc5e80a2fa8 "/sda/mysql-5.7.8-rc-linux-x86_64-debug/data/#sql_47f6_0", form=0x7fc5e80a2030, create_info=0x7fc6b360dd20) at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:11447
#14 0x00000000014c3801 in create_innodb_tmp_table (table=0x7fc5e80a2030, keyinfo=0x7fc5e80a2d88) at /git/mysql-server_dbg/sql/sql_tmp_table.cc:2234
#15 0x00000000014c3c86 in instantiate_tmp_table (table=0x7fc5e80a2030, keyinfo=0x7fc5e80a2d88, start_recinfo=0x7fc5e80a2e28, recinfo=0x7fc5e80a09d8, options=2147748608, big_tables=1 '\001', trace=0x7fc5e801c1f8) at /git/mysql-server_dbg/sql/sql_tmp_table.cc:2338
#16 0x00000000013e18ae in QEP_tmp_table::prepare_tmp_table (this=0x7fc5e80a0b28) at /git/mysql-server_dbg/sql/sql_executor.cc:4601
#17 0x00000000013e1a40 in QEP_tmp_table::put_record (this=0x7fc5e80a0b28, end_of_records=true) at /git/mysql-server_dbg/sql/sql_executor.cc:4643
#18 0x00000000013e1aef in QEP_tmp_table::end_send (this=0x7fc5e80a0b28) at /git/mysql-server_dbg/sql/sql_executor.cc:4667
#19 0x00000000013d8eb9 in sub_select_op (join=0x7fc5e809d358, qep_tab=0x7fc5e80a0748, end_of_records=true) at /git/mysql-server_dbg/sql/sql_executor.cc:1057
#20 0x00000000013d8fec in sub_select (join=0x7fc5e809d358, qep_tab=0x7fc5e80a05d0, end_of_records=true) at /git/mysql-server_dbg/sql/sql_executor.cc:1214
#21 0x00000000013d8ed9 in sub_select_op (join=0x7fc5e809d358, qep_tab=0x7fc5e80a05d0, end_of_records=true) at /git/mysql-server_dbg/sql/sql_executor.cc:1059
#22 0x00000000013d8fec in sub_select (join=0x7fc5e809d358, qep_tab=0x7fc5e80a0458, end_of_records=true) at /git/mysql-server_dbg/sql/sql_executor.cc:1214
#23 0x00000000013d8b6c in do_select (join=0x7fc5e809d358) at /git/mysql-server_dbg/sql/sql_executor.cc:940
#24 0x00000000013d6b13 in JOIN::exec (this=0x7fc5e809d358) at /git/mysql-server_dbg/sql/sql_executor.cc:200
#25 0x000000000146d4e2 in handle_query (thd=0x7fc5e801a000, lex=0x7fc5e801c210, result=0x7fc5e802df98, added_options=0, removed_options=0) at /git/mysql-server_dbg/sql/sql_select.cc:184
#26 0x0000000001424906 in execute_sqlcom_select (thd=0x7fc5e801a000, all_tables=0x7fc5e802d830) at /git/mysql-server_dbg/sql/sql_parse.cc:4843
#27 0x000000000141e332 in mysql_execute_command (thd=0x7fc5e801a000) at /git/mysql-server_dbg/sql/sql_parse.cc:2521
#28 0x000000000142584f in mysql_parse (thd=0x7fc5e801a000, parser_state=0x7fc6b360f680) at /git/mysql-server_dbg/sql/sql_parse.cc:5255
#29 0x000000000141b458 in dispatch_command (thd=0x7fc5e801a000, com_data=0x7fc6b360fdc0, command=COM_QUERY) at /git/mysql-server_dbg/sql/sql_parse.cc:1272
#30 0x000000000141a10e in do_command (thd=0x7fc5e801a000) at /git/mysql-server_dbg/sql/sql_parse.cc:852
#31 0x0000000001541c80 in handle_connection (arg=0x7fc5fbfc9200) at /git/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:300
#32 0x000000000174e31f in pfs_spawn_thread (arg=0x7fc6a8fe8d20) at /git/mysql-server_dbg/storage/perfschema/pfs.cc:2178
#33 0x00007fc6b3011df5 in start_thread (arg=0x7fc6b3610700) at pthread_create.c:308
#34 0x00007fc6b1cdb1ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
[7 Oct 2015 11:22] Umesh Shastry
Hello Roel,

Thank you for the report and test case.
Observed that 5.7.10 debug build is affected.

Thanks,
Umesh
[7 Oct 2015 11:23] Umesh Shastry
// 5.7.10 - only debug build affected

bin/mysql_install_db --insecure --basedir=/export/umesh/server/binaries/mysql-advanced-5.7.10 --datadir=/export/umesh/server/binaries/mysql-advanced-5.7.10/78732 -v
bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/mysql-advanced-5.7.10 --datadir=/export/umesh/server/binaries/mysql-advanced-5.7.10/78732 --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/server/binaries/mysql-advanced-5.7.10/78732/log.err 2>&1 &

- build used

commit: d938a21fec3d67ee00498a48ac20586bad147600
date: 2015-10-06 09:47:31 +0530
build-date: 2015-10-06 18:03:13 +0200
short: d938a21
branch: mysql-5.7

MySQL source 5.7.10

(gdb) bt
#0  0x00007f7f9af48771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000017e4280 in my_write_core (sig=6) at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/mysys/stacktrace.c:247
#2  0x0000000000e505e2 in handle_fatal_signal (sig=6) at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f7f999425d7 in raise () from /lib64/libc.so.6
#5  0x00007f7f99943cc8 in abort () from /lib64/libc.so.6
#6  0x0000000001b4dc57 in ut_dbg_assertion_failed (expr=0x224d835 "*mbmaxlen < 5",
    file=0x224c868 "/export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/storage/innobase/handler/ha_innodb.cc", line=1855)
    at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/storage/innobase/ut/ut0dbg.cc:67
#7  0x000000000191d7ce in innobase_get_cset_width (cset=17, mbminlen=0x7f7f6d73f608, mbmaxlen=0x7f7f6d73f600)
    at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/storage/innobase/handler/ha_innodb.cc:1855
#8  0x0000000001c13078 in dtype_get_mblen (mtype=12, prtype=1114127, mbminlen=0x7f7f6d73f608, mbmaxlen=0x7f7f6d73f600)
    at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/storage/innobase/include/data0type.ic:94
#9  0x0000000001c155cd in dict_mem_fill_column_struct (column=0x7f7f2c026a50, col_pos=0, mtype=12, prtype=1114127, col_len=5)
    at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/storage/innobase/dict/dict0mem.cc:605
#10 0x0000000001c14a1d in dict_mem_table_add_col (table=0x7f7f2c0105a0, heap=0x7f7f2c0270a8, name=0x7f7f6d73f8c0 "_substr(Z.a,-1)_0", mtype=12, prtype=1114127, len=5)
    at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/storage/innobase/dict/dict0mem.cc:318
#11 0x000000000194132d in create_table_info_t::create_table_def (this=0x7f7f6d73fd40)
    at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/storage/innobase/handler/ha_innodb.cc:9644
#12 0x000000000192ee42 in create_table_info_t::create_table (this=0x7f7f6d73fd40)
    at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/storage/innobase/handler/ha_innodb.cc:11228
#13 0x000000000192fa23 in ha_innobase::create (this=0x7f7f2c0265d0, name=0x7f7f2c026568 "/tmp/#sql_1cff_0", form=0x7f7f2c025600, create_info=0x7f7f6d7404e0)
    at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/storage/innobase/handler/ha_innodb.cc:11576
#14 0x000000000157e657 in create_innodb_tmp_table (table=0x7f7f2c025600, keyinfo=0x7f7f2c026348)
    at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_tmp_table.cc:2250
#15 0x000000000157eb2a in instantiate_tmp_table (table=0x7f7f2c025600, keyinfo=0x7f7f2c026348, start_recinfo=0x7f7f2c0263e8, recinfo=0x7f7f2c023bf8, options=2147748608, big_tables=1 '\001',
    trace=0x7f7f2c002cb8) at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_tmp_table.cc:2350
#16 0x0000000001498cd2 in QEP_tmp_table::prepare_tmp_table (this=0x7f7f2c01d728) at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_executor.cc:4572
#17 0x0000000001498e64 in QEP_tmp_table::put_record (this=0x7f7f2c01d728, end_of_records=true) at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_executor.cc:4614
#18 0x0000000001498f13 in QEP_tmp_table::end_send (this=0x7f7f2c01d728) at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_executor.cc:4638
#19 0x000000000149029f in sub_select_op (join=0x7f7f2c01cae0, qep_tab=0x7f7f2c023900, end_of_records=true)
    at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_executor.cc:1060
#20 0x00000000014903dc in sub_select (join=0x7f7f2c01cae0, qep_tab=0x7f7f2c023788, end_of_records=true)
    at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_executor.cc:1217
#21 0x00000000014902bf in sub_select_op (join=0x7f7f2c01cae0, qep_tab=0x7f7f2c023788, end_of_records=true)
    at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_executor.cc:1062
#22 0x00000000014903dc in sub_select (join=0x7f7f2c01cae0, qep_tab=0x7f7f2c023610, end_of_records=true)
    at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_executor.cc:1217
#23 0x000000000148ff46 in do_select (join=0x7f7f2c01cae0) at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_executor.cc:943
#24 0x000000000148de55 in JOIN::exec (this=0x7f7f2c01cae0) at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_executor.cc:199
#25 0x0000000001526b22 in handle_query (thd=0x7f7f2c000b70, lex=0x7f7f2c002cd0, result=0x7f7f2c0074f0, added_options=0, removed_options=0)
    at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_select.cc:184
#26 0x00000000014dd186 in execute_sqlcom_select (thd=0x7f7f2c000b70, all_tables=0x7f7f2c006d88) at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_parse.cc:4947
#27 0x00000000014d69df in mysql_execute_command (thd=0x7f7f2c000b70, first_level=true) at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_parse.cc:2597
#28 0x00000000014de0b7 in mysql_parse (thd=0x7f7f2c000b70, parser_state=0x7f7f6d741dd0) at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_parse.cc:5357
#29 0x00000000014d390e in dispatch_command (thd=0x7f7f2c000b70, com_data=0x7f7f6d742e00, command=COM_QUERY)
    at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_parse.cc:1284
#30 0x00000000014d27a7 in do_command (thd=0x7f7f2c000b70) at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/sql_parse.cc:852
#31 0x00000000015fed79 in handle_connection (arg=0x41b36b0) at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/sql/conn_handler/connection_handler_per_thread.cc:295
#32 0x000000000189b064 in pfs_spawn_thread (arg=0x41fa720) at /export/home2/pb2/build/sb_0-16667756-1444148157.1/mysqlcom-pro-5.7.10/storage/perfschema/pfs.cc:2192
#33 0x00007f7f9af43df5 in start_thread () from /lib64/libpthread.so.0
#34 0x00007f7f99a0360d in clone () from /lib64/libc.so.6
(gdb)
[7 Oct 2015 11:27] Umesh Shastry
// 5.8.0 - only debug build is affected

bin/mysql_install_db  --insecure --basedir=/export/umesh/server/binaries/mysql-advanced-5.8.0 --datadir=/export/umesh/server/binaries/mysql-advanced-5.8.0/78732 -v
bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/mysql-advanced-5.8.0 --datadir=/export/umesh/server/binaries/mysql-advanced-5.8.0/78732 --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/server/binaries/mysql-advanced-5.8.0/78732/log.err 2>&1 &

[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.8.0: cat docs/INFO_SRC
commit: ebe2d8c4433b27eefa69f31f638c0601e9d525e2
date: 2015-10-06 16:12:45 +0200
build-date: 2015-10-06 17:01:57 +0200
short: ebe2d8c
branch: mysql-trunk

MySQL source 5.8.0

(gdb) bt
#0  0x00007f932bfe9771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000017d872f in my_write_core (sig=6) at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/mysys/stacktrace.cc:251
#2  0x00000000010131b1 in handle_fatal_signal (sig=6) at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/signal_handler.cc:218
#3  <signal handler called>
#4  0x00007f932a9e35d7 in raise () from /lib64/libc.so.6
#5  0x00007f932a9e4cc8 in abort () from /lib64/libc.so.6
#6  0x0000000001ab668f in ut_dbg_assertion_failed (expr=0x215a1d5 "*mbmaxlen < 5",
    file=0x2159188 "/export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/ha_innodb.cc", line=1881)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/storage/innobase/ut/ut0dbg.cc:67
#7  0x00000000018853ad in innobase_get_cset_width (cset=17, mbminlen=0x7f92fe7da828, mbmaxlen=0x7f92fe7da820)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/ha_innodb.cc:1881
#8  0x0000000001b87450 in dtype_get_mblen (mtype=12, prtype=1114127, mbminlen=0x7f92fe7da828, mbmaxlen=0x7f92fe7da820)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/storage/innobase/include/data0type.ic:94
#9  0x0000000001b89a01 in dict_mem_fill_column_struct (column=0x7f92bc9660d0, col_pos=0, mtype=12, prtype=1114127, col_len=5)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/storage/innobase/dict/dict0mem.cc:605
#10 0x0000000001b88e51 in dict_mem_table_add_col (table=0x7f92bc0109a0, heap=0x7f92bc966748, name=0x7f92fe7daae0 "_substr(Z.a,-1)_0", mtype=12, prtype=1114127, len=5)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/storage/innobase/dict/dict0mem.cc:318
#11 0x00000000018a8cdb in create_table_info_t::create_table_def (this=0x7f92fe7daf60)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/ha_innodb.cc:9694
#12 0x0000000001896c66 in create_table_info_t::create_table (this=0x7f92fe7daf60)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/ha_innodb.cc:11262
#13 0x000000000189788b in ha_innobase::create (this=0x7f92bc965c50, name=0x7f92bc965be8 "/tmp/#sql_1ec4_0", form=0x7f92bc964c80, create_info=0x7f92fe7db4f0)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/ha_innodb.cc:11601
#14 0x0000000000f846c3 in create_innodb_tmp_table (table=0x7f92bc964c80, keyinfo=0x7f92bc9659c8)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_tmp_table.cc:2258
#15 0x0000000000f84b96 in instantiate_tmp_table (table=0x7f92bc964c80, keyinfo=0x7f92bc9659c8, start_recinfo=0x7f92bc965a68, recinfo=0x7f92bc923658, options=2147748608, big_tables=1 '\001',
    trace=0x7f92bc002cd0) at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_tmp_table.cc:2359
#16 0x0000000000ec70e8 in QEP_tmp_table::prepare_tmp_table (this=0x7f92bc020458) at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_executor.cc:4580
#17 0x0000000000ec727a in QEP_tmp_table::put_record (this=0x7f92bc020458, end_of_records=true)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_executor.cc:4622
#18 0x0000000000ec7329 in QEP_tmp_table::end_send (this=0x7f92bc020458) at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_executor.cc:4646
#19 0x0000000000ebe733 in sub_select_op (join=0x7f92bc01f810, qep_tab=0x7f92bc923360, end_of_records=true)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_executor.cc:1075
#20 0x0000000000ebe870 in sub_select (join=0x7f92bc01f810, qep_tab=0x7f92bc9231e8, end_of_records=true)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_executor.cc:1225
#21 0x0000000000ebe753 in sub_select_op (join=0x7f92bc01f810, qep_tab=0x7f92bc9231e8, end_of_records=true)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_executor.cc:1077
#22 0x0000000000ebe870 in sub_select (join=0x7f92bc01f810, qep_tab=0x7f92bc923070, end_of_records=true)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_executor.cc:1225
#23 0x0000000000ebe3f6 in do_select (join=0x7f92bc01f810) at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_executor.cc:958
#24 0x0000000000ebc379 in JOIN::exec (this=0x7f92bc01f810) at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_executor.cc:214
#25 0x0000000000f29d4e in handle_query (thd=0x7f92bc000b70, lex=0x7f92bc002ce8, result=0x7f92bc007510, added_options=0, removed_options=0)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_select.cc:190
#26 0x0000000000eec9a5 in execute_sqlcom_select (thd=0x7f92bc000b70, all_tables=0x7f92bc006da8)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:4898
#27 0x0000000000ee6404 in mysql_execute_command (thd=0x7f92bc000b70, first_level=true) at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:2564
#28 0x0000000000eed8aa in mysql_parse (thd=0x7f92bc000b70, parser_state=0x7f92fe7dcdd0) at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:5304
#29 0x0000000000ee3397 in dispatch_command (thd=0x7f92bc000b70, com_data=0x7f92fe7dde00, command=COM_QUERY)
    at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:1251
#30 0x0000000000ee2248 in do_command (thd=0x7f92bc000b70) at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:819
#31 0x00000000010036b7 in handle_connection (arg=0x3f7ce20) at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/sql/conn_handler/connection_handler_per_thread.cc:296
#32 0x000000000180c658 in pfs_spawn_thread (arg=0x3fb5ee0) at /export/home2/pb2/build/sb_0-16667071-1444144424.84/mysqlcom-pro-5.8.0-m17/storage/perfschema/pfs.cc:2211
#33 0x00007f932bfe4df5 in start_thread () from /lib64/libpthread.so.0
#34 0x00007f932aaa460d in clone () from /lib64/libc.so.6
(gdb)
[8 Oct 2015 14:08] Marko Mäkelä
Posted by developer:
 
This leads to a corruption of a main-memory data structure inside InnoDB.
I think that we must revert the applicable parts of patches of MySQL Bug#52199 and Bug#35391, and make both mbminlen and mbmaxlen 3 bits wide.
[14 Oct 2015 8:19] Manyi Lu
Posted by developer:
 
See: https://bugs.mysql.com/bug.php?id=37554

Noted in 6.0.10 changelog.  The internal-use-only filename character set was visible in the output of some SHOW statements and in the contents of the CHARACTER_SET_COLLATION_APPLICABILITY table of INFORMATION_SCHEMA.
Fix: don't display internal collations."
[2 Nov 2015 16:47] Paul Dubois
Noted in 5.7.10, 5.8.0 changelogs.

The filename character set is intended for internal use, but 
references to it in SQL statements did not produce an error. Now they
do.
[22 Dec 2015 6:09] Erlend Dahl
Bug#74585 Failing assertion: *mbmaxlen < 5 in ha_innodb.cc line 1588

was marked as a duplicate.
[18 Jun 2016 21:28] Omer Barnir
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0