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

TestSQLRepositoryFulltextConfig fails on non-h2 databases

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 7.3
    • Component/s: Core, Tests

      Description

      We have an initialization error on TestSQLRepositoryFulltextConfig. The repository fails to init. The root cause is on PostgreSQL:

      java.sql.SQLException: Error executing: CREATE OR REPLACE FUNCTION NX_TO_TSVECTOR(string VARCHAR)
      RETURNS TSVECTOR
      AS $$
        SELECT TO_TSVECTOR('org.apache.lucene.analysis.fr.FrenchAnalyzer', SUBSTR($1, 1, 250000))
      $$
      LANGUAGE sql
      IMMUTABLE;
      ERROR: improper qualified name (too many dotted names): org.apache.lucene.analysis.fr.frenchanalyzer
      

      And on Oracle:

      Error post creating table: CREATE INDEX "FULLTEXT_FULLTEXT_IDX" ON "FULLTEXT"("FULLTEXT") INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('org.apache.lucene.analysis.fr.FrenchAnalyzer SYNC (ON COMMIT) TRANSACTIONAL') : ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
      ORA-20000: Oracle Text error:
      DRG-11000: invalid keyword ORG.APACHE.LUCENE.ANALYSIS.FR.FRENCHANALYZER
      

      https://qa.nuxeo.org/jenkins/job/nuxeo-master-fullbuild-part1-multidb-linux/1345/Slave=MULTIDB_LINUX,dbprofile=pgsql,jdk=java-8-oracle/testReport/junit/org.nuxeo.ecm.core/TestSQLRepositoryFulltextConfig/testFulltextOnlyNoteFile/
      https://qa.nuxeo.org/jenkins/job/nuxeo-master-fullbuild-part1-multidb-linux/1345/Slave=MULTIDB_LINUX,dbprofile=oracle12c,jdk=java-8-oracle/testReport/junit/org.nuxeo.ecm.core/TestSQLRepositoryFulltextConfig/testFulltextOnlyNoteFile/

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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