Solr queries slow down over time

Hi, I have around 30M documents in Solr, and I am doing repeated *:* queries with rows=1, and changing start to 0, 1, 2, and so on, in a loop in my script (using pysolr). At the start of the iteration, the calls to Solr were taking less than 1 sec each. After running for a few hours (

Re: Delete from Solr console fails

I spoke too soon. I am getting the "Connection lost" error again. I have never faced this problem when there are a small number of docs in the index. I was wondering if the size of the index (30M docs) has anything to do with this. Thanks Goutham On Fri, Sep 25, 2020 at 9:55 AM Goutham Tholpadi

Re: Delete from Solr console fails

Thanks for your response Rahul! Yes, all the fields I tried with were indexed=true, but it did not work. Btw, when I try to today, I am no longer getting the "Connection lost" error. The delete command returns with status=success, however the document is not actually deleted when I check in the s

Re: Delete from Solr console fails

Goutham, Is the field you are trying to delete by indexed=true in the schema ? If the uniqueKey is indexed=true, does delete by id work for you? ( uniqueKey:value) Also, instead of "Solr Command" if you choose the Document type as "XML" does it make any difference? Rahul On Thu, Sep 24, 2020 at

Delete from Solr console fails

Hi, Setup: We have a stand-alone Solr (v7.2) with around 30 million documents and with 4 cores, 38G of RAM, and a 1TB disk. The documents were not directly indexed but came from a restore of a back from another Solr instance. Problem: Search queries seem to be working fine. However, when I try to

Re: Index Deeply Nested documents and retrieve a full nested document in solr

It is yes to both questions, but I am not sure if they play well together for historical reasons. For storing/parsing original JSON in any (custom) format: https://lucene.apache.org/solr/guide/8_6/transforming-and-indexing-custom-json.html (srcField parameter) For indexing nested children (with na

Index Deeply Nested documents and retrieve a full nested document in solr

Hello Team, Can someone please help to index the below sample json document into Solr. I have following queries on indexing multi level child document. 1. Can we specify names to documents hierarchy such as "therapeuticareas" or "sites" while indexing. 2. How can we index document at mul

fetch streaming expression multiple collections problem

Hello all, When I try to use the "select" streaming expression with multiple collections it works without any problems, like: search( "collection1,collection2", q="*:*", fl="field1,field2", qt="/export", sort="field1 desc" ) but when I try to use the "fetch" expression sim

Re: Solr 8.6.2 text_general

These are field definitions for _text_ and text, your original question was about the fields named "country"/"currency" and whatever type they mapped to. Your text/_text_ field is not actually returned to the browser, because it is "stored=false", so it is most likely a catch-all copyField destina

Re: Solr 8.6.2 text_general

In both it is the same In Solr 8.0.0 In Solr 8.6.2 On Thu, 24 Sep 2020 at 18:33, Alexandre Rafalovitch wrote: > I think that means your field went from multiValued to singleValued. > Double check your schema. Remember that multiValued flag can be set > both on the field itself and on its fie

Re: Solr 8.6.2 text_general

I think that means your field went from multiValued to singleValued. Double check your schema. Remember that multiValued flag can be set both on the field itself and on its fieldType. Regards, Alex P.s. However if your field is supposed to be single-valued, maybe you should treat it as a featur

Solr 8.6.2 text_general

In solr 8.0.0 when running the query the data (type="text_general") was shown in brackets *[ ]* "country":*[*"IN"*]*, "currency":*[*"INR"*]*, "date_c":"2020-08-23T18:30:00Z", "est_cost":0, However, in solr 8.6.2 the query the data (type="text_general") is not showing in brackets [ ] "country":"IN"