[Bug 32033] New: Cannot rebuild zebra
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32033 Bug ID: 32033 Summary: Cannot rebuild zebra Change sponsored?: --- Product: Koha Version: 22.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: bugs.koha-community.org Assignee: koha-bugs@lists.koha-community.org Reporter: chimesh@gmail.com QA Contact: testopia@bugs.koha-community.org My Koha version is 22.05.06.000 and OS is Debian Buster I tried to manually rebuild koha using sudo koha-rebuild-zebra -f libcat (We are using field 880 to insert transliterate terms) But couldnr rebuil. following error occured Use of uninitialized value $sub6 in pattern match (m//) at /usr/share/koha/lib/K oha/Filter/MARC/Index880InZebra.pm line 77. Use of uninitialized value $sub6 in pattern match (m//) at /usr/share/koha/lib/K oha/Filter/MARC/Index880InZebra.pm line 77. Use of uninitialized value $sub6 in pattern match (m//) at /usr/share/koha/lib/K oha/Filter/MARC/Index880InZebra.pm line 77. Tag "24 " is not a valid tag. at /usr/share/koha/lib/Koha/Filter/MARC/Index880In Zebra.pm line 79. Something went wrong rebuilding biblio indexes for libcat -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32033 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |15187 Severity|enhancement |major CC| |dcook@prosentient.com.au Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15187 [Bug 15187] Adding 880 Fields to index-list in order to Increase Search for ALL non-latin Scripts -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32033 --- Comment #1 from David Cook <dcook@prosentient.com.au> --- It looks like you've got bad data there in your record. Can you share a URL to that record? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32033 --- Comment #2 from Chaminda de Silva <chimesh@gmail.com> --- (In reply to David Cook from comment #1)
It looks like you've got bad data there in your record.
Can you share a URL to that record?
1. How to findout the URL of the particulaar record. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32033 --- Comment #3 from David Cook <dcook@prosentient.com.au> --- (In reply to Chaminda de Silva from comment #2)
1. How to findout the URL of the particulaar record.
Do you mean how do you determine which record is causing the problem? You'll need to do a SQL Report. You could try something like the following: SELECT biblionumber, ExtractValue(metadata,'//datafield[@tag="880" and subfield[@code="6" and substring(text(),1,3)="24 "]]/*') as f880 from biblio_metadata HAVING f880 <> '' Do you have a public OPAC? If you can provide the URL to that OPAC, I can lookup the records once you've given me a biblionumber. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32033 --- Comment #4 from David Cook <dcook@prosentient.com.au> --- (As a side note: I'd copied the regex for this from the Elasticsearch code, but really we should've written it at as "(\d\d\d)" rather than "(...)".) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32033 --- Comment #5 from Chaminda de Silva <chimesh@gmail.com> --- (In reply to David Cook from comment #3)
(In reply to Chaminda de Silva from comment #2)
1. How to findout the URL of the particulaar record.
Do you mean how do you determine which record is causing the problem?
You'll need to do a SQL Report.
You could try something like the following:
SELECT biblionumber, ExtractValue(metadata,'//datafield[@tag="880" and subfield[@code="6" and substring(text(),1,3)="24 "]]/*') as f880 from biblio_metadata HAVING f880 <> ''
Do you have a public OPAC? If you can provide the URL to that OPAC, I can lookup the records once you've given me a biblionumber.
Thank you very much David, I figured out the problem of Tag "24 " is not a valid tag using your SQL Query. It should be Tag "245" not Tag "24 ". -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32033 --- Comment #6 from David Cook <dcook@prosentient.com.au> --- (In reply to Chaminda de Silva from comment #5)
Thank you very much David, I figured out the problem of Tag "24 " is not a valid tag using your SQL Query. It should be Tag "245" not Tag "24 ".
I thought that's what I was saying in my 1st comment. Apologies that I wasn't clearer! Glad you were able to sort it out. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32033 --- Comment #7 from David Cook <dcook@prosentient.com.au> --- Katrin, do you think this should be closed? On one hand, failing to reindex due to one bad record seems suboptimal. On the other hand, if it just warns or silences the error, then it's not obvious there is a problem. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32033 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |WORKSFORME Status|NEW |RESOLVED --- Comment #8 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- That's ok for me, glad it could be resolved. When I tagged you I was not sure if it was related to the recent work on 880 indexing. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org