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 <satya.chaita...@gmail.com> 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 <susheel2...@gmail.com> 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 <satya.chaita...@gmail.com >> > >> 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 >> > >>
