Hello Saavs, I am 100% sure we are not updating the DB after we index the data. We are specifying the same fields on both queries. Our prod boxes do not have access to QA or DEV, so I would expect a connection error when indexing if this is the case. No connection errors in the logs.
-----Original Message----- From: Savvas-Andreas Moysidis [mailto:savvas.andreas.moysi...@googlemail.com] Sent: Thursday, February 03, 2011 4:26 PM To: solr-user@lucene.apache.org Subject: Re: Index Not Matching Hello, Are you definitely positive your database isn't updated after you index your data? Are you querying against the same field(s) specifying the same criteria both in Solr and in the database? Any chance you might be pointing to a dev/test instance of Solr ? Regards, - Savvas On 3 February 2011 20:17, Esclusa, Will <william.escl...@bonton.com> wrote: > Greetings! > > > > My organization is new to SOLR, so please bare with me. At times, we > experience an out of sync condition between SOLR index files and our > Database. We resolved that by clearing the index file and performing a full > crawl of the database. Last time we noticed an out of sync condition, we > went through our procedure of deleting and crawling, but this time it did > not fix it. > > > > For example, search for swim on the DB and we get 440 products, but yet > SOLR states we have 214 products. Has anyone experience anything like this? > Does anyone have any suggestions on a trace we can turn on? Again, we are > new to SOLR so any help you can provide is greatly appreciated. > > > > Thanks! > > > > Will > > > >