When I try to purge the trash in the JIRA Studio documentation space I get a DataIntegrityViolationException error.

Cause:

org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not delete: com.atlassian.confluence.pages.Attachment#209027171; SQL []; ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails" Detail: Key (attachmentid)=(209027171) is still referenced from table "imagedetails".; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails" Detail: Key (attachmentid)=(209027171) is still referenced from table "imagedetails".
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:110)

caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails" Detail: Key (attachmentid)=(209027171) is still referenced from table "imagedetails".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
Stack Trace:[hide]

org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not delete: com.atlassian.confluence.pages.Attachment#209027171; SQL []; ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails"
Detail: Key (attachmentid)=(209027171) is still referenced from table "imagedetails".; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails"
Detail: Key (attachmentid)=(209027171) is still referenced from table "imagedetails".
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails"
Detail: Key (attachmentid)=(209027171) is still referenced from table "imagedetails".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:581)
at net.sf.hibernate.impl.ScheduledDeletion.execute(ScheduledDeletion.java:29)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2397)
at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1821)
at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3863)
at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52)
at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao$5.doInHibernate(HibernatePageDao.java:543)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)
at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:341)
at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getDescendents(HibernatePageDao.java:533)
at com.atlassian.confluence.pages.persistence.dao.hibernate.CachingPageDao.getDescendents(CachingPageDao.java:201)
at com.atlassian.confluence.pages.DefaultPageManager.getDescendents(DefaultPageManager.java:165)
at com.atlassian.confluence.pages.DefaultPageManager.removePageFromAncestorCollections(DefaultPageManager.java:199)
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:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy34.removePageFromAncestorCollections(Unknown Source)
at com.atlassian.confluence.pages.Page.remove(Page.java:204)
at com.atlassian.confluence.pages.DefaultTrashManager.emptyTrash(DefaultTrashManager.java:31)
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:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy72.emptyTrash(Unknown Source)
at com.atlassian.confluence.pages.actions.EmptyTrashAction.execute(EmptyTrashAction.java:12)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
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: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.XsrfTokenInterceptor.intercept(XsrfTokenInterceptor.java:100)
at com.atlassian.confluence.xwork.ConfluenceXsrfTokenInterceptor.intercept(ConfluenceXsrfTokenInterceptor.java:18)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.security.interceptors.CaptchaInterceptor.intercept(CaptchaInterceptor.java:46)
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.LoggingContextInterceptor.intercept(LoggingContextInterceptor.java:49)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.core.CancellingInterceptor.intercept(CancellingInterceptor.java:23)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:57)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.setup.webwork.BootstrapAwareInterceptor.intercept(BootstrapAwareInterceptor.java:26)
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.user.actions.UserAwareInterceptor.intercept(UserAwareInterceptor.java:58)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.pages.actions.CommentAwareInterceptor.intercept(CommentAwareInterceptor.java:44)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:110)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:68)
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:38)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:38)
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.TransactionalInvocation.invokeAndHandleExceptions(TransactionalInvocation.java:72)
at com.atlassian.xwork.interceptors.TransactionalInvocation.invokeInTransaction(TransactionalInvocation.java:59)
at com.atlassian.xwork.interceptors.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:56)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.xwork.SetupIncompleteInterceptor.intercept(SetupIncompleteInterceptor.java:40)
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.atlassian.confluence.servlet.ConfluenceServletDispatcher.serviceAction(ConfluenceServletDispatcher.java:53)
at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:84)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:54)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.confluence.jmx.JmxFilter.doFilter(JmxFilter.java:106)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.core.filters.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:19)
at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.confluence.util.LoggingContextFilter.doFilter(LoggingContextFilter.java:47)
at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.confluence.web.filter.ThreadLocalCacheFilter.doFilter(ThreadLocalCacheFilter.java:22)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:44)
at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:206)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98)
at com.atlassian.confluence.util.AbstractBootstrapHotSwappingFilter.doFilter(AbstractBootstrapHotSwappingFilter.java:30)
at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:131)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:69)
at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74)
at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:35)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170)
at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.confluence.util.ConfluenceErrorFilter.doFilter(ConfluenceErrorFilter.java:22)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.confluence.core.datetime.RequestTimeThreadLocalFilter.doFilter(RequestTimeThreadLocalFilter.java:34)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.confluence.util.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:25)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:81)
at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33)
at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41)
at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:619)

