首页 > 数据库 > 文库 > 正文

大表count 致使宕机

2024-09-07 22:12:54
字体:
来源:转载
供稿:网友
  对表做 select count(*) from tbname;
 
  异常信息如下
 
  点击(此处)折叠或打开
 
  016-03-24 21:37:28 17887 [ERROR] InnoDB: Tried to read 16384 bytes at offset 50072698880. Was only able to read 8192.
  2016-03-24 21:37:28 7faab67f6700 InnoDB: Operating system error number 11 in a file operation.
  InnoDB: Error number 11 means 'Resource temporarily unavailable'.
  InnoDB: Some operating system error numbers are described at
  InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
  2016-03-24 21:37:28 7faab67f6700 InnoDB: File operation call: 'read' returned OS error 111.
  2016-03-24 21:37:28 7faab67f6700 InnoDB: Cannot continue operation.
  pure virtual method called
  pure virtual method called
  terminate called without an active exception
  terminate called without an active exception
  13:37:28 UTC - mysqld got signal 6 ;
 
  This could be because you hit a bug. It is also possible that this binary
 
  ulimit -a 没超过限制
 
  可能是表数据文件损坏,在slave上执行没有报错。

(编辑:武林网)

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表