Thanks Antelmo, I'm trying to reproduce this now. -Yonik
On Mon, Feb 19, 2018 at 10:13 AM, Antelmo Aguilar <aagui...@nd.edu> wrote: > Hi all, > > I was wondering if the information I sent is sufficient to look into the > issue. Let me know if you need anything else from me please. > > Thanks, > Antelmo > > On Thu, Feb 15, 2018 at 1:56 PM, Antelmo Aguilar <aagui...@nd.edu> wrote: > >> Hi, >> >> Here are two pastebins. The first is the full complete response with the >> search parameters used. The second is the stack trace from the logs: >> >> https://pastebin.com/rsHvKK63 >> >> https://pastebin.com/8amxacAj >> >> I am not using any custom code or plugins with the Solr instance. >> >> Please let me know if you need anything else and thanks for looking into >> this. >> >> -Antelmo >> >> On Wed, Feb 14, 2018 at 12:56 PM, Yonik Seeley <ysee...@gmail.com> wrote: >> >>> Could you provide the full stack trace containing "Invalid Date >>> String" and the full request that causes it? >>> Are you using any custom code/plugins in Solr? >>> -Yonik >>> >>> >>> On Mon, Feb 12, 2018 at 4:55 PM, Antelmo Aguilar <aagui...@nd.edu> wrote: >>> > Hi, >>> > >>> > I was using the following part of a query to get facet buckets so that I >>> > can use the information in the buckets for some post-processing: >>> > >>> > "json": >>> > "{\"filter\":[\"bundle:pop_sample\",\"has_abundance_data_b: >>> true\",\"has_geodata:true\",\"${project}\"],\"facet\":{\"ter >>> m\":{\"type\":\"terms\",\"limit\":-1,\"field\":\"${term:spec >>> ies_category}\",\"facet\":{\"collection_dates\":{\"type\":\ >>> "terms\",\"limit\":-1,\"field\":\"collection_date\",\"facet\ >>> ":{\"collection\": >>> > {\"type\":\"terms\",\"field\":\"collection_assay_id_s\",\"fa >>> cet\":{\"abnd\":\"sum(div(sample_size_i, >>> > collection_duration_days_i))\"}}}}}}}}" >>> > >>> > Sorry if it is hard to read. Basically what is was doing was getting >>> the >>> > following buckets: >>> > >>> > First bucket will be categorized by "Species category" by default >>> unless we >>> > pass in the request the "term" parameter which we will categories the >>> first >>> > bucket by whatever "term" is set to. Then inside this first bucket, we >>> > create another buckets of the "Collection date" category. Then inside >>> the >>> > "Collection date" category buckets, we would use some functions to do >>> some >>> > calculations and return those calculations inside the "Collection date" >>> > category buckets. >>> > >>> > This query is working fine in Solr 6.2, but I upgraded our instance of >>> Solr >>> > 6.2 to the latest 6.6 version. However it seems that upgrading to Solr >>> 6.6 >>> > broke the above query. Now it complains when trying to create the >>> buckets >>> > of the "Collection date" category. I get the following error: >>> > >>> > Invalid Date String:'Fri Aug 01 00:00:00 UTC 2014' >>> > >>> > It seems that when creating the buckets of a date field, it does some >>> > conversion of the way the date is stored and causes the error to appear. >>> > Does anyone have an idea as to why this error is happening? I would >>> really >>> > appreciate any help. Hopefully I was able to explain my issue well. >>> > >>> > Thanks, >>> > Antelmo >>> >> >>