Re: Unable to delete by range in SOLR

Mon, 04 Jun 2012 14:23:06 -0700 

Delete by query.

See:
http://wiki.apache.org/solr/UpdateJSON

   curl "http://myURL/update?commit=true"; -H
'Content-type:application/json' -d '{"delete": {"query":"[* TO 1730887464]"}}' 

-- Jack Krupansky
-----Original Message----- From: Joe 
Sent: Monday, June 04, 2012 5:12 PM
To: solr-user@lucene.apache.org
Subject: Unable to delete by range in SOLR

I have an instance of SOLR 3.6 running, with JSON as the default
updateHandler.

I am able to delete individual documents with the following:

   curl "http://myURL/update?commit=true"; -H
'Content-type:application/json' -d '{"delete": {"id":"1730887464"}}'

What is the right way to delete a range of IDs?

I have tried the following:

   curl "http://myURL/update?commit=true"; -H
'Content-type:application/json' -d '{"delete": {"id":"[* TO 1730887464]"}}'

   curl "http://myURL/update?commit=true"; -H
'Content-type:application/json' -d '{"delete": {"id":"[0 TO 1730887464]"}}'

And I get the following exception. Any help/pointers would be appreciated.
I've looked up:
http://wiki.apache.org/solr/UpdateJSON
http://lucene.apache.org/solr/api/doc-files/tutorial.html
http://wiki.apache.org/solr/UpdateXmlMessages

   <html>
   <head>
   <meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1"/>
   <title>Error 500 For input string: "[* TO 1730887464]"

   java.lang.NumberFormatException: For input string: "[* TO 1730887464]"
           at
java.lang.NumberFormatException.forInputString(NumberFormatException.
java:65)
           at java.lang.Long.parseLong(Long.java:438)
           at java.lang.Long.parseLong(Long.java:478)
           at
org.apache.solr.schema.TrieField.readableToIndexed(TrieField.java:295
)
           at
org.apache.solr.schema.TrieField.toInternal(TrieField.java:307)
           at
org.apache.solr.update.DirectUpdateHandler2.delete(DirectUpdateHandle
r2.java:288)
           at
org.apache.solr.update.processor.RunUpdateProcessor.processDelete(Run
UpdateProcessorFactory.java:68)
           at
org.apache.solr.update.processor.LogUpdateProcessor.processDelete(Log
UpdateProcessorFactory.java:137)
           at
org.apache.solr.handler.JsonLoader.processUpdate(JsonLoader.java:120)
           at org.apache.solr.handler.JsonLoader.load(JsonLoader.java:75)
           at
org.apache.solr.handler.ContentStreamHandlerBase.handleRequestBody(Co
ntentStreamHandlerBase.java:58)
           at
org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandl
erBase.java:129)
           at
org.apache.solr.core.RequestHandlers$LazyRequestHandlerWrapper.handle
Request(RequestHandlers.java:244)
           at org.apache.solr.core.SolrCore.execute(SolrCore.java:1376)
           at
org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter
.java:365)
           at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilte
r.java:260)
           at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1212)
           at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3
99)
           at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav
a:216)
           at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1
82)
           at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:7
66)
           at
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
           at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand
lerCollection.java:230)
           at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.
java:114)
           at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1
52)
           at org.mortbay.jetty.Server.handle(Server.java:326)
           at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:54
2)
           at
org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnectio
n.java:945)
           at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
           at
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
           at
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
           at
org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.
java:228)
           at
org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.j
ava:582)
   </title>
   </head>
   <body>
HTTP ERROR 500

   <p>Problem accessing /solr/update. Reason:
   <pre>    For input string: "[* TO 1730887464]"

   java.lang.NumberFormatException: For input string: "[* TO 1730887464]"
           at
java.lang.NumberFormatException.forInputString(NumberFormatException.
java:65)
           at java.lang.Long.parseLong(Long.java:438)
           at java.lang.Long.parseLong(Long.java:478)
           at
org.apache.solr.schema.TrieField.readableToIndexed(TrieField.java:295
)
           at
org.apache.solr.schema.TrieField.toInternal(TrieField.java:307)
           at
org.apache.solr.update.DirectUpdateHandler2.delete(DirectUpdateHandle
r2.java:288)
           at
org.apache.solr.update.processor.RunUpdateProcessor.processDelete(Run
UpdateProcessorFactory.java:68)
           at
org.apache.solr.update.processor.LogUpdateProcessor.processDelete(Log
UpdateProcessorFactory.java:137)
           at
org.apache.solr.handler.JsonLoader.processUpdate(JsonLoader.java:120)
           at org.apache.solr.handler.JsonLoader.load(JsonLoader.java:75)
           at
org.apache.solr.handler.ContentStreamHandlerBase.handleRequestBody(Co
ntentStreamHandlerBase.java:58)
           at
org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandl
erBase.java:129)
           at
org.apache.solr.core.RequestHandlers$LazyRequestHandlerWrapper.handle
Request(RequestHandlers.java:244)
           at org.apache.solr.core.SolrCore.execute(SolrCore.java:1376)
           at
org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter
.java:365)
           at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilte
r.java:260)
           at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1212)
           at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3
99)
           at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav
a:216)
           at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1
82)
           at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:7
66)
           at
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
           at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand
lerCollection.java:230)
           at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.
java:114)
           at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1
52)
           at org.mortbay.jetty.Server.handle(Server.java:326)
           at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:54
2)
           at
org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnectio
n.java:945)
           at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
           at
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
           at
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
           at
org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.
java:228)
           at
org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.j
ava:582)



--
View this message in context: http://lucene.472066.n3.nabble.com/Unable-to-delete-by-range-in-SOLR-tp3987664.html Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to