Activity log for bug #1754164

Date Who What changed Old value New value Message
2018-03-07 21:01:45 Jeff Davis bug added bug
2018-03-07 21:03:39 Jeff Davis attachment added rt50488.log https://bugs.launchpad.net/evergreen/+bug/1754164/+attachment/5072241/+files/rt50488.log
2018-03-07 21:04:51 Jeff Davis description EG 2.12.1 and 3.0.3 OpenSRF 2.5 and 3.0 When requesting shelving locations (open-ils.circ.copy_location.retrieve.all) via the HTTP gateway, the request can time out prematurely if you have a large number of shelving locations. To reproduce, add a large number of shelving locations to asset.copy_location (over 5,000 in my test environment). Then, request all shelving locations via the gateway: https://example.com/osrf-gateway-v1?service=open-ils.circ&method=open-ils.circ.copy_location.retrieve.all On my test server, this returns a null response: {"payload":[],"status":200} The open-ils.circ.copy_location.retrieve.all API call itself is not failing: OpenSRF logs show no errors, and the request succeeds via srfsh. However, the gateway logs show a timeout error: Returning NULL from app_request_recv after timeout: open-ils.circ.copy_location.retrieve.all [null] The default timeout value is 60s, but we get our null response in only a few seconds. The gateway request succeeds if we supply a larger timeout value as a URL param, e.g.: https://upstream.catalogue.libraries.coop/osrf-gateway-v1?service=open-ils.circ&method=open-ils.circ.copy_location.retrieve.all&timeout=300 So far I haven't been able to replicate the issue with other API calls that return large chunked responses, but I don't know why there would be anything special about open-ils.circ.copy_location.retrieve.all. EG 2.12.1 and 3.0.3 OpenSRF 2.5 and 3.0 When requesting shelving locations (open-ils.circ.copy_location.retrieve.all) via the HTTP gateway, the request can time out prematurely if you have a large number of shelving locations. To reproduce, add a large number of shelving locations to asset.copy_location (over 5,000 in my test environment). Then, request all shelving locations via the gateway: https://example.com/osrf-gateway-v1?service=open-ils.circ&method=open-ils.circ.copy_location.retrieve.all On my test server, this returns a null response: {"payload":[],"status":200} The open-ils.circ.copy_location.retrieve.all API call itself is not failing: OpenSRF logs show no errors, and the request succeeds via srfsh. However, the gateway logs show a timeout error: Returning NULL from app_request_recv after timeout: open-ils.circ.copy_location.retrieve.all [null] The default timeout value is 60s, but we get our null response in only a few seconds. The gateway request succeeds if we supply a larger timeout value as a URL param, e.g.: https://example.com/osrf-gateway-v1?service=open-ils.circ&method=open-ils.circ.copy_location.retrieve.all&timeout=300 So far I haven't been able to replicate the issue with other API calls that return large chunked responses, but I don't know why there would be anything special about open-ils.circ.copy_location.retrieve.all.
2018-03-15 17:52:39 Jeff Davis tags pullrequest
2018-03-15 17:59:38 Jeff Davis nominated for series evergreen/3.1
2018-03-15 17:59:38 Jeff Davis bug task added evergreen/3.1
2018-03-15 17:59:38 Jeff Davis nominated for series evergreen/2.12
2018-03-15 17:59:38 Jeff Davis bug task added evergreen/2.12
2018-03-15 17:59:38 Jeff Davis nominated for series evergreen/3.0
2018-03-15 17:59:38 Jeff Davis bug task added evergreen/3.0
2018-03-15 17:59:47 Jeff Davis evergreen/2.12: milestone 2.12.11
2018-03-15 17:59:50 Jeff Davis evergreen/3.0: milestone 3.0.5
2018-03-15 17:59:53 Jeff Davis evergreen/3.1: milestone 3.1-rc
2018-03-20 18:44:56 Dan Wells evergreen: milestone 3.1-rc
2018-03-20 18:44:59 Dan Wells bug task deleted evergreen/3.1
2018-03-20 18:45:05 Dan Wells evergreen: importance Undecided Medium
2018-03-21 18:05:15 Bill Erickson tags pullrequest
2018-03-21 23:28:46 Evergreen Bug Maintenance evergreen/2.12: status New Won't Fix
2018-03-21 23:28:49 Evergreen Bug Maintenance evergreen/2.12: milestone 2.12.11
2018-03-22 01:20:45 Evergreen Bug Maintenance evergreen/3.0: milestone 3.0.5 3.0.6
2018-03-27 14:16:41 Evergreen Bug Maintenance evergreen/3.0: milestone 3.0.6
2018-03-27 14:16:43 Evergreen Bug Maintenance evergreen: milestone 3.1-rc
2018-03-27 16:28:17 Jeff Davis nominated for series evergreen/3.1
2018-03-27 16:28:17 Jeff Davis bug task added evergreen/3.1
2019-03-07 15:49:49 Elaine Hardy tags copylocations performance
2019-04-23 17:46:49 Andrea Neiman tags copylocations performance itemlocations performance
2020-08-07 19:40:22 Andrea Neiman evergreen/3.0: status New Won't Fix
2020-08-07 19:40:26 Andrea Neiman evergreen/3.1: status New Won't Fix
2021-10-14 19:38:01 Terran McCanna tags itemlocations performance cat-locations performance