Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15348

InnoDB: Failing assertion: block->magic_n == MEM_BLOCK_MAGIC_N

    XMLWordPrintable

    Details

      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
      

        Attachments

          Activity

            People

            Assignee:
            marko Marko Mäkelä
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration