Bug 16248

Summary: ModZebra doesn't update zebraqueue if ES is enabled
Product: Koha Reporter: Tomás Cohen Arazi <tomascohen>
Component: Architecture, internals, and plumbingAssignee: Tomás Cohen Arazi <tomascohen>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: brendan, julian.maurice, kyle
Version: master   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on: 12478    
Bug Blocks: 25710    
Attachments: Bug 16248: ModZebra doesn't update zebraqueue if ES is enabled
Bug 16248: ModZebra doesn't update zebraqueue if ES is enabled
Bug 16248: ModZebra doesn't update zebraqueue if ES is enabled

Description Tomás Cohen Arazi 2016-04-12 18:13:20 UTC
The zebraqueue table should still be populated with updates if ES is enabled, so the Zebra indexer keeps the Z39.50/SRU indexes up to date.

To reproduce:
- Set SearchEngine = Elasticsearch
- Watch for zebraqueue changes
  $ watch -n 0.5 'echo "SELECT COUNT(*) FROM zebraqueue WHERE done=0" | sudo koha-mysql kohadev'
- Call touch_all_biblios.pl to simulate record changes
  $ sudo koha-shell kohadev ; cd kohaclone
  $ perl misc/maintenance/touch_all_biblios.pl -v 
=> FAIL: Notice the watch is not changing the number of records to be indexed.
Comment 1 Tomás Cohen Arazi 2016-04-12 18:37:06 UTC Comment hidden (obsolete)
Comment 2 Chris Cormack 2016-04-12 21:19:06 UTC Comment hidden (obsolete)
Comment 3 Jesse Weaver 2016-04-21 23:13:56 UTC
Created attachment 50549 [details] [review]
Bug 16248: ModZebra doesn't update zebraqueue if ES is enabled

The zebraqueue table should still be populated with updates if ES is enabled, so
the Zebra indexer keeps the Z39.50/SRU indexes up to date.

To test:
- Set SearchEngine = Elasticsearch
- Watch for zebraqueue changes
  $ watch -n 0.5 'echo "SELECT COUNT(*) FROM zebraqueue WHERE done=0" | sudo koha-mysql kohadev'
- Call touch_all_biblios.pl to simulate record changes
  $ sudo koha-shell kohadev ; cd kohaclone
  $ perl misc/maintenance/touch_all_biblios.pl -v
=> FAIL: Notice the watch is not changing the number of records to be indexed.
- Apply the patch
- Call touch_all_biblios.pl to simulate record changes
  $ sudo koha-shell kohadev ; cd kohaclone
  $ perl misc/maintenance/touch_all_biblios.pl -v
=> SUCCESS: The count raises (more than 0) and the zebra indexer picks the updates.
- Sign off

Signed-off-by: Chris <chrisc@catalyst.net.nz>

Signed-off-by: Jesse Weaver <jweaver@bywatersolutions.com>
Comment 4 Brendan Gallagher 2016-04-22 22:54:42 UTC
*waiting for ES to be pushed.
Comment 5 Brendan Gallagher 2016-04-26 21:07:36 UTC
Pushed to Master - Should be in the May 2016 Release.  Thanks!
Comment 6 Julian Maurice 2016-05-16 08:01:44 UTC
Not needed in stable versions, status changed to RESOLVED