InnoDB: Failing assertion: *mbmaxlen < 5 in ha_innodb.cc line 1870 | sig 6 in innobase_get_cset_width

[Ramesh Sivaraman]

2014-10-20 01:15:52 7fee59322700 InnoDB: Assertion failure in thread 140661675403008 in file ha_innodb.cc line 1870
InnoDB: Failing assertion: *mbmaxlen < 5

*** Asserting query

CREATE TEMPORARY TABLE t14169459_1 (a INT, b TEXT) engine=InnoDB

*** GDB info

#0 0x00007fee78af7771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab7586 in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0
/mysys/stacktrace.c:422
#2 0x000000000072f9ff in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.2
1-69.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007fee776fb5c9 in raise () from /lib64/libc.so.6
#5 0x00007fee776fccd8 in abort () from /lib64/libc.so.6
#6 0x0000000000ace083 in innobase_get_cset_width (cset=17, mbminlen=0x7fee5931c9b8, mbmaxlen=0x7fee5931c9b0) at /mnt/workspace/percona-server-5.6-binari
es-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/handler/ha_innodb.cc:1870
#7 0x0000000000d0ab10 in dtype_get_mblen (mtype=5, prtype=1114364, mbminlen=0x7fee5931c9b8, mbmaxlen=0x7fee5931c9b0) at /mnt/workspace/percona-server-5.
6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/include/data0type.ic:96
#8 0x0000000000d0c84a in dict_mem_fill_column_struct (column=0x7fee1c142d24, col_pos=1, mtype=5, prtype=1114364, col_len=10) at /mnt/workspace/percona-s
erver-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/dict/dict0mem.cc:466
#9 0x0000000000d0c094 in dict_mem_table_add_col (table=0x7fee1c2c7478, heap=0x7fee1c1432b0, name=0x7fee1c2cfd2b "b", mtype=5, prtype=1114364, len=10) at
 /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/dict/dict0mem.cc:279
#10 0x0000000000adaeaa in create_table_def (trx=0x7fee1c2c4f48, form=0x7fee5931d9b0, table_name=0x7fee5931cd70 "tmp/#sql63d1_4_21", temp_path=0x7fee5931cf70 "/dev/shm/574753/12061/tmp/#sql63d1_4_21", remote_path=0x7fee5931d170 "", flags=1, flags2=81) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/handler/ha_innodb.cc:9392
#11 0x0000000000adc8a9 in ha_innobase::create (this=0x7fee1c2c49f0, name=0x7fee5931f970 "/dev/shm/574753/12061/tmp/#sql63d1_4_21", form=0x7fee5931d9b0, create_info=0x7fee59320280) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/handler/ha_innodb.cc:10317
#12 0x0000000000646798 in handler::ha_create (this=0x7fee1c2c49f0, name=0x7fee5931f970 "/dev/shm/574753/12061/tmp/#sql63d1_4_21", form=0x7fee5931d9b0, info=0x7fee59320280) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/handler.cc:4711
#13 0x000000000064763d in ha_create_table (thd=0x1a2dcf0, path=0x7fee5931f970 "/dev/shm/574753/12061/tmp/#sql63d1_4_21", db=0x7fee1c005748 "test", table_name=0x7fee1c0051a0 "t14169459_1", create_info=0x7fee59320280, update_create_info=false, is_temp_table=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/handler.cc:5058
#14 0x00000000008bfeb2 in rea_create_table (thd=0x1a2dcf0, path=0x7fee5931f970 "/dev/shm/574753/12061/tmp/#sql63d1_4_21", db=0x7fee1c005748 "test", table_name=0x7fee1c0051a0 "t14169459_1", create_info=0x7fee59320280, create_fields=..., keys=0, key_info=0x7fee1c005f20, file=0x7fee1c005a48, no_ha_table=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/unireg.cc:527
#15 0x0000000000853880 in create_table_impl (thd=0x1a2dcf0, db=0x7fee1c005748 "test", table_name=0x7fee1c0051a0 "t14169459_1", path=0x7fee5931f970 "/dev/shm/574753/12061/tmp/#sql63d1_4_21", create_info=0x7fee59320280, alter_info=0x7fee5931fd20, internal_tmp_table=false, select_field_count=0, no_ha_table=false, is_trans=0x7fee5931fbfe, key_info=0x7fee5931fb78, key_count=0x7fee5931fb74) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_table.cc:4968
#16 0x0000000000853d4b in mysql_create_table_no_lock (thd=0x1a2dcf0, db=0x7fee1c005748 "test", table_name=0x7fee1c0051a0 "t14169459_1", create_info=0x7fee59320280, alter_info=0x7fee5931fd20, select_field_count=0, is_trans=0x7fee5931fbfe) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_table.cc:5078
#17 0x0000000000853e5f in mysql_create_table (thd=0x1a2dcf0, create_table=0x7fee1c0051e8, create_info=0x7fee59320280, alter_info=0x7fee5931fd20) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_table.cc:5128
#18 0x00000000007e41ee in mysql_execute_command (thd=0x1a2dcf0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:3469
#19 0x00000000007ed193 in mysql_parse (thd=0x1a2dcf0, rawbuf=0x7fee1c0050a0 "CREATE TEMPORARY TABLE t14169459_1 (a INT, b TEXT) engine=InnoDB", length=64, parser_state=0x7fee59320e30) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:6773
#20 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x1a2dcf0, packet=0x222b811 "CREATE TEMPORARY TABLE t14169459_1 (a INT, b TEXT) engine=InnoDB;", packet_length=65) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1432
#21 0x00000000007de528 in do_command (thd=0x1a2dcf0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1049
#22 0x00000000007a64e5 in do_handle_one_connection (thd_arg=0x1a2dcf0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1532
#23 0x00000000007a5fed in handle_one_connection (arg=0x1a2dcf0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1443
#24 0x0000000000dc5bac in pfs_spawn_thread (arg=0x21e6fa0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/perfschema/pfs.cc:1860
#25 0x00007fee78af2df3 in start_thread () from /lib64/libpthread.so.0
#26 0x00007fee777bc01d in clone () from /lib64/libc.so.6

[Ramesh Sivaraman (rameshvs02)]

Core, GDB, error log etc

There was no master (single threaded, single mysqld run)

[Ramesh Sivaraman (rameshvs02)]

s/There was no master (single threaded, single mysqld run)/Single threaded run, single mysqld involved/

[Ramesh Sivaraman (rameshvs02)]

Testcase *****

DROP DATABASE test;CREATE DATABASE test;USE test;
SET character_set_filesystem=filename;
SET @session_start_value=@@character_set_filesystem;
SET @@session.character_set_database=@session_start_value;
set character set default;
create temporary table v0as select 'This is temp. table' A;

[Ramesh Sivaraman (rameshvs02)]

This is an upstream bug : http://bugs.mysql.com/bug.php?id=74585

[Shahriyar Rzayev (rzayev-sehriyar)]

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