A lock could not be obtained within the time requested

[heiko.braun]

Since we moved to ODE 1.3 I get a lot of these:

14:08:08,982 WARN [JDBCExceptionReporter] SQL Error: 30000, SQLState:
40XL1
14:08:08,982 ERROR [JDBCExceptionReporter] A lock could not be
obtained within the time requested
14:08:08,983 ERROR [BpelServerImpl]
org.hibernate.exception.GenericJDBCException: could not execute query
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException
(SQLStateConverter.java:126)
at org.hibernate.exception.SQLStateConverter.convert
(SQLStateConverter.java:114)
at org.hibernate.exception.JDBCExceptionHelper.convert
(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2231)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at org.hibernate.hql.ast.QueryTranslatorImpl.list
(QueryTranslatorImpl.java:361)
at org.hibernate.engine.query.HQLQueryPlan.performList
(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.apache.ode.daohib.bpel.ProcessDaoImpl.deleteEvents
(ProcessDaoImpl.java:256)

[heiko.braun]

This is worse then I thought. On a running jboss instance take a look at http://localhost:8080/jmx-console/HtmlAdaptor?action=invokeOpByName&name=jboss.system:type=ServerInfo&methodName=listThreadCpuUtilization

You'll see a bunch of "ODE-Server-X" threads with heavy CPU utilization.

[heiko.braun]

https://jira.jboss.org/jira/browse/RIFTSAW-62

[heiko.braun]

I have switched trunk to H2 instead of derby. Although the initial error is gone now, others did occur. However the H2 exception handling is much more verbose and better to understand. And besides, it's the same DB the ESB installation already uses as a default. So we got one less artifact to worry about.

I'll keep you guys posted.

[heiko.braun]

But what we really need is test coverage against a decent DB matrix:
https://jira.jboss.org/jira/browse/RIFTSAW-64

Anyone volunteering?