Referer URL

http://confluence.atlassian.com/pages/emptytrash.action?key=JIRASTUDIO
Confluence Application Information
Build Information

baseUrl: http://confluence.atlassian.com
home: /opt/j2ee/domains/atlassian.com/confluence/webapps/atlassian-confluence/data
buildNumber: 1722
upTime: 2 hours, 59 minutes, 51 seconds
devMode: false
serverId: AG6M-Z7IT-YESJ-8WEX
supportEntitlementNumber: null
version: 3.1
Unique ID: ac83cc99-e23d-4070-bba1-5c646733181c
Server information

Application Server: Apache Tomcat/5.5.26
Servlet Version: 2.4
Database Dialect: net.sf.hibernate.dialect.PostgreSQLDialect
Database Driver Name: null
Memory Information

Maximum Heap: 1784 MB
Allocated Heap: 1784 MB
Used Memory: 885 MB
Unused Allocated Memory: 899 MB
Available Memory: 899 MB

Maximum Permgen: 256 MB
Used Permgen: 105 MB
System Information

favouriteColour: Heliotrope
javaRuntime: Java(TM) SE Runtime Environment
operatingSystem: Linux 2.6.18-128.1.1.el5
jvmVersion: 1.0
fileSystemEncoding: ANSI_X3.4-1968
javaVm: Java HotSpot(TM) Server VM
javaVendor: Sun Microsystems Inc.
jvmImplementationVersion: 14.0-b16
systemTimezone: America/Chicago
appServer: Apache Tomcat
tempDirectory: /opt/j2ee/domains/atlassian.com/confluence/tomcat/temp
date: Sunday, 13 Dec 2009
jvmInputArguments: -Xms1800m -Xmx1800m -Dinstance.id=confluence.atlassian.com -Djava.awt.headless=true -Dconfluence.home=/opt/j2ee/domains/atlassian.com/confluence/webapps/atlassian-confluence/data -XX:MaxPermSize=256m -XX:+HeapDumpOnOutOfMemoryError -XX:+PrintGCDateStamps -Xloggc:/var/log/java/confluence.atlassian.com/gc.log -verbose:gc -Dcom.sun.management.snmp.interface=172.16.3.111 -Dcom.sun.management.snmp.port=10161 -Dcom.sun.management.snmp.acl.file=/service/j2ee_confluence.atlassian.com/user_env/snmp.acl -Dhttp.timeout=120 -Dcom.sun.management.jmxremote.port=1099 -Dcom.sun.management.jmxremote.ssl=false -Dcom.sun.management.jmxremote.authenticate=false -XX:+PrintGCDetails -XX:+PrintTenuringDistribution -XX:+UseParallelGC -XX:+UseParallelOldGC -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=/opt/j2ee/domains/atlassian.com/confluence/tomcat/conf/logging.properties -Djava.endorsed.dirs=/opt/j2ee/domains/atlassian.com/confluence/tomcat/common/endorsed -Dcatalina.base=/opt/j2ee/domains/atlassian.com/confluence/tomcat -Dcatalina.home=/opt/j2ee/domains/atlassian.com/confluence/tomcat -Djava.io.tmpdir=/opt/j2ee/domains/atlassian.com/confluence/tomcat/temp
time: 19:05:36
jvmVendor: Sun Microsystems Inc.
userName: j2ee_confluence.atlassian.com
javaVersion: 1.6.0_14
systemLanguage: en
operatingSystemArchitecture: i386
workingDirectory: /opt/j2ee/domains/atlassian.com/confluence/apache-tomcat-5.5.26
Cluster Information

Not clustered.
Plugins

