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: koha-bugs@lists.koha-community.org Reporter: nick@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org 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-call-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.