2021-01-04 12:55:19.312   --- [io-8080-exec-10]  : Parsing JCR-SQL2 statement: SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC 
2021-01-04 12:55:19.312   --- [io-8080-exec-10]  : cost using filter Filter(query=SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC, path=/contents/dossiers//*) 
2021-01-04 12:55:19.312   --- [io-8080-exec-10]  : cost for reference is Infinity 
2021-01-04 12:55:19.312   --- [io-8080-exec-10]  : cost for property is Infinity 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : cost for nodeType is 5.0 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : found Solr index node at /oak:index/solr 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : looking for plans for paths : [/oak:index/solr] 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : building plan for server OakSolrServer{solrServerConfiguration=RemoteSolrServerConfiguration{solrConfDir='', socketTimeout=3000, connectionTimeout=3000, solrHttpUrls=[http://solr:8983/solr/saman-core], solrZkHost='null', solrCollection='oak', solrShardsNo=2, solrReplicationFactor=2}, solrServerProvider=org.apache.jackrabbit.oak.plugins.index.solr.server.RemoteSolrServerProvider@56885c8e} and configuration OakSolrNodeStateConfiguration{definitionChildren=[server]} 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : 3 matched restrictions for filter Filter(query=SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC, path=/contents/dossiers//*) and configuration OakSolrNodeStateConfiguration{definitionChildren=[server]} 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : index plan { costPerExecution : 1.5, costPerEntry : 0.3, estimatedEntryCount : 0, filter : Filter(query=SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC, path=/contents/dossiers//*), isDelayed : true, isFulltextIndex : true, includesNodeData : true, sortOrder : [{ propertyName : jcr:createdBy, propertyType : UNDEFINED, order : DESCENDING }], definition : null, propertyRestriction : null, pathPrefix : , deprecated : false, supportsPathRestriction : false, logWarningForPathFilterMismatch : false } 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : cost for [/oak:index/solr] of type (solr) with plan [{ costPerExecution : 1.5, costPerEntry : 0.3, estimatedEntryCount : 0, filter : Filter(query=SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC, path=/contents/dossiers//*), isDelayed : true, isFulltextIndex : true, includesNodeData : true, sortOrder : [{ propertyName : jcr:createdBy, propertyType : UNDEFINED, order : DESCENDING }], definition : null, propertyRestriction : null, pathPrefix : , deprecated : false, supportsPathRestriction : false, logWarningForPathFilterMismatch : false }] is 1.50 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : cost for solr is Infinity 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : cost for traverse is 2000.0 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : cost using filter Filter(query=SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC fullText=sam:docNumber:"*123*", path=*) 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : cost for reference is Infinity 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : cost for property is Infinity 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : cost for nodeType is Infinity 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : found Solr index node at /oak:index/solr 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : looking for plans for paths : [/oak:index/solr] 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : building plan for server OakSolrServer{solrServerConfiguration=RemoteSolrServerConfiguration{solrConfDir='', socketTimeout=3000, connectionTimeout=3000, solrHttpUrls=[http://solr:8983/solr/saman-core], solrZkHost='null', solrCollection='oak', solrShardsNo=2, solrReplicationFactor=2}, solrServerProvider=org.apache.jackrabbit.oak.plugins.index.solr.server.RemoteSolrServerProvider@15ed25af} and configuration OakSolrNodeStateConfiguration{definitionChildren=[server]} 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : 2 matched restrictions for filter Filter(query=SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC fullText=sam:docNumber:"*123*", path=*) and configuration OakSolrNodeStateConfiguration{definitionChildren=[server]} 
2021-01-04 12:55:19.313   --- [io-8080-exec-10]  : index plan { costPerExecution : 1.5, costPerEntry : 0.3, estimatedEntryCount : 0, filter : Filter(query=SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC fullText=sam:docNumber:"*123*", path=*), isDelayed : true, isFulltextIndex : true, includesNodeData : true, sortOrder : [], definition : null, propertyRestriction : null, pathPrefix : , deprecated : false, supportsPathRestriction : false, logWarningForPathFilterMismatch : false } 
2021-01-04 12:55:19.314   --- [io-8080-exec-10]  : cost for [/oak:index/solr] of type (solr) with plan [{ costPerExecution : 1.5, costPerEntry : 0.3, estimatedEntryCount : 0, filter : Filter(query=SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC fullText=sam:docNumber:"*123*", path=*), isDelayed : true, isFulltextIndex : true, includesNodeData : true, sortOrder : [], definition : null, propertyRestriction : null, pathPrefix : , deprecated : false, supportsPathRestriction : false, logWarningForPathFilterMismatch : false }] is 1.50 
2021-01-04 12:55:19.314   --- [io-8080-exec-10]  : cost for solr is Infinity 
2021-01-04 12:55:19.314   --- [io-8080-exec-10]  : cost for traverse is Infinity 
2021-01-04 12:55:19.314   --- [io-8080-exec-10]  : cost using filter Filter(query=SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC fullText=sam:docNumber:"*123*", path=*, property=[jcr:uuid=[valueFromTheJoinSelector, is not null]]) 
2021-01-04 12:55:19.314   --- [io-8080-exec-10]  : cost for reference is Infinity 
2021-01-04 12:55:19.314   --- [io-8080-exec-10]  : cost for property is Infinity 
2021-01-04 12:55:19.314   --- [io-8080-exec-10]  : cost for nodeType is Infinity 
2021-01-04 12:55:19.314   --- [io-8080-exec-10]  : found Solr index node at /oak:index/solr 
2021-01-04 12:55:19.314   --- [io-8080-exec-10]  : looking for plans for paths : [/oak:index/solr] 
2021-01-04 12:55:19.314   --- [io-8080-exec-10]  : building plan for server OakSolrServer{solrServerConfiguration=RemoteSolrServerConfiguration{solrConfDir='', socketTimeout=3000, connectionTimeout=3000, solrHttpUrls=[http://solr:8983/solr/saman-core], solrZkHost='null', solrCollection='oak', solrShardsNo=2, solrReplicationFactor=2}, solrServerProvider=org.apache.jackrabbit.oak.plugins.index.solr.server.RemoteSolrServerProvider@7f40eedb} and configuration OakSolrNodeStateConfiguration{definitionChildren=[server]} 
2021-01-04 12:55:19.314   --- [io-8080-exec-10]  : 2 matched restrictions for filter Filter(query=SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC fullText=sam:docNumber:"*123*", path=*, property=[jcr:uuid=[valueFromTheJoinSelector, is not null]]) and configuration OakSolrNodeStateConfiguration{definitionChildren=[server]} 
2021-01-04 12:55:19.314   --- [io-8080-exec-10]  : index plan { costPerExecution : 1.5, costPerEntry : 0.3, estimatedEntryCount : 0, filter : Filter(query=SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC fullText=sam:docNumber:"*123*", path=*, property=[jcr:uuid=[valueFromTheJoinSelector, is not null]]), isDelayed : true, isFulltextIndex : true, includesNodeData : true, sortOrder : [], definition : null, propertyRestriction : null, pathPrefix : , deprecated : false, supportsPathRestriction : false, logWarningForPathFilterMismatch : false } 
2021-01-04 12:55:19.314   --- [io-8080-exec-10]  : cost for [/oak:index/solr] of type (solr) with plan [{ costPerExecution : 1.5, costPerEntry : 0.3, estimatedEntryCount : 0, filter : Filter(query=SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC fullText=sam:docNumber:"*123*", path=*, property=[jcr:uuid=[valueFromTheJoinSelector, is not null]]), isDelayed : true, isFulltextIndex : true, includesNodeData : true, sortOrder : [], definition : null, propertyRestriction : null, pathPrefix : , deprecated : false, supportsPathRestriction : false, logWarningForPathFilterMismatch : false }] is 1.50 
2021-01-04 12:55:19.314   --- [io-8080-exec-10]  : cost for solr is Infinity 
2021-01-04 12:55:19.314   --- [io-8080-exec-10]  : cost for traverse is Infinity 
2021-01-04 12:55:19.314   --- [io-8080-exec-10]  : query execute SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC 
2021-01-04 12:55:19.315   --- [io-8080-exec-10]  : query plan [sam:lkeBaseDossier] as [sam_lkeBaseDossier] /* { costPerExecution : 1.5, costPerEntry : 0.3, estimatedEntryCount : 0, filter : Filter(query=SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC, path=/contents/dossiers//*), isDelayed : true, isFulltextIndex : true, includesNodeData : true, sortOrder : [{ propertyName : jcr:createdBy, propertyType : UNDEFINED, order : DESCENDING }], definition : null, propertyRestriction : null, pathPrefix : , deprecated : false, supportsPathRestriction : false, logWarningForPathFilterMismatch : false } where (isdescendantnode([sam_lkeBaseDossier], [/contents/dossiers])) and ([sam_lkeBaseDossier].[sam:documents] is not null) */ inner join [sam:lkeBaseDocument] as [sam_lkeBaseDossier_sam_documents] /* { costPerExecution : 1.5, costPerEntry : 0.3, estimatedEntryCount : 0, filter : Filter(query=SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC fullText=sam:docNumber:"*123*", path=*, property=[jcr:uuid=[valueFromTheJoinSelector, is not null]]), isDelayed : true, isFulltextIndex : true, includesNodeData : true, sortOrder : [], definition : null, propertyRestriction : null, pathPrefix : , deprecated : false, supportsPathRestriction : false, logWarningForPathFilterMismatch : false } where (contains([sam_lkeBaseDossier_sam_documents].[sam:docNumber], '*123*')) and ([sam_lkeBaseDossier_sam_documents].[jcr:uuid] is not null) */ on [sam_lkeBaseDossier_sam_documents].[jcr:uuid] = [sam_lkeBaseDossier].[sam:documents] 
2021-01-04 12:55:19.315   --- [io-8080-exec-10]  : converting filter Filter(query=SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC, path=/contents/dossiers//*, property=[sam:documents=[is not null]]) 
2021-01-04 12:55:19.315   --- [io-8080-exec-10]  : JCR query SELECT sam_lkeBaseDossier.*   FROM [sam:lkeBaseDossier] AS sam_lkeBaseDossier INNER JOIN [sam:lkeBaseDocument] as sam_lkeBaseDossier_sam_documents ON sam_lkeBaseDossier_sam_documents.[jcr:uuid] = sam_lkeBaseDossier.[sam:documents]  WHERE ((CONTAINS([sam_lkeBaseDossier_sam_documents].[sam:docNumber], cast('*123*' AS string)))) AND ISDESCENDANTNODE(sam_lkeBaseDossier, '/contents/dossiers') ORDER BY [sam_lkeBaseDossier].[jcr:createdBy] DESC has been converted to Solr query q.op=AND&fl=path_exact+score&df=catch_all&rows=10&sort=jcr\:createdBy_string_sort+desc&fq=(jcr\:primaryType:sam\:lkeBaseDossier+)+&fq=path_des:\/contents\/dossiers&fq={!collapse+field%3Dpath_collapsed+min%3Dpath_depth+hint%3Dtop_fc+nullPolicy%3Dexpand}&q=*123*+sam\:documents:*+ 
2021-01-04 12:55:19.315   --- [io-8080-exec-10]  : sending query q.op=AND&fl=path_exact+score&df=catch_all&rows=10&sort=jcr\:createdBy_string_sort+desc&fq=(jcr\:primaryType:sam\:lkeBaseDossier+)+&fq=path_des:\/contents\/dossiers&fq={!collapse+field%3Dpath_collapsed+min%3Dpath_depth+hint%3Dtop_fc+nullPolicy%3Dexpand}&q=*123*+sam\:documents:*+ 
2021-01-04 12:55:19.318   --- [io-8080-exec-10]  : getting response {status=0,QTime=1}