InnoDB: Failing assertion: id != srv_tmp_space.space_id() in fsp_space_modify_check

Bug #1529555 reported by Roel Van de Paar
6
This bug affects 1 person
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

+bt
#0 0x00007fd76ac1f771 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x000000000181182c in my_write_core (sig=6) at /git/PS-5.7_dbg/mysys/stacktrace.c:247
#2 0x0000000000e609e3 in handle_fatal_signal (sig=6) at /git/PS-5.7_dbg/sql/signal_handler.cc:223
#3 <signal handler called>
#4 0x00007fd768fb95d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007fd768fbacc8 in __GI_abort () at abort.c:90
#6 0x0000000001b79057 in ut_dbg_assertion_failed (expr=0x221bed8 "id != srv_tmp_space.space_id()", file=0x221b850 "/git/PS-5.7_dbg/storage/innobase/fsp/fsp0fsp.cc", line=766) at /git/PS-5.7_dbg/storage/innobase/ut/ut0dbg.cc:67
#7 0x0000000001c6ec21 in fsp_space_modify_check (id=22, mtr=0x7fd76b207100) at /git/PS-5.7_dbg/storage/innobase/fsp/fsp0fsp.cc:766
#8 0x0000000001c74146 in fseg_alloc_free_page_low (space=0x7fd766c25018, page_size=..., seg_inode=0x7fd6d2805ef2 "", hint=0, direction=111 'o', rw_latch=RW_X_LATCH, mtr=0x7fd76b207100, init_mtr=0x7fd685461aa0, has_done_reservation=1) at /git/PS-5.7_dbg/storage/innobase/fsp/fsp0fsp.cc:2611
#9 0x0000000001c751a2 in fseg_alloc_free_page_general (seg_header=0x7fd6d28c004a "", hint=0, direction=111 'o', has_done_reservation=1, mtr=0x7fd76b207100, init_mtr=0x7fd685461aa0) at /git/PS-5.7_dbg/storage/innobase/fsp/fsp0fsp.cc:2881
#10 0x0000000001b8e13f in btr_page_alloc_low (index=0x7fd6854811a0, hint_page_no=0, file_direction=111 'o', level=0, mtr=0x7fd76b207100, init_mtr=0x7fd685461aa0) at /git/PS-5.7_dbg/storage/innobase/btr/btr0btr.cc:477
#11 0x0000000001b8e1b3 in btr_page_alloc (index=0x7fd6854811a0, hint_page_no=0, file_direction=111 'o', level=0, mtr=0x7fd76b207100, init_mtr=0x7fd685461aa0) at /git/PS-5.7_dbg/storage/innobase/btr/btr0btr.cc:510
#12 0x0000000001bc97bb in PageBulk::init (this=0x7fd6854910d8) at /git/PS-5.7_dbg/storage/innobase/btr/btr0bulk.cc:79
#13 0x0000000001bcb489 in BtrBulk::insert (this=0x7fd76b207e50, tuple=0x7fd6857ad0d8, level=0) at /git/PS-5.7_dbg/storage/innobase/btr/btr0bulk.cc:775
#14 0x0000000001a621fa in BtrBulk::insert (this=0x7fd76b207e50, tuple=0x7fd6857ad0d8) at /git/PS-5.7_dbg/storage/innobase/include/btr0bulk.h:309
#15 0x0000000001a8e518 in row_merge_insert_index_tuples (trx_id=1292, index=0x7fd6854811a0, old_table=0x7fd6854976a0, fd=-1, block=0x0, row_buf=0x7fd685525360, btr_bulk=0x7fd76b207e50, stage=0x0) at /git/PS-5.7_dbg/storage/innobase/row/row0merge.cc:3306
#16 0x0000000001a8c10e in row_merge_read_clustered_index (trx=0x7fd75ac00970, table=0x7fd685542a20, old_table=0x7fd6854976a0, new_table=0x7fd6854976a0, online=false, index=0x7fd6854372d8, fts_sort_idx=0x0, psort_info=0x0, files=0x7fd68542e538, key_numbers=0x7fd6854372e0, n_index=1, add_cols=0x0, add_v=0x0, col_map=0x0, add_autoinc=18446744073709551615, sequence=..., block=0x7fd767444000 <Address 0x7fd767444000 out of bounds>, skip_pk_sort=false, tmpfd=0x7fd76b208a4c, stage=0x7fd685450178) at /git/PS-5.7_dbg/storage/innobase/row/row0merge.cc:2417
#17 0x0000000001a90fef in row_merge_build_indexes (trx=0x7fd75ac00970, old_table=0x7fd6854976a0, new_table=0x7fd6854976a0, online=false, indexes=0x7fd6854372d8, key_numbers=0x7fd6854372e0, n_indexes=1, table=0x7fd685542a20, add_cols=0x0, col_map=0x0, add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=false, stage=0x7fd685450178, add_v=0x0) at /git/PS-5.7_dbg/storage/innobase/row/row0merge.cc:4477
#18 0x000000000198ed6f in ha_innobase::inplace_alter_table (this=0x7fd6854f2e30, altered_table=0x7fd685542a20, ha_alter_info=0x7fd76b208fb0) at /git/PS-5.7_dbg/storage/innobase/handler/handler0alter.cc:5913
#19 0x00000000015a5f4b in handler::ha_inplace_alter_table (this=0x7fd6854f2e30, altered_table=0x7fd685542a20, ha_alter_info=0x7fd76b208fb0) at /git/PS-5.7_dbg/sql/handler.h:3399
#20 0x00000000015a0e1e in restore_secondary_keys (thd=0x7fd685419000, create_info=0x7fd76b20abc0, table=0x7fd685542a20, alter_info=0x7fd76b20aaf0) at /git/PS-5.7_dbg/sql/sql_table.cc:8917
#21 0x00000000015a30a8 in mysql_alter_table (thd=0x7fd685419000, new_db=0x7fd68542bf58 "test", new_name=0x0, create_info=0x7fd76b20abc0, table_list=0x7fd68542b9d0, alter_info=0x7fd76b20aaf0) at /git/PS-5.7_dbg/sql/sql_table.cc:9814
#22 0x00000000016ef32d in Sql_cmd_alter_table::execute (this=0x7fd68542c018, thd=0x7fd685419000) at /git/PS-5.7_dbg/sql/sql_alter.cc:320
#23 0x000000000150d2d8 in mysql_execute_command (thd=0x7fd685419000, first_level=true) at /git/PS-5.7_dbg/sql/sql_parse.cc:5019
#24 0x000000000150f2ae in mysql_parse (thd=0x7fd685419000, parser_state=0x7fd76b20c500) at /git/PS-5.7_dbg/sql/sql_parse.cc:5786
#25 0x00000000015042c5 in dispatch_command (thd=0x7fd685419000, com_data=0x7fd76b20cc90, command=COM_QUERY) at /git/PS-5.7_dbg/sql/sql_parse.cc:1445
#26 0x00000000015031df in do_command (thd=0x7fd685419000) at /git/PS-5.7_dbg/sql/sql_parse.cc:1008
#27 0x000000000163aabf in handle_connection (arg=0x7fd6b6fe97f0) at /git/PS-5.7_dbg/sql/conn_handler/connection_handler_per_thread.cc:313
#28 0x0000000001840094 in pfs_spawn_thread (arg=0x7fd6b6ea8220) at /git/PS-5.7_dbg/storage/perfschema/pfs.cc:2192
#29 0x00007fd76ac1adf5 in start_thread (arg=0x7fd76b20d700) at pthread_create.c:308
#30 0x00007fd76907a1ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

# Requires mysqld option: --sql_mode=
DROP DATABASE test;CREATE DATABASE test;USE test;
SET expand_fast_index_creation=1;
CREATE TEMPORARY TABLE t1(a CHAR (1),b varchar(1));
insert into t1(a)values ('a'),('a'),('a'),('a'),('a'),(0);
ALTER TABLE t1 ADD INDEX(a);

tags: added: expand-fast-index-creation
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.