You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Joe <jo...@gmail.com> on 2012/06/04 23:12:16 UTC
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.
Re: Unable to delete by range in SOLR
Posted by Joe <jo...@gmail.com>.
Thanks for the response Jack! That wasn't exactly right. But the following
modification does work:
curl "http://myURL/update?commit=true" -H 'Content-type:application/json' -d
'{"delete": {"query":"id:[0 TO 1730887464]"}}'
--
View this message in context: http://lucene.472066.n3.nabble.com/Unable-to-delete-by-range-in-SOLR-tp3987664p3987679.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Unable to delete by range in SOLR
Posted by Jack Krupansky <ja...@basetechnology.com>.
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.