[InterMine Dev] About the ObjectStoreQueryDurationException
chenyian at nibio.go.jp
Tue Mar 12 09:22:20 GMT 2013
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'?
More information about the dev