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

              jayda.wu Jayda Wu
              jorge.diaz Jorge Diaz
              Kiyoshi Lee Kiyoshi Lee
              Jorge Diaz Jorge Diaz
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                1 year, 7 weeks, 2 days ago

                Packages

                  Version Package
                  7.2.10 DXP FP17
                  7.2.10.6 DXP SP6
                  7.2.X
                  7.3.10.3 DXP SP3
                  7.3.X
                  7.4.13 DXP GA1
                  Master