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 Ellery Leung <el...@be-o.com> on 2011/06/03 06:07:02 UTC
RE: solr Invalid Date in Date Math String/Invalid Date String
Hi Erick
Here is the error message:
Fieldtype: tdate (I use the default one in solr schema.xml)
Field value(Index): 2006-12-22T13:52:13Z
Field value(query): [2006-12-22T00:00:00Z TO 2006-12-22T23:59:59Z] <<<
with '[' and ']'
And it generates the result below:
-------Start-------
HTTP ERROR: 500
org.apache.solr.common.SolrException: Invalid Date in Date Math
String:'[2006-12-22T00:00:00Z TO 2006-12'
org.apache.jasper.JasperException: org.apache.solr.common.SolrException:
Invalid Date in Date Math String:'[2006-12-22T00:00:00Z TO 2006-12'
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:4
02)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:464)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:358)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:367)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
at
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:268)
at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126)
at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:
264)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler
.java:1089)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:365)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
at
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerColl
ection.java:211)
at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:11
4)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:285)
at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:502)
at
org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:
835)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:641)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:208)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:378)
at
org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:22
6)
at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:4
42)
Caused by: org.apache.solr.common.SolrException: Invalid Date in Date Math
String:'[2006-12-22T00:00:00Z TO 2006-12'
at org.apache.solr.schema.DateField.parseMath(DateField.java:158)
at
org.apache.solr.analysis.TrieTokenizer.reset(TrieTokenizerFactory.java:101)
at
org.apache.solr.analysis.TrieTokenizer.<init>(TrieTokenizerFactory.java:73)
at
org.apache.solr.analysis.TrieTokenizerFactory.create(TrieTokenizerFactory.ja
va:51)
at
org.apache.solr.analysis.TrieTokenizerFactory.create(TrieTokenizerFactory.ja
va:41)
at org.apache.solr.analysis.TokenizerChain.getStream(TokenizerChain.
java:69)
at
org.apache.solr.analysis.SolrAnalyzer.reusableTokenStream(SolrAnalyzer.java:
74)
at
org.apache.jsp.admin.analysis_jsp._jspService(org.apache.jsp.admin.analysis_
jsp:685)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:80)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:3
73)
... 29 more
Caused by: java.text.ParseException: Unparseable date:
"[2006-12-22T00:00:00Z"
at java.text.DateFormat.parse(Unknown Source)
at org.apache.solr.schema.DateField.parseDate(DateField.java:254)
at org.apache.solr.schema.DateField.parseMath(DateField.java:156)
... 39 more
RequestURI=/solr/i-audience.com-contacts-test/admin/analysis.jsp
Powered by Jetty://
------- End -------
Can you tell me what is the problem?
Thank you very much in advance.
-----Original Message-----
From: Erick Erickson [mailto:erickerickson@gmail.com]
Sent: 2011年5月31日 9:54 下午
To: solr-user@lucene.apache.org; elleryleung@be-o.com
Subject: Re: solr Invalid Date in Date Math String/Invalid Date String
Can we see the results of attaching &debugQuery=on to the query? That
often points out the issue.
I'd expect this form to work:
[2006-12-22T00:00:00Z TO 2006-12-22T23:59:59Z]
Best
Erick
2011/5/27 Ellery Leung <el...@be-o.com>:
> Thank you Mike.
>
> So I understand that now. But what about the other items that have values
> on both size? They don't work at all.
>
>
> -----Original Message-----
> From: Mike Sokolov [mailto:sokolov@ifactory.com]
> Sent: 2011年5月27日 10:23 下午
> To: solr-user@lucene.apache.org
> Cc: alucard001
> Subject: Re: solr Invalid Date in Date Math String/Invalid Date String
>
> The "*" endpoint for range terms wasn't implemented yet in 1.4.1 As a
> workaround, we use very large and very small values.
>
> -Mike
>
> On 05/27/2011 12:55 AM, alucard001 wrote:
>> Hi all
>>
>> I am using SOLR 1.4.1 (according to solr info), but no matter what date
>> field I use (date or tdate) defined in default schema.xml, I cannot do a
>> search in solr-admin analysis.jsp:
>>
>> fieldtype: date(or tdate)
>> fieldvalue(index): 2006-12-22T13:52:13Z (I type it in manually, no
> trailing
>> space)
>> fieldvalue(query):
>>
>> The only success case:
>> 2006-12-22T13:52:13Z
>>
>> All search below are failed:
>> * TO NOW
>> [* TO NOW]
>>
>> 2006-12-22T00:00:00Z TO 2006-12-22T23:59:59Z
>> 2006\-12\-22T00\:00\:00Z TO 2006\-12\-22T23\:59\:59Z
>> [2006-12-22T00:00:00Z TO 2006-12-22T23:59:59Z]
>> [2006\-12\-22T00\:00\:00Z TO 2006\-12\-22T23\:59\:59Z]
>>
>> 2006-12-22T00:00:00.000Z TO 2006-12-22T23:59:59.999Z
>> 2006\-12\-22T00\:00\:00\.000Z TO 2006\-12\-22T23\:59\:59\.999Z
>> [2006-12-22T00:00:00.000Z TO 2006-12-22T23:59:59.999Z]
>> [2006\-12\-22T00\:00\:00\.000Z TO 2006\-12\-22T23\:59\:59\.999Z]
>>
>> 2006-12-22T00:00:00Z TO *
>> 2006\-12\-22T00\:00\:00Z TO *
>> [2006-12-22T00:00:00Z TO *]
>> [2006\-12\-22T00\:00\:00Z TO *]
>>
>> 2006-12-22T00:00:00.000Z TO *
>> 2006\-12\-22T00\:00\:00\.000Z TO *
>> [2006-12-22T00:00:00.000Z TO *]
>> [2006\-12\-22T00\:00\:00\.000Z TO *]
>> (vice versa)
>>
>> I get either:
>> Invalid Date in Date Math String or
>> Invalid Date String
>> error
>>
>> What's wrong with it? Can anyone please help me on that?
>>
>> Thank you.
>>
>> --
>> View this message in context:
>
http://lucene.472066.n3.nabble.com/solr-Invalid-Date-in-Date-Math-String-Inv
> alid-Date-String-tp2991763p2991763.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>
>
RE: solr Invalid Date in Date Math String/Invalid Date String
Posted by Chris Hostetter <ho...@fucit.org>.
: Here is the error message:
:
: Fieldtype: tdate (I use the default one in solr schema.xml)
: Field value(Index): 2006-12-22T13:52:13Z
: Field value(query): [2006-12-22T00:00:00Z TO 2006-12-22T23:59:59Z] <<<
: with '[' and ']'
:
: And it generates the result below:
i think the piece of info people were overlooking here is that you are
describing input to the analysis.jsp page.
you can't enter arbitrary query expressions on this page -- just *values*
for hte analyzer of the specifeid field (or field type)
DateField doesn't know abything about the [... TO ...] syntax -- that is
syntax of the query parser.
all the DateField knows is that what you have entered into the "Field
Value" text box is not a date value, and it is not a date match value
either.
-Hoss