[Koha-bugs] [Bug 36168] New: remove_unused_authorities.pl timeout error that's not a timeout error

[bugzilla-daemon at bugs.koha-community.org]

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

            Bug ID: 36168
           Summary: remove_unused_authorities.pl timeout error that's not
                    a timeout error
 Change sponsored?: ---
           Product: Koha
           Version: 23.05
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Command-line Utilities
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: eric at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org
                CC: robin at catalyst.net.nz

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!

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.