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

Assertion `!((flags & ((~(~0U << 1)) << 0)) >> 0) || flags2 & 16U' failed in dict_check_sys_tables on upgrade from 5.5




      The attached datadir was created on MariaDB 5.5.50 by running simple workflow and then shutting down the server normally (general log is also attached).

      Further attempt to start 10.2 (with all default options) on this datadir causes the assertion failure:

      10.2 8f98835bb86

      mysqld: /data/src/10.2/storage/innobase/dict/dict0load.cc:1444: ulint dict_check_sys_tables(bool): Assertion `!((flags & ((~(~0U << 1)) << 0)) >> 0) || flags2 & 16U' failed.
      180308  0:37:35 [ERROR] mysqld got signal 6 ;
      #7  0x00007f9071a9eee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x00005571a9f25955 in dict_check_sys_tables (validate=false) at /data/src/10.2/storage/innobase/dict/dict0load.cc:1443
      #9  0x00005571a9f25d93 in dict_check_tablespaces_and_store_max_id (validate=false) at /data/src/10.2/storage/innobase/dict/dict0load.cc:1535
      #10 0x00005571a9e09104 in innobase_start_or_create_for_mysql () at /data/src/10.2/storage/innobase/srv/srv0start.cc:2543
      #11 0x00005571a9c4de38 in innobase_init (p=0x5571ab947320) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:4359
      #12 0x00005571a9941180 in ha_initialize_handlerton (plugin=0x5571ab91ca00) at /data/src/10.2/sql/handler.cc:520
      #13 0x00005571a96e74ca in plugin_initialize (tmp_root=0x7fff47626e00, plugin=0x5571ab91ca00, argc=0x5571aac5f9f0 <remaining_argc>, argv=0x5571ab8c77f8, options_only=false) at /data/src/10.2/sql/sql_plugin.cc:1416
      #14 0x00005571a96e80d8 in plugin_init (argc=0x5571aac5f9f0 <remaining_argc>, argv=0x5571ab8c77f8, flags=2) at /data/src/10.2/sql/sql_plugin.cc:1698
      #15 0x00005571a95f13a9 in init_server_components () at /data/src/10.2/sql/mysqld.cc:5268
      #16 0x00005571a95f242e in mysqld_main (argc=8, argv=0x5571ab8c77f8) at /data/src/10.2/sql/mysqld.cc:5858
      #17 0x00005571a95e71d0 in main (argc=7, argv=0x7fff47627b98) at /data/src/10.2/sql/main.cc:25

      10.1 starts all right. Starting 10.1 and running mysql_upgrade doesn't help, 10.2 still fails after that.
      10.2.6 also fails, I didn't check earlier 10.2 builds.
      no visible effect on a non-debug build.

      Please note that I had to pack ibdata/ib_logfiles separately, to get around 10Mb limitation in JIRA. Put them back to the datadir.


        1. data.tar.gz
          2.90 MB
          Elena Stepanova
        2. ibfiles.tar.gz
          8.45 MB
          Elena Stepanova
        3. mysql.log.gz
          2.72 MB
          Elena Stepanova

        Issue Links



              marko Marko Mäkelä
              elenst Elena Stepanova
              0 Vote for this issue
              2 Start watching this issue



                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.