|
Re: [Teneo] Error in table creation, unusual table names [message #111882 is a reply to message #111881] |
Thu, 07 February 2008 15:44 |
Martin Taal Messages: 5468 Registered: July 2009 |
Senior Member |
|
|
Hmm, according to some mysql forum error 121 is this:
errno 121 means a duplicate key error. Probably the table already exists in the InnoDB internal data
dictionary, though the .frm file for the table has been deleted. This is the most common reason for
getting errno 121 in table creation. Another possible reason is a name conflict in a foreign key
constraint name. Constraint names must be unique in a database, like table names are.
So this can be a nameclash, can you try the following setting:
SET_FOREIGN_KEY_NAME to false
gr. Martin
david wrote:
> Still getting errors of this kind
>
> 424813 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
> Unsuccessful: alter table `dtrmntnsrc_dtrmintinsrcchildrn` add index
> determintinsrce_mrketstatstype (`dtrmntinsrcchildrn_mrktsttstyp`), add
> constraint determintinsrce_mrketstatstype foreign key
> (`dtrmntinsrcchildrn_mrktsttstyp`) references `marketstatustype` (`id`)
> 424813 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Can't
> create table 'gensec.#sql-55c_12c' (errno: 121)
>
> David
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
|
|
|
Re: [Teneo] Error in table creation, unusual table names [message #615432 is a reply to message #111881] |
Thu, 07 February 2008 15:44 |
Martin Taal Messages: 5468 Registered: July 2009 |
Senior Member |
|
|
Hmm, according to some mysql forum error 121 is this:
errno 121 means a duplicate key error. Probably the table already exists in the InnoDB internal data
dictionary, though the .frm file for the table has been deleted. This is the most common reason for
getting errno 121 in table creation. Another possible reason is a name conflict in a foreign key
constraint name. Constraint names must be unique in a database, like table names are.
So this can be a nameclash, can you try the following setting:
SET_FOREIGN_KEY_NAME to false
gr. Martin
david wrote:
> Still getting errors of this kind
>
> 424813 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
> Unsuccessful: alter table `dtrmntnsrc_dtrmintinsrcchildrn` add index
> determintinsrce_mrketstatstype (`dtrmntinsrcchildrn_mrktsttstyp`), add
> constraint determintinsrce_mrketstatstype foreign key
> (`dtrmntinsrcchildrn_mrktsttstyp`) references `marketstatustype` (`id`)
> 424813 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Can't
> create table 'gensec.#sql-55c_12c' (errno: 121)
>
> David
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
|
|
|
Powered by
FUDForum. Page generated in 0.04172 seconds