Highlighted

Server and jdbc

_jerome_dinnat_

02-07-2008

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(CachedPreparedStatement.java:81)

at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.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(StatelessSessionContainer.java:214)

at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)

at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.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