I wake up this morning to find out that my EJB Timer is now misbehaving I am getting the following exception, does anyone know how i can fix this?
[code]
javax.ejb.TransactionRolledbackLocalException: Exception thrown from bean; nested exception is: com.sun.jdo.api.persistence.support.JDODataStoreException: JDO76400: Got a JDBC SQLException while executing the SQL statement:
SQL statement<select distinct t0."TIMERID", t0."CREATIONTIMERAW", t0."LASTEXPIRATIONRAW", t0."CONTAINERID", t0."OWNERID", t0."STATE", t0."PKHASHCODE", t0."INTERVALDURATION", t0."INITIALEXPIRATIONRAW" from "EJB__TIMER__TBL" t0 where t0."CONTAINERID" = CAST (? AS BIGINT)> with input values:java.lang.Long:77834909659299840.
Please examine the SQLException for more information.
NestedException: java.sql.SQLException: A lock could not be obtained within the time requested
com.sun.jdo.api.persistence.support.JDODataStoreException: JDO76400: Got a JDBC SQLException while executing the SQL statement:
SQL statement<select distinct t0."TIMERID", t0."CREATIONTIMERAW", t0."LASTEXPIRATIONRAW", t0."CONTAINERID", t0."OWNERID", t0."STATE", t0."PKHASHCODE", t0."INTERVALDURATION", t0."INITIALEXPIRATIONRAW" from "EJB__TIMER__TBL" t0 where t0."CONTAINERID" = CAST (? AS BIGINT)> with input values:java.lang.Long:77834909659299840.
Please examine the SQLException for more information.
NestedException: java.sql.SQLException: A lock could not be obtained within the time requested
at com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.throwJDOSqlException(SQLStoreManager.java:645)
at com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.executeQuery(SQLStoreManager.java:479)
at com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.retrieve(SQLStoreManager.java:376)
at com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerImpl.retrieve(PersistenceManagerImpl.java:1127)
at com.sun.jdo.spi.persistence.support.sqlstore.query.QueryImpl.doExecute(QueryImpl.java:689)
at com.sun.jdo.spi.persistence.support.sqlstore.query.QueryImpl.executeWithArray(QueryImpl.java:607)
at com.sun.ejb.containers.TimerBean_2100919770_ConcreteImpl.ejbSelectTimersByContainer(TimerBean_2100919770_ConcreteImpl.java:1598)
at com.sun.ejb.containers.TimerBean.ejbHomeSelectTimersByContainer(TimerBean.java:665)
[/code]
[Message sent by forum member 'tinashechipomho' (tinashechipomho)]
http://forums.java.net/jive/thread.jspa?messageID=231728