java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3]

Atlassian JIRA | Dave Loeng [Atlassian] | 1 decade ago
  1. 0

    Cause: org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3] Stack Trace: [hide] org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3] java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:598) at net.sf.hibernate.impl.ScheduledDeletion.execute(ScheduledDeletion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2382) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2340) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2204) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)

    Atlassian JIRA | 1 decade ago | Dave Loeng [Atlassian]
    java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3]
  2. 0

    Cause: org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3] Stack Trace: [hide] org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3] java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:598) at net.sf.hibernate.impl.ScheduledDeletion.execute(ScheduledDeletion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2382) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2340) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2204) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)

    Atlassian JIRA | 1 decade ago | Dave Loeng [Atlassian]
    java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3]
  3. 0

    Report from Turadg Aleahmad <turadg@berkeley.edu> I tried deleting a template named Person. From the referrer URL you see the pageTemplateId=1. The Confluence location bar read: Location: Dashboard <http://confluence.example.org:48080/dashboard.action> > Templates <http://confluence.example.org:48080/pages/templates/listpagetemplates.action> > Person <http://confluence.example.org:48080/pages/templates/viewpagetemplate.action?pageTemplateId=1> > Remove But the "Name:" was blank. Are you sure you want to delete this template? Name: When I clicked "Remove" I got this... CONFLUENCE <http://confluence.example.org:48080/> System Error A system error has occurred. If this problem persists - please notify your Confluence administrator of this problem. If you experience problems getting to this support page, please send an email to confluence-support@atlassian.com <mailto:confluence-support@atlassian.com> with the following information: 1. a description of your problem 2. cut & paste the error and system information found below 3. attach the application server log file *Cause:* org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is: java.sql.SQLException: Integrity constraint violation: FKBC7CE96A17D4A070 table: PAGETEMPLATES in statement [delete from PAGETEMPLATES where TEMPLATEID=1] *Stack Trace:* [hide] org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is: java.sql.SQLException: Integrity constraint violation: FKBC7CE96A17D4A070 table: PAGETEMPLATES in statement [delete from PAGETEMPLATES where TEMPLATEID=1] java.sql.SQLException: Integrity constraint violation: FKBC7CE96A17D4A070 table: PAGETEMPLATES in statement [delete from PAGETEMPLATES where TEMPLATEID=1] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:582) at net.sf.hibernate.impl.ScheduledDeletion.execute(ScheduledDeletion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2326) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2284) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2180) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:309) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:218) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:172) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy21.removePageTemplate(Unknown Source) at com.atlassian.confluence.pages.templates.actions.RemovePageTemplateAction.doRemove(RemovePageTemplateAction.java:22) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:309) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:175) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:58) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:32) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:18) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:182) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:162) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:36) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:161) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:83) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:39) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:148) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:534) *Referer URL:* http://confluence.example.org:48080/pages/templates/removepagetemplate.action?pageTemplateId=1 *System Information:* System Date: Friday, 23 Jan 2004 System Time: 21:29:39 Java Version: 1.4.2_03 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_03-b02 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: root User Timezone: America/Los_Angeles Operating System: Linux 2.4.21-9.EL OS Architecture: i386 Total Memory: 127 MB Free Memory: 32 MB Used Memory: 95 MB Uptime: 1 day, 2 hours, 37 minutes, 13 seconds Version: 1.0b3 Build Number: 32

    Atlassian JIRA | 1 decade ago | Charles Miller
    java.sql.SQLException: Integrity constraint violation: FKBC7CE96A17D4A070 table: PAGETEMPLATES in statement [delete from PAGETEMPLATES where TEMPLATEID=1]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Report from Turadg Aleahmad <turadg@berkeley.edu> I tried deleting a template named Person. From the referrer URL you see the pageTemplateId=1. The Confluence location bar read: Location: Dashboard <http://confluence.example.org:48080/dashboard.action> > Templates <http://confluence.example.org:48080/pages/templates/listpagetemplates.action> > Person <http://confluence.example.org:48080/pages/templates/viewpagetemplate.action?pageTemplateId=1> > Remove But the "Name:" was blank. Are you sure you want to delete this template? Name: When I clicked "Remove" I got this... CONFLUENCE <http://confluence.example.org:48080/> System Error A system error has occurred. If this problem persists - please notify your Confluence administrator of this problem. If you experience problems getting to this support page, please send an email to confluence-support@atlassian.com <mailto:confluence-support@atlassian.com> with the following information: 1. a description of your problem 2. cut & paste the error and system information found below 3. attach the application server log file *Cause:* org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is: java.sql.SQLException: Integrity constraint violation: FKBC7CE96A17D4A070 table: PAGETEMPLATES in statement [delete from PAGETEMPLATES where TEMPLATEID=1] *Stack Trace:* [hide] org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is: java.sql.SQLException: Integrity constraint violation: FKBC7CE96A17D4A070 table: PAGETEMPLATES in statement [delete from PAGETEMPLATES where TEMPLATEID=1] java.sql.SQLException: Integrity constraint violation: FKBC7CE96A17D4A070 table: PAGETEMPLATES in statement [delete from PAGETEMPLATES where TEMPLATEID=1] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:582) at net.sf.hibernate.impl.ScheduledDeletion.execute(ScheduledDeletion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2326) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2284) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2180) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:309) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:218) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:172) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy21.removePageTemplate(Unknown Source) at com.atlassian.confluence.pages.templates.actions.RemovePageTemplateAction.doRemove(RemovePageTemplateAction.java:22) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:309) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:175) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:58) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:32) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:18) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:182) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:162) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:36) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:161) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:83) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:39) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:148) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:534) *Referer URL:* http://confluence.example.org:48080/pages/templates/removepagetemplate.action?pageTemplateId=1 *System Information:* System Date: Friday, 23 Jan 2004 System Time: 21:29:39 Java Version: 1.4.2_03 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_03-b02 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: root User Timezone: America/Los_Angeles Operating System: Linux 2.4.21-9.EL OS Architecture: i386 Total Memory: 127 MB Free Memory: 32 MB Used Memory: 95 MB Uptime: 1 day, 2 hours, 37 minutes, 13 seconds Version: 1.0b3 Build Number: 32

    Atlassian JIRA | 1 decade ago | Charles Miller
    java.sql.SQLException: Integrity constraint violation: FKBC7CE96A17D4A070 table: PAGETEMPLATES in statement [delete from PAGETEMPLATES where TEMPLATEID=1]
  6. 0

    Errors after DataIntegrityViolationException

    springframework | 1 decade ago | garethmorgan
    java.sql.SQLException: Violation of unique index: SYS\_IDX\_2 in statement \[insert into users (userId, password, name, email, uid) values ('gm2', 'gm2', 'G2 Morgan', 'gaz@test.com', 3)\]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3]

      at org.hsqldb.Trace.getError()
    2. HSQLDB
      jdbcPreparedStatement.executeUpdate
      1. org.hsqldb.Trace.getError(Unknown Source)
      2. org.hsqldb.jdbcResultSet.<init>(Unknown Source)
      3. org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
      4. org.hsqldb.jdbcConnection.execute(Unknown Source)
      5. org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
      6. org.hsqldb.jdbcStatement.executeUpdate(Unknown Source)
      7. org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source)
      7 frames
    3. net.sf.hibernate
      JDBCTransaction.commit
      1. net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
      2. net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:598)
      3. net.sf.hibernate.impl.ScheduledDeletion.execute(ScheduledDeletion.java:29)
      4. net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2382)
      5. net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2340)
      6. net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2204)
      7. net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
      7 frames