java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • At least two users have reported this same stack trace when trying to backup their data: org.springframework.dao.DataIntegrityViolationException: (SessionSynchronization): data integrity violated by SQL 'null'; nested exception is: java.sql.SQLException: Integrity constraint violation: FK932472461E2E76DB table: OS_GROUP in statement [insert into os_user_group (user_id, group_id) values (6, 4)] java.sql.SQLException: Integrity constraint violation: FK932472461E2E76DB table: OS_GROUP in statement [insert into os_user_group (user_id, group_id) values (6, 4)] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1075) at net.sf.hibernate.impl.ScheduledCollectionRecreate.execute(ScheduledCollectionRecreate.java:23) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2326) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2283) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2180) at org.springframework.orm.hibernate.SessionFactoryUtils$SessionSynchronization.beforeCommit(SessionFactoryUtils.java:217) at org.springframework.transaction.support.TransactionSynchronizationManager.triggerBeforeCommit(TransactionSynchronizationManager.java:172) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:213) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:172) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy21.exportAs(Unknown Source) at com.atlassian.confluence.importexport.actions.BackupAction.execute(BackupAction.java:29)
    via by Mike Cannon-Brookes,
  • Here is the exception I get on server: 2004-02-06 13:48:30,671 WARN [sf.hibernate.util.JDBCExceptionReporter] SQL Error: -9, SQLState: 23000 2004-02-06 13:48:30,671 ERROR [sf.hibernate.util.JDBCExceptionReporter] Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)] 2004-02-06 13:48:30,671 ERROR [sf.hibernate.util.JDBCExceptionReporter] could not insert: [com.atlassian.confluence.spaces.SpaceDescription#0] java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:469) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:443) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2326) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2279) at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1747) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1508) at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1532) at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:27) at com.atlassian.confluence.user.persistence.dao.hibernate.ConfluenceUserDAO$1.doInHibernate(ConfluenceUserDAO.java:86) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:147) at com.atlassian.confluence.user.persistence.dao.hibernate.ConfluenceUserDAO.findUserByUsername(ConfluenceUserDAO.java:77) at com.opensymphony.user.provider.hibernate.HibernateCredentialsProvider.handles(HibernateCredentialsProvider.java:83) at com.atlassian.confluence.user.providers.ConfluenceCredentialsProvider.handles(ConfluenceCredentialsProvider.java:47) at com.opensymphony.user.UserManager.getProvider(UserManager.java:310) at com.opensymphony.user.UserManager.getEntity(UserManager.java:296) at com.opensymphony.user.UserManager.getUser(UserManager.java:190) at com.atlassian.confluence.user.DefaultUserAccessor.getUser(DefaultUserAccessor.java:94) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:17) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy5.getUser(Unknown Source) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:153) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy6.getUser(Unknown Source) at com.atlassian.confluence.user.PersonalInformation.getFullName(PersonalInformation.java:53) 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.apache.commons.beanutils.PropertyUtils.getSimpleProperty(PropertyUtils.java:1185) at org.apache.commons.beanutils.PropertyUtils.getNestedProperty(PropertyUtils.java:772) at org.apache.commons.beanutils.BeanUtils.getNestedProperty(BeanUtils.java:695) at org.apache.commons.beanutils.BeanUtils.getProperty(BeanUtils.java:720) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.getStringContentOfAttribute(XmlLuceneDocumentFactory.java:78) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.createDocumentForObjectFromClassConfiguration(XmlLuceneDocumentFactory.java:44) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.createDocument(XmlLuceneDocumentFactory.java:27) at com.atlassian.confluence.search.lucene.LuceneIndexer.index(LuceneIndexer.java:62) at com.atlassian.confluence.importexport.impl.BackupImporter.importEntities(BackupImporter.java:184) at com.atlassian.confluence.importexport.impl.BackupImporter.doImport(BackupImporter.java:95) at com.atlassian.confluence.importexport.DefaultImportExportManager.importAs(DefaultImportExportManager.java:40) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:153) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy21.importAs(Unknown Source) at com.atlassian.confluence.importexport.actions.RestoreAction.doRestore(RestoreAction.java:23) at com.atlassian.confluence.importexport.actions.AbstractImportAction.execute(AbstractImportAction.java:44) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:173) at com.atlassian.confluence.setup.actions.SetupCheckInterceptor.intercept(SetupCheckInterceptor.java:27) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:58) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:32) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:18) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:182) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:162) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:36) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:84) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:95) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:83) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:39) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) 2004-02-06 13:48:30,687 ERROR [sf.hibernate.impl.SessionImpl] Could not synchronize database state with session net.sf.hibernate.JDBCException: could not insert: [com.atlassian.confluence.spaces.SpaceDescription#0] at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:479) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:443) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2326) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2279) at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1747) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1508) at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1532) at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:27) at com.atlassian.confluence.user.persistence.dao.hibernate.ConfluenceUserDAO$1.doInHibernate(ConfluenceUserDAO.java:86) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:147) at com.atlassian.confluence.user.persistence.dao.hibernate.ConfluenceUserDAO.findUserByUsername(ConfluenceUserDAO.java:77) at com.opensymphony.user.provider.hibernate.HibernateCredentialsProvider.handles(HibernateCredentialsProvider.java:83) at com.atlassian.confluence.user.providers.ConfluenceCredentialsProvider.handles(ConfluenceCredentialsProvider.java:47) at com.opensymphony.user.UserManager.getProvider(UserManager.java:310) at com.opensymphony.user.UserManager.getEntity(UserManager.java:296) at com.opensymphony.user.UserManager.getUser(UserManager.java:190) at com.atlassian.confluence.user.DefaultUserAccessor.getUser(DefaultUserAccessor.java:94) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:17) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy5.getUser(Unknown Source) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:153) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy6.getUser(Unknown Source) at com.atlassian.confluence.user.PersonalInformation.getFullName(PersonalInformation.java:53) 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.apache.commons.beanutils.PropertyUtils.getSimpleProperty(PropertyUtils.java:1185) at org.apache.commons.beanutils.PropertyUtils.getNestedProperty(PropertyUtils.java:772) at org.apache.commons.beanutils.BeanUtils.getNestedProperty(BeanUtils.java:695) at org.apache.commons.beanutils.BeanUtils.getProperty(BeanUtils.java:720) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.getStringContentOfAttribute(XmlLuceneDocumentFactory.java:78) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.createDocumentForObjectFromClassConfiguration(XmlLuceneDocumentFactory.java:44) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.createDocument(XmlLuceneDocumentFactory.java:27) at com.atlassian.confluence.search.lucene.LuceneIndexer.index(LuceneIndexer.java:62) at com.atlassian.confluence.importexport.impl.BackupImporter.importEntities(BackupImporter.java:184) at com.atlassian.confluence.importexport.impl.BackupImporter.doImport(BackupImporter.java:95) at com.atlassian.confluence.importexport.DefaultImportExportManager.importAs(DefaultImportExportManager.java:40) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:153) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy21.importAs(Unknown Source) at com.atlassian.confluence.importexport.actions.RestoreAction.doRestore(RestoreAction.java:23) at com.atlassian.confluence.importexport.actions.AbstractImportAction.execute(AbstractImportAction.java:44) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:173) at com.atlassian.confluence.setup.actions.SetupCheckInterceptor.intercept(SetupCheckInterceptor.java:27) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:58) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:32) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:18) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:182) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:162) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:36) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:84) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:95) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:83) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:39) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:469) ... 120 more 2004-02-06 13:48:30,703 WARN [springframework.jdbc.support.SQLStateSQLExceptionTranslator] Translating SQLException with SQLState '23000' and errorCode '-9' and message [Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)]]; SQL was [null] for task [HibernateAccessor] 2004-02-06 13:48:30,703 WARN [springframework.jdbc.support.SQLStateSQLExceptionTranslator] Translating SQLException with SQLState '23000' and errorCode '-9' and message [Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)]]; SQL was [null] for task [HibernateAccessor] 2004-02-06 13:48:30,703 ERROR [springframework.transaction.interceptor.TransactionInterceptor] Invoking rollback for transaction on method 'getUser' due to throwable [org.springframework.dao.DataIntegrityViolationException: (HibernateAccessor): data integrity violated by SQL 'null'; nested exception is: java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)]] 2004-02-06 13:48:30,703 ERROR [springframework.transaction.interceptor.TransactionInterceptor] Invoking rollback for transaction on method 'getUser' due to throwable [org.springframework.dao.DataIntegrityViolationException: (HibernateAccessor): data integrity violated by SQL 'null'; nested exception is: java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)]] 2004-02-06 13:48:30,703 ERROR [confluence.importexport.impl.BackupImporter] Can not import the entities! com.atlassian.confluence.search.lucene.LuceneException: Couldn't get string content of attribute, attributeName=fullName at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.getStringContentOfAttribute(XmlLuceneDocumentFactory.java:84) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.createDocumentForObjectFromClassConfiguration(XmlLuceneDocumentFactory.java:44) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.createDocument(XmlLuceneDocumentFactory.java:27) at com.atlassian.confluence.search.lucene.LuceneIndexer.index(LuceneIndexer.java:62) at com.atlassian.confluence.importexport.impl.BackupImporter.importEntities(BackupImporter.java:184) at com.atlassian.confluence.importexport.impl.BackupImporter.doImport(BackupImporter.java:95) at com.atlassian.confluence.importexport.DefaultImportExportManager.importAs(DefaultImportExportManager.java:40) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:153) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy21.importAs(Unknown Source) at com.atlassian.confluence.importexport.actions.RestoreAction.doRestore(RestoreAction.java:23) at com.atlassian.confluence.importexport.actions.AbstractImportAction.execute(AbstractImportAction.java:44) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:173) at com.atlassian.confluence.setup.actions.SetupCheckInterceptor.intercept(SetupCheckInterceptor.java:27) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:58) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:32) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:18) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:182) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:162) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:36) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:84) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:95) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:83) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:39) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) 2004-02-06 13:48:30,718 ERROR [opensymphony.webwork.dispatcher.ServletDispatcher] Could not execute action com.atlassian.confluence.importexport.ImportExportException: com.atlassian.confluence.search.lucene.LuceneException: Couldn't get string content of attribute, attributeName=fullName at com.atlassian.confluence.importexport.impl.BackupImporter.importEntities(BackupImporter.java:193) at com.atlassian.confluence.importexport.impl.BackupImporter.doImport(BackupImporter.java:95) at com.atlassian.confluence.importexport.DefaultImportExportManager.importAs(DefaultImportExportManager.java:40) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:153) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy21.importAs(Unknown Source) at com.atlassian.confluence.importexport.actions.RestoreAction.doRestore(RestoreAction.java:23) at com.atlassian.confluence.importexport.actions.AbstractImportAction.execute(AbstractImportAction.java:44) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:173) at com.atlassian.confluence.setup.actions.SetupCheckInterceptor.intercept(SetupCheckInterceptor.java:27) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:58) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:32) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:18) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:182) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:162) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:36) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:84) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:95) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:83) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:39) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) Caused by: com.atlassian.confluence.search.lucene.LuceneException: Couldn't get string content of attribute, attributeName=fullName at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.getStringContentOfAttribute(XmlLuceneDocumentFactory.java:84) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.createDocumentForObjectFromClassConfiguration(XmlLuceneDocumentFactory.java:44) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.createDocument(XmlLuceneDocumentFactory.java:27) at com.atlassian.confluence.search.lucene.LuceneIndexer.index(LuceneIndexer.java:62) at com.atlassian.confluence.importexport.impl.BackupImporter.importEntities(BackupImporter.java:184) ... 67 more 2004-02-06 13:48:34,390 WARN [sf.hibernate.util.JDBCExceptionReporter] SQL Error: -9, SQLState: 23000 2004-02-06 13:48:34,390 ERROR [sf.hibernate.util.JDBCExceptionReporter] Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)] 2004-02-06 13:48:34,390 ERROR [sf.hibernate.util.JDBCExceptionReporter] could not insert: [com.atlassian.confluence.spaces.SpaceDescription#0] java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:469) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:443) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2326) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2279) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2180) at com.atlassian.confluence.setup.SpringSessionInViewFilter.closeSession(SpringSessionInViewFilter.java:42) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:88) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:39) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) 2004-02-06 13:48:34,390 ERROR [sf.hibernate.impl.SessionImpl] Could not synchronize database state with session net.sf.hibernate.JDBCException: could not insert: [com.atlassian.confluence.spaces.SpaceDescription#0] at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:479) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:443) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2326) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2279) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2180) at com.atlassian.confluence.setup.SpringSessionInViewFilter.closeSession(SpringSessionInViewFilter.java:42) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:88) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:39) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:469) ... 20 more
    via by Armond Avanes,
  • Here is the exception I get on server: 2004-02-06 13:48:30,671 WARN [sf.hibernate.util.JDBCExceptionReporter] SQL Error: -9, SQLState: 23000 2004-02-06 13:48:30,671 ERROR [sf.hibernate.util.JDBCExceptionReporter] Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)] 2004-02-06 13:48:30,671 ERROR [sf.hibernate.util.JDBCExceptionReporter] could not insert: [com.atlassian.confluence.spaces.SpaceDescription#0] java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:469) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:443) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2326) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2279) at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1747) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1508) at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1532) at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:27) at com.atlassian.confluence.user.persistence.dao.hibernate.ConfluenceUserDAO$1.doInHibernate(ConfluenceUserDAO.java:86) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:147) at com.atlassian.confluence.user.persistence.dao.hibernate.ConfluenceUserDAO.findUserByUsername(ConfluenceUserDAO.java:77) at com.opensymphony.user.provider.hibernate.HibernateCredentialsProvider.handles(HibernateCredentialsProvider.java:83) at com.atlassian.confluence.user.providers.ConfluenceCredentialsProvider.handles(ConfluenceCredentialsProvider.java:47) at com.opensymphony.user.UserManager.getProvider(UserManager.java:310) at com.opensymphony.user.UserManager.getEntity(UserManager.java:296) at com.opensymphony.user.UserManager.getUser(UserManager.java:190) at com.atlassian.confluence.user.DefaultUserAccessor.getUser(DefaultUserAccessor.java:94) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:17) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy5.getUser(Unknown Source) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:153) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy6.getUser(Unknown Source) at com.atlassian.confluence.user.PersonalInformation.getFullName(PersonalInformation.java:53) 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.apache.commons.beanutils.PropertyUtils.getSimpleProperty(PropertyUtils.java:1185) at org.apache.commons.beanutils.PropertyUtils.getNestedProperty(PropertyUtils.java:772) at org.apache.commons.beanutils.BeanUtils.getNestedProperty(BeanUtils.java:695) at org.apache.commons.beanutils.BeanUtils.getProperty(BeanUtils.java:720) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.getStringContentOfAttribute(XmlLuceneDocumentFactory.java:78) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.createDocumentForObjectFromClassConfiguration(XmlLuceneDocumentFactory.java:44) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.createDocument(XmlLuceneDocumentFactory.java:27) at com.atlassian.confluence.search.lucene.LuceneIndexer.index(LuceneIndexer.java:62) at com.atlassian.confluence.importexport.impl.BackupImporter.importEntities(BackupImporter.java:184) at com.atlassian.confluence.importexport.impl.BackupImporter.doImport(BackupImporter.java:95) at com.atlassian.confluence.importexport.DefaultImportExportManager.importAs(DefaultImportExportManager.java:40) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:153) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy21.importAs(Unknown Source) at com.atlassian.confluence.importexport.actions.RestoreAction.doRestore(RestoreAction.java:23) at com.atlassian.confluence.importexport.actions.AbstractImportAction.execute(AbstractImportAction.java:44) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:173) at com.atlassian.confluence.setup.actions.SetupCheckInterceptor.intercept(SetupCheckInterceptor.java:27) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:58) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:32) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:18) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:182) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:162) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:36) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:84) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:95) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:83) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:39) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) 2004-02-06 13:48:30,687 ERROR [sf.hibernate.impl.SessionImpl] Could not synchronize database state with session net.sf.hibernate.JDBCException: could not insert: [com.atlassian.confluence.spaces.SpaceDescription#0] at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:479) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:443) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2326) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2279) at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1747) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1508) at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1532) at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:27) at com.atlassian.confluence.user.persistence.dao.hibernate.ConfluenceUserDAO$1.doInHibernate(ConfluenceUserDAO.java:86) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:147) at com.atlassian.confluence.user.persistence.dao.hibernate.ConfluenceUserDAO.findUserByUsername(ConfluenceUserDAO.java:77) at com.opensymphony.user.provider.hibernate.HibernateCredentialsProvider.handles(HibernateCredentialsProvider.java:83) at com.atlassian.confluence.user.providers.ConfluenceCredentialsProvider.handles(ConfluenceCredentialsProvider.java:47) at com.opensymphony.user.UserManager.getProvider(UserManager.java:310) at com.opensymphony.user.UserManager.getEntity(UserManager.java:296) at com.opensymphony.user.UserManager.getUser(UserManager.java:190) at com.atlassian.confluence.user.DefaultUserAccessor.getUser(DefaultUserAccessor.java:94) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:17) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy5.getUser(Unknown Source) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:153) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy6.getUser(Unknown Source) at com.atlassian.confluence.user.PersonalInformation.getFullName(PersonalInformation.java:53) 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.apache.commons.beanutils.PropertyUtils.getSimpleProperty(PropertyUtils.java:1185) at org.apache.commons.beanutils.PropertyUtils.getNestedProperty(PropertyUtils.java:772) at org.apache.commons.beanutils.BeanUtils.getNestedProperty(BeanUtils.java:695) at org.apache.commons.beanutils.BeanUtils.getProperty(BeanUtils.java:720) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.getStringContentOfAttribute(XmlLuceneDocumentFactory.java:78) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.createDocumentForObjectFromClassConfiguration(XmlLuceneDocumentFactory.java:44) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.createDocument(XmlLuceneDocumentFactory.java:27) at com.atlassian.confluence.search.lucene.LuceneIndexer.index(LuceneIndexer.java:62) at com.atlassian.confluence.importexport.impl.BackupImporter.importEntities(BackupImporter.java:184) at com.atlassian.confluence.importexport.impl.BackupImporter.doImport(BackupImporter.java:95) at com.atlassian.confluence.importexport.DefaultImportExportManager.importAs(DefaultImportExportManager.java:40) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:153) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy21.importAs(Unknown Source) at com.atlassian.confluence.importexport.actions.RestoreAction.doRestore(RestoreAction.java:23) at com.atlassian.confluence.importexport.actions.AbstractImportAction.execute(AbstractImportAction.java:44) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:173) at com.atlassian.confluence.setup.actions.SetupCheckInterceptor.intercept(SetupCheckInterceptor.java:27) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:58) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:32) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:18) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:182) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:162) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:36) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:84) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:95) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:83) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:39) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:469) ... 120 more 2004-02-06 13:48:30,703 WARN [springframework.jdbc.support.SQLStateSQLExceptionTranslator] Translating SQLException with SQLState '23000' and errorCode '-9' and message [Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)]]; SQL was [null] for task [HibernateAccessor] 2004-02-06 13:48:30,703 WARN [springframework.jdbc.support.SQLStateSQLExceptionTranslator] Translating SQLException with SQLState '23000' and errorCode '-9' and message [Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)]]; SQL was [null] for task [HibernateAccessor] 2004-02-06 13:48:30,703 ERROR [springframework.transaction.interceptor.TransactionInterceptor] Invoking rollback for transaction on method 'getUser' due to throwable [org.springframework.dao.DataIntegrityViolationException: (HibernateAccessor): data integrity violated by SQL 'null'; nested exception is: java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)]] 2004-02-06 13:48:30,703 ERROR [springframework.transaction.interceptor.TransactionInterceptor] Invoking rollback for transaction on method 'getUser' due to throwable [org.springframework.dao.DataIntegrityViolationException: (HibernateAccessor): data integrity violated by SQL 'null'; nested exception is: java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)]] 2004-02-06 13:48:30,703 ERROR [confluence.importexport.impl.BackupImporter] Can not import the entities! com.atlassian.confluence.search.lucene.LuceneException: Couldn't get string content of attribute, attributeName=fullName at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.getStringContentOfAttribute(XmlLuceneDocumentFactory.java:84) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.createDocumentForObjectFromClassConfiguration(XmlLuceneDocumentFactory.java:44) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.createDocument(XmlLuceneDocumentFactory.java:27) at com.atlassian.confluence.search.lucene.LuceneIndexer.index(LuceneIndexer.java:62) at com.atlassian.confluence.importexport.impl.BackupImporter.importEntities(BackupImporter.java:184) at com.atlassian.confluence.importexport.impl.BackupImporter.doImport(BackupImporter.java:95) at com.atlassian.confluence.importexport.DefaultImportExportManager.importAs(DefaultImportExportManager.java:40) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:153) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy21.importAs(Unknown Source) at com.atlassian.confluence.importexport.actions.RestoreAction.doRestore(RestoreAction.java:23) at com.atlassian.confluence.importexport.actions.AbstractImportAction.execute(AbstractImportAction.java:44) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:173) at com.atlassian.confluence.setup.actions.SetupCheckInterceptor.intercept(SetupCheckInterceptor.java:27) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:58) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:32) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:18) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:182) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:162) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:36) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:84) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:95) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:83) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:39) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) 2004-02-06 13:48:30,718 ERROR [opensymphony.webwork.dispatcher.ServletDispatcher] Could not execute action com.atlassian.confluence.importexport.ImportExportException: com.atlassian.confluence.search.lucene.LuceneException: Couldn't get string content of attribute, attributeName=fullName at com.atlassian.confluence.importexport.impl.BackupImporter.importEntities(BackupImporter.java:193) at com.atlassian.confluence.importexport.impl.BackupImporter.doImport(BackupImporter.java:95) at com.atlassian.confluence.importexport.DefaultImportExportManager.importAs(DefaultImportExportManager.java:40) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:153) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy21.importAs(Unknown Source) at com.atlassian.confluence.importexport.actions.RestoreAction.doRestore(RestoreAction.java:23) at com.atlassian.confluence.importexport.actions.AbstractImportAction.execute(AbstractImportAction.java:44) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:173) at com.atlassian.confluence.setup.actions.SetupCheckInterceptor.intercept(SetupCheckInterceptor.java:27) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:58) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:32) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:18) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:182) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:162) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:36) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:84) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:95) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:83) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:39) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) Caused by: com.atlassian.confluence.search.lucene.LuceneException: Couldn't get string content of attribute, attributeName=fullName at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.getStringContentOfAttribute(XmlLuceneDocumentFactory.java:84) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.createDocumentForObjectFromClassConfiguration(XmlLuceneDocumentFactory.java:44) at com.atlassian.confluence.search.lucene.mapping.XmlLuceneDocumentFactory.createDocument(XmlLuceneDocumentFactory.java:27) at com.atlassian.confluence.search.lucene.LuceneIndexer.index(LuceneIndexer.java:62) at com.atlassian.confluence.importexport.impl.BackupImporter.importEntities(BackupImporter.java:184) ... 67 more 2004-02-06 13:48:34,390 WARN [sf.hibernate.util.JDBCExceptionReporter] SQL Error: -9, SQLState: 23000 2004-02-06 13:48:34,390 ERROR [sf.hibernate.util.JDBCExceptionReporter] Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)] 2004-02-06 13:48:34,390 ERROR [sf.hibernate.util.JDBCExceptionReporter] could not insert: [com.atlassian.confluence.spaces.SpaceDescription#0] java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:469) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:443) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2326) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2279) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2180) at com.atlassian.confluence.setup.SpringSessionInViewFilter.closeSession(SpringSessionInViewFilter.java:42) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:88) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:39) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) 2004-02-06 13:48:34,390 ERROR [sf.hibernate.impl.SessionImpl] Could not synchronize database state with session net.sf.hibernate.JDBCException: could not insert: [com.atlassian.confluence.spaces.SpaceDescription#0] at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:479) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:443) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2326) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2279) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2180) at com.atlassian.confluence.setup.SpringSessionInViewFilter.closeSession(SpringSessionInViewFilter.java:42) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:88) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:39) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:469) ... 20 more
    via by Armond Avanes,
  • Cause: org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3] Stack Trace: [hide] org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3] java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:598) at net.sf.hibernate.impl.ScheduledDeletion.execute(ScheduledDeletion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2382) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2340) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2204) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
    via by Dave Loeng [Atlassian],
  • Report from Turadg Aleahmad <turadg@berkeley.edu> I tried deleting a template named Person. From the referrer URL you see the pageTemplateId=1. The Confluence location bar read: Location: Dashboard <http://confluence.example.org:48080/dashboard.action> > Templates <http://confluence.example.org:48080/pages/templates/listpagetemplates.action> > Person <http://confluence.example.org:48080/pages/templates/viewpagetemplate.action?pageTemplateId=1> > Remove But the "Name:" was blank. Are you sure you want to delete this template? Name: When I clicked "Remove" I got this... CONFLUENCE <http://confluence.example.org:48080/> System Error A system error has occurred. If this problem persists - please notify your Confluence administrator of this problem. If you experience problems getting to this support page, please send an email to confluence-support@atlassian.com <mailto:confluence-support@atlassian.com> with the following information: 1. a description of your problem 2. cut & paste the error and system information found below 3. attach the application server log file *Cause:* org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is: java.sql.SQLException: Integrity constraint violation: FKBC7CE96A17D4A070 table: PAGETEMPLATES in statement [delete from PAGETEMPLATES where TEMPLATEID=1] *Stack Trace:* [hide] org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is: java.sql.SQLException: Integrity constraint violation: FKBC7CE96A17D4A070 table: PAGETEMPLATES in statement [delete from PAGETEMPLATES where TEMPLATEID=1] java.sql.SQLException: Integrity constraint violation: FKBC7CE96A17D4A070 table: PAGETEMPLATES in statement [delete from PAGETEMPLATES where TEMPLATEID=1] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:582) at net.sf.hibernate.impl.ScheduledDeletion.execute(ScheduledDeletion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2326) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2284) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2180) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:309) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:218) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:172) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy21.removePageTemplate(Unknown Source) at com.atlassian.confluence.pages.templates.actions.RemovePageTemplateAction.doRemove(RemovePageTemplateAction.java:22) 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 com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:309) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:175) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:58) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:32) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:18) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:182) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:162) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:36) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:161) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:83) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:39) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:148) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:534) *Referer URL:* http://confluence.example.org:48080/pages/templates/removepagetemplate.action?pageTemplateId=1 *System Information:* System Date: Friday, 23 Jan 2004 System Time: 21:29:39 Java Version: 1.4.2_03 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_03-b02 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: root User Timezone: America/Los_Angeles Operating System: Linux 2.4.21-9.EL OS Architecture: i386 Total Memory: 127 MB Free Memory: 32 MB Used Memory: 95 MB Uptime: 1 day, 2 hours, 37 minutes, 13 seconds Version: 1.0b3 Build Number: 32
    via by Charles Miller,
  • create EntityBean with CMR fails
    via by 843830,
  • When importing a space I get the error below and subsequently nobody can log in so a full restore has to be done. Cause: org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENT_STATUS, CONTENTTYPE, CONTENTID) values (NULL, NULL, 'This space contains information about Rivermine products including functional roadmaps, requirements and release information', 1, 'stuart', '2004-11-11 19:10:24.0', 'stuart', '2004-11-11 19:10:24.0', NULL, 'current', 'SPACEDESCRIPTION', 6600)] Stack Trace: [hide] org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENT_STATUS, CONTENTTYPE, CONTENTID) values (NULL, NULL, 'This space contains information about Rivermine products including functional roadmaps, requirements and release information', 1, 'stuart', '2004-11-11 19:10:24.0', 'stuart', '2004-11-11 19:10:24.0', NULL, 'current', 'SPACEDESCRIPTION', 6600)] java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENT_STATUS, CONTENTTYPE, CONTENTID) values (NULL, NULL, 'This space contains information about Rivermine products including functional roadmaps, requirements and release information', 1, 'stuart', '2004-11-11 19:10:24.0', 'stuart', '2004-11-11 19:10:24.0', NULL, 'current', 'SPACEDESCRIPTION', 6600)] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at com.mchange.v2.sql.filter.FilterCallableStatement.executeUpdate(FilterCallableStatement.java:309) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:468) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:373) at com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:181) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:73) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:133) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:229) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:158) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170) at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.core.filters.gzip.GzipFilter.doFilter(GzipFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:324) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:395) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:673) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:615) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:786) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) Referer URL: http://leadiant.com/confluence/admin/backup.action Build Information: Uptime: 10 , 37 Version: 1.4-DR3 Build Number: 114 Server Information: Application Server: Apache Tomcat/4.1.30 Servlet Version: 2.3 Database Dialect: N/A Memory Information: Total Memory: 148 MB Free Memory: 43 MB Used Memory: 105 MB System Information: System Date: Wednesday, 02 Feb 2005 System Time: 08:42:48 System Favourite Colour: Lime Java Version: 1.4.2_05 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_05-b04 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: stuart User Timezone: US/Central Operating System: Linux 2.4.20-31.9SB OS Architecture: i386 Request Information: URL: http://leadiant.com/confluence/admin/restore.action - Scheme: http - Server: leadiant.com - Port: 80 - URI: /confluence/500page.jsp - - Context Path: /confluence - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: null Attributes: - javax.servlet.error.exception : java.lang.IllegalStateException: ClobStringType requires active transaction synchronization - javax.servlet.error.message : - os_securityfilter_already_filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - __sitemesh__using_stream : false - javax.servlet.error.request_uri : /confluence/admin/restore.action - javax.servlet.error.status_code : 500 - __sitemesh__filterapplied : true - javax.servlet.error.servlet_name : action - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@1f7886 - loginfilter.already.filtered : true - atlassian.core.seraph.original.url : /admin/restore.action - javax.servlet.jsp.jspException : org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENT_STATUS, CONTENTTYPE, CONTENTID) values (NULL, NULL, 'This space contains information about Rivermine products including functional roadmaps, requirements and release information', 1, 'stuart', '2004-11-11 19:10:24.0', 'stuart', '2004-11-11 19:10:24.0', NULL, 'current', 'SPACEDESCRIPTION', 6600)] - sessioninview.FILTERED : true - com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true Parameters: Logging: 0 log statements generated by this request.
    via by Stuart Donovan,
  • JBoss Community / Mailing Lists
    via by Unknown author,
    • java.sql.SQLException: Integrity constraint violation: FK932472461E2E76DB table: OS_GROUP in statement [insert into os_user_group (user_id, group_id) values (6, 4)] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1075) at net.sf.hibernate.impl.ScheduledCollectionRecreate.execute(ScheduledCollectionRecreate.java:23) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2326) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2283) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2180) at org.springframework.orm.hibernate.SessionFactoryUtils$SessionSynchronization.beforeCommit(SessionFactoryUtils.java:217) at org.springframework.transaction.support.TransactionSynchronizationManager.triggerBeforeCommit(TransactionSynchronizationManager.java:172) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:213) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:172) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy21.exportAs(Unknown Source) at com.atlassian.confluence.importexport.actions.BackupAction.execute(BackupAction.java:29)

    Users with the same issue

    Unknown visitor1 times, last one,