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

Add an index on "nxtag:tags.label" to improve tag suggestion in 10.10

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.10-HF70
    • Component/s: Tagging
    • Release Notes Summary:
      A MongoDB index could be added to improve tags suggestion performance
    • Tags:
    • Upgrade notes:
      Hide

      For existing instances on MongoDB, in order to improve performance on tags suggestion the following index needs to be created manually:

      db.default.createIndex({"nxtag:tags.label": 1})
      Show
      For existing instances on MongoDB, in order to improve performance on tags suggestion the following index needs to be created manually: db. default .createIndex({ "nxtag:tags.label" : 1})
    • Team:
      PLATFORM
    • Sprint:
      nxplatform #77
    • Story Points:
      3

      Description

      an index will help to perform a regex expression because the label is case sensitive.

      Filter: {"$and": [{"nxtag:tags.label": {"$regex": "^paris", "$options": ""}}, {"$and": [{"ecm:isProxy": null}, {"ecm:primaryType": {"$in": ["T ...

, Query timed out on client side after socketTimeout exceeded
	at org.nuxeo.ecm.core.storage.mongodb.MongoDBRepository.newQueryException(MongoDBRepository.java:652) ~[nuxeo-core-storage-mongodb-10.10-HF49.jar:?]
	at org.nuxeo.ecm.core.storage.mongodb.MongoDBRepository.newQueryTimeoutClient(MongoDBRepository.java:671) ~[nuxeo-core-storage-mongodb-10.10-HF49.jar:?]
	at org.nuxeo.ecm.core.storage.mongodb.MongoDBRepository.queryAndFetch(MongoDBRepository.java:928) ~[nuxeo-core-storage-mongodb-10.10-HF49.jar:?]
	at org.nuxeo.ecm.core.storage.dbs.DBSCachingRepository.queryAndFetch(DBSCachingRepository.java:386) ~[nuxeo-core-storage-dbs-10.10-HF52.jar:?]
	at org.nuxeo.ecm.core.storage.dbs.DBSSession.doQueryAndFetch(DBSSession.java:1626) ~[nuxeo-core-storage-dbs-10.10-HF52.jar:?]
	at org.nuxeo.ecm.core.storage.dbs.DBSSession.queryAndFetch(DBSSession.java:1752) ~[nuxeo-core-storage-dbs-10.10-HF52.jar:?]
	at org.nuxeo.ecm.core.storage.dbs.DBSSession.queryAndFetch(DBSSession.java:169) ~[nuxeo-core-storage-dbs-10.10-HF52.jar:?]
	at sun.reflect.GeneratedMethodAccessor208.invoke(Unknown Source) ~[?:?]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_302]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_302]
	at org.nuxeo.ecm.core.storage.dbs.DBSRepositoryBase$DBSSessionInvoker.invoke(DBSRepositoryBase.java:542) ~[nuxeo-core-storage-dbs-10.10-HF52.jar:?]
	at com.sun.proxy.$Proxy103.queryAndFetch(Unknown Source) ~[?:?]
	at org.nuxeo.ecm.core.api.AbstractSession.queryAndFetch(AbstractSession.java:1271) ~[nuxeo-core-10.10-HF52.jar:?]
	at org.nuxeo.ecm.core.api.AbstractSession.queryAndFetch(AbstractSession.java:1256) ~[nuxeo-core-10.10-HF52.jar:?]
	at org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchUnrestrictedSessionRunner.run(CoreQueryAndFetchUnrestrictedSessionRunner.java:46) ~[nuxeo-platform-query-api-10.10-HF52.jar:?]
	at org.nuxeo.ecm.core.api.UnrestrictedSessionRunner.runUnrestricted(UnrestrictedSessionRunner.java:119) ~[nuxeo-core-api-10.10-HF52.jar:?]
	at org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider.getCurrentPage(CoreQueryAndFetchPageProvider.java:133) ~[nuxeo-platform-query-api-10.10-HF52.jar:?]
	at org.nuxeo.ecm.platform.tag.AbstractTagService.getItems(AbstractTagService.java:289) ~[nuxeo-platform-tag-core-10.10-HF21.jar:?]
	at org.nuxeo.ecm.platform.tag.FacetedTagService.doGetTagSuggestions(FacetedTagService.java:204) ~[nuxeo-platform-tag-core-10.10-HF21.jar:?]
	at org.nuxeo.ecm.platform.tag.AbstractTagService.lambda$getSuggestions$7(AbstractTagService.java:210) ~[nuxeo-platform-tag-core-10.10-HF21.jar:?]
	at org.nuxeo.ecm.core.api.CoreInstance$2.run(CoreInstance.java:206) ~[nuxeo-core-api-10.10-HF52.jar:?]
	at org.nuxeo.ecm.core.api.UnrestrictedSessionRunner.runUnrestricted(UnrestrictedSessionRunner.java:137) ~[nuxeo-core-api-10.10-HF52.jar:?]
	at org.nuxeo.ecm.core.api.CoreInstance.doPrivileged(CoreInstance.java:208) ~[nuxeo-core-api-10.10-HF52.jar:?]
	at org.nuxeo.ecm.platform.tag.AbstractTagService.getSuggestions(AbstractTagService.java:210) ~[nuxeo-platform-tag-core-10.10-HF21.jar:?]

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: