« Return to Thread: RE: Derby Error Starting Glassfish

RE: Derby Error Starting Glassfish

by Manfred Riem :: Rate this Message:

Reply to Author | View in Thread

Looks like the database you are using to store the EJB timers is
havinh problems. You might want to have a look at that.

> -------- Original Message --------
> Subject: [entpack] Derby Error Starting Glassfish
> From: jsexton0 <jsexton0@...>
> Date: Fri, May 01, 2009 8:30 am
> To: nbentpack@...
>
>
> 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)
>         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:1118)
>         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.ejbSelectAllTimersByOwnerAndState(TimerBean_2100919770_ConcreteImpl.java:1700)
>         at
> com.sun.ejb.containers.TimerBean.ejbHomeSelectAllActiveTimersOwnedByThisServer(TimerBean.java:709)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at
> com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1067)
>         at
> com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:176)
>         at
> com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2895)
>         at
> com.sun.ejb.containers.EJBLocalHomeInvocationHandler.invoke(EJBLocalHomeInvocationHandler.java:242)
>         at $Proxy24.selectAllActiveTimersOwnedByThisServer(Unknown Source)
>         at
> com.sun.ejb.containers.EJBTimerService.restoreTimers(EJBTimerService.java:491)
>         at
> com.sun.ejb.containers.ContainerFactoryImpl.restoreEJBTimers(ContainerFactoryImpl.java:364)
>         at
> com.sun.enterprise.server.ApplicationLifecycle.onReady(ApplicationLifecycle.java:348)
>         at
> com.sun.enterprise.server.ApplicationServer.onReady(ApplicationServer.java:526)
>         at com.sun.enterprise.server.PEMain.run(PEMain.java:413)
>         at com.sun.enterprise.server.PEMain.main(PEMain.java:338)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at com.sun.enterprise.server.PELaunch.main(PELaunch.java:412)
> NestedStackTrace:
> java.sql.SQLTransactionRollbackException: A lock could not be obtained
> within the time requested
>         at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
>         at
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
>         at
> org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown
> Source)
>         at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
> Source)
>         at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
>         at
> com.sun.jdo.spi.persistence.support.sqlstore.sql.ResultDesc.getResult(ResultDesc.java:490)
>         at
> com.sun.jdo.spi.persistence.support.sqlstore.sql.generator.SelectQueryPlan.getResult(SelectQueryPlan.java:1576)
>         at
> com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.executeQuery(SQLStoreManager.java:477)
>         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:1118)
>         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.ejbSelectAllTimersByOwnerAndState(TimerBean_2100919770_ConcreteImpl.java:1700)
>         at
> com.sun.ejb.containers.TimerBean.ejbHomeSelectAllActiveTimersOwnedByThisServer(TimerBean.java:709)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at
> com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1067)
>         at
> com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:176)
>         at
> com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2895)
>         at
> com.sun.ejb.containers.EJBLocalHomeInvocationHandler.invoke(EJBLocalHomeInvocationHandler.java:242)
>         at $Proxy24.selectAllActiveTimersOwnedByThisServer(Unknown Source)
>         at
> com.sun.ejb.containers.EJBTimerService.restoreTimers(EJBTimerService.java:491)
>         at
> com.sun.ejb.containers.ContainerFactoryImpl.restoreEJBTimers(ContainerFactoryImpl.java:364)
>         at
> com.sun.enterprise.server.ApplicationLifecycle.onReady(ApplicationLifecycle.java:348)
>         at
> com.sun.enterprise.server.ApplicationServer.onReady(ApplicationServer.java:526)
>         at com.sun.enterprise.server.PEMain.run(PEMain.java:413)
>         at com.sun.enterprise.server.PEMain.main(PEMain.java:338)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at com.sun.enterprise.server.PELaunch.main(PELaunch.java:412)
> Caused by: java.sql.SQLException: A lock could not be obtained within the
> time requested
>         at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
>         ... 38 more
> EJB5018: An exception was thrown during an ejb invocation on [TimerBean]
> 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."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
> 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)
>         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:1118)
>         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.ejbSelectAllTimersByOwnerAndState(TimerBean_2100919770_ConcreteImpl.java:1700)
>         at
> com.sun.ejb.containers.TimerBean.ejbHomeSelectAllActiveTimersOwnedByThisServer(TimerBean.java:709)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at
> com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1067)
>         at
> com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:176)
>         at
> com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2895)
>         at
> com.sun.ejb.containers.EJBLocalHomeInvocationHandler.invoke(EJBLocalHomeInvocationHandler.java:242)
>         at $Proxy24.selectAllActiveTimersOwnedByThisServer(Unknown Source)
>         at
> com.sun.ejb.containers.EJBTimerService.restoreTimers(EJBTimerService.java:491)
>         at
> com.sun.ejb.containers.ContainerFactoryImpl.restoreEJBTimers(ContainerFactoryImpl.java:364)
>         at
> com.sun.enterprise.server.ApplicationLifecycle.onReady(ApplicationLifecycle.java:348)
>         at
> com.sun.enterprise.server.ApplicationServer.onReady(ApplicationServer.java:526)
>         at com.sun.enterprise.server.PEMain.run(PEMain.java:413)
>         at com.sun.enterprise.server.PEMain.main(PEMain.java:338)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at com.sun.enterprise.server.PELaunch.main(PELaunch.java:412)
> NestedStackTrace:
> java.sql.SQLTransactionRollbackException: A lock could not be obtained
> within the time requested
>         at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
>         at
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
>         at
> org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown
> Source)
>         at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
> Source)
>         at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
>         at
> com.sun.jdo.spi.persistence.support.sqlstore.sql.ResultDesc.getResult(ResultDesc.java:490)
>         at
> com.sun.jdo.spi.persistence.support.sqlstore.sql.generator.SelectQueryPlan.getResult(SelectQueryPlan.java:1576)
>         at
> com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.executeQuery(SQLStoreManager.java:477)
>         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:1118)
>         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.ejbSelectAllTimersByOwnerAndState(TimerBean_2100919770_ConcreteImpl.java:1700)
>         at
> com.sun.ejb.containers.TimerBean.ejbHomeSelectAllActiveTimersOwnedByThisServer(TimerBean.java:709)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at
> com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1067)
>         at
> com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:176)
>         at
> com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2895)
>         at
> com.sun.ejb.containers.EJBLocalHomeInvocationHandler.invoke(EJBLocalHomeInvocationHandler.java:242)
>         at $Proxy24.selectAllActiveTimersOwnedByThisServer(Unknown Source)
>         at
> com.sun.ejb.containers.EJBTimerService.restoreTimers(EJBTimerService.java:491)
>         at
> com.sun.ejb.containers.ContainerFactoryImpl.restoreEJBTimers(ContainerFactoryImpl.java:364)
>         at
> com.sun.enterprise.server.ApplicationLifecycle.onReady(ApplicationLifecycle.java:348)
>         at
> com.sun.enterprise.server.ApplicationServer.onReady(ApplicationServer.java:526)
>         at com.sun.enterprise.server.PEMain.run(PEMain.java:413)
>         at com.sun.enterprise.server.PEMain.main(PEMain.java:338)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at com.sun.enterprise.server.PELaunch.main(PELaunch.java:412)
> Caused by: java.sql.SQLException: A lock could not be obtained within the
> time requested
>         at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
>         ... 38 more
> 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."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.ejb.containers.BaseContainer.checkExceptionClientTx(BaseContainer.java:3728)
>         at
> com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3576)
>         at
> com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1354)
>         at
> com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1316)
>         at
> com.sun.ejb.containers.EJBLocalHomeInvocationHandler.invoke(EJBLocalHomeInvocationHandler.java:251)
>         at $Proxy24.selectAllActiveTimersOwnedByThisServer(Unknown Source)
>         at
> com.sun.ejb.containers.EJBTimerService.restoreTimers(EJBTimerService.java:491)
>         at
> com.sun.ejb.containers.ContainerFactoryImpl.restoreEJBTimers(ContainerFactoryImpl.java:364)
>         at
> com.sun.enterprise.server.ApplicationLifecycle.onReady(ApplicationLifecycle.java:348)
>         at
> com.sun.enterprise.server.ApplicationServer.onReady(ApplicationServer.java:526)
>         at com.sun.enterprise.server.PEMain.run(PEMain.java:413)
>         at com.sun.enterprise.server.PEMain.main(PEMain.java:338)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at com.sun.enterprise.server.PELaunch.main(PELaunch.java:412)
> EJB5108:Unable to initialize EJB Timer Service. The likely cause is the
> database has not been started or the timer database table has not been
> created.
> 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."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
> 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)
>         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:1118)
>         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.ejbSelectAllTimersByOwnerAndState(TimerBean_2100919770_ConcreteImpl.java:1700)
>         at
> com.sun.ejb.containers.TimerBean.ejbHomeSelectAllActiveTimersOwnedByThisServer(TimerBean.java:709)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at
> com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1067)
>         at
> com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:176)
>         at
> com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2895)
>         at
> com.sun.ejb.containers.EJBLocalHomeInvocationHandler.invoke(EJBLocalHomeInvocationHandler.java:242)
>         at $Proxy24.selectAllActiveTimersOwnedByThisServer(Unknown Source)
>         at
> com.sun.ejb.containers.EJBTimerService.restoreTimers(EJBTimerService.java:491)
>         at
> com.sun.ejb.containers.ContainerFactoryImpl.restoreEJBTimers(ContainerFactoryImpl.java:364)
>         at
> com.sun.enterprise.server.ApplicationLifecycle.onReady(ApplicationLifecycle.java:348)
>         at
> com.sun.enterprise.server.ApplicationServer.onReady(ApplicationServer.java:526)
>         at com.sun.enterprise.server.PEMain.run(PEMain.java:413)
>         at com.sun.enterprise.server.PEMain.main(PEMain.java:338)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at com.sun.enterprise.server.PELaunch.main(PELaunch.java:412)
> NestedStackTrace:
> java.sql.SQLTransactionRollbackException: A lock could not be obtained
> within the time requested
>         at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
>         at
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
>         at
> org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown
> Source)
>         at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
> Source)
>         at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
>         at
> com.sun.jdo.spi.persistence.support.sqlstore.sql.ResultDesc.getResult(ResultDesc.java:490)
>         at
> com.sun.jdo.spi.persistence.support.sqlstore.sql.generator.SelectQueryPlan.getResult(SelectQueryPlan.java:1576)
>         at
> com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.executeQuery(SQLStoreManager.java:477)
>         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:1118)
>         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.ejbSelectAllTimersByOwnerAndState(TimerBean_2100919770_ConcreteImpl.java:1700)
>         at
> com.sun.ejb.containers.TimerBean.ejbHomeSelectAllActiveTimersOwnedByThisServer(TimerBean.java:709)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at
> com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1067)
>         at
> com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:176)
>         at
> com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2895)
>         at
> com.sun.ejb.containers.EJBLocalHomeInvocationHandler.invoke(EJBLocalHomeInvocationHandler.java:242)
>         at $Proxy24.selectAllActiveTimersOwnedByThisServer(Unknown Source)
>         at
> com.sun.ejb.containers.EJBTimerService.restoreTimers(EJBTimerService.java:491)
>         at
> com.sun.ejb.containers.ContainerFactoryImpl.restoreEJBTimers(ContainerFactoryImpl.java:364)
>         at
> com.sun.enterprise.server.ApplicationLifecycle.onReady(ApplicationLifecycle.java:348)
>         at
> com.sun.enterprise.server.ApplicationServer.onReady(ApplicationServer.java:526)
>         at com.sun.enterprise.server.PEMain.run(PEMain.java:413)
>         at com.sun.enterprise.server.PEMain.main(PEMain.java:338)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at com.sun.enterprise.server.PELaunch.main(PELaunch.java:412)
> Caused by: java.sql.SQLException: A lock could not be obtained within the
> time requested
>         at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
>         ... 38 more
> 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."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.ejb.containers.BaseContainer.checkExceptionClientTx(BaseContainer.java:3728)
>         at
> com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3576)
>         at
> com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1354)
>         at
> com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1316)
>         at
> com.sun.ejb.containers.EJBLocalHomeInvocationHandler.invoke(EJBLocalHomeInvocationHandler.java:251)
>         at $Proxy24.selectAllActiveTimersOwnedByThisServer(Unknown Source)
>         at
> com.sun.ejb.containers.EJBTimerService.restoreTimers(EJBTimerService.java:491)
>         at
> com.sun.ejb.containers.ContainerFactoryImpl.restoreEJBTimers(ContainerFactoryImpl.java:364)
>         at
> com.sun.enterprise.server.ApplicationLifecycle.onReady(ApplicationLifecycle.java:348)
>         at
> com.sun.enterprise.server.ApplicationServer.onReady(ApplicationServer.java:526)
>         at com.sun.enterprise.server.PEMain.run(PEMain.java:413)
>         at com.sun.enterprise.server.PEMain.main(PEMain.java:338)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at com.sun.enterprise.server.PELaunch.main(PELaunch.java:412)
> JTS5064: Unexpected exception occurred while delisting the resource
> javax.transaction.xa.XAException
>         at org.apache.derby.jdbc.EmbedXAResource.end(Unknown Source)
>         at com.sun.gjc.spi.XAResourceImpl.end(XAResourceImpl.java:100)
>         at
> com.sun.jts.jta.TransactionState.beforeCompletion(TransactionState.java:161)
>         at
> com.sun.jts.jta.SynchronizationImpl.before_completion(SynchronizationImpl.java:133)
>         at
> com.sun.jts.CosTransactions.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:158)
>         at
> com.sun.jts.CosTransactions.TopCoordinator.beforeCompletion(TopCoordinator.java:2548)
>         at
> com.sun.jts.CosTransactions.CoordinatorTerm.commit(CoordinatorTerm.java:278)
>         at
> com.sun.jts.CosTransactions.TerminatorImpl.commit(TerminatorImpl.java:249)
>         at
> com.sun.jts.CosTransactions.CurrentImpl.commit(CurrentImpl.java:623)
>         at
> com.sun.jts.jta.TransactionManagerImpl.commit(TransactionManagerImpl.java:309)
>         at
> com.sun.enterprise.distributedtx.J2EETransactionManagerImpl.commit(J2EETransactionManagerImpl.java:1004)
>         at
> com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.commit(J2EETransactionManagerOpt.java:397)
>         at
> com.sun.ejb.containers.EJBTimerService.restoreTimers(EJBTimerService.java:511)
>         at
> com.sun.ejb.containers.ContainerFactoryImpl.restoreEJBTimers(ContainerFactoryImpl.java:364)
>         at
> com.sun.enterprise.server.ApplicationLifecycle.onReady(ApplicationLifecycle.java:348)
>         at
> com.sun.enterprise.server.ApplicationServer.onReady(ApplicationServer.java:526)
>         at com.sun.enterprise.server.PEMain.run(PEMain.java:413)
>         at com.sun.enterprise.server.PEMain.main(PEMain.java:338)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at com.sun.enterprise.server.PELaunch.main(PELaunch.java:412)
> EJB5108:Unable to initialize EJB Timer Service. The likely cause is the
> database has not been started or the timer database table has not been
> created.
> javax.transaction.RollbackException
>         at
> com.sun.jts.jta.TransactionManagerImpl.commit(TransactionManagerImpl.java:311)
>         at
> com.sun.enterprise.distributedtx.J2EETransactionManagerImpl.commit(J2EETransactionManagerImpl.java:1004)
>         at
> com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.commit(J2EETransactionManagerOpt.java:397)
>         at
> com.sun.ejb.containers.EJBTimerService.restoreTimers(EJBTimerService.java:511)
>         at
> com.sun.ejb.containers.ContainerFactoryImpl.restoreEJBTimers(ContainerFactoryImpl.java:364)
>         at
> com.sun.enterprise.server.ApplicationLifecycle.onReady(ApplicationLifecycle.java:348)
>         at
> com.sun.enterprise.server.ApplicationServer.onReady(ApplicationServer.java:526)
>         at com.sun.enterprise.server.PEMain.run(PEMain.java:413)
>         at com.sun.enterprise.server.PEMain.main(PEMain.java:338)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at com.sun.enterprise.server.PELaunch.main(PELaunch.java:412)
> Application server startup complete.
> Error registering
> com.sun.appserv:type=RequestProcessor,worker=http4848,name=HttpRequest3
> javax.management.InstanceAlreadyExistsException:
> com.sun.appserv:type=RequestProcessor,worker=http4848,name=HttpRequest3
>         at com.sun.jmx.mbeanserver.Repository.addMBean(Repository.java:453)
>         at
> com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.internal_addObject(DefaultMBeanServerInterceptor.java:1484)
>         at
> com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerDynamicMBean(DefaultMBeanServerInterceptor.java:963)
>         at
> com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerObject(DefaultMBeanServerInterceptor.java:917)
>         at
> com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(DefaultMBeanServerInterceptor.java:312)
>         at
> com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(JmxMBeanServer.java:482)
>         at
> com.sun.enterprise.interceptor.DynamicInterceptor.registerMBean(DynamicInterceptor.java:263)
>         at
> com.sun.org.apache.commons.modeler.Registry.registerComponent(Registry.java:872)
>         at
> com.sun.enterprise.web.connector.grizzly.GrizzlyHttpProtocol$ModelerManagement.registerComponent(GrizzlyHttpProtocol.java:963)
>         at
> com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.registerMonitoring(DefaultProcessorTask.java:1627)
>         at
> com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.configPreProcess(DefaultProcessorTask.java:521)
>         at
> com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.preProcess(DefaultProcessorTask.java:504)
>         at
> com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:812)
>         at
> com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
>         at
> com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
>         at
> com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
>         at
> com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
>         at
> com.sun.enterprise.web.connector.grizzly.WorkerThreadImpl.run(WorkerThreadImpl.java:116)
> WEB0788: Error registering request
> javax.management.InstanceAlreadyExistsException:
> com.sun.appserv:type=RequestProcessor,worker=http4848,name=HttpRequest3
>         at com.sun.jmx.mbeanserver.Repository.addMBean(Repository.java:453)
>         at
> com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.internal_addObject(DefaultMBeanServerInterceptor.java:1484)
>         at
> com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerDynamicMBean(DefaultMBeanServerInterceptor.java:963)
>         at
> com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerObject(DefaultMBeanServerInterceptor.java:917)
>         at
> com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(DefaultMBeanServerInterceptor.java:312)
>         at
> com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(JmxMBeanServer.java:482)
>         at
> com.sun.enterprise.interceptor.DynamicInterceptor.registerMBean(DynamicInterceptor.java:263)
>         at
> com.sun.org.apache.commons.modeler.Registry.registerComponent(Registry.java:872)
>         at
> com.sun.enterprise.web.connector.grizzly.GrizzlyHttpProtocol$ModelerManagement.registerComponent(GrizzlyHttpProtocol.java:963)
>         at
> com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.registerMonitoring(DefaultProcessorTask.java:1627)
>         at
> com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.configPreProcess(DefaultProcessorTask.java:521)
>         at
> com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.preProcess(DefaultProcessorTask.java:504)
>         at
> com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:812)
>         at
> com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
>         at
> com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
>         at
> com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
>         at
> com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
>         at
> com.sun.enterprise.web.connector.grizzly.WorkerThreadImpl.run(WorkerThreadImpl.java:116)
> [AutoDeploy] Selecting file
> C:\openesb\glassfish-v2-ur2-b04-patch-20080729\domains\domain1\autodeploy\amserver.war
> for autodeployment.
> Autoundeploying application :amserver
>
> --
> View this message in context: http://www.nabble.com/Derby-Error-Starting-Glassfish-tp23334048p23334048.html
> Sent from the NetBeans - EntPack mailing list archive at Nabble.com.

 « Return to Thread: RE: Derby Error Starting Glassfish