Re: #1005 - Can't create table (errno: 4242) - importing table to NDB from myISAM

[Alex Davies]

Dear Egbert,

Thanks, that seems to have fixed that bit. But I get the same error on
this query:

 SQL-query:

CREATE TABLE `xcart_counties` (
`countyid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`stateid` int( 11 ) NOT NULL default '0',
`county` varchar( 255 ) NOT NULL default '',
PRIMARY KEY ( `countyid` ) ,
UNIQUE KEY `countyname` ( `stateid` , `county` )
) ENGINE = NDBCLUSTER DEFAULT CHARSET = ascii AUTO_INCREMENT =1

MySQL said:
#1005 - Can't create table './test2/xcart_counties.frm' (errno: 4242) 

Any further guesses? Many thanks for your help so far.

With best wishes,

Alex

On Mon, 31 Jan 2005 17:32:13 +0100, Egbert Rabe <e.rabe@stripped> wrote:
> I had a similar problem, seems that ndbd has problems with primary key
> and unique key together on the same colum.
> Try omitting tho Unique key, there is no need for it (primary is allway
> unique).
> Hope that works
> 
> > Dear Gurus,
> >
> > I am trying to import a table that works fine under myISAM but does
> > not work when I change the ENGINE=NDBCLUSTER. I get the following
> > error:
> >
> > #1005 - Can't create table './test/xcart_customers.frm' (errno: 4242)
> >
> > A lot of googling has told me that means that there are too many indes
> > and advises me to "Try and increase MaxNoOfUniqueIndexes and/or
> > MaxNoOfOrderedIndexes" and I have now got this in my config.ini:
> >
> > [NDBD DEFAULT]
> > NoOfReplicas=2
> > DataMemory = 200MB
> > IndexMemory = 100MB
> > MaxNoOfOrderedIndexes = 100
> >
> > I can not set MaxNoOfUniqueIndexes - it tells me that there is no such
> > option in config.ini.
> >
> > However, despite this, when I try to start ndb_mgmd I still get the error.
> >
> > Can someone point me in the right direction and tell me what I am doing wrong?
> >
> > The dump follows:
> >
> >
> > CREATE TABLE `xcart_customers` (
> > `login` varchar( 32 ) NOT NULL default '',
> > `usertype` char( 1 ) NOT NULL default '',
> > `membership` varchar( 32 ) NOT NULL default '',
> > `password` varchar( 128 ) NOT NULL default '',
> > `password_hint` varchar( 128 ) NOT NULL default '',
> > `password_hint_answer` varchar( 128 ) NOT NULL default '',
> > `b_address` varchar( 64 ) NOT NULL default '',
> > `b_city` varchar( 64 ) NOT NULL default '',
> > `b_county` varchar( 32 ) NOT NULL default '',
> > `b_state` varchar( 32 ) NOT NULL default '',
> > `b_country` char( 2 ) NOT NULL default '',
> > `b_zipcode` varchar( 32 ) NOT NULL default '',
> > `title` varchar( 32 ) NOT NULL default '',
> > `firstname` varchar( 128 ) NOT NULL default '',
> > `lastname` varchar( 128 ) NOT NULL default '',
> > `company` varchar( 255 ) NOT NULL default '',
> > `s_address` varchar( 255 ) NOT NULL default '',
> > `s_city` varchar( 255 ) NOT NULL default '',
> > `s_county` varchar( 32 ) NOT NULL default '',
> > `s_state` varchar( 32 ) NOT NULL default '',
> > `s_country` char( 2 ) NOT NULL default '',
> > `s_zipcode` varchar( 32 ) NOT NULL default '',
> > `email` varchar( 128 ) NOT NULL default '',
> > `phone` varchar( 32 ) NOT NULL default '',
> > `fax` varchar( 32 ) NOT NULL default '',
> > `url` varchar( 128 ) NOT NULL default '',
> > `card_name` varchar( 255 ) NOT NULL default '',
> > `card_type` varchar( 16 ) NOT NULL default '',
> > `card_number` varchar( 42 ) NOT NULL default '',
> > `card_expire` varchar( 4 ) NOT NULL default '',
> > `card_cvv2` char( 3 ) NOT NULL default '',
> > `last_login` int( 11 ) NOT NULL default '0',
> > `first_login` int( 11 ) NOT NULL default '0',
> > `status` char( 1 ) NOT NULL default 'Y',
> > `referer` varchar( 255 ) NOT NULL default '',
> > `pending_membership` varchar( 32 ) NOT NULL default '',
> > `ssn` varchar( 32 ) NOT NULL default '',
> > `language` char( 2 ) NOT NULL default 'US',
> > `cart` mediumtext NOT NULL ,
> > `change_password` char( 1 ) NOT NULL default 'N',
> > `parent` varchar( 32 ) NOT NULL default '',
> > `pending_plan_id` int( 11 ) NOT NULL default '0',
> > PRIMARY KEY ( `login` ) ,
> > UNIQUE KEY `login` ( `login` ) ,
> > KEY `usertype` ( `usertype` ) ,
> > KEY `membership` ( `membership` ) ,
> > KEY `last_login` ( `last_login` ) ,
> > KEY `first_login` ( `first_login` ) ,
> > KEY `status` ( `status` )
> > ) ENGINE = NDBCLUSTER DEFAULT CHARSET = ascii
> >
> 
> 
> --
> Mit freundlichen Grüßen
> 
> Egbert Rabe
> Systemadministrator/Anwendungsentwickler
> 
> ========================================================================
>       __
>      /  \      axilaris GmbH
>      |  |      Moritzstraße 24
>   __ \__/ __   09111 Chemnitz
>   \ \    / /
>    \ \  / /    Fon:  03 71 / 99-44 04
>     | || |     Fax:  03 71 / 99-44 09
>     | || |     Mail: e.rabe@stripped
>     | || |     Web:  www.axilaris.de
>     | || |
>    / /  \ \    Handelsregister: HRB 20494, Amtsgericht Chemnitz
>   /_/    \_\   Umsatzsteuer-Identifikationsnummer: 215/144/00196
> 
> ========================================================================
> 
> Diese E-Mail enthält möglicherweise vertrauliche und/oder rechtlich
> geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder
> diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den
> Absender und vernichten diese E-Mail. Das unerlaubte Kopieren sowie die
> unbefugte Weitergabe dieser E-Mail ist nicht gestattet.
> 
> This e-mail may contain confidential and/or privileged information. If
> you are not the intended recipient or have received this e-mail in error
> please notify the sender immediately and destroy this e-mail. Any
> unauthorized copying, disclosure or distribution of the material in this
> e-mail is strictly prohibited.
> 
> 


-- 
Alex Davies // http://www.davz.net

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the sender immediately by e-mail and delete this e-mail permanently.