Encounter MySQL/Writing File error (errcode 28)

Note: This article is from the blog "afei". If you want to repost this article, please contact the author! And indicate the source: http://blog.csdn.net/faye0412/article/details/8817021

When verboice is installed today, MySQL/Writing File error (errcode 28) is encountered. The detailed exception information is as follows:

[root@bogon verboice]# rake db:schema:load RAILS_ENV=production-- create_table("accounts", {:force=>true})rake aborted!Mysql2::Error: Error writing file './verboice/accounts.frm' (Errcode: 28): CREATE TABLE `accounts` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `email` varchar(255) DEFAULT '' NOT NULL, `encrypted_password` varchar(128) DEFAULT '' NOT NULL, `reset_password_token` varchar(255), `remember_token` varchar(255), `remember_created_at` datetime, `sign_in_count` int(11) DEFAULT 0, `current_sign_in_at` datetime, `last_sign_in_at` datetime, `current_sign_in_ip` varchar(255), `last_sign_in_ip` varchar(255), `password_salt` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `confirmation_token` varchar(255), `confirmed_at` datetime, `confirmation_sent_at` datetime) ENGINE=InnoDBTasks: TOP => db:schema:load(See full trace by running task with --trace)

Exception:Mysql2: Error writing File './verboice/accounts. frm' (errcode: 28)

SeeErrcode: 28, I checked:

# perror 28OS error code  28:  No space left on device

It is clear from the log that the disk space is insufficient. OK. The next step is to add capacity and solve the problem.

Write down the process here to help others who encounter the same problem.