« Return to Thread: Derby Error Starting Glassfish

Re: Derby Error Starting Glassfish

by jsexton0 :: Rate this Message:

Yes, I have seen that. But I don't really see a solution there, is there? I understand that this appears to be a timeout, which could mean that something in Glassfish's startup is either taking too long, or is completely blocked.

But what can I do about it?

I do have use of a timer in my application, but this problem happens on startup, even if I remove that EA and restart.

OpenXGroup Inc. wrote:

Have you reviewed this thread?*
http://forums.java.net/jive/message.jspa?messageID=231728*

Please examine the SQLException for more information. NestedException:
java.sql.SQLTransactionRollbackException: A lock could not be obtained
within the time requested

On Fri, May 1, 2009 at 10:30 AM, jsexton0 <jsexton0@gmail.com> wrote:
>
> As my application has grown larger, something that has been working for
> some
> time has started failing while Glassfish is starting up; EJB timers.
> During
> startup, I see the exception below. Following this, timers can not
> function
> as the EJB timer is not available. In addition, I have found that random
> SAs become unavailable and have to be reloaded. Sometimes this issue
> appears to "fix itself" but I have not been able to identify a pattern, and
> it seems to be getting worse. I hope someone has some ideas...
>
> Thanks
>
> JDO74009: Bean 'TimerBean' method ejbSelectAllTimersByOwnerAndState:
> problems running JDOQL query with params [server, 0]
> 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."OWNERID" = CAST (? AS VARCHAR(32672)) and
> t0."STATE" = CAST (? AS INTEGER)> with input
> values:java.lang.String:server,
> java.lang.Integer:0.
> Please examine the SQLException for more information.
> NestedException: java.sql.SQLTransactionRollbackException: 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)

« Return to Thread: Derby Error Starting Glassfish