killdashnine/play-as — Issue #40: Timeout trying to lock table "application_properties"; 
Author: killdashnine
Created: 2011-12-15 12:12:19+00:00
State: open

13:09:34,271 ERROR ~ Timeout trying to lock table "application_properties"; SQL statement:
select properties0_.application_id as applicat5_1_1_, properties0_."id" as id1_1_, properties0_."id" as id1_0_0_, properties0_.application_id as applicat5_0_0_, properties0_."key" as key2_0_0_, properties0_."priority" as priority3_0_0_, properties0_."value" as value4_0_0_ from "application_properties" properties0_ where properties0_.application_id=? [50200-149]
13:09:35,181 ERROR ~

@68lkk3ff6
Internal Server Error (500) for request GET /status?_=1323950972220

Execution exception (In /app/controllers/ManagerController.java around line 32)
JPAQueryException occured : Error while executing query from models.Application: Timeout trying to lock table "application_properties"; SQL statement: select properties0_.application_id as applicat5_1_1_, properties0_."id" as id1_1_, properties0_."id" as id1_0_0_, properties0_.application_id as applicat5_0_0_, properties0_."key" as key2_0_0_, properties0_."priority" as priority3_0_0_, properties0_."value" as value4_0_0_ from "application_properties" properties0_ where properties0_.application_id=? [50200-149]

play.exceptions.JavaExecutionException: Error while executing query from models.Application: Timeout trying to lock table "application_properties"; SQL statement:
select properties0_.application_id as applicat5_1_1_, properties0_."id" as id1_1_, properties0_."id" as id1_0_0_, properties0_.application_id as applicat5_0_0_, properties0_."key" as key2_0_0_, properties0_."priority" as priority3_0_0_, properties0_."value" as value4_0_0_ from "application_properties" properties0_ where properties0_.application_id=? [50200-149]
at play.mvc.ActionInvoker.invoke(ActionInvoker.java:231)
at Invocation.HTTP Request(Play!)
Caused by: play.db.jpa.JPABase$JPAQueryException: Error while executing query from models.Application: Timeout trying to lock table "application_properties"; SQL statement:
select properties0_.application_id as applicat5_1_1_, properties0_."id" as id1_1_, properties0_."id" as id1_0_0_, properties0_.application_id as applicat5_0_0_, properties0_."key" as key2_0_0_, properties0_."priority" as priority3_0_0_, properties0_."value" as value4_0_0_ from "application_properties" properties0_ where properties0_.application_id=? [50200-149]
at play.db.jpa.GenericModel$JPAQuery.fetch(GenericModel.java:369)
at controllers.ManagerController.status(ManagerController.java:32)
at play.mvc.ActionInvoker.invokeWithContinuation(ActionInvoker.java:548)
at play.mvc.ActionInvoker.invoke(ActionInvoker.java:502)
at play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:478)
at play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:473)
at play.mvc.ActionInvoker.invoke(ActionInvoker.java:161)
... 1 more
Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "application_properties"; SQL statement:
select properties0_.application_id as applicat5_1_1_, properties0_."id" as id1_1_, properties0_."id" as id1_0_0_, properties0_.application_id as applicat5_0_0_, properties0_."key" as key2_0_0_, properties0_."priority" as priority3_0_0_, properties0_."value" as value4_0_0_ from "application_properties" properties0_ where properties0_.application_id=? [50200-149]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.table.RegularTable.doLock(RegularTable.java:499)
at org.h2.table.RegularTable.lock(RegularTable.java:433)
at org.h2.table.TableFilter.lock(TableFilter.java:140)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:571)
at org.h2.command.dml.Query.query(Query.java:257)
at org.h2.command.dml.Query.query(Query.java:227)
at org.h2.command.CommandContainer.query(CommandContainer.java:78)
at org.h2.command.Command.executeQuery(Command.java:178)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.loadCollection(Loader.java:2166)
at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:62)
at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:627)
at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:83)
at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1863)
at org.hibernate.collection.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:479)
at org.hibernate.engine.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java:900)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:279)
at org.hibernate.loader.Loader.doList(Loader.java:2533)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:246)
at play.db.jpa.GenericModel$JPAQuery.fetch(GenericModel.java:367)
... 7 more
13:09:36,278 ERROR ~ Timeout trying to lock table "application_properties"; SQL statement:
select properties0_.application_id as applicat5_1_1_, properties0_."id" as id1_1_, properties0_."id" as id1_0_0_, properties0_.application_id as applicat5_0_0_, properties0_."key" as key2_0_0_, properties0_."priority" as priority3_0_0_, properties0_."value" as value4_0_0_ from "application_properties" properties0_ where properties0_.application_id=? [50200-149]