I realized that some of my first description is wrong. 1. The WRITE_DELAY=0 doesn't seem to change anything. 2. The testBigDatabase with cache enabled works most of the time on our networked database. It is when the cache is deactivated that the test fails as shown in previous message.
If I bypass this failing test (with cache deactivated), I typically get the following output : 00:19:15 23:19:15.794 org.h2.test.unit.TestFileLockSerialized testSequence 00:19:21 23:19:21.311 org.h2.test.unit.TestFileLockSerialized testSequenceFlush 00:19:23 23:19:23.543 org.h2.test.unit.TestFileLockSerialized testLeftLogFiles 00:19:25 23:19:25.406 org.h2.test.unit.TestFileLockSerialized testWrongDatabaseInstanceOnReconnect 00:19:29 23:19:29.609 org.h2.test.unit.TestFileLockSerialized testCache() 00:19:37 23:19:37.057 org.h2.test.unit.TestFileLockSerialized testBigDatabase(true) 00:20:12 23:20:12.180 org.h2.test.unit.TestFileLockSerialized testCheckpointInUpdateRaceCondition 00:20:16 23:20:16.820 org.h2.test.unit.TestFileLockSerialized testConcurrentUpdates 00:20:22 23:20:22.885 org.h2.test.unit.TestFileLockSerialized testThreeMostlyReaders true 00:20:33 23:20:33.589 org.h2.test.unit.TestFileLockSerialized testThreeMostlyReaders false Exception in thread "main" org.h2.jdbc.JdbcSQLException: (Message 42S02 not found); SQL statement: select * from test where id = ? [42102-162] 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.command.Parser.readTableOrView(Parser.java:4758) at org.h2.command.Parser.readTableFilter(Parser.java:1080) at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1686) at org.h2.command.Parser.parseSelectSimple(Parser.java:1793) at org.h2.command.Parser.parseSelectSub(Parser.java:1680) at org.h2.command.Parser.parseSelectUnion(Parser.java:1523) at org.h2.command.Parser.parseSelect(Parser.java:1511) at org.h2.command.Parser.parsePrepared(Parser.java:405) at org.h2.command.Parser.parse(Parser.java:279) at org.h2.command.Parser.parse(Parser.java:251) at org.h2.command.Parser.prepareCommand(Parser.java:217) at org.h2.engine.Session.prepareLocal(Session.java:415) at org.h2.engine.Session.prepareCommand(Session.java:364) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1121) at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71) at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:267) at org.h2.test.unit.TestFileLockSerialized$2.run(TestFileLockSerialized.java:193) at java.lang.Thread.run(Thread.java:662) -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/-xPWB33x5OAJ. To post to this group, send email to h2-database@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.