[Bug 41794] New: Error 500 in http://192.168.1.12:8080/cgi-bin/koha/cataloguing/z3950_search.pl
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41794 Bug ID: 41794 Summary: Error 500 in http://192.168.1.12:8080/cgi-bin/koha/cataloguing/z395 0_search.pl Initiative type: --- Sponsorship --- status: Product: Koha Version: 25.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: koha-bugs@lists.koha-community.org Reporter: egpetridis@yahoo.com QA Contact: testopia@bugs.koha-community.org CC: m.de.rooy@rijksmuseum.nl Created attachment 192677 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=192677&action=edit intranet-access.log When searching z39.50 targets simultaneously, sometimes we get an 500 error. No further information on what target's response makes koha raise the error. What could be done to * make koha report on the targets sucessfully queried, * make koha not stumble when encountering erroneous replies from z39.50 targets * make koha note in the logs the target raising the error. The following logs are not redacted, the search was repeated after clearing logs and doing an init 6, so that logs would be more readable. -- 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=41794 --- Comment #1 from Manos PETRIDIS <egpetridis@yahoo.com> --- Created attachment 192678 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=192678&action=edit intranet-error.log -- 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=41794 --- Comment #2 from Manos PETRIDIS <egpetridis@yahoo.com> --- Created attachment 192679 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=192679&action=edit z3950-error.log File z3950.log is empty therefore cannot be uploaded here. -- 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=41794 Manos PETRIDIS <egpetridis@yahoo.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|enhancement |normal -- 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=41794 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41794 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Please check your configuration for the AdditionalFieldsInZ3950Result system preference. It says there is some invalid code in there. -- 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=41794 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- invalid expression in AdditionalFieldsInZ3950Result(Auth)Search -- 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=41794 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |INVALID Status|NEW |RESOLVED -- 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=41794 --- Comment #5 from Manos PETRIDIS <egpetridis@yahoo.com> --- Created attachment 192810 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=192810&action=edit results example 1 -- 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=41794 --- Comment #6 from Manos PETRIDIS <egpetridis@yahoo.com> --- Created attachment 192811 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=192811&action=edit results example 2 -- 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=41794 --- Comment #7 from Manos PETRIDIS <egpetridis@yahoo.com> --- Created attachment 192812 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=192812&action=edit results example 3 -- 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=41794 Manos PETRIDIS <egpetridis@yahoo.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|INVALID |--- Status|RESOLVED |REOPENED --- Comment #8 from Manos PETRIDIS <egpetridis@yahoo.com> --- Thank you for the time and attention! I failed to notice the pointer to the error in the logs. I beg to differ however, the issue is neither invalid nor resolved. AdditionalFieldsInZ3950Result value is "022$a, 040$a, 082$a2, 092$a2, 245$abc, 247$a, 260$abc, 440$a, 500a, 600$a, 650$avxyz2, 651$avxyz2". Which part is erroneous, and why? Are any of these fields noted in a do-not-use list somewhere in koha documentation? If indeed the value above was an "invalid expression", then we wouldn't get any results. Please note attached examples of result pages. It seems that some servers/targets include garbage/erroneous data in their replies, and koha is unable to report the fact, recover and proceed to the next server in the list. In order to make things clearer, one may * make koha report on the targets sucessfully queried, * make koha not stumble when encountering erroneous replies from z39.50 targets * make koha note in the logs the target raising the error. You may recreate the error by querying LOC for title "koha" or keyword "koha", using the AdditionalFieldsInZ3950Result value above. -- 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=41794 --- Comment #9 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- (In reply to Manos PETRIDIS from comment #8)
Thank you for the time and attention! I failed to notice the pointer to the error in the logs. I beg to differ however, the issue is neither invalid nor resolved.
AdditionalFieldsInZ3950Result value is "022$a, 040$a, 082$a2, 092$a2, 245$abc, 247$a, 260$abc, 440$a, 500a, 600$a, 650$avxyz2, 651$avxyz2". Which part is erroneous, and why? Are any of these fields noted in a do-not-use list somewhere in koha documentation?
You are missing the $ for 500a. The error tells you that too: Breeding: invalid expression in AdditionalFieldsInZ3950Result(Auth)Search: 500a
If indeed the value above was an "invalid expression", then we wouldn't get any results. Please note attached examples of result pages.
Can you please fix that and retry? -- 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=41794 --- Comment #10 from Manos PETRIDIS <egpetridis@yahoo.com> --- Created attachment 192947 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=192947&action=edit z39.50 search result page, showing 500$a info AdditionalFieldsInZ3950ResultSearch value now is "022$a, 040$a, 082$a2, 092$a2, 245$abc, 247$a, 260$abc, 440$a, 500$a, 600$a, 650$avxyz2, 651$avxyz2". This is reflected in image #4, where we can see that field 500$a is shown in the results, when searching against known "safe" targets. -- 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=41794 --- Comment #11 from Manos PETRIDIS <egpetridis@yahoo.com> --- Still however, when I search for "koha" on LOC, I get error 500. Same search, having cleared AdditionalFieldsInZ3950ResultSearch still brings up error 500. Previous attachments updated with the current logs. -- 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=41794 Manos PETRIDIS <egpetridis@yahoo.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #192677|0 |1 is obsolete| | --- Comment #12 from Manos PETRIDIS <egpetridis@yahoo.com> --- Created attachment 192948 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=192948&action=edit Intranet access log -- 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=41794 --- Comment #13 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- (In reply to Manos PETRIDIS from comment #11)
Still however, when I search for "koha" on LOC, I get error 500. Same search, having cleared AdditionalFieldsInZ3950ResultSearch still brings up error 500. Previous attachments updated with the current logs.
LOC recently switched systems, we had some other reports about trouble with search. Not sure if that is something we can solve apart from a nicer error. -- 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=41794 Manos PETRIDIS <egpetridis@yahoo.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #192678|0 |1 is obsolete| | --- Comment #14 from Manos PETRIDIS <egpetridis@yahoo.com> --- Created attachment 192949 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=192949&action=edit intranet error log -- 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=41794 --- Comment #15 from Manos PETRIDIS <egpetridis@yahoo.com> --- Created attachment 192950 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=192950&action=edit Apache error log -- 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=41794 --- Comment #16 from Manos PETRIDIS <egpetridis@yahoo.com> --- Created attachment 192951 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=192951&action=edit OPAC access log -- 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=41794 --- Comment #17 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- U+3BC from the logs is "GREEK SMALL LETTER MU" - could you check if the same error appears with the English GUI to rule out a translation issue? -- 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=41794 --- Comment #18 from Manos PETRIDIS <egpetridis@yahoo.com> --- Same error appears having selected English (en) interface. Tried to modify /usr/share/local/lib/C4/Breeding.pm so that it would write to a log in /tmp just before querying each z39.50 target, but I have still to get an output. -- 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=41794 --- Comment #19 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- Error 500 in http://192.168.1.12:8080/cgi-bin/koha/cataloguing/z3950_search.pl 192.168 is a private IP range, right? -- 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=41794 --- Comment #20 from Manos PETRIDIS <egpetridis@yahoo.com> --- Correct, 192.168.0.0 are private networks, the newer logs however were created accessing the server's external address. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org