Hi,
I am having an issue with processor usage permanently in the 5% - 50% for
an H2 Server Mode deployment when no reads or writes are taking place. Some
details about the system:
- 24 proc box with SSD's
- 5 H2 database servers running on the machine, serving different
instances of the application.
- Each H2 server runs their own single local database, each with the
same schema, of about 15 tables.
- There are several large tables:
- GRAPH_LINK = 1,600,000 rows
- GRAPH = 1,200,000 rows
- GRAPH_VALUE_BOOLEAN = 30,000 rows
- GRAPH_VALUE_DATEONLY = 80,000 rows
- GRAPH_VALUE_DOUBLE = 70,000 rows
- GRAPH_VALUE_INTEGER = 90,000 rows
- The other tables
- About 10 client applications connect into each H2 server.
- Running in TCP Server mode.
- The usage profile:
- Most of the rows to be written in the first 2 minutes
- Small numbers (10's) written per hour after that
- Very occasional large reads of perhaps 200,000 rows. (These can be
discounted as they are not happening at the moment)
- No small reads.
-
- The server is configured Server.createTcpServer(...) and passed
-tcpPort -baseDir and -tcpAllowOthers
- The clients are configured:
-
jdbc:h2:tcp://localhost:20530//var/eBondTS/datacache/ebond-neondesk-bondbanks
- Hardware
- 24 * Intel(R) Xeon(R) CPU E5-4617 0 @ 2.90GHz
- OS
- Red Hat Enterprise Linux Server release 6.3 (Santiago)
- Linux ebondfm2i10 2.6.32-279.5.1.el6.x86_64 #1 SMP Tue Jul 24
13:57:35 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
I have attached a thread dump, and the ddl files
Am I doing something wrong, or is this normal?
Kind Regards
Stephen
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
2014-12-03 22:16:05
Full thread dump Java HotSpot(TM) 64-Bit Server VM (24.0-b56 mixed mode):
"Attach Listener" daemon prio=10 tid=0x00007f7e24001000 nid=0x90b1 waiting on
condition [0x0000000000000000]
java.lang.Thread.State: RUNNABLE
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de802d800 nid=0x8989 runnable [0x00007f7e54cd1000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0cd7580> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de802b000 nid=0x8988 runnable [0x00007f7e54dd2000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0ce16e8> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8029800 nid=0x8987 runnable [0x00007f7e54ed3000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0cbca58> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8028000 nid=0x8986 runnable [0x00007f7e54fd4000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0ce1880> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8026800 nid=0x8985 runnable [0x00007f7e550d5000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0ce19b0> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8025000 nid=0x8984 runnable [0x00007f7e551d6000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0dad020> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8023800 nid=0x8983 runnable [0x00007f7e552d7000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0dad108> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8022000 nid=0x8982 runnable [0x00007f7e553d8000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0dad508> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8020000 nid=0x8981 runnable [0x00007f7e554d9000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0dadcc0> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de801e800 nid=0x8980 runnable [0x00007f7e555da000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0dd0260> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de801d000 nid=0x897f runnable [0x00007f7e556db000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0dd0f20> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de801b800 nid=0x8907 runnable [0x00007f7e557dc000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0de5880> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8019800 nid=0x88f0 runnable [0x00007f7e558dd000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0de7110> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8017800 nid=0x889d runnable [0x00007f7e559de000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0df8160> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8015800 nid=0x889b runnable [0x00007f7e55adf000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0df8ad0> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8013800 nid=0x8888 runnable [0x00007f7e55be0000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0e095f0> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8011800 nid=0x887d runnable [0x00007f7e55ce1000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0e096d8> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de800f000 nid=0x8878 runnable [0x00007f7e55de2000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0e097c0> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de800d000 nid=0x8877 runnable [0x00007f7e55ee3000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0e098a8> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de800b800 nid=0x885b runnable [0x00007f7e55fe4000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0e09990> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de800a000 nid=0x8849 runnable [0x00007f7e560e5000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0e09a78> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8008000 nid=0x8844 runnable [0x00007f7e561e6000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0e2afd0> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8006800 nid=0x883b runnable [0x00007f7e562e7000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0e2fe98> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8005000 nid=0x8823 runnable [0x00007f7e563e8000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0e314b8> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8001800 nid=0x8181 runnable [0x00007f7e564e9000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0e42300> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"MVStore background writer
nio:/var/eBondTS/datacache/ebond-neondesk-bondbanks.mv.db" daemon prio=10
tid=0x00007f7dec010800 nid=0x80c3 in Object.wait() [0x00007f7e566eb000]
java.lang.Thread.State: TIMED_WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x00000000e0e544a8> (a java.lang.Object)
at org.h2.mvstore.MVStore$BackgroundWriterThread.run(MVStore.java:2532)
- locked <0x00000000e0e544a8> (a java.lang.Object)
"H2 TCP Server (tcp://10.143.23.18:20650) thread" prio=10
tid=0x00007f7de8003000 nid=0x80ab runnable [0x00007f7e565ea000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x00000000e0eb1560> (a java.io.BufferedInputStream)
at java.io.DataInputStream.readInt(DataInputStream.java:387)
at org.h2.value.Transfer.readInt(Transfer.java:154)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:257)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Thread.java:724)
"DestroyJavaVM" prio=10 tid=0x00007f7e9000b000 nid=0x77d9 waiting on condition
[0x0000000000000000]
java.lang.Thread.State: RUNNABLE
"H2 TCP Server (tcp://10.143.23.18:20650)" prio=10 tid=0x00007f7e905b0000
nid=0x781a runnable [0x00007f7e567ec000]
java.lang.Thread.State: RUNNABLE
at java.net.PlainSocketImpl.socketAccept(Native Method)
at
java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:398)
at java.net.ServerSocket.implAccept(ServerSocket.java:530)
at java.net.ServerSocket.accept(ServerSocket.java:498)
at org.h2.server.TcpServer.listen(TcpServer.java:250)
at org.h2.tools.Server.run(Server.java:568)
at java.lang.Thread.run(Thread.java:724)
"JTS-UdpPublisher-SingleThreadScheduledExecutor-0" prio=10
tid=0x00007f7e0c001000 nid=0x780b waiting on condition [0x00007f7e568ed000]
java.lang.Thread.State: TIMED_WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x00000000e0d122d0> (a
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
at
java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:226)
at
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2082)
at
java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1090)
at
java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:807)
at
java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1068)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
"JTS-ValueSupplierProcessing-FixedThreadPool(2)-1" prio=10
tid=0x00007f7e04004800 nid=0x7805 waiting on condition [0x00007f7e569ee000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x00000000e0d12780> (a
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
at java.util.concurrent.locks.LockSupport.park(LockSupport.java:186)
at
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2043)
at
java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:442)
at
java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1068)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
"JTS-CaptureScheduling-ScheduledThreadPool(2)-1" prio=10 tid=0x00007f7e04002800
nid=0x7804 waiting on condition [0x00007f7e56aef000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x00000000e0d10638> (a
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
at java.util.concurrent.locks.LockSupport.park(LockSupport.java:186)
at
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2043)
at
java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1085)
at
java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:807)
at
java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1068)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
"JTS-ValueSupplierProcessing-FixedThreadPool(2)-0" prio=10
tid=0x00007f7e04001000 nid=0x7803 waiting on condition [0x00007f7e56bf0000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x00000000e0d12780> (a
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
at java.util.concurrent.locks.LockSupport.park(LockSupport.java:186)
at
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2043)
at
java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:442)
at
java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1068)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
"JTS-CaptureScheduling-ScheduledThreadPool(2)-0" prio=10 tid=0x00007f7e9050e800
nid=0x7802 waiting on condition [0x00007f7e56cf1000]
java.lang.Thread.State: TIMED_WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x00000000e0d10638> (a
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
at
java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:226)
at
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2082)
at
java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1090)
at
java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:807)
at
java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1068)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
"JTS-CaptureEvent-SingleThreadExecutor-0" prio=10 tid=0x00007f7e9050d800
nid=0x7801 waiting on condition [0x00007f7e56df2000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x00000000e0d12e80> (a
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
at java.util.concurrent.locks.LockSupport.park(LockSupport.java:186)
at
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2043)
at
java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:442)
at
java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1068)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
"JTS-TimeSeriesEvent-SingleThreadExecutor-0" prio=10 tid=0x00007f7e08002800
nid=0x7800 waiting on condition [0x00007f7e56ef3000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x00000000e0d05408> (a
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
at java.util.concurrent.locks.LockSupport.park(LockSupport.java:186)
at
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2043)
at
java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:442)
at
java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1068)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
"JTS-IdentifiableTreeEvent-SingleThreadExecutor-0" prio=10
tid=0x00007f7e904e2000 nid=0x77ff waiting on condition [0x00007f7e56ff4000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x00000000e0d13390> (a
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
at java.util.concurrent.locks.LockSupport.park(LockSupport.java:186)
at
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2043)
at
java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:442)
at
java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1068)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
"Service Thread" daemon prio=10 tid=0x00007f7e900b4800 nid=0x77f2 runnable
[0x0000000000000000]
java.lang.Thread.State: RUNNABLE
"C2 CompilerThread1" daemon prio=10 tid=0x00007f7e900b2800 nid=0x77f1 waiting
on condition [0x0000000000000000]
java.lang.Thread.State: RUNNABLE
"C2 CompilerThread0" daemon prio=10 tid=0x00007f7e900af800 nid=0x77f0 waiting
on condition [0x0000000000000000]
java.lang.Thread.State: RUNNABLE
"Signal Dispatcher" daemon prio=10 tid=0x00007f7e900a5800 nid=0x77ef runnable
[0x0000000000000000]
java.lang.Thread.State: RUNNABLE
"Finalizer" daemon prio=10 tid=0x00007f7e9008f800 nid=0x77ee in Object.wait()
[0x00007f7e57dfc000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x00000000e0ce30c0> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:135)
- locked <0x00000000e0ce30c0> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:151)
at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:189)
"Reference Handler" daemon prio=10 tid=0x00007f7e9008b000 nid=0x77ed in
Object.wait() [0x00007f7e57efd000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x00000000e0ce2b10> (a java.lang.ref.Reference$Lock)
at java.lang.Object.wait(Object.java:503)
at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:133)
- locked <0x00000000e0ce2b10> (a java.lang.ref.Reference$Lock)
"VM Thread" prio=10 tid=0x00007f7e90089000 nid=0x77ec runnable
"GC task thread#0 (ParallelGC)" prio=10 tid=0x00007f7e90020800 nid=0x77da
runnable
"GC task thread#1 (ParallelGC)" prio=10 tid=0x00007f7e90022800 nid=0x77db
runnable
"GC task thread#2 (ParallelGC)" prio=10 tid=0x00007f7e90024800 nid=0x77dc
runnable
"GC task thread#3 (ParallelGC)" prio=10 tid=0x00007f7e90026800 nid=0x77dd
runnable
"GC task thread#4 (ParallelGC)" prio=10 tid=0x00007f7e90028000 nid=0x77de
runnable
"GC task thread#5 (ParallelGC)" prio=10 tid=0x00007f7e9002a000 nid=0x77df
runnable
"GC task thread#6 (ParallelGC)" prio=10 tid=0x00007f7e9002c000 nid=0x77e0
runnable
"GC task thread#7 (ParallelGC)" prio=10 tid=0x00007f7e9002d800 nid=0x77e1
runnable
"GC task thread#8 (ParallelGC)" prio=10 tid=0x00007f7e9002f800 nid=0x77e2
runnable
"GC task thread#9 (ParallelGC)" prio=10 tid=0x00007f7e90031800 nid=0x77e3
runnable
"GC task thread#10 (ParallelGC)" prio=10 tid=0x00007f7e90033800 nid=0x77e4
runnable
"GC task thread#11 (ParallelGC)" prio=10 tid=0x00007f7e90035000 nid=0x77e5
runnable
"GC task thread#12 (ParallelGC)" prio=10 tid=0x00007f7e90037000 nid=0x77e6
runnable
"GC task thread#13 (ParallelGC)" prio=10 tid=0x00007f7e90039000 nid=0x77e7
runnable
"GC task thread#14 (ParallelGC)" prio=10 tid=0x00007f7e9003a800 nid=0x77e8
runnable
"GC task thread#15 (ParallelGC)" prio=10 tid=0x00007f7e9003c800 nid=0x77e9
runnable
"GC task thread#16 (ParallelGC)" prio=10 tid=0x00007f7e9003e800 nid=0x77ea
runnable
"GC task thread#17 (ParallelGC)" prio=10 tid=0x00007f7e90040800 nid=0x77eb
runnable
"VM Periodic Task Thread" prio=10 tid=0x00007f7e900bf800 nid=0x77f3 waiting on
condition
JNI global references: 154
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
create table bag (
topology_id bigint not null,
parent_hub_id bigint not null,
primary key (topology_id)
);
create table hub (
topology_id bigint not null,
listenPort integer,
primary key (topology_id)
);
create table topology (
id bigint not null,
name varchar(50) not null,
startupToleranceMs integer not null,
heartbeatIntervalMs integer not null,
heartbeatJitterToleranceMs integer not null,
enableHtmlMBean boolean not null,
htmlMBeanPort integer not null,
enableJvmDebugging boolean not null,
jvmDebuggingPort integer not null,
jvmArgsSpaceSeparated varchar(5000) not null,
primary key (id)
);
alter table bag
add constraint FKBagTopology
foreign key (topology_id)
references topology;
alter table bag
add constraint FKBagParentHub
foreign key (parent_hub_id)
references hub;
alter table hub
add constraint FKHubTopology
foreign key (topology_id)
references topology;
create sequence topology_seq;
create table graph (
id bigint not null,
type varchar(1) not null,
host_mount_id bigint not null,
parent_graph_id bigint,
name varchar(50) not null,
calculationTypeIdentity varchar(100) not null,
persisted boolean not null,
logging boolean not null,
host_bag_id bigint,
primary key (id)
);
create table graph_link (
destination_graph_id bigint not null,
source_graph_id bigint not null,
destination_index integer not null,
primary key (destination_graph_id, destination_index)
);
create table graph_value_boolean (
graph_id bigint not null,
idx integer not null,
value boolean not null,
primary key (graph_id, idx)
);
create table graph_value_integer (
graph_id bigint not null,
idx integer not null,
value integer not null,
primary key (graph_id, idx)
);
create table graph_value_long (
graph_id bigint not null,
idx integer not null,
value bigint not null,
primary key (graph_id, idx)
);
create table graph_value_double (
graph_id bigint not null,
idx integer not null,
value double not null,
primary key (graph_id, idx)
);
create table graph_value_dateonly (
graph_id bigint not null,
idx integer not null,
value integer,
primary key (graph_id, idx)
);
create table graph_value_datetime (
graph_id bigint not null,
idx integer not null,
value bigint,
primary key (graph_id, idx)
);
create table graph_value_string (
graph_id bigint not null,
idx integer not null,
part integer not null,
value varchar(250),
primary key (graph_id, idx, part)
);
create index IDXParentGraph on graph (parent_graph_id);
create index IDXHostMount on graph (host_mount_id);
create index IDXSourceGraphId on graph_link (source_graph_id);
alter table graph
add constraint FKGraphHostMount
foreign key (host_mount_id)
references graph(id);
alter table graph
add constraint FKGraphParentGraph
foreign key (parent_graph_id)
references graph(id);
alter table graph
add constraint FKMountsHostBag
foreign key (host_bag_id)
references bag(topology_id);
alter table graph_link
add constraint FKGraphsLinkDestination
foreign key (destination_graph_id)
references graph(id);
create sequence graph_seq;
