NetBeans Forums

 FAQFAQ   SearchSearch   MemberlistMemberlist   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
  

Derby Error Starting Glassfish
Goto page 1, 2, 3  Next
 
Post new topic   Reply to topic    NetBeans Forums -> SOA Users
View previous topic :: View next topic  
Author Message
jsexton0
Posted via mailing list.





PostPosted: Fri May 01, 2009 2:31 pm    Post subject: Derby Error Starting Glassfish Reply with quote

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.
Back to top
Manfred Riem
Posted via mailing list.





PostPosted: Fri May 01, 2009 2:39 pm    Post subject: Derby Error Starting Glassfish Reply with quote

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

Quote:
-------- Original Message --------
Subject: [entpack] Derby Error Starting Glassfish
From: jsexton0 <address-removed>
Date: Fri, May 01, 2009 8:30 am
To: address-removed


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.
Back to top
David Delivante Gifford
Posted via mailing list.





PostPosted: Fri May 01, 2009 2:43 pm    Post subject: Derby Error Starting Glassfish Reply with quote

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


Please examine the SQLException for more information.
Back to top
jsexton0
Posted via mailing list.





PostPosted: Fri May 01, 2009 2:50 pm    Post subject: Derby Error Starting Glassfish Reply with quote

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:
Quote:

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 <address-removed> wrote:
Quote:

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)


--
View this message in context: http://www.nabble.com/Derby-Error-Starting-Glassfish-tp23334048p23334330.html
Sent from the NetBeans - EntPack mailing list archive at Nabble.com.
Back to top
David Delivante Gifford
Posted via mailing list.





PostPosted: Fri May 01, 2009 2:53 pm    Post subject: Derby Error Starting Glassfish Reply with quote

Take a look at wrong XA state as well...


Can you change javax.sql.ConnectionPoolDataSource to javax.sql.DataSource? Or use XA datasource altogether?
I increased the "Initial and Minimum Pool Size" from 32 (default) to 64. The error vanished, but I don't know if it just depends on how many times per timer event a connection is requested. May be the error will occure again with more connection requests. Do you now what the maximal possible value is for the Initial and Minimum Pool Size? The value of 128 seemed not to be accepted.
Back to top
jsexton0
Posted via mailing list.





PostPosted: Fri May 01, 2009 2:59 pm    Post subject: Derby Error Starting Glassfish Reply with quote

Hello -

This is interesting...
This error is happening on the Derby database, very early in Glassfish's
startup. I am not (directly) using the Derby database in any of my code.
Are you suggesting a change to Glassfish's default setup for its Derby pool?
I can certainly try that...

Thanks


OpenXGroup Inc. wrote:
Quote:

Take a look at wrong XA state as well...

Can you change javax.sql.ConnectionPoolDataSource to javax.sql.DataSource?
Or use XA datasource altogether?
I increased the "Initial and Minimum Pool Size" from 32 (default) to 64.
The
error vanished, but I don't know if it just depends on how many times per
timer event a connection is requested. May be the error will occure again
with more connection requests. Do you now what the maximal possible value
is
for the Initial and Minimum Pool Size? The value of 128 seemed not to be
accepted.

I was able to resolve my problem by changing the resource type to
java.sql.ConnectionPoolDataSource.

Do you need transactional capability. If not, you can set your pool to
return non-transactional-connections.

Set non-transactional-connections="true" in your <jdbc-connection-pool>
configuration.

There are two type of transactions we can talk about in general
(pertaining
to this thread).

1) There is the transaction that you can write using SQL which you (the
programmer) write yourself.
2) There is the transaction that java handles at a system level which can
apply to any operation or series of operations you require to be performed
from beginning to end without error (including database operations).

By setting non-transactional-connections to true you will not get the
protection from system failure as described in number 2.




--
View this message in context: http://www.nabble.com/Derby-Error-Starting-Glassfish-tp23334048p23334482.html
Sent from the NetBeans - EntPack mailing list archive at Nabble.com.
Back to top
Manfred Riem
Posted via mailing list.





PostPosted: Fri May 01, 2009 3:05 pm    Post subject: Derby Error Starting Glassfish Reply with quote

You might want to point your EJB timer pool to another
database.

