[Evergreen-dev] 30 second timeout - wide_holds

[Josh Stompro]

Thank you Terran, that sounds like I could be hitting that... I'll add my
info to that bug and give the patch a try.
Josh


On Fri, Nov 18, 2022 at 12:02 PM Terran McCanna <
tmccanna at georgialibraries.org> wrote:

> 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/20221121/8d66f4f7/attachment.htm>