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

Infinite loop in MySQL NX_ACCESS_ALLOWED

    XMLWordPrintable

    Details

      Description

      When calling NX_ACCESS_ALLOWED on a document that has no parentid but has a versionableid (a version having a proxy on it but whose base document has been deleted), an infinite loop is triggered.

      In NX_ACCESS_ALLOWED in the while loop's first iteration, newid and curid are set to versionableid; then on the next iteration no line is found corresponding to this versionableid: SELECT parentid INTO newid FROM hierarchy WHERE hierarchy.id = curid returns and does nothing. newid and curid remains the same, resulting in a infinite loop.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: