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"

    XMLWordPrintable

Details

    Description

      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)

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. CONFCLOUD-18856 Removing a space violates a foreign key constraint on table "content" from table "notifications"

          • Low - Low priority issues
          • Closed

          Activity

            People

              Unassigned Unassigned
              jfleming James Fleming (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: