org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "EPERSON"; SQL statement: update RESOURCEPOLICY set START_DATE = ?, RPDESCRIPTION = ?, RESOURCE_TYPE_ID = ?, EPERSONGROUP_ID = ?, END_DATE = ?, EPERSON_ID = ?, RPTYPE = ?, RESOURCE_ID = ?, ACTION_ID = ?, RPNAME = ? where POLICY_ID = ? [50200-137]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Check if you're not creating unused SQL entities, as it might cause this exception.

Solutions on the web

via Sakai JIRA by Ivan Masár, 1 year ago
Timeout trying to lock table "EPERSON"; SQL statement: update RESOURCEPOLICY set START_DATE = ?, RPDESCRIPTION = ?, RESOURCE_TYPE_ID = ?, EPERSONGROUP_ID = ?, END_DATE = ?, EPERSON_ID = ?, RPTYPE = ?, RESOURCE_ID = ?, ACTION_ID = ?, RPNAME = ? where POLICY_ID = ? [50200-137]
via Sakai JIRA by Ivan Masár, 1 year ago
Timeout trying to lock table "EPERSON"; SQL statement: update RESOURCEPOLICY set START_DATE = ?, RPDESCRIPTION = ?, RESOURCE_TYPE_ID = ?, EPERSONGROUP_ID = ?, END_DATE = ?, EPERSON_ID = ?, RPTYPE = ?, RESOURCE_ID = ?, ACTION_ID = ?, RPNAME = ? where POLICY_ID = ? [50200-137]
via GitHub by phxql
, 2 years ago
Eine Verklemmung (Deadlock) ist aufgetreten. Die aktuelle Transaktion wurde rückgängig gemacht. Details: " Session #11 (user: ) on thread dw-89 - POST /v1/planet/8.4.2/ship-in-construction is waiting to lock PUBLIC.ROUND while locking PUBLIC.PLANET
via Google Groups by Remo, 2 years ago
Timeout trying to lock table "USERS"; SQL statement: SELECT ... <removed rest of select statement>' [50200-139]
via Google Groups by Su Yeon Kim, 2 years ago
Timeout trying to lock table "T_AUDIO"; SQL statement: SELECT a.*, b.name n_name, b.imgurl n_imgurl, c.name m_name FROM t_audio a JOIN t_narrator b ON a.narrator = b.num JOIN t_media c ON a.media = c.num JOIN t_preference d ON c.num = d.media
via GitHub by atlasloewenherz
, 1 year ago
Timeout trying to lock table "EXECUTION"; SQL statement: select execution0_.id as id1_2_0_, execution0_.version as version2_2_0_, execution0_.abortedby as abortedb3_2_0_, execution0_.arg_string as arg_stri4_2_0_, execution0_.cancelled as
org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "EPERSON"; SQL statement: update RESOURCEPOLICY set START_DATE = ?, RPDESCRIPTION = ?, RESOURCE_TYPE_ID = ?, EPERSONGROUP_ID = ?, END_DATE = ?, EPERSON_ID = ?, RPTYPE = ?, RESOURCE_ID = ?, ACTION_ID = ?, RPNAME = ? where POLICY_ID = ? [50200-137]
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:466)
at org.h2.table.RegularTable.lock(RegularTable.java:404)
at org.h2.constraint.ConstraintReferential.existsRow(ConstraintReferential.java:336)
at org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:328)
at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:271)
at org.h2.table.Table.fireConstraints(Table.java:797)
at org.h2.table.Table.fireAfterRow(Table.java:814)
at org.h2.command.dml.Update.update(Update.java:130)
at org.h2.command.CommandContainer.update(CommandContainer.java:70)
at org.h2.command.Command.executeUpdate(Command.java:199)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:141)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:127)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.dspace.storage.rdbms.MockDatabaseManager.executeUpdate(MockDatabaseManager.java:1397)
at org.dspace.storage.rdbms.MockDatabaseManager.update(MockDatabaseManager.java:803)
at org.dspace.storage.rdbms.DatabaseManager.update(DatabaseManager.java)
at org.dspace.authorize.ResourcePolicy.update(ResourcePolicy.java:478)
at org.dspace.authorize.AuthorizeManager.addPolicy(AuthorizeManager.java:481)
at org.dspace.content.WorkspaceItem.create(WorkspaceItem.java:157)
at org.dspace.content.WorkspaceItemTest.init(WorkspaceItemTest.java:56)
at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:27)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:76)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:120)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:103)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:350)

Users with the same issue

Once, 2 days ago
2 times, 1 year ago
Once, 7 months ago
Once, 5 months ago
Once, 1 year ago
150 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.