<div dir="ltr">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.<div><br></div><div>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.</div><div><br></div><div>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.</div><div><br></div><div>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.</div><div><br></div><div>Logs of the request are at:</div><div><a href="https://gist.github.com/stompro/5e43f8ef97989b8a9db822459e5721e5">https://gist.github.com/stompro/5e43f8ef97989b8a9db822459e5721e5</a><br></div><div><br></div><div>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.</div><div><br></div><div>Thanks</div><div>Josh</div><div><br></div><div><br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><table style="padding:0px;margin:10px 0;border:none"><tbody><tr><td style="vertical-align:middle;padding:0 7px 0 0"><img alt="Company logo" height="107" src="https://storage.googleapis.com/signaturesatori/customer-C039u5c5y/images/7DIM6.png" width="125"></td><td style="border-left:3px solid #e8e8e8;padding:7px 0 0 10px">
<div style="font-family:'arial','helvetica',sans-serif;font-size:14px;line-height:17px;font-weight:bold;color:#ee8e16"><span style="color:#000000"><strong>Josh Stompro</strong></span></div>
<div style="font-family:'arial','helvetica',sans-serif;font-size:12px;line-height:14px;font-weight:normal;color:#000000;margin-bottom:10px">IT Director<br>
<a href="mailto:stomproj@gsuite.larl.org" target="_blank"><span style="color:#1b4698">stomproj@gsuite.larl.org</span></a><span style="color:#1b4698"> </span>| 218-233-3757 ext. 139<span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:small;color:rgb(32,33,36)"> </span>| 218-790-2110</div>
<div style="font-family:'arial','helvetica',sans-serif;font-size:12px;line-height:14px;color:#000000"><strong>Lake Agassiz Regional Library </strong></div>
<div style="font-family:'arial','helvetica',sans-serif;font-size:12px;line-height:14px;font-weight:normal;color:#000000;margin-bottom:10px">118 5th ST S<br>Moorhead MN 56560<br>
<a href="http://www.larl.org" target="_blank"><span style="color:#1b4698">www.larl.org</span></a><br>
<em>Our mission is to enrich lives and strengthen communities.</em></div>
</td></tr></tbody></table>
</div></div></div></div></div>