• Adaptavist Content Formatting Macros (com.adaptavist.confluence.contentFormattingMacros, Version: 1.6.5, Installed: Sep 5, 2007)
• Adaptavist SubSection (com.adaptavist.confluence.subsection, Version: 1.0.5, Installed: Oct 2, 2007)
• Add Content Menu Sections (confluence.menu.add, Version: 1.0, Installed: bundled)
• Admin Sections (confluence.sections.admin, Version: 1.0, Installed: bundled)
• Advanced Macros (confluence.macros.advanced, Version: 1.6.8, Installed: Nov 24, 2008)
• Apache HttpClient OSGi bundle (org.apache.httpcomponents.httpclient-4.0, Version: 4.0, Installed: bundled)
• Apache HttpCore OSGi bundle (org.apache.httpcomponents.httpcore-4.0, Version: 4.0, Installed: bundled)
• Atlassian Gadgets API (com.atlassian.gadgets.atlassian-gadgets-api-2.0.2, Version: 2.0.2, Installed: bundled)
• Atlassian Gadgets OAuth Service Provider Plugin (com.atlassian.gadgets.oauth.serviceprovider, Version: 2.0.2, Installed: bundled)
• Atlassian Gadgets SPI (com.atlassian.gadgets.atlassian-gadgets-spi-2.0.2, Version: 2.0.2, Installed: bundled)
• Atlassian OAuth API (com.atlassian.oauth.atlassian-oauth-api-1.0.12, Version: 1.0.12, Installed: bundled)
• Atlassian OAuth Admin Plugin (com.atlassian.oauth.admin, Version: 1.0.12, Installed: bundled)
• Atlassian OAuth Consumer Plugin (com.atlassian.oauth.consumer, Version: 1.0.12, Installed: bundled)
• Atlassian OAuth Consumer SAL SPI Implementation (com.atlassian.oauth.consumer.sal, Version: 1.0.12, Installed: bundled)
• Atlassian OAuth Consumer SPI (com.atlassian.oauth.atlassian-oauth-consumer-spi-1.0.12, Version: 1.0.12, Installed: bundled)
• Atlassian OAuth Service Provider Plugin (com.atlassian.oauth.serviceprovider, Version: 1.0.12, Installed: bundled)
• Atlassian OAuth Service Provider SAL SPI Implementation (com.atlassian.oauth.serviceprovider.sal, Version: 1.0.12, Installed: bundled)
• Atlassian OAuth Service Provider SPI (com.atlassian.oauth.atlassian-oauth-service-provider-spi-1.0.12, Version: 1.0.12, Installed: bundled)
• Atlassian REST - Module Types (com.atlassian.plugins.rest.atlassian-rest-module, Version: 1.1.0.beta2, Installed: bundled)
• Atlassian Template Renderer API (com.atlassian.templaterenderer.api, Version: 1.0.3, Installed: bundled)
• Atlassian Template Renderer Velocity 1.6 Plugin (com.atlassian.templaterenderer.atlassian-template-renderer-velocity1.6-plugin, Version: 1.0.3, Installed: bundled)
• Atlassian UI Plugin (com.atlassian.auiplugin, Version: 2.0.2.1, Installed: bundled)
• Attachment Actions (confluence.sections.attachments, Version: 1.0, Installed: bundled)
• Attachment Extractors (com.atlassian.confluence.plugins.attachmentExtractors, Version: 1.1, Installed: bundled)
• BND Library (biz.aQute.bndlib-0.0.255, Version: 0.0.255, Installed: bundled)
• Basic Macros (confluence.macros.basic, Version: 1.4, Installed: bundled)
• Browse Menu Items (confluence.sections.browse, Version: 1.0, Installed: bundled)
• Cache Plugin (org.swift.confluence.cache, Version: 3.1.0, Installed: Sep 5, 2007)
• Calendar Plugin (confluence.extra.calendar, Version: 2.5, Installed: Nov 20, 2007)
• Chart Plugin (confluence.extra.chart, Version: 1.15, Installed: Feb 5, 2007)
• Clickr Theme (com.atlassian.confluence.themes.clickr, Version: 2.6, Installed: bundled)
• Collapsable Rss Plugin (com.atlassian.confluence.plugins.collapsablerss, Version: 0.6.2, Installed: Nov 29, 2007)
• Comment Action Sections (confluence.comment.action, Version: 1.0, Installed: bundled)
• Composition Plugin (org.randombits.confluence.composition, Version: 2.2, Installed: Dec 29, 2006)
• Confluence Activity Stream Plugin (com.atlassian.streams.confluence, Version: 3.1, Installed: bundled)
• Confluence Atlassian Plugin Repository (confluence.repository.client, Version: 2.1.6, Installed: Feb 20, 2008)
• Confluence Attachments Plugin (confluence.extra.attachments, Version: 2.17, Installed: bundled)
• Confluence Blogging RPC Plugin (com.atlassian.confluence.plugins.xmlrpc.bloggingrpc, Version: 1.2.4, Installed: Sep 5, 2007)
• Confluence Drag and Drop Plugin (com.atlassian.confluence.plugins.drag-and-drop, Version: 1.0.4, Installed: Dec 1, 2009)
• Confluence HTML Macros (confluence.macros.html, Version: 1.8, Installed: bundled)
• Confluence Legacy Web Resources (legacy.confluence.web.resources, Version: 1.0, Installed: bundled)
• Confluence PDF Export (com.atlassian.confluence.extra.flyingpdf, Version: 1.3, Installed: bundled)
• Confluence REST API (com.atlassian.confluence.restplugin, Version: 3.1, Installed: bundled)
• Confluence Remote API (confluence.extra.confluencerpc, Version: 3.1, Installed: bundled)
• Confluence Spam Reaction Plugin (com.atlassian.confluence.plugins.confluence-spamreaction-plugin, Version: 1.0-SNAPSHOT, Installed: Jan 8, 2009)
• Confluence Thread Dump Plugin (com.atlassian.confluence.plugin.threaddump, Version: 1.2.1, Installed: bundled)
• Content Action Menu Sections (confluence.content.action.menu, Version: 1.0, Installed: bundled)
• Content Buttons (confluence.sections.page.temp, Version: 1.0, Installed: bundled)
• Content Metadata (confluence.sections.content.metadata, Version: 1.0, Installed: bundled)
• Copy Space Plugin (com.atlassian.confluence.plugin.copyspace, Version: 1.0, Installed: Nov 9, 2009)
• Core Extractors (confluence.extractors.core, Version: 1.4, Installed: bundled)
• Core Listeners (confluence.listeners.core, Version: 1.3, Installed: bundled)
• Core Path Converters (confluence.converters.core, Version: 1.0, Installed: bundled)
• Core Startup and Shutdown (confluence.lifecycle.core, Version: 1, Installed: bundled)
• Dashboard Macros (confluence.macros.dashboard, Version: 1.13, Installed: bundled)
• Default Macro Metadata Provider (confluence.macro.metadata.provider, Version: 1.0, Installed: bundled)
• Default Theme (com.atlassian.confluence.themes.default, Version: 1.0, Installed: bundled)
• Did You Mean Index Building Interface (confluence.sections.admin.indexing, Version: 1.0, Installed: bundled)
• Documentation Theme (com.atlassian.confluence.plugins.doctheme, Version: 1.0-beta1, Installed: Nov 30, 2009)
• Dynamic Task List 2 Plugin (confluence.extra.dynamictasklist2, Version: 3.2.5, Installed: Mar 27, 2008)
• Easy Blue Theme (com.atlassian.confluence.ext.theme.easyblue, Version: 1.1, Installed: Nov 23, 2008)
• Edit Settings Sections (confluence.sections.settings.edit, Version: 1.0, Installed: bundled)
• Editor Actions (confluence.editor.actions, Version: 1.0, Installed: bundled)
• EhCache Plugins (confluence.cache.ehcache, Version: 3.0, Installed: bundled)
• Embedded Gadgets Plugin (com.atlassian.gadgets.embedded, Version: 2.0.2, Installed: bundled)
• Excel Plugin (org.swift.confluence.excel, Version: 3.3.0, Installed: Oct 15, 2007)
• Follow list resources (confluence.sections.user.follow.list, Version: 1.0, Installed: bundled)
• French language pack (confluence.languages.fr_FR, Version: 1.18, Installed: bundled)
• Gadget Directory Plugin (com.atlassian.gadgets.directory, Version: 2.0.2, Installed: bundled)
• Gadget Spec Publisher Plugin (com.atlassian.gadgets.publisher, Version: 2.0.2, Installed: bundled)
• Gadgets Plugin (com.atlassian.confluence.plugins.gadgets, Version: 1.0.3, Installed: bundled)
• German language pack (confluence.languages.de_DE, Version: 1.12, Installed: bundled)
• Gliffy Plugin for Confluence (com.gliffy.integration.confluence, Version: 2.0.2-RC2, Installed: Nov 9, 2009)
• Global Dashboard Actions (confluence.sections.dashboard.global, Version: 1.0, Installed: bundled)
• Global Labels Sections (confluence.sections.labels, Version: 1.0, Installed: bundled)
• Global Statistics Plugin (confluence.extra.globalstats, Version: 1.0, Installed: Mar 28, 2007)
• Google Collections Bundle (com.atlassian.bundles.google-collections-1.0.0.rc1, Version: 1.0.0.rc1, Installed: bundled)
• Google Maps (com.atlassian.confluence.ext.gmaps, Version: 0.4.1, Installed: Oct 15, 2007)
• ICU4J (com.atlassian.bundles.icu4j-3.8.0.1, Version: 3.8.0.1, Installed: bundled)
• IM Presence NG Plugin (confluence.extra.impresence2, Version: 2.6, Installed: Apr 18, 2007)
• Information Macros (confluence.extra.information, Version: 1.3, Installed: bundled)
• JDOM DOM Processor (com.springsource.org.jdom-1.0.0, Version: 1.0.0, Installed: bundled)
• JIRA Macros (confluence.extra.jira, Version: 2.8.15, Installed: Oct 15, 2008)
• JSON Library (com.atlassian.bundles.json-20070829.0.0.1, Version: 20070829.0.0.1, Installed: bundled)
• JSR 305 Annotations (com.atlassian.bundles.jsr305-1.0, Version: 1.0, Installed: bundled)
• Java Concurrency in Practice Annotations (com.springsource.net.jcip.annotations-1.0.0, Version: 1.0.0, Installed: bundled)
• Layout Macros (confluence.extra.layout, Version: 1.3, Installed: bundled)
• Left Navigation Theme (com.atlassian.confluence.themes.leftnavigation, Version: 2.9, Installed: bundled)
• Live Search Macros (confluence.extra.livesearch, Version: 2.11, Installed: bundled)
• Lucene Boosting Strategies (confluence.search.lucene.boosting, Version: 1.0, Installed: bundled)
• Metadata Plugin (org.andya.confluence.plugins.metadata, Version: 2.1.0, Installed: Jul 15, 2008)
• New Code Macro Plugin (com.atlassian.confluence.ext.newcode-macro-plugin, Version: 1.9.4, Installed: Sep 16, 2009)
• News Tabs (confluence.sections.news, Version: 1.0, Installed: bundled)
• Office Connector plugin (com.atlassian.confluence.extra.officeconnector, Version: 1.6, Installed: Jan 7, 2009)
• Opensocial Plugin (com.atlassian.gadgets.opensocial, Version: 2.0.2, Installed: bundled)
• Page Operations (confluence.sections.page.operations, Version: 1.0, Installed: bundled)
• Page Tabs (confluence.search.mappers.lucene, Version: 1.0, Installed: bundled)
• Page Tabs (confluence.sections.page, Version: 1.0, Installed: bundled)
• Page Tree (com.atlassian.confluence.plugins.pagetree, Version: 1.13.1, Installed: Jul 15, 2008)
• Page View Links (confluence.sections.page.actions, Version: 1.0, Installed: bundled)
• Profile Macros (confluence.macros.profile, Version: 1.0, Installed: bundled)
• Profile Tabs (confluence.sections.profile, Version: 1.0, Installed: bundled)
• ROME, RSS and atOM utilitiEs for Java (rome.rome-1.0, Version: 1.0, Installed: bundled)
• RSVP Plugin (com.atlassian.confluence.extra.rsvp, Version: 1.6, Installed: Jan 6, 2009)
• Search Web Interface (confluence.sections.admin.generalconfig, Version: 1.0, Installed: bundled)
• Search Web Interface (confluence.sections.search.view, Version: 1.0, Installed: bundled)
• Shared Application Access Layer API (com.atlassian.sal.sal-api-2.0.15, Version: 2.0.15, Installed: bundled)
• Shared Application Access Layer Confluence Plugin (com.atlassian.sal.confluence, Version: 2.0.15, Installed: bundled)
• Slideshow (com.atlassian.confluence.extra.slideshow, Version: 1.0, Installed: Dec 29, 2006)
• Slideshow Plugin (com.atlassian.confluence.ext.slideshow, Version: 0.3, Installed: Apr 18, 2007)
• Snippet Plugin (com.atlassian.confluence.extra.snippet, Version: 2.1.2, Installed: Sep 21, 2009)
• Social Bookmarking Plugin (com.atlassian.confluence.plugins.socialbookmarking, Version: 1.3.1, Installed: bundled)
• Space Actions Sections (confluence.sections.space.actions, Version: 1.0, Installed: bundled)
• Space Admin Sections (confluence.sections.space.admin, Version: 1.0, Installed: bundled)
• Space Advanced Sections (confluence.sections.space.advanced, Version: 1.0, Installed: bundled)
• Space Browse Sections (confluence.sections.space.browse, Version: 1.0, Installed: bundled)
• Space Cleaner (confluence.extra.spacecleaner, Version: 1.1, Installed: Feb 10, 2008)
• Space Export Web Interface (confluence.sections.space.export.view, Version: 1.0, Installed: bundled)
• Space Item Tabs (confluence.sections.space, Version: 1.0, Installed: bundled)
• Space Labels Sections (confluence.sections.space.labels, Version: 1.0, Installed: bundled)
• Space Pages Sections (confluence.sections.space.pages, Version: 1.0, Installed: bundled)
• System Web Resources (confluence.web.resources, Version: 1.0, Installed: bundled)
• Table Plugin (org.swift.confluence.table, Version: 3.3.1, Installed: Sep 5, 2007)
• Table of Contents Plugin (org.randombits.confluence.toc, Version: 2.4.11, Installed: Apr 8, 2008)
• Tabular Metadata (confluence.extra.masterdetail, Version: 2.9, Installed: bundled)
• TinyMCE Editor Plugin (com.atlassian.confluence.tinymceplugin, Version: 3.1, Installed: bundled)
• UWC Importer Admin Panel (com.atlassian.confluence.plugins.uwc.uwcimporter-adminpanel, Version: 1.2.1, Installed: bundled)
• User Administration (confluence.admin.user, Version: 1.0, Installed: bundled)
• User Hover Menu Sections (confluence.user.hover.menu, Version: 1.0, Installed: bundled)
• User Lister (confluence.extra.userlister, Version: 2.4.4, Installed: bundled)
• User Menu Sections (confluence.user.menu.concise, Version: 1.0, Installed: bundled)
• User Menu Sections (confluence.user.menu, Version: 1.0, Installed: bundled)
• User Status (confluence.userstatus, Version: 1.0, Installed: bundled)
• View Changes in Draft (confluence-draft-changes, Version: 1.0, Installed: bundled)
• View Profile Web Interface (confluence.sections.profile.view, Version: 1.0, Installed: bundled)
• View follow resources (confluence.sections.user.view.follow, Version: 1.0, Installed: bundled)
• Widget Connector (com.atlassian.confluence.extra.widgetconnector, Version: 1.3.2, Installed: Jul 26, 2009)
• Wiki Renderer Components (confluence.renderer.components, Version: 1.0, Installed: bundled)
• YourKit Profiling Plugin (com.atlassian.confluence.ext.yourkit, Version: 0.4, Installed: Dec 12, 2007)
• Zen Foundation (com.stepstonetech.confluence.zenfoundation, Version: 2.0.2, Installed: Apr 11, 2007)

