Re: [Resin-interest] Something interesting for People using Resin with Oracle
Alan, No, I assumed that a URL versus a file declaration would be the same. I will use the URL version instead and try it. Also interesting idea as regards JDBC driver swap out. We are using ojdbc6.jar for an 11g R1 database. What combination are you using? Thanks, Aaron -Original Message- From: resin-interest-boun...@caucho.com [mailto:resin-interest- boun...@caucho.com] On Behalf Of Alan Wright Sent: Saturday, October 01, 2011 4:32 AM To: General Discussion for the Resin application server Subject: Re: [Resin-interest] Something interesting for People using Resin with Oracle Have you typed jvm-arg exactly as it is in your resin.xml? I think it is important that it should be file:///dev/urandom I was frequently getting the long delays on startup like yourself. Also you could try an older jdbc driver version to see if the problem goes away either as a solution, or just to more clearly isolate the problem. Regards Alan On 30/09/2011 19:49, Aaron Freeman wrote: We are currently experiencing a problem when we restart where the ConnectionPools to Oracle take a long time to be established and cause a long delay for our production machine to start. It almost feels like the old ConnectionPools have to timeout, even though we have shut the entire Resin instance down and restarted the entire JVM. When I saw your post below I got excited because it's very similar to the issue we are having, but we don't have the SQLRecoverableException anywhere that I am seeing. Also it's not really undeterministic -- it always happens. How long the connections to Oracle take are sort of random, but it's way too long. When I went into /resin-admin/ I see that this is implicitly being set: jvm-arg-Djava.security.egd=/dev/urandom/jvm-arg So adding your argument won't help us. Any other ideas on what could cause resin-4.0.18 to take so darn long to fire up as regards connection to Oracle 11g? Thanks, -a -- Alan Wright Athene Systems tel 0845 230 9803 Athene Systems Limited Registered Office: Shieling House Invincible Road Farnborough GU14 7QU Registered in England and Wales No. 3156080 ___ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest ___ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest
Re: [Resin-interest] Something interesting for People using Resin with Oracle
Have you typed jvm-arg exactly as it is in your resin.xml? I think it is important that it should be file:///dev/urandom I was frequently getting the long delays on startup like yourself. Also you could try an older jdbc driver version to see if the problem goes away either as a solution, or just to more clearly isolate the problem. Regards Alan On 30/09/2011 19:49, Aaron Freeman wrote: We are currently experiencing a problem when we restart where the ConnectionPools to Oracle take a long time to be established and cause a long delay for our production machine to start. It almost feels like the old ConnectionPools have to timeout, even though we have shut the entire Resin instance down and restarted the entire JVM. When I saw your post below I got excited because it's very similar to the issue we are having, but we don't have the SQLRecoverableException anywhere that I am seeing. Also it's not really undeterministic -- it always happens. How long the connections to Oracle take are sort of random, but it's way too long. When I went into /resin-admin/ I see that this is implicitly being set: jvm-arg-Djava.security.egd=/dev/urandom/jvm-arg So adding your argument won't help us. Any other ideas on what could cause resin-4.0.18 to take so darn long to fire up as regards connection to Oracle 11g? Thanks, -a -- Alan Wright Athene Systems tel 0845 230 9803 Athene Systems Limited Registered Office: Shieling House Invincible Road Farnborough GU14 7QU Registered in England and Wales No. 3156080 ___ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest
Re: [Resin-interest] Something interesting for People using Resin with Oracle
We are currently experiencing a problem when we restart where the ConnectionPools to Oracle take a long time to be established and cause a long delay for our production machine to start. It almost feels like the old ConnectionPools have to timeout, even though we have shut the entire Resin instance down and restarted the entire JVM. When I saw your post below I got excited because it's very similar to the issue we are having, but we don't have the SQLRecoverableException anywhere that I am seeing. Also it's not really undeterministic -- it always happens. How long the connections to Oracle take are sort of random, but it's way too long. When I went into /resin-admin/ I see that this is implicitly being set: jvm-arg-Djava.security.egd=/dev/urandom/jvm-arg So adding your argument won't help us. Any other ideas on what could cause resin-4.0.18 to take so darn long to fire up as regards connection to Oracle 11g? Thanks, -a -Original Message- From: resin-interest-boun...@caucho.com [mailto:resin-interest- boun...@caucho.com] On Behalf Of Daniel López Sent: Wednesday, September 28, 2011 10:13 AM To: General Discussion for the Resin application server Subject: Re: [Resin-interest] Something interesting for People using Resin with Oracle Good to know Alan, thanks. Who would have thought servers accessing databases might be located in dedicated machines? Way to go, Oracle! :D S! D. El 28/09/2011 16:19, Alan Wright escribió: At the same time as upgrading to Resin 4 we are upgrading to Oracle 11gR2. Starting/stopping resin was very non-deterministic seeming to hang sometimes during application startup with references to connection timeouts in the error logs. SQLRecoverableException: IO Error: Connection reset The problem was traced to a drying up of the entropy poll preventing oracle jdbc from allocating connections until the pool was replenished The following article explains in full http://www.usn-it.de/index.php/2009/02/20/oracle-11g-jdbc-driver-hangs -blocked-by-devrandom-entropy-pool-empty The solution was to add the following to resin.xml !-- Deal with problems associated with 11G JDBC driver new connection requires random number but generator uses entropy pool filled by random user actions - server has no connected user so entropy pool often empty -- jvm-arg-Djava.security.egd=file:///dev/urandom/jvm-arg Hope this helps someone. Alan -- --- Daniel Lopez Janariz (d.lo...@uib.es) Web Services Centre for Information and Technology Balearic Islands University (SPAIN) --- ___ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest ___ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest
[Resin-interest] Something interesting for People using Resin with Oracle
At the same time as upgrading to Resin 4 we are upgrading to Oracle 11gR2. Starting/stopping resin was very non-deterministic seeming to hang sometimes during application startup with references to connection timeouts in the error logs. SQLRecoverableException: IO Error: Connection reset The problem was traced to a drying up of the entropy poll preventing oracle jdbc from allocating connections until the pool was replenished The following article explains in full http://www.usn-it.de/index.php/2009/02/20/oracle-11g-jdbc-driver-hangs-blocked-by-devrandom-entropy-pool-empty The solution was to add the following to resin.xml Hope this helps someone. Alan -- Alan Wright Athene Systems tel 0845 230 9803 Athene Systems Limited Registered Office: Shieling House Invincible Road Farnborough GU14 7QU Registered in England and Wales No. 3156080 ___ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest
Re: [Resin-interest] Something interesting for People using Resin with Oracle
On Wed, Sep 28, 2011 at 10:13, Alan Wright alan.wri...@athenesystems.com wrote: The solution was to add the following to resin.xml Add the following what? FC ___ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest
[Resin-interest] Something interesting for People using Resin with Oracle
At the same time as upgrading to Resin 4 we are upgrading to Oracle 11gR2. Starting/stopping resin was very non-deterministic seeming to hang sometimes during application startup with references to connection timeouts in the error logs. SQLRecoverableException: IO Error: Connection reset The problem was traced to a drying up of the entropy poll preventing oracle jdbc from allocating connections until the pool was replenished The following article explains in full http://www.usn-it.de/index.php/2009/02/20/oracle-11g-jdbc-driver-hangs-blocked-by-devrandom-entropy-pool-empty The solution was to add the following to resin.xml !-- Deal with problems associated with 11G JDBC driver new connection requires random number but generator uses entropy pool filled by random user actions - server has no connected user so entropy pool often empty -- jvm-arg-Djava.security.egd=file:///dev/urandom/jvm-arg Hope this helps someone. Alan -- Alan Wright Athene Systems tel 0845 230 9803 Athene Systems Limited Registered Office: Shieling House Invincible Road Farnborough GU14 7QU Registered in England and Wales No. 3156080 ___ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest
Re: [Resin-interest] Something interesting for People using Resin with Oracle
Good to know Alan, thanks. Who would have thought servers accessing databases might be located in dedicated machines? Way to go, Oracle! :D S! D. El 28/09/2011 16:19, Alan Wright escribió: At the same time as upgrading to Resin 4 we are upgrading to Oracle 11gR2. Starting/stopping resin was very non-deterministic seeming to hang sometimes during application startup with references to connection timeouts in the error logs. SQLRecoverableException: IO Error: Connection reset The problem was traced to a drying up of the entropy poll preventing oracle jdbc from allocating connections until the pool was replenished The following article explains in full http://www.usn-it.de/index.php/2009/02/20/oracle-11g-jdbc-driver-hangs-blocked-by-devrandom-entropy-pool-empty The solution was to add the following to resin.xml !-- Deal with problems associated with 11G JDBC driver new connection requires random number but generator uses entropy pool filled by random user actions - server has no connected user so entropy pool often empty -- jvm-arg-Djava.security.egd=file:///dev/urandom/jvm-arg Hope this helps someone. Alan -- --- Daniel Lopez Janariz (d.lo...@uib.es) Web Services Centre for Information and Technology Balearic Islands University (SPAIN) --- ___ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest