9 messages in com.mysql.lists.clusterRe: creating table engine fails with
FromSent OnAttachments
John Stile26 Oct 2004 12:36 
John Stile26 Oct 2004 13:25 
Mikael Ronström27 Oct 2004 00:31 
John Stile27 Oct 2004 01:53 
Mikael Ronström27 Oct 2004 02:12 
pek...@mysql.com27 Oct 2004 02:24 
John Stile27 Oct 2004 03:41 
pek...@mysql.com27 Oct 2004 03:48 
Ted Schundler09 Nov 2004 17:34 
Subject:Re: creating table engine fails with
From:John Stile (jo@stilen.com)
Date:10/27/2004 03:41:44 AM
List:com.mysql.lists.cluster

On Wed, 2004-10-27 at 02:24, pek@mysql.com wrote:

John,

This is what I changed it to: CREATE TABLE `mess_att` ( `id` varchar(255) NOT NULL default '', ^^^ `mail_id` text, `att_name` text, `attach` longblob, ^^^ PRIMARY KEY (`id`) ) TYPE=NDBCLUSTER;

ERROR 1005 (HY000): Can't create table './yourpassionconsultant_com_messenger/mess_attr.frm' (errno: 738)

This is bug in blob code which does not adjust for long primary key.

If you replace "longblob" by "mediumblob", it will work.

I am getting a different error now:

mysql> CREATE TABLE `mess_att` ( `id` varchar(255) NOT NULL default '', `mail_id` text, `att_name` text, `attach` mediumblob, PRIMARY KEY (`id`), UNIQUE KEY `PRI` (`id`) ) TYPE=NDBCLUSTER;

ERROR 1005 (HY000): Can't create table
'./somedomain_com_messenger/mess_att.frm' (errno: 156)

CREATE TABLE `popmail` ( `id` varchar(255) NOT NULL default '', `bytes` varchar(255) default NULL, `message` longtext, PRIMARY KEY (`id`) ) TYPE=NDBCLUSTER;

ERROR 1005 (HY000): Can't create table './somedomain_com_messenger/popmail.frm'
(errno: 156)