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

Support of uuid idtype on PostgreSQL is broken

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.7.3, 5.8
    • Fix Version/s: 5.9.1
    • Component/s: Core VCS

      Description

      When using uuid document idtype on PostgreSQL (enable by setting "nuxeo.vcs.idtype=uuid" in the nuxeo.conf).
      After a restart you have the following exception

      java.sql.SQLException: Error executing: CREATE INDEX ancestors_ancestors_idx ON ancestors USING gin(ancestors); : ERROR: data type uuid[] has no default operator class for access method "gin"
  Hint : You must specify an operator class for the index or define a default operator class for the data type.
        at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createDatabase(JDBCMapper.java:160)
...

      Because Nuxeo try to add a GIN index on the ancestors array that is a uuid[].
      GIN index on this type of array is not supported by default on 9.2.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: