ok, we've found a way to reproduce the 830 problem, it is a memory leak
in case of a 800 error.
Thank you for the help.
There is a bug report. http://bugs.mysql.com/bug.php?id=4644
It will be fixed in 4.1.8
T
Chad Martin wrote:
> Olivier Kaloudoff wrote:
>
>> mysql> CREATE TABLE MMyCache (
>> -> date date,
>> -> url varchar(255),
>> -> file_name varchar(64),
>> -> PRIMARY KEY (file_name)
>> -> ) ;
>> ERROR 1005 (HY000): Can't create table './beta6/MMyCache.frm' (errno:
>> 830)
>>
>>
>> mysql> CREATE TABLE MMyCache ( date date, url varchar(255),
>> file_name varchar(64) );
>> ERROR 1005 (HY000): Can't create table './beta6/MMyCache.frm' (errno:
>> 155)
>
>
> I'm pretty sure that you need a primary key, and that the primary key
> has to be a numeric type. I expect error 830 above is because you're
> using a varchar for your primary key, and 155 is because you're not
> using one at all.
>
> Chad Martin
>
