Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-3563

Failed to restore from backup version 1.3.2

    XMLWordPrintable

Details

    • Bug
    • Resolution: Support Request
    • Highest
    • None
    • 1.4.2
    • None
    • VMWare 5.0.0-13124: Windows 2000 Advanced Server SP4, MS SQL 2000 SP4, Orion 2.0.5, j2sdk 1.4.2_08, jtds 0.8

    Description

      Cause:
      (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_os_group_690797E6'. Cannot insert duplicate key in object 'os_group'.

      Stack Trace: [hide]

      (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_os_group_690797E6'. Cannot insert duplicate key in object 'os_group'.
      Referer URL: http://ahf-web/confluence/setup/setup-restore-local.action

      Build Information:
      Uptime: 4 minutes, 53 seconds
      Version: 1.4.2
      Build Number: 214

      Server Information:
      Application Server: Orion/2.0.5
      Servlet Version: 2.3
      Database Dialect: net.sf.hibernate.dialect.SQLServerDialect

      Memory Information:
      Total Memory: 254 MB
      Free Memory: 18 MB
      Used Memory: 236 MB

      System Information:
      System Date: ???????, 14 ??? 2005
      System Time: 11:31:09
      System Favourite Colour: Lime
      Java Version: 1.4.2_08
      Java Vendor: Sun Microsystems Inc.
      JVM Version: 1.0
      JVM Vendor: Sun Microsystems Inc.
      JVM Implementation Version: 1.4.2_08-b03
      Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition
      Java VM: Java HotSpot(TM) Client VM
      User Name: SYSTEM
      User Timezone: Asia/Novosibirsk
      Operating System: Windows 2000 5.0
      OS Architecture: x86

      Request
      Information:
      URL: http://ahf-web/confluence/500page.jsp

      • Scheme: http
      • Server: ahf-web
      • Port: 80
      • URI: /confluence/500page.jsp
      • - Context Path: /confluence
      • - Servlet Path: /500page.jsp
      • - Path Info: null
      • - Query String: null

      Attributes:

      • javax.servlet.error.servlet_name : action
      • javax.servlet.error.message : (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_os_group_690797E6'. Cannot insert duplicate key in object 'os_group'.
      • javax.servlet.error.exception : org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_os_group_690797E6'. Cannot insert duplicate key in object 'os_group'.
      • webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@1f75107
      • com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true
      • javax.servlet.error.request_uri : /confluence/setup/setup-restore-local.action
      • javax.servlet.jsp.jspException : org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_os_group_690797E6'. Cannot insert duplicate key in object 'os_group'.
      • javax.servlet.error.status_code : 500
      • _sitemesh_filterapplied : true
      • sessioninview.FILTERED : true
      • com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true

      Parameters:

      • localFileName = daily-backup-14???2005.zip
      • buildIndex = true

      Logging:
      8 log statements generated by this request:

      [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] String or binary data would be truncated.

      [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Unspecified error returned.

      [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session

      [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [com.atlassian.confluence.importexport.impl.BackupImporter] Error while upgrading imported data (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.SQLException: String or binary data would be truncated.

      Throwable:
      org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.SQLException: String or binary data would be truncated.
      java.sql.SQLException: String or binary data would be truncated.
      at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392)
      at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91)
      at net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:750)
      at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710)
      at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302)
      at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282)
      at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136)
      at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290)
      at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)
      at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449)
      at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392)
      at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1821)
      at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3863)
      at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52)

      [ERROR] Thu Jul 14 11:30:48 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Violation of PRIMARY KEY constraint 'PK_os_group_690797E6'. Cannot insert duplicate key in object 'os_group'.

      [ERROR] Thu Jul 14 11:30:48 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Unspecified error returned.

      [ERROR] Thu Jul 14 11:30:48 NOVST 2005 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session

      [ERROR] Thu Jul 14 11:31:08 NOVST 2005 [com.opensymphony.webwork.dispatcher.ServletDispatcher] Could not execute action

      Throwable:
      org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_os_group_690797E6'. Cannot insert duplicate key in object 'os_group'.
      java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_os_group_690797E6'. Cannot insert duplicate key in object 'os_group'.
      at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392)
      at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91)
      at net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:750)
      at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710)
      at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302)
      at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282)
      at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136)
      at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290)
      at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)
      at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449)
      at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392)
      at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261)
      at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
      at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463)

      Attachments

        Activity

          People

            Unassigned Unassigned
            09e535169999 Rashit A. Fakhreyev
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: