Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-138761

Instance delete operation is not deleting the instance data on all database tables

    Details

      Description

      Database wrong references

      Steps to reproduce

      1. Go to Control Panel => Virtual instances
      2. Create a new instance
      3. Get the companyId from the created instance
      4. Once the instance is completely created, delete it
      5. Execute this SQL:
        select * from AccountGroup where companyId = <companyId>
        
        • Expected result: the SQL doesn't return any record
        • Wrong result: the SQL returns some records
      6. To get the list of all affected tables, use theattached get_tables_with_invalid_records.groovy groovy script: set the companyId value in the second "long wrongValue" line of the script and execute it from server administration.
        • Expected result: the script doesn't return any table
        • Wrong result: the script return following tables

      Database tables with wrong records from deleted instance:

      AccountGroup
      DLStorageQuota
      DispatchTrigger
      OAuth2Application
      OAuth2ApplicationScopeAliases
      OAuth2ScopeGrant
      PortalPreferences

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jayda.wu Jayda Wu
              Reporter:
              jorge.diaz Jorge Diaz
              Participants of an Issue:
              Recent user:
              Enterprise Release HU
              Engineering Assignee:
              Jorge Diaz
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                7 weeks, 3 days ago

                  Packages

                  Version Package
                  7.2.X
                  7.3.X
                  7.4.13 DXP GA1
                  Master