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 < [email protected]> 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 | [email protected] > > http://help.georgialibraries.org | [email protected] > > <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 < > [email protected]> 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 >> [email protected] | 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 >> [email protected] >> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev >> >
_______________________________________________ Evergreen-dev mailing list [email protected] http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev
