java.sql.SQLException: Invalid argument value message from server: "Duplicate key name 'c_contenttype_idx'"

Atlassian JIRA | Dave Loeng [Atlassian] | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    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)

    Atlassian JIRA | 1 decade ago | Dave Loeng [Atlassian]
    java.sql.SQLException: Invalid argument value message from server: "Duplicate key name 'c_contenttype_idx'"
  2. 0

    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)

    Atlassian JIRA | 1 decade ago | Dave Loeng [Atlassian]
    java.sql.SQLException: Invalid argument value message from server: "Duplicate key name 'c_contenttype_idx'"
  3. 0

    Default Carrier Database Issue

    GitHub | 3 years ago | ghost
    java.sql.SQLException: Column count doesn't match value count at row 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    jdbc Error, unable to connect to sql

    Stack Overflow | 4 years ago | SDWACW
    java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM test SET name=eee WHERE id=1' at line 1
  6. 0

    Getting a mysql error when trying to edit table

    Stack Overflow | 3 years ago | Mnemonics
    java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=501' at line 1

    2 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Invalid argument value message from server: "Duplicate key name 'c_contenttype_idx'"

      at com.mysql.jdbc.MysqlIO.checkErrorPacket()
    2. MySQL jdbc
      Statement.execute
      1. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
      2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
      3. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
      4. com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224)
      5. com.mysql.jdbc.Connection.execSQL(Connection.java:2248)
      6. com.mysql.jdbc.Connection.execSQL(Connection.java:2196)
      7. com.mysql.jdbc.Statement.execute(Statement.java:906)
      7 frames
    3. c3p0:JDBC DataSources/Resource Pools
      NewProxyStatement.execute
      1. com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:896)
      1 frame
    4. com.atlassian.confluence
      DefaultImportExportManager.importAs
      1. com.atlassian.confluence.setup.DefaultHibernateConfigurator.createAdditionalDatabaseIndexes(DefaultHibernateConfigurator.java:180)
      2. com.atlassian.confluence.setup.DefaultHibernateConfigurator.createConfluenceSchema(DefaultHibernateConfigurator.java:143)
      3. com.atlassian.confluence.importexport.impl.BackupImporter.deleteAllDatabaseContent(BackupImporter.java:434)
      4. com.atlassian.confluence.importexport.impl.BackupImporter.importEntities(BackupImporter.java:226)
      5. com.atlassian.confluence.importexport.impl.BackupImporter.importEverything(BackupImporter.java:155)
      6. com.atlassian.confluence.importexport.impl.FileBackupImporter.importEverything(FileBackupImporter.java:84)
      7. com.atlassian.confluence.importexport.impl.BackupImporter.doImport(BackupImporter.java:76)
      8. com.atlassian.confluence.importexport.impl.FileBackupImporter.doImport(FileBackupImporter.java:34)
      9. com.atlassian.confluence.importexport.DefaultImportExportManager.importAs(DefaultImportExportManager.java:81)
      9 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:324)
      4 frames
    6. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116)
      3 frames
    7. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
      1 frame
    8. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)
      2 frames
    9. Unknown
      $Proxy43.importAs
      1. $Proxy43.importAs(Unknown Source)
      1 frame
    10. com.atlassian.confluence
      ImportLongRunningTask.run
      1. com.atlassian.confluence.importexport.actions.ImportLongRunningTask.run(ImportLongRunningTask.java:45)
      1 frame
    11. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame