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

Atlassian JIRA | Dave Loeng [Atlassian] | 1 decade ago
  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 | 3 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