MySQL 4.1.7 Create innodb table

Squatrem · #1 (**permalink**) 11-10-04, 16:44

When I try to create a simple InnoDB table, I have the following error :

Code:

ERROR 1005 (HY000): Can't create table './pilote/toto.frm' (Errcode: 121)

My create query is :

Code:

create table toto (
  env_id                    numeric(10,0) not null,
  env_name                  varchar(100) not null,
  auth_password             varchar(100) null,
  env_ipaddr                char(15) null,
  constraint pk_environments primary key (env_id)
) type = InnoDB

Removing the 'constraint' line doesn't make it work better... but if I remove "type = InnoDB" it works...
"skip-innodb" is commented in my conf file and the rights seem good on the data directory..
Is there somethinf I'm missing ?

I'm running gentoo linux on an amd64.
my_print_defaults mysqld outputs:
--skip-bdb
--user=mysql
--pid-file=/var/run/mysqld/mysqld.pid
--socket=/var/run/mysqld/mysqld.sock
--log-error=/var/log/mysql/mysqld.err
--basedir=/usr
--datadir=/var/lib/mysql
--tmpdir=/tmp
--language=/usr/share/mysql/french
--skip-locking
--set-variable=key_buffer=16M
--set-variable=max_allowed_packet=20M
--set-variable=thread_stack=128K
--bind-address=127.0.0.1
--port=3306

Thanks in advance for your help