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 > > >> > > > >> > > > > > >
