October 2011 - Topia-devel - mailman.cloud.codelutin.com

[ANN] - ToPIA 2.6.3 released
by nuiton.org Release Notification 20 Oct '11

20 Oct '11

1 0

Timeout trying to lock table "SYS" with runscript
by Eric Chatellier 17 Oct '11

17 Oct '11

Hi, In my application running h2 for years, i just updated : - h2 from 1.2.128 to 1.3.160 - hibernate from 3.3.2 to 3.6.5 I'm trying to restore a database from runscript command using query: RUNSCRIPT FROM 'xxx/data-backup.sql.gz' COMPRESSION GZIP Execution fails with error : Caused by: org.hibernate.exception.GenericJDBCException: could not execute native bulk manipulation query at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:219) at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1300) at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:365) at org.nuiton.topia.framework.TopiaContextImpl.restore(TopiaContextImpl.java:1338) ... 3 more Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "SYS"; SQL statement: SET CLUSTER '' [50200-160] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:169) at org.h2.message.DbException.get(DbException.java:146) at org.h2.table.RegularTable.doLock(RegularTable.java:500) at org.h2.table.RegularTable.lock(RegularTable.java:434) at org.h2.engine.Database.lockMeta(Database.java:748) at org.h2.engine.Database.addDatabaseObject(Database.java:862) at org.h2.command.dml.Set.addOrUpdateSetting(Set.java:401) at org.h2.command.dml.Set.update(Set.java:101) at org.h2.command.dml.RunScriptCommand.execute(RunScriptCommand.java:66) at org.h2.command.dml.RunScriptCommand.update(RunScriptCommand.java:45) at org.h2.command.CommandContainer.update(CommandContainer.java:73) at org.h2.command.Command.executeUpdate(Command.java:219) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:129) at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:210) ... 6 more But, running the same query in h2 web server works well. Database is has beean tested with url : - jdbc:h2:file:/xxx/DemoRegion/data/data;FILE_LOCK=file;LOG=1;DEFAULT_LOCK_TIMEOUT=1000;DB_CLOSE_DELAY=0;LOCK_MODE=3;TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0 - jdbc:h2:file:/xxx/DemoRegion/data/data;FILE_LOCK=no;LOG=1;DEFAULT_LOCK_TIMEOUT=1000;DB_CLOSE_DELAY=0;LOCK_MODE=3;TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0 - jdbc:h2:file:/xxx/DemoRegion/data/data - jdbc:h2:file:/xxx/DemoRegion/data/data;MVCC=1 without success. I thinks the problem may be related to hibernate update, but i can't find any clue on this. Any idea ? Regards. -- Éric Chatellier

1 2

Re: [Topia-devel] [Topia-commits] r2356 - trunk/topia-persistence/src/main/java/org/nuiton/topia/framework
by Tony Chemit 17 Oct '11

17 Oct '11

On Sun, 16 Oct 2011 22:08:41 +0200 (CEST) echatellier(a)users.nuiton.org wrote: Attention, il faudrait peut-être faire ça mais en reposionnant le connection comme elle était avant, non ? Là en by-pass les commits gérés via hibernet et donc topia. Il me semble plus prudent de faire ça : try {} finally { //On remet comme avant } Ce qui me dérange aussi c'est qu'il n'y ait aucun test pour ça :( Merci de faire le nécessaire pour que la modification soit très locale et ne se propage pas sur la transaction. Tony. > Author: echatellier > Date: 2011-10-16 22:08:41 +0200 (Sun, 16 Oct 2011) > New Revision: 2356 > > Url: http://nuiton.org/repositories/revision/topia/2356 > > Log: > Fix h2 restore clustering bug > > Modified: > trunk/topia-persistence/src/main/java/org/nuiton/topia/framework/TopiaContextImpl.java > > Modified: > trunk/topia-persistence/src/main/java/org/nuiton/topia/framework/TopiaContextImpl.java > =================================================================== > --- > trunk/topia-persistence/src/main/java/org/nuiton/topia/framework/TopiaContextImpl.java > 2011-10-14 14:08:09 UTC (rev 2355) +++ > trunk/topia-persistence/src/main/java/org/nuiton/topia/framework/TopiaContextImpl.java > 2011-10-16 20:08:41 UTC (rev 2356) @@ -1355,8 +1355,14 @@ > in.close(); } > + // FIXME echatellier 20111016 : fix runscript failure in > h2 > + // due to change in clustering between version 1.2.142 > and 1.2.143 > + // "Cluster: auto-commit was disabled after opening a > connection." > + getHibernate().connection().setAutoCommit(true); > + > SQLQuery query = getHibernate().createSQLQuery( > "RUNSCRIPT FROM '" + file.getAbsolutePath() + > "'" + options); > + > query.executeUpdate(); > > // send event AFTER restore > > _______________________________________________ > Topia-commits mailing list > Topia-commits(a)list.nuiton.org > http://list.nuiton.org/cgi-bin/mailman/listinfo/topia-commits -- Tony Chemit -------------------- tél: +33 (0) 2 40 50 29 28 email: chemit(a)codelutin.com http://www.codelutin.com

2 1