Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.3
-
None
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
- is caused by
-
MDEV-11710 thd_destructor_proxy() hangs on shutdown after aborted startup
- Closed