Re: Delete from Solr console fails

2020-10-10 Thread Goutham Tholpadi
Thanks for the response Rahul, and sorry for the delay. This email somehow got missed in my inbox. I am not able to get the thread dump now; here are the other details: - It is stand-alone Solr - I also found later that, while the UI timed out, the request was ultimately processed. In so

Re: Delete from Solr console fails

2020-09-26 Thread Rahul Goswami
You mention high CPU usage...Can you share the thread dump (using jstack) for both the delete by id and delete by query? Also, an output of /solr//schema executed on the host? Lastly, is this standalone Solr or SolrCloud? Attachments won’t make it to the list, so I would recommend sharing a link to

Re: Delete from Solr console fails

2020-09-26 Thread Goutham Tholpadi
Thanks Dominique! I just tried deleting a single document using its id. I tried this: id123 and this: id:id123 In each case, I still get the same "Solr connection lost" error. I checked that the Solr instance has enough RAM (it was using 73% of the RAM), but it was using 110% CPU. Could t

Re: Delete from Solr console fails

2020-09-25 Thread Dominique Bejean
Hi Goutham, I agree with Rahul, avoid large deletebyquery. It you can, prefere one query to get all the ids first than use ids with deletebyid Regards Dominique Le ven. 25 sept. 2020 à 06:50, Goutham Tholpadi a écrit : > I spoke too soon. I am getting the "Connection lost" error again. > > I

Re: Delete from Solr console fails

2020-09-24 Thread Goutham Tholpadi
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

2020-09-24 Thread Goutham Tholpadi
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

2020-09-24 Thread Rahul Goswami
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

2020-09-24 Thread Goutham Tholpadi
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