[InterMine Dev] About the ObjectStoreQueryDurationException
fh293 at cam.ac.uk
Tue Mar 12 16:34:21 GMT 2013
Sorry you had the problem. Postgres will normally take some time to
close the threads, for a large query, it's suppose to take longer, and
it's bad at estimating running time of a query.
It's a bit hard for us to investigate further without accessing your
mine from outside world. Could send us an example of the query?
On 12/03/13 09:22, Chen Yian wrote:
> Hi all,
> Someone constructed an improper query which associated with many
> classes and without any constraint.
> Since the query could be expected to return several million results,
> when it was executed I got the ObjectStoreQueryDurationException finally.
> Though the system threw the Exception and stopped working for the
> query, PostgreSQL was still running.
> These threads occupied all resources for a while and some of them even
> Probably the problem itself is related to PostgreSQL,
> but is there any suggestion for preventing this kind of 'accident'?
> dev mailing list
> dev at intermine.org
More information about the dev