Re: indexed vs queried documents count mismatch
I'd try to isolate one of the "extra" documents and see what it looked like. My guess is that your SQL statement is somehow (tm) generating more docs than in the DB. Best, Erick On Thu, Aug 24, 2017 at 12:58 PM, Satya Marivada wrote: > Source is database: 17,920,274 records in db > Indexed documents from admin screen: 17,920,274 > Query the collection: 17,948,826 > > Thanks, > Satya > > On Thu, Aug 24, 2017 at 3:44 PM Susheel Kumar wrote: > >> Does this happen again if you repeat above? How much total docs does DIH >> query/source shows to compare with Solr? >> >> On Thu, Aug 24, 2017 at 3:23 PM, Satya Marivada > > >> wrote: >> >> > Hi, >> > >> > I have a weird situation, when I index the documents from admin console >> by >> > doing "clean, commit and optimize", when the indexing is completed, it >> > showed 17,920,274 documents are indexed. >> > >> > When queried from the solr admin console from the query tab for all the >> > documents in that collection, it shows 17,948,826 documents. It is so >> weird >> > that the query for all documents returns 28552 documents more. >> > >> > Any suggestions/thoughts. >> > >> > Thanks, >> > Satya >> > >>
Re: indexed vs queried documents count mismatch
Source is database: 17,920,274 records in db Indexed documents from admin screen: 17,920,274 Query the collection: 17,948,826 Thanks, Satya On Thu, Aug 24, 2017 at 3:44 PM Susheel Kumar wrote: > Does this happen again if you repeat above? How much total docs does DIH > query/source shows to compare with Solr? > > On Thu, Aug 24, 2017 at 3:23 PM, Satya Marivada > > wrote: > > > Hi, > > > > I have a weird situation, when I index the documents from admin console > by > > doing "clean, commit and optimize", when the indexing is completed, it > > showed 17,920,274 documents are indexed. > > > > When queried from the solr admin console from the query tab for all the > > documents in that collection, it shows 17,948,826 documents. It is so > weird > > that the query for all documents returns 28552 documents more. > > > > Any suggestions/thoughts. > > > > Thanks, > > Satya > > >
Re: indexed vs queried documents count mismatch
Does this happen again if you repeat above? How much total docs does DIH query/source shows to compare with Solr? On Thu, Aug 24, 2017 at 3:23 PM, Satya Marivada wrote: > Hi, > > I have a weird situation, when I index the documents from admin console by > doing "clean, commit and optimize", when the indexing is completed, it > showed 17,920,274 documents are indexed. > > When queried from the solr admin console from the query tab for all the > documents in that collection, it shows 17,948,826 documents. It is so weird > that the query for all documents returns 28552 documents more. > > Any suggestions/thoughts. > > Thanks, > Satya >
indexed vs queried documents count mismatch
Hi, I have a weird situation, when I index the documents from admin console by doing "clean, commit and optimize", when the indexing is completed, it showed 17,920,274 documents are indexed. When queried from the solr admin console from the query tab for all the documents in that collection, it shows 17,948,826 documents. It is so weird that the query for all documents returns 28552 documents more. Any suggestions/thoughts. Thanks, Satya
