Re: 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/