-
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:
-
Team:PLATFORM
-
Sprint:nxplatform #77
-
Story Points:3
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:?]