Request
Information

URL
http://confluence.atlassian.com/500page.jsp
URI
/500page.jsp
Context Path
Servlet Path
/500page.jsp

Headers (Limited subset)

host
confluence.atlassian.com
user-agent
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5
keep-alive
300
connection
keep-alive

Attributes

javax.servlet.forward.request_uri
/pages/doemptytrash.action
javax.servlet.forward.context_path
javax.servlet.forward.servlet_path
/pages/doemptytrash.action
javax.servlet.forward.path_info
/500page.jsp
os_securityfilter_already_filtered
true
javax.servlet.jsp.jspException
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not delete: com.atlassian.confluence.pages.Attachment#209027171; SQL []; ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails" Detail: Key (attachmentid)=(209027171) is still referenced from table "imagedetails".; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails" Detail: Key (attachmentid)=(209027171) is still referenced from table "imagedetails".
atlassian.core.seraph.original.url
/pages/doemptytrash.action
javax.servlet.error.status_code
500
javax.servlet.error.servlet_name
action
_sitemesh_using_stream
false
com.atlassian.gzipfilter.GzipFilter_already_filtered
true
loginfilter.already.filtered
true
Confluence-Request-Time
1260752736128
com.atlassian.confluence.web.ConfluenceJohnsonFilter_already_filtered
true
javax.servlet.error.message
com.atlassian.core.filters.HeaderSanitisingFilter_already_filtered
true
webwork.valueStack
com.opensymphony.xwork.util.OgnlValueStack@89c10f
sessioninview.FILTERED
true
_sitemesh_filterapplied
true
javax.servlet.error.exception
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not delete: com.atlassian.confluence.pages.Attachment#209027171; SQL []; ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails" Detail: Key (attachmentid)=(209027171) is still referenced from table "imagedetails".; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails" Detail: Key (attachmentid)=(209027171) is still referenced from table "imagedetails".
javax.servlet.error.request_uri
/pages/doemptytrash.action

