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
  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)
  3. 0

    GitHub comment 121#244860184

    GitHub | 3 months ago | vwilliam
    javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    POSIntegration

    Google Groups | 7 months ago | Jianfeng Wang
    org.postgresql.util.PSQLException: ERROR: update or delete on table "ad_package_imp_proc" violates foreign key constraint "adpackageimpproc_adpackageimp" on table "ad_package_imp" Detail: Key (ad_package_imp_proc_id)=(1000002) is still referenced from table "ad_package_imp".; State=23503; ErrorCode=0 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173) at org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:824) at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:848) at com.mchange.v2.c3p0.impl.NewProxyConnection.commit(NewProxyConnection.java:1007)
  6. 0

    Unable to delete files after Migration from 3.6

    Google Groups | 1 month ago | Bikramjit Singh
    org.postgresql.util.PSQLException: ERROR: update or delete on table "dvobject" violates foreign key constraint "fk_datafilecategory_dataset_id" on table "datafilecategory" Detail: Key (id)=(38325) is still referenced from table "datafilecategory" . Error Code: 0 Call: DELETE FROM DVOBJECT WHERE (ID = ?) bind => [1 parameter bound] Query: DeleteObjectQuery([DataFile id:38325 name:null])

    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. 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