Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL)
-
None
Description
--source include/have_innodb.inc
|
|
CREATE SEQUENCE t1 ENGINE=InnoDB ROW_FORMAT REDUNDANT; |
SELECT * FROM INFORMATION_SCHEMA.`INNODB_SYS_TABLES`; |
10.3 556a9202cea3 |
2018-03-30 15:43:54 9 [ERROR] InnoDB: Table `test`.`t1` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12289 SYS_TABLES.N_COLS=8
|
2018-03-30 15:43:54 0x7f7ef81f6700 InnoDB: Assertion failure in file /data/src/10.3/storage/innobase/include/mem0mem.ic line 156
|
InnoDB: Failing assertion: block->magic_n == MEM_BLOCK_MAGIC_N
|
|
Query (0x7f7ea4014d58): SELECT * FROM INFORMATION_SCHEMA.`INNODB_SYS_TABLES`
|
Connection ID (thread ID): 9
|
Status: NOT_KILLED
|
#5 0x00007f7efe6583fa in abort () from /lib/x86_64-linux-gnu/libc.so.6
|
#6 0x0000561e96e0873d in ut_dbg_assertion_failed (expr=0x561e9742f0e0 "block->magic_n == MEM_BLOCK_MAGIC_N", file=0x561e9742f078 "/data/src/10.3/storage/innobase/include/mem0mem.ic", line=156) at /data/src/10.3/storage/innobase/ut/ut0dbg.cc:61
|
#7 0x0000561e96ee00dc in mem_block_validate (block=0x7f7ea400abb0) at /data/src/10.3/storage/innobase/include/mem0mem.ic:156
|
#8 0x0000561e96ee03e1 in mem_heap_free (heap=0x7f7ea400abb0) at /data/src/10.3/storage/innobase/include/mem0mem.ic:515
|
#9 0x0000561e96ee1ac0 in dict_mem_table_free (table=0x7f7ea400e618) at /data/src/10.3/storage/innobase/dict/dict0mem.cc:247
|
#10 0x0000561e96c34b9f in i_s_sys_tables_fill_table (thd=0x7f7ea4000b00, tables=0x7f7ea4015000) at /data/src/10.3/storage/innobase/handler/i_s.cc:6121
|
#11 0x0000561e96689587 in get_schema_tables_result (join=0x7f7ea40160d8, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.3/sql/sql_show.cc:8872
|
#12 0x0000561e96622c60 in JOIN::exec_inner (this=0x7f7ea40160d8) at /data/src/10.3/sql/sql_select.cc:3952
|
#13 0x0000561e96622304 in JOIN::exec (this=0x7f7ea40160d8) at /data/src/10.3/sql/sql_select.cc:3783
|
#14 0x0000561e96623545 in mysql_select (thd=0x7f7ea4000b00, tables=0x7f7ea4015000, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f7ea40160b8, unit=0x7f7ea4004948, select_lex=0x7f7ea40050c0) at /data/src/10.3/sql/sql_select.cc:4188
|
#15 0x0000561e966157e9 in handle_select (thd=0x7f7ea4000b00, lex=0x7f7ea4004880, result=0x7f7ea40160b8, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:382
|
#16 0x0000561e965e0985 in execute_sqlcom_select (thd=0x7f7ea4000b00, all_tables=0x7f7ea4015000) at /data/src/10.3/sql/sql_parse.cc:6556
|
#17 0x0000561e965d7002 in mysql_execute_command (thd=0x7f7ea4000b00) at /data/src/10.3/sql/sql_parse.cc:3770
|
#18 0x0000561e965e4390 in mysql_parse (thd=0x7f7ea4000b00, rawbuf=0x7f7ea4014d58 "SELECT * FROM INFORMATION_SCHEMA.`INNODB_SYS_TABLES`", length=52, parser_state=0x7f7ef81f55d0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8013
|
#19 0x0000561e965d1a43 in dispatch_command (command=COM_QUERY, thd=0x7f7ea4000b00, packet=0x7f7ea4125fb1 "SELECT * FROM INFORMATION_SCHEMA.`INNODB_SYS_TABLES`", packet_length=52, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1842
|
#20 0x0000561e965d0482 in do_command (thd=0x7f7ea4000b00) at /data/src/10.3/sql/sql_parse.cc:1387
|
#21 0x0000561e96734d85 in do_handle_one_connection (connect=0x561e997550c0) at /data/src/10.3/sql/sql_connect.cc:1402
|
#22 0x0000561e96734b12 in handle_one_connection (arg=0x561e997550c0) at /data/src/10.3/sql/sql_connect.cc:1308
|
#23 0x0000561e96bbb979 in pfs_spawn_thread (arg=0x561e99775f60) at /data/src/10.3/storage/perfschema/pfs.cc:1862
|
#24 0x00007f7f00326494 in start_thread (arg=0x7f7ef81f6700) at pthread_create.c:333
|
#25 0x00007f7efe70c93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Non-debug build produces
2018-03-30 15:49:42 9 [ERROR] InnoDB: Table `test`.`t1` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12289 SYS_TABLES.N_COLS=8
|
but doesn't crash.
Some variations which I got on the way while creating the final test case:
mysqld: /data/src/10.3/storage/innobase/dict/dict0mem.cc:211: void dict_mem_table_free(dict_table_t*): Assertion `table->magic_n == 76333786' failed.
|
180330 15:04:58 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f5c30f41ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000055be1be5382b in dict_mem_table_free (table=0x7f5bbc51fca8) at /data/src/10.3/storage/innobase/dict/dict0mem.cc:211
|
#9 0x000055be1bba6a87 in i_s_sys_tables_fill_table (thd=0x7f5bbc000b00, tables=0x7f5bbc02a348) at /data/src/10.3/storage/innobase/handler/i_s.cc:6121
|
#10 0x000055be1b5fb2f7 in get_schema_tables_result (join=0x7f5bbc02be58, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.3/sql/sql_show.cc:8872
|
#11 0x000055be1b5949e6 in JOIN::exec_inner (this=0x7f5bbc02be58) at /data/src/10.3/sql/sql_select.cc:3950
|
#12 0x000055be1b59408a in JOIN::exec (this=0x7f5bbc02be58) at /data/src/10.3/sql/sql_select.cc:3781
|
#13 0x000055be1b5952cb in mysql_select (thd=0x7f5bbc000b00, tables=0x7f5bbc02a348, wild_num=1, fields=..., conds=0x7f5bbc02ac20, og_num=4, order=0x7f5bbc02aeb0, group=0x0, havin
|
g=0x0, proc_param=0x0, select_options=552441481984, result=0x7f5bbc02be38, unit=0x7f5bbc004938, select_lex=0x7f5bbc0050b0) at /data/src/10.3/sql/sql_select.cc:4186
|
#14 0x000055be1b5875a9 in handle_select (thd=0x7f5bbc000b00, lex=0x7f5bbc004870, result=0x7f5bbc02be38, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:382
|
#15 0x000055be1b552745 in execute_sqlcom_select (thd=0x7f5bbc000b00, all_tables=0x7f5bbc02a348) at /data/src/10.3/sql/sql_parse.cc:6556
|
#16 0x000055be1b548dc2 in mysql_execute_command (thd=0x7f5bbc000b00) at /data/src/10.3/sql/sql_parse.cc:3770
|
#17 0x000055be1b556150 in mysql_parse (thd=0x7f5bbc000b00, rawbuf=0x7f5bbc029f58 "SELECT * FROM INFORMATION_SCHEMA.`INNODB_SYS_TABLES` AS table1 WHERE table1.`ROW_FORMAT` < tabl
|
e1.`NAME` ORDER BY table1.`NAME`, table1.`TABLE_ID`, table1.`N_COLS`, table1.`ROW_FORMAT` LIMIT 9 /* QNO "..., length=217, parser_state=0x7f5c30065620, is_com_multi=false, is_ne
|
xt_command=false) at /data/src/10.3/sql/sql_parse.cc:8013
|
#18 0x000055be1b543803 in dispatch_command (command=COM_QUERY, thd=0x7f5bbc000b00, packet=0x7f5bbc00b251 "SELECT * FROM INFORMATION_SCHEMA.`INNODB_SYS_TABLES` AS table1 WHERE ta
|
ble1.`ROW_FORMAT` < table1.`NAME` ORDER BY table1.`NAME`, table1.`TABLE_ID`, table1.`N_COLS`, table1.`ROW_FORMAT` LIMIT 9 /* QNO "..., packet_length=217, is_com_multi=false, is_
|
next_command=false) at /data/src/10.3/sql/sql_parse.cc:1842
|
#19 0x000055be1b542242 in do_command (thd=0x7f5bbc000b00) at /data/src/10.3/sql/sql_parse.cc:1387
|
#20 0x000055be1b6a6af5 in do_handle_one_connection (connect=0x55be1e88ae30) at /data/src/10.3/sql/sql_connect.cc:1402
|
#21 0x000055be1b6a6882 in handle_one_connection (arg=0x55be1e88ae30) at /data/src/10.3/sql/sql_connect.cc:1308
|
#22 0x00007f5c32c18494 in start_thread (arg=0x7f5c30066700) at pthread_create.c:333
|
#23 0x00007f5c30ffe93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
2018-03-30 15:06:39 11 [ERROR] InnoDB: Table `test`.`t1` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12289 SYS_TABLES.N_COLS=8
|
180330 15:06:39 [ERROR] mysqld got signal 6 ;
|
|
#8 0x00007f5a97bda78e in _int_free () from /lib/x86_64-linux-gnu/libc.so.6
|
#9 0x000055690795e908 in dict_mem_table_free (table=0x7f5a28082f18) at /data/src/10.3/storage/innobase/dict/dict0mem.cc:231
|
#10 0x00005569076b1a87 in i_s_sys_tables_fill_table (thd=0x7f5a28000b00, tables=0x7f5a2802a348) at /data/src/10.3/storage/innobase/handler/i_s.cc:6121
|
#11 0x00005569071062f7 in get_schema_tables_result (join=0x7f5a2802be58, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.3/sql/sql_show.cc:8872
|
#12 0x000055690709f9e6 in JOIN::exec_inner (this=0x7f5a2802be58) at /data/src/10.3/sql/sql_select.cc:3950
|
#13 0x000055690709f08a in JOIN::exec (this=0x7f5a2802be58) at /data/src/10.3/sql/sql_select.cc:3781
|
#14 0x00005569070a02cb in mysql_select (thd=0x7f5a28000b00, tables=0x7f5a2802a348, wild_num=1, fields=..., conds=0x7f5a2802ac20, og_num=4, order=0x7f5a2802aeb0, group=0x0, havin
|
g=0x0, proc_param=0x0, select_options=552441481984, result=0x7f5a2802be38, unit=0x7f5a28004938, select_lex=0x7f5a280050b0) at /data/src/10.3/sql/sql_select.cc:4186
|
#15 0x00005569070925a9 in handle_select (thd=0x7f5a28000b00, lex=0x7f5a28004870, result=0x7f5a2802be38, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:382
|
#16 0x000055690705d745 in execute_sqlcom_select (thd=0x7f5a28000b00, all_tables=0x7f5a2802a348) at /data/src/10.3/sql/sql_parse.cc:6556
|
#17 0x0000556907053dc2 in mysql_execute_command (thd=0x7f5a28000b00) at /data/src/10.3/sql/sql_parse.cc:3770
|
#18 0x0000556907061150 in mysql_parse (thd=0x7f5a28000b00, rawbuf=0x7f5a28029f58 "SELECT * FROM INFORMATION_SCHEMA.`INNODB_SYS_TABLES` AS table1 WHERE table1.`ROW_FORMAT` < tabl
|
e1.`NAME` ORDER BY table1.`NAME`, table1.`TABLE_ID`, table1.`N_COLS`, table1.`ROW_FORMAT` LIMIT 9 /* QNO "..., length=217, parser_state=0x7f5a9476f620, is_com_multi=false, is_ne
|
xt_command=false) at /data/src/10.3/sql/sql_parse.cc:8013
|
#19 0x000055690704e803 in dispatch_command (command=COM_QUERY, thd=0x7f5a28000b00, packet=0x7f5a2800b251 "SELECT * FROM INFORMATION_SCHEMA.`INNODB_SYS_TABLES` AS table1 WHERE ta
|
ble1.`ROW_FORMAT` < table1.`NAME` ORDER BY table1.`NAME`, table1.`TABLE_ID`, table1.`N_COLS`, table1.`ROW_FORMAT` LIMIT 9 /* QNO "..., packet_length=217, is_com_multi=false, is_
|
next_command=false) at /data/src/10.3/sql/sql_parse.cc:1842
|
#20 0x000055690704d242 in do_command (thd=0x7f5a28000b00) at /data/src/10.3/sql/sql_parse.cc:1387
|
#21 0x00005569071b1af5 in do_handle_one_connection (connect=0x55690b9dee30) at /data/src/10.3/sql/sql_connect.cc:1402
|
#22 0x00005569071b1882 in handle_one_connection (arg=0x55690b9dee30) at /data/src/10.3/sql/sql_connect.cc:1308
|
#23 0x00007f5a99865494 in start_thread (arg=0x7f5a94770700) at pthread_create.c:333
|
#24 0x00007f5a97c4b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|