You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@solr.apache.org by PatentPulse <bm...@patent-pulse.com> on 2022/01/20 10:49:22 UTC

Problem with Join query and FilterCache

Hello,

 

We updated SOLR to 8.11.0 and now we have this message when we do a query
with a JOIN

"q":"{!join from=cat to=id}airbag",

 

We receive this error message:

"error":{
    "metadata":[
      "error-class","org.apache.solr.common.SolrException",
      "root-error-class","org.apache.solr.common.SolrException"],
    "msg":"Using join queries with synchronous filterCache is not supported!
Details can be found in Solr Reference Guide under
'query-settings-in-solrconfig'.",
    "code":510}}

 

I try to search with Google a solution without success.

I saw in my solrconfig the filtercache section but I don't know what I must
change (LRUCache to CaffeineCache)

 

Can someone help me ?

 

Thanks a lot,

 

Best Regards

Bruno

 



-- 
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus

RE: Problem with Join query and FilterCache

Posted by Bruno Mannina <bm...@free.fr>.
Perfect ! it works,

Thanks a lot !

-----Message d'origine-----
De : Andy Lester [mailto:andy@petdance.com] 
Envoyé : jeudi 20 janvier 2022 16:05
À : users@solr.apache.org
Objet : Re: Problem with Join query and FilterCache



> On Jan 20, 2022, at 8:02 AM, Mike Drob <md...@mdrob.com> wrote:
> 
> Yep, you should change from LRUCache to CaffeineCache in your solrconfig.xml


And, the CaffeineCache has to be set as async. It defaults to async, but I added the async=“true” to be explicit in my solrconfig.xml

        <filterCache
            class="solr.CaffeineCache"
            size="5000"
            initialSize="500"
            autowarmCount="100"
            async="true"
            />


-- 
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus


Re: Problem with Join query and FilterCache

Posted by Andy Lester <an...@petdance.com>.

> On Jan 20, 2022, at 8:02 AM, Mike Drob <md...@mdrob.com> wrote:
> 
> Yep, you should change from LRUCache to CaffeineCache in your solrconfig.xml


And, the CaffeineCache has to be set as async. It defaults to async, but I added the async=“true” to be explicit in my solrconfig.xml

        <filterCache
            class="solr.CaffeineCache"
            size="5000"
            initialSize="500"
            autowarmCount="100"
            async="true"
            />

Re: Problem with Join query and FilterCache

Posted by Mike Drob <md...@mdrob.com>.
Yep, you should change from LRUCache to CaffeineCache in your solrconfig.xml

The page that error message refers to is
https://solr.apache.org/guide/8_11/query-settings-in-solrconfig.html#caches

Mike

On Thu, Jan 20, 2022 at 4:50 AM PatentPulse <bm...@patent-pulse.com>
wrote:

> Hello,
>
>
>
> We updated SOLR to 8.11.0 and now we have this message when we do a query
> with a JOIN
>
> "q":"{!join from=cat to=id}airbag",
>
>
>
> We receive this error message:
>
> "error":{
>     "metadata":[
>       "error-class","org.apache.solr.common.SolrException",
>       "root-error-class","org.apache.solr.common.SolrException"],
>     "msg":"Using join queries with synchronous filterCache is not
> supported!
> Details can be found in Solr Reference Guide under
> 'query-settings-in-solrconfig'.",
>     "code":510}}
>
>
>
> I try to search with Google a solution without success.
>
> I saw in my solrconfig the filtercache section but I don't know what I must
> change (LRUCache to CaffeineCache)
>
>
>
> Can someone help me ?
>
>
>
> Thanks a lot,
>
>
>
> Best Regards
>
> Bruno
>
>
>
>
>
> --
> L'absence de virus dans ce courrier électronique a été vérifiée par le
> logiciel antivirus Avast.
> https://www.avast.com/antivirus
>