MySQL Error 1030 : Got error 127 from storage engine
Remember Me?
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.
mohtasham1983
Registered: Apr 2005
Location: San Jose
Distribution: Fedora 3,4- Ubuntu 6.06 to 8.10, Gentoo and Arch
Posts: 408
MySQL Error 1030 : Got error 127 from storage engine
I copied one of my tables to some place to havea backup from it. then I entered wrong information to the table. So I copied back the back up table to /var/lib/mysql/mydatabase directory and when I want to view data in my table I get the following error:Error 1030 : Got error 127 from storage engine
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,171
perror 127
MySQL error:
127 = Record-file is crashed
mohtasham1983
Registered: Apr 2005
Location: San Jose
Distribution: Fedora 3,4- Ubuntu 6.06 to 8.10, Gentoo and Arch
Posts: 408
Original Poster
nothing important. next time when I rebooy my PC it was working fine. I think I needed to restart both mysql and apache to fix everything
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
code is Off
HTML code is Off
Similar Threads
Linux - Software
10-28-2006
09-06-2005
Linux - Software
11-07-2004
Linux - Networking
02-26-2004
ccflashback
Linux - Newbie
11-18-2003
All times are GMT -5. The time now is .
Advertisement
Write for LQ
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, .
& Latest Threadsmarkjing 的BLOG
用户名：markjing
文章数：43
访问量：1810
注册日期：
阅读量：5863
阅读量：12276
阅读量：327467
阅读量：1035960
51CTO推荐博文
Got error 28 from storage engine错误分析：通常是由于数据库用的临时目录空间不足造成的，所以无法执行sql语句。解决办法：修改my.cnf中的tmpdir参数，指向具有足够空间目录。一般tmpdir所在目录都在/下，所以也有可能是/分区磁盘写满了使用df -hT查看即可650) this.width=650;" src="/wyfs02/M00/59/54/wKioL1TQc9KAJU4bAACa0FQ3HMg401.jpg" title="23.png" alt="wKioL1TQc9KAJU4bAACa0FQ3HMg401.jpg" />如果上述都没问题查询mysql.err日志分析错误，有可能是mysql耗尽了tmp空间可以通过命令查看查看tmp目录总值，已使用值，剩余值lsof |grep tmp |less查看mysqld.err中发现有多行： [ERROR] /mysql_base/bin/mysqld: Sort abortedsql异常，线程没有及时释放导致。restart mysqld服务，释放空间问题解决。本文出自 “” 博客，请务必保留此出处
了这篇文章
类别：┆阅读(0)┆评论(0)博客访问： 23588
博文数量： 4
注册时间：
IT168企业级官微
微信号：IT168qiye
系统架构师大会
微信号：SACC2013
分类： MySQL
使用Navicat for mysql打开表时，出现1030-Got error 28 from storage engine错误。
查询日志：发现根目录空间已满。开发服务器是同事配置，应用和数据库占满了空间。
解决方法：
1.清理根本目录下的日志（应用、数据库）及文件。
2.mysql数据量太大，新加分区，重新配置mysql目录。
阅读(1758) | 评论(0) | 转发(0) |
下一篇：没有了
相关热门文章
给主人留下些什么吧！~~
请登录后评论。MySQL Got error 28 from storage engine [Resolved]
718 ViewsThe MySQL database backup can be taken using mysqldump command from command line in a Linux server.Sometimes, the following error may occur while taking database backup"'Got error 28 from storage engine' when trying to dump tablespaces"Though the error does not provide much information, the issue is related with the disk space on the server.In this case1) Login into the server as root user from command prompt.2) Check the disk usage.# df -h3) Even though more than 20% disk space is available, delete some files.4) Check by taking the database backup again.In my case even though more than 18% disk space was free, the error occurred. On removing some files, the error was gone.Hope this helps!&
0301000Related posts:
Loves Linux, Blogging, Traveling, Hiking and sharing knowledge!
CAPTCHA Code
Copyright 2011 - 2016 Geeks Terminal. All Rights Reserved.
This work is licensed under a投诉建议、广告投放、友情链接，联系QQ：
mysql提示Got error 28 from storage engine问题解决方法
Loading...
在linux中执行mysql查询时提示Got error 28 from storage engine，看这个大概意思是说硬盘空间不够导致无法执行sql语句了，下面我把整理个问题出现与处理方法给各位介绍一下。 在执行一个简单desc语句的时候，出现如下错误：
mysql& desc ZAGCNY;
ERROR 1030 (HY000): Got error 28 from storage engine
字面上的意思是：从存储引擎中获得错误%d
通过搜索了下，大致提到的原因是磁盘空间问题或/tmp空间问题所致，马上检查了下，目前的磁盘空间情况，结果如下：
[root@cqd ~]# df -Th
Filesystem&&& Type&&& Size& Used Avail Use% Mounted on
/dev/sda3&&&& ext4&&& 127G& 121G&&&& 0 100% /
tmpfs&&&&&&& tmpfs&&&& 12G&&&& 0&& 12G&& 0% /dev/shm
/dev/sda1&&&& ext4&&&& 97M&& 33M&& 60M& 36% /boot
果然是空间问题所致，接下来的工作是找到那些程序在大量的耗费空间，并把先清理部分，让业务先正常跑起来。
之后编写个定期清理日志部分的脚本，通过crontab来调用；最后在nagios上添加这台主机的磁盘监控
IT技术书籍推荐:
Android编程权威指南
菲利普斯 (Brian Hardy) (作者), 哈迪 (Bill Phillips) (作者), 王明发 (译者)
Big Nerd Ranch是美国一家专业的移动开发技术培训机构，《Android编程权威指南》主要以训练营的5天教学课程为基础，融合了两位作者多年的心得体会，是一本完全面向实战的Android 编程权威指南。《Android编程权威指南》共37章，详细介绍了GeoQuiz、HelloMoon、DragAndDraw等8个Android应用。这些应用的难易程度不一，最复杂的CriminalIntent应用占用了13章的篇幅。通过这些精心设计的应用，读者可掌握很多重要的理论知识和开发技巧，获得最前沿的开发经验。
　　如果你熟悉Java语言，或者了解对面向对象编程，那就立刻开始Android编程之旅吧！
相关推荐:1、2、3、4、5、6、7、8、9、10、
随机关键词:
正在加载...
最新微信头条}