[InterMine Dev] About the ObjectStoreQueryDurationException

Chen Yian chenyian at nibio.go.jp
Tue Mar 12 09:22:20 GMT 2013


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 
hang.
Probably the problem itself is related to PostgreSQL,
but is there any suggestion for preventing this kind of 'accident'?

Best,

Chen






More information about the dev mailing list