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

Existing Synonym Sets are imported to the database during upgrade automatically

    Details

      Description

      Add upgrade step which does the import during upgrade when the ES server is available and there are SS entries to add.

      Even if we assume that some customers will set-up a new ES cluster and back-up and restore the indexes manually (after the DB upgrade, so the SS entries may not be present during the upgrade process), other customers will just re-use the existing ES 7.x cluster (especially when upgrading from 7.3) so this upgrade step will eliminate the need for running the Groovy-script and also simplify the Search upgrade docs. In addition, this would also help QA in adding an upgrade test.

      Background:

      Synonyms entries are stored in the Elasticsearch index only. They should be backed by SB entities so they can be restored when performing a full reindex or reindexing that entity through the Search Admin.

      Acceptance Criteria:

      1. Upgrade successfully from 7.2/7.3 search index storage to database storage

      Environment:

      1. Install & configure remote ES7
      2. Configure DXP to connect to remote ES7
      3. Start DXP
      4. Create a Synonym set "liferay,company"
      5. Create another Synonym set "dxp,platform"
      6. Create a new Virtual Instance
      7. Repeat steps 3-4 on the new Virtual Instance
      8. Stop DXP
      9. Stop ES7

      Case: Upgrade

      1. Set-up the environment using DXP 7.3 and follow the steps above to create data
      2. Stop DXP 7.3 and upgrade to Master/7.4
      3. Perform a full reindex
      4. Verify that Synonym sets are present on both Virtual Instances
      5. Verify that Synonym sets are present in the database
      6. Verify that the Synonym indexes (liferay-<companyId>-search-tuning-synonyms) contain the synonym set documents

      UPGRADE NOTES

      • After upgrading from 7.3, if the ES server was not available during the upgrade or it did not contain the existing entries for whatever reason, the groovy script attached must be ran (while portal is connected to the elastic server that contains the synonyms indexes) in order to populate the database
      • Storage: JSONStorageEntry table.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              brian.lee Brian Lee
              Reporter:
              tibor.lipusz Tibor Lipusz
              Engineering Assignee:
              Bryan Engler
              Recent user:
              Tibor Lipusz
              Participants of an Issue:
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Development End Date:
                Development Start Date:

                  Packages

                  Version Package
                  7.4.13 DXP GA1