See $GLASSFISH_INSTALL/lib/install/databases for the
proper SQL scripts for your flavor of database.

Manfred
Back to top
David Delivante Gifford
Posted via mailing list.





PostPosted: Fri May 01, 2009 3:06 pm    Post subject: Derby Error Starting Glassfish Reply with quote

You could also follow up on Manfred's suggestion and determine if this bug was addressed by Derby as I think there was a bug logged in the past.
Back to top
David Delivante Gifford
Posted via mailing list.





PostPosted: Fri May 01, 2009 3:16 pm    Post subject: Derby Error Starting Glassfish Reply with quote

Another thing to try- change connection-validation-method="auto-commit" to be
Back to top
jsexton0
Posted via mailing list.





PostPosted: Fri May 01, 2009 3:19 pm    Post subject: Derby Error Starting Glassfish Reply with quote

I'll try adjusting the connection pools. I see these...

__TimerPool
DerbyPool
iepseDerbyPoolNonXA
iepseDerbyPoolXA

Any idea which one is used when initializing the EJB timer service?

Thanks


OpenXGroup Inc. wrote:
Quote:

You could also follow up on Manfred's suggestion and determine if this bug
was addressed by Derby as I think there was a bug logged in the past.
Also,
you can test with MySQL if possible and compare results using the
logging/debugging techniques suggested in the forum.

On Fri, May 1, 2009 at 10:59 AM, jsexton0 <address-removed> wrote:

Quote:

Hello -

This is interesting...
This error is happening on the Derby database, very early in Glassfish's
startup. I am not (directly) using the Derby database in any of my code.
Are you suggesting a change to Glassfish's default setup for its Derby
pool?
I can certainly try that...

Thanks


OpenXGroup Inc. wrote:
Quote:

Take a look at wrong XA state as well...

Can you change javax.sql.ConnectionPoolDataSource to
javax.sql.DataSource?
Quote:
Or use XA datasource altogether?
I increased the "Initial and Minimum Pool Size" from 32 (default) to
64.
Quote:
The
error vanished, but I don't know if it just depends on how many times
per
Quote:
timer event a connection is requested. May be the error will occure
again
Quote:
with more connection requests. Do you now what the maximal possible
value
Quote:
is
for the Initial and Minimum Pool Size? The value of 128 seemed not to
be
Quote:
accepted.

I was able to resolve my problem by changing the resource type to
java.sql.ConnectionPoolDataSource.

Do you need transactional capability. If not, you can set your pool to
return non-transactional-connections.

Set non-transactional-connections="true" in your <jdbc-connection-pool>
configuration.

There are two type of transactions we can talk about in general
(pertaining
to this thread).

1) There is the transaction that you can write using SQL which you (the
programmer) write yourself.
2) There is the transaction that java handles at a system level which
can
Quote:
apply to any operation or series of operations you require to be
performed
Quote:
from beginning to end without error (including database operations).

By setting non-transactional-connections to true you will not get the
protection from system failure as described in number 2.




--
View this message in context:
http://www.nabble.com/Derby-Error-Starting-Glassfish-tp23334048p23334482.html
Sent from the NetBeans - EntPack mailing list archive at Nabble.com.





--
View this message in context: http://www.nabble.com/Derby-Error-Starting-Glassfish-tp23334048p23334783.html
Sent from the NetBeans - EntPack mailing list archive at Nabble.com.
Back to top
David Delivante Gifford
Posted via mailing list.





PostPosted: Fri May 01, 2009 3:20 pm    Post subject: Derby Error Starting Glassfish Reply with quote

Hello,

Activate derby-lock-print
Back to top
Manfred Riem
Posted via mailing list.





PostPosted: Fri May 01, 2009 3:28 pm    Post subject: Derby Error Starting Glassfish Reply with quote

That would be '__TimerPool'

Manfred

Quote:
-------- Original Message --------
Subject: Re: [entpack] Derby Error Starting Glassfish
From: jsexton0 <address-removed>
Date: Fri, May 01, 2009 9:19 am
To: address-removed


I'll try adjusting the connection pools. I see these...

__TimerPool
DerbyPool
iepseDerbyPoolNonXA
iepseDerbyPoolXA

