https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43639

            Bug ID: 43639
           Summary: Cannot use  ElasticsearchMARCFormat because of too
                    many fields
   Initiative type: ---
        Sponsorship ---
            status:
           Product: Koha
           Version: Main
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Searching - Elasticsearch
          Assignee: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]
  Target Milestone: ---

This was in KTD with ES9.

Set preference ElasticsearchMARCFormat to searchable array.

Reindex

Perform any search.

Boom:
[2026/09/25 16:43:57] [WARN] [Request] ** [http://es:9200]-[400]
[query_shard_exception] failed to create query: field expansion matches too
many fields, limit: 1024, got: 1060, with:
{"index":"koha_kohadev_biblios","index_uuid":"XUtjIIh2TXWiFwf0NaAgqQ"},
[query_shard_exception] failed to create query: field expansion matches too
many fields, limit: 1024, got: 1174, with:
{"index_uuid":"XUtjIIh2TXWiFwf0NaAgqQ","index":"koha_kohadev_biblios"},
[query_shard_exception] failed to create query: field expansion matches too
many fields, limit: 1024, got: 1069, with:
{"index_uuid":"XUtjIIh2TXWiFwf0NaAgqQ","index":"koha_kohadev_biblios"},
[query_shard_exception] failed to create query: field expansion matches too
many fields, limit: 1024, got: 1046, with:
{"index":"koha_kohadev_biblios","index_uuid":"XUtjIIh2TXWiFwf0NaAgqQ"},
[query_shard_exception] failed to create query: field expansion matches too
many fields, limit: 1024, got: 1066, with:
{"index_uuid":"XUtjIIh2TXWiFwf0NaAgqQ","index":"koha_kohadev_biblios"}, called
from sub Search::Elasticsearch::Role::Cxn::process_response at
/kohadevbox/koha/Koha/SearchEngine/Elasticsearch.pm line 56. With vars: {'body'
=> {'error' => {'type' => 'search_phase_execution_exception','root_cause' =>
[{'index_uuid' => 'XUtjIIh2TXWiFwf0NaAgqQ','index' =>
'koha_kohadev_biblios','type' => 'query_shard_exception','reason' => 'failed to
create query: field expansion matches too many fields, limit: 1024, got:
1060'},{'type' => 'query_shard_exception','reason' => 'failed to create query:
field expansion matches too many fields, limit: 1024, got: 1174','index_uuid'
=> 'XUtjIIh2TXWiFwf0NaAgqQ','index' => 'koha_kohadev_biblios'},{'index' =>
'koha_kohadev_biblios','index_uuid' => 'XUtjIIh2TXWiFwf0NaAgqQ','reason' =>
'failed to create query: field expansion matches too many fields, limit: 1024,
got: 1069','type' => 'query_shard_exception'},{'type' =>
'query_shard_exception','reason' => 'failed to create query: field expansion
matches too many fields, limit: 1024, got: 1046','index' =>
'koha_kohadev_biblios','index_uuid' => 'XUtjIIh2TXWiFwf0NaAgqQ'},{'type' =>
'query_shard_exception','reason' => 'failed to create query: field expansion
matches too many fields, limit: 1024, got: 1066','index_uuid' =>
'XUtjIIh2TXWiFwf0NaAgqQ','index' => 'koha_kohadev_biblios'}],'reason' => 'all
shards failed','grouped' => bless( do{\(my $o = 1)}, 'JSON::PP::Boolean'
),'failed_shards' => [{'index' => 'koha_kohadev_biblios','node' =>
'j0qWhv_aT_m6BJl0W0eyRA','shard' => 0,'reason' => {'index_uuid' =>
'XUtjIIh2TXWiFwf0NaAgqQ','index' => 'koha_kohadev_biblios','reason' => 'failed
to create query: field expansion matches too many fields, limit: 1024, got:
1060','caused_by' => {'reason' => 'field expansion matches too many fields,
limit: 1024, got: 1060','type' => 'illegal_argument_exception'},'type' =>
'query_shard_exception'}},{'reason' => {'index' =>
'koha_kohadev_biblios','index_uuid' => 'XUtjIIh2TXWiFwf0NaAgqQ','type' =>
'query_shard_exception','caused_by' => {'reason' => 'field expansion matches
too many fields, limit: 1024, got: 1174','type' =>
'illegal_argument_exception'},'reason' => 'failed to create query: field
expansion matches too many fields, limit: 1024, got: 1174'},'shard' => 1,'node'
=> 'j0qWhv_aT_m6BJl0W0eyRA','index' => 'koha_kohadev_biblios'},{'index' =>
'koha_kohadev_biblios','node' => 'j0qWhv_aT_m6BJl0W0eyRA','reason' => {'type'
=> 'query_shard_exception','caused_by' => {'type' =>
'illegal_argument_exception','reason' => 'field expansion matches too many
fields, limit: 1024, got: 1069'},'reason' => 'failed to create query: field
expansion matches too many fields, limit: 1024, got: 1069','index_uuid' =>
'XUtjIIh2TXWiFwf0NaAgqQ','index' => 'koha_kohadev_biblios'},'shard' =>
2},{'index' => 'koha_kohadev_biblios','shard' => 3,'reason' => {'type' =>
'query_shard_exception','reason' => 'failed to create query: field expansion
matches too many fields, limit: 1024, got: 1046','caused_by' => {'type' =>
'illegal_argument_exception','reason' => 'field expansion matches too many
fields, limit: 1024, got: 1046'},'index_uuid' =>
'XUtjIIh2TXWiFwf0NaAgqQ','index' => 'koha_kohadev_biblios'},'node' =>
'j0qWhv_aT_m6BJl0W0eyRA'},{'index' => 'koha_kohadev_biblios','shard' =>
4,'reason' => {'type' => 'query_shard_exception','reason' => 'failed to create
query: field expansion matches too many fields, limit: 1024, got:
1066','caused_by' => {'type' => 'illegal_argument_exception','reason' => 'field
expansion matches too many fields, limit: 1024, got: 1066'},'index' =>
'koha_kohadev_biblios','index_uuid' => 'XUtjIIh2TXWiFwf0NaAgqQ'},'node' =>
'j0qWhv_aT_m6BJl0W0eyRA'}],'phase' => 'query'},'status' => 400},'request' =>
{'path' => '/koha_kohadev_biblios/_search','body' => {'size' =>
'20','aggregations' => {'holdingbranch' => {'terms' => {'size' => '20','field'
=> 'holdingbranch__facet'}},'su-geo' => {'terms' => {'field' =>
'su-geo__facet','size' => '20'}},'homebranch' => {'terms' => {'size' =>
'20','field' => 'homebranch__facet'}},'author' => {'terms' => {'field' =>
'author__facet','size' => '20'}},'ccode' => {'terms' => {'field' =>
'ccode__facet','size' => '20'}},'itype' => {'terms' => {'size' => '20','field'
=> 'itype__facet'}},'subject' => {'terms' => {'size' => '20','field' =>
'subject__facet'}},'ln' => {'terms' => {'size' => '20','field' =>
'ln__facet'}},'title-series' => {'terms' => {'size' => '20','field' =>
'title-series__facet'}},'location' => {'terms' => {'size' => '20','field' =>
'location__facet'}}},'from' => 0,'sort' => [{'_score' => {'order' =>
'desc'}},{'local-number__sort' => {'order' => 'desc'}}],'query' => {'bool' =>
{'must' => [{'query_string' => {'fields' =>
['record-source','identifier-other','other-control-number','lc-card-number','personal-name','local-number','koha-auth-number','arp','date-entered-on-file','number-natl-biblio','musical-presentation','date-of-publication','host-item','cn-suffix','location','date-of-acquisition','report-number','author-personal-bibliography','nlm-call-number','title-abbreviated','conference-name','stack','subject','publisher','note','title-key','geographic-class','issues','replacementprice','acqsource','cn-bib-sort','bio','cn-class','control-number-identifier','udc-classification','ln-subtitle','title-other-variant','interest-grade-level','rtype','number-legal-deposit','ff7-01-02','map-scale','identifier-publisher-for-music','reading-grade-level','index-term-genre','ta','restricted','geolocation_lon','curriculum','cn-sort','lexile-number','totalissues','title-uniform','withdrawn','geolocation_lat','pl','copynumber','ln','homebranch','isbn','reserves','number-local-acquisition','host-item-number','lc-ca
 
ll-number','name','name-geographic','author-name-corporate','title-series','title-cover','cross-reference','record-control-number','music-key','itemtype','holdingbranch','cn-prefix','biblioitemnumber','extent','issn-all','identifier-standard','local-classification','language-original','microform-generation','llength','copydate','nal-call-number','ff8-23','ctype','number-db','related-periodical','barcode','fingerprint-identifier','provider','title-no-punctuation','arl','replacementpricedate','dewey-classification','bnb-card-number','ccode','cn-item','materials-specified','bib-level','number-govt-pub','su-geo','ff7-01','ff7-00','datelastseen','code-institution','ff7-02','renewals','title','author-name-personal','itemnumber','bgf-number','lf','dissertation-information','abstract','title-collective','damaged','classification-source','lost','subject-name-personal','coded-location-qualifier','author','coden','indexed-by','editor','ln-audio','price','itype','title-former','corporate-name',
 
'author-title','uri','ff8-29','material-type','stock-number','interest-age-level','issn','thematic-number','index-term-uncontrolled','isbn-all','current-publication-frequency','notforloan','code-geographic','title-expanded','author-in-order','not-onloan-count','datelastborrowed','date-time-last-modified','name-and-title','cn-bib-source','title-later','control-number','marc_data_array.*'],'lenient'
=> bless( do{\(my $o = 1)}, 'JSON::PP::Boolean' ),'type' =>
'cross_fields','analyze_wildcard' =>
$VAR1->{'request'}{'body'}{'query'}{'bool'}{'must'}[0]{'query_string'}{'lenient'},'fuzziness'
=> 'auto','query' => '(cat*)','default_operator' => 'AND'}}]}}},'mime_type' =>
'application/json','qs' => {'track_total_hits' => 'true'},'serialize' =>
'std','ignore' => [],'method' => 'GET'},'status_code' => 400}

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to