Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-75487

Space Import throws error: insert or update on table "content" violates foreign key constraint "fk_content_lastmodifier" Detail: Key (lastmodifier)=(XXXXXX) is not present in table "user_mapping".

XMLWordPrintable

      Issue Summary

      When importing a Confluence Space one of the errors below is triggered:

      ERROR: insert or update on table "content" violates foreign key constraint "fk_content_lastmodifier" Detail: Key (lastmodifier)=(XXXXXX) is not present in table "user_mapping". 
      ERROR: insert or update on table "content" violates foreign key constraint "fk_content_creator" Detail: Key (creator)=(XXXXXX) is not present in table "user_mapping". 

      Steps to Reproduce

      1. Export Confluence Cloud Space
      2. Import into another Confluence Cloud Site
      3. Error is triggered

      Expected Results

      The import should be successful.

      Actual Results

      Foreign key constraints are being hit and stopping the import

      Workaround

      Use the import via CSV instead, which has this specific constraint already addressed during the import flow.

              Unassigned Unassigned
              590db20ccbc2 Isaac Spann
              Votes:
              1 Vote for this issue
              Watchers:
              16 Start watching this issue

                Created:
                Updated:
                Resolved: