Mysql服务自动停止,请大神帮吗看下

liushuangle 2015-11-19 10:51:13
2015-11-14 00:37:07 3652 [Note] Plugin 'FEDERATED' is disabled.
2015-11-14 00:37:07 16e8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-11-14 00:37:07 3652 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-14 00:37:07 3652 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-14 00:37:07 3652 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-14 00:37:07 3652 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-14 00:37:07 3652 [Note] InnoDB: Initializing buffer pool, size = 525.0M
2015-11-14 00:37:07 3652 [Note] InnoDB: Completed initialization of buffer pool
2015-11-14 00:37:07 16e8 InnoDB: Operating system error number 21 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2015-11-14 00:37:07 16e8 InnoDB: File name E:\MySQL5.6_IPORTAL\innodb_data\ibdata1
2015-11-14 00:37:07 16e8 InnoDB: File operation call: 'create' returned OS error 121.
2015-11-14 00:37:07 16e8 InnoDB: Cannot continue operation.
2015-11-14 00:38:28 1248 [Note] Plugin 'FEDERATED' is disabled.
2015-11-14 00:38:28 13d8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-11-14 00:38:28 1248 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-14 00:38:28 1248 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-14 00:38:28 1248 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-14 00:38:28 1248 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-14 00:38:28 1248 [Note] InnoDB: Initializing buffer pool, size = 525.0M
2015-11-14 00:38:28 1248 [Note] InnoDB: Completed initialization of buffer pool
2015-11-14 00:38:28 1248 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-14 00:38:29 1248 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-14 00:38:29 1248 [Note] InnoDB: Waiting for purge to start
2015-11-14 00:38:29 1248 [Note] InnoDB: 5.6.12 started; log sequence number 15561001329
2015-11-14 00:38:29 1248 [Note] Server hostname (bind-address): '*'; port: 3306
2015-11-14 00:38:29 1248 [Note] IPv6 is available.
2015-11-14 00:38:29 1248 [Note] - '::' resolves to '::';
2015-11-14 00:38:29 1248 [Note] Server socket created on IP: '::'.
2015-11-14 00:38:29 1248 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50612. Please use mysql_upgrade to fix this error.
2015-11-14 00:38:29 1248 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50612. Please use mysql_upgrade to fix this error.
2015-11-14 00:38:29 1248 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50612. Please use mysql_upgrade to fix this error.
2015-11-14 00:38:29 1248 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
2015-11-14 00:38:29 1248 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50528, now running 50612. Please use mysql_upgrade to fix this error.
2015-11-14 00:38:29 1248 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50528, now running 50612. Please use mysql_upgrade to fix this error.
2015-11-14 00:38:29 1248 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2015-11-14 00:38:29 1248 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2015-11-14 00:38:29 1248 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50528, now running 50612. Please use mysql_upgrade to fix this error.
2015-11-14 00:38:29 1248 [Note] Event Scheduler: Loaded 8 events
2015-11-14 00:38:29 1248 [Note] D:\MySQL5.6_IPORTAL\bin\mysqld: ready for connections.
Version: '5.6.12' socket: '' port: 3306 MySQL Community Server (GPL)
...全文
145 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
ACMAIN_CHM 2015-11-19
  • 打赏
  • 举报
回复
2015-11-14 00:38:29 1248 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50612. Please use mysql_upgrade to fix this error. 先按这个方法做一下。
qiuchu2003 2015-11-19
  • 打赏
  • 举报
回复
应该是升级了mysql后,默认数据库的表结构发生变化导致的,尝试使用mysql_upgrade修复

56,677

社区成员

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

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