|
»
»
»
Deadlock (kind of) at Server shutdown
|
View:
New views
20 Messages
—
Rating Filter:
Alert me
|
| < Prev | 1 - 2 | Next > |
 |
Deadlock (kind of) at Server shutdown
by Francois Valdy
::
Rate this Message:
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@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
|
|
Using Ant to load hsqldb schema.
by Stephen Ince
::
Rate this Message:
For some reason I can't get Ant to load my schema in hsqldb 1.8.07. This
worked fine in 1.7.2. Does anyone have any insight to what may be problem? I thought I might have to set autocommit to true. Ant reports that all statements were executed successfully but there are tables missing. Do I need to set some flag some place? Ant version: 1.5.7 Hsql: 1.8.07 Ant task. <sql classpathref="classpath" driver="${openload.database.driver}" url="${openload.database.url}" userid="${openload.database.username}" password="${openload.database.password}" autocommit="true" src="${openload.database.sqlScript}" onerror="continue"/> openload.database.url =jdbc:hsqldb:file:${openload.home}/modules/hsqldb/ods openload.database.driver = org.hsqldb.jdbcDriver Steve ------------------------------------------------------------------------- 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@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
|
|
Re: Using Ant to load hsqldb schema.
by Stephen Ince
::
Rate this Message:
I needed "shutdown" in my script. I found it by looking through old mail
postings. Steve ----- Original Message ----- From: "Stephen Ince" <since@...> To: "HSQLdb user discussions" <hsqldb-user@...> Sent: Thursday, April 26, 2007 1:59 PM Subject: [Hsqldb-user] Using Ant to load hsqldb schema. > For some reason I can't get Ant to load my schema in hsqldb 1.8.07. This > worked fine in 1.7.2. Does anyone have any insight to what may be problem? > I > thought I might have to set autocommit to true. Ant reports that all > statements were executed successfully but there are tables missing. Do I > need to set some flag some place? > > Ant version: 1.5.7 > Hsql: 1.8.07 > > Ant task. > <sql > classpathref="classpath" > driver="${openload.database.driver}" > url="${openload.database.url}" > userid="${openload.database.username}" > password="${openload.database.password}" > autocommit="true" > src="${openload.database.sqlScript}" > onerror="continue"/> > > openload.database.url > =jdbc:hsqldb:file:${openload.home}/modules/hsqldb/ods > openload.database.driver = org.hsqldb.jdbcDriver > > Steve > > > ------------------------------------------------------------------------- > 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@... > 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@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
|
|
Re: Deadlock (kind of) at Server shutdown
by Marc Ravensbergen
::
Rate this Message:
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@... > 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@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
|
|
Re: Deadlock (kind of) at Server shutdown
by fredt
::
Rate this Message:
How did you shutdown the server? How many databases was it serving?
Fred ----- Original Message ----- From: "Marc Ravensbergen" <marcusraven@...> To: "HSQLdb user discussions" <hsqldb-user@...> 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@... > 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@... 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@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
|
|
|
|
|
Re: Deadlock (kind of) at Server shutdown
by Francois Valdy
::
Rate this Message:
I don't have the source code available right now, but from what I
remember (apologies if it's not accurate), it was due to an extraneous locking done during call to print. I also noticed that it was fixed in 1.9 branch, but not backported to 1.8. Francois. On 6/8/07, Marc Ravensbergen <marcusraven@...> wrote: > 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@...> To: "HSQLdb user discussions" > <hsqldb-user@...> 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@... 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@... 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@... 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@... > 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@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
|
|
Re: Deadlock (kind of) at Server shutdown
by Marc Ravensbergen
::
Rate this Message:
Is there a quick patch that I could apply to my version (1.8.0.7) that would
give me the update found in the 1.9 branch for this problem? I am getting kind of desperate here as I seem to be getting a 40% chance of hanging my application at database shutdown. Marc On Saturday 09 June 2007 6:04:45 am Francois Valdy wrote: > I don't have the source code available right now, but from what I > remember (apologies if it's not accurate), it was due to an extraneous > locking done during call to print. > I also noticed that it was fixed in 1.9 branch, but not backported to 1.8. > > Francois. > > On 6/8/07, Marc Ravensbergen <marcusraven@...> wrote: > > 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@...> > > To: "HSQLdb user discussions" > > > <hsqldb-user@...> > > 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@... > 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@... > 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@... > 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@... > > 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@... > https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
|
|
Re: Deadlock (kind of) at Server shutdown
by fredt
::
Rate this Message:
Please check out the HEAD of cvs hsqldb-dev and report if there is still any
problem. This code will be released as 1.8.0.8 Fred ----- Original Message ----- From: "Marc Ravensbergen" <marcusraven@...> To: "HSQLdb user discussions" <hsqldb-user@...> Sent: 22 August 2007 16:58 Subject: Re: [Hsqldb-user] Deadlock (kind of) at Server shutdown Is there a quick patch that I could apply to my version (1.8.0.7) that would give me the update found in the 1.9 branch for this problem? I am getting kind of desperate here as I seem to be getting a 40% chance of hanging my application at database shutdown. Marc On Saturday 09 June 2007 6:04:45 am Francois Valdy wrote: > I don't have the source code available right now, but from what I > remember (apologies if it's not accurate), it was due to an extraneous > locking done during call to print. > I also noticed that it was fixed in 1.9 branch, but not backported to 1.8. > > Francois. > > On 6/8/07, Marc Ravensbergen <marcusraven@...> wrote: > > 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@...> > > To: "HSQLdb user discussions" > > > <hsqldb-user@...> > > 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@... > 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@... > 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@... > 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@... > > 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@... > https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
|
|
Re: Deadlock (kind of) at Server shutdown
by Marc Ravensbergen
::
Rate this Message:
I checked out the cvs version, but it doesn't compile.
I am not very familiar with cvs, maybe I did it wrong... cvs -d:pserver:anonymous@...:/cvsroot/hsqldb login (pressed enter) cvs -z3 -d:pserver:anonymous@...:/cvsroot/hsqldb co -P hsqldb-dev I then tried to build by entering the build directory, and trying both ant jar ant hsqldb but both failed on the same errors... mr98ai@corncob:~/Desktop/hsqldb-dev/build$ ant hsqldb Buildfile: build.xml init: -javaversion4: javaversion2: -prepare: codeswitcher: switch1: switch2: switches: switchtojdk11: switchtojdk12: switchtojdk14: [java] .......... store: lib: [javac] Compiling 1 source file to /home/mr98ai/Desktop/hsqldb-dev/classes -javajsse: [echo] ant.java.hasjsse=true classes: [javac] Compiling 120 source files to /home/mr98ai/Desktop/hsqldb-dev/classes [javac] /home/mr98ai/Desktop/hsqldb-dev/src/org/hsqldb/jdbc/jdbcStatement.java:127: org.hsqldb.jdbc.jdbcStatement is not abstract and does not override abstract method isPoolable() in java.sql.Statement [javac] public class jdbcStatement implements Statement { [javac] ^ [javac] /home/mr98ai/Desktop/hsqldb-dev/src/org/hsqldb/jdbc/jdbcStatement.java:1535: isClosed() in org.hsqldb.jdbc.jdbcStatement cannot implement isClosed() in java.sql.Statement; attempting to assign weaker access privileges; was public [javac] synchronized boolean isClosed() { [javac] ^ [javac] /home/mr98ai/Desktop/hsqldb-dev/src/org/hsqldb/jdbc/jdbcPreparedStatement.java:203: org.hsqldb.jdbc.jdbcPreparedStatement is not abstract and does not override abstract method setNClob(int,java.io.Reader) in java.sql.PreparedStatement [javac] public class jdbcPreparedStatement extends jdbcStatement [javac] ^ [javac] /home/mr98ai/Desktop/hsqldb-dev/src/org/hsqldb/jdbc/jdbcCallableStatement.java:295: org.hsqldb.jdbc.jdbcCallableStatement is not abstract and does not override abstract method setNClob(java.lang.String,java.io.Reader) in java.sql.CallableStatement [javac] public class jdbcCallableStatement extends jdbcPreparedStatement [javac] ^ [javac] /home/mr98ai/Desktop/hsqldb-dev/src/org/hsqldb/jdbc/jdbcConnection.java:403: org.hsqldb.jdbc.jdbcConnection is not abstract and does not override abstract method createStruct(java.lang.String,java.lang.Object[]) in java.sql.Connection [javac] public class jdbcConnection implements Connection { [javac] ^ [javac] /home/mr98ai/Desktop/hsqldb-dev/src/org/hsqldb/jdbc/jdbcResultSetMetaData.java:94: org.hsqldb.jdbc.jdbcResultSetMetaData is not abstract and does not override abstract method isWrapperFor(java.lang.Class<?>) in java.sql.Wrapper [javac] public class jdbcResultSetMetaData implements ResultSetMetaData { [javac] ^ [javac] /home/mr98ai/Desktop/hsqldb-dev/src/org/hsqldb/jdbc/jdbcResultSet.java:325: org.hsqldb.jdbc.jdbcResultSet is not abstract and does not override abstract method updateNClob(java.lang.String,java.io.Reader) in java.sql.ResultSet [javac] public class jdbcResultSet implements ResultSet { [javac] ^ [javac] /home/mr98ai/Desktop/hsqldb-dev/src/org/hsqldb/jdbc/jdbcDatabaseMetaData.java:279: org.hsqldb.jdbc.jdbcDatabaseMetaData is not abstract and does not override abstract method getFunctionColumns(java.lang.String,java.lang.String,java.lang.String,java.lang.String) in java.sql.DatabaseMetaData [javac] public class jdbcDatabaseMetaData implements DatabaseMetaData { [javac] ^ [javac] /home/mr98ai/Desktop/hsqldb-dev/src/org/hsqldb/jdbc/jdbcBlob.java:78: org.hsqldb.jdbc.jdbcBlob is not abstract and does not override abstract method getBinaryStream(long,long) in java.sql.Blob [javac] public class jdbcBlob implements Blob { [javac] ^ [javac] /home/mr98ai/Desktop/hsqldb-dev/src/org/hsqldb/jdbc/jdbcClob.java:81: org.hsqldb.jdbc.jdbcClob is not abstract and does not override abstract method getCharacterStream(long,long) in java.sql.Clob [javac] public final class jdbcClob implements Clob { [javac] ^ [javac] /home/mr98ai/Desktop/hsqldb-dev/src/org/hsqldb/jdbc/jdbcParameterMetaData.java:54: org.hsqldb.jdbc.jdbcParameterMetaData is not abstract and does not override abstract method isWrapperFor(java.lang.Class<?>) in java.sql.Wrapper [javac] public class jdbcParameterMetaData implements ParameterMetaData { [javac] ^ [javac] Note: Some input files use unchecked or unsafe operations. [javac] Note: Recompile with -Xlint:unchecked for details. [javac] 11 errors BUILD FAILED /home/mr98ai/Desktop/hsqldb-dev/build/build.xml:286: Compile failed; see the compiler error output for details. Total time: 6 seconds mr98ai@corncob:~/Desktop/hsqldb-dev/build$ Marc On Wednesday 22 August 2007 12:26:25 pm fredt wrote: > Please check out the HEAD of cvs hsqldb-dev and report if there is still > any problem. This code will be released as 1.8.0.8 > > Fred > ----- Original Message ----- > From: "Marc Ravensbergen" <marcusraven@...> > To: "HSQLdb user discussions" <hsqldb-user@...> > Sent: 22 August 2007 16:58 > Subject: Re: [Hsqldb-user] Deadlock (kind of) at Server shutdown > > > Is there a quick patch that I could apply to my version (1.8.0.7) that > would give me the update found in the 1.9 branch for this problem? I am > getting kind of desperate here as I seem to be getting a 40% chance of > hanging my application at database shutdown. > > Marc > > On Saturday 09 June 2007 6:04:45 am Francois Valdy wrote: > > I don't have the source code available right now, but from what I > > remember (apologies if it's not accurate), it was due to an extraneous > > locking done during call to print. > > I also noticed that it was fixed in 1.9 branch, but not backported to > > 1.8. > > > > Francois. > > > > On 6/8/07, Marc Ravensbergen <marcusraven@...> wrote: > > > 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@...> > > > > To: "HSQLdb user discussions" > > > > > <hsqldb-user@...> > > > > 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 Met |
