Comment 27 for bug 1704396

Mike,

We have also not seen any long running queries for these searches. I applied the patch to a training system and executed a few one-hit isbn searches that exhibited the 70 second delay. I did not see any "Error printing XMPP stanza to socket" messages logged.

I've added a doc to the shared folder referenced in comment 13 with the timelog, osrfsys.log entries and ejabberd.log entries for a one-hit isbn search. The osrfsys.log pauses at 12:10:08 and resumes at 12:11:18. Here's the excerpt:

[2017-08-24 12:10:08] open-ils.search [INFO:3474:CStoreEditor.pm:139:150358408346840262] editor[0|0] request en-US open-ils.cstore.direct.biblio.peer_bib_copy_map.search.atomic {"target_copy":5735238}
open-ils.cstore 2017-08-24 12:10:08 [INFO:46670:osrf_application.c:1070:150358408346840262] CALL: open-ils.cstore open-ils.cstore.direct.biblio.peer_bib_copy_map.search.atomic {"target_copy":5735238}
open-ils.cstore 2017-08-24 12:10:08 [INFO:46670:osrf_app_session.c:1177:150358408346840262] [open-ils.cstore] sent 369 bytes of data to <email address hidden>/open-ils.search_drone_at_localhost_3474
open-ils.cstore 2017-08-24 12:10:08 [INFO:46670:osrf_stack.c:163:150358408346840262] Message processing duration 0.001401
[2017-08-24 12:10:08] open-ils.search [INFO:3474:CStoreEditor.pm:139:150358408346840262] editor[0|0] open-ils.cstore.direct.biblio.peer_bib_copy_map.search.atomic: returned 0 result(s)
[2017-08-24 12:10:08] open-ils.search [INFO:3474:Event.pm:64:150358408346840262] Loading events xml file /openils/var/data/ils_events.xml
[2017-08-24 12:11:18] open-ils.circ [INFO:46623:Application.pm:159:150358408346840263] CALL: open-ils.circ open-ils.circ.copy_note.retrieve.all HASH(0x4b00350)
open-ils.cstore 2017-08-24 12:11:18 [INFO:46873:osrf_application.c:1070:150358408346840263] CALL: open-ils.cstore open-ils.cstore.direct.asset.copy_note.search.atomic {"owning_copy":10199236,"pub":"t"}

Here's a direct link to the doc with the complete logs:

https://docs.google.com/document/d/1MG4O9BWu25AcIVcADndV5kzdBho2X_9FqTzFCoi54C4/edit?usp=sharing