mysql启动出错

小七和十一的爸爸 2017-07-07 03:35:55
170707 15:02:31 mysqld_safe Starting mysqld daemon with databases from /chunk1/mysqlData/data
2017-07-07T07:02:32.017206Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-07-07T07:02:32.017369Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2017-07-07T07:02:32.017424Z 0 [Note] /chunk1/mysqlData/bin/mysqld (mysqld 5.7.9) starting as process 21829 ...
2017-07-07T07:02:32.022762Z 0 [Note] InnoDB: PUNCH HOLE support not available
2017-07-07T07:02:32.022808Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-07-07T07:02:32.022819Z 0 [Note] InnoDB: Uses event mutexes
2017-07-07T07:02:32.022830Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-07-07T07:02:32.022855Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-07-07T07:02:32.022866Z 0 [Note] InnoDB: Using Linux native AIO
2017-07-07T07:02:32.023189Z 0 [Note] InnoDB: Number of pools: 1
2017-07-07T07:02:32.023333Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-07-07T07:02:32.032604Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-07-07T07:02:32.042528Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-07-07T07:02:32.045692Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-07-07T07:02:32.058706Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-07-07T07:02:32.058926Z 0 [Note] InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on, skipping log redo
2017-07-07T07:02:32.064897Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-07-07T07:02:32.064938Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-07-07T07:02:32.065025Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-07-07T07:02:32.149217Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-07-07T07:02:32.150928Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-07-07T07:02:32.150965Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-07-07T07:02:32.152290Z 0 [Note] InnoDB: 5.7.9 started; log sequence number 0
2017-07-07T07:02:32.152338Z 0 [Note] InnoDB: !!! innodb_force_recovery is set to 6 !!!
2017-07-07T07:02:32.153507Z 0 [Note] InnoDB: Loading buffer pool(s) from /chunk1/mysqlData/data/ib_buffer_pool
2017-07-07T07:02:32.153586Z 0 [Note] InnoDB: not started
2017-07-07T07:02:32.153771Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-07-07T07:02:32.153965Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170707 15:02:32
2017-07-07T07:02:32.154873Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`plugin` in the cache. Attempting to load the tablespace with space id 2
2017-07-07T07:02:32.156609Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`gtid_executed` in the cache. Attempting to load the tablespace with space id 18
2017-07-07T07:02:32.157050Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-07-07T07:02:32.157088Z 0 [Note] Server hostname (bind-address): '*'; port: 3308
2017-07-07T07:02:32.157220Z 0 [Note] IPv6 is available.
2017-07-07T07:02:32.157258Z 0 [Note] - '::' resolves to '::';
2017-07-07T07:02:32.157276Z 0 [Note] Server socket created on IP: '::'.
2017-07-07T07:02:32.179416Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`server_cost` in the cache. Attempting to load the tablespace with space id 19
2017-07-07T07:02:32.179750Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`engine_cost` in the cache. Attempting to load the tablespace with space id 20
2017-07-07T07:02:32.181484Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_leap_second` in the cache. Attempting to load the tablespace with space id 12
2017-07-07T07:02:32.181854Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_name` in the cache. Attempting to load the tablespace with space id 8
2017-07-07T07:02:32.182208Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone` in the cache. Attempting to load the tablespace with space id 9
2017-07-07T07:02:32.182546Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_transition_type` in the cache. Attempting to load the tablespace with space id 11
2017-07-07T07:02:32.182859Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_transition` in the cache. Attempting to load the tablespace with space id 10
2017-07-07T07:02:32.184012Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`servers` in the cache. Attempting to load the tablespace with space id 3
2017-07-07T07:02:32.191814Z 0 [Note] Event Scheduler: Loaded 0 events
2017-07-07T07:02:32.192595Z 0 [Note] /chunk1/mysqlData/bin/mysqld: ready for connections.
Version: '5.7.9' socket: '/chunk1/mysqlData/mysql.sock' port: 3308 Source distribution
...全文
1476 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
  • 打赏
  • 举报
回复 1
2017-07-07T07:02:32.154873Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`plugin` in the cache. Attempting to load the tablespace with space id 2 这个应该是mysql的系统报,都放到了表空间中了,而显然么有找到,是不是文件丢失了

56,675

社区成员

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