Geoserver CQL file queryCollection limit

Question

I'm using GeoServer 2.9.0 and I need to get some result using CQL_FILTER, intersects between polygon and line String layer, cql query is as follow:

INTERSECTS(geom, collectGeometries(queryCollection('workspace:line_string_layer', 'geom', 'IN(''line_string_layer.23'')')))

The full requested url is

http://IP:8080/MapServer/workspace/wfs?service=WFS&version=1.0.0&request=GetFeature&typeName=workspace:polygon_layer&maxFeatures=500000000&outputFormat=application/json&CQL_FILTER=INTERSECTS(geom,collectGeometries(queryCollection('workspace:line_string_layer','geom','IN(''line_string_layer.23'')')))

But the result return as follow

<?xml version="1.0" encoding="UTF-8"?>
    <ows:ExceptionReport xmlns:ows="http://www.opengis.net/ows/1.1" 
     xmlns:xs="http://www.w3.org/2001/XMLSchema" 
     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.0.0" 
     xsi:schemaLocation="http://www.opengis.net/ows/1.1
     http://IP:8080/workspace/schemas/ows/1.1.0/owsAll.xsd">
     <ows:Exception exceptionCode="NoApplicableCode">
         <ows:ExceptionText>java.lang.IllegalStateException: The query 
              in queryCollection returns too many features, the limit is 
              1000 The query in queryCollection returns too many features, 
              the limit is 1000
         </ows:ExceptionText>
      </ows:Exception>
</ows:ExceptionReport>

How to increase this queryCollection limit or am I doing something wrong?

Answer 1

Something that could be related is documented in http://docs.geoserver.org/stable/en/user/extensions/querylayer/index.html

Memory limits

The queryCollection and collectGeometries functions do not perform a true database-style join. Instead they execute a query against the secondary layer every time they are executed, and load the entire result into memory. The functions thus risk using excessive server memory if the query result set is very large, or if the collected geometries are very large. To prevent impacting server stability there are built-in limits to how much data can be processed:

• at most 1000 features are collected by queryCollection
• at most 37000 coordinates (1MB worth of Coordinate objects) are collected by collectGeometries

These limits can be overridden by setting alternate values for the following parameters (this can be done using JVM system variables, servlet context variables, or enviroment variables):

• QUERY_LAYER_MAX_FEATURES controls the maximum number of features collected by queryCollection
• GEOMETRY_COLLECT_MAX_COORDINATES controls the maximum number of coordinates collected by collectGeometries

However, you seem to use maxFeatures=500000000 and you will probably take a risk by inreasing QUERY_LAYER_MAX_FEATURES to such a high number.