Parameters (Limited subset)

atl_token
6JeLVTgy-x
confirm
OK
key
JIRASTUDIO

Confluence User

alui
Logging:

8 log statements generated by this request:
[ERROR] Sun Dec 13 19:05:36 CST 2009 [com.atlassian.confluence.pages.persistence.dao.FileSystemAttachmentDataDao] Could not find attachments to remove at '/opt/j2ee/domains/atlassian.com/confluence/webapps/atlassian-confluence/data/attachments/ver003/189/103/104103939/221/212/208962221/209027165'
[ERROR] Sun Dec 13 19:05:36 CST 2009 [com.atlassian.confluence.pages.persistence.dao.FileSystemAttachmentDataDao] Could not find attachments to remove at '/opt/j2ee/domains/atlassian.com/confluence/webapps/atlassian-confluence/data/attachments/ver003/189/103/104103939/221/212/208962221/209027170'
[ERROR] Sun Dec 13 19:05:36 CST 2009 [com.atlassian.confluence.pages.persistence.dao.FileSystemAttachmentDataDao] Could not find attachments to remove at '/opt/j2ee/domains/atlassian.com/confluence/webapps/atlassian-confluence/data/attachments/ver003/189/103/104103939/221/212/208962221/209027163'
[ERROR] Sun Dec 13 19:05:36 CST 2009 [com.atlassian.confluence.pages.persistence.dao.FileSystemAttachmentDataDao] Could not find attachments to remove at '/opt/j2ee/domains/atlassian.com/confluence/webapps/atlassian-confluence/data/attachments/ver003/189/103/104103939/221/212/208962221/209027169'
[ERROR] Sun Dec 13 19:05:36 CST 2009 [com.atlassian.confluence.pages.persistence.dao.FileSystemAttachmentDataDao] Could not find attachments to remove at '/opt/j2ee/domains/atlassian.com/confluence/webapps/atlassian-confluence/data/attachments/ver003/189/103/104103939/221/212/208962221/209027167'
[ERROR] Sun Dec 13 19:05:36 CST 2009 [net.sf.hibernate.util.JDBCExceptionReporter] ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails" Detail: Key (attachmentid)=(209027171) is still referenced from table "imagedetails".
[ERROR] Sun Dec 13 19:05:36 CST 2009 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session
[ERROR] Sun Dec 13 19:05:36 CST 2009 [com.atlassian.confluence.servlet.ConfluenceServletDispatcher] Could not execute action
Throwable:
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not delete: com.atlassian.confluence.pages.Attachment#209027171; SQL []; ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails"
Detail: Key (attachmentid)=(209027171) is still referenced from table "imagedetails".; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails"
Detail: Key (attachmentid)=(209027171) is still referenced from table "imagedetails".
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails"
Detail: Key (attachmentid)=(209027171) is still referenced from table "imagedetails".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:581)
at net.sf.hibernate.impl.ScheduledDeletion.execute(ScheduledDeletion.java:29)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2397)
at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1821)
at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3863)