ess-dive / docker-metacat

Other
0 stars 0 forks source link

Solr 8.11 returns filterCache error on join query #37

Closed vchendrix closed 2 years ago

vchendrix commented 2 years ago

There is an issue with upgrading to solr 8.11. This issue was found on https://data.ess-dive.lbl.gov/portals/SPRUCE_Experiment/Metrics.

The following query

https://data.ess-dive.lbl.gov/catalog/d1/mn/v2/query/solr/?q={!join%20from=resourceMap%20to=resourceMap}((siteText:%22SPRUCE%20Experiment%22))%20AND%20(-obsoletedBy:*%20AND%20*:*%20AND%20formatType:METADATA)&fq=formatType:DATA%20AND%20-obsoletedBy:*&stats=true&stats.field=size&facet=true&facet.field=formatId&facet.limit=-1&f.formatId.facet.mincount=1&f.formatId.facet.missing=false&f.dateUploaded.facet.missing=true&facet.range=dateUploaded&facet.range.start=1900-01-01T00:00:00.000Z&facet.range.end=2022-02-02T00:03:21.717Z&facet.range.gap=%2B1MONTH&rows=0&wt=json

returns

<error detailCode="Solr server error" errorCode="500" name="ServiceFailure">
<description>Error from server at http://db-solr:8983/solr/dataone: Using join queries with synchronous filterCache is not supported! Details can be found in Solr Reference Guide under 'query-settings-in-solrconfig'.</description>
</error>

More Information

Proposed Solution Might adjust the configuration file in solr.

Current Configuration (solrconfig.xml) See if changeing this to CaffeineCache fixes the issue.

 <filterCache class="solr.FastLRUCache"
                 size="512"
                 initialSize="512"
                 autowarmCount="0"/>
<queryResultCache class="solr.LRUCache"
                      size="512"
                      initialSize="512"
                      autowarmCount="0"/>
<documentCache class="solr.LRUCache"
                   size="512"
                   initialSize="512"
                   autowarmCount="0"/>