a couple of thread dumps attached from the source DB
On 10 October 2011 19:07, Thomas Mueller <[email protected]>wrote:
> Hi,
>
> I don't know what could be the problem... Could you get a few full thread
> dumps to find out what the problem is?
>
> jps -l (to get the process id)
> jstack -l <pid>
>
> Regards,
> Thomas
>
> --
> 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.
>
--
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.
2011-10-11 11:21:30
Full thread dump Java HotSpot(TM) 64-Bit Server VM (16.3-b01 mixed mode):
"H2 TCP Server (tcp://10.16.15.122:1234) thread" prio=6 tid=0x000000004b640800
nid=0x1b90 waiting on condition [0x000000004bd9f000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at org.h2.engine.Session.waitIfExclusiveModeEnabled(Session.java:1097)
at org.h2.command.Command.executeQuery(Command.java:174)
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
- locked <0x0000000009a138d0> (a org.h2.engine.Session)
at org.h2.store.LobStorage.getInputStream(LobStorage.java:467)
- locked <0x0000000009a04ee8> (a org.h2.engine.Database)
at org.h2.value.ValueLobDb.getInputStream(ValueLobDb.java:281)
at org.h2.value.ValueLobDb.getReader(ValueLobDb.java:267)
at org.h2.value.ValueLobDb.getString(ValueLobDb.java:188)
at org.h2.value.ValueLobDb.getSQL(ValueLobDb.java:302)
at org.h2.command.dml.ScriptCommand.query(ScriptCommand.java:274)
at org.h2.command.CommandContainer.query(CommandContainer.java:82)
at org.h2.command.Command.executeQuery(Command.java:185)
- locked <0x0000000009a04ee8> (a org.h2.engine.Database)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:278)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
at java.lang.Thread.run(Unknown Source)
Locked ownable synchronizers:
- None
"H2 Log Writer HI_COUGAR10" daemon prio=6 tid=0x000000004ce31800 nid=0x1a3c
waiting for monitor entry [0x000000004d37f000]
java.lang.Thread.State: BLOCKED (on object monitor)
at org.h2.engine.Database.flush(Database.java:1745)
- waiting to lock <0x0000000009a04ee8> (a org.h2.engine.Database)
at org.h2.store.WriterThread.run(WriterThread.java:84)
at java.lang.Thread.run(Unknown Source)
Locked ownable synchronizers:
- None
"H2 File Lock Watchdog C:\DB\cougardb_hi\hi_cougar10.lock.db" daemon prio=10
tid=0x000000004b7d3000 nid=0x17e4 waiting on condition [0x000000004ca7f000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at org.h2.store.FileLock.run(FileLock.java:492)
at java.lang.Thread.run(Unknown Source)
Locked ownable synchronizers:
- None
"H2 TCP Server (tcp://10.16.15.122:1234)" prio=6 tid=0x000000004a37f800
nid=0x152c runnable [0x000000004c87f000]
java.lang.Thread.State: RUNNABLE
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(Unknown Source)
- locked <0x0000000009a602f0> (a java.net.SocksSocketImpl)
at java.net.ServerSocket.implAccept(Unknown Source)
at java.net.ServerSocket.accept(Unknown Source)
at org.h2.server.TcpServer.listen(TcpServer.java:239)
at org.h2.tools.Server.run(Server.java:451)
at java.lang.Thread.run(Unknown Source)
Locked ownable synchronizers:
- None
"H2 Console Server (http://10.16.15.122:8144)" prio=6 tid=0x000000004a2e3000
nid=0x105c runnable [0x000000004c51f000]
java.lang.Thread.State: RUNNABLE
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(Unknown Source)
- locked <0x0000000009a5fc58> (a java.net.SocksSocketImpl)
at java.net.ServerSocket.implAccept(Unknown Source)
at java.net.ServerSocket.accept(Unknown Source)
at org.h2.server.web.WebServer.listen(WebServer.java:339)
at org.h2.tools.Server.run(Server.java:451)
at java.lang.Thread.run(Unknown Source)
Locked ownable synchronizers:
- None
"DestroyJavaVM" prio=6 tid=0x00000000002ab800 nid=0x424 waiting on condition
[0x0000000000000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"Wrapper-Connection" daemon prio=10 tid=0x000000004a252800 nid=0x1048 runnable
[0x000000004be9f000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at java.io.DataInputStream.readByte(Unknown Source)
at
org.tanukisoftware.wrapper.WrapperManager.handleSocket(WrapperManager.java:3983)
at
org.tanukisoftware.wrapper.WrapperManager.run(WrapperManager.java:4338)
at java.lang.Thread.run(Unknown Source)
Locked ownable synchronizers:
- None
"Wrapper-Control-Event-Monitor" daemon prio=6 tid=0x000000004a222000 nid=0x19a8
waiting on condition [0x000000004bc9f000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at
org.tanukisoftware.wrapper.WrapperManager$3.run(WrapperManager.java:739)
Locked ownable synchronizers:
- None
"Low Memory Detector" daemon prio=6 tid=0x000000004a21d800 nid=0x1bd4 runnable
[0x0000000000000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"CompilerThread1" daemon prio=10 tid=0x000000004a20e800 nid=0x1804 waiting on
condition [0x0000000000000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"CompilerThread0" daemon prio=10 tid=0x000000004a206800 nid=0xcb4 waiting on
condition [0x0000000000000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"Attach Listener" daemon prio=10 tid=0x000000004a205000 nid=0x11c8 waiting on
condition [0x0000000000000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"Signal Dispatcher" daemon prio=10 tid=0x000000004a204000 nid=0xbec runnable
[0x0000000000000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"Finalizer" daemon prio=8 tid=0x000000004a1ac000 nid=0x17d4 in Object.wait()
[0x000000004b00f000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x0000000009a5f2e0> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(Unknown Source)
- locked <0x0000000009a5f2e0> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(Unknown Source)
at java.lang.ref.Finalizer$FinalizerThread.run(Unknown Source)
Locked ownable synchronizers:
- None
"Reference Handler" daemon prio=10 tid=0x000000004a1ab000 nid=0x1b0c in
Object.wait() [0x000000004af0f000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x0000000009a5f298> (a java.lang.ref.Reference$Lock)
at java.lang.Object.wait(Object.java:485)
at java.lang.ref.Reference$ReferenceHandler.run(Unknown Source)
- locked <0x0000000009a5f298> (a java.lang.ref.Reference$Lock)
Locked ownable synchronizers:
- None
"VM Thread" prio=10 tid=0x000000004a1a5800 nid=0xe04 runnable
"GC task thread#0 (ParallelGC)" prio=6 tid=0x00000000004a6800 nid=0x1380
runnable
"GC task thread#1 (ParallelGC)" prio=6 tid=0x00000000004a9000 nid=0xf14
runnable
"GC task thread#2 (ParallelGC)" prio=6 tid=0x00000000004ab000 nid=0x1888
runnable
"GC task thread#3 (ParallelGC)" prio=6 tid=0x00000000004ac800 nid=0x1b14
runnable
"GC task thread#4 (ParallelGC)" prio=6 tid=0x00000000004b0000 nid=0x197c
runnable
"GC task thread#5 (ParallelGC)" prio=6 tid=0x00000000004b1000 nid=0x10cc
runnable
"GC task thread#6 (ParallelGC)" prio=6 tid=0x00000000004b2800 nid=0x18dc
runnable
"GC task thread#7 (ParallelGC)" prio=6 tid=0x00000000004b3800 nid=0x1b80
runnable
"VM Periodic Task Thread" prio=10 tid=0x000000004a21e800 nid=0x1298 waiting on
condition
JNI global references: 1261
2011-10-11 11:28:37
Full thread dump Java HotSpot(TM) 64-Bit Server VM (16.3-b01 mixed mode):
"H2 Log Writer HI_COUGAR10" daemon prio=6 tid=0x000000004a31c800 nid=0xfa4
waiting for monitor entry [0x000000004d43f000]
java.lang.Thread.State: BLOCKED (on object monitor)
at org.h2.engine.Database.flush(Database.java:1745)
- waiting to lock <0x0000000009ce7c80> (a org.h2.engine.Database)
at org.h2.store.WriterThread.run(WriterThread.java:84)
at java.lang.Thread.run(Unknown Source)
Locked ownable synchronizers:
- None
"H2 File Lock Watchdog C:\DB\cougardb_hi\hi_cougar10.lock.db" daemon prio=10
tid=0x000000004a23a000 nid=0xe5c waiting on condition [0x000000004cb3f000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at org.h2.store.FileLock.run(FileLock.java:492)
at java.lang.Thread.run(Unknown Source)
Locked ownable synchronizers:
- None
"H2 TCP Server (tcp://10.16.15.122:1234) thread" prio=6 tid=0x000000004a2f3000
nid=0xcf4 waiting on condition [0x000000004ca3f000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at org.h2.engine.Session.waitIfExclusiveModeEnabled(Session.java:1097)
at org.h2.command.Command.executeQuery(Command.java:174)
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
- locked <0x0000000009d1aa80> (a org.h2.engine.Session)
at org.h2.store.LobStorage.getInputStream(LobStorage.java:467)
- locked <0x0000000009ce7c80> (a org.h2.engine.Database)
at org.h2.value.ValueLobDb.getInputStream(ValueLobDb.java:281)
at org.h2.value.ValueLobDb.getReader(ValueLobDb.java:267)
at org.h2.value.ValueLobDb.getString(ValueLobDb.java:188)
at org.h2.value.ValueLobDb.getSQL(ValueLobDb.java:302)
at org.h2.command.dml.ScriptCommand.query(ScriptCommand.java:274)
at org.h2.command.CommandContainer.query(CommandContainer.java:82)
at org.h2.command.Command.executeQuery(Command.java:185)
- locked <0x0000000009ce7c80> (a org.h2.engine.Database)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:278)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
at java.lang.Thread.run(Unknown Source)
Locked ownable synchronizers:
- None
"H2 TCP Server (tcp://10.16.15.122:1234)" prio=6 tid=0x000000004a38a000
nid=0xd44 runnable [0x000000004c93f000]
java.lang.Thread.State: RUNNABLE
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(Unknown Source)
- locked <0x0000000009d66550> (a java.net.SocksSocketImpl)
at java.net.ServerSocket.implAccept(Unknown Source)
at java.net.ServerSocket.accept(Unknown Source)
at org.h2.server.TcpServer.listen(TcpServer.java:239)
at org.h2.tools.Server.run(Server.java:451)
at java.lang.Thread.run(Unknown Source)
Locked ownable synchronizers:
- None
"H2 Console Server (http://10.16.15.122:8144)" prio=6 tid=0x000000004a2f4000
nid=0x14fc runnable [0x000000004c73f000]
java.lang.Thread.State: RUNNABLE
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(Unknown Source)
- locked <0x0000000009d65ae0> (a java.net.SocksSocketImpl)
at java.net.ServerSocket.implAccept(Unknown Source)
at java.net.ServerSocket.accept(Unknown Source)
at org.h2.server.web.WebServer.listen(WebServer.java:339)
at org.h2.tools.Server.run(Server.java:451)
at java.lang.Thread.run(Unknown Source)
Locked ownable synchronizers:
- None
"DestroyJavaVM" prio=6 tid=0x00000000005db800 nid=0xdd8 waiting on condition
[0x0000000000000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"Wrapper-Connection" daemon prio=10 tid=0x000000004a2e0000 nid=0x1790 runnable
[0x000000004beff000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at java.io.DataInputStream.readByte(Unknown Source)
at
org.tanukisoftware.wrapper.WrapperManager.handleSocket(WrapperManager.java:3983)
at
org.tanukisoftware.wrapper.WrapperManager.run(WrapperManager.java:4338)
at java.lang.Thread.run(Unknown Source)
Locked ownable synchronizers:
- None
"Wrapper-Control-Event-Monitor" daemon prio=6 tid=0x000000004a2af800 nid=0x38c
waiting on condition [0x000000004bcff000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at
org.tanukisoftware.wrapper.WrapperManager$3.run(WrapperManager.java:739)
Locked ownable synchronizers:
- None
"Low Memory Detector" daemon prio=6 tid=0x000000004a2ab000 nid=0x17f0 runnable
[0x0000000000000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"CompilerThread1" daemon prio=10 tid=0x000000004a29c000 nid=0x19c8 waiting on
condition [0x0000000000000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"CompilerThread0" daemon prio=10 tid=0x000000004a286800 nid=0xee8 waiting on
condition [0x0000000000000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"Attach Listener" daemon prio=10 tid=0x000000004a285000 nid=0x1634 waiting on
condition [0x0000000000000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"Signal Dispatcher" daemon prio=10 tid=0x000000004a284000 nid=0x3dc runnable
[0x0000000000000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"Finalizer" daemon prio=8 tid=0x000000004a22c000 nid=0x149c in Object.wait()
[0x000000004b08f000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x0000000009cb2a20> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(Unknown Source)
- locked <0x0000000009cb2a20> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(Unknown Source)
at java.lang.ref.Finalizer$FinalizerThread.run(Unknown Source)
Locked ownable synchronizers:
- None
"Reference Handler" daemon prio=10 tid=0x000000004a22b000 nid=0x2a0 in
Object.wait() [0x000000004af8f000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x0000000009ca8088> (a java.lang.ref.Reference$Lock)
at java.lang.Object.wait(Object.java:485)
at java.lang.ref.Reference$ReferenceHandler.run(Unknown Source)
- locked <0x0000000009ca8088> (a java.lang.ref.Reference$Lock)
Locked ownable synchronizers:
- None
"VM Thread" prio=10 tid=0x000000004a225800 nid=0x1290 runnable
"GC task thread#0 (ParallelGC)" prio=6 tid=0x00000000004a6800 nid=0xb6c
runnable
"GC task thread#1 (ParallelGC)" prio=6 tid=0x00000000004a9000 nid=0x900
runnable
"GC task thread#2 (ParallelGC)" prio=6 tid=0x00000000004ab000 nid=0xd34
runnable
"GC task thread#3 (ParallelGC)" prio=6 tid=0x00000000004ac800 nid=0x1650
runnable
"GC task thread#4 (ParallelGC)" prio=6 tid=0x00000000004b0000 nid=0x16c0
runnable
"GC task thread#5 (ParallelGC)" prio=6 tid=0x00000000004b1000 nid=0x12ac
runnable
"GC task thread#6 (ParallelGC)" prio=6 tid=0x00000000004b2800 nid=0xbe8
runnable
"GC task thread#7 (ParallelGC)" prio=6 tid=0x00000000004b3800 nid=0x1934
runnable
"VM Periodic Task Thread" prio=10 tid=0x000000004a2ac000 nid=0xce8 waiting on
condition
JNI global references: 1214
