[ckan-dev] CKAN Spatial Query Error

[Adrià Mercader]

Hi Michael,

Some ideas:

Are you using Solr 3.x or 4.x? Did you add the necessary fields to
your Solr schema as described here?

http://docs.ckan.org/projects/ckanext-spatial/en/latest/spatial-search.html#choosing-a-backend-for-the-spatial-search

Have you restarted jetty/tomcat?

Have a look at the logs on /var/log/tomcat7/ or /var/log/jetty/ to see
if there are more clues on the Solr server log

Hope this helps,

Adrià

On 16 March 2015 at 22:10, Michael Speth <spethm at landcareresearch.co.nz> wrote:
> Have have installed solr 4.10.3 on our test ckan instance and are using the
> ckan spatial ext.  When we attempt to do a spatial query, we get the
> following error (from the apache logs) and on the web we get "No datasets
> found".
>
> [Tue Mar 17 11:02:39 2015] [error] 2015-03-17 11:02:39,015 ERROR
> [ckan.controllers.package] Dataset search error: ('SOLR returned an error
> running query: {\\'sort\\': u\\'score desc, metadata_modified desc\\',
> \\'fq\\': [u\\'+dataset_type:dataset capacity:"public" +site_id:"ckan"
> +state:active\\', \\'{!frange incl=false l=0
> u=1}div(mul(mul(max(0,sub(min(183.515625,maxx),max(161.806640625,minx))),max(0,sub(min(-33.6512082992,maxy),max(-47.9310663475,miny)))),2),add(310.001215248,mul(sub(maxy,miny),sub(maxx,minx))))\\'],
> \\'bf\\':
> \\'div(mul(mul(max(0,sub(min(183.515625,maxx),max(161.806640625,minx))),max(0,sub(min(-33.6512082992,maxy),max(-47.9310663475,miny)))),2),add(310.001215248,mul(sub(maxy,miny),sub(maxx,minx))))\\',
> \\'rows\\': 21, \\'facet.field\\': [\\'organization\\', \\'groups\\',
> \\'tags\\', \\'res_format\\', \\'license_id\\'], \\'facet.limit\\':
> \\'50\\', \\'mm\\': \\'2<-1 5<80%\\', \\'defType\\': \\'edismax\\',
> \\'facet.mincount\\': 1, \\'q\\': \\'*:*\\', \\'start\\': 0, \\'wt\\':
> \\'json\\', \\'qf\\': \\'name^4 title^4 tags^2 groups^2 text\\', \\'tie\\':
> \\'0.1\\', \\'facet\\': \\'true\\', \\'fl\\': \\'id validated_data_dict\\',
> \\'fq_list\\': [\\'{!frange incl=false l=0
> u=1}div(mul(mul(max(0,sub(min(183.515625,maxx),max(161.806640625,minx))),max(0,sub(min(-33.6512082992,maxy),max(-47.9310663475,miny)))),2),add(310.001215248,mul(sub(maxy,miny),sub(maxx,minx))))\\']}
> Error: \\'Server Error\\'',)
>
> Any ideas what might be wrong?
> --
> Michael Speth
> DevOps Computer Engineer
> Landcare Research Consultant
>
> ________________________________
>
> Please consider the environment before printing this email
> Warning: This electronic message together with any attachments is
> confidential. If you receive it in error: (i) you must not read, use,
> disclose, copy or retain it; (ii) please contact the sender immediately by
> reply email and then delete the emails.
> The views expressed in this email may not be those of Landcare Research New
> Zealand Limited. http://www.landcareresearch.co.nz
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>