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)