ObjectDB ObjectDB

Set timeout for BatchQueryItr

#1

Hello Support,

For an unknow reason, some of my object query never finish ( deadlock maybe ). 

My tomcat temp directory is full of "BatchQueryItr" files.

I can't found the origin of the issue but i wonder if it's possible to put a timeout for too long query.

Regards,

Xirt

edit
delete
#2

Here is the stack trace of blocked threads :

com.objectdb.o.OMF.at ( OMF.java:881 )

com.objectdb.o.OBM.close ( OBM.java:202 )
sun.reflect.GeneratedMethodAccessor1518.invoke ( unknown source )
sun.reflect.DelegatingMethodAccessorImpl.invoke ( DelegatingMethodAccessorImpl.java:43 )
java.lang.reflect.Method.invoke ( Method.java:497 )
org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke ( ExtendedEntityManagerCreator.java:344 )
com.sun.proxy.$Proxy246.close ( unknown source )

edit
delete
#3

You can set a query execution timeout as a query hint.

The many BatchQueryItr files may indicate a complex query on a lot of data with no sufficient indexes.

If there is a deadlock, please post a full thread dump (which should also show the deadlock).

ObjectDB Support
edit
delete

Reply

To post on this website please sign in.