Error removing space with custom space logo and attachments stored in the database

XMLWordPrintable

      The following foreign key constraint error is thrown when trying to remove a space:

      org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not delete: [com.atlassian.confluence.pages.Attachment#131179]; SQL []; ERROR: update or delete on table "attachments" violates foreign key constraint "fk9dc3e34d34a4917e" on table "attachmentdata"
        Detail: Key (attachmentid)=(131179) is still referenced from table "attachmentdata".; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "attachments" violates foreign key constraint "fk9dc3e34d34a4917e" on table "attachmentdata"
        Detail: Key (attachmentid)=(131179) is still referenced from table "attachmentdata".
      Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "attachments" violates foreign key constraint "fk9dc3e34d34a4917e" on table "attachmentdata"
        Detail: Key (attachmentid)=(131179) is still referenced from table "attachmentdata".
      

      This problem only occurs when attachments are stored in the database and a custom logo is configured for the space. This problem will be more evident in a cluster as attachments are always stored in the database.

              Assignee:
              Agnes Ro
              Reporter:
              Agnes Ro
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: