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.
5 messages in com.mysql.lists.clusterRe: perror 800 ?
