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

InnoDB: Failing assertion when accessing INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES upon upgrade from 10.1.0 to 10.1.20

    Details

      Description

      On 10.1.20 with default settings

      SET GLOBAL innodb_file_format=Barracuda;
      DROP TABLE IF EXISTS t1;
      CREATE TABLE t1 (i INT) ENGINE=InnoDB ROW_FORMAT=COMPACT PAGE_COMPRESSED=1;
      shutdown;
      

      On current 10.1 started on the same datadir with default settings

      SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES;
      

      10.1 98cd0ec53691

      2017-10-16 17:57:57 7f49da504b00  InnoDB: Assertion failure in thread 139955172035328 in file fsp0fsp.ic line 102
      InnoDB: Failing assertion: page_size <= (1 << 16)
       
      #1  0x00007f49d823e3fa in abort () from /lib/x86_64-linux-gnu/libc.so.6
      #2  0x0000555d2507d5ac in fsp_flags_get_page_size (flags=865) at /data/src/10.1/storage/xtradb/include/fsp0fsp.ic:102
      #3  0x0000555d250899e4 in i_s_dict_fill_sys_tablespaces (thd=0x7f49b474d070, space=4, name=0x7f49aac4ff78 "test/t1", flags=865, table_to_fill=0x7f49aac4c088) at /data/src/10.1/storage/xtradb/handler/i_s.cc:7693
      #4  0x0000555d25089eea in i_s_sys_tablespaces_fill_table (thd=0x7f49b474d070, tables=0x7f49aac223b8) at /data/src/10.1/storage/xtradb/handler/i_s.cc:7783
      #5  0x0000555d24b7735d in get_schema_tables_result (join=0x7f49aac232e8, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.1/sql/sql_show.cc:8221
      #6  0x0000555d24b16d14 in JOIN::exec_inner (this=0x7f49aac232e8) at /data/src/10.1/sql/sql_select.cc:2664
      #7  0x0000555d24b163bb in JOIN::exec (this=0x7f49aac232e8) at /data/src/10.1/sql/sql_select.cc:2512
      #8  0x0000555d24b19951 in mysql_select (thd=0x7f49b474d070, rref_pointer_array=0x7f49b4751500, tables=0x7f49aac223b8, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f49aac232c8, unit=0x7f49b4750b70, select_lex=0x7f49b4751270) at /data/src/10.1/sql/sql_select.cc:3449
      #9  0x0000555d24b0f376 in handle_select (thd=0x7f49b474d070, lex=0x7f49b4750aa8, result=0x7f49aac232c8, setup_tables_done_option=0) at /data/src/10.1/sql/sql_select.cc:384
      #10 0x0000555d24adf1fd in execute_sqlcom_select (thd=0x7f49b474d070, all_tables=0x7f49aac223b8) at /data/src/10.1/sql/sql_parse.cc:5912
      #11 0x0000555d24ad5419 in mysql_execute_command (thd=0x7f49b474d070) at /data/src/10.1/sql/sql_parse.cc:2982
      #12 0x0000555d24ae290b in mysql_parse (thd=0x7f49b474d070, rawbuf=0x7f49aac22088 "SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES", length=62, parser_state=0x7f49da503630) at /data/src/10.1/sql/sql_parse.cc:7333
      #13 0x0000555d24ad1510 in dispatch_command (command=COM_QUERY, thd=0x7f49b474d070, packet=0x7f49b46b2071 "SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES", packet_length=62) at /data/src/10.1/sql/sql_parse.cc:1484
      #14 0x0000555d24ad02ad in do_command (thd=0x7f49b474d070) at /data/src/10.1/sql/sql_parse.cc:1106
      #15 0x0000555d24c08e61 in do_handle_one_connection (thd_arg=0x7f49b474d070) at /data/src/10.1/sql/sql_connect.cc:1349
      #16 0x0000555d24c08bc5 in handle_one_connection (arg=0x7f49b474d070) at /data/src/10.1/sql/sql_connect.cc:1261
      #17 0x00007f49da1a7494 in start_thread (arg=0x7f49da504b00) at pthread_create.c:333
      #18 0x00007f49d82f293f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      The pre-created 10.1.20 datadir is attached.

      No obvious problems with non-debug.

        Attachments

          Issue Links

            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: