List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:November 16 2007 11:03pm
Subject:ERROR 3 (HY000): Error writing file (Errcode: 5)
View as plain text  
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?

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