Hi,
I'm currently experiencing a "Timeout trying to lock table "SYS"" problem
only under Java 8 JVM.
With a java 7 JVM, everything is working fine.
I can't make a test case on it, because i can't understand what's is
involved.
The exception i get is :
Caused by: org.hibernate.PessimisticLockException: could not execute
statement
at org.hibernate.dialect.H2Dialect$2.convert(H2Dialect.java:342)
~[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
~[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
~[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
~[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
~[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
at
org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:211)
~[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
at
org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)
~[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
at
org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:389)
~[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
at
org.nuiton.topia.framework.TopiaContextImpl.restore(TopiaContextImpl.java:1202)
~[topia-persistence-2.9.3.jar:2.9.3]
... 7 more
Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table
"SYS"; SQL statement:
SET CLUSTER '' [50200-176]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
~[h2-1.3.176.jar:1.3.176]
at org.h2.message.DbException.get(DbException.java:178)
~[h2-1.3.176.jar:1.3.176]
at org.h2.message.DbException.get(DbException.java:154)
~[h2-1.3.176.jar:1.3.176]
at org.h2.table.RegularTable.doLock(RegularTable.java:530)
~[h2-1.3.176.jar:1.3.176]
at org.h2.table.RegularTable.lock(RegularTable.java:464)
~[h2-1.3.176.jar:1.3.176]
at org.h2.engine.Database.lockMeta(Database.java:869)
~[h2-1.3.176.jar:1.3.176]
at org.h2.engine.Database.addDatabaseObject(Database.java:983)
~[h2-1.3.176.jar:1.3.176]
at org.h2.command.dml.Set.addOrUpdateSetting(Set.java:524)
~[h2-1.3.176.jar:1.3.176]
at org.h2.command.dml.Set.update(Set.java:111) ~[h2-1.3.176.jar:1.3.176]
at org.h2.command.dml.RunScriptCommand.execute(RunScriptCommand.java:79)
~[h2-1.3.176.jar:1.3.176]
at org.h2.command.dml.RunScriptCommand.update(RunScriptCommand.java:58)
~[h2-1.3.176.jar:1.3.176]
at org.h2.command.CommandContainer.update(CommandContainer.java:79)
~[h2-1.3.176.jar:1.3.176]
at org.h2.command.Command.executeUpdate(Command.java:254)
~[h2-1.3.176.jar:1.3.176]
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:158)
~[h2-1.3.176.jar:1.3.176]
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:144)
~[h2-1.3.176.jar:1.3.176]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
~[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
at
org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:211)
~[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
at
org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)
~[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
at
org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:389)
~[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
at
org.nuiton.topia.framework.TopiaContextImpl.restore(TopiaContextImpl.java:1202)
~[topia-persistence-2.9.3.jar:2.9.3]
Do you have any clue on what can cause this error only with java 8 jvm ?
Regards.
--
Éric Chatellier
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
