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

Deleting Justin's space on the extranet results in a hibernate exception

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Medium
    • None
    • 2.3
    • None
    • Atlassian extranet.

    Description

      org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Batch entry 1 delete from CONTENT where CONTENTID=69518087748074334 was aborted. Call getNextException to see the cause.
      java.sql.BatchUpdateException: Batch entry 1 delete from CONTENT where CONTENTID=69518087748074334 was aborted. Call getNextException to see the cause.
      at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2497)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1298)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:347)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2559)
      at com.caucho.sql.UserStatement.executeBatch(UserStatement.java:213)
      at com.caucho.sql.UserStatement.executeBatch(UserStatement.java:213)
      at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
      at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128)
      at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2397)
      at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1821)
      at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1578)
      at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543)
      at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
      at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernateBlogPostDao$1.doInHibernate(HibernateBlogPostDao.java:99)
      at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:312)
      at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:289)
      at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernateBlogPostDao.getBlogPosts(HibernateBlogPostDao.java:85)
      at com.atlassian.confluence.pages.DefaultPageManager.getBlogPosts(DefaultPageManager.java:64)
      at com.atlassian.confluence.pages.DefaultPageManager.removeAllBlogPosts(DefaultPageManager.java:210)
      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.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
      at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:20)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
      at $Proxy15.removeAllBlogPosts(Unknown Source)
      at com.atlassian.confluence.spaces.DefaultSpaceManager.removeSpace(DefaultSpaceManager.java:123)
      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.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
      at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:20)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
      at $Proxy21.removeSpace(Unknown Source)
      at com.atlassian.confluence.spaces.actions.RemoveSpaceAction.doRemove(RemoveSpaceAction.java:17)
      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:302)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170)
      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:39)
      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:47)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:114)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:67)
      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.actions.LastModifiedInterceptor.intercept(LastModifiedInterceptor.java:39)
      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.xwork.interceptors.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:98)
      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:92)
      at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:99)
      at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
      at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:137)
      at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.core.filters.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:21)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:44)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:177)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:35)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:172)
      at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:122)
      at com.atlassian.core.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.core.filters.gzip.GzipFilter.doFilter(GzipFilter.java:61)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:188)
      at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:163)
      at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:208)
      at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:396)
      at com.caucho.server.port.TcpConnection.run(TcpConnection.java:363)
      at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:490)
      at com.caucho.util.ThreadPool.run(ThreadPool.java:423)
      at java.lang.Thread.run(Thread.java:534)
      caused by:
      org.postgresql.util.PSQLException: ERROR: update or delete on "content" violates foreign key constraint "fk9eb4c0e037e35a2e" on "ancestors"
      Detail: Key (contentid)=(69518087748074334) is still referenced from table "ancestors".
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:347)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2559)
      at com.caucho.sql.UserStatement.executeBatch(UserStatement.java:213)
      at com.caucho.sql.UserStatement.executeBatch(UserStatement.java:213)
      at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
      at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128)
      at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2397)
      at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1821)
      at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1578)
      at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543)
      at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
      at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernateBlogPostDao$1.doInHibernate(HibernateBlogPostDao.java:99)
      at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:312)
      at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:289)
      at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernateBlogPostDao.getBlogPosts(HibernateBlogPostDao.java:85)
      at com.atlassian.confluence.pages.DefaultPageManager.getBlogPosts(DefaultPageManager.java:64)
      at com.atlassian.confluence.pages.DefaultPageManager.removeAllBlogPosts(DefaultPageManager.java:210)
      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.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
      at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:20)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
      at $Proxy15.removeAllBlogPosts(Unknown Source)
      at com.atlassian.confluence.spaces.DefaultSpaceManager.removeSpace(DefaultSpaceManager.java:123)
      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.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
      at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:20)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
      at $Proxy21.removeSpace(Unknown Source)
      at com.atlassian.confluence.spaces.actions.RemoveSpaceAction.doRemove(RemoveSpaceAction.java:17)
      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:302)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170)
      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:39)
      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:47)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:114)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:67)
      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.actions.LastModifiedInterceptor.intercept(LastModifiedInterceptor.java:39)
      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.xwork.interceptors.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:98)
      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:92)
      at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:99)
      at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
      at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:137)
      at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.core.filters.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:21)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:44)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:177)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:35)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:172)
      at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:122)
      at com.atlassian.core.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.core.filters.gzip.GzipFilter.doFilter(GzipFilter.java:61)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37)
      at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:188)
      at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:163)
      at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:208)
      at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:396)
      at com.caucho.server.port.TcpConnection.run(TcpConnection.java:363)
      at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:490)
      at com.caucho.util.ThreadPool.run(ThreadPool.java:423)
      at java.lang.Thread.run(Thread.java:534)

      Referer URL: http://extranet.atlassian.com/spaces/removespace.action?key=justin

      Build Information:
      Confluence Home: /opt/j2ee/domains/atlassian.com/extranet/root/webapps/atlassian-confluence/data
      Uptime: 16 minutes, 3 seconds
      Version: 2.3-dev
      Build Number: 610

      Server Information:
      Application Server: Resin/3.0.14
      Servlet Version: 2.4
      Database Dialect: net.sf.hibernate.dialect.PostgreSQLDialect
      Database Driver Name: N/A
      Database Driver Version: N/A

      Memory Information:
      Total Memory: 254 MB
      Free Memory: 136 MB
      Used Memory: 118 MB

      System Information:
      System Date: Monday, 10 Jul 2006
      System Time: 20:47:28
      System Favourite Colour: Viridian
      Java Version: 1.4.2_10
      Java Vendor: Sun Microsystems Inc.
      JVM Version: 1.0
      JVM Vendor: Sun Microsystems Inc.
      JVM Implementation Version: 1.4.2_10-b03
      Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition
      Java VM: Java HotSpot(TM) Client VM
      User Name: j2ee
      User Timezone: America/Chicago
      Operating System: Linux 2.6.9-34.0.1.ELsmp
      OS Architecture: i386
      Filesystem Encoding: ANSI_X3.4-1968

      Enabled Plugins:
      Page Tabs (confluence.sections.page, Version: 1.0)
      Basic Macros (confluence.macros.basic, Version: 1.3)
      Core Listeners (confluence.listeners.core, Version: 1.3)
      Dashboard Macros (confluence.macros.dashboard, Version: 1.3)
      Confluence Usage Stats (com.atlassian.confluence.ext.usage, Version: 0.2.5)
      Chart Plugin (confluence.extra.chart, Version: 1.5)
      User Listener (confluence.extra.userlister, Version: 1.2)
      Live Search Macros (confluence.extra.livesearch, Version: 1.3)
      Information Macros (confluence.extra.information, Version: 0.1)
      Global Labels Sections (confluence.sections.labels, Version: 1.0)
      JIRA Macros (confluence.extra.jira, Version: 1.4)
      Clickr Theme (com.atlassian.confluence.themes.clickr, Version: 1.0)
      Layout Macros (confluence.extra.layout, Version: 0.1)
      Confluence Remote API (confluence.extra.confluencerpc, Version: 1.4)
      Profile Tabs (confluence.sections.profile, Version: 1.0)
      Admin Sections (confluence.sections.admin, Version: 1.0)
      Tabular Metadata (confluence.extra.masterdetail, Version: 1.0)
      Space Admin Sections (confluence.sections.space.admin, Version: 1.0)
      Space Pages Sections (confluence.sections.space.pages, Version: 1.0)
      Find Email (com.atlassian.confluence.extra, Version: 1.0)
      Calendar Plugin (confluence.extra.calendar, Version: 2.1.7)
      YourKit Profiling Plugin (com.atlassian.confluence.ext.yourkit, Version: 0.1)
      Advanced Macros (confluence.macros.advanced, Version: 1.3)
      Space Advanced Sections (confluence.sections.space.advanced, Version: 1.0)
      News Tabs (confluence.sections.news, Version: 1.0)
      Confluence Repository Client (confluence.repository.client, Version: 1.2.1)
      Attachments Macros (confluence.extra.attachments, Version: 1.3)
      IM Presence Macros (confluence.extra.impresence, Version: 0.1)
      Edit Profile Sections (confluence.sections.profile.edit, Version: 1.0)
      Sudoku Game (com.adaptavist.confluence.games.sudoku, Version: 1.3.1)
      Content Formatting Macros (com.adaptavist.confluence.contentFormattingMacros, Version: 1.4.1)
      Space Actions Sections (confluence.sections.space.actions, Version: 1.0)
      Task List Macros (confluence.extra.tasklist, Version: 1.3)
      New Code Macro (confluence.ext.code, Version: 1.0.2)
      Space Labels Sections (confluence.sections.space.labels, Version: 1.0)
      Attachment Extractors (confluence.extractors.attachments, Version: 1.4)
      Left Navigation Theme (com.atlassian.confluence.themes.leftnavigation, Version: 1.0)
      Dynamic Task List Macros (confluence.extra.dynamictasklist, Version: 1.3)
      Core Extractors (confluence.extractors.core, Version: 1.4)
      Compatibility Macros (confluence.macros.compatibility, Version: 1.3)
      Space Item Tabs (confluence.sections.space, Version: 1.0)
      Request

      Information:
      URL: http://extranet.atlassian.com/500page.jsp

      • Scheme: http
      • Server: extranet.atlassian.com
      • Port: 80
      • URI: /500page.jsp
      • - Context Path:
      • - Servlet Path: /500page.jsp
      • - Path Info: null
      • - Query String: null

      Attributes:

      • webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@120ad65
      • javax.servlet.error.message : (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Batch entry 1 delete from CONTENT where CONTENTID=69518087748074334 was aborted. Call getNextException to see the cause.
      • sessioninview.FILTERED : true
      • com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true
      • javax.servlet.error.exception : org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Batch entry 1 delete from CONTENT where CONTENTID=69518087748074334 was aborted. Call getNextException to see the cause.
      • javax.servlet.forward.servlet_path : /spaces/doremovespace.action
      • os_securityfilter_already_filtered : true
      • caucho.forward : true
      • com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true
      • javax.servlet.error.servlet_name : action
      • javax.servlet.jsp.jspException : org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Batch entry 1 delete from CONTENT where CONTENTID=69518087748074334 was aborted. Call getNextException to see the cause.
      • _sitemesh_filterapplied : true
      • javax.servlet.forward.request_uri : /spaces/doremovespace.action
      • javax.servlet.error.status_code : 500
      • javax.servlet.forward.query_string : key=justin
      • javax.servlet.error.request_uri : /spaces/doremovespace.action
      • atlassian.core.seraph.original.url : /spaces/doremovespace.action?key=justin
      • loginfilter.already.filtered : true
      • javax.servlet.forward.context_path :

      Parameters:

      • confirm = OK
      • key = justin
        Confluence User:
      • justin

      Logging:
      7 log statements generated by this request:
      [ERROR] Mon Jul 10 20:47:28 CDT 2006 [net.sf.hibernate.util.JDBCExceptionReporter] Batch entry 1 delete from CONTENT where CONTENTID=69518087748074334 was aborted. Call getNextException to see the cause.
      [ERROR] Mon Jul 10 20:47:28 CDT 2006 [net.sf.hibernate.util.JDBCExceptionReporter] ERROR: update or delete on "content" violates foreign key constraint "fk9eb4c0e037e35a2e" on "ancestors" Detail: Key (contentid)=(69518087748074334) is still referenced from table "ancestors".
      [ERROR] Mon Jul 10 20:47:28 CDT 2006 [net.sf.hibernate.util.JDBCExceptionReporter] Batch entry 1 delete from CONTENT where CONTENTID=69518087748074334 was aborted. Call getNextException to see the cause.
      [ERROR] Mon Jul 10 20:47:28 CDT 2006 [net.sf.hibernate.util.JDBCExceptionReporter] ERROR: update or delete on "content" violates foreign key constraint "fk9eb4c0e037e35a2e" on "ancestors" Detail: Key (contentid)=(69518087748074334) is still referenced from table "ancestors".
      [ERROR] Mon Jul 10 20:47:28 CDT 2006 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session
      [ERROR] Mon Jul 10 20:47:28 CDT 2006 [com.atlassian.xwork.interceptors.XWorkTransactionInterceptor] Invoking rollback for transaction on action '/spaces/doremovespace.action (RemoveSpaceAction.doRemove())' due to throwable: org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Batch entry 1 delete from CONTENT where CONTENTID=69518087748074334 was aborted. Call getNextException to see the cause.
      Throwable:
      org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Batch entry 1 delete from CONTENT where CONTENTID=69518087748074334 was aborted. Call getNextException to see the cause.
      java.sql.BatchUpdateException: Batch entry 1 delete from CONTENT where CONTENTID=69518087748074334 was aborted. Call getNextException to see the cause.
      at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2497)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1298)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:347)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2559)
      at com.caucho.sql.UserStatement.executeBatch(UserStatement.java:213)
      at com.caucho.sql.UserStatement.executeBatch(UserStatement.java:213)
      at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
      at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128)
      at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2397)
      at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1821)
      at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1578)
      at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543)
      at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
      at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernateBlogPostDao$1.doInHibernate(HibernateBlogPostDao.java:99)
      at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:312)
      at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:289)
      at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernateBlogPostDao.getBlogPosts(HibernateBlogPostDao.java:85)
      [ERROR] Mon Jul 10 20:47:28 CDT 2006 [com.opensymphony.webwork.dispatcher.ServletDispatcher] Could not execute action
      Throwable:
      org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Batch entry 1 delete from CONTENT where CONTENTID=69518087748074334 was aborted. Call getNextException to see the cause.
      java.sql.BatchUpdateException: Batch entry 1 delete from CONTENT where CONTENTID=69518087748074334 was aborted. Call getNextException to see the cause.
      at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2497)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1298)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:347)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2559)
      at com.caucho.sql.UserStatement.executeBatch(UserStatement.java:213)
      at com.caucho.sql.UserStatement.executeBatch(UserStatement.java:213)
      at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
      at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128)
      at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2397)
      at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1821)
      at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1578)
      at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543)
      at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
      at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernateBlogPostDao$1.doInHibernate(HibernateBlogPostDao.java:99)
      at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:312)
      at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:289)
      at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernateBlogPostDao.getBlogPosts(HibernateBlogPostDao.java:85)

      Attachments

        Activity

          People

            Unassigned Unassigned
            justin@atlassian.com Justin Koke
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: