MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: ERROR 1005: Can't create table (errno: 121) Help
Posted by: Heikki Tuuri
Date: March 15, 2006 03:17PM

Hi!

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.

What does InnoDB print in the .err log?

Best regards,

Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
ERROR 1005: Can't create table (errno: 121) Help
324795
Stephen Baker
July 12, 2005 11:49AM
Re: ERROR 1005: Can't create table (errno: 121) Help
145460
Shweta Gadgil
July 18, 2005 10:12PM
Re: ERROR 1005: Can't create table (errno: 121) Help
133856
development
July 19, 2005 12:37AM
Re: ERROR 1005: Can't create table (errno: 121) Help
89350
Willumpie de Jong
March 15, 2006 06:35AM
Re: ERROR 1005: Can't create table (errno: 121) Help
70660
Tafadzwa Karimazondo
December 20, 2007 03:05PM
Re: ERROR 1005: Can't create table (errno: 121) Help
118803
Heikki Tuuri
March 15, 2006 03:17PM
Re: ERROR 1005: Can't create table (errno: 121) Help
40001
Fred Riley
May 05, 2006 10:49AM
Re: ERROR 1005: Can't create table (errno: 121) Help
16834
Cooper Quintin
December 11, 2008 04:29AM
Re: ERROR 1005: Can't create table (errno: 121) Help
18002
Michael Soliman
August 30, 2006 07:00AM
Re: ERROR 1005: Can't create table (errno: 121) Help
16531
Christian An
September 03, 2006 05:50AM
Re: ERROR 1005: Can't create table (errno: 121) Help
16618
Hsing-Tsu Lai
September 03, 2006 10:47AM
Re: ERROR 1005: Can't create table (errno: 121) Help
13150
bhanu prasad
May 29, 2007 05:25AM
Re: ERROR 1005: Can't create table (errno: 121) Help
16397
Vladimir Gorokhov
October 25, 2007 08:21AM
Re: ERROR 1005: Can't create table (errno: 121) Help
10438
danielle davis
February 19, 2009 08:39AM
Re: ERROR 1005: Can't create table (errno: 121) Help
11009
Chemi Peña
June 08, 2007 10:41AM
Re: ERROR 1005: Can't create table (errno: 121) Help
10505
James Troi
March 23, 2006 04:07PM
Re: ERROR 1005: Can't create table (errno: 121) Help
8779
Lanny Day
July 06, 2006 10:02AM
Re: ERROR 1005: Can't create table (errno: 121) Help
8882
Paul Pikowsky
July 26, 2006 03:34PM
Re: ERROR 1005: Can't create table (errno: 121) Help
8111
Mourad DRAOUIL
September 19, 2007 04:47AM
Re: ERROR 1005: Can't create table (errno: 121) Help
11048
Eric Brunson
September 12, 2006 12:53PM
Re: ERROR 1005: Can't create table (errno: 121) Help
9554
Prabhakar Kasi
June 06, 2007 07:37AM
Re: ERROR 1005: Can't create table (errno: 121) Help
13511
charles sheinin
March 06, 2008 06:22PM
Re: ERROR 1005: Can't create table (errno: 121) Help
8544
AAA BBB
April 25, 2008 02:07PM
Re: ERROR 1005: Can't create table (errno: 121) Help
5780
m h
January 28, 2009 05:16AM
Re: ERROR 1005: Can't create table (errno: 121) Help
16608
morgan mora
February 23, 2009 07:16PM
Re: ERROR 1005: Can't create table (errno: 121) Help
7772
Bernie Glynn
April 28, 2009 01:06AM
Re: ERROR 1005: Can't create table (errno: 121) Help
16954
John Wilson
May 22, 2009 09:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.