Re: 500 Exception at regular intervals after upgrading to 9.5.0

2024-02-28 Thread Gus Heck
*Here's the full exception:* * org.apache.solr.common.SolrException: org.apache.solr.client.solrj.SolrServerException* You missed the exception message which would be very useful (line above most likely) On Tue, Feb 27, 2024 at 6:29 AM Henrik Brautaset Aronsen < henrik.aron...@gmail.com> wrote:

Re: Multiple query parsers syntax

2024-02-28 Thread Chris Hostetter
: I tried the following, edismax to search against the description field and : lucene parser to search against the keywords field, but it does not work. : What is wrong? : : host:port/solr/v9/select?q={!edismax qf=description}white roses OR : {!lucene}keywords:(white AND roses)&debug=true The

Re: Multiple query parsers syntax

2024-02-28 Thread Chris Hostetter
: I like Hoss' breakdown in this presentation for query substitution : syntax... :) : : the Lucene/Solr Revolution 2016 presentation by hoss : - see slideshow link at : top... FWIW: If a talk I give is ever recorded, I add link to that video fr

Re: Multiple query parsers syntax

2024-02-28 Thread Robi Petersen
Thanks Hoss! I'd forgotten that link didn't work... I'd just scrolled thru the slides (a long time ago) On Wed, Feb 28, 2024 at 10:25 AM Chris Hostetter wrote: > > : I like Hoss' breakdown in this presentation for query substitution > : syntax... :) > : > : the Lucene/Solr Revolution 2016 prese

RE: [EXTERNAL] Re: Is this list alive? I need help

2024-02-28 Thread Beale, Jim (US-KOP)
I didn't see these responses because they were buried in my clutter folder. We have 12,541,505 docs for calls, 9,144,862 form fills, 53,838 SMS and 12,752 social leads. These are all a single Solr 9.1 cluster of three nodes with PROD and UAT all on a single server. As follows: [cid:image0

Setting up basic authentication in Solr 8.11.1 Standalone

2024-02-28 Thread Hodder, Rick (Chief Information Office - IT)
Hi, I have an existing 8.11.1 standalone installation on a windows server, and I have been asked to make it run under basic authentication. I have created security.json file in the solr home folder used the contents of the sample on Configuring Authentication, Authorization and Audit Logging |

RE: [EXTERNAL] Re: Is this list alive? I need help

2024-02-28 Thread Beale, Jim (US-KOP)
Here is the performance for this query on these nodes. You saw the code in a previous email. http://samisolrcld.aws01.hibu.int:8983/solr/calls/select?indent=true&q.op=OR&fl=business_id,call_id,call_date,call_callerno,caller_name,dialog_merged&q=business_id%3A7016655681%20AND%20call_day:[20230101%

Re: Backtick character in field data breaks streaming query

2024-02-28 Thread Rahul Goswami
Submitted https://github.com/apache/solr/pull/2321 I can't assign reviewers (at least it seems so), so would be great if somebody could please take a look. Thanks. -Rahul On Tue, Feb 27, 2024 at 3:10 PM Rahul Goswami wrote: > Thanks. Submitted https://issues.apache.org/jira/browse/SOLR-17186 >

Re: Setting up basic authentication in Solr 8.11.1 Standalone

2024-02-28 Thread Jan Høydahl
You need a few more permissions in order for that Admin screen to work. Try instead the default security.json generated by bin/solr auth enable (cloud mode): { "authentication":{ "blockUnknown": true, "class":"solr.BasicAuthPlugin", "credentials":{"solr":"cHFNAKbTL930UaGklonJT02g/NVUS

RE: Setting up basic authentication in Solr 8.11.1 Standalone

2024-02-28 Thread Hodder, Rick (Chief Information Office - IT)
Thanks Jan, worked like a charm! Thanks, RICK HODDER Staff Software Engineer Global Specialty The Hartford 83 Wooster Heights Rd. | 2nd floor Danbury, CT, 06810 W: 475-329-6251 Email: richard.hod...@thehartford.com www.thehartford.com www.facebook.com/thehartford twitter.com/thehartford   --

Re: Multiple query parsers syntax

2024-02-28 Thread rajani m
Thank you Hoss, the slides and presentation are gold. Thank you Robi and Mikhail for looking into this one. On Wed, Feb 28, 2024, 1:50 PM Robi Petersen wrote: > Thanks Hoss! I'd forgotten that link didn't work... I'd just scrolled thru > the slides (a long time ago) > > On Wed, Feb 28, 2024 at

Re: [EXTERNAL] Re: Is this list alive? I need help

2024-02-28 Thread Gus Heck
Your description leads me to believe that at worst you have ~20M docs in one index, If the average doc size is 5k or so it sounds like 100GB.. This is smalish and across 3 machines it ought to be fine. Your time 1 values are very slow to begin with. Unfortunately you didn't send us the query, only

RE: [EXTERNAL] Re: Is this list alive? I need help

2024-02-28 Thread Beale, Jim (US-KOP)
I did send the query. Here it is: http://samisolrcld.aws01.hibu.int:8983/solr/calls/select?indent=true&q.op=OR&fl=business_id,call_id,call_date,call_callerno,caller_name,dialog_merged&q=business_id%3A7016655681%20AND%20call_day:[20230101%20TO%2020240101}&group=true&group.field=call_callerno&sort=c

Re: [EXTERNAL] Is this list alive? I need help

2024-02-28 Thread Walter Underwood
What does the CPU utilization look like while that query is executing? If it is using 100% of one CPU, then it is CPU limited. If it is using less than 100% of one CPU, then it is IO limited. Regardless, that is a VERY expensive query. A shared EFS disk is a poor system design for Solr. Each no

Re: [EXTERNAL] Re: Is this list alive? I need help

2024-02-28 Thread Gus Heck
Ah sorry my eyes flew past the long hard to read link straight to the pretty table. Sorry. Yeah so a 1 row grouping query is not a good idea. If you did it paginated with cursor mark you would want to play around with trading off number of requests vs size of request. very likely the optimal s