List:General Discussion« Previous MessageNext Message »
From:Ady Wicaksono Date:November 17 2007 9:57am
Subject:Re: ERROR 3 (HY000): Error writing file (Errcode: 5)
View as plain text  
$ perror 5
OS error code   5:  Input/output error

How did you delete the table?

On Nov 17, 2007 7:03 AM, Daevid Vincent <daevid@stripped> wrote:

> I'm baffled as to why this isn't working...
>
> I am 'root'. I have full perms and all that stuff. I use these DBs every
> day. Yesterday, I deleted a table that had FKs because I wanted to change
> a
> column name, but couldn't because of the restraint *sigh*. After that I
> couldn't re-create the table again. So breaking it down to basic level...
>
> mysql> use mydbB;
> mysql> CREATE TABLE foo ( id int(10) unsigned NOT NULL auto_increment,
> name
> varchar(255) NOT NULL, PRIMARY KEY id (id) );
> ERROR 3 (HY000): Error writing file './mydbB/foo.frm' (Errcode: 5)
>
> mysql> use mydbA;
> mysql> CREATE TABLE foo ( id int(10) unsigned NOT NULL auto_increment,
> name
> varchar(255) NOT NULL, PRIMARY KEY id (id) );
> Query OK, 0 rows affected (0.04 sec)
>
> root@daevid111:/var/lib/mysql# ll
> total 28748
> drwxrwxrwx    2 mysql    mysql        8192 Nov 16 22:46 mydbA
> drwxrwxrwx    2 mysql    mysql        4096 Nov 16 22:50 mydbB
> -rw-rw----    1 mysql    mysql     5242880 Nov 16 22:46 ib_logfile0
> -rw-rw----    1 mysql    mysql     5242880 Nov 13 22:07 ib_logfile1
> -rw-rw----    1 mysql    mysql    18874368 Nov 16 22:46 ibdata1
> drwx------    2 mysql    mysql        4096 Nov 13 22:07 mysql
> drwx------    2 mysql    mysql        4096 Nov 13 22:06 test
>
> All drives have gigabytes free.
>
> "ENGINE=InnoDB" matters not.
>
> What gives?
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Regards,

Ady Wicaksono
Email:
ady.wicaksono at gmail.com
http://adywicaksono.wordpress.com/

Thread
ERROR 3 (HY000): Error writing file (Errcode: 5)Daevid Vincent17 Nov
  • Re: ERROR 3 (HY000): Error writing file (Errcode: 5)Ady Wicaksono17 Nov
  • Re: ERROR 3 (HY000): Error writing file (Errcode: 5)Ofer Inbar19 Nov