org.postgresql.util.PSQLException: ERROR: update or delete on table "content_perm_set" violates foreign key constraint "fkbd74b31676e33274" on table "content_perm" @40000000521f567b0856be24 Detail: Key (id)=(950276) is still referenced from table "content_perm". @40000000521f567b0856c20c at com.atlassian.event.internal.SingleParameterMethodListenerInvoker.invoke(SingleParameterMethodListenerInvoker.java:54) @40000000521f567b0856cdc4 at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$2.run(AsynchronousAbleEventDispatcher.java:66) @40000000521f567b0856d1ac at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$1.execute(AsynchronousAbleEventDispatcher.java:32) @40000000521f567b0856d594 at com.atlassian.event.internal.AsynchronousAbleEventDispatcher.dispatch(AsynchronousAbleEventDispatcher.java:60) @40000000521f567b0856dd64 at com.atlassian.event.internal.EventPublisherImpl.invokeListeners(EventPublisherImpl.java:160) @40000000521f567b0856e14c at com.atlassian.event.internal.EventPublisherImpl.publish(EventPublisherImpl.java:79) @40000000521f567b0856ed04 at com.atlassian.confluence.spaces.DefaultSpaceManager.removeSpace(DefaultSpaceManager.java:156) @40000000521f567b0856f0ec at com.atlassian.confluence.spaces.DefaultSpaceManager.removeSpace(DefaultSpaceManager.java:119)

