[Bug 31614] New: Add configurable timeout for Zebra connections
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31614 Bug ID: 31614 Summary: Add configurable timeout for Zebra connections Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Searching - Zebra Assignee: koha-bugs@lists.koha-community.org Reporter: dcook@prosentient.com.au Zebra searches that take 30+ seconds will return 0 records to Koha, because the ZOOM connection has an I/O timeout that defaults to 30 seconds. -- 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=31614 --- Comment #1 from David Cook <dcook@prosentient.com.au> --- Ideally, your search wouldn't take longer than 30 seconds, but if you do a weighted search that includes a stopword in a database of over 1,000,000 records... it's not uncommon to have this 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=31614 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |dcook@prosentient.com.au |ity.org | -- 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=31614 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31614 --- Comment #2 from David Cook <dcook@prosentient.com.au> --- Created attachment 140881 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=140881&action=edit Bug 31614: Adds a koha-conf.xml config to set Zebra connection timeout This patch adds <zebra_connection_timeout>30</zebra_connection_timeout> to the koha-conf.xml file. Sometimes, a Zebra search might take longer than 30 seconds. If it does, Koha will say that 0 records have been found. While slow searching is not desirable, it's more desirable to get the result set regardless. Test plan: 0. Apply patch 1. Add <zebra_connection_timeout>.1</zebra_connection_timeout> to your relevant koha-conf.xml file (e.g. /etc/koha/sites/kohadev/koha-conf.xml) 2. echo 'flush_all' | nc -q 1 memcached 11211 3. koha-plack --restart kohadev 4. Go to http://localhost:8081/cgi-bin/koha/catalogue/search.pl?q=test 5. Note that no results are returned 6. Change zebra_connection_timeout to 30 7. echo 'flush_all' | nc -q 1 memcached 11211 8. koha-plack --restart kohadev 9a. Go to http://localhost:8081/cgi-bin/koha/catalogue/search.pl?q=test 9b. Note that 3 results are returned 10. Remove zebra_connection_timeout from koha-conf.xml 11. echo 'flush_all' | nc -q 1 memcached 11211 12. koha-plack --restart kohadev 13a. Go to http://localhost:8081/cgi-bin/koha/catalogue/search.pl?q=test 13b. Note that 3 results are returned 14. Celebrate -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31614 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31614 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #140881|0 |1 is obsolete| | --- Comment #3 from David Nind <david@davidnind.com> --- Created attachment 140965 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=140965&action=edit Bug 31614: Adds a koha-conf.xml config to set Zebra connection timeout This patch adds <zebra_connection_timeout>30</zebra_connection_timeout> to the koha-conf.xml file. Sometimes, a Zebra search might take longer than 30 seconds. If it does, Koha will say that 0 records have been found. While slow searching is not desirable, it's more desirable to get the result set regardless. Test plan: 0. Apply patch 1. Add <zebra_connection_timeout>.1</zebra_connection_timeout> to your relevant koha-conf.xml file (e.g. /etc/koha/sites/kohadev/koha-conf.xml) 2. echo 'flush_all' | nc -q 1 memcached 11211 3. koha-plack --restart kohadev 4. Go to http://localhost:8081/cgi-bin/koha/catalogue/search.pl?q=test 5. Note that no results are returned 6. Change zebra_connection_timeout to 30 7. echo 'flush_all' | nc -q 1 memcached 11211 8. koha-plack --restart kohadev 9a. Go to http://localhost:8081/cgi-bin/koha/catalogue/search.pl?q=test 9b. Note that 3 results are returned 10. Remove zebra_connection_timeout from koha-conf.xml 11. echo 'flush_all' | nc -q 1 memcached 11211 12. koha-plack --restart kohadev 13a. Go to http://localhost:8081/cgi-bin/koha/catalogue/search.pl?q=test 13b. Note that 3 results are returned 14. Celebrate Signed-off-by: David Nind <david@davidnind.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31614 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- QA Contact| |kyle@bywatersolutions.com CC| |kyle@bywatersolutions.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31614 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31614 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #140965|0 |1 is obsolete| | --- Comment #4 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 141516 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=141516&action=edit Bug 31614: Adds a koha-conf.xml config to set Zebra connection timeout This patch adds <zebra_connection_timeout>30</zebra_connection_timeout> to the koha-conf.xml file. Sometimes, a Zebra search might take longer than 30 seconds. If it does, Koha will say that 0 records have been found. While slow searching is not desirable, it's more desirable to get the result set regardless. Test plan: 0. Apply patch 1. Add <zebra_connection_timeout>.1</zebra_connection_timeout> to your relevant koha-conf.xml file (e.g. /etc/koha/sites/kohadev/koha-conf.xml) 2. echo 'flush_all' | nc -q 1 memcached 11211 3. koha-plack --restart kohadev 4. Go to http://localhost:8081/cgi-bin/koha/catalogue/search.pl?q=test 5. Note that no results are returned 6. Change zebra_connection_timeout to 30 7. echo 'flush_all' | nc -q 1 memcached 11211 8. koha-plack --restart kohadev 9a. Go to http://localhost:8081/cgi-bin/koha/catalogue/search.pl?q=test 9b. Note that 3 results are returned 10. Remove zebra_connection_timeout from koha-conf.xml 11. echo 'flush_all' | nc -q 1 memcached 11211 12. koha-plack --restart kohadev 13a. Go to http://localhost:8081/cgi-bin/koha/catalogue/search.pl?q=test 13b. Note that 3 results are returned 14. Celebrate Signed-off-by: David Nind <david@davidnind.com> Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31614 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to master Version(s)| |22.11.00 released in| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31614 --- Comment #5 from Tomás Cohen Arazi <tomascohen@gmail.com> --- Pushed to master for 22.11. Nice work everyone, thanks! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31614 Lucas Gass <lucas@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to master |RESOLVED Resolution|--- |FIXED CC| |lucas@bywatersolutions.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31614 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |srdjan@catalyst.net.nz --- Comment #6 from David Cook <dcook@prosentient.com.au> --- *** Bug 17123 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org