[Bug 22705] New: Koha tries and fails to connect to local ElasticSearch while configuration points to a remote one
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22705 Bug ID: 22705 Summary: Koha tries and fails to connect to local ElasticSearch while configuration points to a remote one Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Searching - Elasticsearch Assignee: koha-bugs@lists.koha-community.org Reporter: julian.maurice@biblibre.com Target Milestone: --- Relevant configuration block in $KOHA_CONF: <elasticsearch> <server>elasticsearch5</server> <index_name>koha_master</index_name> </elasticsearch> % misc/search_tools/rebuild_elastic_search.pl -v Indexing biblios [Cxn] ** [http://127.0.0.1:9200]-[599] Could not connect to '127.0.0.1:9200': Connection refused, called from sub Search::Elasticsearch::Role::Client::Direct::__ANON__ at /home/koha/env/master/src/Koha/SearchEngine/Elasticsearch/Indexer.pm line 382. With vars: {'status_code' => 599,'request' => {'serialize' => 'std','method' => 'HEAD','qs' => {},'path' => '/koha_master_biblios','ignore' => [],'body' => undef}} It looks like it is related to the 'Sniff' CxnPool. When I remove this line https://gitlab.com/koha-community/Koha/blob/7e218b81e6f7e4cf8bb8be3aef547cd1... everything works as expected -- 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=22705 --- Comment #1 from Julian Maurice <julian.maurice@biblibre.com> --- Okay, so I re-read https://wiki.koha-community.org/wiki/Elasticsearch and it's clear that the problem comes from the Sniff CxnPool, I changed $KOHA_CONF to use the Static CxnPool, and it works. Shouldn't we use Static as the default CxnPool ? -- 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=22705 Alex Arnaud <alex.arnaud@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |alex.arnaud@biblibre.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22705 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Could this be related to Bug 21974? Just going by keywords :) -- 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=22705 --- Comment #3 from Julian Maurice <julian.maurice@biblibre.com> --- (In reply to Katrin Fischer from comment #2)
Could this be related to Bug 21974? Just going by keywords :)
That is totally related. I'm just complaining about the default value of cxn_pool :) Sniff (Koha's default) works only with a local ES, while Static (Search::Elasticsearch's default) works in most cases. -- 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=22705 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |21974 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21974 [Bug 21974] cxn_pool must be configurable -- 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=22705 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |rel_19_05_candidate CC| |jonathan.druart@bugs.koha-c | |ommunity.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=22705 --- Comment #4 from Julian Maurice <julian.maurice@biblibre.com> --- Created attachment 89781 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=89781&action=edit Bug 22705: Change default value of cxn_pool to 'Static' 'Static' is the default value of Search::Elasticsearch and for a good reason : it works in most cases, unlike the 'Sniff' option -- 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=22705 Julian Maurice <julian.maurice@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Koha tries and fails to |Change default value of |connect to local |Elasticsearch cxn_pool to |ElasticSearch while |'Static' |configuration points to a | |remote one | -- 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=22705 Julian Maurice <julian.maurice@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- 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=22705 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- 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=22705 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #89781|0 |1 is obsolete| | --- Comment #5 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 89897 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=89897&action=edit Bug 22705: Change default value of cxn_pool to 'Static' 'Static' is the default value of Search::Elasticsearch and for a good reason : it works in most cases, unlike the 'Sniff' option To test: 1 - Apply patch 2 - Edit koha-conf.xml 3 - Add '<cxn_pool>Static</cxn_pool>' to the elasticsearch stanza 4 - Restart all the things! 5 - Reindex ES, it works 6 - Set SearchEngine to ES, try searching 7 - It works! Signed-off-by: Nick Clemens <nick@bywatersolutions.com> -- 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=22705 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- 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=22705 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #89897|0 |1 is obsolete| | --- Comment #6 from Chris Cormack <chris@bigballofwax.co.nz> --- Created attachment 90033 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=90033&action=edit Bug 22705: Change default value of cxn_pool to 'Static' 'Static' is the default value of Search::Elasticsearch and for a good reason : it works in most cases, unlike the 'Sniff' option To test: 1 - Apply patch 2 - Edit koha-conf.xml 3 - Add '<cxn_pool>Static</cxn_pool>' to the elasticsearch stanza 4 - Restart all the things! 5 - Reindex ES, it works 6 - Set SearchEngine to ES, try searching 7 - It works! Signed-off-by: Nick Clemens <nick@bywatersolutions.com> Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz> -- 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=22705 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to Master CC| |nick@bywatersolutions.com --- Comment #7 from Nick Clemens <nick@bywatersolutions.com> --- Awesome work all! Pushed to master for 19.05 -- 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=22705 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to Master |Pushed to Stable Version(s)| |19.05.00, 18.11.06 released in| | CC| |martin.renvoize@ptfs-europe | |.com --- Comment #8 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Pushed to 18.11.x for 18.11.06 -- 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=22705 Liz Rea <wizzyrea@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to Stable |RESOLVED CC| |wizzyrea@gmail.com Resolution|--- |FIXED --- Comment #9 from Liz Rea <wizzyrea@gmail.com> --- I'm declining this for the 18.05 track, as there aren't probably many users using ES, and I want people to have a reason to upgrade. You can feel free to try and convince me to do something different. :) Cheers, Liz -- 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=22705 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |26260 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26260 [Bug 26260] elasticsearch>cnx_pool missing in koha-conf-site.xml.in -- 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