Atlassian JIRA | Matthew Hunter | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    The following error is thrown when importing into Atlassian OnDemand from Confluence build number 4355. {noformat} @40000000521f567b07311a44 2013-08-29 08:10:57,118 WARN [Long running task: Importing data] [sf.hibernate.util.JDBCExceptionReporter] logExceptions SQL Error: 0, SQLState: 23503 @40000000521f567b073125fc -- referer: https://arcticwolf.atlassian.net/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: admin | action: doimportconfluencesite @40000000521f567b0736fe14 2013-08-29 08:10:57,120 ERROR [Long running task: Importing data] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ERROR: update or delete on table "content_perm_set" violates foreign key constraint "fkbd74b31676e33274" on table "content_perm" @40000000521f567b073701fc Detail: Key (id)=(950276) is still referenced from table "content_perm". @40000000521f567b073705e4 -- referer: https://arcticwolf.atlassian.net/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: admin | action: doimportconfluencesite @40000000521f567b074aa554 2013-08-29 08:10:57,121 ERROR [Long running task: Importing data] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session @40000000521f567b074aa93c -- referer: https://arcticwolf.atlassian.net/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: admin | action: doimportconfluencesite @40000000521f567b085654ac 2013-08-29 08:10:57,126 ERROR [Long running task: Importing data] [atlassian.event.internal.AsynchronousAbleEventDispatcher] run There was an exception thrown trying to dispatch event 'com.atlassian.confluence.event.events.space.SpaceWillRemoveEvent[source=com.atlassian.confluence.spaces.DefaultSpaceManager@1c4e7b2]' from the invoker 'SingleParameterMethodListenerInvoker{method=public void com.atlassian.confluence.core.listeners.BundledContentSpaceRemovalListener.spaceIsBeingRemoved(com.atlassian.confluence.event.events.space.SpaceWillRemoveEvent), listener=com.atlassian.confluence.core.listeners.BundledContentSpaceRemovalListener@72fb4b}'. @40000000521f567b08569714 -- referer: https://arcticwolf.atlassian.net/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: admin | action: doimportconfluencesite @40000000521f567b08569ee4 java.lang.RuntimeException: Hibernate operation: could not delete: [com.atlassian.confluence.security.ContentPermissionSet#950276]; SQL []; ERROR: update or delete on table "content_perm_set" violates foreign key constraint "fkbd74b31676e33274" on table "content_perm" @40000000521f567b0856b26c Detail: Key (id)=(950276) is still referenced from table "content_perm".; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "content_perm_set" violates foreign key constraint "fkbd74b31676e33274" on table "content_perm" @40000000521f567b0856be24 Detail: Key (id)=(950276) is still referenced from table "content_perm". @40000000521f567b0856c20c at com.atlassian.event.internal.SingleParameterMethodListenerInvoker.invoke(SingleParameterMethodListenerInvoker.java:54) @40000000521f567b0856cdc4 at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$2.run(AsynchronousAbleEventDispatcher.java:66) @40000000521f567b0856d1ac at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$1.execute(AsynchronousAbleEventDispatcher.java:32) @40000000521f567b0856d594 at com.atlassian.event.internal.AsynchronousAbleEventDispatcher.dispatch(AsynchronousAbleEventDispatcher.java:60) @40000000521f567b0856dd64 at com.atlassian.event.internal.EventPublisherImpl.invokeListeners(EventPublisherImpl.java:160) @40000000521f567b0856e14c at com.atlassian.event.internal.EventPublisherImpl.publish(EventPublisherImpl.java:79) @40000000521f567b0856ed04 at com.atlassian.confluence.spaces.DefaultSpaceManager.removeSpace(DefaultSpaceManager.java:156) @40000000521f567b0856f0ec at com.atlassian.confluence.spaces.DefaultSpaceManager.removeSpace(DefaultSpaceManager.java:119) @40000000521f567b0856f4d4 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) @40000000521f567b0856f4d4 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) @40000000521f567b0857008c at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) @40000000521f567b08570474 at java.lang.reflect.Method.invoke(Method.java:597) @40000000521f567b08570474 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) @40000000521f567b0857085c at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) @40000000521f567b085717fc at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) @40000000521f567b08571be4 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) @40000000521f567b08571fcc at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) @40000000521f567b085742f4 at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16) @40000000521f567b085746dc at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) @40000000521f567b085746dc at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) @40000000521f567b08575294 at $Proxy93.removeSpace(Unknown Source) @40000000521f567b08575294 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) @40000000521f567b0857567c at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) @40000000521f567b08575a64 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) @40000000521f567b08575a64 at java.lang.reflect.Method.invoke(Method.java:597) @40000000521f567b08576234 at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129) @40000000521f567b0857661c at $Proxy332.removeSpace(Unknown Source) @40000000521f567b08576a04 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) @40000000521f567b08576a04 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) @40000000521f567b085775bc at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) @40000000521f567b085779a4 at java.lang.reflect.Method.invoke(Method.java:597) @40000000521f567b085779a4 at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:154) @40000000521f567b08577d8c at $Proxy332.removeSpace(Unknown Source) @40000000521f567b0857855 {noformat}

    Atlassian JIRA | 4 years ago | Matthew Hunter
    org.postgresql.util.PSQLException: ERROR: update or delete on table "content_perm_set" violates foreign key constraint "fkbd74b31676e33274" on table "content_perm" @40000000521f567b0856be24 Detail: Key (id)=(950276) is still referenced from table "content_perm". @40000000521f567b0856c20c at com.atlassian.event.internal.SingleParameterMethodListenerInvoker.invoke(SingleParameterMethodListenerInvoker.java:54) @40000000521f567b0856cdc4 at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$2.run(AsynchronousAbleEventDispatcher.java:66) @40000000521f567b0856d1ac at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$1.execute(AsynchronousAbleEventDispatcher.java:32) @40000000521f567b0856d594 at com.atlassian.event.internal.AsynchronousAbleEventDispatcher.dispatch(AsynchronousAbleEventDispatcher.java:60) @40000000521f567b0856dd64 at com.atlassian.event.internal.EventPublisherImpl.invokeListeners(EventPublisherImpl.java:160) @40000000521f567b0856e14c at com.atlassian.event.internal.EventPublisherImpl.publish(EventPublisherImpl.java:79) @40000000521f567b0856ed04 at com.atlassian.confluence.spaces.DefaultSpaceManager.removeSpace(DefaultSpaceManager.java:156) @40000000521f567b0856f0ec at com.atlassian.confluence.spaces.DefaultSpaceManager.removeSpace(DefaultSpaceManager.java:119)
  2. 0

    The following error is thrown when importing into Atlassian OnDemand from Confluence build number 4355. {noformat} @40000000521f567b07311a44 2013-08-29 08:10:57,118 WARN [Long running task: Importing data] [sf.hibernate.util.JDBCExceptionReporter] logExceptions SQL Error: 0, SQLState: 23503 @40000000521f567b073125fc -- referer: https://arcticwolf.atlassian.net/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: admin | action: doimportconfluencesite @40000000521f567b0736fe14 2013-08-29 08:10:57,120 ERROR [Long running task: Importing data] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ERROR: update or delete on table "content_perm_set" violates foreign key constraint "fkbd74b31676e33274" on table "content_perm" @40000000521f567b073701fc Detail: Key (id)=(950276) is still referenced from table "content_perm". @40000000521f567b073705e4 -- referer: https://arcticwolf.atlassian.net/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: admin | action: doimportconfluencesite @40000000521f567b074aa554 2013-08-29 08:10:57,121 ERROR [Long running task: Importing data] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session @40000000521f567b074aa93c -- referer: https://arcticwolf.atlassian.net/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: admin | action: doimportconfluencesite @40000000521f567b085654ac 2013-08-29 08:10:57,126 ERROR [Long running task: Importing data] [atlassian.event.internal.AsynchronousAbleEventDispatcher] run There was an exception thrown trying to dispatch event 'com.atlassian.confluence.event.events.space.SpaceWillRemoveEvent[source=com.atlassian.confluence.spaces.DefaultSpaceManager@1c4e7b2]' from the invoker 'SingleParameterMethodListenerInvoker{method=public void com.atlassian.confluence.core.listeners.BundledContentSpaceRemovalListener.spaceIsBeingRemoved(com.atlassian.confluence.event.events.space.SpaceWillRemoveEvent), listener=com.atlassian.confluence.core.listeners.BundledContentSpaceRemovalListener@72fb4b}'. @40000000521f567b08569714 -- referer: https://arcticwolf.atlassian.net/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: admin | action: doimportconfluencesite @40000000521f567b08569ee4 java.lang.RuntimeException: Hibernate operation: could not delete: [com.atlassian.confluence.security.ContentPermissionSet#950276]; SQL []; ERROR: update or delete on table "content_perm_set" violates foreign key constraint "fkbd74b31676e33274" on table "content_perm" @40000000521f567b0856b26c Detail: Key (id)=(950276) is still referenced from table "content_perm".; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "content_perm_set" violates foreign key constraint "fkbd74b31676e33274" on table "content_perm" @40000000521f567b0856be24 Detail: Key (id)=(950276) is still referenced from table "content_perm". @40000000521f567b0856c20c at com.atlassian.event.internal.SingleParameterMethodListenerInvoker.invoke(SingleParameterMethodListenerInvoker.java:54) @40000000521f567b0856cdc4 at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$2.run(AsynchronousAbleEventDispatcher.java:66) @40000000521f567b0856d1ac at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$1.execute(AsynchronousAbleEventDispatcher.java:32) @40000000521f567b0856d594 at com.atlassian.event.internal.AsynchronousAbleEventDispatcher.dispatch(AsynchronousAbleEventDispatcher.java:60) @40000000521f567b0856dd64 at com.atlassian.event.internal.EventPublisherImpl.invokeListeners(EventPublisherImpl.java:160) @40000000521f567b0856e14c at com.atlassian.event.internal.EventPublisherImpl.publish(EventPublisherImpl.java:79) @40000000521f567b0856ed04 at com.atlassian.confluence.spaces.DefaultSpaceManager.removeSpace(DefaultSpaceManager.java:156) @40000000521f567b0856f0ec at com.atlassian.confluence.spaces.DefaultSpaceManager.removeSpace(DefaultSpaceManager.java:119) @40000000521f567b0856f4d4 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) @40000000521f567b0856f4d4 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) @40000000521f567b0857008c at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) @40000000521f567b08570474 at java.lang.reflect.Method.invoke(Method.java:597) @40000000521f567b08570474 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) @40000000521f567b0857085c at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) @40000000521f567b085717fc at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) @40000000521f567b08571be4 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) @40000000521f567b08571fcc at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) @40000000521f567b085742f4 at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16) @40000000521f567b085746dc at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) @40000000521f567b085746dc at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) @40000000521f567b08575294 at $Proxy93.removeSpace(Unknown Source) @40000000521f567b08575294 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) @40000000521f567b0857567c at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) @40000000521f567b08575a64 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) @40000000521f567b08575a64 at java.lang.reflect.Method.invoke(Method.java:597) @40000000521f567b08576234 at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129) @40000000521f567b0857661c at $Proxy332.removeSpace(Unknown Source) @40000000521f567b08576a04 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) @40000000521f567b08576a04 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) @40000000521f567b085775bc at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) @40000000521f567b085779a4 at java.lang.reflect.Method.invoke(Method.java:597) @40000000521f567b085779a4 at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:154) @40000000521f567b08577d8c at $Proxy332.removeSpace(Unknown Source) @40000000521f567b0857855 {noformat}

    Atlassian JIRA | 4 years ago | Matthew Hunter
    org.postgresql.util.PSQLException: ERROR: update or delete on table "content_perm_set" violates foreign key constraint "fkbd74b31676e33274" on table "content_perm" @40000000521f567b0856be24 Detail: Key (id)=(950276) is still referenced from table "content_perm". @40000000521f567b0856c20c at com.atlassian.event.internal.SingleParameterMethodListenerInvoker.invoke(SingleParameterMethodListenerInvoker.java:54) @40000000521f567b0856cdc4 at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$2.run(AsynchronousAbleEventDispatcher.java:66) @40000000521f567b0856d1ac at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$1.execute(AsynchronousAbleEventDispatcher.java:32) @40000000521f567b0856d594 at com.atlassian.event.internal.AsynchronousAbleEventDispatcher.dispatch(AsynchronousAbleEventDispatcher.java:60) @40000000521f567b0856dd64 at com.atlassian.event.internal.EventPublisherImpl.invokeListeners(EventPublisherImpl.java:160) @40000000521f567b0856e14c at com.atlassian.event.internal.EventPublisherImpl.publish(EventPublisherImpl.java:79) @40000000521f567b0856ed04 at com.atlassian.confluence.spaces.DefaultSpaceManager.removeSpace(DefaultSpaceManager.java:156) @40000000521f567b0856f0ec at com.atlassian.confluence.spaces.DefaultSpaceManager.removeSpace(DefaultSpaceManager.java:119)

    Root Cause Analysis

    1. org.postgresql.util.PSQLException

      ERROR: update or delete on table "content_perm_set" violates foreign key constraint "fkbd74b31676e33274" on table "content_perm" @40000000521f567b0856be24 Detail: Key (id)=(950276) is still referenced from table "content_perm". @40000000521f567b0856c20c at com.atlassian.event.internal.SingleParameterMethodListenerInvoker.invoke(SingleParameterMethodListenerInvoker.java:54) @40000000521f567b0856cdc4 at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$2.run(AsynchronousAbleEventDispatcher.java:66) @40000000521f567b0856d1ac at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$1.execute(AsynchronousAbleEventDispatcher.java:32) @40000000521f567b0856d594 at com.atlassian.event.internal.AsynchronousAbleEventDispatcher.dispatch(AsynchronousAbleEventDispatcher.java:60) @40000000521f567b0856dd64 at com.atlassian.event.internal.EventPublisherImpl.invokeListeners(EventPublisherImpl.java:160) @40000000521f567b0856e14c at com.atlassian.event.internal.EventPublisherImpl.publish(EventPublisherImpl.java:79) @40000000521f567b0856ed04 at com.atlassian.confluence.spaces.DefaultSpaceManager.removeSpace(DefaultSpaceManager.java:156) @40000000521f567b0856f0ec at com.atlassian.confluence.spaces.DefaultSpaceManager.removeSpace(DefaultSpaceManager.java:119)

      at sun.reflect.NativeMethodAccessorImpl.invoke0()
    2. Java RT
      NativeMethodAccessorImpl.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      2 frames