[prev in list] [next in list] [prev in thread] [next in thread]
List: hsqldb-user
Subject: Re: [Hsqldb-user] Problem stopping the hsqldb server
From: "Fred Toussi" <fredt () users ! sourceforge ! net>
Date: 2011-06-30 20:21:45
Message-ID: 1309465305.14319.1469074213 () webmail ! messagingengine ! com
[Download RAW message or body]
This is a multi-part message in MIME format.
--_----------=_1309465305143190
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="us-ascii"
Date: Thu, 30 Jun 2011 16:21:45 -0400
X-Mailer: MessagingEngine.com Webmail Interface
Hi Tom,
Thanks for the info.
We need to analyze and investigate this further and try to
reproduce with the information you have provided.
As a workaround, I thinks you should use the server.noexit=true
property. Then after the SHUTDOWN, just kill the server process.
The --remote_open method is actually designed _not_ to shutdown
the server but only the database when a SHUTDOWN happens, it
implies --noexit. One uses this method to start the server empty,
then specify the name and path on the connection URL. Perhaps it
would be better to remove this line completely from your
properties file
The file listing shows no .lck file. This file is present between
the first connection to a database and its shutdown. So it seems
the actual shutdown of the database took place. You can verify by
comparing the file timestamp with the time you shutdown, also the
property modified=no in the bookfiles.properties.
The flow of execution at shutdown is identical for a database
that was created and one that was reopened, so the difference you
mention is puzzling.
The thread dump shows the server is waiting for all the
connections to close, which should happen at shutdown but doesn't
seem to. Like it would behave with noexit=true
Fred
On Thu, 30 Jun 2011 11:54 -0700, "Tom Smith"
<hsqldbpost@gmail.com> wrote:
Hi Fred,
Directory listing below, in the output
I started with no bookfiles.*
I started the server, shut it down successfully, started it
again, shut it down again and the server didn't exit.
hsqldb/bookfiles didn't exist before I started.
================================
toms-MacBook-Pro:Activities tom$ sh shutdown.sh
Disconnected from JDBC Data Source
toms-MacBook-Pro:Activities tom$ sh shutdown.sh
Disconnected from JDBC Data Source
toms-MacBook-Pro:Activities tom$ ls -al hsqldb
total 24
drwxr-xr-x 7 tom staff 238 Jun 30 11:45 .
drwxr-xr-x 15 tom staff 510 Jun 30 11:43 ..
drwxr-xr-x 8 tom staff 272 Jun 30 11:42 .svn
-rw-r--r-- 1 tom staff 84 Jun 30 11:45
bookfiles.properties
-rw-r--r-- 1 tom staff 1609 Jun 30 11:45 bookfiles.script
drwxr-xr-x 6 tom staff 204 Jun 30 11:39 lib
-rwxr-xr-x 1 tom staff 81 Jun 30 09:58 server.properties
toms-MacBook-Pro:Activities tom$ cat shutdown.sh
#!/bin/bash
# Insert sample records into the database
java -jar hsqldb/lib/sqltool.jar --rcfile=sqltool.rc --sql
"shutdown;" localhost-sa">localhost-sa
==========================================================
And I'll add a thread dump, in case that helps.
Tom
2011-06-30 11:51:35
Full thread dump Java HotSpot(TM) 64-Bit Server VM
(20.1-b02-384 mixed mode):
"RMI TCP Connection(idle)" daemon prio=9 tid=10a9c7000
nid=0x10da0d000 waiting on condition [10da0c000]
java.lang.Thread.State: TIMED_WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <7f40a0070> (a
java.util.concurrent.SynchronousQueue$TransferStack">Synchrono
usQueue$TransferStack)
at
java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.j
ava:198)
at
java.util.concurrent.SynchronousQueue$TransferStack">Synchrono
usQueue$TransferStack.awaitFulfill(SynchronousQueue.java:424)
at
java.util.concurrent.SynchronousQueue$TransferStack">Synchrono
usQueue$TransferStack.transfer(SynchronousQueue.java:323)
at
java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.ja
va:874)
at
java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExec
utor.java:945)
at
java.util.concurrent.ThreadPoolExecutor$Worker">ThreadPoolExec
utor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:680)
Locked ownable synchronizers:
- None
"JMX server connection timeout 21" daemon prio=9 tid=1018dc800
nid=0x10d90a000 in Object.wait() [10d909000]
java.lang.Thread.State: TIMED_WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <7f40d4490> (a [I)
at
com.sun.jmx.remote.internal.ServerCommunicatorAdmin$Timeout">S
erverCommunicatorAdmin$Timeout.run(ServerCommunicatorAdmin.jav
a:150)
- locked <7f40d4490> (a [I)
at java.lang.Thread.run(Thread.java:680)
Locked ownable synchronizers:
- None
"RMI Scheduler(0)" daemon prio=9 tid=101927800 nid=0x10d807000
waiting on condition [10d806000]
java.lang.Thread.State: TIMED_WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <7f41088b0> (a
java.util.concurrent.locks.AbstractQueuedSynchronizer$Conditio
nObject">AbstractQueuedSynchronizer$ConditionObject)
at
java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.j
ava:198)
at
java.util.concurrent.locks.AbstractQueuedSynchronizer$Conditio
nObject">AbstractQueuedSynchronizer$ConditionObject.awaitNanos
(AbstractQueuedSynchronizer.java:2025)
at
java.util.concurrent.DelayQueue.take(DelayQueue.java:164)
at
java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQu
eue">ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Schedul
edThreadPoolExecutor.java:609)
at
java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQu
eue">ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Schedul
edThreadPoolExecutor.java:602)
at
java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExec
utor.java:947)
at
java.util.concurrent.ThreadPoolExecutor$Worker">ThreadPoolExec
utor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:680)
Locked ownable synchronizers:
- None
"RMI TCP Connection(1)-10.100.100.107" daemon prio=9
tid=101920800 nid=0x10d704000 runnable [10d702000]
java.lang.Thread.State: RUNNABLE
at java.lang.Long.toString(Long.java:101)
at java.rmi.server.UID.toString(UID.java:192)
at java.lang.String.valueOf(String.java:2826)
at java.lang.StringBuilder.append(StringBuilder.java:115)
at java.rmi.server.ObjID.toString(ObjID.java:222)
at
sun.rmi.server.UnicastServerRef.logCall(UnicastServerRef.java:
435)
at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java
:281)
at sun.rmi.transport.Transport$1.run(Transport.java:159)
at java.security.AccessController.doPrivileged(Native
Method)
at
sun.rmi.transport.Transport.serviceCall(Transport.java:155)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport
.java:535)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler">TCPTrans
port$ConnectionHandler.run0(TCPTransport.java:790)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler">TCPTrans
port$ConnectionHandler.run(TCPTransport.java:649)
at
java.util.concurrent.ThreadPoolExecutor$Worker">ThreadPoolExec
utor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker">ThreadPoolExec
utor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:680)
Locked ownable synchronizers:
- <7f4141a48> (a
java.util.concurrent.locks.ReentrantLock$NonfairSync)
"RMI TCP Accept-0" daemon prio=9 tid=10b876000 nid=0x10d601000
runnable [10d600000]
java.lang.Thread.State: RUNNABLE
at java.net.PlainSocketImpl.socketAccept(Native Method)
at
java.net.PlainSocketImpl.accept(PlainSocketImpl.java:408)
- locked <7f40d4538> (a java.net.SocksSocketImpl)
at java.net.ServerSocket.implAccept(ServerSocket.java:462)
at java.net.ServerSocket.accept(ServerSocket.java:430)
at
sun.management.jmxremote.LocalRMIServerSocketFactory$1">LocalR
MIServerSocketFactory$1.accept(LocalRMIServerSocketFactory.jav
a:34)
at
sun.rmi.transport.tcp.TCPTransport$AcceptLoop">TCPTransport$Ac
ceptLoop.executeAcceptLoop(TCPTransport.java:369)
at
sun.rmi.transport.tcp.TCPTransport$AcceptLoop">TCPTransport$Ac
ceptLoop.run(TCPTransport.java:341)
at java.lang.Thread.run(Thread.java:680)
Locked ownable synchronizers:
- None
"Attach Listener" daemon prio=9 tid=10b88f000 nid=0x10d201000
waiting on condition [00000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"Poller SunPKCS11-Darwin">SunPKCS11-Darwin" daemon prio=1
tid=10a90c000 nid=0x10d307000 waiting on condition [10d306000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at
sun.security.pkcs11.SunPKCS11$TokenPoller">SunPKCS11$TokenPoll
er.run(SunPKCS11.java:692)
at java.lang.Thread.run(Thread.java:680)
Locked ownable synchronizers:
- None
"DestroyJavaVM" prio=5 tid=10a90b000 nid=0x100501000 waiting
on condition [00000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"HSQLDB Server @77df38fd" prio=5 tid=10b81f000 nid=0x10b701000
waiting on condition [10b700000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at org.hsqldb.server.Server.shutdown(Unknown Source)
- locked <7f44e8fa0> (a org.hsqldb.server.Server)
at org.hsqldb.server.Server.run(Unknown Source)
at org.hsqldb.server.Server.access$000(Unknown Source)
at org.hsqldb.server.Server$ServerThread.run(Unknown
Source)
Locked ownable synchronizers:
- None
"Low Memory Detector" daemon prio=5 tid=1028dd000
nid=0x10b307000 runnable [00000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"C2 CompilerThread1" daemon prio=9 tid=1028dc800
nid=0x10b204000 waiting on condition [00000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"C2 CompilerThread0" daemon prio=9 tid=101800800
nid=0x10b101000 waiting on condition [00000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"Signal Dispatcher" daemon prio=9 tid=1028db800
nid=0x10a701000 runnable [00000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"Surrogate Locker Thread (Concurrent GC)" daemon prio=5
tid=1028da800 nid=0x10a407000 waiting on condition [00000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"Finalizer" daemon prio=8 tid=1028d2000 nid=0x10a0ea000 in
Object.wait() [10a0e9000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <7f44e3a48> (a
java.lang.ref.ReferenceQueue$Lock">ReferenceQueue$Lock)
at
java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118)
- locked <7f44e3a48> (a
java.lang.ref.ReferenceQueue$Lock">ReferenceQueue$Lock)
at
java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:134)
at
java.lang.ref.Finalizer$FinalizerThread">Finalizer$FinalizerTh
read.run(Finalizer.java:159)
Locked ownable synchronizers:
- None
"Reference Handler" daemon prio=10 tid=1028d1000
nid=0x109fe7000 in Object.wait() [109fe6000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <7f44e57e8> (a java.lang.ref.Reference$Lock)
at java.lang.Object.wait(Object.java:485)
at
java.lang.ref.Reference$ReferenceHandler.run(Reference.java:11
6)
- locked <7f44e57e8> (a java.lang.ref.Reference$Lock)
Locked ownable synchronizers:
- None
"VM Thread" prio=9 tid=1028cc800 nid=0x109ee4000 runnable
"Gang worker#0 (Parallel GC Threads)" prio=9 tid=102802800
nid=0x102401000 runnable
"Gang worker#1 (Parallel GC Threads)" prio=9 tid=102803000
nid=0x102504000 runnable
"Gang worker#2 (Parallel GC Threads)" prio=9 tid=102803800
nid=0x102607000 runnable
"Gang worker#3 (Parallel GC Threads)" prio=9 tid=102804000
nid=0x10270a000 runnable
"Concurrent Mark-Sweep GC Thread" prio=9 tid=10287f800
nid=0x109bf0000 runnable
"VM Periodic Task Thread" prio=10 tid=1028ee800
nid=0x10b40a000 waiting on condition
"Exception Catcher Thread" prio=10 tid=102801800
nid=0x1017f9000 runnable
JNI global references: 1007
On Thu, Jun 30, 2011 at 11:27 AM, Fred Toussi
<[1]fredt@users.sourceforge.net> wrote:
Could you post the directory listing for the database files.
Fred
On Thu, 30 Jun 2011 10:12 -0700, "Tom Smith"
<[2]hsqldbpost@gmail.com> wrote:
Hi -
I'm having a problem getting the hsqldb server process to exit.
It just prints
[Server@60072ffb]: Initiating shutdown sequence...
and hangs there.
I'm starting the server with
java -cp lib/hsqldb.jar org.hsqldb.server.Server
server.properties:
server.database.0=file:bookfiles
server.remote_open=false">remote_open=false
server.dbname.0=bookdb
I added server.remote_open to see if it would help. It didn't.
When I start it, it prints:
[Server@60072ffb]: [Thread[main,5,main]]: checkRunning(false)
entered
[Server@60072ffb]: [Thread[main,5,main]]: checkRunning(false)
exited
[Server@60072ffb]: Startup sequence initiated from main() method
[Server@60072ffb]: Loaded properties from
[/Users/tom/repos/training/solr101/Activities/hsqldb/server.prope
rties]
[Server@60072ffb]: Initiating startup sequence...
[Server@60072ffb]: Server socket opened successfully in 6 ms.
[Server@60072ffb]: Database [index=0, id=0, db=file:bookfiles,
alias=bookdb] opened sucessfully in 273 ms.
[Server@60072ffb]: Startup sequence completed in 281 ms.
[Server@60072ffb]: 2011-06-30 10:03:13.315 HSQLDB server 2.2.4 is
online on port 9001
[Server@60072ffb]: To close normally, connect and execute
SHUTDOWN SQL
[Server@60072ffb]: From command line, use [Ctrl]+[C] to abort
abruptly
When I try to shutdown with
java -jar hsqldb/lib/sqltool.jar --rcfile=sqltool.rc --sql
"shutdown;" localhost-sa">localhost-sa
with sqltool.rc containing:
# This is for a hsqldb Server running with default settings on
your local
# computer (and for which you have not changed the password for
"SA").
urlid localhost-sa">localhost-sa
url jdbc:hsqldb:hsql://localhost/bookdb
username SA
password
Then sqltool prints: "Disconnected from JDBC Data Source" It
prints the same, whether the server exits, or not.
The server process prints "[Server@60072ffb]: Initiating shutdown
sequence...", but doesn't exit.
It will exit the first time I open a database, but not the second
time. (If I delete bookfiles.* before starting, it will exit when
shutdown. If the files exist, it won't).
Any suggestions?
Thanks,
Tom
--------------------------------------------------------------------------
----
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
[3]http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Hsqldb-user mailing list
[4]Hsqldb-user@lists">Hsqldb-user@lists.sourceforge.net
[5]https://lists.sourceforge.net/lists/listinfo/hsqldb-user">hsqldb-user
--------------------------------------------------------------
----------------
All of the data generated in your IT infrastructure is
seriously valuable.
Why? It contains a definitive record of application
performance, security
threats, fraudulent activity, and more. Splunk takes this data
and makes
sense of it. IT sense. And common sense.
[6]http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Hsqldb-user mailing list
[7]Hsqldb-user@lists">Hsqldb-user@lists.sourceforge.net
[8]https://lists.sourceforge.net/lists/listinfo/hsqldb-user">h
sqldb-user
--------------------------------------------------------------------------
----
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists">Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user">hsqldb-user
References
1. mailto:fredt@users.sourceforge.net
2. mailto:hsqldbpost@gmail.com
3. http://p.sf.net/sfu/splunk-d2d-c2
4. mailto:Hsqldb-user@lists.sourceforge.net
5. https://lists.sourceforge.net/lists/listinfo/hsqldb-user
6. http://p.sf.net/sfu/splunk-d2d-c2
7. mailto:Hsqldb-user@lists.sourceforge.net
8. https://lists.sourceforge.net/lists/listinfo/hsqldb-user
--_----------=_1309465305143190
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/html; charset="us-ascii"
Date: Thu, 30 Jun 2011 16:21:45 -0400
X-Mailer: MessagingEngine.com Webmail Interface
<!--/*SC*/DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" \
"http://www.w3.org/TR/html4/loose.dtd"/*EC*/--> <html><head><title></title><style \
type="text/css"><!-- \
body{padding:1ex;margin:0;font-family:sans-serif;font-size:small}a[href]{color:-moz-hy \
perlinktext!important;text-decoration:-moz-anchor-decoration}blockquote{margin:0;border-left:2px \
solid #144fae;padding-left:1em}blockquote blockquote{border-color:#006312}blockquote \
blockquote blockquote{border-color:#540000} --></style></head><body><div \
style="font-family: Arial; font-size: medium;" dir="ltr"><div> <div>
Hi Tom,</div>
<div>
</div>
<div>
Thanks for the info.</div>
<div>
</div>
<div>
<div>
We need to analyze and investigate this further and try to reproduce with the \
information you have provided.</div> </div>
<div>
</div>
<div>
As a workaround, I thinks you should use the server.noexit=true property. Then \
after the SHUTDOWN, just kill the server process.</div> <div>
</div>
<div>
The --remote_open method is actually designed _not_ to shutdown the server but only \
the database when a SHUTDOWN happens, it implies --noexit. One uses this method to \
start the server empty, then specify the name and path on the connection URL. Perhaps \
it would be better to remove this line completely from your properties file</div> \
<div> </div>
The file listing shows no .lck file. This file is present between the first \
connection to a database and its shutdown. So it seems the actual shutdown of the \
database took place. You can verify by comparing the file timestamp with the time you \
shutdown, also the property modified=no in the bookfiles.properties. <div>
</div>
<div>
The flow of execution at shutdown is identical for a database that was created and \
one that was reopened, so the difference you mention is puzzling.</div> <div>
</div>
<div>
The thread dump shows the server is waiting for all the connections to close, which \
should happen at shutdown but doesn't seem to. Like it would behave with \
noexit=true</div> <div>
</div>
<div>
Fred</div>
</div>
<div class="defangedMessage">
<div id="me31240">
<div>
On Thu, 30 Jun 2011 11:54 -0700, "Tom Smith" \
<hsqldbpost@gmail.com> wrote:</div> <blockquote class="me31240QuoteMessage" \
type="cite"> <span style="font-family: courier new,monospace;">Hi Fred,</span><br \
style="font-family: courier new,monospace;" /> <br style="font-family: courier \
new,monospace;" /> <span style="font-family: courier new,monospace;">Directory \
listing below, in the output</span><br style="font-family: courier new,monospace;" /> \
<br style="font-family: courier new,monospace;" /> <span style="font-family: courier \
new,monospace;">I started with no bookfiles.*<br /> I started the server, shut it \
down successfully, started it again, shut it down again and the server didn't \
exit.</span><br style="font-family: courier new,monospace;" /> <br \
style="font-family: courier new,monospace;" /> <span style="font-family: courier \
new,monospace;">hsqldb/bookfiles didn't exist before I started.</span><br \
style="font-family: courier new,monospace;" /> <br style="font-family: courier \
new,monospace;" /> <span style="font-family: courier \
new,monospace;">================================</span><br style="font-family: \
courier new,monospace;" /> <span style="font-family: courier \
new,monospace;">toms-MacBook-Pro:Activities tom$ sh shutdown.sh </span><br \
style="font-family: courier new,monospace;" /> <span style="font-family: courier \
new,monospace;">Disconnected from JDBC Data Source</span><br style="font-family: \
courier new,monospace;" /> <span style="font-family: courier \
new,monospace;">toms-MacBook-Pro:Activities tom$ sh shutdown.sh </span><br \
style="font-family: courier new,monospace;" /> <span style="font-family: courier \
new,monospace;">Disconnected from JDBC Data Source</span><br style="font-family: \
courier new,monospace;" /> <span style="font-family: courier \
new,monospace;">toms-MacBook-Pro:Activities tom$ ls -al hsqldb</span><br \
style="font-family: courier new,monospace;" /> <span style="font-family: courier \
new,monospace;">total 24</span><br style="font-family: courier new,monospace;" /> \
<span style="font-family: courier new,monospace;">drwxr-xr-x 7 tom \
staff 238 Jun 30 11:45 .</span><br style="font-family: courier \
new,monospace;" /> <span style="font-family: courier \
new,monospace;">drwxr-xr-x 15 tom staff 510 Jun 30 11:43 \
..</span><br style="font-family: courier new,monospace;" /> <span \
style="font-family: courier new,monospace;">drwxr-xr-x 8 tom \
staff 272 Jun 30 11:42 .svn</span><br style="font-family: courier \
new,monospace;" /> <span style="font-family: courier \
new,monospace;">-rw-r--r-- 1 tom staff 84 Jun 30 \
11:45 bookfiles.properties</span><br style="font-family: courier new,monospace;" /> \
<span style="font-family: courier new,monospace;">-rw-r--r-- 1 tom \
staff 1609 Jun 30 11:45 bookfiles.script</span><br style="font-family: courier \
new,monospace;" /> <span style="font-family: courier \
new,monospace;">drwxr-xr-x 6 tom staff 204 Jun 30 11:39 \
lib</span><br style="font-family: courier new,monospace;" /> <span \
style="font-family: courier new,monospace;">-rwxr-xr-x 1 tom \
staff 81 Jun 30 09:58 server.properties</span><br \
style="font-family: courier new,monospace;" /> <span style="font-family: courier \
new,monospace;">toms-MacBook-Pro:Activities tom$ cat shutdown.sh </span><br \
style="font-family: courier new,monospace;" /> <span style="font-family: courier \
new,monospace;">#!/bin/bash</span><br style="font-family: courier new,monospace;" /> \
<span style="font-family: courier new,monospace;"># Insert sample records into the \
database</span><br style="font-family: courier new,monospace;" /> <span \
style="font-family: courier new,monospace;">java -jar hsqldb/lib/sqltool.jar \
--rcfile=sqltool.rc --sql "shutdown;" \
localhost-sa">localhost-sa</span><br style="font-family: courier \
new,monospace;" /> <span style="font-family: courier \
new,monospace;">==========================================================</span><br \
style="font-family: courier new,monospace;" /> <br />
And I'll add a thread dump, in case that helps.<br />
<br />
Tom<br />
<br />
2011-06-30 11:51:35<br />
Full thread dump Java HotSpot(TM) 64-Bit Server VM (20.1-b02-384 mixed mode):<br \
/> <br />
"RMI TCP Connection(idle)" daemon prio=9 tid=10a9c7000 nid=0x10da0d000 \
waiting on condition [10da0c000]<br /> java.lang.Thread.State: \
TIMED_WAITING (parking)<br /> at sun.misc.Unsafe.park(Native \
Method)<br /> - parking to wait for <7f40a0070> (a \
java.util.concurrent.SynchronousQueue$TransferStack">SynchronousQueue$TransferStack)<br \
/> at \
java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:198)<br /> \
at \
java.util.concurrent.SynchronousQueue$TransferStack">SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:424)<br \
/> at \
java.util.concurrent.SynchronousQueue$TransferStack">SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:323)<br \
/> at \
java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:874)<br /> \
at \
java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:945)<br /> \
at \
java.util.concurrent.ThreadPoolExecutor$Worker">ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)<br \
/> at java.lang.Thread.run(Thread.java:680)<br />
<br />
Locked ownable synchronizers:<br />
- None<br />
<br />
"JMX server connection timeout 21" daemon prio=9 tid=1018dc800 \
nid=0x10d90a000 in Object.wait() [10d909000]<br /> \
java.lang.Thread.State: TIMED_WAITING (on object monitor)<br /> \
at java.lang.Object.wait(Native Method)<br /> - waiting on \
<7f40d4490> (a [I)<br /> at \
com.sun.jmx.remote.internal.ServerCommunicatorAdmin$Timeout">ServerCommunicatorAdmin$Timeout.run(ServerCommunicatorAdmin.java:150)<br \
/> - locked <7f40d4490> (a [I)<br />
at java.lang.Thread.run(Thread.java:680)<br />
<br />
Locked ownable synchronizers:<br />
- None<br />
<br />
"RMI Scheduler(0)" daemon prio=9 tid=101927800 nid=0x10d807000 waiting \
on condition [10d806000]<br /> java.lang.Thread.State: TIMED_WAITING \
(parking)<br /> at sun.misc.Unsafe.park(Native Method)<br />
- parking to wait for <7f41088b0> (a \
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject">AbstractQueuedSynchronizer$ConditionObject)<br \
/> at \
java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:198)<br /> \
at \
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject">Abstrac \
tQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2025)<br \
/> at \
java.util.concurrent.DelayQueue.take(DelayQueue.java:164)<br /> \
at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue">Schedule \
dThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:609)<br /> \
at \
java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue">ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:602)<br \
/> at \
java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:947)<br /> \
at \
java.util.concurrent.ThreadPoolExecutor$Worker">ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)<br \
/> at java.lang.Thread.run(Thread.java:680)<br />
<br />
Locked ownable synchronizers:<br />
- None<br />
<br />
"RMI TCP Connection(1)-10.100.100.107" daemon prio=9 tid=101920800 \
nid=0x10d704000 runnable [10d702000]<br /> java.lang.Thread.State: \
RUNNABLE<br /> at java.lang.Long.toString(Long.java:101)<br />
at java.rmi.server.UID.toString(UID.java:192)<br />
at java.lang.String.valueOf(String.java:2826)<br />
at java.lang.StringBuilder.append(StringBuilder.java:115)<br />
at java.rmi.server.ObjID.toString(ObjID.java:222)<br />
at \
sun.rmi.server.UnicastServerRef.logCall(UnicastServerRef.java:435)<br /> \
at \
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:281)<br /> \
at sun.rmi.transport.Transport$1.run(Transport.java:159)<br /> \
at java.security.AccessController.doPrivileged(Native Method)<br \
/> at \
sun.rmi.transport.Transport.serviceCall(Transport.java:155)<br /> \
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)<br /> \
at \
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler">TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)<br \
/> at \
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler">TCPTransport$ConnectionHandler.run(TCPTransport.java:649)<br \
/> at \
java.util.concurrent.ThreadPoolExecutor$Worker">ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)<br \
/> at \
java.util.concurrent.ThreadPoolExecutor$Worker">ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)<br \
/> at java.lang.Thread.run(Thread.java:680)<br />
<br />
Locked ownable synchronizers:<br />
- <7f4141a48> (a \
java.util.concurrent.locks.ReentrantLock$NonfairSync)<br /> <br />
"RMI TCP Accept-0" daemon prio=9 tid=10b876000 nid=0x10d601000 runnable \
[10d600000]<br /> java.lang.Thread.State: RUNNABLE<br />
at java.net.PlainSocketImpl.socketAccept(Native Method)<br />
at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:408)<br \
/> - locked <7f40d4538> (a java.net.SocksSocketImpl)<br />
at java.net.ServerSocket.implAccept(ServerSocket.java:462)<br \
/> at java.net.ServerSocket.accept(ServerSocket.java:430)<br />
at \
sun.management.jmxremote.LocalRMIServerSocketFactory$1">LocalRMIServerSocketFactory$1.accept(LocalRMIServerSocketFactory.java:34)<br \
/> at \
sun.rmi.transport.tcp.TCPTransport$AcceptLoop">TCPTransport$AcceptLoop.executeAcceptLoop(TCPTransport.java:369)<br \
/> at \
sun.rmi.transport.tcp.TCPTransport$AcceptLoop">TCPTransport$AcceptLoop.run(TCPTransport.java:341)<br \
/> at java.lang.Thread.run(Thread.java:680)<br />
<br />
Locked ownable synchronizers:<br />
- None<br />
<br />
"Attach Listener" daemon prio=9 tid=10b88f000 nid=0x10d201000 waiting on \
condition [00000000]<br /> java.lang.Thread.State: RUNNABLE<br />
<br />
Locked ownable synchronizers:<br />
- None<br />
<br />
"Poller SunPKCS11-Darwin">SunPKCS11-Darwin" daemon prio=1 \
tid=10a90c000 nid=0x10d307000 waiting on condition [10d306000]<br /> \
java.lang.Thread.State: TIMED_WAITING (sleeping)<br /> at \
java.lang.Thread.sleep(Native Method)<br /> at \
sun.security.pkcs11.SunPKCS11$TokenPoller">SunPKCS11$TokenPoller.run(SunPKCS11.java:692)<br \
/> at java.lang.Thread.run(Thread.java:680)<br />
<br />
Locked ownable synchronizers:<br />
- None<br />
<br />
"DestroyJavaVM" prio=5 tid=10a90b000 nid=0x100501000 waiting on \
condition [00000000]<br /> java.lang.Thread.State: RUNNABLE<br />
<br />
Locked ownable synchronizers:<br />
- None<br />
<br />
"HSQLDB Server @77df38fd" prio=5 tid=10b81f000 nid=0x10b701000 waiting \
on condition [10b700000]<br /> java.lang.Thread.State: TIMED_WAITING \
(sleeping)<br /> at java.lang.Thread.sleep(Native Method)<br />
at org.hsqldb.server.Server.shutdown(Unknown Source)<br />
- locked <7f44e8fa0> (a org.hsqldb.server.Server)<br />
at org.hsqldb.server.Server.run(Unknown Source)<br />
at org.hsqldb.server.Server.access$000(Unknown Source)<br />
at org.hsqldb.server.Server$ServerThread.run(Unknown Source)<br \
/> <br />
Locked ownable synchronizers:<br />
- None<br />
<br />
"Low Memory Detector" daemon prio=5 tid=1028dd000 nid=0x10b307000 \
runnable [00000000]<br /> java.lang.Thread.State: RUNNABLE<br />
<br />
Locked ownable synchronizers:<br />
- None<br />
<br />
"C2 CompilerThread1" daemon prio=9 tid=1028dc800 nid=0x10b204000 waiting \
on condition [00000000]<br /> java.lang.Thread.State: RUNNABLE<br />
<br />
Locked ownable synchronizers:<br />
- None<br />
<br />
"C2 CompilerThread0" daemon prio=9 tid=101800800 nid=0x10b101000 waiting \
on condition [00000000]<br /> java.lang.Thread.State: RUNNABLE<br />
<br />
Locked ownable synchronizers:<br />
- None<br />
<br />
"Signal Dispatcher" daemon prio=9 tid=1028db800 nid=0x10a701000 runnable \
[00000000]<br /> java.lang.Thread.State: RUNNABLE<br />
<br />
Locked ownable synchronizers:<br />
- None<br />
<br />
"Surrogate Locker Thread (Concurrent GC)" daemon prio=5 tid=1028da800 \
nid=0x10a407000 waiting on condition [00000000]<br /> \
java.lang.Thread.State: RUNNABLE<br /> <br />
Locked ownable synchronizers:<br />
- None<br />
<br />
"Finalizer" daemon prio=8 tid=1028d2000 nid=0x10a0ea000 in Object.wait() \
[10a0e9000]<br /> java.lang.Thread.State: WAITING (on object \
monitor)<br /> at java.lang.Object.wait(Native Method)<br />
- waiting on <7f44e3a48> (a \
java.lang.ref.ReferenceQueue$Lock">ReferenceQueue$Lock)<br /> \
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118)<br \
/> - locked <7f44e3a48> (a \
java.lang.ref.ReferenceQueue$Lock">ReferenceQueue$Lock)<br /> \
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:134)<br \
/> at \
java.lang.ref.Finalizer$FinalizerThread">Finalizer$FinalizerThread.run(Finalizer.java:159)<br \
/> <br />
Locked ownable synchronizers:<br />
- None<br />
<br />
"Reference Handler" daemon prio=10 tid=1028d1000 nid=0x109fe7000 in \
Object.wait() [109fe6000]<br /> java.lang.Thread.State: WAITING (on \
object monitor)<br /> at java.lang.Object.wait(Native Method)<br \
/> - waiting on <7f44e57e8> (a \
java.lang.ref.Reference$Lock)<br /> at \
java.lang.Object.wait(Object.java:485)<br /> at \
java.lang.ref.Reference$ReferenceHandler.run(Reference.java:116)<br /> \
- locked <7f44e57e8> (a java.lang.ref.Reference$Lock)<br /> \
<br /> Locked ownable synchronizers:<br />
- None<br />
<br />
"VM Thread" prio=9 tid=1028cc800 nid=0x109ee4000 runnable<br />
<br />
"Gang worker#0 (Parallel GC Threads)" prio=9 tid=102802800 \
nid=0x102401000 runnable<br /> <br />
"Gang worker#1 (Parallel GC Threads)" prio=9 tid=102803000 \
nid=0x102504000 runnable<br /> <br />
"Gang worker#2 (Parallel GC Threads)" prio=9 tid=102803800 \
nid=0x102607000 runnable<br /> <br />
"Gang worker#3 (Parallel GC Threads)" prio=9 tid=102804000 \
nid=0x10270a000 runnable<br /> <br />
"Concurrent Mark-Sweep GC Thread" prio=9 tid=10287f800 nid=0x109bf0000 \
runnable<br /> "VM Periodic Task Thread" prio=10 tid=1028ee800 \
nid=0x10b40a000 waiting on condition<br /> <br />
"Exception Catcher Thread" prio=10 tid=102801800 nid=0x1017f9000 \
runnable<br /> JNI global references: 1007<br />
<br />
<br style="font-family: courier new,monospace;" />
<div class="me31240gmail_quote" style="font-family: courier new,monospace;">
On Thu, Jun 30, 2011 at 11:27 AM, Fred Toussi <span dir="ltr"><<a \
href="mailto:fredt@users.sourceforge.net">fredt@users.sourceforge.net</a>></span> \
wrote:<br /> <blockquote class="me31240gmail_quote" style="margin: 0pt 0pt 0pt \
0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> <div>
<div dir="ltr" style="font-size: medium;">
<div>
Could you post the directory listing for the database files.</div>
<div>
</div>
<div>
Fred</div>
<div>
<div>
<div>
<div>
</div>
<div class="me31240h5">
<div>
On Thu, 30 Jun 2011 10:12 -0700, "Tom Smith" <<a \
href="mailto:hsqldbpost@gmail.com" target="_blank">hsqldbpost@gmail.com</a>> \
wrote:</div> </div>
</div>
<blockquote type="cite">
<div>
<div>
</div>
<div class="me31240h5">
Hi -<br />
<br />
I'm having a problem getting the hsqldb server process to exit. It \
just prints<br /> <br />
[Server@60072ffb]: Initiating shutdown sequence...<br />
<br />
and hangs there.<br />
<br />
I'm starting the server with<br />
<br />
java -cp lib/hsqldb.jar org.hsqldb.server.Server<br />
<br />
server.properties:<br />
server.database.0=file:bookfiles<br />
server.remote_open=false">remote_open=false<br />
server.dbname.0=bookdb<br />
<br />
I added server.remote_open to see if it would help. It didn't.<br />
<br />
When I start it, it prints:<br />
<br />
[Server@60072ffb]: [Thread[main,5,main]]: checkRunning(false) entered<br \
/>
[Server@60072ffb]: [Thread[main,5,main]]: checkRunning(false) exited<br \
/>
[Server@60072ffb]: Startup sequence initiated from main() method<br />
[Server@60072ffb]: Loaded properties from \
[/Users/tom/repos/training/solr101/Activities/hsqldb/server.properties]<br /> \
[Server@60072ffb]: Initiating startup sequence...<br />
[Server@60072ffb]: Server socket opened successfully in 6 ms.<br />
[Server@60072ffb]: Database [index=0, id=0, db=file:bookfiles, \
alias=bookdb] opened sucessfully in 273 ms.<br /> [Server@60072ffb]: Startup \
sequence completed in 281 ms.<br />
[Server@60072ffb]: 2011-06-30 10:03:13.315 HSQLDB server 2.2.4 is online \
on port 9001<br />
[Server@60072ffb]: To close normally, connect and execute SHUTDOWN SQL<br \
/>
[Server@60072ffb]: From command line, use [Ctrl]+[C] to abort abruptly<br \
/> <br />
When I try to shutdown with<br />
<br />
java -jar hsqldb/lib/sqltool.jar --rcfile=sqltool.rc --sql \
"shutdown;" localhost-sa">localhost-sa<br /> <br />
with sqltool.rc containing:<br />
<br />
# This is for a hsqldb Server running with default settings on your \
local<br />
# computer (and for which you have not changed the password for \
"SA").<br /> urlid localhost-sa">localhost-sa<br />
url jdbc:hsqldb:hsql://localhost/bookdb<br />
username SA<br />
password<br />
<br />
Then sqltool prints: "Disconnected from JDBC Data Source" It \
prints the same, whether the server exits, or not.<br /> <br />
The server process prints "[Server@60072ffb]: Initiating shutdown \
sequence...", but doesn't exit.<br /> <br />
It will exit the first time I open a database, but not the second time. \
(If I delete bookfiles.* before starting, it will exit when shutdown. If the files \
exist, it won't).<br /> <br />
Any suggestions?<br />
<br />
Thanks,<br />
<br />
Tom<br />
</div>
</div>
<pre>
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
<a href="http://p.sf.net/sfu/splunk-d2d-c2" \
target="_blank">http://p.sf.net/sfu/splunk-d2d-c2</a> </pre>
<pre>
_______________________________________________
Hsqldb-user mailing list
<a href="mailto:Hsqldb-user@lists.sourceforge.net" \
target="_blank">Hsqldb-user@lists">Hsqldb-user@lists.sourceforge.net</a> <a \
href="https://lists.sourceforge.net/lists/listinfo/hsqldb-user" \
target="_blank">https://lists.sourceforge.net/lists/listinfo/hsqldb-user">hsqldb-user</a>
</pre>
</blockquote>
</div>
</div>
<div>
</div>
</div>
</div>
<br />
------------------------------------------------------------------------------<br \
/>
All of the data generated in your IT infrastructure is seriously valuable.<br />
Why? It contains a definitive record of application performance, security<br />
threats, fraudulent activity, and more. Splunk takes this data and makes<br />
sense of it. IT sense. And common sense.<br />
<a href="http://p.sf.net/sfu/splunk-d2d-c2" \
target="_blank">http://p.sf.net/sfu/splunk-d2d-c2</a><br /> \
_______________________________________________<br /> Hsqldb-user mailing list<br />
<a href="mailto:Hsqldb-user@lists.sourceforge.net">Hsqldb-user@lists">Hsqldb-user@lists.sourceforge.net</a><br \
/> <a href="https://lists.sourceforge.net/lists/listinfo/hsqldb-user" \
target="_blank">https://lists.sourceforge.net/lists/listinfo/hsqldb-user">hsqldb-user</a><br \
/> </blockquote>
</div>
<br style="font-family: courier new,monospace;" />
<pre>
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
</pre>
<pre>
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists">Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user">hsqldb-user
</pre>
</blockquote>
</div>
</div>
<div>
</div>
</div></body></html>
--_----------=_1309465305143190--
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic