Bug 36168

Summary: remove_unused_authorities.pl timeout error that's not a timeout error
Product: Koha Reporter: Eric Swenson <eric>
Component: Command-line UtilitiesAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: koha, robin
Version: 23.05   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Eric Swenson 2024-02-26 18:47:22 UTC
I have been trying to run remove_unused_authorities.pl and it keep's receiving an error:

authid=306335 type=PERSO_NAME[Timeout] ** [http://172.20.20.23:9200]-[599] Timed out while waiting for socket to become ready for reading, called from sub Search::Elasticsearch::Role::Client::Direct::__ANON__ at /usr/share/koha/lib/Koha/SearchEngine/Elasticsearch/Search.pm line 95. With vars: {'request' => {'ignore' => [],'mime_type' => 'application/json','path' => '/koha_planoisd_biblios/_search','method' => 'GET','serialize' => 'std','body' => {'from' => 0,'query' => {'query_string' => {'query' => '(koha-auth-number:306335)','type' => 'cross_fields','default_operator' => 'AND','fuzziness' => '0','analyze_wildcard' => bless( do{\(my $o = 1)}, 'JSON::PP::Boolean' ),'fields' => ['itemnumber','uri','rtype','music-key','itemtype','identifier-publisher-for-music','notforloan','nal-call-number','llength','itype','language-original','lc-call-number','record-url','author-name-corporate','control-number','local-number','related-title','number-local-acquisition','author','title-key','extent','record-source','copynumber','enumchron','su-geo','material-type','control-number-identifier','renewals','geographic-class','pl','issn','index-term-uncontrolled','language-note','udc-classification','cn-class','date-of-acquisition','title-medium','thematic-number','editor','copydate','datelastseen','ta','ff8-23','cn-prefix','ln','title-cover','stack','materials-specified','ctype','name-geographic','biblioitemnumber','name-and-title','abstract','ff7-01-02','name','acqsource','author-name-personal','stock-number','not-onloan-count','ln-subtitle','cn-item','cross-reference','bio','interest-age-level','lexile-number','title','publisher','nlm-call-number','price','cn-suffix','ff7-01','bgf-number','author-in-order','replacementprice','location','bnb-card-number','author-personal-bibliography','number-legal-deposit','title-abbreviated','cn-bib-sort','note','author-title','date-entered-on-file','index-term-genre','contents','dissertation-information','code-institution','indexed-by','number-natl-biblio','host-item','number-govt-pub','ccode','lc-card-number','conference-name','replacementpricedate','ff8-29','bib-level','title-part','identifier-other','totalissues','title-series','title-collective','title-other-variant','report-number','arp','reserves','corporate-name','date-time-last-modified','microform-generation','subject-name-personal','cn-bib-source','local-note','coded-location-qualifier','other-control-number','homebranch','number-db','restricted','koha-auth-number','provider','datelastborrowed','isbn','withdrawn','reading-grade-level','title-expanded','record-control-number','host-item-number','damaged','curriculum','ln-audio','date-of-publication','lf','classification-source','local-classification','title-uniform','holdingbranch','coden','map-scale','ff7-02','arl','ff7-00','personal-name','issues','title-later','dewey-classification','related-periodical','subject','cn-sort','identifier-standard','interest-grade-level','lost','code-geographic','title-former','barcode'],'lenient' => $VAR1->{'request'}{'body'}{'query'}{'query_string'}{'analyze_wildcard'}}},'size' => 10,'aggregations' => {'author' => {'terms' => {'field' => 'author__facet','size' => '50'}},'su-geo' => {'terms' => {'size' => '50','field' => 'su-geo__facet'}},'ln' => {'terms' => {'size' => '50','field' => 'ln__facet'}},'subject' => {'terms' => {'field' => 'subject__facet','size' => '50'}},'homebranch' => {'terms' => {'field' => 'homebranch__facet','size' => '50'}},'location' => {'terms' => {'field' => 'location__facet','size' => '50'}},'ccode' => {'terms' => {'field' => 'ccode__facet','size' => '50'}},'itype' => {'terms' => {'size' => '50','field' => 'itype__facet'}},'title-series' => {'terms' => {'size' => '50','field' => 'title-series__facet'}}}},'qs' => {'track_total_hits' => 'true'}},'status_code' => 599}
Unable to perform your search. Please try again.

The script then seems to hang and not be able to move forward. I tried running with the authoritycategory flag set to limit the number of authorities to search through, but whenever I run the PERSO_NAME category it gives the same error. I was given the advice that this is most likely caused by a piece of data not being anble to be queried and then that error not being handled by the script. I am happy to try and track down the offending record, but don't know how to start that search. Help would be appreciated. Thank you!