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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