Any idea which one is used when initializing the EJB timer service?

Thanks
Back to top
David Delivante Gifford
Posted via mailing list.





PostPosted: Fri May 01, 2009 3:49 pm    Post subject: Derby Error Starting Glassfish Reply with quote

_TimerPool
Back to top
jsexton0
Posted via mailing list.





PostPosted: Fri May 01, 2009 3:49 pm    Post subject: Derby Error Starting Glassfish Reply with quote

Hello -

I tried changing the max connections to 64, and the timeout to 90000 on each
pool..

__TimerPool
DerbyPool
iepseDerbyPoolNonXA
iepseDerbyPoolXA

Still unable to startup Glassfish correctly, no change. I do not know
were/how to set other Derby properties. My server is
as-originally-installed with respect to the __TimerPool settings.

I guess I'll have to try pointing it at a different database server
altogether. I'd like to understand why this started happening however, and
I hate having to make such a drastic change to the way Glassfish comes "out
of the box".

I do have one timer bean in my application, but it's been working fine for
months as other development has progressed. Nothing in particular seems to
have caused this error to begin happening, except the application has grown.

Thanks


OpenXGroup Inc. wrote:
Quote:

Another thing to try- change connection-validation-method="auto-commit" to
be "table"?
Can you change javax.sql.ConnectionPoolDataSource to javax.sql.DataSource?
Or use XA datasource altogether?

When you use a timer, it comes with the XA datasource access because the
timer instances are stored in the database. When you call your method
directly, it uses a single (non-XA) connection. And that is a big
difference.

More information about *how to diagnose a deadlock situation in Derby /
Java
DB*.
http://wiki.apache.org/db-derby/LockDebugging
http://db.apache.org/derby/docs/dev/devguide/cdevconcepts50894.html

Note that lock ordering as part of the application is important (e.g.
locking in same order) and that a table being accessed without an index
could lead to a Table-level lock, affecting the lock granularity quite
significantly and the risk of deadlocks as part of the applications. It
seemed like some index might have been missing for some of the columns
being
searched as part of some queries.


On Fri, May 1, 2009 at 10:59 AM, jsexton0 <address-removed> wrote:

Quote:

Hello -

This is interesting...
This error is happening on the Derby database, very early in Glassfish's
startup. I am not (directly) using the Derby database in any of my code.
Are you suggesting a change to Glassfish's default setup for its Derby
pool?
I can certainly try that...

Thanks


OpenXGroup Inc. wrote:
Quote:

Take a look at wrong XA state as well...

Can you change javax.sql.ConnectionPoolDataSource to
javax.sql.DataSource?
Quote:
Or use XA datasource altogether?
I increased the "Initial and Minimum Pool Size" from 32 (default) to
64.
Quote:
The
error vanished, but I don't know if it just depends on how many times
per
Quote:
timer event a connection is requested. May be the error will occure
again
Quote:
with more connection requests. Do you now what the maximal possible
value
Quote:
is
for the Initial and Minimum Pool Size? The value of 128 seemed not to
be
Quote:
accepted.

I was able to resolve my problem by changing the resource type to
java.sql.ConnectionPoolDataSource.

Do you need transactional capability. If not, you can set your pool to
return non-transactional-connections.

Set non-transactional-connections="true" in your <jdbc-connection-pool>
configuration.

There are two type of transactions we can talk about in general
(pertaining
to this thread).

1) There is the transaction that you can write using SQL which you (the
programmer) write yourself.
2) There is the transaction that java handles at a system level which
can
Quote:
apply to any operation or series of operations you require to be
performed
Quote:
from beginning to end without error (including database operations).

By setting non-transactional-connections to true you will not get the
protection from system failure as described in number 2.




--
View this message in context:
http://www.nabble.com/Derby-Error-Starting-Glassfish-tp23334048p23334482.html
Sent from the NetBeans - EntPack mailing list archive at Nabble.com.





--
View this message in context: http://www.nabble.com/Derby-Error-Starting-Glassfish-tp23334048p23335261.html
Sent from the NetBeans - EntPack mailing list archive at Nabble.com.
Back to top
Manfred Riem
Posted via mailing list.





