-
Bug
-
Resolution: Duplicate
-
Medium
-
None
-
2.9.1
-
None
-
4
-
I have a space that has 2 space templates defined. When I try to remove the space I get the following exception page and the space does not get removed:
------------------------------
Cause
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not delete: com.atlassian.confluence.pages.templates.PageTemplate#1409026; SQL []; ERROR: update or delete on table "pagetemplates" violates foreign key constraint "fkbc7ce96a17d4a070" on table "pagetemplates" Detail: Key (templateid)=(1409026) is still referenced from table "pagetemplates".; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "pagetemplates" violates foreign key constraint "fkbc7ce96a17d4a070" on table "pagetemplates" Detail: Key (templateid)=(1409026) is still referenced from table "pagetemplates".
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:110)
caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "pagetemplates" violates foreign key constraint "fkbc7ce96a17d4a070" on table "pagetemplates" Detail: Key (templateid)=(1409026) is still referenced from table "pagetemplates".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
Stack Trace:[hide]
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not delete: com.atlassian.confluence.pages.templates.PageTemplate#1409026; SQL []; ERROR: update or delete on table "pagetemplates" violates foreign key constraint "fkbc7ce96a17d4a070" on table "pagetemplates"
Detail: Key (templateid)=(1409026) is still referenced from table "pagetemplates".; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "pagetemplates" violates foreign key constraint "fkbc7ce96a17d4a070" on table "pagetemplates"
Detail: Key (templateid)=(1409026) is still referenced from table "pagetemplates".
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "pagetemplates" violates foreign key constraint "fkbc7ce96a17d4a070" on table "pagetemplates"
Detail: Key (templateid)=(1409026) is still referenced from table "pagetemplates".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
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.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 org.springframework.orm.hibernate.HibernateTemplate$20.doInHibernate(HibernateTemplate.java:731)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)
at org.springframework.orm.hibernate.HibernateTemplate.find(HibernateTemplate.java:717)
at org.springframework.orm.hibernate.HibernateTemplate.find(HibernateTemplate.java:700)
at bucket.search.persistence.dao.hibernate.HibernateIndexQueueEntryDao.getNewEntries(HibernateIndexQueueEntryDao.java:43)
at com.atlassian.confluence.search.lucene.queue.DatabaseIndexTaskQueue.getUnflushedEntries(DatabaseIndexTaskQueue.java:153)
at com.atlassian.confluence.search.lucene.queue.DatabaseIndexTaskQueue.flushQueue(DatabaseIndexTaskQueue.java:136)
at com.atlassian.confluence.search.lucene.DefaultConfluenceIndexManager.flushQueue(DefaultConfluenceIndexManager.java:106)
at sun.reflect.GeneratedMethodAccessor499.invoke(Unknown Source)
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 org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy25.flushQueue(Unknown Source)
at com.atlassian.confluence.spaces.DefaultSpaceManager.removeSpace(DefaultSpaceManager.java:168)
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:20)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy30.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:597)
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: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.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:48)
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:54)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.pages.actions.CommentAwareInterceptor.intercept(CommentAwareInterceptor.java:43)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:120)
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:97)
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:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
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:153)
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.confluence.jmx.JmxFilter.doFilter(JmxFilter.java:109)
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:21)
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:49)
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 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:192)
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.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:120)
at com.atlassian.confluence.util.AbstractBootstrapHotSwappingFilter.doFilter(AbstractBootstrapHotSwappingFilter.java:28)
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:125)
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.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:142)
at com.atlassian.core.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27)
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:94)
at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:64)
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.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33)
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:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
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:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:619)
Referer URL
https://wiki.globalrelay.net/spaces/removespace.action?key=TRGR
Confluence Application Information
Build Information
home: /opt/confluence/data
buildNumber: 1418
upTime: 9 days, 20 hours, 45 minutes, 25 seconds
devMode: false
version: 2.9.1
Unique ID: 0x0000011E508F850D0A140A0CA6A377AA9A9AB8D349E1C1DEC2D167EE9949B587
Server information
Application Server: Apache Tomcat/5.5.23
Servlet Version: 2.4
Database Dialect: net.sf.hibernate.dialect.PostgreSQLDialect
Database Driver Name: org.postgresql.Driver
Database Driver Version: 8.3
Database Name: PostgreSQL
Database Version: 8.3.3
Database Transaction Isolation: Read committed Database Latency: 0
Memory Information
Total Memory: 476 MB
Used Memory: 333 MB
Free Memory: 142 MB
System Information
favouriteColour: Sangria
javaRuntime: Java(TM) SE Runtime Environment
jvmVersion: 1.0
operatingSystem: Linux 2.6.18-92.1.10.el5.centos.plus
fileSystemEncoding: UTF-8
javaVm: Java HotSpot(TM) 64-Bit Server VM
javaVendor: Sun Microsystems Inc.
userTimezone: Etc/GMT
jvmImplementationVersion: 10.0-b23
appServer: Apache Tomcat
date: Friday, 19 Dec 2008
time: 18:43:49
jvmVendor: Sun Microsystems Inc.
userName: root
javaVersion: 1.6.0_07
operatingSystemArchitecture: amd64
Cluster Information
Not clustered.
Plugins
- Add Content Menu Sections (confluence.menu.add, Version: 1.0)
- Admin Sections (confluence.sections.admin, Version: 1.0)
- Advanced Macros (confluence.macros.advanced, Version: 1.4.2)
- Attachment Actions (confluence.sections.attachments, Version: 1.0)
- Basic Macros (confluence.macros.basic, Version: 1.4)
- Browse Menu Items (confluence.sections.browse, Version: 1.0)
- Calendar Plugin (confluence.extra.calendar, Version: 2.7.1)
- Chart Plugin (confluence.extra.chart, Version: 1.11)
- Checklists Macros (com.comalatech.checklists, Version: 1.4.0)
- Code Macro (confluence.macros.code, Version: 1.5)
- Comment Action Sections (confluence.comment.action, Version: 1.0)
- Confluence Atlassian Plugin Repository (confluence.repository.client, Version: 2.0.15)
- Confluence Attachments Plugin (confluence.extra.attachments, Version: 2.10)
- Confluence Blogging RPC Plugin (com.atlassian.confluence.plugins.xmlrpc.bloggingrpc, Version: 1.2.3)
- Confluence Classic Theme (com.atlassian.confluence.themes.classic, Version: 2.0)
- Confluence Contributors Plugin (com.atlassian.confluence.contributors, Version: 1.2)
- Confluence HTML Macros (confluence.macros.html, Version: 1.4)
- Confluence Remote API (confluence.extra.confluencerpc, Version: 2.9.1)
- Confluence Usage Stats (com.atlassian.confluence.ext.usage, Version: 0.8)
- Content Action Menu Sections (confluence.content.action.menu, Version: 1.0)
- Content Buttons (confluence.sections.page.temp, Version: 1.0)
- Core Extractors (confluence.extractors.core, Version: 1.4)
- Core Listeners (confluence.listeners.core, Version: 1.3)
- Core Path Converters (confluence.converters.core, Version: 1.0)
- Core Startup and Shutdown (confluence.lifecycle.core, Version: 1)
- Dashboard Macros (confluence.macros.dashboard, Version: 1.4.2)
- Default Theme (com.atlassian.confluence.themes.default, Version: 1.0)
- Dynamic Task List 2 Plugin (confluence.extra.dynamictasklist2, Version: 3.0.6)
- Edit Profile Sections (confluence.sections.profile.edit, Version: 1.0)
- Excel Plugin (org.swift.confluence.excel, Version: 3.5.0)
- Form Mail NG (com.adaptavist.confluence.formMailNG, Version: 1.2.1)
- French language pack (confluence.languages.fr_FR, Version: 1.8)
- German language pack (confluence.languages.de_DE, Version: 1.3)
- Global Labels Sections (confluence.sections.labels, Version: 1.0)
- Google Maps Plugin (com.atlassian.confluence.ext.gmaps, Version: 0.5)
- Information Macros (confluence.extra.information, Version: 1.0)
- JIRA Macros (confluence.extra.jira, Version: 2.8.1.2)
- Layout Macros (confluence.extra.layout, Version: 1.1)
- Left Navigation Theme (com.atlassian.confluence.themes.leftnavigation, Version: 2.0)
- Live Search Macros (confluence.extra.livesearch, Version: 2.8)
- News Tabs (confluence.sections.news, Version: 1.0)
- Office Connector plugin (com.atlassian.confluence.extra.officeconnector, Version: 1.3.6)
- Page Operations (confluence.sections.page.operations, Version: 1.0)
- Page Tabs (confluence.search.mappers.lucene, Version: 1.0)
- Page Tabs (confluence.sections.page, Version: 1.0)
- Page Tree (com.atlassian.confluence.plugins.pagetree, Version: 1.10)
- Page View Links (confluence.sections.page.actions, Version: 1.0)
- Profile Tabs (confluence.sections.profile, Version: 1.0)
- Search Web Interface (confluence.sections.search.view, Version: 1.0)
- Social Bookmarking Plugin (com.atlassian.confluence.plugins.socialbookmarking, Version: 1.2.2)
- Space Actions Sections (confluence.sections.space.actions, Version: 1.0)
- Space Admin Sections (confluence.sections.space.admin, Version: 1.0)
- Space Advanced Sections (confluence.sections.space.advanced, Version: 1.0)
- Space Browse Sections (confluence.sections.space.browse, Version: 1.0)
- Space Item Tabs (confluence.sections.space, Version: 1.0)
- Space Labels Sections (confluence.sections.space.labels, Version: 1.0)
- Space Pages Sections (confluence.sections.space.pages, Version: 1.0)
- Survey Macros (com.nearinfinity.confluence.survey-plugin, Version: 1.1.6)
- System Web Resources (confluence.web.resources, Version: 1.0)
- Table of Contents Plugin (org.randombits.confluence.toc, Version: 2.4.8)
- Tabular Metadata (confluence.extra.masterdetail, Version: 2.7)
- TinyMCE Editor Plugin (com.atlassian.confluence.extra.tinymceplugin, Version: 3.0-rc2)
- Top and Left Navigation Theme (at.hansen.confluence.themes.topandleftnavigation, Version: 1.1)
- Top and Left Navigation Theme - Alternative Version (at.hansen.confluence.themes.topandleftnavigationITD, Version: 1.0)
- User Lister (confluence.extra.userlister, Version: 2.4.1)
- User Menu Sections (confluence.user.menu, Version: 1.0)
- View Profile Web Interface (confluence.sections.profile.view, Version: 1.0)
- Visio Plugin (org.swift.confluence.visio, Version: 1.0)
- WebDAV Plugin (confluence.extra.webdav, Version: 1.1)
- Wiki Renderer Components (confluence.renderer.components, Version: 1.0)
- Word Plugin (org.swift.confluence.word, Version: 3.0.1)
Request
Information
URL
https://wiki.globalrelay.net/500page.jsp
URI
/500page.jsp
Context Path
Servlet Path
/500page.jsp
Query String
key=TRGR
Headers (Limited subset)
host
wiki.globalrelay.net
user-agent
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1
keep-alive
300
connection
keep-alive
Attributes
javax.servlet.forward.request_uri
/spaces/doremovespace.action
javax.servlet.forward.context_path
javax.servlet.forward.servlet_path
/spaces/doremovespace.action
javax.servlet.forward.path_info
/500page.jsp
javax.servlet.forward.query_string
key=TRGR
os_securityfilter_already_filtered
true
javax.servlet.jsp.jspException
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not delete: com.atlassian.confluence.pages.templates.PageTemplate#1409026; SQL []; ERROR: update or delete on table "pagetemplates" violates foreign key constraint "fkbc7ce96a17d4a070" on table "pagetemplates" Detail: Key (templateid)=(1409026) is still referenced from table "pagetemplates".; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "pagetemplates" violates foreign key constraint "fkbc7ce96a17d4a070" on table "pagetemplates" Detail: Key (templateid)=(1409026) is still referenced from table "pagetemplates".
atlassian.core.seraph.original.url
/spaces/doremovespace.action?key=TRGR
javax.servlet.error.status_code
500
javax.servlet.error.servlet_name
action
javax.servlet.request.key_size
0
_sitemesh_using_stream
false
com.atlassian.gzipfilter.GzipFilter_already_filtered
true
loginfilter.already.filtered
true
com.atlassian.johnson.filters.JohnsonFilter_already_filtered
true
Confluence-Request-Time
1229712225070
javax.servlet.request.ssl_session
494be350f50b8059357a86344181e59cbfdbbed36dccc1bee33339ca1bfa3c4a
javax.servlet.error.message
webwork.valueStack
com.opensymphony.xwork.util.OgnlValueStack@27e61926
sessioninview.FILTERED
true
_sitemesh_filterapplied
true
javax.servlet.request.cipher_suite
TLS_DHE_RSA_WITH_AES_128_CBC_SHA
javax.servlet.error.exception
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not delete: com.atlassian.confluence.pages.templates.PageTemplate#1409026; SQL []; ERROR: update or delete on table "pagetemplates" violates foreign key constraint "fkbc7ce96a17d4a070" on table "pagetemplates" Detail: Key (templateid)=(1409026) is still referenced from table "pagetemplates".; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "pagetemplates" violates foreign key constraint "fkbc7ce96a17d4a070" on table "pagetemplates" Detail: Key (templateid)=(1409026) is still referenced from table "pagetemplates".
javax.servlet.error.request_uri
/spaces/doremovespace.action
Parameters (Limited subset)
confirm
OK
key
TRGR
Confluence User
anonymous
----------------------------
When I manually delete the templates and then remove the space I get no exception and the space is removed.
- duplicates
-
CONFSERVER-19490 Removing Space with multiple Page Templates and multiple page templates versions will fail with Foreign Key Contraints
- Closed
- is related to
-
CONFSERVER-16304 Unable to delete space due to integrity constraing for template
- Closed