28170

MySQL error: “1030 - Got error -1 from storage engine”

Question:

I received the following message while working while working with a pre-existing existing database and adding some new tables Error Msg

#1030 - Got error -1 from storage engine

Answer1:

This usually means you've ran out of disk space. Check using df -h and delete any large log files or other files taking up a lot of space.

Failing that, check your memory usage.

Answer2:

This error is mainly due to the low memory which means that you don't have enough memory for allocating to your table or database.

Please have a look <a href="http://wiki.jumpbox.com/doc/runtime/faq/mysql_maintenance" rel="nofollow">here</a>.It would be helpful.

Answer3:

You will get this error if <strong>/etc/my.cnf</strong> you have <strong>innodb_force_recovery</strong> turned on. Comment out that option, restart the server and try the data import again.

Recommend

  • How is user.dir configured for Tomcat servlets?
  • Serializing socket
  • Collect HostCPU utilisation and disk I/O speed using XenServer Java API
  • Are there algorithms for putting a digest into the file being digested?
  • Errno 2 using python shutil.py No such file or directory for file destination
  • How to get or calculate size of Azure File/Share or Service
  • How to import Navit into Eclipse and use it in own android project
  • Where to save the local DB created for iphone app?
  • Binary Tree Traversal Sum Of Each Depth
  • get passwords from chrome
  • Small video playback
  • iOS 6 dateFromString returns wrong date
  • Selecting a subset of data in ServiceStack.OrmLite
  • Does the Azure table storage API cache results?
  • Installing PHP 7 on digitalocean
  • Redshift Querying: error xx000 disk full redshift
  • Django model inheritance, filtering models
  • Breaking out column by groups in Pandas
  • Error when parsing timestamp with pandas read_csv
  • How to clear text inside text field when radio button is select
  • How to avoid particles glitching together in an elastic particle collision simulator?
  • Recording logins for password protected directories
  • R - Combining Columns to String Based on Logical Match
  • Adding a button at the bottom of a table view
  • Splitting given String into two variables - php
  • Getting last autonumber in access
  • What is Eclipse's Declaration View used for?
  • Check if a string to interpolate provides expected placeholders
  • Does CUDA 5 support STL or THRUST inside the device code?
  • When should I choose bucket sort over other sorting algorithms?
  • How do you troubleshoot character encoding problems?
  • Delete MySQLi record without showing the id in the URL
  • GridView Sorting works once only
  • 0x202A in filename: Why?
  • Is there a mandatory requirement to switch app.yaml?
  • Use group_by to filter specific cases while keeping NAs
  • What are the advantages and disadvantages of reading an entire file into a single String as opposed
  • Understanding cpu registers
  • How does Linux kernel interrupt the application?
  • reshape alternating columns in less time and using less memory