PostPosted: Fri May 01, 2009 3:54 pm    Post subject: Derby Error Starting Glassfish Reply with quote

The only other thing I could recommend is to connect
to the EJB timer database yourself and see if the
database itself is not corrupted in anyway.

Manfred

Quote:
-------- Original Message --------
Subject: Re: [entpack] Derby Error Starting Glassfish
From: jsexton0 <address-removed>
Date: Fri, May 01, 2009 9:49 am
To: address-removed


Hello -

I tried changing the max connections to 64, and the timeout to 90000 on each
pool..

__TimerPool
DerbyPool
iepseDerbyPoolNonXA
iepseDerbyPoolXA

Still unable to startup Glassfish correctly, no change. I do not know
were/how to set other Derby properties. My server is
as-originally-installed with respect to the __TimerPool settings.

I guess I'll have to try pointing it at a different database server
altogether. I'd like to understand why this started happening however, and
I hate having to make such a drastic change to the way Glassfish comes "out
of the box".

I do have one timer bean in my application, but it's been working fine for
months as other development has progressed. Nothing in particular seems to
have caused this error to begin happening, except the application has grown.

Thanks


OpenXGroup Inc. wrote:
Quote:

Another thing to try- change connection-validation-method="auto-commit" to
be "table"?
Can you change javax.sql.ConnectionPoolDataSource to javax.sql.DataSource?
Or use XA datasource altogether?

When you use a timer, it comes with the XA datasource access because the
timer instances are stored in the database. When you call your method
directly, it uses a single (non-XA) connection. And that is a big
difference.

More information about *how to diagnose a deadlock situation in Derby /
Java
DB*.
http://wiki.apache.org/db-derby/LockDebugging
http://db.apache.org/derby/docs/dev/devguide/cdevconcepts50894.html

Note that lock ordering as part of the application is important (e.g.
locking in same order) and that a table being accessed without an index
could lead to a Table-level lock, affecting the lock granularity quite
significantly and the risk of deadlocks as part of the applications. It
seemed like some index might have been missing for some of the columns
being
searched as part of some queries.


On Fri, May 1, 2009 at 10:59 AM, jsexton0 <address-removed> wrote:

Quote:

Hello -

This is interesting...
This error is happening on the Derby database, very early in Glassfish's
startup. I am not (directly) using the Derby database in any of my code.
Are you suggesting a change to Glassfish's default setup for its Derby
pool?
I can certainly try that...

Thanks


OpenXGroup Inc. wrote:
Quote:

Take a look at wrong XA state as well...

Can you change javax.sql.ConnectionPoolDataSource to
javax.sql.DataSource?
Quote:
Or use XA datasource altogether?
I increased the "Initial and Minimum Pool Size" from 32 (default) to
64.
Quote:
The
error vanished, but I don't know if it just depends on how many times
per
Quote:
timer event a connection is requested. May be the error will occure
again
Quote:
with more connection requests. Do you now what the maximal possible
value
Quote:
is
for the Initial and Minimum Pool Size? The value of 128 seemed not to
be
Quote:
accepted.

I was able to resolve my problem by changing the resource type to
java.sql.ConnectionPoolDataSource.

Do you need transactional capability. If not, you can set your pool to
return non-transactional-connections.

Set non-transactional-connections="true" in your <jdbc-connection-pool>
configuration.

There are two type of transactions we can talk about in general
(pertaining
to this thread).

1) There is the transaction that you can write using SQL which you (the
programmer) write yourself.
2) There is the transaction that java handles at a system level which
can
Quote:
apply to any operation or series of operations you require to be
performed
Quote:
from beginning to end without error (including database operations).

By setting non-transactional-connections to true you will not get the
protection from system failure as described in number 2.




--
View this message in context:
http://www.nabble.com/Derby-Error-Starting-Glassfish-tp23334048p23334482.html
Sent from the NetBeans - EntPack mailing list archive at Nabble.com.





--
View this message in context: http://www.nabble.com/Derby-Error-Starting-Glassfish-tp23334048p23335261.html
Sent from the NetBeans - EntPack mailing list archive at Nabble.com.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    NetBeans Forums -> SOA Users All times are GMT
Goto page 1, 2, 3  Next
Page 1 of 3

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB
By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo