SELECT * FROM cmis:document where 'cmis:contentStreamFileName' != ''
(There are less than 100 small documents on the instance, heap space = 3Gb)
java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOf(Arrays.java:3181) ~[?:1.8.0_201] at java.util.ArrayList.grow(ArrayList.java:265) ~[?:1.8.0_201] at java.util.ArrayList.ensureExplicitCapacity(ArrayList.java:239) ~[?:1.8.0_201] at java.util.ArrayList.ensureCapacityInternal(ArrayList.java:231) ~[?:1.8.0_201] at java.util.ArrayList.add(ArrayList.java:462) ~[?:1.8.0_201] at org.antlr.runtime.CommonTokenStream.fillBuffer(CommonTokenStream.java:116) ~[?:?] at org.antlr.runtime.CommonTokenStream.LT(CommonTokenStream.java:238) ~[?:?] at org.apache.chemistry.opencmis.server.support.query.CmisQlStrictParser.root(CmisQlStrictParser.java:198) ~[?:?] at org.apache.chemistry.opencmis.server.support.query.QueryUtilStrict.parseStatement(QueryUtilStrict.java:61) ~[?:?] at org.apache.chemistry.opencmis.server.support.query.QueryUtilBase.processStatement(QueryUtilBase.java:72) ~[?:?] at org.nuxeo.ecm.core.opencmis.impl.server.CMISQLtoNXQL.getNXQL(CMISQLtoNXQL.java:166) ~[?:?] at org.nuxeo.ecm.core.opencmis.impl.server.NuxeoCmisService.queryProjection(NuxeoCmisService.java:1669) ~[?:?] at org.nuxeo.ecm.core.opencmis.impl.server.NuxeoCmisService.query(NuxeoCmisService.java:1528) ~[?:?] at org.apache.chemistry.opencmis.server.support.wrapper.ConformanceCmisServiceWrapper.query(ConformanceCmisServiceWrapper.java:1218) ~[?:?] at org.apache.chemistry.opencmis.server.impl.browser.DiscoveryService$Query.serve(DiscoveryService.java:83) ~[?:?] at org.apache.chemistry.opencmis.server.shared.Dispatcher.dispatch(Dispatcher.java:92) ~[?:?] at org.apache.chemistry.opencmis.server.impl.browser.CmisBrowserBindingServlet.dispatch(CmisBrowserBindingServlet.java:435) ~[?:?] at org.apache.chemistry.opencmis.server.impl.browser.CmisBrowserBindingServlet.service(CmisBrowserBindingServlet.java:262) ~[?:?] at org.nuxeo.ecm.core.opencmis.bindings.NuxeoCmisBrowserBindingServlet.service(NuxeoCmisBrowserBindingServlet.java:70) ~[?:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[servlet-api-9.0.34.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[catalina-9.0.34.jar:9.0.34] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina-9.0.34.jar:9.0.34] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-websocket-9.0.34.jar:9.0.34] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina-9.0.34.jar:9.0.34] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina-9.0.34.jar:9.0.34] at org.nuxeo.ecm.platform.web.common.requestcontroller.filter.NuxeoThreadTrackerFilter.doFilter(NuxeoThreadTrackerFilter.java:43) ~[?:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina-9.0.34.jar:9.0.34] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina-9.0.34.jar:9.0.34] at org.nuxeo.ecm.platform.web.common.requestcontroller.filter.NuxeoStandbyFilter.doFilter(NuxeoStandbyFilter.java:67) ~[?:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina-9.0.34.jar:9.0.34] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina-9.0.34.jar:9.0.34] at org.nuxeo.ecm.core.management.jtajca.internal.Log4jWebFilter.doFilter(Log4jWebFilter.java:69) ~[?:?]