Uploaded image for project: 'PUBLIC - Liferay Portal Web Content Experience'
  1. PUBLIC - Liferay Portal Web Content Experience
  2. WCM-1480

Deleting Virtual Instance leaves orphaned table data

    Details

      Description

      The ct_analytics_analyticsevent and ct_analytics_analyticsreferrer tables have rows that are created for specific companies, but are not cleared out when the virtual instance is removed. Because the companyId no longer corresponds to an existing virtual instance, they are not cleared out once they expire, either.

      Steps to reproduce:

      1. Deploy Audience Targeting
      2. Create a virtual instance (for ease of testing it can be configured to an alias that is also set to 127.0.0.1 in the system's hosts file, e.g. localhost2 instead of localhost)
      3. Check the ct_analyics_analyticsevent and ct_analytics_analyticsreferrer tables and note the number of rows in them
      4. Log into the virtual instance, then refresh the page a few times
      5. Check the two tables again, noting the added rows
      6. Delete the Virtual Instance
      7. Check the tables one more time
        Expected result: the rows added for visiting the Virtual Instance are deleted
        Actual result: no rows are deleted

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                3.0
                2.2.0
                3.0 RC2