[NXP-30281] Add a MongoDB index for Drive getChangeSummary - Nuxeo Issue Tracker

XML

Word

Printable

Details

Type: Bug
Status: Resolved
Priority: Minor
Resolution: Fixed
Affects Version/s: 10.10
Fix Version/s: 10.10-HF49, 11.x, 2021.5
Component/s: Core MongoDB, Nuxeo Drive

Release Notes Summary:
MongoDB indexes have been added to the fields logId, logRepositoryId and logEventDate.
Epic Link:
MongoDB indexes needed in the platform
Tags:
- nxplatform
- platform-review
Team:
PLATFORM
Sprint:
nxplatform #37
Story Points:
2

Description

In order to prevent

Caused by: com.mongodb.MongoQueryException: Query failed with error code 96 and error message 'errmsg: "Sort operation used more than the maximum 33554432 bytes of RAM. Add an index, or specify a smaller limit."' on server vfc-mongodb-0.vfc-mongodb.cust-vfc.svc.cluster.local:27017
    at com.mongodb.operation.FindOperation$1.call(FindOperation.java:735) ~[mongo-jav..
at org.nuxeo.drive.mongodb.MongoDBAuditChangeFinder.queryAuditEntries(MongoDBAuditChangeFinder.java:136) ~[nuxeo-drive-mongodb-10.10-HF42.jar:?]
	at org.nuxeo.drive.service.impl.AuditChangeFinder.getFileSystemChanges(AuditChangeFinder.java:87) ~[nuxeo-drive-core-10.10-HF42.jar:?]
	at org.nuxeo.drive.service.impl.NuxeoDriveManagerImpl.getChangeSummary(NuxeoDriveManagerImpl.java:367) ~[nuxeo-drive-core-10.10-HF42.jar:?]
	at org.nuxeo.drive.operations.NuxeoDriveGetChangeSummary.run(NuxeoDriveGetChangeSummary.java:74) ~[nuxeo-drive-operations-10.10-HF36.jar:?]