0 Replies Latest reply on Jul 2, 2008 11:48 PM by (jerome_dinnat)

    Server and jdbc

    (jerome_dinnat) Level 1
      Hi,

      I have some errors in the server logs when I go to localhost:8080/workspace, it takes time to print the page.

      The server started without problems

      CVSTag=JBoss_4_0_3_SP1 date=200510231054)] Started in 9m:24s:280ms

      When I try to connect to workspace, I don't understand that :

      2008-06-04 09:39:43,229 WARN [com.adobe.idp.common.errors.exception.IDPLoggedException] UserM:GENERIC_WARNING: [Thread Hashcode: 7265526] | [com.adobe.idp.storeprovider.jdbc.DBStatement] errorCode:12290 errorCodeHEX:0x3002 message:execute non-query failure(update EDCCONFIGURATIONENTITYSQ2 set seq = LAST_INSERT_ID(seq + 1)) chainedException:java.sql.SQLException: Lock wait timeout exceeded; try restarting transactionchainedExceptionMessage:Lock wait timeout exceeded; try restarting transaction chainedException trace:java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
      at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)
      at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
      at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedState ment.java:81)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedSta tement.java:227)
      at com.adobe.idp.storeprovider.jdbc.DBStatement.executeNonQuery(DBStatement.java:390)
      at com.adobe.idp.storeprovider.jdbc.DBSchemaSQL.bumpSequence(DBSchemaSQL.java:1234)
      at com.adobe.idp.storeprovider.jdbc.DBSequence.nextValue(DBSequence.java:62)
      at com.adobe.idp.storeprovider.jdbc.DBStoreProvider.update(DBStoreProvider.java:1258)
      at com.adobe.idp.storeprovider.jdbc.DBStoreProvider.update(DBStoreProvider.java:1222)
      at com.adobe.idp.config.PreferencesBean.doUpdate(PreferencesBean.java:571)
      at com.adobe.idp.config.PreferencesBean.flush(PreferencesBean.java:261)
      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:585)
      at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
      at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionConta iner.java:214)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionI nterceptor.java:149)
      at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstance Interceptor.java:154)
      at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor. java:54)
      at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:389)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
      at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)
      at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor. java:122)
      at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
      at org.jboss.ejb.Container.invoke(Container.java:873)
      at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)
      at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)
      at