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

Server shuts down in unclean fashion after failing to start with a wrong value of innodb_undo_tablespaces

    XMLWordPrintable

Details

    Description

      Note: I'm not sure it's actually an InnoDB problem, please change the category and re-assign if needed.

      To reproduce,

      • create a datadir with the default innodb_undo_tablespaces=0,
      • start the server with another value, e.g. --innodb_undo_tablespaces=2.

      The error is expected in this case, but what happens after it appears to be wrong.

      On 10.2:

      2016-12-30 13:08:15 139840456656768 [Note] InnoDB: Created tablespace for space 4294967280 name innodb_redo_log key_id 0 encryption 0
      2016-12-30 13:08:15 139840456656768 [ERROR] InnoDB: Expected to open 2 undo tablespaces but was able to find only 0 undo tablespaces. Set the innodb_undo_tablespaces parameter to the correct value and retry. Suggested value is 0
      2016-12-30 13:08:15 139840456656768 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2112] with error Generic error
      2016-12-30 13:08:15 139840456656768 [ERROR] Plugin 'InnoDB' init function returned error.
      2016-12-30 13:08:15 139840456656768 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
      2016-12-30 13:08:15 139840456656768 [Note] Plugin 'FEEDBACK' is disabled.
      2016-12-30 13:08:15 139840456656768 [ERROR] Unknown/unsupported storage engine: InnoDB
      2016-12-30 13:08:15 139840456656768 [ERROR] Aborting
       
      2016-12-30 13:08:15 139840456656768 [ERROR] Plugin 'MyISAM' has ref_count=1 after shutdown.
      Error in my_thread_global_end(): 1 threads didn't exit
      mysqld: /data/src/10.2/sql/mysqld.cc:2154: void mysqld_exit(int): Assertion `global_status_var.global_memory_used == 0' failed.
      161230 13:08:21 [ERROR] mysqld got signal 6 ;
      ...
      

      On 10.1, there is no assertion failure or ref_count problem, but it seems that the process just disappears without proper shut down:

      2016-12-30 13:11:38 140051651819392 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
      2016-12-30 13:11:38 140051651819392 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0.
      2016-12-30 13:11:38 140051651819392 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0.
      2016-12-30 13:11:38 7f6050f4f780 InnoDB: Expected to open 2 undo tablespaces but was able
      2016-12-30 13:11:38 7f6050f4f780 InnoDB: to find only 0 undo tablespaces.
      2016-12-30 13:11:38 7f6050f4f780 InnoDB: Set the innodb_undo_tablespaces parameter to the
      2016-12-30 13:11:38 7f6050f4f780 InnoDB: correct value and retry. Suggested value is 0
      2016-12-30 13:11:38 140051651819392 [ERROR] Plugin 'InnoDB' init function returned error.
      2016-12-30 13:11:38 140051651819392 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
      2016-12-30 13:11:38 140051651819392 [Note] Plugin 'FEEDBACK' is disabled.
      2016-12-30 13:11:38 140051651819392 [ERROR] Unknown/unsupported storage engine: InnoDB
      2016-12-30 13:11:38 140051651819392 [ERROR] Aborting
      

      MySQL 5.6, 5.7, MariaDB 5.5, 10.0 perform the shutdown, e.g. on 10.0:

      2016-12-30 13:11:02 7f9fc17a6780 InnoDB: Expected to open 2 undo tablespaces but was able
      2016-12-30 13:11:02 7f9fc17a6780 InnoDB: to find only 0 undo tablespaces.
      2016-12-30 13:11:02 7f9fc17a6780 InnoDB: Set the innodb_undo_tablespaces parameter to the
      2016-12-30 13:11:02 7f9fc17a6780 InnoDB: correct value and retry. Suggested value is 0
      161230 13:11:02 [ERROR] Plugin 'InnoDB' init function returned error.
      161230 13:11:02 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
      161230 13:11:02 [ERROR] Unknown/unsupported storage engine: InnoDB
      161230 13:11:02 [ERROR] Aborting
       
      161230 13:11:02 [Note] /data/bld/10.0/bin/mysqld: Shutdown complete
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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