Hi Daniel, Thanks so much for your inputs. I tried this with SOLR 6.1.0 fresh data and if i use id field as long, the target site is not able to replay the transaction when we use delete by id. I opened a ticket in JIRA - https://issues.apache.org/jira/browse/SOLR-9394. Below is the exception on the SOLR leader on the target site. Also if i try with delete by query it works and also if i change id to string it works.
Error stacktrace on the target site SOLR node leader:- 2016-08-06 08:09:21.091 ERROR (qtp472654579-2699) [c:collection s:shard1 r:core_node3 x:collection] o.a.s.h.RequestHandlerBase org.apache.solr.common.SolrException: Invalid Number: A@@@@@^L^K0W at org.apache.solr.schema.TrieField.readableToIndexed(TrieField.java:537) at org.apache.solr.update.DeleteUpdateCommand.getIndexedId(DeleteUpdateCommand.java:65) at org.apache.solr.update.processor.DistributedUpdateProcessor.versionDelete(DistributedUpdateProcessor.java:1495) at org.apache.solr.update.processor.CdcrUpdateProcessor.versionDelete(CdcrUpdateProcessor.java:85) at org.apache.solr.update.processor.DistributedUpdateProcessor.processDelete(DistributedUpdateProcessor.java:1154) at org.apache.solr.handler.loader.JavabinLoader.delete(JavabinLoader.java:151) at org.apache.solr.handler.loader.JavabinLoader.parseAndLoadDocs(JavabinLoader.java:112) at org.apache.solr.handler.loader.JavabinLoader.load(JavabinLoader.java:54) at org.apache.solr.handler.UpdateRequestHandler$1.load(UpdateRequestHandler.java:97) at org.apache.solr.handler.ContentStreamHandlerBase.handleRequestBody(ContentStreamHandlerBase.java:69) at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:156) at org.apache.solr.core.SolrCore.execute(SolrCore.java:2036) at org.apache.solr.servlet.HttpSolrCall.execute(HttpSolrCall.java:657) at org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:464) at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:257) at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:208) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1160) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1092) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:213) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:119) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134) at org.eclipse.jetty.server.Server.handle(Server.java:518) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:308) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:244) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95) at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93) at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceAndRun(ExecuteProduceConsume.java:246) at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:156) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:654) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572) at java.lang.Thread.run(Thread.java:745) On Tue, Aug 9, 2016 at 8:55 AM, Daniel Collins <danwcoll...@gmail.com> wrote: > This vaguely rings a bell, though from a long time ago. We had our id > field using the "lowercase" type in Solr, and that broke/changed somewhere > in the 4.x series (we are on 4.8.1 now and it doesn't work there), so we > have to revert to a simple "string" type instead. I know you have a very > different use case, but I don't think its anything to do with CDCR or 6.x, > I think its a "problem" in the 4.x series. You might want to check the 4.x > release notes, and/or try upgrading to 4.10.4 (the latest in the 4.x > series) just to see what the behavior is there, I think it changed > somewhere around 4.4 or 4.6... > > But I'm talking probably 2-3 years ago, so my memory is hazy on this. > > On 9 August 2016 at 08:51, bharath.mvkumar <bharath.mvku...@gmail.com> > wrote: > > > Hi All, > > > > I have an issue with cross data center replication, when we delete the > > document by id from the main site. The target site document is not > deleted. > > I have the id field which is a unique field for my schema which is > > configured as "long". > > > > If i change the type to "string" it works fine. Is there any issue using > > long. Because we migrated from 4.4 to 6.1, and we had the id field as > long. > > Can you please help me with this. Really appreciate your help. > > > > I see the below error on the target site:- > > > > o.a.s.h.RequestHandlerBase org.apache.solr.common.SolrException: > Invalid > > Number: > > at org.apache.solr.schema.TrieField.readableToIndexed( > > TrieField.java:537) > > at > > org.apache.solr.update.DeleteUpdateCommand.getIndexedId( > > DeleteUpdateCommand.java:65) > > at > > org.apache.solr.update.processor.DistributedUpdateProcessor. > versionDelete( > > DistributedUpdateProcessor.java:1495) > > at > > org.apache.solr.update.processor.CdcrUpdateProcessor.versionDelete( > > CdcrUpdateProcessor.java:85) > > > > Thanks, > > Bharath Kumar > > > > > > > > -- > > View this message in context: http://lucene.472066.n3. > > nabble.com/Unique-key-field-type-in-solr-6-1-schema-tp4290895.html > > Sent from the Solr - User mailing list archive at Nabble.com. > > > -- Thanks & Regards, Bharath MV Kumar "Life is short, enjoy every moment of it"
