Details

      Description

      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)

        Attachments

        1. DefaultHibernateConfigurator.class
          8 kB
          dave
        2. hibernate-2.1.8-atlassian.jar
          945 kB
          dave
        3. stacktrace.txt
          53 kB
          Stephane Nicoll

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              dave@atlassian.com dave (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: