RE: Solr 5.4.1 Mergeindexes duplicate rows

2016-05-10 Thread Kalpana
As per Shawn's advice I deleted the index data using http://localhost:8983/solr/Sitecore_SharePoint/update?stream.body=%3Cdelete%3E%3Cquery%3E*:*%3C/query%3E%3C/delete%3E&commit=true and then stopped and started Solr and the duplicates were gone. Will keep a watch! Thanks much! -- View this

RE: Solr 5.4.1 Mergeindexes duplicate rows

2016-05-10 Thread Kalpana
Url merge and still saw duplicates. I can try what you have recommended. Thanks so much!. From: Shawn Heisey-2 [via Lucene] [mailto:ml-node+s472066n4275813...@n3.nabble.com] Sent: Tuesday, May 10, 2016 10:38 AM To: Kalpana Sivanandan Subject: Re: Solr 5.4.1 Mergeindexes duplicate rows On 5/9

Re: Solr 5.4.1 Mergeindexes duplicate rows

2016-05-10 Thread Shawn Heisey
On 5/9/2016 7:55 AM, Kalpana wrote: > Can anyone help me with a merge. Currently I have the two cores already > pulling data from SQL Table based on the query I set up. > > Solr is running > > I also have a third core set up with schema similar to the first two. and > then I wrote this in the url a

Re: Solr 5.4.1 Mergeindexes duplicate rows

2016-05-09 Thread Kalpana
Hello Can anyone help me with a merge. Currently I have the two cores already pulling data from SQL Table based on the query I set up. Solr is running I also have a third core set up with schema similar to the first two. and then I wrote this in the url and hit enter http://localhost:8983/solr/

Re: Solr 5.4.1 Mergeindexes duplicate rows

2016-05-06 Thread Kalpana
Querying on _uniqueKey:9105 returns only one doc from Core1 and 0 from Core2 before the merge -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-5-4-1-Mergeindexes-duplicate-rows-tp4275153p4275174.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Solr 5.4.1 Mergeindexes duplicate rows

2016-05-06 Thread Kalpana
Yes, when I query them separately I do not see duplicates. I am using Solr 5.4.1 I created the core and then browsed to http://localhost:8983/solr/admin/cores?action=mergeindexes&core=Sitecore_SharePoint&srcCore=sitecore_web_index&srcCore=SharePoint_All Thanks -- View this message in context:

Re: Solr 5.4.1 Mergeindexes duplicate rows

2016-05-06 Thread Erick Erickson
My _guess_ is that you somehow hit the merge multiple times and, perhaps, interrupted it thus don't have complete duplicates. If we're all talking about the same thing, what you're seeing doesn't make sense. I'm assuming you're totally sure that a query on _uniqueKey:9105 will return only one do

Re: Solr 5.4.1 Mergeindexes duplicate rows

2016-05-06 Thread Kalpana
Thank you for your reply, I did see the website (reason to use the merge indexes). However, individual cores do not have duplicates and the two cores dont have common records. So I am not sure why there are duplicates. One of them is a sitecore core and the other one is a SQL db. They both have d

Re: Solr 5.4.1 Mergeindexes duplicate rows

2016-05-06 Thread Shawn Heisey
On 5/6/2016 9:47 AM, Kalpana wrote: > I am trying to create a new core by merging two indexes. All of them have > the same schema and data on the cores do not have duplicates. As soon as I > do a merge I see lots of duplicates. I used this for merging : > http://localhost:8983/solr/admin/cores?acti

Solr 5.4.1 Mergeindexes duplicate rows

2016-05-06 Thread Kalpana
Hello I am trying to create a new core by merging two indexes. All of them have the same schema and data on the cores do not have duplicates. As soon as I do a merge I see lots of duplicates. I used this for merging : http://localhost:8983/solr/admin/cores?action=mergeindexes&core=Sitecore_SharePo