Here are my answers to your (default?) questions which might be
helpful:
- What is your database URL?
It works with: jdbc:h2:~/test;LOCK_TIMEOUT=86400000
It crashes with: jdbc:h2:~/
test;LOCK_TIMEOUT=86400000;MULTITHREADED=TRUE
- How many connections does your application use concurrently?
It's variable but a good mean value is 3.
Usually I use a connection pool for these connections but not using it
does not improve the situation.
- Do you use temporary tables?
No
- Did you use LOG=0 or LOG=1?
No
- With which version of H2 was this database created?
You can find it out using:
select * from information_schema.settings where
name='CREATE_BUILD'
or have a look in the SQL script created by the recover tool.
1.3.154
- Did the application run out of memory (once, or multiple times)?
No
- Do you use any settings or special features (for example cache
settings,
two phase commit, linked tables)?
No
- Do you use any H2-specific system properties?
No
- Is the application multi-threaded?
Yes
- What operating system, file system, and virtual machine
(java -version) do you use?
uname: Linux 2.6.31.14-0.6-default #1 SMP 2010-12-10 11:18:32 +0100
x86_64 x86_64 x86_64 GNU/Linux
Filesystem: ext3 and/or ext4
java version "1.6.0_22"
Java(TM) SE Runtime Environment (build 1.6.0_22-b04)
Java HotSpot(TM) 64-Bit Server VM (build 17.1-b03, mixed mode)
- How did you start the Java process (java -Xmx... and so on)?
java -Xmx5g myapp.jar com.myapp.MyApp
- Is it (or was it at some point) a networked file system?
No
- How big is the database (file sizes)?
-rw-r--r-- 1 test users 32572336128 2011-04-07 07:47 test.h2.db
-rw-r--r-- 1 test users 1690 2011-04-07 07:47 test.trace.db
- How much heap memory does the Java process have?
5GB
- Is the database usually closed normally, or is process terminated
forcefully or the computer switched off?
It is closed normally by using the shutdown hook. The computer is not
switched off. Only the application is terminated.
- Is it possible to reproduce this problem using a fresh database
(sometimes, or always)?
Yes, as I described.
- Create the database with the recovery SQL script
- Run my app (I will try to simplify it)
- Are there any other exceptions (maybe in the .trace.db file)?
Could you send them please?
I'll have to check that
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
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.
