Marc Ravensbergen wrote:
I use
conn.createStatement().executeQuery("SHUTDOWN");
to shutdown the server. The sever was only serving 1 database, but to
multiple clients; some clients were on a different machine, but one
client is also on the same physical machine as the server, and both
client and server in this case are started in the same JVM session; the
client in this case also talks to the server exactly as it would if it
was on a different machine, ie. it uses the following url:
jdbc:hsqldb:hsql://corncob/database1
hope this helps,
Marc
fredt wrote:
How did you shutdown the server? How many databases was it serving?
Fred
----- Original Message -----
From: "Marc Ravensbergen" <marcusraven@xxxxxxxxx>
To: "HSQLdb user discussions" <hsqldb-user@xxxxxxxxxxxxxxxxxxxxx>
Sent: 08 June 2007 14:22
Subject: Re: [Hsqldb-user] Deadlock (kind of) at Server shutdown
I can second this; in fact, I have noticed it in previous versions as
well (1.8.0.5 I believe). This is a _serious_ problem, are there any
work arounds?
Marc
Francois Valdy wrote:
Deadlock can occur at server shutdown (with remote SHUTDOWN command)
with 1.8.0.7, see locked stack traces below.
I don't believe you'll need more details (cause I easily found this
race condition reason in Server code), but if you do, feel free to
ask.
The server doesn't answer the shutdown command, keeps connection open,
and doesn't exit.
This is quite serious as it prevents the client application from shuting
down.
Thanks in advance.
Francois.
"HSQLDB Server @1df8b99" prio=6 tid=0x4918a058 nid=0x1330 waiting on
condition [0x4957f000..0x4957fc68]
at java.lang.Thread.sleep(Native Method)
at org.hsqldb.Server.shutdown(Unknown Source)
- locked <0x07a04560> (a org.hsqldb.Server)
at org.hsqldb.Server.run(Unknown Source)
at org.hsqldb.Server.access$000(Unknown Source)
at org.hsqldb.Server$ServerThread.run(Unknown Source)
"HSQLDB Connection @9b8ff9" prio=6 tid=0x4918e3f0 nid=0x318 waiting
for monitor entry [0x4a61f000..0x4a61fbe8]
at org.hsqldb.Server.print(Unknown Source)
- waiting to lock <0x07a04560> (a org.hsqldb.Server)
at org.hsqldb.Server.printWithThread(Unknown Source)
at org.hsqldb.Server.releaseServerSocket(Unknown Source)
at org.hsqldb.Server.stop(Unknown Source)
at org.hsqldb.Server.notify(Unknown Source)
at org.hsqldb.DatabaseManager.notifyServers(Unknown Source)
at org.hsqldb.DatabaseManager.removeDatabase(Unknown Source)
at org.hsqldb.Database.close(Unknown Source)
at org.hsqldb.DatabaseCommandInterpreter.processShutdown(Unknown Source)
at org.hsqldb.DatabaseCommandInterpreter.executePart(Unknown Source)
at org.hsqldb.DatabaseCommandInterpreter.execute(Unknown Source)
at org.hsqldb.Session.sqlExecuteDirectNoPreChecks(Unknown Source)
- locked <0x07a0f9b8> (a org.hsqldb.Database)
at org.hsqldb.Session.execute(Unknown Source)
- locked <0x07a0f9b8> (a org.hsqldb.Database)
at org.hsqldb.ServerConnection.run(Unknown Source)
at java.lang.Thread.run(Thread.java:595)
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
|
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
| 
