[Evergreen-dev] 30 second timeout - wide_holds

[Terran McCanna]

Could it be related to this?
https://bugs.launchpad.net/evergreen/+bug/1971745



Terran McCanna, PINES Program Manager
------------------------------

Georgia Public Library Service | University System of Georgia

2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341

(404) 235-7138 | tmccanna at georgialibraries.org

http://help.georgialibraries.org | help at georgialibraries.org

<https://www.facebook.com/georgialibraries>
<https://www.twitter.com/georgialibs>
<https://www.instagram.com/georgialibraries/>
<https://www.twitter.com/georgialibs>

Join our email list <http://georgialibraries.org> for stories of Georgia
libraries making an impact in our communities.



On Fri, Nov 18, 2022 at 11:39 AM Josh Stompro via Evergreen-dev <
evergreen-dev at list.evergreen-ils.org> wrote:

> Hello, I setup a 3.9 test system a month or so ago with a copy of our
> production system to get prepared to upgrade.  And when I try to view the
> holdshelf on the new system, for our largest branch, I get no results.
>
> It seems like the request to open-ils.storage.action.live_holds.wide_hash
> is taking 34 seconds for the 450 items on the holdshelf to be processed.
>
> The open-ils-circ call for open-ils.circ.hold.wide_hash.stream is getting
> canceled after 30 seconds.  Can someone help me find where that timeout is
> set, so I can set it to be longer.  I have a memory of finding where that
> timeout was set for our production system, but I'm struggling to find it
> again.
>
> Checked the /openils/conf/*.xml files, and the /etc/apache2/* files, and I
> had a vague memory of it being in the TT2 template config file, but no luck
> there either.
>
> Logs of the request are at:
> https://gist.github.com/stompro/5e43f8ef97989b8a9db822459e5721e5
>
> I'm also planning on looking at an explain analyze of the query,  to see
> if maybe there is an index missing or something along those lines, but
> since this is a less powerful test server, I would still like requests to
> finish even if they take a while when I'm testing.
>
> Thanks
> Josh
>
>
> [image: Company logo]
> *Josh Stompro*
> IT Director
> stomproj at gsuite.larl.org | 218-233-3757 ext. 139 | 218-790-2110
> *Lake Agassiz Regional Library *
> 118 5th ST S
> Moorhead MN 56560
> www.larl.org
> *Our mission is to enrich lives and strengthen communities.*
> _______________________________________________
> Evergreen-dev mailing list
> Evergreen-dev at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20221118/89a08ca8/attachment.htm>