mysql碰到一个奇怪的问题,执行查询没有语法错误,但是抛异常:
java.sql.SQLException: Got error 134 from storage engine
错误原因
Even though the MyISAM
table format is very reliable (all changes to a table made by an SQL statement are written before the statement returns), you can still get corrupted tables if any of the following events occur:
-
The mysqld process is killed in the middle of a write.
-
An unexpected computer shutdown occurs (for example, the computer is turned off).
-
Hardware failures.
-
You are using an external program (such as myisamchk ) to modify a table that is being modified by the server at the same time.
-
A software bug in the MySQL or
MyISAM
code.
Typical symptoms of a corrupt table are:
-
You get the following error while selecting data from the table:
Incorrect key file for table: '...'. Try to repair it
-
Queries don't find rows in the table or return incomplete results.
来自:
http://dev.mysql.com/doc/refman/5.0/en/corrupted-myisam-tables.html
解决:
CHECK TABLE 表名
REPAIR TABLE 表名
转载
相关推荐
最近在执行一个innoDB类型sql文件的时候,发现系统报错了,通过查找相关的资料终于解决了,所以下面这篇文章主要给大家介绍了关于mysql执行sql文件时报错Error: Unknown storage engine 'InnoDB'的解决方法,需要的...
MySQL 5.6 InnoDB Storage Engine Architecture
SequoiaSQL - MySQL Storage Engine is a distributed MySQL storage engine. It currently supports SequoiaDB 3.x as the backend database, and it will be extended to multiple databases such like MongoDB/...
user: ‘root’ host: `localhost’ (Got timeout reading communication packets) MYSQL server has gone away 引起这个原因是不可怕的.原因是更改了系统的断开时间. mysql>show gloable variables like “%time...
innodb storage engine architecture innodb存储引擎架构
在my.ini(linux下/etc/my.cnf)加上skip-...看下mysql目录的错误日志: 引用 090613 10:15:27 [ERROR] Default storage engine (InnoDB) is not available 090613 10:15:27 [ERROR] Aborting 090613 10:15:27 [Note] C:\...
Jira6不支持mysql5.7,需要此jar,具体就是报错 Unknown system variable 'storage_engine' 的解决
连接64位的mysql,即使把mysql安装目录下的libmysql.dll放到qt安装目录bin路径下,也是无法连接数据库。网上给出的做法是下载Qt对应版本的源码,重新编译。这种方法复杂繁琐,且容易编译失败。这里提供了mysql官方给...
主要为大家详细介绍了MySQL定义异常和异常处理,具有一定的参考价值,感兴趣的小伙伴们可以参考一下
MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers By 作者: Jesper Wisborg Krogh ISBN-10 书号: 1484236939 ISBN-13 书号: 9781484236932 Edition 版本: 1st ed...
MySQL存储过程 ERROR Handler 异常处理
环境变量配置错误 mysql 命令行错误 ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: N
mysql常见异常mysql常见异常mysql常见异常mysql常见异常mysql常见异常mysql常见异常mysql常见异常mysql常见异常mysql常见异常mysql常见异常mysql常见异常mysql常见异常mysql常见异常mysql常见异常mysql常见异常mysql...
-DCMAKE_INSTALL_PREFIX=/home/mysql -DMYSQL_DATADIR=/home/mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_TCP_PORT=3306 -DMYSQL_USER=mysql -DWITH_MYISAM_STORAGE_ENGINE=1 ...
主要介绍了MySQL启动报错问题InnoDB:Unable to lock/ibdata1 error,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 解决: 1.打开在创建mysql容器时挂载的conf目录下的mysqld.cnf(如下文件) 我创建docker的姿势 2.进入mysqlId.cnf文件中在...
安装高版本mysql、解决error 2003、error nr.1364 安装高版本mysql、解决error 2003、error nr.1364
Inside.MySQL_InnoDB.Storage.Engine_zh-CN[www.TopSage.com].part2