Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-18856

Removing a space violates a foreign key constraint on table "content" from table "notifications"

      NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

      org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not delete: com.atlassian.confluence.pages.Page#1817938518; SQL []; ERROR: update or delete on table "content" violates foreign key constraint "fk594acc88c38fbea" on table "notifications" Detail: Key (contentid)=(1817938518) is still referenced from table "notifications".; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "content" violates foreign key constraint "fk594acc88c38fbea" on table "notifications" Detail: Key (contentid)=(1817938518) is still referenced from table "notifications".
      at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:110)

      caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "content" violates foreign key constraint "fk594acc88c38fbea" on table "notifications" Detail: Key (contentid)=(1817938518) is still referenced from table "notifications".
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)

              Unassigned Unassigned
              jfleming James Fleming (Inactive)
              Affected customers:
              2 This affects my team
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: