[openspending-dev] solr problem during installation and more

Alberto Rodriguez Peon alberto.rodriguez.peon at cern.ch
Wed Aug 7 12:48:53 UTC 2013


Hi all,

I am Alberto Rodríguez, a summer student from CERN, right now working on the development of an API for loading datasets.

I installed Openspending following this tutorial<http://docs.openspending.org/en/latest/install.html> .  The website seems to be working, and I can create datasets but not see the graphs nor the "manage" page. The exception raised is the following:

WebError Traceback:
⇝ SolrException: HTTP code=400, reason=Bad Request
View as:   Interactive<http://127.0.0.1:5000/test1/editor#> (full)<http://127.0.0.1:5000/test1/editor#>  |  Text<http://127.0.0.1:5000/test1/editor#> (full)<http://127.0.0.1:5000/test1/editor#>  |  XML<http://127.0.0.1:5000/test1/editor#> (full)<http://127.0.0.1:5000/test1/editor#>
Module openspending.ui.controllers.editor:37 in index     [http://127.0.0.1:5000/_debug/media/plus.jpg]     <http://127.0.0.1:5000/test1/editor#>  view<http://127.0.0.1:5000/test1/editor#>
>>  <http://127.0.0.1:5000/test1/editor#> c.index_count = solr.dataset_entries(c.dataset.name)
Module openspending.lib.solr_util:78 in dataset_entries     [http://127.0.0.1:5000/_debug/media/plus.jpg]     <http://127.0.0.1:5000/test1/editor#>  view<http://127.0.0.1:5000/test1/editor#>
>>  <http://127.0.0.1:5000/test1/editor#> res = solr.raw_query(q='*:*', fq=f, rows=0, wt='json')
Module solr.core:706 in raw_query     [http://127.0.0.1:5000/_debug/media/plus.jpg]     <http://127.0.0.1:5000/test1/editor#>  view<http://127.0.0.1:5000/test1/editor#>
>>  <http://127.0.0.1:5000/test1/editor#> return self.select.raw(**params)
Module solr.core:822 in raw     [http://127.0.0.1:5000/_debug/media/plus.jpg]     <http://127.0.0.1:5000/test1/editor#>  view<http://127.0.0.1:5000/test1/editor#>
>>  <http://127.0.0.1:5000/test1/editor#> rsp = conn._post(self.selector, request, conn.form_headers)
Module solr.core:639 in _post     [http://127.0.0.1:5000/_debug/media/plus.jpg]     <http://127.0.0.1:5000/test1/editor#>  view<http://127.0.0.1:5000/test1/editor#>
>>  <http://127.0.0.1:5000/test1/editor#> return check_response_status(self.conn.getresponse())
Module solr.core:1096 in check_response_status     [http://127.0.0.1:5000/_debug/media/plus.jpg]     <http://127.0.0.1:5000/test1/editor#>  view<http://127.0.0.1:5000/test1/editor#>
>>  <http://127.0.0.1:5000/test1/editor#> raise ex
SolrException: HTTP code=400, reason=Bad Request


And in the solr console I got:

3722874 [qtp968250425-10] ERROR org.apache.solr.core.SolrCore  – org.apache.solr.common.SolrException: undefined field dataset
    at org.apache.solr.schema.IndexSchema.getDynamicFieldType(IndexSchema.java:1223)
    at org.apache.solr.schema.IndexSchema$SolrQueryAnalyzer.getWrappedAnalyzer(IndexSchema.java:418)
    at org.apache.lucene.analysis.AnalyzerWrapper.initReader(AnalyzerWrapper.java:81)
    at org.apache.lucene.analysis.Analyzer.tokenStream(Analyzer.java:175)
    at org.apache.solr.parser.SolrQueryParserBase.newFieldQuery(SolrQueryParserBase.java:408)
    at org.apache.solr.parser.SolrQueryParserBase.getFieldQuery(SolrQueryParserBase.java:966)
    at org.apache.solr.parser.SolrQueryParserBase.getFieldQuery(SolrQueryParserBase.java:574)
    at org.apache.solr.parser.SolrQueryParserBase.handleQuotedTerm(SolrQueryParserBase.java:779)
    at org.apache.solr.parser.QueryParser.Term(QueryParser.java:404)
    at org.apache.solr.parser.QueryParser.Clause(QueryParser.java:186)
    at org.apache.solr.parser.QueryParser.Query(QueryParser.java:108)
    at org.apache.solr.parser.QueryParser.TopLevelQuery(QueryParser.java:97)
    at org.apache.solr.parser.SolrQueryParserBase.parse(SolrQueryParserBase.java:160)
    at org.apache.solr.search.LuceneQParser.parse(LuceneQParser.java:50)
    at org.apache.solr.search.QParser.getQuery(QParser.java:142)
    at org.apache.solr.handler.component.QueryComponent.prepare(QueryComponent.java:160)
    at org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:187)
    at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:135)
    at org.apache.solr.core.SolrCore.execute(SolrCore.java:1904)
    at org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:659)
    at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:362)
    at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:158)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1419)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:455)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
    at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1075)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:384)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1009)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
    at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:255)
    at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
    at org.eclipse.jetty.server.Server.handle(Server.java:368)
    at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)
    at org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(BlockingHttpConnection.java:53)
    at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:953)
    at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1014)
    at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:861)
    at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
    at org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpConnection.java:72)
    at org.eclipse.jetty.server.bio.SocketConnector$ConnectorEndPoint.run(SocketConnector.java:264)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
    at java.lang.Thread.run(Thread.java:724)


Anyone can help me to fix this? I really don't know why is failing.

By the way, in the tutorial there is one step<http://docs.openspending.org/en/latest/install.html#test-the-install> that allows to import a dataset from the json metadata and the csv file.

That is exactly what we need from the CERN side to push data to Openspending. Could someone explain me how it works internally? This command, executed from an URL, can be the API we need.

Best regards,
Alberto

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/openspending-dev/attachments/20130807/72338e61/attachment.html>


More information about the openspending-dev mailing list