When I add <requestHandler name="/sql" class="org.apache.solr.handler.sql.SQLHandler"> to solrconfig.xml, I cannot even create a new collection:
10/08/2023, 15:43:38 ERROR false CollectionHandlingUtils Error from shard: http://192.168.0.65:7574/solr 10/08/2023, 15:43:38 ERROR false CollectionHandlingUtils Error from shard: http://192.168.0.65:7574/solr 10/08/2023, 15:43:38 ERROR false RequestHandlerBase org.apache.solr.common.SolrException: Error CREATEing SolrCore 'teste_shard1_replica_n7': Unable to create core [teste_shard1_replica_n7] Caused by: org.apache.solr.common.SolrException 10/08/2023, 15:43:38 ERROR false CollectionHandlingUtils Error from shard: http://192.168.0.65:8983/solr 10/08/2023, 15:43:38 ERROR false RequestHandlerBase org.apache.solr.common.SolrException: Error CREATEing SolrCore 'teste_shard2_replica_n2': Unable to create core [teste_shard2_replica_n2] Caused by: org.apache.solr.common.SolrException 10/08/2023, 15:43:38 ERROR false CollectionHandlingUtils Error from shard: http://192.168.0.65:8983/solr 10/08/2023, 15:43:38 ERROR false CollectionHandlingUtils Cleaning up collection [teste]. 10/08/2023, 15:43:38 ERROR false OverseerCollectionMessageHandler Collection: teste operation: create failed Em qui., 10 de ago. de 2023 às 15:41, Kojo <rbsnk...@gmail.com> escreveu: > > I used the command: > /opt/solr-9.0.0/bin/solr -m 20g -e cloud -Dsolr.modules=sql -z > 192.168.0.65:2181 > > A query on the dashboard does not work. > > This is the beggining of the stacktrace: > > > 2023-08-10 18:38:11.682 ERROR (qtp2106165633-31) [c:bv_collection s:shard2 > r:core_node7 x:bv_collection_shard2_replica_n4] o.a.s.s.HttpSolrCall > java.lang.RuntimeException: java.lang.NoClassDefFoundError: > org/apache/solr/common/SolrException => java.lang.RuntimeException: > java.lang.NoClassDefFoundError: org/apache/solr/common/SolrException > at org.apache.solr.servlet.HttpSolrCall.sendError(HttpSolrCall.java:840) > java.lang.RuntimeException: java.lang.NoClassDefFoundError: > org/apache/solr/common/SolrException > at org.apache.solr.servlet.HttpSolrCall.sendError(HttpSolrCall.java:840) > ~[solr-core-9.0.0.jar:9.0.0 a4eb7aa123dc53f8dac74d80b66a490f2d6b4a26 - janhoy > - 2022-05-05 01:00:08] > at org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:641) > ~[solr-core-9.0.0.jar:9.0.0 a4eb7aa123dc53f8dac74d80b66a490f2d6b4a26 - janhoy > - 2022-05-05 01:00:08] > at > org.apache.solr.servlet.SolrDispatchFilter.dispatch(SolrDispatchFilter.java:239) > ~[solr-core-9.0.0.jar:9.0.0 a4eb7aa123dc53f8dac74d80b66a490f2d6b4a26 - > janhoy - 2022-05-05 01:00:08] > at > org.apache.solr.servlet.SolrDispatchFilter.lambda$doFilter$0(SolrDispatchFilter.java:207) > ~[solr-core-9.0.0.jar:9.0.0 a4eb7aa123dc53f8dac74d80b66a490f2d6b4a26 - > janhoy - 2022-05-05 01:00:08] > at > org.apache.solr.servlet.ServletUtils.traceHttpRequestExecution2(ServletUtils.java:257) > ~[solr-core-9.0.0.jar:9.0.0 a4eb7aa123dc53f8dac74d80b66a490f2d6b4a26 - > janhoy - 2022-05-05 01:00:08] > at > org.apache.solr.servlet.ServletUtils.rateLimitRequest(ServletUtils.java:227) > ~[solr-core-9.0.0.jar:9.0.0 a4eb7aa123dc53f8dac74d80b66a490f2d6b4a26 - janhoy > - 2022-05-05 01:00:08] > at > org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:202) > ~[solr-core-9.0.0.jar:9.0.0 a4eb7aa123dc53f8dac74d80b66a490f2d6b4a26 - > janhoy - 2022-05-05 01:00:08] > at > org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:184) > ~[solr-core-9.0.0.jar:9.0.0 a4eb7aa123dc53f8dac74d80b66a490f2d6b4a26 - > janhoy - 2022-05-05 01:00:08] > at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:201) > ~[jetty-servlet-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) > ~[jetty-servlet-9.4.44.v20210927.jar:9.4.44.v20210927] > at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548) > ~[jetty-servlet-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:600) > ~[jetty-security-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) > ~[jetty-servlet-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:191) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.handler.InetAccessHandler.handle(InetAccessHandler.java:177) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:322) > ~[jetty-rewrite-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:763) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > at > org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) > ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927] > > Em qui., 10 de ago. de 2023 às 10:14, Kojo <rbsnk...@gmail.com> escreveu: >> >> I included modules in solrconfig.xml, i thought it was enought. >> >> I will try later and post the result here. >> bin/solr start -e techproducts -Dsolr.modules=sql >> >> >> Thanks! >> >> >> >> Em qui., 10 de ago. de 2023 às 09:40, Eric Pugh >> <ep...@opensourceconnections.com> escreveu: >>> >>> You need to enable the sql module. I suspect you won’t be the first person >>> with this email now that we have added modules. It would be nice if the UI >>> told you that you need to restart Solr with that setting! >>> >>> SQL Query Language :: Apache Solr Reference Guide >>> solr.apache.org >>> >>> >>> bin/solr start -e techproducts -Dsolr.modules=sql >>> >>> >>> >>> >>> On Aug 10, 2023, at 8:36 AM, Kojo <rbsnk...@gmail.com> wrote: >>> >>> Hi, >>> I'm trying to get the SQL query requestHandler up and running using this >>> config: <requestHandler name="/sql" class="solr.SQLHandler">. >>> >>> My setup involves solr-9.0.0 in cloud mode with ZooKeeper. >>> >>> I went through the Solr documentation, but I'm hitting a roadblock with >>> just that. Do you know any other sources that might help? I've already >>> checked out the official Solr documentation here: >>> https://solr.apache.org/guide/solr/latest/query-guide/sql-query.html#configuration >>> >>> Here's what I've tried so far, but sadly, no luck: >>> >>> - Tried a query on the admin page. >>> - Attempted to connect via sqlalchemy-solr. >>> - Gave a shot at sending a request to the _sql/ endpoint. >>> >>> On the config side of things: >>> >>> - Initially, I thought I could get away with no extra config, as per Solr's >>> docs. Supposedly, the /sql request handler should already be good to go in >>> a regular Solr installation. >>> >>> - Then I got a bit fancy and added the request handler config directly into >>> the solrconfig.xml file like this: >>> >>> <requestHandler name="/sql" class="solr.SQLHandler"> >>> <lst name="defaults"> >>> <str name="config">solrconfig.xml</str> >>> </lst> >>> </requestHandler> >>> >>> >>> To solve this puzzle, I tried these moves: >>> >>> Grabbed the solr-core-9.0.0.jar library from >>> /server/solr-webapp/webapp/WEB-INF/lib/ and threw it into >>> <solr_home>/server/lib/. >>> I doubled down and copied the solr-sql-9.0.0.jar from >>> <solr_home>/modules/sql/lib/ to both <solr_home>/server/lib/ and >>> <solr_home>/server/lib/ext/. >>> Oh, and I also tweaked the solrconfig.xml file by sticking in a line to >>> point to the outside library directory: >>> >>> <lib dir="${solr.install.dir:../../../..}/lib/ext/" regex=".*\.jar" /> >>> >>> >>> I'm reaching out to see if I'm on the right track here. If I am, I'm >>> planning to keep poking around and maybe get some error logs to show you >>> later. But if I'm off the mark, your tips or suggestions for other places >>> to look would be awesome. >>> >>> Thanks a bunch for your help! >>> >>> Cheers, >>> Koji >>> >>> >>> _______________________ >>> Eric Pugh | Founder & CEO | OpenSource Connections, LLC | 434.466.1467 | >>> http://www.opensourceconnections.com | My Free/Busy >>> Co-Author: Apache Solr Enterprise Search Server, 3rd Ed >>> This e-mail and all contents, including attachments, is considered to be >>> Company Confidential unless explicitly stated otherwise, regardless of >>> whether attachments are marked as such. >>>
