MySQL#74585 - InnoDB: Failing assertion: *mbmaxlen < 5 in file ha_innodb.cc line 1904

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;

InnoDB: Assertion failure in thread 140207163553536 in file ha_innodb.cc line 1904

InnoDB: Failing assertion: *mbmaxlen < 5

#5  0x00007f84843607c0 in *__GI_abort () at abort.c:92

#6  0x0000000000a015db in innobase_get_cset_width (cset=17, mbminlen=0x7f84862d54f8, mbmaxlen=0x7f84862d54f0) at 10.0/storage/xtradb/handler/ha_innodb.cc:1904

#7  0x0000000000c1ed5f in dtype_get_mblen (mtype=12, prtype=1114383, mbminlen=0x7f84862d54f8, mbmaxlen=0x7f84862d54f0) at 10.0/storage/xtradb/include/data0type.ic:96

#8  0x0000000000c209b0 in dict_mem_fill_column_struct (column=0x7f8470c60b78, col_pos=0, mtype=12, prtype=1114383, col_len=95) at 10.0/storage/xtradb/dict/dict0mem.cc:499

#9  0x0000000000c20224 in dict_mem_table_add_col (table=0x7f8470f4b978, heap=0x7f8470c29800, name=0x7f8472f8df49 "A", mtype=12, prtype=1114383, len=95) at 10.0/storage/xtradb/dict/dict0mem.cc:312

#10 0x0000000000a0ddc4 in create_table_def (trx=0x7f8470d54c78, form=0x7f84862d67c0, table_name=0x7f84862d58b0 "mysqld.1/#sql403c_3_0", temp_path=0x7f84862d5ab0 "/data/repo/bzr/10.0/mysql-test/var/tmp/mysqld.1/#sql403c_3_0", remote_path=0x7f84862d5cb0 "", flags=1, flags2=81) at 10.0/storage/xtradb/handler/ha_innodb.cc:9697

#11 0x0000000000a0f742 in ha_innobase::create (this=0x7f8470e0c088, name=0x7f84862d84c0 "/data/repo/bzr/10.0/mysql-test/var/tmp/mysqld.1/#sql403c_3_0", form=0x7f84862d67c0, create_info=0x7f84862d9cb0) at 10.0/storage/xtradb/handler/ha_innodb.cc:10616

#12 0x0000000000871070 in handler::ha_create (this=0x7f8470e0c088, name=0x7f84862d84c0 "/data/repo/bzr/10.0/mysql-test/var/tmp/mysqld.1/#sql403c_3_0", form=0x7f84862d67c0, info=0x7f84862d9cb0) at 10.0/sql/handler.cc:4285

#13 0x0000000000871f4d in ha_create_table (thd=0x7f847df0b070, path=0x7f84862d84c0 "/data/repo/bzr/10.0/mysql-test/var/tmp/mysqld.1/#sql403c_3_0", db=0x7f8470e1d788 "test", table_name=0x7f8470e1d178 "v0as", create_info=0x7f84862d9cb0, frm=0x7f84862d86d0) at 10.0/sql/handler.cc:4654

#14 0x000000000076b749 in rea_create_table (thd=0x7f847df0b070, frm=0x7f84862d86d0, path=0x7f84862d84c0 "/data/repo/bzr/10.0/mysql-test/var/tmp/mysqld.1/#sql403c_3_0", db=0x7f8470e1d788 "test", table_name=0x7f8470e1d178 "v0as", create_info=0x7f84862d9cb0, file=0x7f8470e14088, no_ha_create_table=false) at 10.0/sql/unireg.cc:378

#15 0x000000000072798e in create_table_impl (thd=0x7f847df0b070, orig_db=0x7f8470e1d788 "test", orig_table_name=0x7f8470e1d178 "v0as", db=0x7f8470e1d788 "test", table_name=0x7f8470e1d178 "v0as", path=0x7f84862d84c0 "/data/repo/bzr/10.0/mysql-test/var/tmp/mysqld.1/#sql403c_3_0", create_info=0x7f84862d9cb0, alter_info=0x7f84862d9c20, create_table_mode=1, is_trans=0x0, key_info=0x7f84862d86e8, key_count=0x7f84862d86e4, frm=0x7f84862d86d0) at 10.0/sql/sql_table.cc:4835

#16 0x0000000000727eb5 in mysql_create_table_no_lock (thd=0x7f847df0b070, db=0x7f8470e1d788 "test", table_name=0x7f8470e1d178 "v0as", create_info=0x7f84862d9cb0, alter_info=0x7f84862d9c20, is_trans=0x0, create_table_mode=1) at 10.0/sql/sql_table.cc:4949

#17 0x0000000000665686 in create_table_from_items (thd=0x7f847df0b070, create_info=0x7f84862d9cb0, create_table=0x7f8470e1d1b0, alter_info=0x7f84862d9c20, items=0x7f847df0f580, lock=0x7f84862d9878, hooks=0x7f84862d9850) at 10.0/sql/sql_insert.cc:3911

#18 0x0000000000665cf1 in select_create::prepare (this=0x7f8470e1d8a0, values=..., u=0x7f847df0ed80) at 10.0/sql/sql_insert.cc:4083

#19 0x00000000006affc9 in JOIN::prepare (this=0x7f8470e1d980, rref_pointer_array=0x7f847df0f6e0, tables_init=0x0, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f847df0f468, unit_arg=0x7f847df0ed80) at 10.0/sql/sql_select.cc:967

#20 0x00000000006b7d4d in mysql_select (thd=0x7f847df0b070, rref_pointer_array=0x7f847df0f6e0, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7f8470e1d8a0, unit=0x7f847df0ed80, select_lex=0x7f847df0f468) at 10.0/sql/sql_select.cc:3286

#21 0x00000000006ae3f5 in handle_select (thd=0x7f847df0b070, lex=0x7f847df0ecb8, result=0x7f8470e1d8a0, setup_tables_done_option=0) at 10.0/sql/sql_select.cc:373

#22 0x000000000067c469 in mysql_execute_command (thd=0x7f847df0b070) at 10.0/sql/sql_parse.cc:2997

#23 0x000000000068586f in mysql_parse (thd=0x7f847df0b070, rawbuf=0x7f8470e1d088 "create temporary table v0as select 'This is temp. table' A", length=58, parser_state=0x7f84862da630) at 10.0/sql/sql_parse.cc:6407

#24 0x0000000000678652 in dispatch_command (command=COM_QUERY, thd=0x7f847df0b070, packet=0x7f8472ff2071 "create temporary table v0as select 'This is temp. table' A", packet_length=58) at 10.0/sql/sql_parse.cc:1299

#25 0x00000000006779f7 in do_command (thd=0x7f847df0b070) at 10.0/sql/sql_parse.cc:996

#26 0x00000000007944aa in do_handle_one_connection (thd_arg=0x7f847df0b070) at 10.0/sql/sql_connect.cc:1379

#27 0x00000000007941fd in handle_one_connection (arg=0x7f847df0b070) at 10.0/sql/sql_connect.cc:1293

#28 0x0000000000ccb4a6 in pfs_spawn_thread (arg=0x7f847dfd9df0) at 10.0/storage/perfschema/pfs.cc:1860

#29 0x00007f8485f0fb50 in start_thread (arg=<optimized out>) at pthread_create.c:304

#30 0x00007f848440720d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

revision-id: sergii@pisem.net-20141103164737-457hfby1eg82zol9

date: 2014-11-03 17:47:37 +0100

build-date: 2014-11-08 18:41:28 +0400

revno: 4471

branch-nick: 10.0