Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-3459

Proxies fail when the live document is removed (VCS)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 5.2 RC1
    • Fix Version/s: 5.2 RC1 SP1, 5.2 GA
    • Component/s: Core VCS
    • Impact type:
      Content model Change
    • Upgrade notes:
      Hide

      Databases initialized with 5.2.RC1 need to be purged of the foreign key reference:

      For H2 and PostgreSQL:
      ALTER TABLE VERSIONS DROP CONSTRAINT VERSIONS_VERSIONABLEID_HIERARCHY_FK;

      In addition, for databases that have already been corrupted, some data is missing and there is no recourse but removing the affected proxies and versions as well:

      For H2 and PostgreSQL:
      DELETE FROM HIERARCHY WHERE PARENTID IS NULL AND PRIMARYTYPE <> 'Root' AND NOT EXISTS(SELECT * FROM VERSIONS WHERE VERSIONS.ID = HIERARCHY.ID);

      Always backup first!

      Show
      Databases initialized with 5.2.RC1 need to be purged of the foreign key reference: For H2 and PostgreSQL: ALTER TABLE VERSIONS DROP CONSTRAINT VERSIONS_VERSIONABLEID_HIERARCHY_FK; In addition, for databases that have already been corrupted, some data is missing and there is no recourse but removing the affected proxies and versions as well: For H2 and PostgreSQL: DELETE FROM HIERARCHY WHERE PARENTID IS NULL AND PRIMARYTYPE <> 'Root' AND NOT EXISTS(SELECT * FROM VERSIONS WHERE VERSIONS.ID = HIERARCHY.ID); Always backup first!

      Description

      When removing a live document, the versions (and the proxies) become inaccessible because the versions table row for each version is incorrectly cleared. This is due to a spurious foreign key in the versions table.

        Attachments

        1. nuxeo-core-storage-sql-1.5.0-RC1-NXP-3459.diff
          0.7 kB
          Florent Guillaume

          Issue Links

          is required by

          Bug - A problem which impairs or prevents the functions of the product. NXP-4080 Nuxeo 5.2.0 RC1 SP1

          • Major - Major loss of function.
          • Resolved

            Activity

              People

              • Assignee:
                fguillaume Florent Guillaume
                Reporter:
                fguillaume Florent Guillaume
                Participants:
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: