InnoDB: Failing assertion: fil_space_get_type(id) == FIL_TYPE_TABLESPACE in file fsp0fsp.cc line 778
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Invalid
|
Undecided
|
Unassigned | |||
5.7 |
Fix Released
|
High
|
Laurynas Biveinis |
Bug Description
** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
SET @@SESSION.
SET expand_
create table t3(id int,key id (id),constraint t2_id_fk foreign key (id) references t2 (id)) engine=innodb;
CREATE TEMPORARY TABLE t1 LIKE t3;
INSERT INTO t1 VALUES(0xABE3);
ALTER TABLE t1 ROW_FORMAT=
** GDB info
#0 0x00007f758cdc5771 in pthread_kill () from /lib64/
#1 0x0000000001832190 in my_write_core (sig=6) at /sda/PS-
#2 0x0000000000e7389f in handle_fatal_signal (sig=6) at /sda/PS-
#3 <signal handler called>
#4 0x00007f758af515d7 in raise () from /lib64/libc.so.6
#5 0x00007f758af52cc8 in abort () from /lib64/libc.so.6
#6 0x0000000001b35073 in ut_dbg_
#7 0x0000000001c2d7db in fsp_space_
#8 0x0000000001c2eb32 in fsp_try_
#9 0x0000000001c34873 in fsp_reserve_
#10 0x0000000001c34aa1 in fsp_reserve_
#11 0x0000000001b859dd in PageBulk::init (this=0x7f75368
#12 0x0000000001b87725 in BtrBulk::insert (this=0x7f758d3
#13 0x0000000001a1b83e in BtrBulk::insert (this=0x7f758d3
#14 0x0000000001a48916 in row_merge_
#15 0x0000000001a464f0 in row_merge_
#16 0x0000000001a4b28b in row_merge_
#17 0x0000000001945d6b in ha_innobase:
#18 0x00000000015a99ab in handler:
#19 0x00000000015a4783 in restore_
#20 0x00000000015a6aa0 in mysql_alter_table (thd=0x7f753681
#21 0x000000000170ec29 in Sql_cmd_
#22 0x00000000015102e4 in mysql_execute_
#23 0x00000000015122c6 in mysql_parse (thd=0x7f753681
#24 0x000000000150725d in dispatch_command (thd=0x7f753681
#25 0x0000000001506177 in do_command (thd=0x7f753681
#26 0x000000000163eea3 in handle_connection (arg=0x7f7554bf
#27 0x0000000001cb2920 in pfs_spawn_thread (arg=0x7f755c3f
#28 0x00007f758cdc0df5 in start_thread () from /lib64/
The attached tarball (1457454574_
$ vi 1457454574_mybase # STEP1: Update the base path in this file (usually the only change required!). If you use a non-binary distribution, please update SOURCE_DIR location also
$ ./1457454574_init # STEP2: Initializes the data dir
$ ./1457454574_start # STEP3: Starts mysqld
$ ./1457454574_cl # STEP4: To check mysqld is up
$ ./1457454574_
$ ./1457454574_run # OPTIONAL: Run the testcase with the mysql CLI (may not reproduce the issue, as the pquery binary was used for the original testcase reduction)
$ vi /dev/shm/
$ ./1457454574_gdb # OPTIONAL: Brings you to a gdb prompt with gdb attached to the used mysqld and attached to the generated core
$ ./1457454574_
tags: | added: expand-fast-index-creation regression |
Reduced testcase
SET expand_ fast_index_ creation= 1; COMPRESSED KEY_BLOCK_SIZE=1;
CREATE TEMPORARY TABLE t1(id int, key id (id)) engine=innodb;
INSERT INTO t1 VALUES(0xABE3);
ALTER TABLE t1 ROW_FORMAT=