List:Cluster« Previous MessageNext Message »
From:Tomas Ulin Date:November 11 2004 9:43am
Subject:Re: perror 800 ?
View as plain text  
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
>

Thread
perror 800 ?Olivier Kaloudoff10 Nov
  • Re: perror 800 ?Olivier Kaloudoff10 Nov
    • Re: perror 800 ?Chad Martin11 Nov
      • Re: perror 800 ?Tomas Ulin11 Nov
    • Re: perror 800 ?Tomas Ulin11 Nov