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/<collection>/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 any file sharing service. On a side note, I have observed the UI timing out requests after a certain point even though the actual request is still being processed. In case something like that is happening here, did you try the delete by id as an HTTP request through a curl or Postman? Having said that I would still expect delete by id to execute in reasonable time, so I would start by looking at what is s eating up the CPU in your request.
-Rahul On Sat, Sep 26, 2020 at 4:50 AM Goutham Tholpadi <gtholp...@gmail.com> wrote: > Thanks Dominique! I just tried deleting a single document using its id. I > > tried this: > > <delete> > > <id> id123 </id> > > </delete> > > > > and this: > > <delete> > > <query> id:id123 </query> > > </delete> > > > > 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 this be a CPU under-allocation problem (the Solr > > container has 4 cores allocated to it)? > > > > Thanks > > Goutham > > > > On Fri, Sep 25, 2020 at 7:41 PM Dominique Bejean < > dominique.bej...@eolya.fr> > > wrote: > > > > > 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 <gtholp...@gmail.com> a > > > écrit : > > > > > > > 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 <gtholp...@gmail.com> > > > > wrote: > > > > > > > > > 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 search console again. > > > > > > > > > > I tried using Document Type as XML just now and I see the same > > > behaviour > > > > > as above. > > > > > > > > > > Thanks > > > > > Goutham > > > > > > > > > > On Fri, Sep 25, 2020 at 7:17 AM Rahul Goswami <rahul196...@gmail.com > > > > > > > wrote: > > > > > > > > > >> 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? > > > > >> (<delete><id> uniqueKey:value</id></delete>) > > > > >> 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 1:04 PM Goutham Tholpadi < > gtholp...@gmail.com > > > > > > > > >> wrote: > > > > >> > > > > >> > 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 > > > delete > > > > >> > documents from the Solr console, I get a "Connection to Solr lost" > > > > >> error. I > > > > >> > am trying by navigating to the "Documents" section of the chosen > > > core, > > > > >> > using "Solr Command" as the "Document Type", and entering > something > > > > >> this in > > > > >> > the box below: > > > > >> > <delete> > > > > >> > <query> > > > > >> > field:value > > > > >> > </query> > > > > >> > </delete> > > > > >> > > > > > >> > I tried with the field being the unique key, and otherwise. I also > > > > tried > > > > >> > with values containing wild cards. I got the error in all cases. > > > > >> > > > > > >> > Any pointers on this? > > > > >> > > > > > >> > Thanks > > > > >> > Goutham > > > > >> > > > > > >> > > > > > > > > > > > > > >
