-
Type:
Bug
-
Status: Done
-
Priority:
Medium
-
Resolution: Fixed
-
Affects Version/s: 5.7.26-29
-
Fix Version/s: 5.7.27-30
-
Component/s: None
-
Labels:
crash in create temporary table.
#0 0x00007f1f6611397c in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000018f8ee3 in my_write_core (sig=6) at /home/rahul.malik/MySQL/percona-server/mysys/stacktrace.c:249
#2 0x0000000001677c36 in handle_fatal_signal (sig=6) at /home/rahul.malik/MySQL/percona-server/sql/signal_handler.cc:223
#3 <signal handler called>
#4 0x00007f1f649a04f5 in raise () from /lib64/libc.so.6
#5 0x00007f1f649a1cd5 in abort () from /lib64/libc.so.6
#6 0x0000000001c12b0b in ut_dbg_assertion_failed (expr=0x23eadec "flags == space->flags", file=0x23ea1c0 "/home/rahul.malik/MySQL/percona-server/storage/innobase/fsp/fsp0fsp.cc", line=1753) at /home/rahul.malik/MySQL/percona-server/storage/innobase/ut/ut0dbg.cc:67
#7 0x0000000001d29d4c in fsp_fill_free_list (init_space=false, space=0x4f581f8, header=0x7f1f4c55c026 "", mtr=0x7f1f302aecf0) at /home/rahul.malik/MySQL/percona-server/storage/innobase/fsp/fsp0fsp.cc:1753
#8 0x0000000001d2a68b in fsp_alloc_free_extent (space_id=1417, page_size=..., hint=0, mtr=0x7f1f302aecf0) at /home/rahul.malik/MySQL/percona-server/storage/innobase/fsp/fsp0fsp.cc:1924
#9 0x0000000001d2ad4f in fsp_alloc_free_page (space=1417, page_size=..., hint=0, rw_latch=RW_SX_LATCH, mtr=0x7f1f302aecf0, init_mtr=0x7f1f302aecf0) at /home/rahul.malik/MySQL/percona-server/storage/innobase/fsp/fsp0fsp.cc:2094
#10 0x0000000001d2ea19 in fseg_alloc_free_page_low (space=0x4f581f8, page_size=..., seg_inode=0x7f1f4dd17032 "", hint=0, direction=111 'o', rw_latch=RW_SX_LATCH, mtr=0x7f1f302aecf0, init_mtr=0x7f1f302aecf0, has_done_reservation=0) at /home/rahul.malik/MySQL/percona-server/storage/innobase/fsp/fsp0fsp.cc:3246
#11 0x0000000001d2d2fe in fseg_create_general (space_id=1417, page=0, byte_offset=84, has_done_reservation=0, mtr=0x7f1f302aecf0) at /home/rahul.malik/MySQL/percona-server/storage/innobase/fsp/fsp0fsp.cc:2822
#12 0x0000000001d2d4e4 in fseg_create (space=1417, page=0, byte_offset=84, mtr=0x7f1f302aecf0) at /home/rahul.malik/MySQL/percona-server/storage/innobase/fsp/fsp0fsp.cc:2882
#13 0x0000000001c29b3e in btr_create (type=3, space=1417, page_size=..., index_id=4874, index=0x7f1e9001e9c0, btr_redo_create_info=0x0, mtr=0x7f1f302aecf0) at /home/rahul.malik/MySQL/percona-server/storage/innobase/btr/btr0btr.cc:1111
#14 0x0000000001cb77da in dict_create_index_tree_in_mem (index=0x7f1e9001e9c0, trx=0x7f1f59ebd400) at /home/rahul.malik/MySQL/percona-server/storage/innobase/dict/dict0crea.cc:1095
#15 0x0000000001b333cf in row_create_index_for_mysql (index=0x7f1e9001e9c0, trx=0x7f1f59ebd400, field_lengths=0x7f1e9000e950, handler=0x0) at /home/rahul.malik/MySQL/percona-server/storage/innobase/row/row0mysql.cc:3935
#16 0x00000000019dd4f3 in create_index (trx=0x7f1f59ebd400, form=0x7f1f302b02e0, flags=33, table_name=0x7f1f302afa30 "tmp/#sql78bb_2e_1", key_num=0) at /home/rahul.malik/MySQL/percona-server/storage/innobase/handler/ha_innodb.cc:11820
#17 0x00000000019c7918 in create_table_info_t::create_table (this=0x7f1f302af4f0) at /home/rahul.malik/MySQL/percona-server/storage/innobase/handler/ha_innodb.cc:13345
#18 0x00000000019c85cd in ha_innobase::create (this=0x7f1e9001c070, name=0x7f1f302b2080 "/tmp/#sql78bb_2e_1", form=0x7f1f302b02e0, create_info=0x7f1f302b28f0) at /home/rahul.malik/MySQL/percona-server/storage/innobase/handler/ha_innodb.cc:13685
#19 0x0000000000f265dc in handler::ha_create (this=0x7f1e9001c070, name=0x7f1f302b2080 "/tmp/#sql78bb_2e_1", form=0x7f1f302b02e0, info=0x7f1f302b28f0) at /home/rahul.malik/MySQL/percona-server/sql/handler.cc:5279
#20 0x0000000000f27218 in ha_create_table (thd=0x7f1e90000b70, path=0x7f1f302b2080 "/tmp/#sql78bb_2e_1", db=0x7f1e90006c40 "test", table_name=0x7f1e90006680 "tt_1_t", create_info=0x7f1f302b28f0, create_fields=0x7f1f302b23c0, update_create_info=false, is_temp_table=false) at /home/rahul.malik/MySQL/percona-server/sql/handler.cc:5562
#21 0x000000000163d40c in rea_create_table (thd=0x7f1e90000b70, path=0x7f1f302b2080 "/tmp/#sql78bb_2e_1", db=0x7f1e90006c40 "test", table_name=0x7f1e90006680 "tt_1_t", create_info=0x7f1f302b28f0, create_fields=..., keys=3, key_info=0x7f1e90018a40, file=0x7f1e90007640, no_ha_table=false) at /home/rahul.malik/MySQL/percona-server/sql/unireg.cc:572
#22 0x00000000015bb4d4 in create_table_impl (thd=0x7f1e90000b70, db=0x7f1e90006c40 "test", table_name=0x7f1e90006680 "tt_1_t", error_table_name=0x7f1e90006680 "tt_1_t", path=0x7f1f302b2080 "/tmp/#sql78bb_2e_1", create_info=0x7f1f302b28f0, alter_info=0x7f1f302b2360, internal_tmp_table=false, select_field_count=0, no_ha_table=false, is_trans=0x7f1f302b230e, key_info=0x7f1f302b2290, key_count=0x7f1f302b228c) at /home/rahul.malik/MySQL/percona-server/sql/sql_table.cc:5616
#23 0x00000000015bba87 in mysql_create_table_no_lock (thd=0x7f1e90000b70, db=0x7f1e90006c40 "test", table_name=0x7f1e90006680 "tt_1_t", create_info=0x7f1f302b28f0, alter_info=0x7f1f302b2360, select_field_count=0, is_trans=0x7f1f302b230e) at /home/rahul.malik/MySQL/percona-server/sql/sql_table.cc:5746
#24 0x00000000015bbbb4 in mysql_create_table (thd=0x7f1e90000b70, create_table=0x7f1e900066b8, create_info=0x7f1f302b28f0, alter_info=0x7f1f302b2360) at /home/rahul.malik/MySQL/percona-server/sql/sql_table.cc:5792
#25 0x00000000015289b7 in mysql_execute_command (thd=0x7f1e90000b70, first_level=true) at /home/rahul.malik/MySQL/percona-server/sql/sql_parse.cc:3491
#26 0x000000000152f6c7 in mysql_parse (thd=0x7f1e90000b70, parser_state=0x7f1f302b3550, update_userstat=false) at /home/rahul.malik/MySQL/percona-server/sql/sql_parse.cc:5905
#27 0x0000000001524136 in dispatch_command (thd=0x7f1e90000b70, com_data=0x7f1f302b3d70, command=COM_QUERY) at /home/rahul.malik/MySQL/percona-server/sql/sql_parse.cc:1532
#28 0x0000000001522f4e in do_command (thd=0x7f1e90000b70) at /home/rahul.malik/MySQL/percona-server/sql/sql_parse.cc:1053
#29 0x00000000016549c8 in handle_connection (arg=0x4f452a0) at /home/rahul.malik/MySQL/percona-server/sql/conn_handler/connection_handler_per_thread.cc:318
#30 0x000000000191d9ba in pfs_spawn_thread (arg=0x50b1670) at /home/rahul.malik/MySQL/percona-server/storage/perfschema/pfs.cc:2190
#31 0x00007f1f6610eaa1 in start_thread () from /lib64/libpthread.so.0
#32 0x00007f1f64a56c4d in clone () from /lib64/libc.so.6
(gdb)
Collapse
5:16 PM
- is triggered by
-
PS-3821 InnoDB temporary tablespace encryption
-
- Done
-