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

Remove ad hoc H2 fulltext indexing

    Details

    • Type: Clean up
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 11.1, 2021.0
    • Component/s: Core, H2
    • Tags:
    • Upgrade notes:
      Hide

      Fulltext searches are not possible anymore with the embedded h2 database. If fulltext search is required, it should be done either by using a regular database like MongoDB or PostgreSQL, or by directing the query to an Elasticsearch-based page provider.

      Show
      Fulltext searches are not possible anymore with the embedded h2 database. If fulltext search is required, it should be done either by using a regular database like MongoDB or PostgreSQL, or by directing the query to an Elasticsearch-based page provider.
    • Team:
      FG
    • Sprint:
      nxFG 11.1.13
    • Story Points:
      3

      Description

      Remove our ad hoc H2 fulltext indexing (H2Fulltext) because it's an additional maintenance burden, has a dependency on Lucene so requires changes when Lucene is upgraded, and causes random bugs after the H2 upgrade of NXP-28956.

      An attempt to keep the very simple native H2 non-Lucene fulltext search for minimal coverage failed, as this implementation throws exception when used in concurrency. We therefore completely remove H2 fulltext support.

      In production anyway we don't use H2, as Elasticsearch is the backend actually used for fulltext searches.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day
                  1d

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.