innodb_undo_tablespaces参数引发的启动报错

#####################

 

配置文件部分如下：

#undo
innodb_max_undo_log_size                                        = 1024M
innodb_undo_log_truncate                                        = on
innodb_undo_logs                                                = 128
innodb_undo_tablespaces                                         = 3
innodb_purge_rseg_truncate_frequency                            = 128

 

启动后错误日志如下：

2021-03-30T02:34:11.760364Z mysqld_safe Logging to '/home/work/mysql/log/mysql.err'.
2021-03-30T02:34:11.797080Z mysqld_safe Starting mysqld daemon with databases from /home/work/mysql/data
2021-03-30T10:34:12.038396+08:00 0 [Warning] option 'general_log': boolean value '/home/work/mysql/log/mysql.log' wasn't recognized. Set to OFF.
2021-03-30T10:34:12.038475+08:00 0 [Warning] option 'general_log': boolean value '/home/work/mysql/log/mysql.log' wasn't recognized. Set to OFF.
2021-03-30T10:34:12.038488+08:00 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
2021-03-30T10:34:12.038715+08:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-03-30T10:34:12.038788+08:00 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2021-03-30T10:34:12.038830+08:00 0 [Note] /home/work/mysql/bin/mysqld (mysqld 5.7.25-28-log) starting as process 330878 ...
2021-03-30T10:34:12.049232+08:00 0 [Warning] option 'innodb-buffer-pool-chunk-size': unsigned value 128 adjusted to 1048576
2021-03-30T10:34:12.049864+08:00 0 [Note] InnoDB: PUNCH HOLE support available
2021-03-30T10:34:12.049886+08:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-03-30T10:34:12.049893+08:00 0 [Note] InnoDB: Uses event mutexes
2021-03-30T10:34:12.049900+08:00 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-03-30T10:34:12.049912+08:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2021-03-30T10:34:12.049921+08:00 0 [Note] InnoDB: Using Linux native AIO
2021-03-30T10:34:12.056298+08:00 0 [Note] InnoDB: Number of pools: 1
2021-03-30T10:34:12.056460+08:00 0 [Note] InnoDB: Using CPU crc32 instructions
2021-03-30T10:34:12.060447+08:00 0 [Note] InnoDB: Initializing buffer pool, total size = 30G, instances = 8, chunk size = 1M
2021-03-30T10:34:13.727815+08:00 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-30T10:34:14.264939+08:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-03-30T10:34:14.277604+08:00 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /home/work/hdd1/mysql/data/xb_doublewrite
2021-03-30T10:34:14.277972+08:00 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 4096 MB
2021-03-30T10:34:14.278715+08:00 0 [Note] InnoDB: Progress in MB:
 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2100 2200 2300 2400 2500 2600 2700 2800 2900 3000 3100 3200 3300 3400 3500 3600 3700 3800 3900 4000
2021-03-30T10:34:19.027579+08:00 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 4096 MB
2021-03-30T10:34:19.028433+08:00 0 [Note] InnoDB: Progress in MB:
 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2100 2200 2300 2400 2500 2600 2700 2800 2900 3000 3100 3200 3300 3400 3500 3600 3700 3800 3900 4000
2021-03-30T10:34:23.862138+08:00 0 [Note] InnoDB: Setting log file ./ib_logfile2 size to 4096 MB
2021-03-30T10:34:23.862291+08:00 0 [Note] InnoDB: Progress in MB:
 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2100 2200 2300 2400 2500 2600 2700 2800 2900 3000 3100 3200 3300 3400 3500 3600 3700 3800 3900 4000
2021-03-30T10:34:28.628734+08:00 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2021-03-30T10:34:28.628833+08:00 0 [Warning] InnoDB: New log files created, LSN=208100792182065
2021-03-30T10:34:28.629383+08:00 0 [ERROR] InnoDB: Expected to open 3 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
2021-03-30T10:34:28.629410+08:00 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-03-30T10:34:29.431332+08:00 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-03-30T10:34:29.431346+08:00 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-03-30T10:34:29.431357+08:00 0 [ERROR] Failed to initialize builtin plugins.
2021-03-30T10:34:29.431364+08:00 0 [ERROR] Aborting

2021-03-30T10:34:29.431381+08:00 0 [Note] Binlog end
2021-03-30T10:34:29.431467+08:00 0 [Note] Shutting down plugin 'MyISAM'
2021-03-30T10:34:29.431489+08:00 0 [Note] Shutting down plugin 'CSV'
2021-03-30T10:34:29.432828+08:00 0 [Note] /home/work/mysql/bin/mysqld: Shutdown complete

 

解决问题：注释掉该参数：

 

#undo
innodb_max_undo_log_size                                        = 1024M
innodb_undo_log_truncate                                        = on
innodb_undo_logs                                                = 128
# innodb_undo_tablespaces                                         = 3
innodb_purge_rseg_truncate_frequency                            = 128

 

 

 

 

 

 

 

 

 

####################