From: Pankaj J. (OSU) <jai...@sc...> - 2012-01-27 18:58:10
|
Chris, Can you check. Either there is a cycle issue or ~70 children terms with located_in and partial_overlaps relationship. Pankaj. -------- Original Message -------- Subject: Bad GAZ term? Date: Fri, 27 Jan 2012 18:25:22 +0000 From: Youens-Clark, Ken <kc...@cs...> To: Pankaj Jaiswal (OSU) <jai...@sc...> CC: Vindhya Amarasinghe <ama...@sc...>, "van Buren, Peter" <van...@cs...>, Palitha Dharmawardhana <dha...@sc...> Pankaj, I'm looking into some particularly crippling queries against our servers. Peter forwarded me this one: On Jan 11, 2012, at 10:43 AM, Peter Van Buren wrote: Here's another one that causes issues: 180.76.6.21 www.gramene.org<http://www.gramene.org/> GET /db/ontology/search?id=GAZ:00002564 HTTP/1.1 We just had two of these taking up ~ 20GB or ram. Looking into it, I suspect there is a circular relationship in the term's parentage. Do you have a way of checking this? This page: http://dev.gramene.org/db/ontology/search?id=GAZ:00002564 Never loads because of what looks to me like an infinite recursion while querying for the inheritance tree. -- Ken Youens-Clark kc...@cs...<mailto:kc...@cs...> Ware Lab/CSHL/USDA-ARS |