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 | 3 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded 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 | 3 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 | 3 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