Error restoring on MySQL

2006-01-11 13:08:44,618 INFO [com.atlassian.confluence.lifecycle] Starting Confluence 2.1.1 (build #406)
2006-01-11 13:10:32,508 WARN [sf.hibernate.cache.EhCache] Could not find configuration for com.opensymphony.user.provider.hibernate.impl.HibernateUserImpl.groups. Configuring using the defaultCache settings.
2006-01-11 13:10:32,524 WARN [sf.hibernate.cache.EhCache] Could not find configuration for com.atlassian.confluence.pages.Draft. Configuring using the defaultCache settings.
2006-01-11 13:10:32,524 WARN [sf.hibernate.cache.EhCache] Could not find configuration for com.opensymphony.user.provider.hibernate.impl.HibernateUserImpl. Configuring using the defaultCache settings.
2006-01-11 13:10:32,524 WARN [sf.hibernate.cache.EhCache] Could not find configuration for com.atlassian.user.impl.hibernate.DefaultHibernateUser. Configuring using the defaultCache settings.
2006-01-11 13:10:32,524 WARN [sf.hibernate.cache.EhCache] Could not find configuration for com.atlassian.user.impl.hibernate.DefaultHibernateExternalEntity. Configuring using the defaultCache settings.
2006-01-11 13:10:32,524 WARN [sf.hibernate.cache.EhCache] Could not find configuration for com.atlassian.user.impl.hibernate.DefaultHibernateGroup. Configuring using the defaultCache settings.
2006-01-11 13:10:32,524 WARN [sf.hibernate.cache.EhCache] Could not find configuration for com.opensymphony.user.provider.hibernate.impl.HibernateGroupImpl. Configuring using the defaultCache settings.
2006-01-11 13:10:36,164 WARN [sf.hibernate.cache.EhCache] Could not find configuration for net.sf.hibernate.cache.StandardQueryCache. Configuring using the defaultCache settings.
2006-01-11 13:10:59,367 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table os_user_group add constraint FK932472461E2E76DB foreign key (group_id) references os_group (id)
2006-01-11 13:10:59,367 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-74c_35.frm' (errno: 150)"
2006-01-11 13:11:01,039 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table CONFANCESTORS add constraint FK9494E23C37E35A2E foreign key (ANCESTORID) references CONTENT (CONTENTID)
2006-01-11 13:11:01,055 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-74c_35.frm' (errno: 150)"
2006-01-11 13:11:03,336 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table local_members add constraint FK6B8FB445CE2B3226 foreign key (userid) references users (id)
2006-01-11 13:11:03,336 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-74c_35.frm' (errno: 150)"
2006-01-11 13:11:03,601 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table external_members add constraint FKD8C8D8A5F25E5D5F foreign key (extentityid) references external_entities (id)
2006-01-11 13:11:03,601 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-74c_35.frm' (errno: 150)"
2006-01-11 13:11:05,055 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table CONTENT add constraint FK6382C0598C38FBEA foreign key (PAGEID) references CONTENT (CONTENTID)
2006-01-11 13:11:05,055 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-74c_35.frm' (errno: 150)"
2006-01-11 13:11:50,898 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: create table groups (id bigint not null, groupname varchar(255) not null, primary key (id))
2006-01-11 13:11:50,898 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Table 'groups' already exists"
2006-01-11 13:11:51,070 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: create table SPACES (SPACEID bigint not null, SPACENAME varchar(255), SPACEKEY varchar(255) not null unique, SPACEDESCID bigint, HOMEPAGE bigint, CREATOR varchar(255), CREATIONDATE datetime, LASTMODIFIER varchar(255), LASTMODDATE datetime, primary key (SPACEID))
2006-01-11 13:11:51,070 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Table 'spaces' already exists"
2006-01-11 13:11:51,382 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: create table CONTENT (CONTENTID bigint not null, CONTENTTYPE varchar(255) not null, TITLE varchar(255), VERSION integer, CREATOR varchar(255), CREATIONDATE datetime, LASTMODIFIER varchar(255), LASTMODDATE datetime, VERSIONCOMMENT mediumtext, PREVVER bigint, CONTENT_STATUS varchar(255), SPACEID bigint, PARENTID bigint, MESSAGEID varchar(255), PAGEID bigint, PARENTCOMMENTID bigint, USERNAME varchar(255), primary key (CONTENTID))
2006-01-11 13:11:51,382 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Table 'content' already exists"
2006-01-11 13:11:55,773 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table os_user_group add constraint FK932472461E2E76DB foreign key (group_id) references os_group (id)
2006-01-11 13:11:55,773 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-74c_3a.frm' (errno: 150)"
2006-01-11 13:11:57,398 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table CONFANCESTORS add constraint FK9494E23C37E35A2E foreign key (ANCESTORID) references CONTENT (CONTENTID)
2006-01-11 13:11:57,398 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-74c_3a.frm' (errno: 150)"
2006-01-11 13:11:57,585 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: create index s_spacedescid_idx on SPACES (SPACEDESCID)
2006-01-11 13:11:57,585 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Invalid argument value message from server: "Duplicate key name 's_spacedescid_idx'"
2006-01-11 13:11:57,585 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: create index s_homepage_idx on SPACES (HOMEPAGE)
2006-01-11 13:11:57,585 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Invalid argument value message from server: "Duplicate key name 's_homepage_idx'"
2006-01-11 13:11:57,664 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table SPACES add constraint FK9228242D11B7BFEE foreign key (HOMEPAGE) references CONTENT (CONTENTID)
2006-01-11 13:11:57,664 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-74c_3a.frm' (errno: 121)"
2006-01-11 13:11:57,742 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table SPACES add constraint FK9228242D2C72D3D2 foreign key (SPACEDESCID) references CONTENT (CONTENTID)
2006-01-11 13:11:57,742 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-74c_3a.frm' (errno: 121)"
2006-01-11 13:11:58,507 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table local_members add constraint FK6B8FB445CE2B3226 foreign key (userid) references users (id)
2006-01-11 13:11:58,507 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-74c_3a.frm' (errno: 150)"
2006-01-11 13:11:58,710 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table external_members add constraint FKD8C8D8A5F25E5D5F foreign key (extentityid) references external_entities (id)
2006-01-11 13:11:58,710 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-74c_3a.frm' (errno: 150)"
2006-01-11 13:11:58,710 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: create index c_parentcommid_idx on CONTENT (PARENTCOMMENTID)
2006-01-11 13:11:58,710 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Invalid argument value message from server: "Duplicate key name 'c_parentcommid_idx'"
2006-01-11 13:11:58,710 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: create index c_title_idx on CONTENT (TITLE)
2006-01-11 13:11:58,710 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Invalid argument value message from server: "Duplicate key name 'c_title_idx'"
2006-01-11 13:11:58,710 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: create index c_spaceid_idx on CONTENT (SPACEID)
2006-01-11 13:11:58,710 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Invalid argument value message from server: "Duplicate key name 'c_spaceid_idx'"
2006-01-11 13:11:58,710 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: create index c_parentid_idx on CONTENT (PARENTID)
2006-01-11 13:11:58,710 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Invalid argument value message from server: "Duplicate key name 'c_parentid_idx'"
2006-01-11 13:11:58,726 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: create index c_username_idx on CONTENT (USERNAME)
2006-01-11 13:11:58,726 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Invalid argument value message from server: "Duplicate key name 'c_username_idx'"
2006-01-11 13:11:58,726 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: create index c_prevver_idx on CONTENT (PREVVER)
2006-01-11 13:11:58,726 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Invalid argument value message from server: "Duplicate key name 'c_prevver_idx'"
2006-01-11 13:11:58,726 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: create index c_messageid_idx on CONTENT (MESSAGEID)
2006-01-11 13:11:58,726 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Invalid argument value message from server: "Duplicate key name 'c_messageid_idx'"
2006-01-11 13:11:58,804 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table CONTENT add constraint FK6382C0598C38FBEA foreign key (PAGEID) references CONTENT (CONTENTID)
2006-01-11 13:11:58,804 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-74c_3a.frm' (errno: 150)"
2006-01-11 13:11:58,898 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table CONTENT add constraint FK6382C05974B18345 foreign key (PARENTID) references CONTENT (CONTENTID)
2006-01-11 13:11:58,898 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-74c_3a.frm' (errno: 121)"
2006-01-11 13:11:58,976 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table CONTENT add constraint FK6382C05917D4A070 foreign key (PREVVER) references CONTENT (CONTENTID)
2006-01-11 13:11:58,976 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-74c_3a.frm' (errno: 121)"
2006-01-11 13:11:59,085 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table CONTENT add constraint FK6382C059B97E9230 foreign key (PARENTCOMMENTID) references CONTENT (CONTENTID)
2006-01-11 13:11:59,085 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-74c_3a.frm' (errno: 121)"
2006-01-11 13:11:59,164 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table CONTENT add constraint FK6382C059B2DC6081 foreign key (SPACEID) references SPACES (SPACEID)
2006-01-11 13:11:59,164 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-74c_3a.frm' (errno: 121)"
2006-01-11 13:12:00,507 ERROR [atlassian.confluence.setup.DefaultHibernateConfigurator] Error creating additional indexes.
java.sql.SQLException: Invalid argument value message from server: "Duplicate key name 'c_contenttype_idx'"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2248)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2196)
at com.mysql.jdbc.Statement.execute(Statement.java:906)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:896)
at com.atlassian.confluence.setup.DefaultHibernateConfigurator.createAdditionalDatabaseIndexes(DefaultHibernateConfigurator.java:180)
at com.atlassian.confluence.setup.DefaultHibernateConfigurator.createConfluenceSchema(DefaultHibernateConfigurator.java:143)
at com.atlassian.confluence.importexport.impl.BackupImporter.deleteAllDatabaseContent(BackupImporter.java:434)
at com.atlassian.confluence.importexport.impl.BackupImporter.importEntities(BackupImporter.java:226)
at com.atlassian.confluence.importexport.impl.BackupImporter.importEverything(BackupImporter.java:155)
at com.atlassian.confluence.importexport.impl.FileBackupImporter.importEverything(FileBackupImporter.java:84)
at com.atlassian.confluence.importexport.impl.BackupImporter.doImport(BackupImporter.java:76)
at com.atlassian.confluence.importexport.impl.FileBackupImporter.doImport(FileBackupImporter.java:34)
at com.atlassian.confluence.importexport.DefaultImportExportManager.importAs(DefaultImportExportManager.java:81)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)
at $Proxy43.importAs(Unknown Source)
at com.atlassian.confluence.importexport.actions.ImportLongRunningTask.run(ImportLongRunningTask.java:45)
at java.lang.Thread.run(Thread.java:534)