参考博文:http://www.webjx.com/database/mysql-15516.html
测试数据库性能时,向MySQL数据库中插入了几千万条数据,导致数据库崩溃出现错误→[Got error 28 from storage engine]......
以下是错误详细信息。
mysql> show triggers;
ERROR 1030 (HY000): Got error 28 from storage engine
mysql> show errors;
+-------+------+--------------------------------------------------------+
| Level | Code | Message |
+-------+------+--------------------------------------------------------+
| Error | 1030 | Got error 28 from storage engine |
| Error | 6 | Error on delete of '/tmp/#sql_1515_0.MYI' (Errcode: 2) |
+-------+------+--------------------------------------------------------+
2 rows in set (0.00 sec)
解决思路:
1. 看了下具体错误代码
mysql> \! perror 6
OS error code 6: No such device or address
那就是/tmp/#sql_1515_0.MYI这个文件没有? 这个文件是临时生成的,本来就应该没有啊!
那就是创建的时候出错了?
2. 查看了下磁盘空间,原来我的第一块虚拟盘满了,而我的第二块盘上存放MySQL数据,所有有空间足够!
[root@rdb1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 4.9G 4.9G 0 100% /
tmpfs 252M 0 252M 0% /dev/shm
/dev/sdb1 9.9G 2.8G 6.6G 30% /opt/sdb
删除了一些文件。
[root@rdb1 ~]
# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 4.9G 3.5G 1.1G 77% /
tmpfs 252M 0 252M 0% /dev/shm
/dev/sdb1 9.9G 2.8G 6.6G 30% /opt/sdb
这个时候OK了。
分享到:
相关推荐
mysql默认是线程不安全的, 及编程时如何解决此问题的解决方案 InnoDB Operating system error number 9. [MDEV-9749] InnoDB receives 'Bad file descriptor' error, possibly related to feedback plugin Lost ...
目录MySQL 3534 Error1. 问题2. 解决步骤3....-2017-11-07T12:25:58 [ERROR] InnoDB: Operating system error number 87 in a file operation -2017-11-07T12:25:58 [ERROR] InnoDB: File .\ib_logfile101
QT连接数据库成功,带有数据的测试代码,已经运行成功!
printf("%s\n", mysql_error(&mysql;)); printf("connect failed\n"); return 1; } // query char* tbname = "student"; sprintf(strSQL, "select * from %s", tbname); if (mysql_real_query(&mysql;, ...
执行SQL报错:The used SELECT statements have a different number of columns 以上翻译:使用的SELECT语句具有不同数量的列 原因:我们在 SQL 语句中使用了 UNION 连接两张表时,查询字段数量不一致导致 # 效果...
[ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=32, page number=57890], I/O length: 16384 bytes。 看起来是I/O出现了错误,但MySQL进程并未...
Bug with processing parameter name when a name begins from a number is fixed MySQL data provider Bug with processing TIMESTAMP and DATETIME fields is fixed Bug with loading data from a pipe is fixed ...
1,查看Mysqld(/var/log/mysqld.log)日志,发现以下错误:InnoDB: Error: log file /usr/...030826 1:42:15 Can’t init databases030826 1:42:15 Aborting2,解决办法“If you want to change the number or the siz
注:如果不能远程连接,出现错误mysql error number 1130,则加入下面语句试试: mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '******' WITH GRANT OPTION;
错误鸭子 国外模块的通用鸭子类型 将错误映射到以下错误: 配置不当 临时错误(重试应该会... [ { "module": "requests", "stack": { "file": "some.js", "lineNumber": 15 }, "error": { "message": "Hello Dude",
【作 用】: mysql数据库操作类 【作 者】: Riyan 【版 本】: version 2.0 【修改日期】: 2010/02/11 ※※※※※※※※※※※※※※※※※※※※※※※※※※※※※※※※※※※※ ※※※※※※※※ **/ class ...
mysql 提示SQL-ERROR summary different number of columns
我们生产环境有一组集群的多台MySQL服务器(MySQL 5.6.21),不定期的会crash,但error log中只记录了重启信息,未记录crash时的堆栈: mysqld_safe Number of processes running now: 0 mysqld_safe mysqld ...
$result=mysql_query($sql)or die(mysql_error()); $row=mysql_fetch_array($result); $number=++$row[number]; $sql=update $table set number=’$number’ where id=’$id’; mysql_query($sql)or die(mysql_...
error_reporting ; Default Value: E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED ; Development Value: E_ALL ; Production Value: E_ALL & ~E_DEPRECATED & ~E_STRICT ; html_errors ; Default Value: On ; ...
一般来说实现无限极分类都是使用递归或者迭代的方式,小伙伴们看下本文的实现方式吧。 1,数据库设计: 2,代码: 复制代码 代码如下:/** * @author koma * @... /** * 从顶层逐级向下获取子类 * @param number $pid
Try It Out: Data Storage in MySQL 439 Try It Out: Storing and Retrieving Documents 441 Try It Out: A Document Retention Framework 446 The python-ldap Module 448 Try It Out: Using Basic OpenLDAP ...
o CurrPorts now displays a simple error message if it fails to close one or more TCP connections. * Version 2.01: o The 'Remote Address' and 'Local Address' columns are now sorted by the IP ...
Mysql 甲骨文 是个开源的数据库server,可运行在多种平台, 特点是响应速度特别快,主要面向中小企业 中小型企业 PostgreSQL 号称“世界上最先进的开源数据库“,可以运行在多种平台下,是tb级数据库,而且性能也很...